I have my freeradius working, I running slackware 12.1 with freeradius version 2.1.5. I used NTRAping utility to send packets to my freeradius server. I also used radtest and that was successful. So now I want to set freeradius with backend mysql database. I am looking for the script db_mysql.sql and cannot find this file. I installed mysql as a package, when I installed slackware. So, does that file even exist anymore? I have the radius book and the directory it shows doesn't contain any file with that name.
Read the SQL HOWTO at: http://wiki.freeradius.org/SQL_HOWTO. Also, look at the sql.conf file in the raddb directory and the mysql files in raddb/sql/mysql. You will want to read the information in admin.sql and schema.sql. Tim From: freeradius-users-bounces+tim.sylvester=networkradius.com@lists.freeradius.or g [mailto:freeradius-users-bounces+tim.sylvester=networkradius.com@lists.freer adius.org] On Behalf Of jon jon Sent: Tuesday, May 26, 2009 9:51 AM To: FreeRadius users mailing list Subject: next I have my freeradius working, I running slackware 12.1 with freeradius version 2.1.5. I used NTRAping utility to send packets to my freeradius server. I also used radtest and that was successful. So now I want to set freeradius with backend mysql database. I am looking for the script db_mysql.sql and cannot find this file. I installed mysql as a package, when I installed slackware. So, does that file even exist anymore? I have the radius book and the directory it shows doesn't contain any file with that name.
ok so after reading the admin.sql it looks like it is telling me what to type into my mysql, to create a default admin for radius,and so freeradius can read any table in sql, does it matter what I change localhost to or can it be anyname I want. guess I am seeing what I have to do but not fully understanding it. I am using a mysql book also but think that might be getting me more confused. jon On Tue, May 26, 2009 at 12:02 PM, Tim Sylvester < tim.sylvester@networkradius.com> wrote:
Read the SQL HOWTO at: http://wiki.freeradius.org/SQL_HOWTO. Also, look at the sql.conf file in the raddb directory and the mysql files in raddb/sql/mysql. You will want to read the information in admin.sql and schema.sql.
Tim
*From:* freeradius-users-bounces+tim.sylvester=networkradius.com@ lists.freeradius.org [mailto:freeradius-users-bounces+tim.sylvester<freeradius-users-bounces%2Btim.sylvester> =networkradius.com@lists.freeradius.org] *On Behalf Of *jon jon *Sent:* Tuesday, May 26, 2009 9:51 AM *To:* FreeRadius users mailing list *Subject:* next
I have my freeradius working, I running slackware 12.1 with freeradius version 2.1.5. I used NTRAping utility to send packets to my freeradius server. I also used radtest and that was successful. So now I want to set freeradius with backend mysql database. I am looking for the script db_mysql.sql and cannot find this file. I installed mysql as a package, when I installed slackware. So, does that file even exist anymore? I have the radius book and the directory it shows doesn't contain any file with that name.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
ok so after reading the admin.sql it looks like it is telling me what to type into my mysql, to create a default admin for radius,and so freeradius can read any table in sql, does it matter what I change localhost to or can it be anyname I want. guess I am seeing what I have to do but not fully understanding it. I am using a mysql book also but think that might be getting me more confused.
Well, change localhost to the IP address of your mysql database server. If your server is on local host *don't* change localhost into anything else. Ivan Kalik Kalik Informatika ISP
So far I haved followed instructions in the admin.sql file and the used the command: mysql -uroot -prootpass radius < schema.sql which creates a database called radius, that I am suppose to fill with some dummy data, is this right so far? I also uncommented the line- $INCLUDE sql.conf, in the radius.conf file. My mysql server is on the same machine as my freeradius server. Is there a certain line I should see now when I fire up my radius server in debug mode, saying it is using mysql to authenticate clients? Thank you for answering my questions! On Tue, May 26, 2009 at 2:45 PM, Ivan Kalik <tnt@kalik.net> wrote:
ok so after reading the admin.sql it looks like it is telling me what to type into my mysql, to create a default admin for radius,and so freeradius can read any table in sql, does it matter what I change localhost to or can it be anyname I want. guess I am seeing what I have to do but not fully understanding it. I am using a mysql book also but think that might be getting me more confused.
Well, change localhost to the IP address of your mysql database server. If your server is on local host *don't* change localhost into anything else.
Ivan Kalik Kalik Informatika ISP
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi,
So far I haved followed instructions in the admin.sql file and the used the command: mysql -uroot -prootpass radius < schema.sql which creates a database called radius, that I am suppose to fill with some dummy data, is this right so far? I also uncommented the line- $INCLUDE sql.conf, in the radius.conf file. My mysql server is on the same machine as my freeradius server. Is there a certain line I should see now when I fire up my radius server in debug mode, saying it is using mysql to authenticate clients?
you've populated SQL with radius table, you've enabled sql.conf to be read by uncommenting it.. now...have you edited sql.conf and the underlying config files eg ql/mysql/dialup.conf? finally, to use SQL for client AAA you need to uncomment the required lines in the server (virtual servers in 2.x) - eg within the authorise and authenicate sections (for example) alan
On Thu, May 28, 2009 at 2:04 AM, <A.L.M.Buxey@lboro.ac.uk> wrote:
Hi,
So far I haved followed instructions in the admin.sql file and the used the command: mysql -uroot -prootpass radius < schema.sql which creates a database called radius, that I am suppose to fill with some dummy data, is this right so far? I also uncommented the line- $INCLUDE sql.conf, in the radius.conf file. My mysql server is on the same machine as my freeradius server. Is there a certain line I should see now when I fire up my radius server in debug mode, saying it is using mysql to authenticate clients?
you've populated SQL with radius table, you've enabled sql.conf to be read by uncommenting it.. yes did that
now...have you edited sql.conf and the underlying config files eg ql/mysql/dialup.conf?
I edited sql.conf file but I didn't do anything to the dialup.conf file, why should I have, more reading now!
finally, to use SQL for client AAA you need to uncomment the required lines in the server (virtual servers in 2.x) - eg within the authorise and authenicate sections (for example)
did this had to read the radiusd.conf file to figure that one out. so as of right now I used the schema.sql to set up a empty database and made up some users in there in radcheck. I start my radius server in debugging mode and mysql server is now being used to authenticate users. I did a radtest with my users in mysql database and got an access accept message which is good. I also used ntraping to test and that was successful. This server right now is not in production, it is just for testing. Right now I am trying where to go next. should I try using chap instead of pap? Now that you asked if I edited the dialup.conf file I will do a littel reading.
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
now...have you edited sql.conf and the underlying config files eg ql/mysql/dialup.conf?
I edited sql.conf file but I didn't do anything to the dialup.conf file, why should I have, more reading now!
There is no dire need. There are things you need to edit if you want to use Stripped-User-Name or Simultaneous-Use. Ivan Kalik Kalik Informatika ISP
participants (4)
-
A.L.M.Buxey＠lboro.ac.uk -
Ivan Kalik -
jon jon -
Tim Sylvester