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
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
Do bear with me if i may not understand everything as it took quite alot of trial and error to get here
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?
Happy to report that issue with backup has been fully resolved few days back. Even new script installations on new VPS after are good.