Re: The use of %w in password_query leads to "Failed to expand plugin setting" error

2021-01-16 Thread @lbutlr
On 16 Jan 2021, at 01:19, f...@fili.nl wrote: > No :) I'm converting the password scheme at the moment of login, please read > the link https://wiki.dovecot.org/HowTo/ConvertPasswordSchemes for more info. Yes, I did that a while ago, but you said "When the user has % in their password" which se

Re: The use of %w in password_query leads to "Failed to expand plugin setting" error

2021-01-16 Thread fili
No :) I'm converting the password scheme at the moment of login, please read the link https://wiki.dovecot.org/HowTo/ConvertPasswordSchemes for more info.Btw, the base64 encoding tip worked! Thanks again AkiOn 16 Jan 2021 03:25, "@lbutlr" wrote:On 14 Jan 2021, at 08:30, Filidor Wiese wrote: > Wh

Re: The use of %w in password_query leads to "Failed to expand plugin setting" error

2021-01-15 Thread @lbutlr
On 14 Jan 2021, at 08:30, Filidor Wiese wrote: > When a user has a % sign in their password, the following error occurs: Were you storing PLAIN TEXT passwords? -- Some humans would do anything to see if it was possible to do it. If you put a large switch in some cave somewhere, with a s

Re: The use of %w in password_query leads to "Failed to expand plugin setting" error

2021-01-14 Thread Filidor Wiese
Thanks Aki, that sounds like a good solution. So you're suggesting? password_query = \ SELECT domain, password, TO_BASE64('%w') AS userdb_plain_pass, \ domain as userdb_domain, concat('*:storage=', quota) AS userdb_quota_rule, 5000 as userdb_uid, 5000 as userdb_gid, '/home/%d/%n' as userdb_home

Re: The use of %w in password_query leads to "Failed to expand plugin setting" error

2021-01-14 Thread Aki Tuomi
> On 14/01/2021 17:30 Filidor Wiese wrote: > > > Hi, > I'm trying to convert my existing users to a more modern password scheme by > following the how-to at https://wiki.dovecot.org/HowTo/ConvertPasswordSchemes. > One of the steps is to include the use of '%w' in the password_query, like so:

The use of %w in password_query leads to "Failed to expand plugin setting" error

2021-01-14 Thread Filidor Wiese
Hi, I'm trying to convert my existing users to a more modern password scheme by following the how-to at https://wiki.dovecot.org/HowTo/ConvertPasswordSchemes. One of the steps is to include the use of '%w' in the password_query, like so: password_query = \   SELECT domain, password, '%w'