Hi Guys,
After the upgrade to OMV4 I've got an issue with the MySQL plugin. In the GUI it says it isn't running, but it seems to work. I can login to the management console. But when I look in the log file I see this error:
Code
2017-12-28 9:43:16 140407516739328 [ERROR] Incorrect definition of table mysql.proc: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVA
Does anyone know how to resolve this issue?
*UPDATE*
I also can't reset the password. Then I get the following error:
Code
Error #0:
OMV\ExecException: Failed to execute command 'export PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin; export LANG=C; sudo mysql -u root -e " CREATE USER IF NOT EXISTS 'omvadmin'@'localhost' IDENTIFIED BY '*****; GRANT ALL PRIVILEGES ON *.* TO 'omvadmin'@'localhost' IDENTIFIED BY '*****' WITH GRANT OPTION; FLUSH PRIVILEGES; "' with exit code '1': in /usr/share/php/openmediavault/system/process.inc:175
Stack trace:
#0 /usr/share/openmediavault/engined/rpc/mysql.inc(223): OMV\System\Process->execute()
#1 [internal function]: OMV\Engined\Rpc\MySql->resetPassword(Array, Array)
#2 /usr/share/php/openmediavault/rpc/serviceabstract.inc(123): call_user_func_array(Array, Array)
#3 /usr/share/php/openmediavault/rpc/rpc.inc(86): OMV\Rpc\ServiceAbstract->callMethod('resetPassword', Array, Array)
#4 /usr/sbin/omv-engined(536): OMV\Rpc\Rpc::call('MySql', 'resetPassword', Array, Array, 1)
#5 {main}