28 Jul
2005
28 Jul
'05
2:29 a.m.
Hello, guys:
I sent a help message to you before since I got problems in acc
tables. Now i made some changes, and it finally works. thanks you for
guys. now I want to share my tips to you who are need acc records,
because many people have this problem.
first, make sure that you must confiugre Makefile in acc module and
recompile it properly.
second load acc module into ser.cfg.
third, put all necessary into ser and route section.
please follow the sequences. maybe some parts are not really
necessary. but there is data in acc.
Now i show you my ser.cfg.
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("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)
modparam("rr", "enable_full_lr", 1)
modparam("acc", "db_flag", 1)
# Record Route Section
# testing from
zhu-----------------------------------------------------------------
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);
};
this is data section received from acc table of mysql:
| 333 <sip:333@192.168.1.26:5061>;tag=249979601 |
<sip:800@192.168.1.26>;tag=1273583692 | 200
| INVITE | sip:800@192.168.1.188:5061 |
sip:800@192.168.1.188:5061 | sip:333@192.168.1.26:5061 |
sip:800@192.168.1.26 |
4E916DD5-2141-3B23-08CC-6F2CEA3B405B(a)192.168.1.26 | 333 |
192.168.1.26 | 249979601 | 1273583692 | 2005-07-28 01:50:01 |
20050728095001 | 0 | 0
|
| 333 <sip:333@192.168.1.26:5061>;tag=249979601 |
<sip:800@192.168.1.26>;tag=1273583692 | 200
| ACK | sip:800@192.168.1.188:5061 |
sip:800@192.168.1.188:5061 | sip:333@192.168.1.26:5061 |
sip:800@192.168.1.26 |
4E916DD5-2141-3B23-08CC-6F2CEA3B405B(a)192.168.1.26 | 333 |
192.168.1.26 | 249979601 | 1273583692 | 2005-07-28 01:50:01 |
20050728095001 | 0 | 0
|
| 333 <sip:333@192.168.1.26:5061>;tag=249979601 |
<sip:800@192.168.1.26>;tag=1273583692 | 200
| BYE | sip:800@192.168.1.188:5061 |
sip:800@192.168.1.188:5061 | sip:333@192.168.1.26:5061 |
sip:800@192.168.1.26 |
4E916DD5-2141-3B23-08CC-6F2CEA3B405B(a)192.168.1.26 | 333 |
192.168.1.26 | 249979601 | 1273583692 | 2005-07-28 01:50:03 |
20050728095003 | 0 | 0
|
try it!