I'm new to handling radius and I'm up the creak here. I've been laboring with freeradius. I finally have it using the mysql databases but I can't get the thing to
1) Return the right attributes on a user. 2) Work at all with user@realm. 3) Use the accounting tables. I'm using NTradping to try and figure it out and I followed the instructions as best I could at http://www.frontios.com/freeradius.html I am going to include a dump of the data in my mysql tables. I would REALLY be grateful if someone could point out to me what the hell I'm doing wrong!! (Sorry for the explicative. I've been pounding my head against the wall for the last 72 hours.) mysql> show tables; +------------------+ | Tables_in_radius | +------------------+ | dictionary | | nas | | radacct | | radcheck | | radgroupcheck | | radgroupreply | | radreply | | realmgroup | | realms | | usergroup | +------------------+ 10 rows in set (0.00 sec) mysql> select * from dictionary; Empty set (0.00 sec) (Pegasus is my laptop using NTRadPing) mysql> select * from nas; +----+---------+-----------+------------+------+-------+----------+-----------+------+ | id | nasname | shortname | ipaddr | type | ports | secret | community | snmp | +----+---------+-----------+------------+------+-------+----------+-----------+------+ | 1 | pegasus | pegasus | 64.7.8.154 | NULL | 5 | 18121812 | NULL | NULL | +----+---------+-----------+------------+------+-------+----------+-----------+------+ 1 row in set (0.00 sec) mysql> select * from radacct; +-----------+---------------+--------------+----------+------------+--------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+ | RadAcctId | AcctSessionId | AcctUniqueId | UserName | Realm | NASIPAddress | NASPortId | NASPortType | AcctStartTime | AcctStopTime | AcctSessionTime | AcctAuthentic | ConnectInfo_start | ConnectInfo_stop | AcctInputOctets | AcctOutputOctets | CalledStationId | CallingStationId | AcctTerminateCause | ServiceType | FramedProtocol | FramedIPAddress | AcctStartDelay | AcctStopDelay | +-----------+---------------+--------------+----------+------------+--------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+ | 1 | | | aarons | hotadz.com | | NULL | NULL | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | | | | Framed | PPP | 255.255.255.254 | NULL | NULL | +-----------+---------------+--------------+----------+------------+--------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+ 1 row in set (0.02 sec) mysql> select * from radcheck; +----+---------------------+-----------+----------+ | id | UserName | Attribute | Value | +----+---------------------+-----------+----------+ | 1 | aarons | Password | testing | | 2 | [EMAIL PROTECTED] | Password | 18121812 | | 3 | [EMAIL PROTECTED] | Password | testing | +----+---------------------+-----------+----------+ 3 rows in set (0.00 sec) mysql> select * from radgroupcheck; +----+-----------+-------------------+-----------------+ | id | GroupName | Attribute | Value | +----+-----------+-------------------+-----------------+ | 1 | test | Service-Type | Framed | | 2 | test | Framed-Protocol | PPP | | 3 | test | Framed-IP-Address | 255.255.255.254 | | 4 | test | Framed-IP-Netmask | 255.255.255.255 | | 5 | test | Idle-Timeout | 600 | | 6 | test | Session-Timeout | 28800 | +----+-----------+-------------------+-----------------+ 6 rows in set (0.01 sec) mysql> select * from radgroupreply; +----+-----------+-------------------+-----------------+ | id | GroupName | Attribute | Value | +----+-----------+-------------------+-----------------+ | 1 | test | Service-Type | Framed | | 2 | test | Framed-Protocol | PPP | | 3 | test | Framed-IP-Address | 255.255.255.254 | | 4 | test | Framed-IP-Netmask | 255.255.255.255 | | 5 | test | Idle-Timeout | 600 | | 6 | test | Session-Timeout | 28800 | +----+-----------+-------------------+-----------------+ 6 rows in set (0.00 sec) mysql> select * from radreply; +----+-------------------+-----------+------------+ | id | UserName | Attribute | Value | +----+-------------------+-----------+------------+ | 1 | [EMAIL PROTECTED] | realm | hotadz.com | +----+-------------------+-----------+------------+ 1 row in set (0.00 sec) mysql> select * from realmgroup; +----+------------+-----------+ | id | RealmName | GroupName | +----+------------+-----------+ | 1 | hotadz.com | test | +----+------------+-----------+ 1 row in set (0.00 sec) mysql> select * from realms; +----+------------+---------+----------+---------+ | id | realmname | nas | authport | options | +----+------------+---------+----------+---------+ | 1 | hotadz.com | pegasus | 1645 | | | 2 | mfxpop.com | pegasus | 1645 | | +----+------------+---------+----------+---------+ 2 rows in set (0.00 sec) mysql> select * from usergroup; +----+---------------------+------------+ | id | UserName | GroupName | +----+---------------------+------------+ | 1 | aarons | test | | 2 | [EMAIL PROTECTED] | hotadz.com | | 3 | [EMAIL PROTECTED] | test | +----+---------------------+------------+ 3 rows in set (0.00 sec) Thats a literal dump of my tables. I really don't know what I'm doing, what is dependant upon which or anything. I mostly filled the tables by tailing my SQL log, and comparing the the SQL statements with the documentation. Any help anyone can give me would SERIOUSLY be appreciated as I have until October 15 to have this thing operating. Thanks a TON! __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
