Thor Spruyt wrote: > Drew Decker wrote: > > > Is it possible to log the failed attempts to a mysql database? I > > would like to develop a web interface for the technical support > > staff to let them view the Failed attempts with out having to > > teach them how to use SSH etc. If this is possible to do could you > > point me to a how-to or at least give me a little information on > > where to get started? Thanks for you help in advance > > Install msyslog. That's a syslog server to replace the standard > syslog server. Msyslog can put all syslog messages in a MySql > database after which you can extract the necessary info from the > database.
The first point is you'll get a lot of useless data, but that's not an important issue. The second point is you'll only get the login / password in the database. For example the hotline staff may need the Calling-Station-Id too. Therefore you need the rlm_sql module to execute the SQL query of your choice after authentication. -- Nicolas Baradakis - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
