<html><head></head><body><div class="ydp5a0f02bdyahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div></div>
<div><span style="color: rgb(38, 40, 42); font-size: 13px;">Hello,</span><br></div></div><div id="ydp35fcc8a5yahoo_quoted_7442983449" class="ydp35fcc8a5yahoo_quoted"><div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;"><div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">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" data-setdir="false"><span><span><br></span></span></div><div dir="ltr" data-setdir="false"><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></div><div>opensips=> </div><div><br></div></div></span></div><div dir="ltr" data-setdir="false"><span><span>When I try to start OpenSIP as below, it gives me the following error. </span></span></div><div dir="ltr" data-setdir="false"><span><span><br></span></span></div><div dir="ltr" data-setdir="false"><span><div><div>[root@SIPserver ~]# opensipsctl start</div><div><br></div><div>INFO: Starting OpenSIPS :</div><div><br></div><div>ERROR: PID file /var/run/opensips.pid does not exist -- OpenSIPS start failed</div><div>[root@SIPserver ~]#</div><div><br></div></div><div><br></div><div dir="ltr" data-setdir="false"> <span>/var/log/opensips.log shows the below error. </span><br></div><div dir="ltr" data-setdir="false"><span><br></span></div><div dir="ltr" data-setdir="false"><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></div></div><div dir="ltr" data-setdir="false">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" 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"><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" 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"><span><span style="color: rgb(0, 0, 0); font-family: Helvetica Neue, Helvetica, Arial, sans-serif; font-size: 16px;">Thanks!</span></span></div></div></span></div></div>
</div>
</div></body></html>