Hello all,
My environment runs zabbix 2.4.5, I want to upgrade it to 4.4.7.
First I upgrade it to 3.4.15 and everythins works fine.
And then I upgrade it from 3.4.15 to 4.4.7,the upgrade process seems goes well,no errors or warnings in zabbix_server.log .
And then I open http://ip/zabbix, it redirected to http://xx/zabbix/setup.php , I configured the database connection and this finished successfully.
But after I login,some errors occured like 1.png.The errors are: "SQL error [ORA-00911: invalid character] in [SELECT NULL FROM users u WHERE u.userid=4 FOR UPDATE;]" and "Invalid argument supplied for foreach() [zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_status_of_zbx() → OracleDbBackend->checkEncoding() → OracleDbBackend->checkDatabaseEncoding() in include/classes/db/OracleDbBackend.php:84]"
My database is oracle and character set are :
SQL> select parameter,value from v$nls_parameters where parameter='NLS_CHARACTERSET' or parameter='NLS_NCHAR_CHARACTERSET';
PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_CHARACTERSET UTF8
NLS_NCHAR_CHARACTERSET UTF8
Is this a serious problem ? How can I fix it ?Thank you!
My environment runs zabbix 2.4.5, I want to upgrade it to 4.4.7.
First I upgrade it to 3.4.15 and everythins works fine.
And then I upgrade it from 3.4.15 to 4.4.7,the upgrade process seems goes well,no errors or warnings in zabbix_server.log .
And then I open http://ip/zabbix, it redirected to http://xx/zabbix/setup.php , I configured the database connection and this finished successfully.
But after I login,some errors occured like 1.png.The errors are: "SQL error [ORA-00911: invalid character] in [SELECT NULL FROM users u WHERE u.userid=4 FOR UPDATE;]" and "Invalid argument supplied for foreach() [zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → make_status_of_zbx() → OracleDbBackend->checkEncoding() → OracleDbBackend->checkDatabaseEncoding() in include/classes/db/OracleDbBackend.php:84]"
My database is oracle and character set are :
SQL> select parameter,value from v$nls_parameters where parameter='NLS_CHARACTERSET' or parameter='NLS_NCHAR_CHARACTERSET';
PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_CHARACTERSET UTF8
NLS_NCHAR_CHARACTERSET UTF8
Is this a serious problem ? How can I fix it ?Thank you!
Attached Files
Comment