Resolved can't upgrade to ONYX from 12.5

[Giorgos Kontopoulos]

I am on CENTOS 6.8
and have upgraded to mysql 5.6
mysql -V gives
mysql Ver 14.14 Distrib 5.7.16, for Linux (x86_64) using EditLine wrapper

and tried to upgrade using the web tool and later on using the
plesk installer

attaching the log that the plesk installer produced

 

[IgorG]

There is error like

Plesk database scheme was not upgraded completely

Try to fix it with

# mysql_upgrade -u admin -p`cat /etc/psa/.psa.shadow`

 

[Giorgos Kontopoulos]

@IgorG thanks for the suggestion
it did not help though
the mysql upgrade did not find anything to fix and the plesk installer came up with same output it seems
attaching just in case

anymore ideas ?

 

[SibProgrammer]

Open /etc/mysql/my.cnf and add the following lines:

[mysqld]
sql_mode=""

Then restart MySQL using the following command: service mysql restart
Try to upgrade once again.

 

[Giorgos Kontopoulos]

@SibProgrammer
did you mean in /etc/my.cnf ?

[mysqld]
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

because /etc/mysql folder does not even exist

 

[SibProgrammer]

Yes, it depends on OS. /etc/my.cnf in your case.

 

[Giorgos Kontopoulos]

I had to use "/etc/init.d/mysqld restart"
and force the mysql_update
"mysql_upgrade -u admin -p`cat /etc/psa/.psa.shadow` --force"
and even though there did not seem to make any updates
the "plesk installer" actually upgraded to ONYX

great thanks guys