Topic: Modifying MYSQL database. What I am I missing?
==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.6.7
- Deployed with iRedMail Easy or the downloadable installer? downloadable
- Linux/BSD distribution name and version: Ubuntu Server 22.04 LTS minimized
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? N
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
I have run iredmail for years and mailbox locations have gotten scattered a bit. I have the following base directories in my structure:
MariaDB [vmail]> select storagebasedirectory from mailbox;
+--------------------------------+
| storagebasedirectory |
+--------------------------------+
| /shares/email/some_domains.com |
| /shares/email/some_domains.com |
...
| /shares/email/some_domains.com |
| /shares/email_sandbox |
| /shares/email/some_domains.com |
| /shares/email |
| /shares/email/some_domains.com |
...
| /shares/email/some_domains.com |
+--------------------------------+
the sandbox entry was my mistake created during a migration and the /shares/email is the location the latest install of iredmail is putting newly created email accounts. The rest are carryovers from my original install years ago.
My two questions are:
1. Can I just move the vmail1 folder that are directly under one of these locations to another?
-AND-
2. Then can I just modify all entries of this column in this table of the moved vmail1 folder to the new location or is there a lot more involved?
I have already hunted down every config file and script I can find with "sandbox" in the name and scrubbed them so there's already a mismatch I need to fix which I think this would fix it...
THANKS!
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.