1

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.

2

Re: Modifying MYSQL database. What I am I missing?

1+2 are correct.