Re: [RADIATOR] Account log to MySQL

2015-02-05 Thread Heikki Vatiainen
On 3.2.2015 23.39, Chad Roseburg wrote: > FailureQueryinsert into RADAUTHLOG (TIME_STAMP, > USERNAME, TYPE, REASON) values (%t, '%n', 0, %1) In addition to the other suggestions, I recommend either escaping the the information that is supplied by the user with %Quote, see '5

Re: [RADIATOR] Account log to MySQL

2015-02-03 Thread Hugh Irvine
Hello Chad - From what you show below, you have two “” lines - if this is not a typo it will certainly confuse the configuration file parser. The best way to debug is to set the Trace level to 4 (DEBUG) so you can see exactly what is happening. You set the Trace level in the configuration fil

Re: [RADIATOR] Account log to MySQL

2015-02-03 Thread Michael
If you have a lot of different devices, and lots of auth activity, I would suggest setting up your authlog sql table to have a unique index for user/type/reason, and an sql query that inserts, but if the same error already exists, just increment a count column and the timestamp. This way, if a