[OpenSIPS-Users] OpenSIPS installation with PostgresSQL

[Bogdan-Andrei Iancu]

Hi,

and I assume you also locally compiled the postgres module, right ?

If you do in the directory with the opensips sources:

(cd modules/db_postgres ; make proper) ; make modules 
module=modules/db_postgres

could you post the output here ?

Regards,

Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
   https://www.opensips-solutions.com

On 4/20/20 7:24 PM, Nayani Nikeshala wrote:
> Hello,
>
> OpenSIPS was compiled by me and I followed the OpenSIPS Installation 
> Webinar 
> <https://www.opensips.org/Documentation/Tutorials-GettingStarted> tutorial. 
>
>
> Thanks!
>
> On Monday, April 20, 2020, 08:04:10 PM GMT+5:30, Bogdan-Andrei Iancu 
> <bogdan at opensips.org> wrote:
>
>
> Hi,
>
> Is OpenSIPS compiled by you or installed from packages (if yes, what 
> is the repo url)?
>
> Regards,
> Bogdan-Andrei Iancu
>
> OpenSIPS Founder and Developer
>    https://www.opensips-solutions.com
>
> On 4/19/20 11:50 PM, Nayani Nikeshala via Users wrote:
> Hello,
>
> I'm trying to install opensips-2.4.7 with psql -8.4.20 on a Centos-6 
> platform. I can connect to psql DB as below.
>
> [root at SIPserver ~]# psql -h localhost -U opensips -d opensips
> psql (8.4.20)
> Type "help" for help.
>
> opensips=>
>
> When I try to start OpenSIP as below, it gives me the following error.
>
> [root at SIPserver ~]# opensipsctl start
>
> INFO: Starting OpenSIPS :
>
> ERROR: PID file /var/run/opensips.pid does not exist -- OpenSIPS start 
> failed
> [root at SIPserver ~]#
>
>
> /var/log/opensips.log shows the below error.
>
> 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
> Apr 20 01:31:20 SIPserver opensips: ERROR:core:load_module: failed to 
> load module
> 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
>
> I noted that PQconnectdbParams is available from psql-9 onwards and 
> could not figure out, what does this error mean.
>
> Could someone assist me please.
>
> Thanks!
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org  <mailto:Users at lists.opensips.org>
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200421/1a9270c7/attachment.html>