migrating 2.1 to 3.x, sql pass scheme, pass value?

[Noel Butler]

On 15/08/2017 08:18, voytek at sbt.net.au wrote:

> I've also dumped MySQL 'vmail' and imported database, created user vmail,
> vmailadmin
> 
> Aug 15 08:05:31 auth-worker(9763): Error: mysql(127.0.0.1): Connect failed
> to database (vmail): Access denied for user 'vmail'@'localhost' (using
> password: YES) - waiting for 1 seconds before retry

Forget looking at dovecot at teh moment, your problem maybe mysql (I'd
hope you meant mariadb but either way...) 

use command line mysql as vmail user from your dovecot machine to test
password further BEFORE tinkering with dovecot. 

~$ mysql -p -v vmail 

enter password <what I do is copy and paste the password from the file
FIRST, not being lazy, because it verifies and checks the exact password
you have told dovecot to send> 

If it's all good you'll see : 

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 20970
Server version: 5.5.57-MariaDB Source distribution 

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. 

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement. 

MariaDB [(none)]> 

....  

If not, look into mysql db and verifiy vmail user and perms (especially
for localhost), ensure you have reloaded privs as well. 

Set mysql debugging on if need be. 

-- 
Kind Regards, 

Noel Butler 

 		This Email, including any attachments, may contain legally privileged
information, therefore remains confidential and subject to copyright
protected under international law. You may not disseminate, discuss, or
reveal, any part, to anyone, without the authors express written
authority to do so. If you are not the intended recipient, please notify
the sender then delete all copies of this message including attachments,
immediately. Confidentiality, copyright, and legal privilege are not
waived or lost by reason of the mistaken delivery of this message. Only
PDF [1] and ODF [2] documents accepted, please do not send proprietary
formatted documents 

 

Links:
------
[1] http://www.adobe.com/
[2] http://en.wikipedia.org/wiki/OpenDocument
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: OpenPGP digital signature
URL: <http://dovecot.org/pipermail/dovecot/attachments/20170815/8067f83e/attachment.sig>