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:[email protected]]
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
[email protected]<mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
--
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
OpenSIPS solutions and "know-how"
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
