Hi Bogdan,
I removed psql 8.4 and installed psql 9.6. 
[root@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@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@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@SIPserver opensips-2.4.7]#
[root@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 
<[email protected]> 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.   
     
   
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to