I have debian 7.8 and using postfix, mysql with roundcube and pure-ftpd-mysql. All working perfectly with mysql Ver 14.14 Distrib 5.5.40 since 2014.
I try to update mysql to 5.7 in order to play with the new full index search mysql functionnality on massive database but I failed.
After updating mysql server to 5.7 phpmyadmin was working great but I had to add:
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
In conf in order to remove the default value error. My backup and table upgrade sucessfully and all my website was working fine.
But I had massive issue with postfix and pureftpd.
Could connect anymore to ftp even if all dabatase of pureftpd was there and working. I check all the conf everything seems fine.
I can connect to roundcube successfully and see my old email but I cant send or receive anymore email. I received this error in my log :
postfix/cleanup[27758]: warning: mysql:/etc/postfix/mysql_virtual_alias_maps.cf is unavailable. unsupported dictionary type: mysql
I try many things but nothing worked I end up using my full backup and restore the entire system. RIght now everything back to normal 100% perfect but with 5.5 mysql.
Maybe I did something wrong during the process. What I did :
Entire backup of my system and sql database and conf
apt-get remove mysql-server mysql-client mysql-common
apt-get autoremove
apt-get autoclean
apt-get install libaio1
dpkg -i mysql-apt-config_0.8.3-1_all.deb
apt-get update
apt-get intall mysql-server
service mysql start
restoring mysql database and upgrading table
Thanks for the help!