Possible to add a NAS in any MySQL table?
Hello everyone, I´ve been searching the net for answers but havent´been able to find any information about how to add a NAS in the MySQL tables instead of using the clients.conf file. It is possible to use one of the tables that comes with Freeradius? If it is possible, is there any "HOW to" guide for it somewhere? Best regards/ Peter Carlstedt _________________________________________________________________ Keep your friends updated—even when you’re not signed in. http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/soc...
Peter Carlstedt wrote:
Hello everyone,
I´ve been searching the net for answers but havent´been able to find any information about how to add a NAS in the MySQL tables instead of using the clients.conf file. It is possible to use one of the tables that comes with Freeradius? If it is possible, is there any "HOW to" guide for it somewhere?
sql.conf: --------- # Set to 'yes' to read radius clients from the database ('nas' table) # Clients will ONLY be read on server startup. For performance # and security reasons, finding clients via SQL queries CANNOT # be done "live" while the server is running. # readclients = yes # Table to keep radius client info nas_table = "nas" sql/${database}/dialup.conf: ---------------------------- nas_query = "SELECT id, nasname, shortname, type, secret FROM ${nas_table}" HTH Patric
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 W dniu 2009-12-09 08:42, Patric pisze:
Peter Carlstedt wrote:
Hello everyone,
I´ve been searching the net for answers but havent´been able to find any information about how to add a NAS in the MySQL tables instead of using the clients.conf file. It is possible to use one of the tables that comes with Freeradius? If it is possible, is there any "HOW to" guide for it somewhere?
sql.conf: ---------
# Set to 'yes' to read radius clients from the database ('nas' table) # Clients will ONLY be read on server startup. For performance # and security reasons, finding clients via SQL queries CANNOT # be done "live" while the server is running. # readclients = yes
# Table to keep radius client info nas_table = "nas"
sql/${database}/dialup.conf: ----------------------------
nas_query = "SELECT id, nasname, shortname, type, secret FROM ${nas_table}"
Hi, so, maybe You know, Patric, how I can insert into radacct table username from inner session, not outer session? - -- pozdrawiam Maciej Łukasz Wojszkun tel. +48698611234 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJLH6VdAAoJELZ0XRdrHMhc3oUH/23EWlCo/XJrHLdPMaM0CF1V kTATI2qqdBM/+XILt6ppvRhwiGGsqNHkIK+YW3nZqKgk9tcSmWClu/ECWajXAcBT rqGy1AhJLF2gpuyRHLMGJNRSd8EXjD0iHdyKpn3o6KVuQ2SvEBP0MaxAqvbXfca4 MoJ67sw3iZ9rYBEaKTWQsL4aePvPBfAIRqmyKfBn/PQpy2VRxhCX6ttDukoScRQz Qc85men6lRfBBSRlt3H00wI0yP4uhJZf/A3dHL/xDtGGIlnoAEez6kJ6fVojKZtb f2DB+lXthFV+rFw25+YvZaV46wYk4MWuJw3b9M6nWRhvImp0Fsh95jhoS9KI298= =AhoQ -----END PGP SIGNATURE-----
participants (4)
-
Maciej Łukasz Wojszkun -
Patric -
Peter Carlstedt -
tnt＠kalik.net