1 Topic by loudking

  • loudking
  • Member
  • Offline
  • Registered: 2015-04-22
  • Posts: 41

Topic: version 0.9.4 install failed with Access denied for user 'root'@'local

==== Required information ====
- iRedMail version (check /etc/iredmail-release):
- 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?
- Related log if you're reporting an issue:
======== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.4
- Linux/BSD distribution name and version: CentOS 6.6
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx):Apache
- Manage mail accounts with iRedAdmin-Pro?No
- Related log if you're reporting an issue: /runtime/install.log
====

I tried to install latest version on a virgin OS and failed many times with same error. I am sure MySQL password is correct. Please suggest how to continue. Attachment is /run/time/install.log

Below is output during installation:
********************************************************************
* Start iRedMail Configurations
********************************************************************
[ INFO ] Create self-signed SSL certification files (2048 bits).
[ INFO ] Generate a strong, unique Diffie Hellman Group with openssl, please wait.
[ INFO ] Create required system account: vmail, iredadmin, iredapd.
[ INFO ] Configure Nginx web server and uWSGI.
[ INFO ] Configure PHP.
[ INFO ] Configure MySQL database server.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[ INFO ] Setup daily cron job to backup SQL databases with /var/vmail/backup/backup_mysql.sh
[ INFO ] Configure Postfix (Message Transfer Agent).
[ INFO ] Configure Dovecot (pop3/imap/managesieve server).
[ INFO ] Configure ClamAV (anti-virus toolkit).
[ INFO ] Configure Amavisd-new (interface between MTA and content checkers).
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[ INFO ] Configure SpamAssassin (content-based spam filter).
[ INFO ] Configure iRedAPD (postfix policy daemon).
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[ INFO ] Configure iRedAdmin (official web-based admin panel).
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[ INFO ] Configure Fail2ban (authentication failure monitor).
[ INFO ] Configure Roundcube webmail.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

*************************************************************************

Post's attachments

install.log 9.08 kb, 1 downloads since 2016-03-18 

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,172

Re: version 0.9.4 install failed with Access denied for user 'root'@'local

loudking wrote:

I am sure MySQL password is correct

Do you have MySQL server running (with a non-empty mysql root password) BEFORE installing iRedMail?

3 Reply by loudking

  • loudking
  • Member
  • Offline
  • Registered: 2015-04-22
  • Posts: 41

Re: version 0.9.4 install failed with Access denied for user 'root'@'local

Yes I do. It is a new myswl instance. Just before installing iredmail I created password for root and logged from terminal to confirm root @localhost is OK

4 Reply by ZhangHuangbin

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

Re: version 0.9.4 install failed with Access denied for user 'root'@'local

Try this:

*) Remove your mysql root password BEFORE installing iRedMail. (empty password)
*) Make sure you can login to MySQL server without a password.
*) Then install iRedMail. It will set a strong/random password for mysql root user, you can find the password in "iRedMail.tips" file.

In upcoming iRedMail release (0.9.5), this can be simplified to just run iRedMail.sh with MYSQL_ROOT_PASSWD parameter:

MYSQL_ROOT_PASSWD='your_existing_password' bash iRedMail.sh

Also, it's clearly warned in iRedMail installation guide, it requires a fresh/new server without MySQL/OpenLDAP/Apache/... installed. Don't ignore the details in our installation guides....

5 Reply by loudking

  • loudking
  • Member
  • Offline
  • Registered: 2015-04-22
  • Posts: 41

Re: version 0.9.4 install failed with Access denied for user 'root'@'local

Thanks for your reply. But what should I do after erasing root password? Download and run clearRedMail.sh or simply rerun iRedMail.sh?

ZhangHuangbin wrote:

Try this:

*) Remove your mysql root password BEFORE installing iRedMail. (empty password)
*) Make sure you can login to MySQL server without a password.
*) Then install iRedMail. It will set a strong/random password for mysql root user, you can find the password in "iRedMail.tips" file.

In upcoming iRedMail release (0.9.5), this can be simplified to just run iRedMail.sh with MYSQL_ROOT_PASSWD parameter:

MYSQL_ROOT_PASSWD='your_existing_password' bash iRedMail.sh

Also, it's clearly warned in iRedMail installation guide, it requires a fresh/new server without MySQL/OpenLDAP/Apache/... installed. Don't ignore the details in our installation guides....

6 Reply by ZhangHuangbin

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

Re: version 0.9.4 install failed with Access denied for user 'root'@'local

loudking wrote:

Thanks for your reply. But what should I do after erasing root password? Download and run clearRedMail.sh or simply rerun iRedMail.sh?

Download the latest iRedMail, then run iRedMail with command:

bash iRedMail.sh