Jump to content
Froxlor Forum
  • 0

Debian Trixie dovecot config changes => breaking changes

MeinerEiner

Asked by MeinerEiner,

 Share

Question

MeinerEiner Contributor

MeinerEiner

Posted
Posted

Hello,

latest updates to dovecot breaks imap and pop. File /etc/dovecot/dovecot-sql.conf.ext is oblolete and dovecot will mnot start any more. 

Config file: 

disable_plaintext_auth = no
auth_mechanisms = plain login
!include auth-sql.conf.ext
mail_location = mbox:~/mail:INBOX=/var/mail/%u

namespace inbox {
  inbox = yes
}
mail_privileged_group = mail

service auth {
  # Postfix smtp-auth
  unix_listener /var/spool/postfix/private/auth {
    mode = 0660
    user = postfix
    group = postfix
  }
  # Exim4 smtp-auth
  unix_listener auth-client {
    mode = 0660
    user = mail
    #group = Debian-exim
  }
}

service stats {
  unix_listener stats-reader {
    group = vmail
    mode = 0666
  }
  unix_listener stats-writer {
    group = vmail
    mode = 0666
  }
}

ssl = yes
ssl_cert = </etc/ssl/custom/system.com.pem
ssl_key = </etc/ssl/custom/system.com.key
ssl_dh = </usr/share/dovecot/dh.pem

postmaster_address = postmaster@isp-template.system.com

protocol imap {
  mail_plugins = $mail_plugins quota imap_quota
}

pop3_logout_format = in=%i out=%o top=%t/%p, retr=%r/%b, del=%d/%m, size=%s

plugin {
  sieve = file:~/sieve;active=~/.dovecot.sieve
  sieve_dir = ~/sieve
}

plugin {
  quota = maildir:User quota
}

Are the any developments on debian trixie or available fixes for dovecot?

9 answers to this question

Recommended Posts

  • 0
MeinerEiner Contributor

MeinerEiner

Posted
  • Author
Posted

Hello,

Just take a look at this fix for additional config: 

auth_allow_cleartext = yes
auth_mechanisms = plain login
!include auth-sql.conf.ext
mail_driver = mbox = mbox
mail_inbox_path = /var/mail/%u

namespace inbox {
  inbox = yes
}
mail_privileged_group = mail

service auth {
  # Postfix smtp-auth
  unix_listener /var/spool/postfix/private/auth {
    mode = 0660
    user = postfix
    group = postfix
  }
  # Exim4 smtp-auth
  unix_listener auth-client {
    mode = 0660
    user = mail
    #group = Debian-exim
  }
}

service stats {
  unix_listener stats-reader {
    group = vmail
    mode = 0666
  }
  unix_listener stats-writer {
    group = vmail
    mode = 0666
  }
}

ssl = yes
ssl_server_cert_file = /etc/ssl/lets-encrypt/mail/fullchain.cer
ssl_server_key_file = /etc/ssl/lets-encrypt/mail/server.key
ssl_server_dh_file = /usr/share/dovecot/dh.pem

postmaster_address = postmaster@service.com

protocol imap {
  mail_plugins {
    quota = yes
    imap_quota = yes
  }
}

pop3_logout_format = in=%i out=%o top=%t/%p, retr=%r/%b, del=%d/%m, size=%s

## Sieve
mail_plugins { 
  sieve = yes 
}

sieve_script personal {
  driver = file
  path = ~/sieve
  active_path = ~/.dovecot.sieve
}

## Quota
mail_plugins {
  quota = yes
}

quota "User quota" {
  driver= Maildir++ quota
}

quota "User quota" {
  warning warn-95 {
    quota_storage_percentage = 95
    execute quota-warning {
      args = 95 %{user}
    }
  }
  warning warn-80 {
    quota_storage_percentage = 80
    execute quota-warning {
      args = 80 %{user}
    }
  }
}

Later I will check how to fix file /etc/dovecot/dovecot-sql.conf.ext.

  • 0
d00p Grand Master

d00p

Posted
Posted

it would be more helpful to see a diff, the actual changes necessary or at least the error message dovecot throws

  • 0
MeinerEiner Contributor

MeinerEiner

Posted
  • Author
Posted

Just look in the first post and use a diff tool to compare it. Most thins are renamings. I guess this will also affect debian bookworm with next release of dovecot.

  • 0
MeinerEiner Contributor

MeinerEiner

Posted
  • Author
Posted

Here is the config I thik it should work - with diffs: 

#disable_plaintext_auth = no
auth_allow_cleartext = yes
auth_mechanisms = plain login
!include auth-sql.conf.ext
#mail_location = mbox:~/mail:INBOX=/var/mail/%u
mail_driver = mbox = mbox
mail_inbox_path = /var/mail/%u

namespace inbox {
  inbox = yes
}
mail_privileged_group = mail

service auth {
  # Postfix smtp-auth
  unix_listener /var/spool/postfix/private/auth {
    mode = 0660
    user = postfix
    group = postfix
  }
  # Exim4 smtp-auth
  unix_listener auth-client {
    mode = 0660
    user = mail
    #group = Debian-exim
  }
}

service stats {
  unix_listener stats-reader {
    group = vmail
    mode = 0666
  }
  unix_listener stats-writer {
    group = vmail
    mode = 0666
  }
}

