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:1...@10.32.0.97 | | | | | | | | | > sip:1...@10.32.0.97 | | NULL | > | 2 | ACK | 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 | > E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24 > 11:20:03 | 0 | | | sip:1...@10.32.0.97 | | | | | | | | | > sip:1...@10.32.0.97 | | NULL | > | 3 | BYE | 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 | > E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24 > 11:20:26 | 0 | | | sip:1...@10.32.0.97 | | | | | | | | | > sip:1...@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@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > -- Bogdan-Andrei Iancu www.voice-system.ro _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users