[OpenSIPS-Users] OpenSIPS installation with PostgresSQL

[Bogdan-Andrei Iancu]

Thanks Nayani,

This is a bit strante as teh libpq-fe.h file is not directly included by 
OpenSIPS, but it is via the pq-con.h file. And both are in the same 
directory pf libpq, directory which should be detected by the OpenSIPS 
Makefile.

Could you run and post the output of:

(cd modules/db_postgres/ ; make proper; NICER=0 make )

Please run it as it is, including the brackets

Regards,

Bogdan-Andrei Iancu

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

On 4/24/20 7:53 PM, Nayani Nikeshala wrote:
> 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> <mailto: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> <mailto: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> <mailto: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/20200427/5d960a54/attachment-0001.html>