Thread: MySQL - What Tables of Modified For New Users?

There will be an entry in the Users table and the Identities table, then once they start using the system they could have multiple entries in the Identities table, the Contacts table and if you have caching enabled then in the cache and messages tables too.

Thanks. Is there an simple solution I can use or how do other RC admins manage when someone leaves and their Linux shell account is removed. I don't want their accounts to linger with useless data in MySQL. Is there a simple solution to cleaning up MySQL once I remove a user from my mail server?

Hi there!

I have made a couple of bash-scripts to solve this nicely on my domain. Note that you need to know the RC user id of the user you need to remove (I usually map the RC user id to the linux uid when I create a RC user for convenience).

Run the following 5 SQL commands on your RC DB to remove a user:
DELETE FROM messages WHERE messages.user_id = <USERID>;
DELETE FROM cache WHERE cache.user_id = <USERID>;
DELETE FROM contacts WHERE contacts.user_id = <USERID>;
DELETE FROM identities WHERE identities.user_id = <USERID>;
DELETE FROM users WHERE users.user_id = <USERID> LIMIT 1;

If the RC user id of your user is 6 then replace <USERID> above with 6.

Please also note that users table must be the last one where you remove the user.

Hope this helps a bit.

~# Magnus