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@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


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

_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to