Hi Bogdan,
I added the path of libpq-fe.h to the Makefile.
[root@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
<[email protected]> 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
<[email protected]> 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
<[email protected]> 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@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@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@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 "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.
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
