[OpenSIPS-Users] Configuring OpenSIPS with Postgresql

[Bogdan-Andrei Iancu]

Hi Jerry,

If I said "postgres://.....", then that's the way it should be, right ?

Regards,
Bogdan

On 12/06/2011 09:41 PM, Jerry Richards wrote:
>
> Thanks, Bogdan.  Which of these should it be?
>
>     modparam("usrloc", "db_url",  
> "postgres://opensips:opensipsrw@localhost/opensips")
>     modparam("usrloc", "db_url",  
> "postgresql://opensips:opensipsrw@localhost/opensips")
>     modparam("usrloc", "db_url",  
> "pgsql://opensips:opensipsrw@localhost/opensips")
>
> Thanks,
>
> Jerry
>
> *From:*Bogdan-Andrei Iancu [mailto:bogdan at 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_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:
>     modparam("usrloc", "db_url",  
> "postgres://opensips:opensipsrw@localhost/opensips")
>
> Regards,
> Bogdan
>
> On 12/01/2011 09:51 PM, Jerry Richards wrote:
>
> 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 following error:
>
> ERROR: could not load the script in 
> /opt/opensips/lib64/opensips/opensipsctl/opensipsdbctl.pgsql for 
> database engine PGSQL
>
> ERROR: database engine not loaded - tried 'PGSQL'
>
> I noticed the opensipsdbctl.pgsql file does not exist at all.  I 
> suspect there is a build step to specify postgresql?
>
> Thanks,
>
> Jerry
>
>   
>   
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org  <mailto:Users at lists.opensips.org>
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
>
> -- 
> Bogdan-Andrei Iancu
> OpenSIPS Founder and Developer
> OpenSIPS solutions and "know-how"


-- 
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
OpenSIPS solutions and "know-how"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20111207/897e84df/attachment-0001.htm>