Hello and sorry for my English
I am on Ubuntu 16 and now Zabbix 4.0.3. On my Ubuntu server i did apt-get upgrade and i had update for Zabbix server. Before upgrade Zabbix i did one backup of my database and Zabbix_server_conf file
When i did upgrade, the system said : "there is a new version of Zabbix_server_conf file, do you want to use the new version or keep you version". So i did " upgrade the file version"
After the upgrade, i connect to Zabbix website and i see this error below and no data. So i was thinking it was because of conf file, and i see that was missing DBPassword in conf File. But after Added pasword and restart, not better
.
But finally it was not an error but upgrade of database. After few minutes, Zabbix server works well but how to know if the upgrade of the database as worked ?
I am on Ubuntu 16 and now Zabbix 4.0.3. On my Ubuntu server i did apt-get upgrade and i had update for Zabbix server. Before upgrade Zabbix i did one backup of my database and Zabbix_server_conf file
When i did upgrade, the system said : "there is a new version of Zabbix_server_conf file, do you want to use the new version or keep you version". So i did " upgrade the file version"
After the upgrade, i connect to Zabbix website and i see this error below and no data. So i was thinking it was because of conf file, and i see that was missing DBPassword in conf File. But after Added pasword and restart, not better
.But finally it was not an error but upgrade of database. After few minutes, Zabbix server works well but how to know if the upgrade of the database as worked ?
Code:
[LEFT][COLOR=#F2F2F2][FONT=Courier New]******************** Profileur de script ********************[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]Temps total: 0.026404[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]Temps SQL total : 0.006033[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]Compte SQL : 21 (selects: 20 | executes : 10)[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]Pic d'utilisation de la mémoire : 4M[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]Limite mémoire: 128M[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]1. [/FONT][/COLOR][/LEFT]
[B]dashboard.get[/B] [LEFT][COLOR=#F2F2F2][FONT=Courier New][CControllerDashboardView.php:217][/FONT][/COLOR][/LEFT]
[TABLE="width: 0"]
[TR]
[TD]Paramètres:
Array
(
[output] => Array
(
[0] => dashboardid
[1] => name
[2] => userid
)
[selectWidgets] => Array
(
[0] => widgetid
[1] => type
[2] => name
[3] => x
[4] => y
[5] => width
[6] => height
[7] => fields
)
[dashboardids] => 1
[preservekeys] => 1
)[/TD]
[TD]Résultat:
Array
(
[1] => Array
(
[dashboardid] => 1
[name] => Global view
[userid] => 1
[widgets] => Array
(
[0] => Array
(
[widgetid] => 1
[type] => systeminfo
[name] =>
[x] => 0
[y] => 0
[width] => 4
[height] => 4
[fields] => Array
(
)
)
[1] => Array
(
[widgetid] => 2
[type] => problemsbysv
[name] =>
[x] => 4
[y] => 0
[width] => 6
[height] => 4
[fields] => Array
(
[0] => Array
(
[type] => 0
[name] => hide_empty_groups
[value] => 1
)
)
)
[2] => Array
(
[widgetid] => 3
[type] => clock
[name] =>
[x] => 10
[y] => 0
[width] => 2
[height] => 4
[fields] => Array
(
)
)
[3] => Array
(
[widgetid] => 4
[type] => problems
[name] =>
[x] => 0
[y] => 4
[width] => 10
[height] => 7
[fields] => Array
(
[0] => Array
(
[type] => 0
[name] => show
[value] => 3
)
[1] => Array
(
[type] => 0
[name] => show_tags
[value] => 3
)
)
)
[4] => Array
(
[widgetid] => 6
[type] => favgraphs
[name] =>
[x] => 10
[y] => 4
[width] => 2
[height] => 4
[fields] => Array
(
)
)
)
)
)[/TD]
[/TR]
[/TABLE]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]2. [/FONT][/COLOR][/LEFT]
[B]dashboard.get[/B] [LEFT][COLOR=#F2F2F2][FONT=Courier New][CControllerDashboardAbstract.php:34][/FONT][/COLOR][/LEFT]
[TABLE="width: 0"]
[TR]
[TD]Paramètres:
Array
(
[output] => Array
(
)
[dashboardids] => Array
(
[0] => 1
)
[editable] => 1
[preservekeys] => 1
)[/TD]
[TD]Résultat:
Array
(
[1] => Array
(
)
)[/TD]
[/TR]
[/TABLE]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]3. [/FONT][/COLOR][/LEFT]
[B]user.get[/B] [LEFT][COLOR=#F2F2F2][FONT=Courier New][CControllerDashboardView.php:404][/FONT][/COLOR][/LEFT]
[TABLE="width: 0"]
[TR]
[TD]Paramètres:
Array
(
[output] => Array
(
[0] => name
[1] => surname
[2] => alias
)
[userids] => 1
)[/TD]
[TD]Résultat:
Array
(
[0] => Array
(
[userid] => 1
[name] => Zabbix
[surname] => Administrator
[alias] => Admin
)
)[/TD]
[/TR]
[/TABLE]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (0.002493): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#429AE3][FONT=inherit]COMMIT[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (0.000144): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#59DB8F][FONT=inherit]SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.dashbrd.dashboardid'[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (9.6E-5): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#429AE3][FONT=inherit]BEGIN[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (0.000133): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#59DB8F][FONT=inherit]SELECT d.dashboardid,d.name,d.userid FROM dashboard d WHERE d.dashboardid='1'[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDashboard->get() → DBselect() in include/classes/api/services/CDashboard.php:131[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (0.000146): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#59DB8F][FONT=inherit]SELECT t.widgetid,t.type,t.name,t.x,t.y,t.width,t.height,t.dashboardid FROM widget t WHERE t.dashboardid='1'[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDashboard->get() → CDashboard->addRelatedObjects() → CApiService->select() → DBselect() in include/classes/api/CApiService.php:350[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (0.000164): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#59DB8F][FONT=inherit]SELECT widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid FROM widget_field WHERE widgetid IN (1,2,3,4,6)[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDashboard->get() → CDashboard->addRelatedObjects() → DB::select() → DBselect() in include/classes/db/DB.php:900[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (9.1E-5): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#429AE3][FONT=inherit]COMMIT[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (8.3E-5): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#429AE3][FONT=inherit]BEGIN[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CControllerDashboardAbstract->prepareEditableFlag() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (0.000113): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#59DB8F][FONT=inherit]SELECT d.dashboardid FROM dashboard d WHERE d.dashboardid='1'[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CControllerDashboardAbstract->prepareEditableFlag() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CDashboard->get() → DBselect() in include/classes/api/services/CDashboard.php:131[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (8.9E-5): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#429AE3][FONT=inherit]COMMIT[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CControllerDashboardAbstract->prepareEditableFlag() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (8.4E-5): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#429AE3][FONT=inherit]BEGIN[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CControllerDashboardView::getOwnerData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (0.000118): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#59DB8F][FONT=inherit]SELECT u.userid,u.name,u.surname,u.alias FROM users u WHERE u.userid='1'[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CControllerDashboardView::getOwnerData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->get() → DBselect() in include/classes/api/services/CUser.php:171[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (8.6E-5): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#429AE3][FONT=inherit]COMMIT[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView->getDashboard() → CControllerDashboardView::getOwnerData() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (0.000134): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#59DB8F][FONT=inherit]SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.dashbrd.widget.rf_rate'[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CControllerDashboardView::getWidgets() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (0.000136): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#59DB8F][FONT=inherit]SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.dashbrd.filter.active'[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (0.000159): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#59DB8F][FONT=inherit]SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.dashbrd.filter.from'[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → getTimeSelectorPeriod() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (0.000132): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#59DB8F][FONT=inherit]SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.dashbrd.filter.to'[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerDashboardView->doAction() → getTimeSelectorPeriod() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (0.000136): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#59DB8F][FONT=inherit]SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.layout.mode'[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CView::getLayoutMode() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (0.000143): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#59DB8F][FONT=inherit]SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.menu.view.last'[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → local_generateHeader() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (0.001227): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#59DB8F][FONT=inherit]SELECT c.* FROM config c[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → local_generateHeader() → CView->getOutput() → include() → select_config() → DBselect() in include/profiles.inc.php:33[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]SQL (0.000126): [/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#59DB8F][FONT=inherit]SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.login.attempt.failed'[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#F2F2F2][FONT=Courier New]zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → local_generateHeader() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164[/FONT][/COLOR][/LEFT]
Comment