[SR-Users] R: siremis with postgres

[Tomas Zanet]

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