Cron MySQL backup not working

aaP_crazykiddodk

Cron backup of MySQL database does not work anymore.

Error:

★start backup[2024-09-19 14:26:56]

(1045, "Access denied for user 'root'@'127.0.0.1' (using password: YES)&quot😉

|-Error：Failed to connect to database [localhost: 3306]
|-Message sent successfully.
|-The message notification has been sent.

I have already done the following multiple times:

Restart panel
Pressed Fix button
Set a new MySQL Root password and checked access via phpmyadmin etc.

Initial FIX NOT WORKING:
Delete cron and add again. but same error.

aaPanel_Kern

Hi, can you give us your aapanel information? The server makes a snapshot backup first, if possible, please send it to kern@aapanel.com.
It is recommended to fill in the following
Post link:
SSH IP address, account password and port:
aapanel login link address and account password:
Detailed problem description:

No post link will not be able to know which user's information is, and the problem will not be processed

aaP_crazykiddodk

This is not possible as I have clients secure information and live sites running.
Where is the database backup information coming from? is it stored in DB?

aaPanel_Kern

Is it possible to take a screenshot of the phpmyadmin user?
aaP_crazykiddodk

aaP_crazykiddodk

aaPanel_Kern

took a screenshot of the root user from phpmyadmin.
Or you can take a screenshot of the root user of mysql

aaP_crazykiddodk

but there is nothing there, all priv are Y and host set to localhost

aaP_crazykiddodk

Again everything works, sites, phpmyadmin even DB backup from Database list
only Cron that does not

aaPanel_Kern

Try to add the root user and the host is 127.0.0.1, the password is the same as the host localhost
aaP_crazykiddodk

idflorin

Same problem here.

aaPanel_Kern Where and what to add?

aaP_crazykiddodk

It seems like that worked, hmmm but how come since I have not changed anything with root user.

aaPanel_Kern

What version of aapanel are you using?

aaP_crazykiddodk

7.0.9

aaPanel_Kern

Is this database only accessible by 127.0.0.1?

aaP_crazykiddodk

for root user yes, but there are a few others that are open to remote

aaPanel_Kern

Hello, I suggest you provide the error information.
Please check if the prompted user and host exist?

idflorin

aaPanel_Kern its root
https://prnt.sc/82uSWSZB905x

`★start backup[2024-09-23 20:30:43]

(1045, "Access denied for user 'root'@'127.0.0.1' (using password: YES)&quot😉

|-Error：Failed to connect to database [localhost: 3306]

★start backup[2024-09-23 20:30:43]

(1045, "Access denied for user 'root'@'127.0.0.1' (using password: YES)&quot😉

|-Error：Failed to connect to database [localhost: 3306]

★start backup[2024-09-23 20:30:43]

(1045, "Access denied for user 'root'@'127.0.0.1' (using password: YES)&quot😉

|-Error：Failed to connect to database [localhost: 3306]
Traceback (most recent call last):
File "/www/server/panel/class_v2/panel_backup_v2.py", line 1856, in send_notification
push_res = pp.push_message_immediately(channel_data)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/panel/class/panelPush.py", line 394, in push_message_immediately
ret = msg_obj.push_data(msg)
^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/panel/class/msg/tg_msg.py", line 228, in push_data
return self.send_msg(data['msg'])

KeyError: 'msg'

==========================================================================================
|-Error：Message notification sending failed.
----------------------------------------------------------------------------
★[2024-09-23 20:30:43] Successful
----------------------------------------------------------------------------`


System: Ubuntu 22.04.5 LTS x86_64(Py3.12.3)
Up Time: 4 Day(s) aapanel 7.0.9

aaPanel_Kern

No post link will not be able to know which user's information is, and the problem will not be processed

idflorin

aaPanel_Kern Credentials sent