[SR-Users] db_postgres Error

[Daniel-Constantin Mierla]

Hello,

the log messages indicate that the connection to postgres module has
timeout. Be sure postres server is up and running.

Cheers,
Daniel

Hi list
i'm config SQLOps Module with postgresql db module or is postgresql
driver?
#!ifndef DBURL
#!endif
sql_query("ca", "select * from xxxxx","ra");
if($dbr(ra=>rows)> 0){
xlog("L_INFO", "saldo:$dbr(ra=>[0,0]) y seg:$dbr(ra=>[0,1]) ");
$var(credit) = $dbr(ra=>[0,0]); # 30$ of credit
$var(cost_per_sec) = $dbr(ra=>[0,1]); # 1$ per sec
$var(i_pulse) = "1"; # 1$ to establish the call
$var(f_pulse) = "1"; # 1$ per second
sql_result_free ("ra");
if($var(cost_per_sec) > $var(credit)) {
sl_send_reply("402","payment required");
exit;
}
}
postgres result check failed with code 7 (PGRES_FATAL_ERROR)
postgres query command failed, connection status 0, error [SSL SYSCALL
error: Connection timed out#012]
postgres query command failed, connection status 1, error [SSL SYSCALL
error: EOF detected#012]
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users