Re: How to reject/erase a user a day after his/her first login

2005-02-23 Thread Antonio J. Soler
Isn't there any way to change mysql sentence so it checks if there is no 'Expired' attribute, thus adding expired date? I tried this query (in raddb/sql.conf): postauth_query = INSERT into ${authcheck_table} (id, UserName, Attribute, op, Value) values (0, '%{User-Name}', 'Expired',

How to reject/erase a user a day after his/her first login

2005-02-22 Thread Antonio J. Soler
Hello, We have set up a radius server to manage user access from a hotel. Users are connected via PLC or WiFi. By now, we are using freeradius 1.0.1 running on a Debian 3.0 r3, and rlm_mysql module. I'd like to know if there is some way to clean a user from the database one day after his first

Re: How to reject/erase a user a day after his/her first login

2005-02-22 Thread Kostas Kalevras
On Tue, 22 Feb 2005, Antonio J. Soler wrote: Hello, We have set up a radius server to manage user access from a hotel. Users are connected via PLC or WiFi. By now, we are using freeradius 1.0.1 running on a Debian 3.0 r3, and rlm_mysql module. I'd like to know if there is some way to clean a user