Issue with restoring backup

Hello there,

firstly i am grateful for Cyberpanel, it is very light and speedy, and UI is much more modern than many paid and free control panels.

have been trying for about a month now but to no avail, hence would like to seek some help here :slight_smile:

Provider: Hetzner, Cloudcone etc.

System: Centos 7.5 (.1804)

Installation version: Free (non enterprise)

Installing from official server or mirror server?
Mostly official, have tried mirror as well

Replace JS/CSS files to JS Delivr?
No, have tried JS Delivr as well

Install Memcached extension for PHP?
yes

Install LiteSpeed Memcached?
yes

Install Memcached?
yes

Install Redis extension for PHP?
yes

Install Redis?
yes

MYSQL password unchanged from fresh installation

Situation:

  • Exported website from another server manual by packing files and exporting database.
  • Set up new website on Cyberpanel, set up (empty) database with my own password (different from password given by installer).
  • copied and extracted public_html files with no problem
  • imported database dump with no problem
  • website running perfectly fun
  • able to create backup with no problem
  • shifted backup to /home/backup
  • deleted website to prepare for restoration

Problem:

  • Upon restoring, it says “Status: OK to Run”, and while “Restoring database”, it ends with [5009] error.
  • Cyberpanel log file says “Could not change password for MYSQL user: *****! [restoreDatabaseBackup]”

would like to receive some guidance here.

Thanks!

Sorry for your trouble. There is MySQL password in /etc/cyberpanel/mysqlPassword

Can you use that and login to MySQL successfully? mysql -u root -p

Sorry for your trouble. There is MySQL password in /etc/cyberpanel/mysqlPassword

Can you use that and login to MySQL successfully? mysql -u root -p

No worries, really just happy to be able to move away from (sometimes annoying) plesk and potentially work with such a lightweight and simplified control panel. In fact planning a triple redundancy remote backups with these; it would be fun to see it work :stuck_out_tongue:

Do bear with me if i may not understand everything as it took quite alot of trial and error to get here :smile:

Yes, looks like it works:

[root@server1 backup]# mysql -u root -p                                                                                  
Enter password:                                                                                                          
Welcome to the MariaDB monitor.  Commands end with ; or \\g.                                                              
Your MariaDB connection id is 363                                                                                        
Server version: 10.0.37-MariaDB-wsrep MariaDB Server, wsrep_25.24.rc3fc46e                                               
                                                                                                                         
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.                                                     
                                                                                                                         
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.                                           
                                                                                                                         
MariaDB [(none)]> exit                                                                                                   
Bye 

tried a few fresh installations starting from the most recently above.

Environment 1 (which is what we are discussing now ):
PHPmyadmin password unchanged (root@localhost)
/etc/cyberpanel/mysqlPassword unchanged
website database password same as /etc/cyberpanel/mysqlPassword

Observation: Backup OK, restore error [5009]
Main Log File: Could not change password for MYSQL user: website_db! [restoreDatabaseBackup]

Environment 2:
PHPmyadmin password unchanged (root@localhost)
/etc/cyberpanel/mysqlPassword unchanged
website database password different from /etc/cyberpanel/mysqlPassword

Observation: Backup OK, restore error [5009]
Main Log File: Could not change password for MYSQL user: website_db! [restoreDatabaseBackup]

Environment 3:
PHPmyadmin password changed (root@localhost)
/etc/cyberpanel/mysqlPassword changed
website database password different from /etc/cyberpanel/mysqlPassword

Observation: Backup error [5009] , forgot to copy log. Will try in future.

Can you submit a ticket with login details of any such environment? Would be better if it is fresh install with steps to reproduce the problem.

@CyberPanel said:
Can you submit a ticket with login details of any such environment? Would be better if it is fresh install with steps to reproduce the problem.

Sure, since my current problem is on a fresh installation. Where do I submit a ticket?

https://cyberpanel.net/support

thanks, submitted

cheers

Happy to report that issue with backup has been fully resolved few days back. Even new script installations on new VPS after are good.