[SR-Users] R: R: siremis with postgres

[Daniel-Constantin Mierla]

Hello,

the driver in the Config.xml is for mysql not for postgress. You have to
change to the appropriate pdo_xyz corresponding to postgres.

Cheers,
Daniel

On 18/06/15 13:46, Tomas Zanet wrote:
> Hi all, do you have any feedbacks about that?
> Is it a my misconfiguration or a Siremis bug?
>
> Thanks.
> T.
>
>
>
> Tomas Zanet
> Software Design Department
> tzanet at came.com
> CAME S.p.A.
>
> -----Messaggio originale-----
> Da: sr-users [mailto:sr-users-bounces at lists.sip-router.org] Per conto di Tomas Zanet
> Inviato: mercoledì 10 giugno 2015 17:04
> A: miconda at gmail.com; Kamailio (SER) - Users Mailing List
> Oggetto: [SR-Users] R: siremis with postgres
>
> Here it is:
>
> <?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_Mysql" Server="localhost" Port="3306" DBName="kamailio" User="kamailio" Password="kamailiorw" Charset="utf8"/>
>    </DataSource>
> </Config>
>
>
> Thanks,
> T.
>
>
>
> Tomas Zanet
> Software Design Department
> tzanet at came.com
> CAME S.p.A.
>
> -----Messaggio originale-----
> Da: sr-users [mailto:sr-users-bounces at lists.sip-router.org] Per conto di Daniel-Constantin Mierla
> Inviato: mercoledì 10 giugno 2015 16:59
> A: Kamailio (SER) - Users Mailing List
> Oggetto: Re: [SR-Users] siremis with postgres
>
> Hello,
>
> can you look into Config.xml located inside siremis subfolder and see the values for database username and password?
>
> Cheers,
> Daniel
>
> On 10/06/15 14:59, Tomas Zanet wrote:
>> Hi all,
>> I need to install Kamailio, and Siremis as well, with Postgres backend. My current versions are the following:
>> - Kamailio 4.2.1
>> - Siremis 4.2.0
>> - PHP 5.3.10-1ubuntu3.18
>> - postgres 9.1.3
>>
>> To do so, I installed libpq-dev and compiled Kamailio with db_postgres
>> module.  After that, I create the Kamailio database using kamdbctl
>> create
>>
>> No problems so far....while I’m facing some problem when I tried to install Siremis with Postgres. To do so, I installed php5-pgsql before and then I did the steps described here:
>> http://kb.asipto.com/siremis:install42x:main#dokuwiki__top
>>
>> After clicking on “Setup Now” and “Next” buttons, I’m facing with the following problem:
>> ERROR: SQLSTATE[08006] [7] FATAL: password authentication failed for user "www-data" FATAL: password authentication failed for user "www-data"
>>
>> Though the username I specified into web page is not www-data, but siremis. As far as I know www-data is a Debian user name under which Apache/PHP is running.
>>
>> Can anyone help me please?
>>
>> Thanks in advance
>> Best Regards,
>>
>> Tomas
>>
>>
>>
>>
>>
>> Tomas Zanet
>> Software Design Department
>> tzanet at came.com
>> CAME S.p.A.
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
>> list sr-users at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
> --
> Daniel-Constantin Mierla
> http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
> Book: SIP Routing With Kamailio - http://www.asipto.com
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users at lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users at lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Book: SIP Routing With Kamailio - http://www.asipto.com