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]> <mailto:[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]> <mailto:[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
