rlm_sql_getvpdata: database query error

tnt at kalik.net tnt at kalik.net
Thu Mar 26 20:30:31 CET 2009


>radius_xlat:  'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheckAttribute,radgroupcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE usergroup.Username = '0021709d3d47' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
>rlm_sql_mysql: MYSQL check_error: 1146 received
>rlm_sql_getvpdata: database query error
>radius_xlat:  'SELECT id, UserName, Attribute, Value, op           FROM radreply           WHERE Username = '0021709d3d47'           ORDER BY id'
>radius_xlat:  'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreplyAttribute,radgroupreply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE usergroup.Username = '0021709d3d47' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
>rlm_sql_mysql: MYSQL check_error: 1146 received
>rlm_sql_getvpdata: database query error

Hm, mysql error 1146 is - table does not exist. Do you have
radgroupcheck, radgroupreply and usergroup tables in your radius
database? Are the names correct? If you made them using script provided
with the server this shouldn't happen.

Ivan Kalik
Kalik Informatika ISP




More information about the Freeradius-Users mailing list