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]