Re: Password Mismatch when connecting from Email Client

[Dr Francis Greaves]

My dovecot-sql.conf.ext file has this line:

default_pass_scheme = MD5-CRYPT

looking in the postfixadmin database passwords are encrypted




 On Fri, 04 Feb 2022 16:37:54 + Benny Pedersen  wrote 



On 2022-02-04 17:17, Dr Francis Greaves wrote: 
 
> Any help much appreciated. 
 
what is stored in mysql on the password field ? 
 
you dont need to expose passwords in maillists 

Re: Password Mismatch when connecting from Email Client

[Benny Pedersen]

On 2022-02-04 18:33, Francis Greaves wrote:

Well my PostfixAdmin is setup like this:

$CONF['encrypt'] = 'md5crypt';

and dovecot default_pass_scheme = MD5-CRYPT

So I would have thought that would match OK.

I have tried a password with just AlphaNumeric characters, no special
chars but same error.



and thats why i asked what is in mysql password field

no info no help here


should i keep repeat ?

Re: Password Mismatch when connecting from Email Client

[Alexander Dalloz]

Am 04.02.2022 um 18:33 schrieb Francis Greaves:

Well my PostfixAdmin is setup like this:

$CONF['encrypt'] = 'md5crypt';

and dovecot default_pass_scheme = MD5-CRYPT


Use

$CONF['encrypt'] = 'dovecot:MD5-CRYPT'
$CONF['dovecotpw'] = "/path/to/doveadm pw";

in conf.inc.php of Postfixadmin.

Alexander

Re: Password Mismatch when connecting from Email Client

[Francis Greaves]

Well my PostfixAdmin is setup like this:



$CONF['encrypt'] = 'md5crypt';



and dovecot default_pass_scheme = MD5-CRYPT



So I would have thought that would match OK.



I have tried a password with just AlphaNumeric characters, no special chars but 
same error.






 On Fri, 04 Feb 2022 17:16:05 + Benny Pedersen  wrote 



On 2022-02-04 18:08, João Silva wrote: 
> On 04/02/2022 16:51, Francis Greaves wrote: 
> 
>> My dovecot-sql.conf.ext file has this line: 
>> 
>> default_pass_scheme = MD5-CRYPT 
>> 
>> looking in the postfixadmin database passwords are encrypted 
> 
> How? there are several ways to encrypt passwords. If the 
> default_pass_scheme mismatch the way postfixadmin encrypts the 
> passwords the verification will fail. 
 
and thats why i asked what is in mysql password field 
 
no info no help here

Re: Password Mismatch when connecting from Email Client

[justina colmena ~biz]

That is a test user on a private network. Not publicly accessible at all.

Anyways, I have had the best luck on dovecot and postfix with the unix/linux 
utility "pass" to generate fairly long alphanumeric-only passwords as I have 
found that any special characters in passwords are ending up garbled or 
misinterpreted when I attempt to log in to dovecot on IMAP or POP.

On February 4, 2022 7:37:54 AM AKST, Benny Pedersen  wrote:
>On 2022-02-04 17:17, Dr Francis Greaves wrote:
>
>> Any help much appreciated.
>
>what is stored in mysql on the password field ?
>
>you dont need to expose passwords in maillists 

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

Re: Password Mismatch when connecting from Email Client

[Benny Pedersen]

On 2022-02-04 18:08, João Silva wrote:

On 04/02/2022 16:51, Francis Greaves wrote:


My dovecot-sql.conf.ext file has this line:

default_pass_scheme = MD5-CRYPT

looking in the postfixadmin database passwords are encrypted


How? there are several ways to encrypt passwords. If the
default_pass_scheme mismatch the way postfixadmin encrypts the
passwords the verification will fail.


and thats why i asked what is in mysql password field

no info no help here

Re: Password Mismatch when connecting from Email Client

[João Silva]

On 04/02/2022 16:51, Francis Greaves wrote:

My dovecot-sql.conf.ext file has this line:
default_pass_scheme = MD5-CRYPT
looking in the postfixadmin database passwords are encrypted


How? there are several ways to encrypt passwords. If the 
default_pass_scheme mismatch the way postfixadmin encrypts the passwords 
the verification will fail.







 On Fri, 04 Feb 2022 16:37:54 + *Benny Pedersen * 
wrote 


On 2022-02-04 17:17, Dr Francis Greaves wrote:

> Any help much appreciated.

what is stored in mysql on the password field ?

you dont need to expose passwords in maillists 

Re: Password Mismatch when connecting from Email Client

[Francis Greaves]

My dovecot-sql.conf.ext file has this line:

default_pass_scheme = MD5-CRYPT

looking in the postfixadmin database passwords are encrypted







 On Fri, 04 Feb 2022 16:37:54 + Benny Pedersen  wrote 



On 2022-02-04 17:17, Dr Francis Greaves wrote: 
 
> Any help much appreciated. 
 
what is stored in mysql on the password field ? 
 
you dont need to expose passwords in maillists 

Re: Password Mismatch when connecting from Email Client

[Benny Pedersen]

On 2022-02-04 17:17, Dr Francis Greaves wrote:


Any help much appreciated.


what is stored in mysql on the password field ?

you dont need to expose passwords in maillists 

Re: Password Mismatch when connecting from Email Client

[João Silva]

The passwords are stored in plaintext in the database?

Already checked

https://github.com/postfixadmin/postfixadmin/blob/master/DOCUMENTS/DOVECOT.txt 



Once a dumped to a postfix admin database crypt passwords straight from 
/etc/shadow without a single issue, that's why I'm asking if the 
passwords are in plaintext or not.


On 04/02/2022 16:17, Dr Francis Greaves wrote:


Dear All

I have Postfix version 3.3.0, Dovecot Version 2.2.33.2 and 
PostfixAdmin version 3.3.10 using MySQL on a small device running 
Ubuntu VERSION="18.04.6 LTS (Bionic Beaver)" for my internal LAN Mail.


I have a user ad...@fsoft.nnet with a mailbox setup in PostfixAdmin 
with a password as 'Test75?'


Everything is running fine, but I cannot get my Email Client 
Thunderbird to connect.


I have setup the debugging to see that the correct password is being 
used, which it is, but I have this error:


dovecot: auth-worker(26468):
sql(ad...@fsoft.nnet,10.6.10.10,): Password
mismatch (given password: Test75?)

showing that dovecot disagrees!!!

Why is this? Is it something to do with the permissions in PostfixAdmin?

I did find a post on Server Fault 
 
where someone had the same problem. He just tried various passwords 
until he found one that worked I have not found any other post 
about this exact problem.


Any help much appreciated.

Regards
Francis