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]