Just to button up this issue, I have it running now. I figured out to use postgres, the module is called db_postgres, but the DBENGINE is called PGSQL. Basically, all of the references in the configs need to be literally "postgres", not "pgsql" or "postgresql".
Thanks, Jerry From: [email protected] [mailto:[email protected]] 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, 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
