Re: Userdb lookup problems

2025-02-17 Thread Ken Wright via dovecot
On Mon, 2025-02-17 at 15:49 +0200, Timo Sirainen wrote: On 16. Feb 2025, at 17.03, Ken Wright via dovecot wrote: mysql localhost {   user = something   password = MYPASSWORD   dbname = something } .. According to the logs,

Re: Userdb lookup problems

2025-02-16 Thread Ken Wright via dovecot
On Sun, 2025-02-16 at 09:30 +0200, Timo Sirainen wrote: > On 16. Feb 2025, at 6.33, Ken Wright via dovecot > wrote: > > > > On Sat, 2025-02-15 at 18:31 -0500, Doug via dovecot wrote: > > > " Access denied for user.. 'dovecot'@'localhost' " > > > > > > Is a mysql error. mysql isn't allowing the

Re: Standard "usual" config (Re: Userdb lookup problems)

2025-02-16 Thread Joan Moreau via dovecot
Thank you For the mail_home, in what sense it is not the same as mail_path ? Can' t we just scrap one of them ? On 2025-02-16 21:06, Timo Sirainen via dovecot wrote: On 16. Feb 2025, at 14.52, Joan Moreau via dovecot wrote: and anyway the full path of sieves script is specified sieve_sc

Re: Standard "usual" config (Re: Userdb lookup problems)

2025-02-16 Thread Timo Sirainen via dovecot
On 16. Feb 2025, at 14.52, Joan Moreau via dovecot wrote: > > and anyway the full path of sieves script is specified > > sieve_script personal { > path = /data/mails/%{user | domain }/%{user | username }/sieve/default.sieve > } This is different from what you used to have: > sieve = fil

Re: Standard "usual" config (Re: Userdb lookup problems)

2025-02-16 Thread Joan Moreau via dovecot
and anyway the full path of sieves script is specified sieve_script personal { path = /data/mails/%{user | domain }/%{user | username }/sieve/default.sieve } 1 - Why "mail_home" is used by Sieve ? (as anyway, script are specified otherwise) 2 - why scripts are not run ? On 2025-02-16 20:

Re: Standard "usual" config (Re: Userdb lookup problems)

2025-02-16 Thread Joan Moreau via dovecot
I added mail_home = /data/mails/%{user | domain }/%{user | username } (same as pail_path, really never used that, why 2 parameters for the same thing ???) but still, sieve is not trigggered (everything arrives in INBOX, meaning my scripts are not executed ) On 2025-02-16 20:44, Timo Sirai

Re: Standard "usual" config (Re: Userdb lookup problems)

2025-02-16 Thread Timo Sirainen via dovecot
On 16. Feb 2025, at 14.30, Joan Moreau via dovecot wrote: > > Initially there is mail_location > > Now, I have > > mail_driver = mdbox > mail_path = /data/mails/%{user | domain }/%{user | username } > > I don't understand what is "mail_home" : What does it represent ? https://doc.dovecot.org/

Re: Standard "usual" config (Re: Userdb lookup problems)

2025-02-16 Thread Joan Moreau via dovecot
Initially there is mail_location Now, I have mail_driver = mdbox mail_path = /data/mails/%{user | domain }/%{user | username } I don't understand what is "mail_home" : What does it represent ? On 2025-02-16 19:59, Timo Sirainen wrote: On 16. Feb 2025, at 13.54, Joan Moreau wrote: Well, -

Re: Standard "usual" config (Re: Userdb lookup problems)

2025-02-16 Thread Timo Sirainen via dovecot
On 16. Feb 2025, at 13.54, Joan Moreau wrote: > > Well, > > - I need xapian enable in LMTP (how to index incoming emails otherwise ?) > It is enabled from the global mail_plugins. When using the mail_plugin { foo=yes } syntax it adds to the existing mail_plugins rather than replacing them.

Re: Standard "usual" config (Re: Userdb lookup problems)

2025-02-16 Thread Joan Moreau via dovecot
Well, - I need xapian enable in LMTP (how to index incoming emails otherwise ?) - doing as below, I get : Feb 16 11:53:11 gjserver dovecot[2108456]: lmtp(j...@grosjo.net)<2108468>: Error: duplicate db: User j...@grosjo.net doesn't have home dir set, disabling duplicate database On 2025-02

Re: Standard "usual" config (Re: Userdb lookup problems)

