[Serusers] missed_calls username and domain

Ah khng akhng999 at gmail.com
Sat Aug 20 06:28:29 CEST 2005


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 at 202.73.10.8>;tag=ff2015eeb8c23171 | missed calls |
INVITE     | n/a      | n/a    |
| <sip:10001 at 202.73.10.8>;tag=ff2015eeb8c23171 | missed calls |
CANCEL     | n/a      | n/a    |
| <sip:10001 at 202.73.10.8>;tag=688a799e25d70d76 | missed calls |
INVITE     | n/a      | n/a    |
| <sip:10001 at 202.73.10.8>;tag=9da5279e291e12cc | missed calls |
INVITE     | n/a      | n/a    |
| <sip:10001 at 202.73.10.8>;tag=1fbde47420f30ff2 | missed calls |
INVITE     | n/a      | n/a    |
| <sip:10001 at 202.73.10.8>;tag=bde153a0cf74ce23 | missed calls |
INVITE     | n/a      | n/a    |
| <sip:10001 at 202.73.10.8>;tag=bc3362f1cb8b0f64 | missed calls |
INVITE     | n/a      | n/a    |
+----------------------------------------------+--------------+------------+----------+--------+
9 rows in set (0.00 sec)

Regards
Seong
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20050820/304cefb1/attachment.htm>


More information about the sr-users mailing list