Thx Bogdan,
Seems to be correct though: // what fields to show $show_field[0]['caller_id'] = "Caller" ; $show_field[1]['callee_id'] = "Callee" ; $show_field[2]['call_start_time'] = "Call Start Time"; $show_field[3]['duration'] = "Duration"; $show_field[4]['leg_type'] = "Leg Type"; I don't know what "leg_type" corresponds to, (no entry in the acc table afaik), but I do see caller_id and callee_id... but the CDRviewer is showing my call entry with these fields blanked out... -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bogdan-Andrei Iancu Sent: Wednesday, March 24, 2010 12:24 PM To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] OpenSIPs-CP CDRviewer question 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:[email protected] | | | | | | | | | > sip:[email protected] | | NULL | > | 2 | ACK | 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 | > E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24 > 11:20:03 | 0 | | | sip:[email protected] | | | | | | | | | > sip:[email protected] | | NULL | > | 3 | BYE | 1BB69EB7976D43D1FA7F0A976BCFF582 | 9b522302 | > E06F4B164B33933E42E1DC53B510F59D1133C657 | 200 | OK | 2010-03-24 > 11:20:26 | 0 | | | sip:[email protected] | | | | | | | | | > sip:[email protected] | | 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 > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > -- Bogdan-Andrei Iancu www.voice-system.ro _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
