[SR-Users] db_postgres Error

[Rene Montilva]

Hi list

i'm config  SQLOps Module with postgresql db module or is postgresql driver?

this is my kamailio config:

#!ifndef DBURL
#!define DBURL "postgres://user:ouser@x.x.x.x/kamailio"
#!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;
        }

}


i got this warning and would like why this happen:


WARNING: db_postgres [km_dbase.c:235]: db_postgres_submit_query(): postgres
result check failed with code 7 (PGRES_FATAL_ERROR)

 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]

 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]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140709/865bc01a/attachment.html>