1 Topic by marco

  • marco
  • Member
  • Offline
  • Registered: 2020-11-21
  • Posts: 1

Topic: MYSQL error

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

-Iredmail version 1.3.2 MARIADB edition.
Deployed with downloadable installer.
Ubuntu 20.04
store mail accounts in MySQL
Webserver Nginx
Manage mail accounts with iRedAdmin-Pro? NO




i got a issue with mariadb. i get a error

Nov 19 18:56:33 mail.darksideoftheeclipse.info mysqld[40358]: 2020-11-19 18:56:33 0 [Note] /usr/sbin/mysqld (mysqld 10.3.25-MariaDB-0ubuntu0.20.04.1) starting as process 40358 ...
Nov 19 18:56:34 mail.darksideoftheeclipse.info systemd[1]: Started MariaDB 10.3.25 database server.
Nov 19 18:56:34 mail.darksideoftheeclipse.info /etc/mysql/debian-start[40393]: Upgrading MySQL tables if necessary.
Nov 19 18:56:34 mail.darksideoftheeclipse.info /etc/mysql/debian-start[40397]: Looking for 'mysql' as: /usr/bin/mysql
Nov 19 18:56:34 mail.darksideoftheeclipse.info /etc/mysql/debian-start[40397]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Nov 19 18:56:34 mail.darksideoftheeclipse.info /etc/mysql/debian-start[40397]: Version check failed. Got the following error when calling the 'mysql' command line client
Nov 19 18:56:34 mail.darksideoftheeclipse.info /etc/mysql/debian-start[40397]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Nov 19 18:56:34 mail.darksideoftheeclipse.info /etc/mysql/debian-start[40397]: FATAL ERROR: Upgrade failed
Nov 19 18:56:34 mail.darksideoftheeclipse.info /etc/mysql/debian-start[40407]: Checking for insecure root accounts.
Nov 19 18:56:34 mail.darksideoftheeclipse.info debian-start[40410]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)



is this a problem or can i just ignore?

----

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: 30,788

Re: MYSQL error

Safe to ignore. Or you can fix it by link /root/.my.cnf to /etc/mysql/debian.cnf like this:

cd /etc/mysql/
mv debian.cnf debian.cnf.bak
ln -sf /root/.my.cnf debian.cnf