mysql errors when running freeradius

[JamesWhetherly]

Hi Alan, 

Thanks for the reply. I am pretty new to unix, and started playing around
with it about 6 weeks ago!

I am trying to use radtest at the moment and haven't added any clients as i
am awaiting the arrival of my new base station. So i haven't added any new
clients. 

I have used the schema that was located in side raddb/sql/mysql/schema.sql.
So the database looks like this:

mysql> show tables;
+------------------+
| Tables_in_radius |
+------------------+
| radacct          | 
| radcheck         | 
| radgroupcheck    | 
| radgroupreply    | 
| radpostauth      | 
| radreply         | 
| radusergroup     | 
+------------------+

Only one of those tables looks like it is to do with NAS's, which is
radacct:

mysql> describe radacct;
+----------------------+-------------+------+-----+---------+----------------+
| Field                | Type        | Null | Key | Default | Extra         
|
+----------------------+-------------+------+-----+---------+----------------+
| radacctid            | bigint(21)  | NO   | PRI | NULL    | auto_increment
| 
| acctsessionid        | varchar(32) | NO   | MUL |         |               
| 
| acctuniqueid         | varchar(32) | NO   | MUL |         |               
| 
| username             | varchar(64) | NO   | MUL |         |               
| 
| groupname            | varchar(64) | NO   |     |         |               
| 
| realm                | varchar(64) | YES  |     |         |               
| 
| nasipaddress         | varchar(15) | NO   | MUL |         |               
| 
| nasportid            | varchar(15) | YES  |     | NULL    |               
| 
| nasporttype          | varchar(32) | YES  |     | NULL    |               
| 
| acctstarttime        | datetime    | YES  | MUL | NULL    |               
| 
| acctstoptime         | datetime    | YES  | MUL | NULL    |               
| 
| acctsessiontime      | int(12)     | YES  | MUL | NULL    |               
| 
| acctauthentic        | varchar(32) | YES  |     | NULL    |               
| 
| connectinfo_start    | varchar(50) | YES  |     | NULL    |               
| 
| connectinfo_stop     | varchar(50) | YES  |     | NULL    |               
| 
| acctinputoctets      | bigint(20)  | YES  |     | NULL    |               
| 
| acctoutputoctets     | bigint(20)  | YES  |     | NULL    |               
| 
| calledstationid      | varchar(50) | NO   |     |         |               
| 
| callingstationid     | varchar(50) | NO   |     |         |               
| 
| acctterminatecause   | varchar(32) | NO   |     |         |               
| 
| servicetype          | varchar(32) | YES  |     | NULL    |               
| 
| framedprotocol       | varchar(32) | YES  |     | NULL    |               
| 
| framedipaddress      | varchar(15) | NO   | MUL |         |               
| 
| acctstartdelay       | int(12)     | YES  |     | NULL    |               
| 
| acctstopdelay        | int(12)     | YES  |     | NULL    |               
| 
| xascendsessionsvrkey | varchar(10) | YES  |     | NULL    |               
| 
+----------------------+-------------+------+-----+---------+----------------+

I noticed theres a line that states 'readclients' in the sql.conf. the
comments talk about looking at a table called 'nas' like you suggested. If i
was set this to 'no' would this then allow me to still use sql but read from
the clients.conf instead?

I have been playing around with it all day today and now i can get radius to
the "ready to progress request" stage. When i then try the test user i have
set up in in the sql database it doesn't like it. I used the sql guide once
again from the wiki and created a user called 'sqltest' and matched it to
'fredf' a dynamic user. The radiusd debug is show below:

Ready to process requests.
rad_recv: Access-Request packet from host 127.0.0.1 port 45849, id=210,
length=59
	User-Name = "sqltest"
	User-Password = "testpwd"
	NAS-IP-Address = 127.0.0.2
	NAS-Port = 1812
No authenticate method (Auth-Type) configuration found for the request:
Rejecting the user
Failed to authenticate the user.
Delaying reject of request 0 for 1 seconds
Going to the next request
Waking up in 0.9 seconds.
Sending delayed reject for request 0
Sending Access-Reject of id 210 to 127.0.0.1 port 45849
Waking up in 4.9 seconds.
Cleaning up request 0 ID 210 with timestamp +8
Ready to process requests.


Thanks for the help!

-- 
View this message in context: http://www.nabble.com/mysql-errors-when-running-freeradius-tp23977490p23983199.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.