1 Topic by fr (edited by fr 2019-02-01 16:55:37)

  • fr
  • Member
  • Offline
  • Registered: 2019-02-01
  • Posts: 61

Topic: mysql Error username and password incorrect when creating backup

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

hello to all this is my first post.
I installed and configured iredmail on my server (openbsd)
and this morning I noticed that the backup script backup_mysql.sh gives me error: "[ERROR] Mysql username or password is incorrect in file /var.../backup.sh"
Up until two days ago everything went well.
Now I noticed that the files requested in the root .my.cnf ..... are missing.
how can I regenerate them?

Post's attachments

iredmail.png
iredmail.png 9.99 kb, file has never been downloaded. 

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

Re: mysql Error username and password incorrect when creating backup

/var/vmail/backup/backup_mysql.sh uses /root/.my.cnf to get mysql username and password, you must make sure it contains correct ones.

Seems you changed password? please update this file.

3 Reply by fr

  • fr
  • Member
  • Offline
  • Registered: 2019-02-01
  • Posts: 61

Re: mysql Error username and password incorrect when creating backup

Thanks Mr. Zhang.
I do not know why but all the files .my.cnf (amavis, posgregql....) were deleted ... I solved by reinstalling in a vm server and iredmail (using the same credentials); I copied the .my.cnf to the server and everything seems to work.
:-)

ZhangHuangbin wrote:

/var/vmail/backup/backup_mysql.sh uses /root/.my.cnf to get mysql username and password, you must make sure it contains correct ones.

Seems you changed password? please update this file.

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: mysql Error username and password incorrect when creating backup

fr wrote:

I solved by reinstalling in a vm server and iredmail (using the same credentials); I copied the .my.cnf to the server and everything seems to work.

Please make sure the SQL passwords in these /root/.my.cnf* files are correct.