[isf-wifidog] Deleting users

[Dana Spiegel]

I've done this. Its not pretty, but it works. In reality, you need to  
also delete the entries in the statistics table that refer to the  
users you want to purge.

Also, its much easier if you use phpPgAdmin for your database  
management, so you don't need to dump and reload. you can just delete  
the statistics entries, then delete the users.

Dana Spiegel
Executive Director
NYCwireless
dana at NYCwireless.net
www.NYCwireless.net
+1 917 402 0422

Read the Wireless Community blog: http://www.wirelesscommunity.info


On Feb 6, 2006, at 6:39 PM, Ray Gwinn wrote:

> There may be a way to delete users, but a dangerous way.  Use  
> pg_dump to dump the wifidog
> database in plain text.  Use a text editor to delete the unwanted  
> users.  Then delete the wifidog
> database and rebuild it using psql.
>
> I have not done this, so I suggest that anyone that tries it to  
> test a lot before doing it on a
> production system.
>
> Ray
>
> On 6 Feb 2006 at 17:40, Gabe Sawhney wrote:
>
>> On 2/6/06, Max Horváth <max.horvath at maxspot.de> wrote:
>>>> I cannot find a method to delete users, is there a way?
>>>
>>> No! And there won't be a way. Deleting a user would invalidate the
>>> statistics.
>>
>> What do you mean by "invalidate the statistics"?  I've created approx
>> one billion test accounts for myself (which I'll never actually use)
>> which one day I want to go in and delete.  Is there some reason  
>> for me
>> not to do this?
>>
>>
>>> This is correct. If a user doesn't reply the validation mail, he's
>>> out of your network. To create a new account he needs another e- 
>>> mail-
>>> address. After the third or fourth time of signing up and getting
>>> kicked out he'll validate his e-mail-address or he'll never use the
>>> network again. ;)
>>
>> Of course, the other solution is to (from a validated wifidog  
>> account,
>> or from a non-wifidog 'net connection), click on the "resend
>> validation email" to give yourself a second chance on the original
>> account, and not have to set up another one with an alternate email
>> address.
>>
>> Gabe
>> _______________________________________________
>> WiFiDog mailing list
>> WiFiDog at listes.ilesansfil.org
>> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
>
>
> _______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listes.ilesansfil.org/pipermail/wifidog/attachments/20060207/256ffbd8/attachment.html