[OpenSIPS-Users] opensips 1.11.5 error opening new ssl connections with postgres

[Bogdan-Andrei Iancu]

Hi Iñigo,

So basically this issue has nothing to do with OpenSIPS itself (like 
causing it), but actually to the postgres server, right ?

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 17.09.2015 09:55, Iñigo Belamendia wrote:
> Hi,
>
> >From last monday our OpenSIPS (1.11.5) dies after a restart. The
> process starts but after few seconds (10") it goes down.
>
> In log we can see some access to database (Postgres), but after some
> queries it refuses new queries execution. An error message appears in
> log saying there's no authorization line in pg_hba.conf:
>
> Sep 15 12:03:27 server01 opensips[17471]:
> ERROR:db_postgres:db_postgres_new_connection: SSL error: called a
> function you should not call#012FATAL:  no hay una l?nea en
> pg_hba.conf para <<192.168.1.119>>, usuario <<username>>, base de
> datos <<opensips>>, SSL inactivo#012
>
> And it's true, theres no SSL-inactive auth line, but it is for SSL
> (ip, username and password have been double checked). In attached log
> file completed queries can be seen.
>
> This issue happened in two different environments after a system
> update (apt-get update && apt-get upgrade) and a service restart
> (service opensips restart). Before each upgrade a disk snapshot is
> taken but a restore from these snapshots (opensips and postgres)
> doesn't fix the issue.
>
> Queries executed [with psql] from console in OpenSIPS machine run ok.
>
> Adding no-ssl auth into pg_hba.conf OpenSIPS starts ok.
>
>
>
>
> _______________________________________________
> Users mailing list
> 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/20150923/50d74d0b/attachment.htm>