<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<font face="Calibri, sans-serif" size="2">
<div>Hello,</div>
<div> </div>
<div>So I realized I didn’t have accounting to database enabled properly, </div>
<div>And added the following lines to my opensips.cfg:</div>
<div> </div>
<div>modparam("acc", "db_url", "mysql://<user>:<passwd>@localhost/opensips")</div>
<div>modparam("acc", "db_extra", "caller_id=$fu; callee_id=$tu")</div>
<div> </div>
<div>now I see there is an entry into the “acc” table:</div>
<div> </div>
<div> </div>
<div>mysql> select * from acc;</div>
<div>+----+--------+----------------------------------+----------+------------------------------------------+----------+------------+---------------------+--------+---------+---------+---------------------+---------------+------+--------+----------+--------------+------------+-------------+----------+---------------------+---------------+---------+</div>
<div>| id | method | from_tag | to_tag | callid | sip_code | sip_reason | time | cdr_id | src_uri | dst_uri | caller_id | caller_domain | rpid | src_ip | src_port | sip_proxy_ip
| user_agent | accountcode | amaflags | callee_id | callee_domain | contact |</div>
<div>+----+--------+----------------------------------+----------+------------------------------------------+----------+------------+---------------------+--------+---------+---------+---------------------+---------------+------+--------+----------+--------------+------------+-------------+----------+---------------------+---------------+---------+</div>
<div>| 1 | INVITE | 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 | E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24 11:20:03 | 0 | | | sip:1000@10.32.0.97 | | | | |
| | | | sip:1003@10.32.0.97 | | NULL |</div>
<div>| 2 | ACK | 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 | E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24 11:20:03 | 0 | | | sip:1000@10.32.0.97 | | | | |
| | | | sip:1003@10.32.0.97 | | NULL |</div>
<div>| 3 | BYE | 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 | E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24 11:20:26 | 0 | | | sip:1000@10.32.0.97 | | | | |
| | | | sip:1003@10.32.0.97 | | NULL |</div>
<div>+----+--------+----------------------------------+----------+------------------------------------------+----------+------------+---------------------+--------+---------+---------+---------------------+---------------+------+--------+----------+--------------+------------+-------------+----------+---------------------+---------------+---------+</div>
<div> </div>
<div> </div>
<div> </div>
<div>However, when I view from CDRViewer, the </div>
<div>Caller, Callee , and Leg Type fields for this entry are blank.</div>
<div> </div>
<div>Is this expected behavior? </div>
<div> </div>
<div> </div>
<div> </div>
</font>
<DIV>
<HR>
</DIV>
<DIV>This email message is for the sole use of the intended recipient(s) and may
contain confidential information. Any unauthorized review, use, disclosure
or distribution is prohibited. If you are not the intended recipient,
please contact the sender by reply email and destroy all copies of the original
message. </DIV>
<DIV>
<HR>
</DIV>
<P></P>
</body>
</html>