You need to use db_extra in order to capture the username and callednumber to log extra value that are not default. You also need to add the field in to the database.
Look in acc module db_extra and Pseudo Variables http://www.opensips.org/Resources/DocsCoreVar15#varpv to log extra variables This is from my modparam for db_extra. modparam("acc", "db_extra", "from_uri=$fU; to_uri=$tU; ip=$si; ua=$hdr(User-Agent)") $fU is from username variables and from_uri is the databse table field $tu is to URI variable and to_uri is the databse table field $si is source Ip and ip is the database table field $hdr(Use-Agent) is user agent headr informaiton and ua is the database table field. hope this help Nhadie wrote: > > Hi Guys, > > Newbie on opensips, i was able to mysql accounting, but when i looked at > the table logs: > > +----+--------+------------+------------+----------------------------------------------+----------+----------------------------------+---------------------+ > | id | method | from_tag | to_tag | callid > | sip_code | sip_reason | time > | > +----+--------+------------+------------+----------------------------------------------+----------+----------------------------------+---------------------+ > | 1 | INVITE | 8d9f7e51 | as619fe46d | > NDAwYzQ4NDMxMGU2Y2UxYzg3Njk0OWJhYzYwMjhlMTg. | 183 | Session > Progress | 2009-05-09 00:11:51 | > | 2 | INVITE | 8d9f7e51 | as619fe46d | > NDAwYzQ4NDMxMGU2Y2UxYzg3Njk0OWJhYzYwMjhlMTg. | 200 | OK > | 2009-05-09 00:11:57 | > > > I noticed that username of the caller and the number called are not on > that table, is there another table i should link to the acc? i looked at > dialog table but there's nothing on it. > > anything i missed? thanks in advanced. > > regards, > ron > > _______________________________________________ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > -- View this message in context: http://n2.nabble.com/Acc-table-tp2846361p2846421.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users