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