I have CDR logging to a MySQL server setup and it seems to be working.
I can’t figure out how to map the CDR records to SIP users.
For example, I register to Asterisk as
1234@pbx1
and I call an extension. The CDR record shows:
2006-06-05 15:03:00
"Jack Snodgrass" ( sent from the sip phone app I used )
(ditto)
jsnodgra (ditto)
date ( entension I called )
context-pbx2 ( contect for that extension )
SIP/192.168.1.15-0a062ec8 ( I assume that this maps to the sip user that made the call )
Hangup
10
10
ANSWERED
3
no where in there is the fact that I was using
1234@pbx1 as my sip extension. How do I get
SIP/192.168.1.15-0a062ec8
to map to my 1234@pbx1 registration?
Also… I have an accountcode defined for the
1234@pbx1 sip extension but the accountcode
field is blank.
What am I missing?
jack