Re: [OpenSIPS-Users] Configuring OpenSIPS with Postgresql

2011-12-07 Thread Bogdan-Andrei Iancu
Andrei Iancu [mailto:bog...@opensips.org] *Sent:* Tuesday, December 06, 2011 9:34 AM *To:* OpenSIPS users mailling list *Cc:* Jerry Richards *Subject:* Re: [OpenSIPS-Users] Configuring OpenSIPS with Postgresql Hello Jerry, If you want to use postgres with opensips, you need to change all the db_

Re: [OpenSIPS-Users] Configuring OpenSIPS with Postgresql

2011-12-06 Thread Jerry Richards
. Thanks, Jerry From: users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] On Behalf Of Jerry Richards Sent: Tuesday, December 06, 2011 11:42 AM To: Bogdan-Andrei Iancu; OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] Configuring OpenSIPS with Postgresql Thanks,

Re: [OpenSIPS-Users] Configuring OpenSIPS with Postgresql

2011-12-06 Thread Jerry Richards
"usrloc", "db_url", "pgsql://opensips:opensipsrw@localhost/opensips") Thanks, Jerry From: Bogdan-Andrei Iancu [mailto:bog...@opensips.org] Sent: Tuesday, December 06, 2011 9:34 AM To: OpenSIPS users mailling list Cc: Jerry Richards Subject: Re: [OpenSIPS-Users] Con

Re: [OpenSIPS-Users] Configuring OpenSIPS with Postgresql

2011-12-06 Thread Bogdan-Andrei Iancu
Hello Jerry, If you want to use postgres with opensips, you need to change all the db_url parameters in opensips config file; what db backend to be used, is defined via the prefix of the url: modparam("usrloc", "db_url", "mysql://opensips:opensipsrw@localhost/opensips") versus: modpa

[OpenSIPS-Users] Configuring OpenSIPS with Postgresql

2011-12-01 Thread Jerry Richards
Hello, My opensips is not starting. I noticed the /var/log/messages file indicates it needs a database. I want to use postgresql instead of mysql, so I changed the DBENGINE parameter to PGSQL in the opensipsctlrc and osipsconsolerc. Now, when I execute "./opensipsdbctl create", I get the fol