Unix TimeStamp Based Login

[jomajo]

Yes Alan, shame on me. ( I wasn't sleeping for 30 hours right now :/ )

Now freeradius doesn't know what is current-time? And can do anything more?

# 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
sql_xlat finished
rlm_sql (sql): Released sql socket id: 3
        expand: %{sql:select start_time from resv where
username='%{User-Name}'} -> 1336995000
sql_xlat
        expand: %{User-Name} -> ieva
sql_set_user escaped user --> 'ieva'
        expand: select end_time from resv where username='%{User-Name}' ->
select end_time from resv where username='ieva'
rlm_sql (sql): Reserving sql socket id: 2
sql_xlat finished
rlm_sql (sql): Released sql socket id: 2
        expand: %{sql:select end_time from resv where
username='%{User-Name}'} -> 1337004000
        expand: %l -> 1337005165
++[request] returns notfound
++? if (Resv-Cur-Time < Resv-Start-Time)
Failed parsing "Resv-Start-Time": Unknown value Resv-Start-Time for
attribute Resv-Cur-Time
++? if (Resv-Cur-Time > Resv-End-Time)
Failed parsing "Resv-End-Time": Unknown value Resv-End-Time for attribute
Resv-Cur-Time
        expand: %{Resv-End-Time} - %{Resv-Cur-Time} -> 1337004000 -
1337005165
        expand: %{expr:%{Resv-End-Time} - %{Resv-Cur-Time}} -> -1165
++[reply] returns notfound

Thank you for your answers , they are really helpful!

--
View this message in context: http://freeradius.1045715.n5.nabble.com/Unix-TimeStamp-Based-Login-tp5708187p5709092.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.