1 Topic by Duckdave

  • Duckdave
  • Member
  • Offline
  • Registered: 2019-02-08
  • Posts: 3

Topic: DB Error: SQLSTATE[HY000] [1045] Access denied for user

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.9
- Deployed with iRedMail Easy or the downloadable installer? downloadable installer
- Linux/BSD distribution name and version: Ubuntu 18.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hi,

i've set up a 2 node iRedMail cluster with mariadb and dovecot replication.
I tested a failover und shutdown node 2 all fine, i started node 2 backup and shutdown node 1 and i have "DB Error: SQLSTATE[HY000] [1045] Access denied for user" in all services.

The passwords and grants on both nodes are the same, can't figure out whats causing the error.

Regards

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by Duckdave (edited by Duckdave 2019-02-08 04:31:37)

  • Duckdave
  • Member
  • Offline
  • Registered: 2019-02-08
  • Posts: 3

Re: DB Error: SQLSTATE[HY000] [1045] Access denied for user

i think figured out the problem, during the mariadb replication setup i move a mysqldump from node 1 to node 2 i selected all databases, therefore the users in the mysql db have the same passwords. But on node 2, for example, the postfix config had a other password.

I think i need to reinstall the second node.

regards

*** Update ***
i found all the users and passwords in the installation folder under iRedMail(version).tips and changed the passwords in the mariadb and all is working fine.

3 Reply by Duckdave

  • Duckdave
  • Member
  • Offline
  • Registered: 2019-02-08
  • Posts: 3

Re: DB Error: SQLSTATE[HY000] [1045] Access denied for user

Something schould be wrong i my replication configuration at mariadb. Sometimes my service users get the passwords of the other node.

this is my rep configuration:
[mariadb]
server_id=2
log-basename=slave1
log_bin
auto_increment_increment=10
auto_increment_offset=1
binlog_do_db='amavisd'
binlog_do_db='iredadmin'
binlog_do_db='roundcubemail'
binlog_do_db='sogo'
binlog_do_db='vmail'
binlog_ignore_db='test'
binlog_ignore_db='information_schema'
binlog_ignore_db='mysql'
binlog_ignore_db='iredapd'
replicate_ignore_db='test'
replicate_ignore_db='information_schema'
replicate_ignore_db='mysql'
replicate_ignore_db='iredapd'
slave-parallel-threads=5

someone a idea why this happen?

Thanks.