On Fri 01 Sep 2006 17:42, ZaiPower wrote: > Hello: > > I'd like to know if it is possible to save all the info under the log > directory "radacct" (connections' details by client's IP) in MySQL instead > of files in hard disk.
Yes. This is certainly possible. > Are all the variables accessible?. I mean, are they valid for an SQL > sentence in 'postauth_query' variables %{Packet-Type}, %{User-Name}, > %{User-Password}, %{NAS-IP-Address}, %{NAS-Port} and %{Client-IP-Address}? > Am I missing any other info? 'postauth_query' is funnily enough related to postauth, NOT Accounting. Please read http://wiki.freeradius.org/index.php/Rlm_sql > After reading the answer > (http://wiki.freeradius.org/index.php/FAQ#How_do_I_log_failed_login_attempt >s_in_a_SQL_database.3F) to the question "How do I log failed login attempts > in a SQL database?" in the FreeRadius wiki it seems it is possible with > adequate SQL sentences. Yes. Do you want to log unsuccessfull logins or (successfull) accounting info to SQL? > I see three problems: > - I don't see clearly how to separate successfully authentication of > unsuccessfull. Maybe like this? How could I tell FreeRadius different > queries depending on type of request? > > post-auth { > # Login successful: get an address from the IP pool. > ippool > > Post-Auth-Type ACCEPT { > sql > } > > Post-Auth-Type REJECT { > # Login failed: log to SQL database. > sql > } > } > Please reread this. It is very clear. > - Where I can find documentation about the different packet types and their > data? Your NAS documentation "may" contain this info. You can also read http://www.ietf.org/rfc/rfc2865.txt http://www.ietf.org/rfc/rfc2866.txt > - Is it possible to tell FreeRadius that I want to send more than one query > to MySQL? More than one query for what? > I really want this functionality (keep the connection logs in MySQL, not in > the filesystem). I make this question to know if I am in the right path or > ideally if anybody has already make something like this. Excellent. This functionality exists. Enjoy :-) -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc
pgpM6cTAdx41u.pgp
Description: PGP signature
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html