All mailboxes removed

Discussion in 'General' started by republicus, Mar 30, 2020.

  1. republicus

    republicus New Member

    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?
     
  2. Jesse Norell

    Jesse Norell ISPConfig Developer ISPConfig Developer

    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.
     
  3. republicus

    republicus New Member

    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?
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    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?
     
  5. republicus

    republicus New Member

  6. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  7. republicus

    republicus New Member

    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.

    upload_2020-4-1_16-45-44.png
     
  8. republicus

    republicus New Member

    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.

    upload_2020-4-1_17-4-36.png

    Sorry to waste your time. I do appreciate all of your assistance
     
    Steini86, Th0m and Jesse Norell like this.
  9. Th0m

    Th0m ISPConfig Developer ISPConfig Developer

    I think this happened to all of us once - maybe twice ;)
     

Share This Page