On Tue, August 15, 2017 8:54 am, Noel Butler wrote:
On 15/08/2017 08:18, voytek@sbt.net.au wrote:
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
Noel, thanks
MySQL on old, MariaDB on new
OK, KEYING in password as I have:
(you meant -u, no?)
]# mysql -p -u vmail Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 1245 Server version: 10.1.19-MariaDB MariaDB Server
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | postfix | | vmail | +--------------------+ 3 rows in set (0.00 sec)
MariaDB [(none)]>
I've used the password i've made, NOT the string I have in /etc/dovecot/mysql file
enter password
BUT, when I use OLDSERVER hashed string
on OLD server, it's OK
on NEW server, fail:
# mysql -p -u vmail Enter password: ERROR 1045 (28000): Access denied for user 'vmail'@'localhost' (using password: YES)
so, the hashed string I've copied /transfered from OLD server 'as is' doesn't work on NEW
how do I generate hashed string from my password ?