Dovecot 2.4. field lookup for sqlite_path?
Good day Guys
Reading: https://doc.dovecot.org/2.4.1/core/config/auth/databases/sql.html#sqlite
Im trying to do a field look up but I get the following error message
Failed to parse configuration: Failed to expand sqlite_path setting variables: dom ain: No value to get domain from
This is what I have
passdb sql { query = SELECT name AS username, password FROM mailboxes WHERE name = '%{user | username}' sqlite_path = /usr/home/.mail/%{domain}/mailconf.sq3 }
If I hard code the path, then the error message goes away
Regards Brent Clark
On 04/06/2025 15:45 EEST Brent Clark via dovecot <dovecot@dovecot.org> wrote: Good day Guys Reading: https://doc.dovecot.org/2.4.1/core/config/auth/databases/ sql.html#sqlite Im trying to do a field look up but I get the following error message Failed to parse configuration: Failed to expand sqlite_path setting variables: dom ain: No value to get domain from This is what I have passdb sql { query = SELECT name AS username, password FROM mailboxes WHERE name = '%{user | username}' sqlite_path = /usr/home/.mail/%{domain}/mailconf.sq3 } If I hard code the path, then the error message goes away Regards Brent Clark _______________________________________________ dovecot mailing list -- dovecot@dovecot.org To unsubscribe send an email to dovecot-leave@dovecot.org The correct syntax is %{user|domain}. Aki
On 2025/06/04 14:53, Aki Tuomi wrote:
The correct syntax is %{user|domain}. Aki
Good day Aki
Thank you, for taking the time to reply.
The reason, why it was %{domain}, for if I did what you proposing, I get
Failed to parse configuration: Failed to expand sqlite_path setting variables: Unknown variable 'user'
Regards Brent
On 2025/06/04 14:53, Aki Tuomi wrote:
The correct syntax is %{user|domain}. Aki
Good day Aki
Thank you, for taking the time to reply.
The reason, why it was %{domain}, for if I did what you proposing, I get
Failed to parse configuration: Failed to expand sqlite_path setting variables: Unknown variable 'user'
Regards Brent
participants (2)
-
Aki Tuomi
-
Brent Clark