Topic: Password for mySQL for iRedAPD file location?
==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.7
- Linux/BSD distribution name and version: Debian 9
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MariaDB
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro?: No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Greetings! I had to change some passwords for some things to get things working correctly on a previously messed up upgrade from Debian 8 to 9. I've managed to get almost everything working again by creating a VM, copying configuration files over from the VM, and changing passwords for the databases, to match the passwords that are used for MySQL on my existing production machine. Lately, I've been getting an error from iRedAPD, because I didn't change the password in one of the configuration files in order to give iRedAPD access to the vmail database on my machine. I can't figure out which configuration file for iRedAPD that I need to update the database password in. Since having updated everything, I've been getting this error in my inbox from a failed cron job, because the iRedAPD password is wrong for MySQL.
Traceback (most recent call last):
File "/opt/www/iredadmin/tools/delete_mailboxes.py", line 158, in <module>
qr = conn.select('deleted_mailboxes', where=sql_where)
File "/usr/lib/python2.7/dist-packages/web/db.py", line 699, in select
return self.query(qout, processed=True)
File "/usr/lib/python2.7/dist-packages/web/db.py", line 658, in query
db_cursor = self._db_cursor()
File "/usr/lib/python2.7/dist-packages/web/db.py", line 570, in _db_cursor
return self.ctx.db.cursor()
File "/usr/lib/python2.7/dist-packages/web/db.py", line 511, in _getctx
self._load_context(self._ctx)
File "/usr/lib/python2.7/dist-packages/web/db.py", line 522, in _load_context
ctx.db = self._connect(self.keywords)
File "/usr/lib/python2.7/dist-packages/web/db.py", line 550, in _connect
return self.db_module.connect(**keywords)
File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
return Connection(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 204, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'vmailadmin'@'localhost' (using password: YES)")
If someone could please point me in the direction of the correct file to change this password in, I would be really grateful!
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.
