1

Topic: cron backup_openldap.sh - Access denied for user 'iredadmin'@'localhos

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.7
- Linux/BSD distribution name and version: ubuntu 16.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): ldap
- 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.
====

the cronjob of backup ldap has this error message every time it runs (3:00 AM)

mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'iredadmin'@'localhost' (using password: YES)
* Starting backup at 2018-01-24-03-00-01
* Backup directory: /var/vmail/backup/ldap/2018/01.
* Dumping LDAP data into file: /var/vmail/backup/ldap/2018/01/2018-01-24-03-00-01.ldif...
* Compressing LDIF file with command: 'bzip2 -9' ...
* [DONE]
* Removing plain LDIF file: /var/vmail/backup/ldap/2018/01/2018-01-24-03-00-01.ldif...    [DONE]
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'iredadmin'@'localhost' (using password: YES)
* File size:
=================
36K    /var/vmail/backup/ldap/2018/01/2018-01-24-03-00-01.ldif.bz2
=================
* [ OK ] Backup completes successfully.
* Delete old backup under /var/vmail/backup/ldap/2017/10.
* Suppose to delete: /var/vmail/backup/ldap/2017/10/2017-10-26*

the password for iredadmin stored in "/etc/dovecot/dovecot-used-quota.conf" is correct, i tried to login with that directly from cli.

is this something i have to worry about?

----

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

2

Re: cron backup_openldap.sh - Access denied for user 'iredadmin'@'localhos

Nothing to worry about, the backup is fine, just not inserted a record to store the backup status.

This is a known bug and fixed. To fix it, please download the latest "backup_openldap.sh" to replace the one on your server:
https://bitbucket.org/zhb/iredmail/src/ … ail/tools/

3

Re: cron backup_openldap.sh - Access denied for user 'iredadmin'@'localhos

Thanks!
Also replace the login credentials in that file? or leave it as root and no password?

4

Re: cron backup_openldap.sh - Access denied for user 'iredadmin'@'localhos

If you have /root/.my.cnf with correct sql username/password, just download the new version and replace old one, no change required.