Unix TimeStamp Based Login

[Phil Mayers]

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"