<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>It may sound weird, but maybe you into the other extrema, with
some too new version :D...<br>
<br>
Is it possible to try some 9.3 or so ?<br>
<br>
Regards, </tt><br>
<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/21/20 10:35 PM, Nayani Nikeshala
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:1971406255.325015.1587497750288@mail.yahoo.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div class="ydp262fd7bayahoo-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 removed psql 8.4 and
installed psql 9.6. </div>
<div dir="ltr" data-setdir="false"><br>
</div>
<div dir="ltr" data-setdir="false">
<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>
</div>
</div>
<br>
</div>
<div dir="ltr" data-setdir="false">When I compile, I get below
error. (Below is a part of the error)</div>
<div dir="ltr" data-setdir="false"><br>
</div>
<div dir="ltr" data-setdir="false">
<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>
</div>
</div>
<div dir="ltr" data-setdir="false"><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>
</div>
<div dir="ltr" data-setdir="false"><span><span style="color:
rgb(0, 0, 0); font-family: Helvetica Neue, Helvetica,
Arial, sans-serif; font-size: 16px;"><br>
</span></span></div>
<div dir="ltr" data-setdir="false">
<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>
</div>
<div dir="ltr" data-setdir="false">
<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>
</div>
<div dir="ltr" data-setdir="false">Could you assist me
with above error. </div>
</div>
<br>
</div>
<br>
</div>
<div><br>
</div>
</div>
<div id="yahoo_quoted_8185339492" class="yahoo_quoted">
<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 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="yiv3232751335">
<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="yiv3232751335moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a rel="nofollow" shape="rect" class="yiv3232751335moz-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="yiv3232751335yqt3599837898"
id="yiv3232751335yqtfd29760">
<div class="yiv3232751335moz-cite-prefix">On 4/21/20
5:21 PM, Nayani Nikeshala wrote:<br clear="none">
</div>
<blockquote type="cite"> </blockquote>
</div>
</div>
<div class="yiv3232751335yqt3599837898"
id="yiv3232751335yqtfd41903">
<div>
<div><span style="color:rgb(38, 40, 42);">Hi Bogdan,</span><br
clear="none">
</div>
<div class="yiv3232751335ydpbd3f94ebyahoo_quoted"
id="yiv3232751335ydpbd3f94ebyahoo_quoted_7777934833">
<div style="font-family:'Helvetica Neue', Helvetica,
Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
<div
class="yiv3232751335ydp33188704yahoo-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>
</blockquote>
<br>
</body>
</html>