[OpenSER-Users] DB_Extra and AVP Problem

[Alexandre dos Reis Ferreira]

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 at 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 at 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 at 192.168.1.19','200','OK','2007-06-21 19:20:33','sip:6101 at domain,'sip:022xxxxxxxx at domain','sip:06#022xxxxxxxx at 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
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20070622/33137cfa/attachment.htm