dovecot - Mar 2015 - Connect failed to database

Am 02.03.2015 um 19:30 schrieb Dan LaSota:
>>> Just some quick ideas
>>> * check if the mysql socket file has rw permissions for the dovecot
user
>
> # ls -l /var/lib/mysql/mysql.sock
> srwxrwxrwx. 1 mysql mysql 0 Mar  1 19:33 /var/lib/mysql/mysql.sock
that's not the problem
> I have tried with
> connect = host=localhost dbname=servermail user='usermail'
password='gjwslegosoghjshloehg$_jsdgh'
> and
> connect = host=127.0.0.1 dbname=servermail user='usermail'
password='gjwslegosoghjshloehg$_jsdgh'
>
> still doesn't work:
> Mar  2 04:58:48 mail dovecot: auth-worker(5745): Error: mysql(127.0.0.1):
Connect failed to database (servermail): Access denied for user
'usermail'@'localhost' (using password: YES) - waiting for 1
seconds before retry
that is a pretty clear message

the username / password / host is wrong, fix your mysql permissions and 
keep in mind that localhost != 127.0.0.1 in that context

the user with that password from that host is not allowed - period

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 181 bytes
Desc: OpenPGP digital signature
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20150302/75aa57ea/attachment.sig>

>> 
>> still doesn't work:
>> Mar  2 04:58:48 mail dovecot: auth-worker(5745): Error:
mysql(127.0.0.1): Connect failed to database (servermail): Access denied for
user 'usermail'@'localhost' (using password: YES) - waiting for
1 seconds before retry
> 
> that is a pretty clear message
> 
> the username / password / host is wrong, fix your mysql permissions and
keep in mind that localhost != 127.0.0.1 in that context
which is the preferred address: localhost or 127.0.0.1 ?

> 
> the user with that password from that host is not allowed - period
Then why can I use the same credentials to log into mysql from the command line?
Like so:

# mysql -u mailuser -h localhost -p

Dan LaSota
Instructional Designer, UAF eLearning
(907) 451-4067
dan.lasota at alaska.edu
http://elearning.uaf.edu

Am 02.03.2015 um 19:53 schrieb Dan LaSota:
>>>
>>> still doesn't work:
>>> Mar  2 04:58:48 mail dovecot: auth-worker(5745): Error:
mysql(127.0.0.1): Connect failed to database (servermail): Access denied for
user 'usermail'@'localhost' (using password: YES) - waiting for
1 seconds before retry
>>
>> that is a pretty clear message
>>
>> the username / password / host is wrong, fix your mysql permissions and
keep in mind that localhost != 127.0.0.1 in that context
>
> which is the preferred address: localhost or 127.0.0.1 ?
depends

if you prefer unix sockets: localhost
if you prefer TCP: 127.0.0.1
>> the user with that password from that host is not allowed - period
>
> Then why can I use the same credentials to log into mysql from the command
line? Like so:
>
> # mysql -u mailuser -h localhost -p
that is unix-socket, -h 127.0.0.1 would be TCP

just use "host=/var/lib/mysql/mysql.sock" or wherever your socket
lives
or give the 127.0.0.1 user the same permissions - these are mysql basics


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 181 bytes
Desc: OpenPGP digital signature
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20150302/1fb2f2b3/attachment.sig>