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: