<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
the log messages indicate that the connection to postgres module has
timeout. Be sure postres server is up and running.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 10/07/14 00:17, Rene Montilva wrote:<br>
</div>
<blockquote
cite="mid:CALbkU0TWsmPP+SrGe48RtCbbSFwjAmvzgCpCGPOgaFfgLwGMeQ@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>
<div>Hi list<br>
<br>
</div>
i'm config SQLOps Module with postgresql db module or is
postgresql driver?<br>
<br>
</div>
this is my kamailio config:<br>
<br>
#!ifndef DBURL<br>
#!define DBURL <a class="moz-txt-link-rfc2396E" href="mailto:postgres://user:ouser@x.x.x.x/kamailio">"postgres://user:ouser@x.x.x.x/kamailio"</a><br>
#!endif<br>
<br>
<br>
sql_query("ca", "select * from xxxxx","ra");<br>
<br>
<br>
if($dbr(ra=>rows)> 0){<br>
xlog("L_INFO", "saldo:$dbr(ra=>[0,0]) y
seg:$dbr(ra=>[0,1]) ");<br>
<br>
$var(credit) = $dbr(ra=>[0,0]); # 30$ of credit<br>
$var(cost_per_sec) = $dbr(ra=>[0,1]); # 1$ per sec<br>
$var(i_pulse) = "1"; # 1$ to establish the call<br>
$var(f_pulse) = "1"; # 1$ per second<br>
<br>
sql_result_free ("ra");<br>
<br>
<br>
<br>
<br>
if($var(cost_per_sec) > $var(credit)) {<br>
sl_send_reply("402","payment required");<br>
exit;<br>
}<br>
<br>
}<br>
<br>
<br>
</div>
i got this warning and would like why this happen:<br>
<br>
<br>
WARNING: db_postgres [km_dbase.c:235]:
db_postgres_submit_query(): postgres result check failed with
code 7 (PGRES_FATAL_ERROR)<br>
<br>
WARNING: db_postgres [km_dbase.c:239]:
db_postgres_submit_query(): postgres query command failed,
connection status 0, error [SSL SYSCALL error: Connection timed
out#012]<br>
<br>
WARNING: db_postgres [km_dbase.c:239]:
db_postgres_submit_query(): postgres query command failed,
connection status 1, error [SSL SYSCALL error: EOF detected#012]<br>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a></pre>
</body>
</html>