Mysql config personal server.
I'm working on a personal mail server, following this guide: Digital Ocean -Postfix/Dovecot/Mysql - Setup.
The thing is, that i want to config a user(mine this time), as 'normal'. This means without any additional permession. To accomplish that i'm working on a DB with
root user which i use to "grant/drop" permissions as needed.
- My 'user' have only
SELECTpermissions on my personal
- I reviewed the config files and logs, but i can't find the error or what i'm doing wrong.
rootuser have not outgoing email, that means he is not included on any database table, for security reasons.
log is dumping trough
tail on a server loop-log maked by hand:
/var/log/mail.log: dovecot: auth-worker(5529): Error: mysql(127.0.0.1): Connect failed to database (my-db): Access denied for user 'my_user'@'localhost' (using password: YES) - waiting for 125 seconds before retry. dovecot: auth: Error: auth worker: Aborted PASSL request for firstname.lastname@example.org: Lookup timed out. dovecot: lmtp(email@example.com): Error: user firstname.lastname@example.org: Auth USER lookup failed. dovecot: auth-worker(5529): Error: mysql: Query timed out (no free connections for 60 secs): SELECT email as user, password FROM virtual_users WHERE email = 'email@example.com'; auth-worker(5529): Error: sql(firstname.lastname@example.org): Password query failed: Not connected to database. /var/log/mysql/error.log 2016-11-04T08:38:38.500948Z 2552 [Note] Access denied for user 'my_user'@'localhost' (using password: YES).
So i undertand that the configuration on the server side, possibly on dovecot or postfix, files point a connection to the
root but i want that it will be a
- I reviwed the password and grant permisssions.
Any help will be apreciated.
note: this question was writed on "stack overflow" page and moved here acordingly to the nature of its own(about configuration) instead software develpment!(original question)