[OpenSIPS-Users] OpenSIPS installation with PostgresSQL

[Nayani Nikeshala]

 Hi Bogdan,
I added the path of libpq-fe.h to the Makefile. 
[root at SIPserver include]# ls -lrt /usr/pgsql-9.6/include/libpq-fe.h-rw-r--r--. 1 root root 21900 Feb 12 02:52 /usr/pgsql-9.6/include/libpq-fe.h


    On Friday, April 24, 2020, 01:51:35 PM GMT+5:30, Bogdan-Andrei Iancu <bogdan at opensips.org> wrote:  
 
  Hi Nayani,
 
 What was the fix you did ? the path to the postgres lib? 
 
 Regards,
  Bogdan-Andrei Iancu

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

 On 4/23/20 10:18 PM, Nayani Nikeshala wrote:
  
 
 Hi Bogdan, 
  I could fix the problem by modifying Makefile of postgres module. Thanks for the support. 
  
      On Thursday, April 23, 2020, 02:21:00 PM GMT+5:30, Bogdan-Andrei Iancu <bogdan at opensips.org> wrote:  
  
     Hi,
 
 I have an 9.5.19 (on Ubuntu) and works ok.
 
 Regards,
  Bogdan-Andrei Iancu

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

  On 4/22/20 3:44 PM, Nayani Nikeshala wrote:
  
 
      Hi Bogdan, 
  I found an old email, where he has faced a similar kind of an issue with PSQL 9.2 also. I believe, it will not get resolved with PSQL version.  
  https://opensips.org/pipermail/devel/2015-June/017666.html
  
  According to the email, he has resolved it by modifying makefile, but I'm not sure, how he did that. 
  
      On Wednesday, April 22, 2020, 01:54:09 PM GMT+5:30, Bogdan-Andrei Iancu <bogdan at opensips.org> wrote:  
  
     It may sound weird, but maybe you into the other extrema, with some too new version :D...
 
 Is it possible to try some 9.3 or so ?
 
 Regards, 
 Bogdan-Andrei Iancu

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

  On 4/21/20 10:35 PM, Nayani Nikeshala wrote:
  
 
      Hi Bogdan, 
  I removed psql 8.4 and installed psql 9.6.  
    [root at SIPserver opensips-2.4.7]# yum list installed | grep postgre postgresql96.i686        9.6.17-1PGDG.rhel6 postgresql96-devel.i686  9.6.17-1PGDG.rhel6 postgresql96-libs.i686   9.6.17-1PGDG.rhel6 postgresql96-server.i686 9.6.17-1PGDG.rhel6 [root at SIPserver opensips-2.4.7]# 
   
  When I compile, I get below error. (Below is a part of the error) 
    make[1]: Entering directory `/home/cscore/Downloads/opensips-2.4.7/modules/db_postgres' Compiling dbase.c Compiling pg_con.c Compiling res.c Compiling val.c In file included from pg_con.c:23: pg_con.h:39:22: error: libpq-fe.h: No such file or directory In file included from pg_con.c:23: pg_con.h:54: error: expected specifier-qualifier-list before ‘PGconn’ pg_con.c: In function ‘db_postgres_new_connection’: pg_con.c:93: error: ‘struct pg_con’ has no member named ‘con’ pg_con.c:93: warning: implicit declaration of function ‘PQconnectdbParams’ 
   libpq-fe.h & pg_config are in the below paths.  
  
    [root at SIPserver opensips-2.4.7]# ls -lrt /usr/pgsql-9.6/include/libpq-fe.h -rw-r--r--. 1 root root 21900 Feb 12 02:52 /usr/pgsql-9.6/include/libpq-fe.h [root at SIPserver opensips-2.4.7]# 
    [root at SIPserver opensips-2.4.7]# ls -lrt /usr/pgsql-9.6/bin/pg_config -rwxr-xr-x. 1 root root 24544 Feb 12 02:52 /usr/pgsql-9.6/bin/pg_config  
  Could you assist me with above error.   
  
  
      On Tuesday, April 21, 2020, 08:57:13 PM GMT+5:30, Bogdan-Andrei Iancu <bogdan at opensips.org> wrote:  
  
     Hi Nayani,
 
 yeah, that is a rather old and unsupported version of postgres. I think you should try to use a newer version it (maybe a newer version of your distro).
 
 Regards,
 Bogdan-Andrei Iancu

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

  On 4/21/20 5:21 PM, Nayani Nikeshala wrote:
  
 
     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 "makeinclude_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.c Compiling db_postgres.c Compiling pg_con.c Compiling res.c Compiling val.c pg_con.c: In function db_postgres_new_connection: pg_con.c:93: warning: implicit declaration of function PQconnectdbParams pg_con.c:93: warning: assignment makes pointer from integer without a cast Linking db_postgres.so make[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.   
     
       
       
       
   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200424/89066d8e/attachment-0001.html>