[sql] expand: %{User-Name}
-> fredf
[sql] sql_set_user escaped user --> 'fredf'
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 = 'fredf'
ORDER BY id
[sql] User found in radcheck table
[sql] expand: SELECT id, username, attribute, value,
op FROM
radreply WHERE
username = '%{SQL-User-Name}'
ORDER BY id -> SELECT id, username, attribute, value,
op FROM
radreply WHERE
username = 'fredf'
ORDER BY id
[sql] expand: SELECT
groupname FROM
radusergroup WHERE
username = '%{SQL-User-Name}'
ORDER BY priority -> SELECT
groupname FROM
radusergroup WHERE
username = 'fredf'
ORDER BY priority
[sql] expand: SELECT id, groupname,
attribute, Value,
op FROM
radgroupcheck WHERE
groupname =
'%{Sql-Group}'
ORDER BY id -> SELECT id, groupname,
attribute, Value,
op FROM
radgroupcheck WHERE
groupname =
'dynamic' ORDER BY
id
rlm_sql_mysql: MYSQL check_error: 1146 received
rlm_sql_getvpdata: database query error
[sql] Error retrieving check pairs for group dynamic
[sql] Error processing groups; rejecting user
rlm_sql (sql): Released sql socket id: 4
++[sql] returns fail
<tim>
Error: 1146 SQLSTATE: 42S02 (ER_NO_SUCH_TABLE) Message: Table '%s.%s' doesn't exist
Use the MySQL client with the same user that FreeRADIUS uses to connect to MySQL. Then try the query that FR sent to MySQL:
SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'dynamic' ORDER BY id;
You should get the same error – 1146 and message with more information on the error.
Tim