[OpenSIPS-Users] OpenSIPS installation with PostgresSQL

[Nayani Nikeshala]

 Hello,
OpenSIPS was compiled by me and I followed the OpenSIPS Installation Webinar tutorial. 
Thanks!
    On Monday, April 20, 2020, 08:04:10 PM GMT+5:30, Bogdan-Andrei Iancu <bogdan at opensips.org> wrote:  
 
  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/3d068445/attachment.html>