accounting in syslog

Luo, Frank Y.F. Mr. luoy at muohio.edu
Wed May 30 19:00:33 CEST 2012


Is there a way to send accounting log to syslog instead of detail file in radacct?

Also instead of sending it to sql db, i tried to use sql-file but it results in a lot of sql command (we really don't want to run the sql command later).  

INSERT INTO radacct (AcctSessionId, UserName, 	 NASIPAddress, FramedIPAddress, AcctStartTime, AcctStopTime, 	 AcctSessionTime, AcctTerminateCause) VALUES
                 	 ('4fc645a8/00:25:00:3e:e6:c2/188601', 'luoy', '172.18.47.242', 	 '172.25.128.186', '2012-05-30 12:07:04', '0', '0', '');
INSERT INTO radacct (AcctSessionId, UserName, 	 NASIPAddress, FramedIPAddress, AcctStartTime, AcctStopTime, 	 AcctSessionTime, AcctTerminateCause) VALUES
                 	 ('4fc645d8/10:40:f3:1c:a3:b4/188604', '1040f31ca3b4', '172.18.47.242', 	 '172.24.146.51', '2012-05-30 12:07:52', '0', '0', '
');


Also noticing the UserName part, a lot of times that a binary username is logged, like here "1040f31ca3b4", instead of the real name. How to fix this?

THanks for the help

Frank



More information about the Freeradius-Users mailing list