## Reset the WebCache:
Go to GroupWare > WebClient > DB settings, see if its set to SQLite or a DB server.
A - If its SQLite, browse to the accounts mailbox then rename the ~webmail\cache.db file.
B - If it's a DB server do the following:
https://support.icewarp.com/hc/en-us/articles/115001317207-How-to-cleanup-one-specific-account-from-centralized-database
1 query: deleting from “Items” table:
DELETE i FROM item AS i INNER JOIN folder on i.folder_id = folder.folder_id
WHERE folder.account_id = 'user@domain.com'
2 query: deleting from “folder” Table
DELETE FROM folder WHERE folder.account_id = 'user@domain.com'
------------------
## Reset the directory cache:
Go to System > Tools > SQL manager then select the directory cache DB.
Run the following queries where the username is the account name in question.
SELECT * FROM DirectoryCache WHERE search_path like '%username%'
If the output is correct, turn it into a delete and remove the asterisk (*):
DELETE FROM DirectoryCache WHERE search_path like '%username%'
Once completed, go under the account settings and refresh the cache.
You might find that in the variable %username%, it will return records for other domains with the same usernames. So you can modify it such as %domainname.com/username/%
On Windows
SELECT * FROM DirectoryCache WHERE search_path like '%example.com\username%'
DELETE FROM DirectoryCache WHERE search_path like '%example.com\username%'
On Linux
SELECT * FROM DirectoryCache WHERE search_path like '%example.com/username%'
DELETE FROM DirectoryCache WHERE search_path like '%example.com/username%'
NOTE: Some instances are stubborn to refresh, in that case, try to do this when the user is not logged in.
For the more stubborn ones, even try to do a restart of services just to be sure to clear any current threads. You want to ensure no data is being added back until after all the queries are run.
--
Comments
0 comments
Article is closed for comments.