zabbix起動失敗

初期設定の最終段階でMySQLがらみのエラーが出力されて、ログインができていない。

* Error in query [SELECT * FROM nodes WHERE nodetype=1 order by nodeid] [Table ‘zabbix.nodes’ doesn’t exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:524]
* Error in query [SELECT u.* FROM users u WHERE u.alias=’guest’ AND (u.userid div 100000000000000) in (0) ] [Table ‘zabbix.users’ doesn’t exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:524]
* Error in query [UPDATE sessions SET status=1 WHERE sessionid=”] [Table ‘zabbix.sessions’ doesn’t exist]
* Error in query [SELECT count(u.userid) as user_cnt FROM users u] [Table ‘zabbix.users’ doesn’t exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:524]
* Error in query [SELECT * FROM config WHERE (configid div 100000000000000) in (0) ] [Table ‘zabbix.config’ doesn’t exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:524]
* Use of undefined constant S_INSTALLATION – assumed ‘S_INSTALLATION'[/var/www/html/zabbix/include/profiles.inc.php:341]
* Unable to select configuration
* Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=0 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Table ‘zabbix.groups’ doesn’t exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:524]
* Error in query [SELECT * FROM nodes WHERE nodeid=0] [Table ‘zabbix.nodes’ doesn’t exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:524]
* Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=0 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Table ‘zabbix.groups’ doesn’t exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:524]
* Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=0 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Table ‘zabbix.groups’ doesn’t exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:524]
* Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=0 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Table ‘zabbix.groups’ doesn’t exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:524]
* Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=0 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Table ‘zabbix.groups’ doesn’t exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:524]
* Error in query [SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM groups hg LEFT JOIN rights r ON r.id=hg.groupid LEFT JOIN users_groups g ON r.groupid=g.usrgrpid AND g.userid=0 LEFT JOIN nodes n ON (hg.groupid div 100000000000000)=n.nodeid WHERE (hg.groupid div 100000000000000) in (0) GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid ORDER BY node_name, hg.name, permission ] [Table ‘zabbix.groups’ doesn’t exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:524]
* Error in query [SELECT * FROM config WHERE (configid div 100000000000000) in (0) ] [Table ‘zabbix.config’ doesn’t exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:524]
* Unable to select configuration

Add a Comment

このサイトはスパムを低減するために Akismet を使っています。コメントデータの処理方法の詳細はこちらをご覧ください