<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<font face="monospace">Hi all,<br>
<br>
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.<br>
<br>
Thus, how do i make domain and username recorded into database? <br>
<br>
# -- accounting parameters --<br>
modparam("acc", "log_level", 1)<br>
modparam("acc", "db_missed_flag", 3)<br>
modparam("acc", "db_flag", 1)<br>
modparam("acc", "failed_transactions", 1)<br>
modparam("acc", "report_cancels", 1)<br>
<br>
failure_route[1] {<br>
# we account missed incoming calls; previous statteful
processing<br>
# guarantees that retransmissions are not accounted<br>
acc_db_request("missed calls","missed_calls");<br>
revert_uri();<br>
if (t_check_status("486") || t_check_status("603")) {<br>
log(1,"User busy\n");<br>
} else if (t_check_status("480") || t_check_status("408")) {<br>
log(1,"User is unavailable\n");<br>
} else {<br>
log(1,"User is unavailable for unknown reason\n");<br>
}<br>
<br>
rewritehostport("202.73.10.7:5060");<br>
append_branch();<br>
t_relay_to_udp("202.73.10.7", "5060");<br>
<br>
}<br>
<br>
<br>
mysql> select sip_from,sip_status,sip_method,username,domain from
missed_calls;<br>
+----------------------------------------------+--------------+------------+----------+--------+<br>
| sip_from | sip_status |
sip_method | username | domain |<br>
+----------------------------------------------+--------------+------------+----------+--------+<br>
| <a class="moz-txt-link-rfc2396E" href="mailto:sip:10001@202.73.10.8"><sip:10001@202.73.10.8></a>;tag=ff2015eeb8c23171 | missed calls |
INVITE | n/a | n/a |<br>
| <a class="moz-txt-link-rfc2396E" href="mailto:sip:10001@202.73.10.8"><sip:10001@202.73.10.8></a>;tag=ff2015eeb8c23171 | missed calls |
CANCEL | n/a | n/a |<br>
| <a class="moz-txt-link-rfc2396E" href="mailto:sip:10001@202.73.10.8"><sip:10001@202.73.10.8></a>;tag=688a799e25d70d76 | missed calls |
INVITE | n/a | n/a |<br>
| <a class="moz-txt-link-rfc2396E" href="mailto:sip:10001@202.73.10.8"><sip:10001@202.73.10.8></a>;tag=9da5279e291e12cc | missed calls |
INVITE | n/a | n/a |<br>
| <a class="moz-txt-link-rfc2396E" href="mailto:sip:10001@202.73.10.8"><sip:10001@202.73.10.8></a>;tag=1fbde47420f30ff2 | missed calls |
INVITE | n/a | n/a |<br>
| <a class="moz-txt-link-rfc2396E" href="mailto:sip:10001@202.73.10.8"><sip:10001@202.73.10.8></a>;tag=bde153a0cf74ce23 | missed calls |
INVITE | n/a | n/a |<br>
| <a class="moz-txt-link-rfc2396E" href="mailto:sip:10001@202.73.10.8"><sip:10001@202.73.10.8></a>;tag=bc3362f1cb8b0f64 | missed calls |
INVITE | n/a | n/a |<br>
+----------------------------------------------+--------------+------------+----------+--------+<br>
9 rows in set (0.00 sec)</font><br>
<br>
Regards<br>
Seong<br>
</body>
</html>