Hi all, I want to display missed calls in SERWEB, so i use acc_db_request to store the entry into table missed_calls. However, username and domain weren't recorded into database. While i noticed that serweb is comparing username and domain in sql WHERE cluase (method.get_missed_calls.php) which cause no records being display. Thus, how do i make domain and username recorded into database? # -- accounting parameters -- modparam("acc", "log_level", 1) modparam("acc", "db_missed_flag", 3) modparam("acc", "db_flag", 1) modparam("acc", "failed_transactions", 1) modparam("acc", "report_cancels", 1) failure_route[1] { # we account missed incoming calls; previous statteful processing # guarantees that retransmissions are not accounted acc_db_request("missed calls","missed_calls"); revert_uri(); if (t_check_status("486") || t_check_status("603")) { log(1,"User busy\n"); } else if (t_check_status("480") || t_check_status("408")) { log(1,"User is unavailable\n"); } else { log(1,"User is unavailable for unknown reason\n"); } rewritehostport("202.73.10.7:5060"); append_branch(); t_relay_to_udp("202.73.10.7", "5060"); } mysql> select sip_from,sip_status,sip_method,username,domain from missed_calls; +----------------------------------------------+--------------+------------+----------+--------+ | sip_from | sip_status | sip_method | username | domain | +----------------------------------------------+--------------+------------+----------+--------+ | <sip:10001@202.73.10.8>;tag=ff2015eeb8c23171 | missed calls | INVITE | n/a | n/a | | <sip:10001@202.73.10.8>;tag=ff2015eeb8c23171 | missed calls | CANCEL | n/a | n/a | | <sip:10001@202.73.10.8>;tag=688a799e25d70d76 | missed calls | INVITE | n/a | n/a | | <sip:10001@202.73.10.8>;tag=9da5279e291e12cc | missed calls | INVITE | n/a | n/a | | <sip:10001@202.73.10.8>;tag=1fbde47420f30ff2 | missed calls | INVITE | n/a | n/a | | <sip:10001@202.73.10.8>;tag=bde153a0cf74ce23 | missed calls | INVITE | n/a | n/a | | <sip:10001@202.73.10.8>;tag=bc3362f1cb8b0f64 | missed calls | INVITE | n/a | n/a | +----------------------------------------------+--------------+------------+----------+--------+ 9 rows in set (0.00 sec) Regards Seong _______________________________________________ Serusers mailing list serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers