[OpenSIPS-Users] OpenSIPS installation with PostgresSQL

[Nayani Nikeshala]

 Hi Bogdan,
I removed psql 8.4 and installed psql 9.6. 
[root at SIPserver opensips-2.4.7]# yum list installed | grep postgrepostgresql96.i686        9.6.17-1PGDG.rhel6postgresql96-devel.i686  9.6.17-1PGDG.rhel6postgresql96-libs.i686   9.6.17-1PGDG.rhel6postgresql96-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.cCompiling pg_con.cCompiling res.cCompiling val.cIn file included from pg_con.c:23:pg_con.h:39:22: error: libpq-fe.h: No such file or directoryIn 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 "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.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/20200421/b79c2879/attachment.html>