Hi Nick,
As the data arrives correctly and complete to the RADIUS server, I guess
it is more a problem of RADIUS/CDRtool when come to missing data in the DB.
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 04/29/2013 10:17 PM, Nick Khamis wrote:
Hello Everyone,
We have setup opensips to work with freeradius using the CDTool documentation
however, some of the fields that are filled in the the radius log
file, for example:
Service-Type = SIP
Sip-Response-Code = 200
Sip-Method = Bye
Event-Timestamp = "Apr 29 2013 01:54:11 EDT"
Sip-From-Tag = "as3469a78c"
Sip-To-Tag = "as50c4af01"
is not showing up in the DB:
+-------------+-----------------+-----------+------------+----------+
| servicetype | sipresponsecode | sipmethod | sipfromtag | siptotag |
+-------------+-----------------+-----------+------------+----------+
| SIP | 0 | | | |
It's not everything, things like servicetype, Acct-Session-Id, and User-Name,
are consistent with the raidus log files. The dictionaries, and sql.conf
are taken from CDRTool project.
On a slightly unrelated, I had to add the following field to radacct schema
included with CDTTool, to stop some sql errors:
-- Added:
-- `FramedProtocol` varchar(15) NOT NULL default '',
-- `XAScendSessionSVRKey` varchar(15) NOT NULL default '',
PS Added the modification to the sql procedures as well...
Thanks in Advance,
Nick.
_______________________________________________
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
