Roundcube error 500 after Mysql update to 5.7 on ubuntu

[peter.ondzik]

Hello,

today i have updated mysql from 5.4 to 5.7 and after that i have problems to log in in webmail which is running on roundcube.


when i make update of mysql i used this steps:

Code: Select all

First of all , Backup All your Database.

mysqldump --all-databases > all_databases.sql
I am pasting the particular portion of tutorial that worked for me .

If you want to install MySQL 5.7, you'll need to add the newer APT package repository from the MySQL APT repository page. Click Download on the bottom right, then copy the link on the next page from No thanks, just start my download. Download the .deb package to your server.

wget https://dev.mysql.com/get/mysql-apt-config_0.8.1-1_all.deb
Next, install it using dpkg.

sudo dpkg -i mysql-apt-config_0.8.1-1_all.deb
You'll see a prompt that asks you which MySQL product you want to configure. The MySQL Server option, which is highlighted, should say mysql-5.7. If it doesn't, press ENTER, then scroll down to mysql-5.7 using the arrow keys, and press ENTER again.

Once the option says mysql-5.7, scroll down on the main menu to Apply and press ENTER again. Now, update your package index.

sudo apt-get update
Finally, install the MySQL-server package, which now contains MySQL 5.7.

sudo apt-get install mysql-server
Now upgrade all mysql databases .

sudo mysql_upgrade -u root -p
Now restart mysql server .

sudo service mysql restart

i get internal error 500 and i cant solve this problem, can you help me please ?

[skamasle]

If you get error 500 maybe your repos breake some php or you miss roundcube database, you need check your logs

I not remoend you use mysql 5.7 in vesta yet, until v18 because your backups maybe not working fine

[peter.ondzik]

I have the all databases in my phpmyadmin, because other websites are working fine, but when i login in to a phpmyadmin a cannot add user because i get the same error 500, i think that the problem is somwhere in phpmyadmin config.

How can i get back the old version of mysql with good configns from vestacp ?