I have no idea what's happened but somehow all my mailbox accounts are no longer listed in ISPConfig. I suspect that it may be related to a bit of API code I am using in nextcloud for webmail but I cant be sure yet. Can someone help me locate what caused my mailboxes to be removed and if it be possible to restore them?
Are you logged in as an admin, reseller or client? Do they show for an admin? Try adding a mailbox with the ispconfig interface, perform a dump of dbispconfig, then run your api code to "break" that mailbox and dump dbispconfig again, then compare the two.
I am logged into admin. The mail accounts can still access their email with email client apps. But the ISPConfig interface shows nearly none of the mailboxes. It seems they are still in the database. I've not yet tried your suggestion as I try to figure out whats going on. Will your instructions be safe if the accounts still exist but are merely not showing on the interface?
Do you have a backup of your server which contains the ISPConfig database, so you can restore a recent version of the database which still contains the mailboxes?
Sadly Ive been out of state for a month and do not. The mailboxes are lightly used if I need to recreate them. But how can I prevent this? The API only uses get and update. So I wonder if this could be related to these old reported issues with update deleting mailboxes? https://www.howtoforge.com/communit...s-makes-ispconfig-delete-them-entirely.72980/
If the mailboxes are still working, then they must be still there on the hard disk. The issue you posted them on the harddisk, so your issue is something different. Please take a look into ispconfig database with e.g. phpmyadmin, mail_user table. if the mailboxes are still working, they must still exist on the shell (the files) and also in the ispconfig database has postfix and dovecot connects directly to them), so there must be a field or flag in the database records of the mailboxes be wrong which prevents them from showing up in the UI. If the mailboxes are still there, check which values the sys_* fields of one of these invisible mailboxes has.
Thanks @till . I am looking at the database and all of the mailboxes are present in the mail_user table. Below are some column fields for one mailbox not shown in the UI. I have 22 emails in the database, and only three appear on the UI. Comparing the three that do appear to the others: I see no noticeable reason in the database that the 19 other emails are not appearing. I've also not yet restarted any services or the server itself.
This can be marked as solved. Dumb rookie mistake on my end. My browser cached the mail filter so it was only showing support* emails. After numerous refreshes I finally noticed and manually removed my search field from a month or more ago. Sorry to waste your time. I do appreciate all of your assistance
