We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Restoring Backup Debian 8 (MySQL) to Debian 9 (MariaDB)
Restoring Backup Debian 8 (MySQL) to Debian 9 (MariaDB)
I'm moving to a new vps host, old vps host has Debian 8. After clean Vesta install, i restore from backup and run mysql_upgrade. No issues with non db sites but all joomla/wp sites have " Error establishing a database connection". Cant figure out why. I can restore the same backup file to new host and as long as its Debian 8 everything just works after restore command, but not with Debian 9. I'm 100% sure it has to do with MariaDB Debian 9 using but as far as i know its a direct replacement and should just work.
Tried changing "localhost" in config files to IP, and even [::1], nothing works. Whats really odd is that if i go ahead and change DB password for one of the sites and then plug in new password into wp config file, it will load fine BUT if i do this to other sites i get "http error 500".
Its not the end of the world for me, ill just install Debian 8 on new host but i want to know why this is happening and how to make this work. Since i'm migrating, might as well use Debian 9.
Tried changing "localhost" in config files to IP, and even [::1], nothing works. Whats really odd is that if i go ahead and change DB password for one of the sites and then plug in new password into wp config file, it will load fine BUT if i do this to other sites i get "http error 500".
Its not the end of the world for me, ill just install Debian 8 on new host but i want to know why this is happening and how to make this work. Since i'm migrating, might as well use Debian 9.
Re: Restoring Backup Debian 8 (MySQL) to Debian 9 (MariaDB)
What version your run in debian 8
Maybe you have mysql 5.7 ?
Maybe your backup not store passwords in vesta conf file as old issue with mysql 5.7 -> viewtopic.php?t=13239
Check if your db.conf store your password /usr/local/vesta/data/users/YOURUSER/db.conf
Also unzip backup and check if there are passwords
With error 500 I can say nothing, you need check logs, maybe php version, maybe something more
Maybe you have mysql 5.7 ?
Maybe your backup not store passwords in vesta conf file as old issue with mysql 5.7 -> viewtopic.php?t=13239
Check if your db.conf store your password /usr/local/vesta/data/users/YOURUSER/db.conf
Also unzip backup and check if there are passwords
With error 500 I can say nothing, you need check logs, maybe php version, maybe something more