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