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