[isf-wifidog] Splash only & enforcing timeouts (reprise)

Han Boetes hboetes at utelisys.com
Mar 20 Avr 09:41:53 EDT 2010

On 04/19/2010 01:38 PM, Han Boetes wrote:
>  I'd rather avoid running unstable branches. I think I'll try to
>  implement something which regularly checks in postgres the mac addresses
>  which belong to splash_only_user and then remove them once they get
>  older than an hour.
>  If anyone with more postgres experience than me knows how to do that
>  properly please let me know. It seems you can easily do this in a
>  shell-script of a few lines, if you know the right postgres commands
>  that is.

Pfff easy:

psql wifidog -A -q -c "DELETE FROM public.connections, public.users 
WHERE (username='SPLASH_ONLY_USER' AND timestamp_in < current_timestamp 
- interval '1 hour') ORDER BY timestamp_in"

>  I already was doing that and accidentally removed the admin user. How
>  can I recreate that user without killing the current settings?

Run the installer again, it won't harm existing settings.

Met vriendelijke groet,

Han Boetes
Utelisys Communications B.V.

Plus d'informations sur la liste de diffusion WiFiDog