[OpenSIPS-Users] 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 at 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.