mysql errors when running freeradius

[Kenneth Grady]

look in sql/mysql/nas.sql

JamesWhetherly wrote:
> 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!
>
>