13 Apr
2011
13 Apr
'11
3:41 p.m.
Hello,
I've setup a siremis installation using mysql for siremis tables. Now having kamailio
with postgresql on another machine, I've chosen Postgresql in seremis setup under SIP
DB and correctly inserted the right username/password/host. Connection was successfully.
The problem rises when you try to query something owned by kamailio-db: the query builded
from seremis is not written for a postgresql database but is still written to be used in a
mysql database. Here an example:
An exception occurred while executing this script:
Error message: #0, Error in query:: SELECT T0.id, T0.username, T0.domain, T0.password,
T0.email_address, T0.ha1, T0.ha1b, T0.rpid FROM `subscriber` T0 LIMIT 10. SQLSTATE[42601]:
Syntax error: 7 ERROR: syntax error at or near "`" at character 101
Script name and line number of error:
/var/www/siremis-2.0.0/openbiz/bin/data/BizDataObj_Lite.php:447
Obviously, nothing works. The only things working are all those operation using mysql as
db.
Have I setup wrong my installation or is it not possible to use two different databases?
Thanks a lot,
Giorgio Maria Santini
14 Apr
14 Apr
12:15 p.m.
Hello,
On 4/13/11 2:41 PM, Giorgio Maria Santini wrote:
Hello,
I've setup a siremis installation using mysql for siremis tables. Now
having kamailio with postgresql on another machine, I've chosen
Postgresql in seremis setup under SIP DB and correctly inserted the
right username/password/host. Connection was successfully.
The problem rises when you try to query something owned by kamailio-db: the query builded
from seremis is not written for a postgresql database but is still written to be used in a
mysql database. Here an example:
An exception occurred while executing this script:
Error message: #0, Error in query:: SELECT T0.id, T0.username, T0.domain, T0.password,
T0.email_address, T0.ha1, T0.ha1b, T0.rpid FROM `subscriber` T0 LIMIT 10. SQLSTATE[42601]:
Syntax error: 7 ERROR: syntax error at or near "`" at character 101
Script name and line number of error:
/var/www/siremis-2.0.0/openbiz/bin/data/BizDataObj_Lite.php:447
Obviously, nothing works. The only things working are all those operation using mysql as
db.
Have I setup wrong my installation or is it not possible to use two different databases?
what is the content of siremis/Config.xml?
Cheers,
Daniel
--
Daniel-Constantin Mierla
http://www.asipto.com
2:40 p.m.
New subject: Siremis with mysql and Kamailio with postgresql: wrong sqls
Here is my siremis/Config.xml
<?xml version="1.0" standalone="no"?>
<Config>
<DataSource>
<Database Name="Default" Driver="Pdo_Mysql"
Server="localhost" Port="3306" DBName="siremis"
User="siremis" Password="siremisrw" Charset="utf8"/>
<Database Name="Serdb" Driver="Pdo_Pgsql"
Server="xxx.xx.xxx.xx" Port="5432" DBName="kamailio"
User="kamailio" Password="yyyyyyy" Charset="utf8"/>
</DataSource>
</Config>
I've tested Siremis using postgresql for both databases (siremis and kamailio), but
install wasn't successfully because Siremis uses mysql-formatted queries to build the
database even using another db.
On Apr 14, 2011, at 11:15 AM, Daniel-Constantin Mierla wrote:
Hello,
On 4/13/11 2:41 PM, Giorgio Maria Santini wrote:
Giorgio Maria Santini
Hello,
I've setup a siremis installation using mysql for siremis tables. Now having kamailio
with postgresql on another machine, I've chosen Postgresql in seremis setup under SIP
DB and correctly inserted the right username/password/host. Connection was successfully.
The problem rises when you try to query something owned by kamailio-db: the query
builded from seremis is not written for a postgresql database but is still written to be
used in a mysql database. Here an example:
An exception occurred while executing this script:
Error message: #0, Error in query:: SELECT T0.id, T0.username, T0.domain, T0.password,
T0.email_address, T0.ha1, T0.ha1b, T0.rpid FROM `subscriber` T0 LIMIT 10. SQLSTATE[42601]:
Syntax error: 7 ERROR: syntax error at or near "`" at character 101
Script name and line number of error:
/var/www/siremis-2.0.0/openbiz/bin/data/BizDataObj_Lite.php:447
Obviously, nothing works. The only things working are all those operation using mysql as
db.
Have I setup wrong my installation or is it not possible to use two different databases?
what is the content of siremis/Config.xml?
Cheers,
Daniel
--
Daniel-Constantin Mierla
http://www.asipto.com
4972
days inactive
4973
days old
2 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
Giorgio Maria Santini