<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Thanks Nayani,<br>
<br>
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.<br>
<br>
Could you run and post the output of:<br>
<br>
(cd modules/db_postgres/ ; make proper; NICER=0 make )<br>
<br>
Please run it as it is, including the brackets <br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="https://www.opensips-solutions.com">https://www.opensips-solutions.com</a>
</pre>
<div class="moz-cite-prefix">On 4/24/20 7:53 PM, Nayani Nikeshala
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:1567006032.186555.1587747189795@mail.yahoo.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div class="ydp572fc6eayahoo-style-wrap"
style="font-family:Helvetica Neue, Helvetica, Arial,
sans-serif;font-size:16px;">
<div dir="ltr" data-setdir="false">Hi Bogdan,</div>
<div dir="ltr" data-setdir="false"><br>
</div>
<div dir="ltr" data-setdir="false">I added the path of <span><span
style="color: rgb(0, 0, 0); font-family: Helvetica Neue,
Helvetica, Arial, sans-serif; font-size: 16px;">libpq-fe.h
to the Makefile. </span></span></div>
<div dir="ltr" data-setdir="false"><br>
</div>
<div dir="ltr" data-setdir="false">
<div>
<div>[root@SIPserver include]# ls -lrt
/usr/pgsql-9.6/include/libpq-fe.h</div>
<div>-rw-r--r--. 1 root root 21900 Feb 12 02:52
/usr/pgsql-9.6/include/libpq-fe.h</div>
<div><br>
</div>
</div>
<br>
</div>
<div><br>
</div>
</div>
<div id="yahoo_quoted_8237064692" class="yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial,
sans-serif;font-size:13px;color:#26282a;">
<div> On Friday, April 24, 2020, 01:51:35 PM GMT+5:30,
Bogdan-Andrei Iancu <a class="moz-txt-link-rfc2396E" href="mailto:bogdan@opensips.org"><bogdan@opensips.org></a> wrote: </div>
<div><br>
</div>
<div><br>
</div>
<div>
<div id="yiv5875277552">
<div> <tt>Hi Nayani,<br clear="none">
<br clear="none">
What was the fix you did ? the path to the postgres
lib? <br clear="none">
<br clear="none">
Regards,<br clear="none">
</tt>
<pre class="yiv5875277552moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a rel="nofollow" shape="rect" class="yiv5875277552moz-txt-link-freetext" target="_blank" href="https://www.opensips-solutions.com" moz-do-not-send="true">https://www.opensips-solutions.com</a>
</pre>
<div class="yiv5875277552yqt9685169967"
id="yiv5875277552yqt48697">
<div class="yiv5875277552moz-cite-prefix">On 4/23/20
10:18 PM, Nayani Nikeshala wrote:<br clear="none">
</div>
<blockquote type="cite"> </blockquote>
</div>
</div>
<div class="yiv5875277552yqt9685169967"
id="yiv5875277552yqt31118">
<div>
<div class="yiv5875277552ydp68f9aa4dyahoo-style-wrap"
style="font-family:Helvetica Neue, Helvetica, Arial,
sans-serif;font-size:16px;">
<div dir="ltr">Hi Bogdan,</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">I could fix the problem by modifying
Makefile of postgres module. Thanks for the
support.</div>
<div dir="ltr"><br clear="none">
</div>
<div><br clear="none">
</div>
</div>
<div class="yiv5875277552ydpab4460d9yahoo_quoted"
id="yiv5875277552ydpab4460d9yahoo_quoted_8451255942">
<div style="font-family:'Helvetica Neue', Helvetica,
Arial, sans-serif;font-size:13px;color:#26282a;">
<div> On Thursday, April 23, 2020, 02:21:00 PM
GMT+5:30, Bogdan-Andrei Iancu <a rel="nofollow"
shape="rect"
class="yiv5875277552moz-txt-link-rfc2396E"
ymailto="mailto:bogdan@opensips.org"
target="_blank"
href="mailto:bogdan@opensips.org"
moz-do-not-send="true"><bogdan@opensips.org></a>
wrote: </div>
<div><br clear="none">
</div>
<div><br clear="none">
</div>
<div>
<div id="yiv5875277552ydpab4460d9yiv4765520955">
<div> <tt>Hi,<br clear="none">
<br clear="none">
I have an 9.5.19 (on Ubuntu) and works ok.<br
clear="none">
<br clear="none">
Regards,<br clear="none">
</tt>
<pre class="yiv5875277552ydpab4460d9yiv4765520955moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a rel="nofollow" shape="rect" class="yiv5875277552ydpab4460d9yiv4765520955moz-txt-link-freetext" target="_blank" href="https://www.opensips-solutions.com" moz-do-not-send="true">https://www.opensips-solutions.com</a>
</pre>
<div
class="yiv5875277552ydpab4460d9yiv4765520955yqt0966171494"
id="yiv5875277552ydpab4460d9yiv4765520955yqt61876">
<div
class="yiv5875277552ydpab4460d9yiv4765520955moz-cite-prefix">On
4/22/20 3:44 PM, Nayani Nikeshala wrote:<br
clear="none">
</div>
<blockquote type="cite"> </blockquote>
</div>
</div>
<div
class="yiv5875277552ydpab4460d9yiv4765520955yqt0966171494"
id="yiv5875277552ydpab4460d9yiv4765520955yqt68602">
<div>
<div
class="yiv5875277552ydpab4460d9yiv4765520955ydpeb8bea13yahoo-style-wrap"
style="font-family:Helvetica Neue,
Helvetica, Arial,
sans-serif;font-size:16px;">
<div dir="ltr">Hi Bogdan,</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">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. </div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr"><span><a rel="nofollow"
shape="rect" target="_blank"
href="https://opensips.org/pipermail/devel/2015-June/017666.html"
moz-do-not-send="true">https://opensips.org/pipermail/devel/2015-June/017666.html</a></span><br
clear="none">
</div>
<div><br clear="none">
</div>
<div dir="ltr">According to the email,
he has resolved it by modifying
makefile, but I'm not sure, how he did
that.</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr"><br clear="none">
</div>
</div>
<div
class="yiv5875277552ydpab4460d9yiv4765520955yahoo_quoted"
id="yiv5875277552ydpab4460d9yiv4765520955yahoo_quoted_8404259530">
<div style="font-family:'Helvetica
Neue', Helvetica, Arial,
sans-serif;font-size:13px;color:#26282a;">
<div> On Wednesday, April 22, 2020,
01:54:09 PM GMT+5:30, Bogdan-Andrei
Iancu <a rel="nofollow"
shape="rect"
class="yiv5875277552ydpab4460d9yiv4765520955moz-txt-link-rfc2396E"
ymailto="mailto:bogdan@opensips.org" target="_blank"
href="mailto:bogdan@opensips.org"
moz-do-not-send="true"><bogdan@opensips.org></a>
wrote: </div>
<div><br clear="none">
</div>
<div><br clear="none">
</div>
<div>
<div
id="yiv5875277552ydpab4460d9yiv4765520955">
<div> <tt>It may sound weird, but
maybe you into the other
extrema, with some too new
version :D...<br clear="none">
<br clear="none">
Is it possible to try some 9.3
or so ?<br clear="none">
<br clear="none">
Regards, </tt><br
clear="none">
<pre class="yiv5875277552ydpab4460d9yiv4765520955moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a rel="nofollow" shape="rect" class="yiv5875277552ydpab4460d9yiv4765520955moz-txt-link-freetext" target="_blank" href="https://www.opensips-solutions.com" moz-do-not-send="true">https://www.opensips-solutions.com</a>
</pre>
<div
class="yiv5875277552ydpab4460d9yiv4765520955yqt9174662582"
id="yiv5875277552ydpab4460d9yiv4765520955yqt86238">
<div
class="yiv5875277552ydpab4460d9yiv4765520955moz-cite-prefix">On
4/21/20 10:35 PM, Nayani
Nikeshala wrote:<br
clear="none">
</div>
<blockquote type="cite"> </blockquote>
</div>
</div>
<div
class="yiv5875277552ydpab4460d9yiv4765520955yqt9174662582"
id="yiv5875277552ydpab4460d9yiv4765520955yqt35619">
<div>
<div
class="yiv5875277552ydpab4460d9yiv4765520955ydp262fd7bayahoo-style-wrap"
style="font-family:Helvetica
Neue, Helvetica, Arial,
sans-serif;font-size:16px;">
<div dir="ltr">Hi Bogdan,</div>
<div dir="ltr"><br
clear="none">
</div>
<div dir="ltr">I removed
psql 8.4 and installed
psql 9.6. </div>
<div dir="ltr"><br
clear="none">
</div>
<div dir="ltr">
<div>
<div>[root@SIPserver
opensips-2.4.7]# yum
list installed | grep
postgre</div>
<div>postgresql96.i686
9.6.17-1PGDG.rhel6</div>
<div>postgresql96-devel.i686
9.6.17-1PGDG.rhel6</div>
<div>postgresql96-libs.i686
9.6.17-1PGDG.rhel6</div>
<div>postgresql96-server.i686
9.6.17-1PGDG.rhel6</div>
<div>[root@SIPserver
opensips-2.4.7]#</div>
<div><br clear="none">
</div>
</div>
<br clear="none">
</div>
<div dir="ltr">When I
compile, I get below
error. (Below is a part of
the error)</div>
<div dir="ltr"><br
clear="none">
</div>
<div dir="ltr">
<div>
<div>make[1]: Entering
directory
`/home/cscore/Downloads/opensips-2.4.7/modules/db_postgres'</div>
<div>Compiling dbase.c</div>
<div>Compiling pg_con.c</div>
<div>Compiling res.c</div>
<div>Compiling val.c</div>
<div>In file included
from pg_con.c:23:</div>
<div>pg_con.h:39:22:
error: libpq-fe.h: No
such file or directory</div>
<div>In file included
from pg_con.c:23:</div>
<div>pg_con.h:54: error:
expected
specifier-qualifier-list
before ‘PGconn’</div>
<div>pg_con.c: In
function
‘db_postgres_new_connection’:</div>
<div>pg_con.c:93: error:
‘struct pg_con’ has no
member named ‘con’</div>
<div>pg_con.c:93:
warning: implicit
declaration of
function
‘PQconnectdbParams’</div>
<div><br clear="none">
</div>
</div>
<div dir="ltr"><span><span
style="color:rgb(0,
0,
0);font-family:Helvetica
Neue, Helvetica,
Arial,
sans-serif;font-size:16px;">libpq-fe.h
& <span><span
style="color:rgb(0,
0,
0);font-family:Helvetica
Neue, Helvetica,
Arial,
sans-serif;font-size:16px;">pg_config
are</span></span> in
the below paths. </span></span><br
clear="none">
</div>
<div dir="ltr"><span><span
style="color:rgb(0,
0,
0);font-family:Helvetica
Neue, Helvetica,
Arial,
sans-serif;font-size:16px;"><br
clear="none">
</span></span></div>
<div dir="ltr">
<div>
<div>[root@SIPserver
opensips-2.4.7]# ls
-lrt
/usr/pgsql-9.6/include/libpq-fe.h</div>
<div>-rw-r--r--. 1
root root 21900 Feb
12 02:52
/usr/pgsql-9.6/include/libpq-fe.h</div>
<div>[root@SIPserver
opensips-2.4.7]#</div>
<div><br clear="none">
</div>
<div dir="ltr">
<div>
<div>[root@SIPserver
opensips-2.4.7]#
ls -lrt
/usr/pgsql-9.6/bin/pg_config</div>
<div>-rwxr-xr-x. 1
root root 24544
Feb 12 02:52
/usr/pgsql-9.6/bin/pg_config</div>
</div>
<br clear="none">
</div>
<div dir="ltr">Could
you assist me with
above error. </div>
</div>
<br clear="none">
</div>
<br clear="none">
</div>
<div><br clear="none">
</div>
</div>
<div
class="yiv5875277552ydpab4460d9yiv4765520955yahoo_quoted"
id="yiv5875277552ydpab4460d9yiv4765520955yahoo_quoted_8185339492">
<div
style="font-family:'Helvetica
Neue', Helvetica, Arial,
sans-serif;font-size:13px;color:#26282a;">
<div> On Tuesday, April
21, 2020, 08:57:13 PM
GMT+5:30, Bogdan-Andrei
Iancu <a rel="nofollow"
shape="rect"
class="yiv5875277552ydpab4460d9yiv4765520955moz-txt-link-rfc2396E"
ymailto="mailto:bogdan@opensips.org" target="_blank"
href="mailto:bogdan@opensips.org"
moz-do-not-send="true"><bogdan@opensips.org></a>
wrote: </div>
<div><br clear="none">
</div>
<div><br clear="none">
</div>
<div>
<div
id="yiv5875277552ydpab4460d9yiv4765520955">
<div> Hi Nayani,<br
clear="none">
<br clear="none">
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).<br
clear="none">
<br clear="none">
Regards,<br
clear="none">
<pre class="yiv5875277552ydpab4460d9yiv4765520955moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a rel="nofollow" shape="rect" class="yiv5875277552ydpab4460d9yiv4765520955moz-txt-link-freetext" target="_blank" href="https://www.opensips-solutions.com" moz-do-not-send="true">https://www.opensips-solutions.com</a>
</pre>
<div
class="yiv5875277552ydpab4460d9yiv4765520955yqt3599837898"
id="yiv5875277552ydpab4460d9yiv4765520955yqtfd29760">
<div
class="yiv5875277552ydpab4460d9yiv4765520955moz-cite-prefix">On
4/21/20 5:21 PM,
Nayani Nikeshala
wrote:<br
clear="none">
</div>
<blockquote
type="cite"> </blockquote>
</div>
</div>
<div
class="yiv5875277552ydpab4460d9yiv4765520955yqt3599837898"
id="yiv5875277552ydpab4460d9yiv4765520955yqtfd41903">
<div>
<div><span
style="color:rgb(38,
40, 42);">Hi
Bogdan,</span><br
clear="none">
</div>
<div
class="yiv5875277552ydpab4460d9yiv4765520955ydpbd3f94ebyahoo_quoted"
id="yiv5875277552ydpab4460d9yiv4765520955ydpbd3f94ebyahoo_quoted_7777934833">
<div
style="font-family:'Helvetica
Neue',
Helvetica,
Arial,
sans-serif;font-size:13px;color:#26282a;">
<div>
<div
class="yiv5875277552ydpab4460d9yiv4765520955ydp33188704yahoo-style-wrap"
style="font-family:Helvetica Neue, Helvetica, Arial,
sans-serif;font-size:16px;">
<div dir="ltr"><br
clear="none">
</div>
<div dir="ltr">I
have attached
the output log
for the above
commands. </div>
<div dir="ltr"><br
clear="none">
</div>
<div dir="ltr"><span><span
style="font-family:monospace;">"make modules module=modules/db_postgres"
gave me an
error as in
the attached
file, so I
used "<span>make
include_modules=db_postgres modules" instead. I could see below in the
output. </span></span></span><br
clear="none">
</div>
<div dir="ltr"><span><span
style="font-family:monospace;"><span><br clear="none">
</span></span></span></div>
<div dir="ltr"><span><span
style="font-family:monospace;"> </span></span>
<div>
<div>make[1]:
Entering
directory
`/home/cscore/Downloads/opensips-2.4.7/modules/db_postgres'</div>
<div>make[1]:
Leaving
directory
`/home/cscore/Downloads/opensips-2.4.7/modules/db_postgres'</div>
<div>make[1]:
Entering
directory
`/home/cscore/Downloads/opensips-2.4.7/modules/db_postgres'</div>
<div>Compiling
dbase.c</div>
<div>Compiling
db_postgres.c</div>
<div>Compiling
pg_con.c</div>
<div>Compiling
res.c</div>
<div>Compiling
val.c</div>
<div>pg_con.c:
In function
db_postgres_new_connection:</div>
<div><span
style="background-color:rgb(91,
136, 40);">pg_con.c:93:
warning:
implicit
declaration of
function
PQconnectdbParams</span></div>
<div><span
style="background-color:rgb(91,
136, 40);">pg_con.c:93:
warning:
assignment
makes pointer
from integer
without a cast</span></div>
<div>Linking
db_postgres.so</div>
<div>make[1]:
Leaving
directory
`/home/cscore/Downloads/opensips-2.4.7/modules/db_postgres'</div>
</div>
<div><br
clear="none">
</div>
<div dir="ltr">Is
this a problem
of my psql
version(<span><span
style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica,
Arial,
sans-serif;">8.4.20</span></span>),
because <span><span
style="color:rgb(0, 0,
0);font-family:monospace;font-size:16px;background-color:rgb(91,
136, 40);">PQconnectdbParams </span><span
style="color:rgb(0, 0,
0);font-family:monospace;font-size:16px;background-color:rgb(255,
255, 255);"> is
not available
in that
version. </span></span></div>
</div>
<br
clear="none">
</div>
</div>
</div>
</div>
<br clear="none">
</div>
</div>
</div>
</div>
</div>
</div>
<br clear="none">
</div>
</div>
</div>
</div>
</div>
</div>
<br clear="none">
</div>
</div>
</div>
</div>
</div>
</div>
<br clear="none">
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<br>
</body>
</html>