2025-02-16 Thread Joan Moreau via dovecot
If I remove the block and put sieve = yes in lmtp/lda, sieve rules are just not applied to incoming emails... On 2025-02-16 19:20, Joan Moreau via dovecot wrote: Dovecot now starts I have a problem with the initial block mail_plugins { fts = yes fts_xapian = yes sieve = yes managesieve = yes

Re: Standard "usual" config (Re: Userdb lookup problems)

2025-02-16 Thread Timo Sirainen via dovecot
On 16. Feb 2025, at 13.20, Joan Moreau via dovecot wrote: > > Dovecot now starts > > I have a problem with the initial block > > mail_plugins { >fts = yes >fts_xapian = yes >sieve = yes >managesieve = yes > } You're doing more than just syntax changes here. There is no managesi

Standard "usual" config (Re: Userdb lookup problems)

2025-02-16 Thread Joan Moreau via dovecot
Dovecot now starts I have a problem with the initial block mail_plugins { fts = yes fts_xapian = yes sieve = yes managesieve = yes } Basically, if I want to start dovecot, I need to remove that block, but then, managesieve is not working, fts neither, etc.. What is the correc

Re: Userdb lookup problems

2025-02-16 Thread Timo Sirainen via dovecot
On 16. Feb 2025, at 10.37, Joan Moreau via dovecot wrote: > > @Timo : You would just put a page with in 2 columns, left , the old default > conf, right, the new default conf, that would be a million times helpful I added some more settings and other upgrading help to: https://github.com/doveco

Re: Userdb lookup problems

2025-02-16 Thread Joan Moreau via dovecot
v3 -- dovecot_config_version = 2.4.0 dovecot_storage_version = 2.4.0 base_dir = /run/dovecot state_dir = /var/lib/dovecot default_login_user = dovecot listen = * :: verbose_proctitle = yes mail_gid = mail mail_uid = mailusers mail_driver = mdbox mail_path = /data/mails/%{user

Re: Userdb lookup problems

2025-02-16 Thread Joan Moreau via dovecot
v2 -- dovecot_config_version = 2.4.0 dovecot_storage_version = 2.4.0 base_dir = /run/dovecot state_dir = /var/lib/dovecot default_login_user = dovecot listen = * :: verbose_proctitle = yes mail_gid = mail mail_uid = mailusers mail_driver = mdbox mail_path = /data/mails/%{user

Re: Userdb lookup problems

2025-02-16 Thread Timo Sirainen via dovecot
On 16. Feb 2025, at 11.18, Joan Moreau via dovecot wrote: > > ssl_cert = ssl_key = ssl_dh = default_vsz_limit = 0 = unlimited > plugin { There are no more plugin settings. >plugin = fts_xapian managesieve sieve > >fts = xapian >fts_xapian = verbose=0 You need to c

Re: Userdb lookup problems

2025-02-16 Thread Bjoern Franke via dovecot
Hi, this part --- ssl_cert =

Re: Userdb lookup problems

2025-02-16 Thread Joan Moreau via dovecot
For the sake of simplicity and in the intent to be useful for others, here where I get with my config (using Sieve, FTS Xapian, LMTP, and mySQL user/passdb Any corrections ? - dovecot_config_version = 2.4.0 dovecot_storage_version = 2.4.0 base_dir = /run/dovecot state_dir = /var/lib/dove

Re: Userdb lookup problems

2025-02-16 Thread Joan Moreau via dovecot
Yes, that is helpful indeed. Swimming in the pacific ocean here Related item : I have "iterate_query" to convert from the old setup to the new config as well. What to do with that ? Thank you On 2025-02-16 16:49, Timo Sirainen via dovecot wrote: On 16. Feb 2025, at 10.37, Joan Moreau vi

Re: Userdb lookup problems

2025-02-16 Thread Timo Sirainen via dovecot
On 16. Feb 2025, at 10.37, Joan Moreau via dovecot wrote: > > @Timo : You would just put a page with in 2 columns, left , the old default > conf, right, the new default conf, that would be a million times helpful This is done for some settings, but for others there is no exact 1:1 mapping even

Re: Userdb lookup problems

2025-02-16 Thread Joan Moreau via dovecot
@Timo : You would just put a page with in 2 columns, left , the old default conf, right, the new default conf, that would be a million times helpful On 2025-02-16 15:30, Timo Sirainen via dovecot wrote: On 16. Feb 2025, at 6.33, Ken Wright via dovecot wrote: On Sat, 2025-02-15 at 18:31 -0500

Re: Userdb lookup problems

2025-02-15 Thread Timo Sirainen via dovecot
On 16. Feb 2025, at 6.33, Ken Wright via dovecot wrote: > > On Sat, 2025-02-15 at 18:31 -0500, Doug via dovecot wrote: >> " Access denied for user.. 'dovecot'@'localhost' " >> >> Is a mysql error. mysql isn't allowing the user dovecot to open the >> database to run your SQL query. Until you ca

Re: Userdb lookup problems

2025-02-15 Thread Ken Wright via dovecot
On Sat, 2025-02-15 at 18:31 -0500, Doug via dovecot wrote: > " Access denied for user.. 'dovecot'@'localhost' " > > Is a mysql error. mysql isn't allowing the user dovecot to open the > database to run your SQL query.  Until you can open the database, you > aren't even retrieving the account pass

Re: Userdb lookup problems

2025-02-15 Thread Joan Moreau via dovecot
- From: Ken Wright via dovecot Sent: Saturday, February 15, 2025 4:41 PM To: Aki Tuomi ; Ken Wright via dovecot ; Timo Sirainen Subject: Re: Userdb lookup problems On Sat, 2025-02-15 at 20:24 +0200, Aki Tuomi wrote: On 15/02/2025 18:29 EET Ken Wright via dovecot wrote: On Sat, 2025-02-15 at 17:5

RE: Userdb lookup problems

2025-02-15 Thread Doug via dovecot
hould concentrate your efforts. I don't use mysql for authentication so I can't really tell you how to configure dovecot or mysql to make it work. > -Original Message- > From: Ken Wright via dovecot > Sent: Saturday, February 15, 2025 4:41 PM > To: Aki Tuomi ; K

Re: Userdb lookup problems

2025-02-15 Thread Ken Wright via dovecot
On Sat, 2025-02-15 at 20:24 +0200, Aki Tuomi wrote: > >   > > > > > On 15/02/2025 18:29 EET Ken Wright via dovecot > > wrote: > > > >   > > > >   > > > > On Sat, 2025-02-15 at 17:53 +0200, Aki Tuomi wrote: > > > > > > > > > > > > > On 15/02/2025 17:39 EET Ken Wright via d

Re: Userdb lookup problems

2025-02-15 Thread Aki Tuomi via dovecot
  On 15/02/2025 18:29 EET Ken Wright via dovecot wrote:     On Sat, 2025-02-15 at 17:53 +0200, Aki Tuomi wrote: On 15/02/2025 17:39 EET Ken Wright via dovecot wrote:     On Sat, 2025-02-15 at 08:59

Re: Userdb lookup problems

2025-02-15 Thread Ken Wright via dovecot
On Sat, 2025-02-15 at 17:53 +0200, Aki Tuomi wrote: > > > On 15/02/2025 17:39 EET Ken Wright via dovecot > > wrote: > > > >   > > On Sat, 2025-02-15 at 08:59 +0200, Timo Sirainen wrote: > > > On 15. Feb 2025, at 0.06, Ken Wright via dovecot > > > wrote: > > > > > > > > > These need to be conv

Re: Userdb lookup problems

2025-02-15 Thread Aki Tuomi via dovecot
> On 15/02/2025 17:39 EET Ken Wright via dovecot wrote: > > > On Sat, 2025-02-15 at 08:59 +0200, Timo Sirainen wrote: > > On 15. Feb 2025, at 0.06, Ken Wright via dovecot > > wrote: > > > > > > driver = mysql > > > connect = host=localhost dbname=postfixadmin user=postfixadmin > > > passwor

Re: Userdb lookup problems

2025-02-15 Thread Joan Moreau via dovecot
What "%{user | username}" means ? %user or %username ? On 2025-02-15 23:39, Ken Wright via dovecot wrote: On Sat, 2025-02-15 at 08:59 +0200, Timo Sirainen wrote: On 15. Feb 2025, at 0.06, Ken Wright via dovecot wrote: driver = mysql connect = host=localhost dbname=postfixadmin user=postfixadm

Re: Userdb lookup problems

2025-02-15 Thread Ken Wright via dovecot
On Sat, 2025-02-15 at 08:59 +0200, Timo Sirainen wrote: > On 15. Feb 2025, at 0.06, Ken Wright via dovecot > wrote: > > > > driver = mysql > > connect = host=localhost dbname=postfixadmin user=postfixadmin > > password=hidden > > userdb_default_password_scheme = ARGON2I > > password_query = SELEC

Re: Userdb lookup problems

2025-02-14 Thread Timo Sirainen via dovecot
On 15. Feb 2025, at 0.06, Ken Wright via dovecot wrote: > > I finally got my new Dovecot 2.4 installation going to the point I can > log in from Evolution, but for some reason it won't accept my password. > Here are the pertinent sections from the dovecot.conf, 10-mail.conf, > and dovecot-sql.con