<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<tt>Hi </tt><tt>Iņigo,<br>
<br>
So basically this issue has nothing to do with OpenSIPS itself
(like causing it), but actually to the postgres server, right ?<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 17.09.2015 09:55, Iņigo Belamendia
wrote:<br>
</div>
<blockquote cite="mid:55FA63CC.3020003@enigmedia.es" type="cite">
<pre wrap="">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.
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>