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!