[OpenSIPS-Users] OpenSIPS installation with PostgresSQL

[Nayani Nikeshala]

 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 opensipspsql (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: PQconnectdbParamsApr 20 01:31:20 SIPserver opensips: ERROR:core:load_module: failed to load moduleApr 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!  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200419/88d5bad2/attachment.html>