ssl = yes
#ssl_cert = </etc/ssl/lets-encrypt/mail/fullchain.cer
ssl_server_cert_file = /etc/ssl/lets-encrypt/mail/fullchain.cer
#ssl_key = </etc/ssl/lets-encrypt/mail/server.key
ssl_server_key_file = /etc/ssl/lets-encrypt/mail/server.key
#ssl_dh = </usr/share/dovecot/dh.pem
ssl_server_dh_file = /usr/share/dovecot/dh.pem

postmaster_address = postmaster@service.com

#protocol imap {
#  mail_plugins = $mail_plugins quota imap_quota
#}
protocol imap {
  mail_plugins {
    quota = yes
    imap_quota = yes
  }
}

pop3_logout_format = in=%i out=%o top=%t/%p, retr=%r/%b, del=%d/%m, size=%s

## LDA
protocol lda {
  mail_plugins {
     sieve = yes
  }
}


## Sieve
mail_plugins { 
  sieve = yes 
}

#plugin {
#  sieve = file:~/sieve;active=~/.dovecot.sieve
#  sieve_dir = ~/sieve
#}
sieve_script personal {
  driver = file
  path = ~/sieve
  active_path = ~/.dovecot.sieve
}

mailbox Spam {
## From elsewhere to Spam folder
  sieve_script report-spam {
    type = before
    cause = copy
    path = /etc/dovecot/sieve/report-spam.sieve
  }
}

## From Spam folder to elsewhere
imapsieve_from Spam {
  sieve_script report-ham {
    type = before
    cause = copy
    path = /etc/dovecot/sieve/report-ham.sieve
  }
}


## Quota
mail_plugins {
  quota = yes
}

#plugin {
#  quota = maildir:User quota
#}
quota "User quota" {
  driver= Maildir++ quota
}

quota "User quota" {
  warning warn-95 {
    quota_storage_percentage = 95
    execute quota-warning {
      args = 95 %{user}
    }
  }
  warning warn-80 {
    quota_storage_percentage = 80
    execute quota-warning {
      args = 80 %{user}
    }
  }
}

##Sql
#driver = mysql
#connect = "host=127.0.0.1 dbname=froxlor user=froxlor password=FROXLOR_MYSQL_PASSWORD"
sql_driver = mysql
mysql 127.0.0.1 {
  user = froxlor
  password = FROXLOR_DBPASSWORD
  dbname = froxlor
}

#password_query = SELECT username AS user, password_enc AS password, CONCAT(homedir, maildir) AS userdb_home, uid AS userdb_uid, gid AS userdb_gid,  CONCAT('maildir:', homedir, maildir) AS userdb_mail, CONCAT('*:storage=', quota, 'M') as userdb_quota_rule FROM mail_users WHERE (username = '%u' OR email = '%u') AND ((imap = 1 AND '%Ls' = 'imap') OR (pop3 = 1 AND '%Ls' = 'pop3') OR ((postfix = 'Y' AND '%Ls' = 'smtp') OR (postfix = 'Y' AND '%Ls' = 'sieve')))
iterate_query = "SELECT username AS user FROM mail_users WHERE (imap = 1 OR pop3 = 1)"
passdb sql {
 default_password_scheme = CRYPT
 query = SELECT username AS user, password_enc AS password FROM mail_users WHERE (username = '%{user}' OR email = '%{user}') AND ((imap = 1 AND '%Ls' = 'imap') OR (pop3 = 1 AND '%Ls' = 'pop3') OR ((postfix = 'Y' AND '%Ls' = 'smtp') OR (postfix = 'Y' AND '%Ls' = 'sieve')))iterate_query = "SELECT username AS user FROM mail_users WHERE (imap = 1 OR pop3 = 1)"
}

#user_query = SELECT CONCAT(homedir, maildir) AS home, CONCAT('maildir:', homedir, maildir) AS mail, uid, gid, CONCAT('*:storage=', quota, 'M') as quota_rule FROM mail_users WHERE (username = '%u' OR email = '%u')
userdb sql {
  query = SELECT CONCAT(homedir, maildir) AS home, 'maildir' as mail_driver, CONCAT(homedir, maildir) AS mail_path, uid, gid, CONCAT('*:storage=', quota, 'M') as quota_rule FROM mail_users WHERE (username = '%{user}' OR email = '%{user}')
}

For password query is it enough to retrieve only neccessary fields user and password?

Old entries are comment out with # obove new statement.

  • 0
MeinerEiner Contributor

MeinerEiner

Posted
  • Author
Posted

Dovecot 2.4 is only available as community edition with feature cut. I do not know exactly how this affects froxlor functionality. but it seems to be ok. The only thing i cannot find in new config ist sieve after.d config to move spam marked mails to junk folder.

 

So are there any plans to use an alternative to dovecot for the future?

 

Dovecot 2.4 is also available for debian bookworm with dovecot repo

  • 0
d00p Grand Master

d00p

Posted
Posted
11 minutes ago, MeinerEiner said:

So are there any plans to use an alternative to dovecot for the future?

no

We provide default configs for the system defaults, so for bookworm, it's dovecot 2.3, as of now, trixie will ship with dovecot 2.4 and as said in my first reply: 

On 5/20/2025 at 7:57 AM, d00p said:

Trixie is not released yet. Possible issues will be addressed then. 

 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to question listing


×
×
  • Create New...