1

Topic: Access denied MYSQL

Hello,

After a clean and fresh install of IredMail et iRedAmin-pro on a debian, i restored datas from an other server. I used the backup_mysql.sh script and import tables into my new server.

After a reboot i had no more access to admin panels and roundcube, and in the mysql.log that access denied appears


          388 Connect    Access denied for user 'amavisd'@'localhost' (using password: YES)
          389 Connect    Access denied for user 'amavisd'@'localhost' (using password: YES)
110630 11:04:30      390 Connect    Access denied for user 'amavisd'@'localhost' (using password: YES)
110630 11:09:28      391 Connect    Access denied for user 'iredadmin'@'localhost' (using password: YES)
110630 11:14:28      392 Connect    Access denied for user 'amavisd'@'localhost' (using password: YES)
          393 Connect    Access denied for user 'iredadmin'@'localhost' (using password: YES)
110630 11:19:28      394 Connect    Access denied for user 'amavisd'@'localhost' (using password: YES)
          395 Connect    Access denied for user 'amavisd'@'localhost' (using password: YES)
          396 Connect    Access denied for user 'iredadmin'@'localhost' (using password: YES)
110630 11:24:28      397 Connect    Access denied for user 'amavisd'@'localhost' (using password: YES)
          398 Connect    Access denied for user 'amavisd'@'localhost' (using password: YES)
          399 Connect    Access denied for user 'iredadmin'@'localhost' (using password: YES)
110630 11:29:28      400 Connect    Access denied for user 'amavisd'@'localhost' (using password: YES)
          401 Connect    Access denied for user 'amavisd'@'localhost' (using password: YES)
110630 11:30:41      402 Connect    Access denied for user 'iredadmin'@'localhost' (using password: YES)
          403 Connect    Access denied for user 'iredadmin'@'localhost' (using password: YES)
110630 11:30:44      404 Connect    Access denied for user 'iredadmin'@'localhost' (using password: YES)

Don't know really what to do...

----

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

2

Re: Access denied MYSQL

Because you stored database 'mysql', and you're using mysql accounts and passwords which created by your old server.
You can reset password for below mysql users:

- roundcube: Find its password in /usr/share/apache2/roundcubemail/config/db.inc.php.
- vmail: Find its password in /etc/postfix/mysql/*.cf.
- iredadmin: Find in /usr/share/apache2/iredadmin/settings.ini, section '[iredadmin]'
- amavisd: Find in /etc/amavis/conf.d/50-user, in setting '@storage_sql_dsn'.

For example:

$ mysql -uroot -p
mysql> USE mysql;
mysql> UPDATE user set Password=Password('password_you_find_in_config_file') WHERE User='roundcube';
mysql> FLUSH PRIVILEGES;

Sorry for my delayed response.