Forum OpenACS Q&A: How to delete invalid users from the system

1: How to delete invalid users from the system

Posted by Christof Spitz on 12/16/03 10:52 PM

Hi,

some users in our system entered invalid email-addresses. Although I deleted them in the acs-admin/users section, the system (bboard) still sends forum messages to them, which makes all other users furious, since these mails come back as undeliverable to the user who posted a message.

Could anybody tell me in which table(s) I have to delete this users forever?

Thanks!

2: Re: How to delete invalid users from the system (response to 1)

Posted by Don Baccus on 12/17/03 12:36 AM

What version of OpenACS are you using?

3: Re: How to delete invalid users from the system (response to 2)

Posted by Christof Spitz on 12/17/03 01:11 AM

Hi Don, its 4.6.2

4: Re: How to delete invalid users from the system (response to 1)

Posted by Caroline Meeks on 12/17/03 01:33 AM

In 5.0 notification-security-procs.tcl proc can_notify_user checks to see if the user state is active.

Take a look at that proc and where its called and maybe you can patch your system so it won't send notifications to "deleted" users.

You may also have to patch the bulk-mail module, does anyone know if that has a mechanism to prevent bulk mailing non-active usrers? One thing to test is if you create a spam to be sent in the future, then delete one of the users that it would have gone to, does the email get sent? It should not.

5: Re: How to delete invalid users from the system (response to 1)

Posted by Christof Spitz on 12/17/03 09:35 AM

Thanks, Caroline. I found the proc can_notify_user, which checks user_approved_p:

return [db_string user_approved_p {} -default 0]

Being a bloody beginner, I wonder where I might find a list or description of other parameters that can be checked ...