Re: MYSQL and FR2

2010-06-08 Thread Natr Brazell
Alan, I'm not sure I understand what you mean with the following statement. "simply add those attributes (if present!) into the SQL that create the accounting INSERT/UPDATE commands - sql/mysql/dialup.conf - and ensure the table is ready for them! :-)" The particular part is (if present!). Can

Re: MYSQL and FR2

2010-06-07 Thread Natr Brazell
Thanks for the help Alan, I see what you mean now. I guess I assumed that the radacct database was more than a recording of session start and end times. Is there another table that I should be seeing user activity in? In other words I was thinking that user activity (ie. the commands they ente

Re: MYSQL and FR2

2010-06-07 Thread Alan Buxey
Hi, > > rad_recv: Accounting-Request packet from host x.x.x.120 port 51637, id=50, > length=95 > Acct-Status-Type = Interim-Update > Acct-Session-Id = "C2594B9A71DB" > Acct-Delay-Time = 0 > User-Name = "joe.bobuser" > NAS-Identifier = "M20" > Junip

MYSQL and FR2

2010-06-07 Thread Natr Brazell
I am looking for a good reference on how to integrate MYSQL and Freeradius. I've set up the basics and imported the schema's and modified the sql.conf file and the sites-enabled/default files. All starting and running fine. What I don't know about are how (if at all) you can log the rad_recv messa