Acc table

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Acc table

Nhadie
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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Acc table

k1028
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