Hi all, I'm trying out ISPConfig3 and like to add ":LAYOUT=fs" to mail_location in dovecot. On my old server I had the following in /etc/dovecot/conf.d/10-mail.conf Code: ... mail_location = maildir:~/.maildir:LAYOUT=fs ... ISPConfig seems to ignore this setting and takes it from the database. When I add it to the password_query or the user_query in /etc/dovecot/dovecot-sql.conf it either complains about or ignores it. Is there a way to have subfolders in the email client also als subfolders in the filesystem? So basically I want to have "/" as folder separator instead of "." Thanks
The dovecot conf file is /etc/dovecot/dovecot.conf. Files in conf.d are not used at all on an ISPConfig system.
And if you want to concatenate a string in a SQL query, use the SQL concat command: https://www.w3schools.com/sql/func_mysql_concat.asp
This file will be overwritten when doing a ISPConfig update. In the future, you can use a separate file for custom settings: https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5988
Neither Code: mail_location = maildir:/home/vmail/%d/%u/Maildir:LAYOUT=fs in /etc/dovecot/dovecot.conf nor Code: user_query = SELECT email as user, maildir as home, CONCAT( maildir_format, ':', maildir, '/', IF(maildir_format='maildir','Maildir',maildir_format)),':LAYOUT=fs' as mail, uid, gid, CONCAT('*:storage=', quota, 'B') AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE (login = '%u' OR email = '%u') AND `disable%Ls` = 'n' AND server_id = '1' in /etc/dovecot/dovecot-sql.conf works. It just gets ignored.
Code: # doveadm user test1@xxx field value uid 5000 gid 5000 home /home/vmail/xxx/test1 mail maildir:/home/vmail/xxx/test1/Maildir:LAYOUT=fs quota_rule *:storage=0B sieve /home/vmail/xxx/test1/.sieve On my current server where it is working without ISPConfig and all config done in dovecot it is Code: # doveadm user administrator field value uid 1000 gid 1000 home /home/administrator mail maildir:~/.maildir:LAYOUT=fs system_groups_user administrator
What do you mean by "doesn't work"? Do you test with a mail client or with the doveadm tools? Already existing folders are not renamed, so the folder structure remains the same and you have to do that by hand.
With "does't work" I meant, folders are still created as ".folder.subfolder" etc. when I create folders in Thunderbird and not as "folder/subfolder". I also tried with adding Code: namespace inbox { separator = / inbox = yes } to dovecot.conf