[Serusers] No record inserted into the acc table of mysql! - sr-users

28 Jul 2005


      Hello, guys:
thanks for your replies. I run SER and make sip call. I configured
ser.cfg and some message are displayed as fowwlow:
loadmodule "/usr/local/lib/ser/modules/mysql.so"
loadmodule "/usr/local/lib/ser/modules/sl.so"
loadmodule "/usr/local/lib/ser/modules/tm.so"
loadmodule "/usr/local/lib/ser/modules/rr.so"
loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/lib/ser/modules/registrar.so"
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"
loadmodule "/usr/local/lib/ser/modules/uri_db.so"
loadmodule "/usr/local/lib/ser/modules/acc.so"
modparam("acc","log_level",1)
modparam("acc","log_flag",1)
#  modparam("acc", "db_url","flatstore:/var/log/acc")
 modparam("acc", "db_flag", 1)
#  modparam("acc", "db_missed_flag", 1)
#  modparam("acc", "failed_transactions", 2)
modparam("auth_db|uri_db|usrloc|acc", "db_url",
"mysql://ser:heslo@localhost/ser")
modparam("auth_db", "calculate_ha1", 1)
modparam("auth_db", "password_column", "password")
modparam("usrloc", "db_mode", 1)
 if (method=="INVITE" || method=="ACK") {
           log (1, "%method - INVITE or ACK MESSAGE RECEIVED - START
ACCOUNTING\n");
           setflag(1);
          #  record_route();
        };
        if (method=="BYE" || method=="CANCEL") {
                log (1, "%method  - STOP ACCOUNTING\n");
                setflag(1);
            #    record_route();
        };
        # end of testing --------------------------------------------
if (method!="REGISTER") {
                record_route();
                setflag(2);
        };
some messages are capured : 
ACK sip:800@192.168.1.188:5061 SIP/2.0
Record-Route: sip:192.168.1.26;ftag=78086448;lr=on
Via: SIP/2.0/UDP 192.168.1.26;branch=0
Via: SIP/2.0/UDP
211.25.2.30:5061;received=192.168.1.26;rport=5061;branch=z9hG4bK255A602DB910243AC238B003FB36CE58
From: 333 sip:333@192.168.1.26:5061;tag=78086448
To: sip:800@192.168.1.26;tag=542148979
Contact: sip:333@211.25.2.30:5061
Call-ID: 0CF994AF-C18C-4447-A6D3-758FF4EB99A8@192.168.1.26
CSeq: 9213 ACK
Max-Forwards: 16
Content-Length: 0
SIP/2.0 200 Ok
Via: SIP/2.0/UDP
211.25.2.30:5061;received=192.168.1.26;rport=5061;branch=z9hG4bK7D8A9CF509DF4CAC2EB9DF19BEB26EE3
From: 333 sip:333@192.168.1.26:5061;tag=78086448
To: sip:800@192.168.1.26;tag=542148979
Contact: sip:800@192.168.1.188:5061
Call-ID: 0CF994AF-C18C-4447-A6D3-758FF4EB99A8@192.168.1.26
CSeq: 9214 BYE
Server: X-Lite release 1105d
Content-Length: 0
2(2160) WARNING:vqm_resize: resize(0) called
 2(2160) DEBUG: add_to_tail_of_timer[2]: 0x422c2440
 2(2160) DEBUG: reply relayed. buf=0x8103438: SIP/2.0 2...,
shmem=0x422c3e68: SIP/2.0 2
 2(2160) DBG: trans=0x422c23f8, callback type 128, id 0 entered
 2(2160) ACC: transaction answered: method=BYE,
i-uri=sip:800@192.168.1.188:5061, o-uri=sip:800@192.168.1.188:5061,
call_id=0CF994AF-C18C-4447-A6D3-758FF4EB99A8@192.168.1.26, from=333
I know there is something happened, maybe, somewhere is worng in route section. 
Please give me some suggestions! thanks in advance!
lizhong