<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.30.2">
</HEAD>
<BODY LINK="#0000ff">
On Wed, 2010-09-08 at 22:14 -0700, Tim Sylvester wrote:
<BLOCKQUOTE TYPE=CITE>
[sql] expand: %{User-Name} -> fredf<BR>
[sql] sql_set_user escaped user --> 'fredf'<BR>
rlm_sql (sql): Reserving sql socket id: 4<BR>
[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<BR>
[sql] User found in radcheck table<BR>
[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<BR>
[sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = 'fredf' ORDER BY priority<BR>
[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<BR>
rlm_sql_mysql: MYSQL check_error: 1146 received<BR>
rlm_sql_getvpdata: database query error<BR>
[sql] Error retrieving check pairs for group dynamic<BR>
[sql] Error processing groups; rejecting user<BR>
rlm_sql (sql): Released sql socket id: 4<BR>
++[sql] returns fail<BR>
<BR>
<BR>
<BR>
<tim><BR>
<BR>
<BR>
<BR>
From the MySQL documentation:<BR>
<BR>
Error: <B>1146</B> SQLSTATE:<B>42S02</B> (<B><A HREF="http://dev.mysql.com/doc/refman/5.1/en/error-messages-server.html#error_er_no_such_table">ER_NO_SUCH_TABLE</A></B>) Message: Table '%s.%s' doesn't exist <BR>
<BR>
Use the MySQL client with the same user that FreeRADIUS uses to connect to MySQL. Then try the query that FR sent to MySQL:<BR>
<BR>
<BR>
<BR>
SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'dynamic' ORDER BY id;<BR>
<BR>
<BR>
<BR>
You should get the same error – 1146 and message with more information on the error.<BR>
<BR>
<BR>
<BR>
Tim<BR>
</BLOCKQUOTE>
<BR>
Sounds like you haven't created the table in your MySQL DB yet.
<BR>
</BODY>
</HTML>