Cannot reuse previously deleted email address

[TGates]

To solve the client account issue where, if you delete a client and then one day want to add a new client with the same email address, the following file is all that needs changing:

Code:

/etc/sentora/panel/dryden/ctrl/users.class.php

the last function at the bottom, "CheckUserEmailIsUnique", has a line:

Code:

$sql = "SELECT COUNT(*) FROM x_accounts WHERE LOWER(ac_email_vc)=:email";

change this to:

Code:

$sql = "SELECT COUNT(*) FROM x_accounts WHERE LOWER(ac_email_vc)=:email AND ac_deleted_ts IS NULL";

and save the file.

You will now be able to create a client account using an email address that was used before to create an account that has since been deleted. It does NOT allow multiple active accounts with the same email address, as that would just be silly.

This modification does not increase, allow or create any additional opportunities for spam.

If the issue is to do with email addresses being left in tables when mailboxes/aliases/forwarders/dist lists are deleted, the only thing I am aware of there being an issue with is mailboxes left in the Postfix database, which I discussed (and proposed the fix for) this in this thread a while back:

http://forums.sentora.org/showthread.php?tid=10597

I'm fairly sure I have been able to create a mailbox for a client, then later delete it, and then even later, create it again for the same client or another client if they want it moving, etc.

I could be wrong - but it would be really useful for that step-by-step description of how to recreate an error with this as I am not seeing any.

Keith.

I like this solution. I will add it to the master. I'm not sure why it wasn't done this way originally. And, you will still have a record of all the times the same email was deleted/re-used.

Thanks Keith!

I will also take a look at the proposed postfix fix too.