Le 23/11/2012 12:59, Thomas Leuxner a écrit :
Am 23.11.2012 um 12:48 schrieb Mathieu R. <mathieu@400iso.net>:
Thank you. can i safely :
- close dovecot
- move files to ~Maildir
- change the config in docecot.conf
- and then restart dovecot ?
Yes. You are able to move the Maildir structure (cur|new|tmp) like this. Not sure the location is also overridden in your SQL queries. If so, you also need to return the new "home" in the queries.
Regards Thomas
As i'm very newbie at sql stuff, here is my current dovecot-sql.conf :
driver = mysql
connect = host=localhost dbname=postfix_db user=postfix_user
password=mypass
# The new name for MD5 is MD5-CRYPT so you might need to change this
depending on version
default_pass_scheme = MD5-CRYPT
# Get the mailbox
user_query = SELECT '/srv/vmail/%d/%u' as home,
'maildir:/srv/vmail/%d/%u' as mail, 5000 AS uid, 5000 AS gid,
concat('dirsize:storage=', quota) AS quota FROM mailbox WHERE username
= '%u' AND active = '1'
# Get the password
password_query = SELECT username as user, password, '/srv/vmail/%d/%u'
as userdb_home, 'maildir:/srv/vmail/%d/%u' as userdb_mail, 5000 as
userdb_uid, 5000 as userdb_gid FROM mailbox WHERE username = '%u' AND
active = '1'
# If using client certificates for authentication, comment the above
and uncomment the following
#password_query = SELECT null AS password, '%u' AS user
i think i can change it for :
driver = mysql connect = host=localhost dbname=postfix_db user=postfix_user password=mypass # The new name for MD5 is MD5-CRYPT so you might need to change this depending on version default_pass_scheme = MD5-CRYPT # Get the mailbox user_query = SELECT '/srv/vmail/%d/%u' as home, 'maildir:/srv/vmail/%d/%u/Maildir' as mail, 5000 AS uid, 5000 AS gid, concat('dirsize:storage=', quota) AS quota FROM mailbox WHERE username = '%u' AND active = '1' # Get the password password_query = SELECT username as user, password, '/srv/vmail/%d/%u' as userdb_home, 'maildir:/srv/vmail/%d/%u/Maildir' as userdb_mail, 5000 as userdb_uid, 5000 as userdb_gid FROM mailbox WHERE username = '%u' AND active = '1' # If using client certificates for authentication, comment the above and uncomment the following #password_query = SELECT null AS password, '%u' AS user
maybe can somebody confirm before i mess up everything ?
-- Mathieu Rousseau http://400iso.net/