Discussion :

[PAPITA]

SAlut à tous quelqu'un qui a deja installer zabbix serveur peut m'aider.
Je suis sur l'interface de connexion et il m'affiche les erreurs suivantes :

# rror 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[/usr/share/zabbix/include/db.inc.php:519]
# 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[/usr/share/zabbix/include/db.inc.php:519]
# 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[/usr/share/zabbix/include/db.inc.php:519]
# Error in query [SELECT DISTINCT n.nodeid, n.name as node_name, h.hostid, h.host, min(r.permission) as permission, ug.userid FROM hosts h LEFT JOIN hosts_groups hg ON hg.hostid=h.hostid LEFT JOIN groups g ON g.groupid=hg.groupid LEFT JOIN rights r ON r.id=g.groupid LEFT JOIN users_groups ug ON ug.usrgrpid=r.groupid and ug.userid=0 LEFT JOIN nodes n ON (h.hostid div 100000000000000)=n.nodeid WHERE (h.hostid div 100000000000000) in (0) GROUP BY h.hostid,n.nodeid,n.name,h.host,ug.userid ORDER BY n.name,n.nodeid, h.host, permission, ug.userid ] [Table 'zabbix.hosts' doesn't exist]
# mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
# 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[/usr/share/zabbix/include/db.inc.php:519]
# Use of undefined constant S_INSTALLATION - assumed 'S_INSTALLATION'[/usr/share/zabbix/include/profiles.inc.php:341]
# Unable to select configuration
# 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[/usr/share/zabbix/include/db.inc.php:519]
# Error in query [SELECT DISTINCT n.nodeid, n.name as node_name, h.hostid, h.host, min(r.permission) as permission, ug.userid FROM hosts h LEFT JOIN hosts_groups hg ON hg.hostid=h.hostid LEFT JOIN groups g ON g.groupid=hg.groupid LEFT JOIN rights r ON r.id=g.groupid LEFT JOIN users_groups ug ON ug.usrgrpid=r.groupid and ug.userid=0 LEFT JOIN nodes n ON (h.hostid div 100000000000000)=n.nodeid WHERE (h.hostid div 100000000000000) in (0) GROUP BY h.hostid,n.nodeid,n.name,h.host,ug.userid ORDER BY n.name,n.nodeid, h.host, permission, ug.userid ] [Table 'zabbix.hosts' doesn't exist]
# mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
# Error in query [SELECT DISTINCT n.nodeid, n.name as node_name, h.hostid, h.host, min(r.permission) as permission, ug.userid FROM hosts h LEFT JOIN hosts_groups hg ON hg.hostid=h.hostid LEFT JOIN groups g ON g.groupid=hg.groupid LEFT JOIN rights r ON r.id=g.groupid LEFT JOIN users_groups ug ON ug.usrgrpid=r.groupid and ug.userid=0 LEFT JOIN nodes n ON (h.hostid div 100000000000000)=n.nodeid WHERE (h.hostid div 100000000000000) in (0) GROUP BY h.hostid,n.nodeid,n.name,h.host,ug.userid ORDER BY n.name,n.nodeid, h.host, permission, ug.userid ] [Table 'zabbix.hosts' doesn't exist]
# mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
# 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[/usr/share/zabbix/include/db.inc.php:519]
# Unable to select configuration
# Timezone for PHP is not set. Please set "date.timezone" option in php.ini.
Merci d'avance

[Invité]

[CODE]# 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][/CODE]

Salut,

Tes tables n'existent pas. As-tu créé la base de données avec les tables nécessaires au fonctionnement de l'application?

[PAPITA]

Merci bien
Je suis debutant sous linux et j'utilise Ubuntu .Zabbix se trouvant dans la distribution .
C'est à travers des tuto que je poursuit la realisation de ce serveur , mais la dedans il n'est pas expliqué franchement les champs de la database zabbix.
Et moi c'est en regardant sur l'ecran de connection que j'ai vu et pris comme champ de la BD login name et password .
Je pense que tu dois avoir raison pour le BD et les tables necessaire.
Je crois que ca doit etre cela.
Mais que dois je faire dan s ce cas peux tu m'aider.

Merci bien pour l'aide

[PAPITA]

Merci bien
Je suis debutant sous linux et j'utilise Ubuntu .Zabbix se trouvant dans la distribution .
C'est à travers des tuto que je poursuit la realisation de ce serveur , mais la dedans il n'est pas expliqué franchement les champs de la database zabbix.
Et moi c'est en regardant sur l'ecran de connection que j'ai vu et pris comme champ de la BD login name et password .
Je pense que tu dois avoir raison pour le BD et les tables necessaire.
Je crois que ca doit etre cela.
Mais que dois je faire dan s ce cas peux tu m'aider.

Merci bien pour l'aide

[Invité]

Tout est expliqué clairement dans la documentation de zabbix. Il suffit de la lire un peu.

http://www.zabbix.com/documentation/...n/requirements