On 14/05/12 14:40, Efx Efx wrote:
CREATE TABLE `Resv` ( `Username` varchar(20) NOT NULL, `Start-Time` int(11) NOT NULL, `End-Time` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Hyphens? Really? Bad idea. Stick to all lower-case letters and underscore.
*This is my output:*
# Executing section authorize from file /etc/freeradius/sites-enabled/default +- entering group authorize {...} sql_xlat expand: %{User-Name} -> ieva sql_set_user escaped user --> 'ieva' expand: select Start_time from Resv where Username='%{User-Name}' -> select Start_time from Resv where Username='ieva' rlm_sql (sql): Reserving sql socket id: 3 rlm_sql_mysql: MYSQL check_error: 1054 received rlm_sql (sql): database query error, select Start_time from Resv where
This is a basic SQL error. Your query is wrong.
Username='ieva': Unknown column 'Start_time' in 'field list'
Because you have defined the table with "start-time" not "start_time"