[OpenSIPS-Users] OpenSIPs-CP CDRviewer question

[Bogdan-Andrei Iancu]

Hi Christian,

you need to go into opensips-cp > trunk > config > tools > system > 
cdrviewer > local.inc.php file and configure the $show_field array to 
show you whatever columns you need. Probably by mistake, it is 
configured to show some columns that does not exists.

Regards,
Bogdan


Christian Vo wrote:
> Hello,
> So I realized I didn’t have accounting to database enabled properly,
> And added the following lines to my opensips.cfg:
> modparam("acc", "db_url", "mysql://<user>:<passwd>@localhost/opensips")
> modparam("acc", "db_extra", "caller_id=$fu; callee_id=$tu")
> now I see there is an entry into the “acc” table:
> mysql> select * from acc;
> +----+--------+----------------------------------+----------+------------------------------------------+----------+------------+---------------------+--------+---------+---------+---------------------+---------------+------+--------+----------+--------------+------------+-------------+----------+---------------------+---------------+---------+
> | 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 |
> +----+--------+----------------------------------+----------+------------------------------------------+----------+------------+---------------------+--------+---------+---------+---------------------+---------------+------+--------+----------+--------------+------------+-------------+----------+---------------------+---------------+---------+
> | 1 | INVITE | 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 | 
> E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24 
> 11:20:03 | 0 | | | sip:1000 at 10.32.0.97 | | | | | | | | | 
> sip:1003 at 10.32.0.97 | | NULL |
> | 2 | ACK | 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 | 
> E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24 
> 11:20:03 | 0 | | | sip:1000 at 10.32.0.97 | | | | | | | | | 
> sip:1003 at 10.32.0.97 | | NULL |
> | 3 | BYE | 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 | 
> E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24 
> 11:20:26 | 0 | | | sip:1000 at 10.32.0.97 | | | | | | | | | 
> sip:1003 at 10.32.0.97 | | NULL |
> +----+--------+----------------------------------+----------+------------------------------------------+----------+------------+---------------------+--------+---------+---------+---------------------+---------------+------+--------+----------+--------------+------------+-------------+----------+---------------------+---------------+---------+
> However, when I view from CDRViewer, the
> Caller, Callee , and Leg Type fields for this entry are blank.
> Is this expected behavior?
> ------------------------------------------------------------------------
> 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.
> ------------------------------------------------------------------------
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   


-- 
Bogdan-Andrei Iancu
www.voice-system.ro