On Wed, 28 Jul 2004, Ken A wrote: > > > Edgars wrote: > > i am writing my own program to get them in human-readable form:) > > > > Edgars > > > Yep. I made some changes that make it easier for me to start from > scratch with a language I'm more familiar with (perl) than to modify > dialupadmin to do what I want, especially since I'm not very good with > php, and there are many things in dialupadmin I would want to change.
What do you mean by that? > > I added a couple of columns to the radacct table, so my records include > several Ascend attributes not in the standard table: > (Ascend-Disconnect-Cause, Ascend-XmitRate, Ascend-DataRate). > > And, I was getting duplicate STOP records in the radacct table, so I > also put a unique index on (sessionid,username,nasipaddress) and changed > the INSERT STOP record in sql.conf to a "REPLACE INTO" instead of > "INSERT INTO" and that seems to have resolved the problem. > > Ken A > > > > Ken A wrote: > > > >> Those of you that use mysql with freeradius, can anyone recommend some > >> software for linux to process mysql radacct table logs? > >> Do you just roll your own scripts to query the logs and make reports? > >> Seems simple enough, but "what are others doing?" is always a good > >> question :-) > >> > >> Thanks, > >> > >> Ken A > >> > >> > >> > >> - List info/subscribe/unsubscribe? See > >> http://www.freeradius.org/list/users.html > >> > >> > > > > - List info/subscribe/unsubscribe? See > > http://www.freeradius.org/list/users.html > > > > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html