MAC authenticating with mySQL database
Hi all! I have been trying to read up on MAC authentication and implementing that into a sql database. The MAC authentication with a userfile was no problem. But i hit the wall when i wanted to use a database instead of text file. Is there any good HOWTO's out there on this one? The configuration of the intended network. Radius server--->wifi-routers with MAC auth--->clients The reason for this MAC authentication is for engineers to have access to internet on sites we have equipment on. But not the users of the equipment. And the reason for wanting to implement sql database to store MAC addresses in, is to make it easier for admins to edit and that we want to implement other software to also use the info for our engineers. Cheers. -- Kjell Christian Bruheim Helpdesk Supportingit
Kjell Bruheim wrote:
I have been trying to read up on MAC authentication and implementing that into a sql database. The MAC authentication with a userfile was no problem. But i hit the wall when i wanted to use a database instead of text file. Is there any good HOWTO's out there on this one?
The schema in SQL mirrors the format of the "users" file. Do you have a *specific* question about something? i.e. what to put in SQL, how to put it in SQL, etc? Or are you just saying "it doesn't work"? Alan DeKok.
hi , i have setup mysql database with free radius server.if you have any quest from building to connecting then let me know.on which stage your are ...and what steps yuor are going to perform.hope you will get reply with in couple of days and connceted to database. best regards yawar hadi On Thu, Aug 7, 2008 at 11:13 AM, Alan DeKok <aland@deployingradius.com>wrote:
Kjell Bruheim wrote:
I have been trying to read up on MAC authentication and implementing that into a sql database. The MAC authentication with a userfile was no problem. But i hit the wall when i wanted to use a database instead of text file. Is there any good HOWTO's out there on this one?
The schema in SQL mirrors the format of the "users" file.
Do you have a *specific* question about something? i.e. what to put in SQL, how to put it in SQL, etc?
Or are you just saying "it doesn't work"?
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Yawar Hadi Noshahi QAU Islamabad (+92-0300-5504798)
Alan DeKok skrev:
Kjell Bruheim wrote:
I have been trying to read up on MAC authentication and implementing that into a sql database. The MAC authentication with a userfile was no problem. But i hit the wall when i wanted to use a database instead of text file. Is there any good HOWTO's out there on this one?
The schema in SQL mirrors the format of the "users" file.
Do you have a *specific* question about something? i.e. what to put in SQL, how to put it in SQL, etc?
Or are you just saying "it doesn't work"?
Alan DeKok.
To clarify a bit. users file have these entries for mac auth: 000000-000000 Auth-Type := Local, User-Password == "000000-000000" And i am not sure what to put where in the sql database. How to put data into the sql database, is not the problem. But what. I have inserted all the tables in the sql/mysql folder. So it would be nice if someone knew where to put the data and what of that string above should go in to the database. Or point me to a good HOWTO. Cheers -- Kjell Christian Bruheim Helpdesk Supportingit
have you connected freeradius server with mysql databsse ? first ans this then we will move onword On Thu, Aug 7, 2008 at 11:44 AM, Kjell Bruheim <kjell@supportingit.com>wrote:
Alan DeKok skrev:
Kjell Bruheim wrote:
I have been trying to read up on MAC authentication and implementing that into a sql database. The MAC authentication with a userfile was no problem. But i hit the wall when i wanted to use a database instead of text file. Is there any good HOWTO's out there on this one?
The schema in SQL mirrors the format of the "users" file.
Do you have a *specific* question about something? i.e. what to put in SQL, how to put it in SQL, etc? Or are you just saying "it doesn't work"?
Alan DeKok.
To clarify a bit.
users file have these entries for mac auth: 000000-000000 Auth-Type := Local, User-Password == "000000-000000"
And i am not sure what to put where in the sql database. How to put data into the sql database, is not the problem. But what. I have inserted all the tables in the sql/mysql folder. So it would be nice if someone knew where to put the data and what of that string above should go in to the database. Or point me to a good HOWTO.
Cheers
-- Kjell Christian Bruheim Helpdesk Supportingit
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Yawar Hadi Noshahi QAU Islamabad (+92-0300-5504798)
Kjell Bruheim wrote:
users file have these entries for mac auth: 000000-000000 Auth-Type := Local, User-Password == "000000-000000"
We *have* seen MAC address authentication before. Some comments: 1) Don't set Auth-Type. 2) Use "Cleartext-Password := ...", not "User-Password == ..." See the FAQ for an example.
And i am not sure what to put where in the sql database. How to put data into the sql database, is not the problem. But what. I have inserted all the tables in the sql/mysql folder. So it would be nice if someone knew where to put the data and what of that string above should go in to the database. Or point me to a good HOWTO.
You insert the text into the appropriate fields in the radcheck table. See the schema for the names of the fields. The fields are named *descriptively*... i.e. if you read the schema, it should be pretty obvious what's going on. And yes, this is not the complete hand-holding you asked for. There are good reasons for this. You need to *understand* your system. Blindly following instructions doesn't help. Alan DeKok.
participants (3)
-
Alan DeKok -
Kjell Bruheim -
Yawar Hadi