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:
>>
>> 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
Giorgio Maria Santini
_______________________________________________
sr-dev mailing list
[email protected]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
