Hello All,
I have a problem with db extra and AVP. Some times don’t log the values of AVP in the
database.
Script.
Openser Version 1.2.1.
...
modparam("acc", "db_extra",
"from_uri=$fu;i_uri=$ou;o_uri=$ru;cod_op=$avp(s:cod_op);ip_do_originador=$si;flag_followme=$avp(s:flag_follow_me)")
...
route[2] {
...
$avp(s:cod_op) = $(rU{s.select,0,#});
xlog("L_ALERT", "Test_01 RURI=$rU AVP=$avp(s:cod_op) To=$tu
IP=$si\n");
...
}
Example using the scene of a call.
For RURI = sip:06#022xxxxxxxx@domain.com
I have the following result in logs:
=> Log file
Jun 21 19:20:33 ser01-brt openser-1.2.1[14952]: Test_01 RURI=06#022xxxxxxxx AVP=06
To=sip:022xxxxxxxx@domain IP=x.x.x.x
=> Insert in database ( The values of cod_op and flag_follow_me is null)
T 10.5.0.19:33875 -> 10.5.0.22:3306 [AP]
insert into acc
(method,from_tag,to_tag,callid,sip_code,sip_reason,time,from_uri,i_uri,o_uri,cod_op,ip_do_originador,flag_followme
)
values
('INVITE','a7ba357706b2e329','as10700de1','1cefcf0885d9adbf(a)192.168.1.19','200','OK','2007-06-21
19:20:33','sip:6101@domain,'sip:022xxxxxxxx@domain','sip:06#022xxxxxxxx@x.x.x.x:5060;transport=udp','
','x.x.x.x',' ')
The problem is intermittent and occurs in 15% of the calls.
Does anybody know how can i resolve this question?
Best regards,
Areis.
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.9.4/860 - Release Date: 21/6/2007 17:53