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@came.com CAME S.p.A.

-----Messaggio originale----- Da: sr-users [mailto:sr-users-bounces@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@came.com CAME S.p.A.

---

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

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@came.com CAME S.p.A.

-----Messaggio originale----- Da: sr-users [mailto:sr-users-bounces@lists.sip-router.org] Per conto di Tomas Zanet Inviato: mercoledì 10 giugno 2015 17:04 A: miconda@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@came.com CAME S.p.A.

-----Messaggio originale----- Da: sr-users [mailto:sr-users-bounces@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@came.com CAME S.p.A.

---

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@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@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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users