<html><head></head><body><div class="ydp68f9aa4dyahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div></div>
<div dir="ltr" data-setdir="false">Hi Bogdan,</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">I could fix the problem by modifying Makefile of postgres module. Thanks for the support.</div><div dir="ltr" data-setdir="false"><br></div><div><br></div>
</div><div id="ydpab4460d9yahoo_quoted_8451255942" class="ydpab4460d9yahoo_quoted">
<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 <bogdan@opensips.org> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydpab4460d9yiv4765520955"><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="ydpab4460d9yiv4765520955moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a shape="rect" class="ydpab4460d9yiv4765520955moz-txt-link-freetext" href="https://www.opensips-solutions.com" rel="nofollow" target="_blank">https://www.opensips-solutions.com</a>
</pre>
<div class="ydpab4460d9yiv4765520955yqt0966171494" id="ydpab4460d9yiv4765520955yqt61876"><div class="ydpab4460d9yiv4765520955moz-cite-prefix">On 4/22/20 3:44 PM, Nayani Nikeshala
wrote:<br clear="none">
</div>
<blockquote type="cite">
</blockquote></div></div><div class="ydpab4460d9yiv4765520955yqt0966171494" id="ydpab4460d9yiv4765520955yqt68602"><div><div class="ydpab4460d9yiv4765520955ydpeb8bea13yahoo-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 shape="rect" href="https://opensips.org/pipermail/devel/2015-June/017666.html" rel="nofollow" target="_blank">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="ydpab4460d9yiv4765520955yahoo_quoted" id="ydpab4460d9yiv4765520955yahoo_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 shape="rect" class="ydpab4460d9yiv4765520955moz-txt-link-rfc2396E" href="mailto:bogdan@opensips.org" rel="nofollow" target="_blank"><bogdan@opensips.org></a> wrote: </div>
<div><br clear="none">
</div>
<div><br clear="none">
</div>
<div>
<div id="ydpab4460d9yiv4765520955">
<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="ydpab4460d9yiv4765520955moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a shape="rect" class="ydpab4460d9yiv4765520955moz-txt-link-freetext" href="https://www.opensips-solutions.com" rel="nofollow" target="_blank">https://www.opensips-solutions.com</a>
</pre>
<div class="ydpab4460d9yiv4765520955yqt9174662582" id="ydpab4460d9yiv4765520955yqt86238">
<div class="ydpab4460d9yiv4765520955moz-cite-prefix">On 4/21/20
10:35 PM, Nayani Nikeshala wrote:<br clear="none">
</div>
<blockquote type="cite"> </blockquote>
</div>
</div>
<div class="ydpab4460d9yiv4765520955yqt9174662582" id="ydpab4460d9yiv4765520955yqt35619">
<div>
<div class="ydpab4460d9yiv4765520955ydp262fd7bayahoo-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="ydpab4460d9yiv4765520955yahoo_quoted" id="ydpab4460d9yiv4765520955yahoo_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 shape="rect" class="ydpab4460d9yiv4765520955moz-txt-link-rfc2396E" href="mailto:bogdan@opensips.org" rel="nofollow" target="_blank"><bogdan@opensips.org></a>
wrote: </div>
<div><br clear="none">
</div>
<div><br clear="none">
</div>
<div>
<div id="ydpab4460d9yiv4765520955">
<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="ydpab4460d9yiv4765520955moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a shape="rect" class="ydpab4460d9yiv4765520955moz-txt-link-freetext" href="https://www.opensips-solutions.com" rel="nofollow" target="_blank">https://www.opensips-solutions.com</a>
</pre>
<div class="ydpab4460d9yiv4765520955yqt3599837898" id="ydpab4460d9yiv4765520955yqtfd29760">
<div class="ydpab4460d9yiv4765520955moz-cite-prefix">On
4/21/20 5:21 PM, Nayani Nikeshala wrote:<br clear="none">
</div>
<blockquote type="cite"> </blockquote>
</div>
</div>
<div class="ydpab4460d9yiv4765520955yqt3599837898" id="ydpab4460d9yiv4765520955yqtfd41903">
<div>
<div><span style="color:rgb(38, 40, 42);">Hi
Bogdan,</span><br clear="none">
</div>
<div class="ydpab4460d9yiv4765520955ydpbd3f94ebyahoo_quoted" id="ydpab4460d9yiv4765520955ydpbd3f94ebyahoo_quoted_7777934833">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
<div class="ydpab4460d9yiv4765520955ydp33188704yahoo-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></body></html>