[OpenSIPS-Users] OpenSIPS installation with PostgresSQL

[Nayani Nikeshala]

 Hi Bogdan,

I have attached the output log for the above commands. 
"make modules module=modules/db_postgres" gave me an error as in the attached file, so I used "make include_modules=db_postgres modules" instead. I could see below in the output. 

make[1]: Entering directory `/home/cscore/Downloads/opensips-2.4.7/modules/db_postgres'make[1]: Leaving directory `/home/cscore/Downloads/opensips-2.4.7/modules/db_postgres'make[1]: Entering directory `/home/cscore/Downloads/opensips-2.4.7/modules/db_postgres'Compiling dbase.cCompiling db_postgres.cCompiling pg_con.cCompiling res.cCompiling val.cpg_con.c: In function db_postgres_new_connection:pg_con.c:93: warning: implicit declaration of function PQconnectdbParamspg_con.c:93: warning: assignment makes pointer from integer without a castLinking db_postgres.somake[1]: Leaving directory `/home/cscore/Downloads/opensips-2.4.7/modules/db_postgres'
Is this a problem of my psql version(8.4.20), because PQconnectdbParams  is not available in that version. 
    On Tuesday, April 21, 2020, 02:32:39 PM GMT+5:30, Bogdan-Andrei Iancu <bogdan at opensips.org> wrote:  
 
  Hi,
 
 and I assume you also locally compiled the postgres module, right ?
 
 If you do in the directory with the opensips sources:
 
 (cd modules/db_postgres ; make proper) ; make modules module=modules/db_postgres
 
 could you post the output here ?
 
 Regards,
  Bogdan-Andrei Iancu

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

 On 4/20/20 7:24 PM, Nayani Nikeshala wrote:
  
 
 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/20200421/eb5227cc/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: output-log.7z
Type: application/octet-stream
Size: 6572 bytes
Desc: not available
URL: <http://lists.opensips.org/pipermail/users/attachments/20200421/eb5227cc/attachment-0001.obj>