[OpenSIPS-Users] OpenSIPS installation with PostgresSQL

[Bogdan-Andrei Iancu]

Hi,

Is OpenSIPS compiled by you or installed from packages (if yes, what is 
the repo url)?

Regards,

Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
   https://www.opensips-solutions.com

On 4/19/20 11:50 PM, Nayani Nikeshala via Users wrote:
> Hello,
>
> I'm trying to install opensips-2.4.7 with psql -8.4.20 on a Centos-6 
> platform. I can connect to psql DB as below.
>
> [root at SIPserver ~]# psql -h localhost -U opensips -d opensips
> psql (8.4.20)
> Type "help" for help.
>
> opensips=>
>
> When I try to start OpenSIP as below, it gives me the following error.
>
> [root at SIPserver ~]# opensipsctl start
>
> INFO: Starting OpenSIPS :
>
> ERROR: PID file /var/run/opensips.pid does not exist -- OpenSIPS start 
> failed
> [root at SIPserver ~]#
>
>
> /var/log/opensips.log shows the below error.
>
> Apr 20 01:31:20 SIPserver opensips: ERROR:core:sr_load_module: could 
> not open module </usr/local//lib/opensips/modules/db_postgres.so>: 
> /usr/local//lib/opensips/modules/db_postgres.so: undefined symbol: 
> PQconnectdbParams
> Apr 20 01:31:20 SIPserver opensips: ERROR:core:load_module: failed to 
> load module
> Apr 20 01:31:20 SIPserver opensips: CRITICAL:core:yyerror: parse error 
> in config file /usr/local//etc/opensips/opensips.cfg, line 89, column 
> 13-14: failed to load module db_postgres.so#012
>
> I noted that PQconnectdbParams is available from psql-9 onwards and 
> could not figure out, what does this error mean.
>
> Could someone assist me please.
>
> Thanks!
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200420/85097967/attachment-0001.html>