Hi all.
The problems start when I configure FreeRadius to insert RADIUS
accounting data into SQL, in my case - postgreSQL database. I followed
the steps on http://wiki.freeradius.org/SQL_HOWTO. FreeRadius creates
SQL insert indeed, as you can see down below, but the thing is that the
data from this table is totally useless, as e.g. acctstartime and
acctstoptime fields are equal, which doesn't make sense. If we see the
/var/log/radius/radacct/127.0.0.1/detail-20080107 file (see above), we
can see that all of the AvPs are created in the SQL table, except the
ones which have "Asterisk" as prefix (e.g. Asterisk-Acc-Code,
Asterisk-Src, etc). I thought that FreeRadius will somehow map these
values from Asterisk to values which can be put to radacct table, e.g.
Asterisk-Start-Time ---> acctstarttime, etc. Obviously, it doesn't. I've
been googling for whole day concerning this problem, and I wasn't able
to find anything related to it, so probably other users had no problems
with that. I assume that I would have to create a custom table for
supporting asterisk RADIUS packets, but I wasn't able to find anything
on google. I would appreciate any kind of help, hint, or advice.
Paweł Plato
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
