>> /etc/raddb/sql.conf[22]: Instantiation failed for module "sql"
>> /etc/raddb/sites-enabled/default[159]: Failed to load module "sql".
> Ищите ошибку в настройках сопряжения radius и mysql.вроде бы с этим поборолся - все ок. запускаю в тестовом режиме получаю сейчас такое:
d_recv: Access-Request packet from host 127.0.0.1 port 41738, id=152, length=57
User-Name = "piter"
User-Password = "09876"
NAS-IP-Address = 127.0.0.1
NAS-Port = 1812
+- entering group authorize {...}
++[preprocess] returns ok
[auth_log] expand: /var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d -> /var/log/radius/radacct/127.0.0.1/auth-detail-20110908
[auth_log] /var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d expands to /var/log/radius/radacct/127.0.0.1/auth-detail-20110908
[auth_log] expand: %t -> Thu Sep 8 18:33:57 2011
++[auth_log] returns ok
++[chap] returns noop
++[mschap] returns noop
[eap] No EAP-Message, not doing EAP
++[eap] returns noop
rlm_sql (sql): Reserving sql socket id: 4
[sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = '' ORDER BY id
[sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = '' ORDER BY priority
rlm_sql_mysql: MYSQL check_error: 1146 received
[sql] database query error, SELECT groupname FROM radusergroup WHERE username = '' ORDER BY priority: Table 'radius.radusergroup' doesn't exist
[sql] Error retrieving group list
[sql] Error processing groups; rejecting user
rlm_sql (sql): Released sql socket id: 4
++[sql] returns fail
Invalid user: [piter/09876] (from client 127.0.0.1 port 1812)
Using Post-Auth-Type Reject
+- entering group REJECT {...}
[attr_filter.access_reject] expand: %{User-Name} -> piter
attr_filter: Matched entry DEFAULT at line 11
++[attr_filter.access_reject] returns updated
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 152 to 127.0.0.1 port 41738
Waking up in 4.9 seconds.
Cleaning up request 0 ID 152 with timestamp +22
Не пойму почему WHERE username = '' пустое - странно
и второе 'radius.radusergroup' doesn't exist - она есть по идее
mysql> show tables;
+------------------+
| Tables_in_radius |
+------------------+
| nas |
| radacct |
| radcheck |
| radgroupcheck |
| radgroupreply |
| radpostauth |
| radreply |
| usergroup