<html><head></head><body><div></div>
<div><span style="color: rgb(38, 40, 42);">Hi Bogdan,</span><br></div><div id="ydpbd3f94ebyahoo_quoted_7777934833" class="ydpbd3f94ebyahoo_quoted"><div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;"><div><div class="ydp33188704yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">I have attached the output log for the above commands. </div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><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></div><div dir="ltr" data-setdir="false"><span><span style="font-family: monospace;"><span><br></span></span></span></div><div dir="ltr" data-setdir="false"><span><span style="font-family: monospace;"><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></div><div dir="ltr" data-setdir="false">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></span></span></div><div><br></div>
</div><div id="ydpbd3f94ebyahoo_quoted_7512830322" class="ydpbd3f94ebyahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Tuesday, April 21, 2020, 02:32:39 PM GMT+5:30, Bogdan-Andrei Iancu <bogdan@opensips.org> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydpbd3f94ebyiv8455625678"><div>
<tt>Hi,<br clear="none">
<br clear="none">
and I assume you also locally compiled the postgres module, right
?<br clear="none">
<br clear="none">
If you do in the directory with the opensips sources:<br clear="none">
<br clear="none">
(cd modules/db_postgres ; make proper) ; make modules
module=modules/db_postgres<br clear="none">
<br clear="none">
could you post the output here ?<br clear="none">
<br clear="none">
Regards,<br clear="none">
</tt>
<pre class="ydpbd3f94ebyiv8455625678moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a shape="rect" class="ydpbd3f94ebyiv8455625678moz-txt-link-freetext" href="https://www.opensips-solutions.com" rel="nofollow" target="_blank">https://www.opensips-solutions.com</a>
</pre>
<div class="ydpbd3f94ebyiv8455625678yqt3877228695" id="ydpbd3f94ebyiv8455625678yqt80149"><div class="ydpbd3f94ebyiv8455625678moz-cite-prefix">On 4/20/20 7:24 PM, Nayani Nikeshala
wrote:<br clear="none">
</div>
<blockquote type="cite">
</blockquote></div></div><div class="ydpbd3f94ebyiv8455625678yqt3877228695" id="ydpbd3f94ebyiv8455625678yqt74580"><div><div class="ydpbd3f94ebyiv8455625678ydp84241c42yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;">
<div dir="ltr">Hello,</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">OpenSIPS was compiled by me
and I followed the <span><a shape="rect" class="ydpbd3f94ebyiv8455625678ydpce1c1bdwikilink" title="Tutorials-GettingStarted" href="https://www.opensips.org/Documentation/Tutorials-GettingStarted" style="font-family:Trebuchet MS, sans-serif, Verdana, Arial;color:rgb(24, 86, 98);font-weight:bold;text-decoration-line:underline;width:100px;font-size:13.008px;" rel="nofollow" target="_blank">OpenSIPS Installation Webinar</a> tutorial. </span></div>
<div dir="ltr"><span><br clear="none">
</span></div>
<div dir="ltr"><span>Thanks!</span></div>
<div><br clear="none">
</div>
</div>
<div class="ydpbd3f94ebyiv8455625678yahoo_quoted" id="ydpbd3f94ebyiv8455625678yahoo_quoted_8250963257">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div> On Monday, April 20, 2020, 08:04:10 PM GMT+5:30,
Bogdan-Andrei Iancu <a shape="rect" class="ydpbd3f94ebyiv8455625678moz-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="ydpbd3f94ebyiv8455625678">
<div> <tt>Hi,<br clear="none">
<br clear="none">
Is OpenSIPS compiled by you or installed from packages
(if yes, what is the repo url)?<br clear="none">
<br clear="none">
Regards,<br clear="none">
</tt>
<pre class="ydpbd3f94ebyiv8455625678moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a shape="rect" class="ydpbd3f94ebyiv8455625678moz-txt-link-freetext" href="https://www.opensips-solutions.com" rel="nofollow" target="_blank">https://www.opensips-solutions.com</a>
</pre>
<div class="ydpbd3f94ebyiv8455625678yqt6904689872" id="ydpbd3f94ebyiv8455625678yqtfd17554">
<div class="ydpbd3f94ebyiv8455625678moz-cite-prefix">On 4/19/20
11:50 PM, Nayani Nikeshala via Users wrote:<br clear="none">
</div>
<blockquote type="cite"> </blockquote>
</div>
</div>
<div class="ydpbd3f94ebyiv8455625678yqt6904689872" id="ydpbd3f94ebyiv8455625678yqtfd54601">
<div>
<div class="ydpbd3f94ebyiv8455625678ydp5a0f02bdyahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;">
<div><span style="color:rgb(38, 40, 42);font-size:13px;">Hello,</span><br clear="none">
</div>
</div>
<div class="ydpbd3f94ebyiv8455625678ydp35fcc8a5yahoo_quoted" id="ydpbd3f94ebyiv8455625678ydp35fcc8a5yahoo_quoted_7442983449">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">I'm trying to install <span>opensips-2.4.7
with <span>psql -8.4.20 on a Centos-6
platform. I can connect to psql DB as
below.</span></span></div>
<div dir="ltr"><span><span><br clear="none">
</span></span></div>
<div dir="ltr"><span> </span>
<div>
<div>[root@SIPserver ~]# psql -h localhost
-U opensips -d opensips</div>
<div>psql (8.4.20)</div>
<div>Type "help" for help.</div>
<div><br clear="none">
</div>
<div>opensips=> </div>
<div><br clear="none">
</div>
</div>
</div>
<div dir="ltr"><span><span>When I try to start
OpenSIP as below, it gives me the
following error. </span></span></div>
<div dir="ltr"><span><span><br clear="none">
</span></span></div>
<div dir="ltr"><span> </span>
<div>
<div>[root@SIPserver ~]# opensipsctl start</div>
<div><br clear="none">
</div>
<div>INFO: Starting OpenSIPS :</div>
<div><br clear="none">
</div>
<div>ERROR: PID file /var/run/opensips.pid
does not exist -- OpenSIPS start failed</div>
<div>[root@SIPserver ~]#</div>
<div><br clear="none">
</div>
</div>
<div><br clear="none">
</div>
<div dir="ltr"> <span>/var/log/opensips.log
shows the below error. </span><br clear="none">
</div>
<div dir="ltr"><span><br clear="none">
</span></div>
<div dir="ltr">
<div>
<div>Apr 20 01:31:20 SIPserver opensips:
ERROR:core:sr_load_module: could not
open module
</usr/local//lib/opensips/modules/db_postgres.so>:
/usr/local//lib/opensips/modules/db_postgres.so: undefined symbol:
PQconnectdbParams</div>
<div>Apr 20 01:31:20 SIPserver opensips:
ERROR:core:load_module: failed to load
module</div>
<div>Apr 20 01:31:20 SIPserver opensips:
CRITICAL:core:yyerror: parse error in
config file
/usr/local//etc/opensips/opensips.cfg,
line 89, column 13-14: failed to load
module db_postgres.so#012</div>
<div><br clear="none">
</div>
</div>
<div dir="ltr">I noted that <span><span style="color:rgb(0, 0, 0);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;">PQconnectdbParams
is available from psql-9 onwards and
could not figure out, what does this
error mean. </span></span></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"><span><span style="color:rgb(0, 0, 0);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;">Could
someone assist me please. </span></span></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"><span><span style="color:rgb(0, 0, 0);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;">Thanks!</span></span></div>
</div>
</div>
</div>
</div>
</div>
<br clear="none">
<fieldset class="ydpbd3f94ebyiv8455625678mimeAttachmentHeader"></fieldset>
<pre class="ydpbd3f94ebyiv8455625678moz-quote-pre">_______________________________________________
Users mailing list
<a shape="rect" class="ydpbd3f94ebyiv8455625678moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" rel="nofollow" target="_blank">Users@lists.opensips.org</a>
<a shape="rect" class="ydpbd3f94ebyiv8455625678moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="nofollow" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
<br clear="none">
</div>
</div>
</div>
</div>
</div>
</div>
<br clear="none">
</div></div></div></div>
</div>
</div></div>
</div>
</div></body></html>