23 Aug
2005
23 Aug
'05
8:34 p.m.
Hi
you have to include "username Part of inbound Request-URI" in the
accounting packet using log_fmt parameter:
modparam("acc", "log_fmt", "miocfsp") # p = username Part
of inbound
Request-URI
rafael
On 8/19/05, Ah khng <akhng999(a)gmail.com> wrote:
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
--
rrgv