1 Topic by Sascha_1977 (edited by Sascha_1977 2025-08-28 23:16:20)

  • Sascha_1977
  • Member
  • Offline
  • Registered: 2025-08-27
  • Posts: 3

Topic: Upgrade to mlmmj 3.4 and got sql error (Solved)

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.7.4
- Linux/BSD distribution name and version: Debian 12
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro?: No, normal free Version
====

Today I upgraded mlmmj to 3.4.0 and got this error. Must I care about it? All seems to work normal.

pymysql.err.OperationalError: (1045, "Access denied for user 'vmailadmin'@'localhost' (using password: YES)")
* Upgrading completed.

See attached Log for Details

Post's attachments

Logfile.txt 2.92 kb, 1 downloads since 2025-08-27 

You don't have the permssions to download the attachments of this post.

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,474

Re: Upgrade to mlmmj 3.4 and got sql error (Solved)

Do you have correct sql user and password in files /root/.my.cnf-*? especially /root/.my.cnf-vmailadmin.

3 Reply by Sascha_1977 (edited by Sascha_1977 2025-08-28 00:07:26)

  • Sascha_1977
  • Member
  • Offline
  • Registered: 2025-08-27
  • Posts: 3

Re: Upgrade to mlmmj 3.4 and got sql error (Solved)

Interesteringly I have no file

/root/.my.cnf-vmailadmin

only .my.cnf and .my.cnf-fail2ban

I´m running the server this way since years and never had a problem.

PS:
I added this file with correct password for vmailadmin now and executed again ... but still get the error. Here is what I wrote into the cnf:

[client]
host=127.0.0.1
port=3306
user=vmailadmin
password="MY_SECRET_PASSWORD"

I tested the password with:

mysql -u vmailadmin -p

and its definitive the correct one.

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,474

Re: Upgrade to mlmmj 3.4 and got sql error (Solved)

Do you have correct sql username and password in /opt/mlmmjadmin/settings.py?

5 Reply by Sascha_1977 (edited by Sascha_1977 2025-08-28 14:22:53)

  • Sascha_1977
  • Member
  • Offline
  • Registered: 2025-08-27
  • Posts: 3

Re: Upgrade to mlmmj 3.4 and got sql error (Solved)

Thank you. That did the trick. smile It was the wrong password in this file.