erro zabbix

[henderson]

Boa tarde a todos,aconteceu um problema comigo quando estava finalizando a instalação do zabbix.o erro é esse aí:
* 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[/usr/local/share/zabbix/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:546]
* Error in query [SELECT u.*,s.* FROM sessions s,users u WHERE s.sessionid='f4bc26c8a219289c0dc5ba2bf6316bd8' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1280521442) OR (u.autologout=0)) AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))] [Table 'zabbix.sessions' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:546]
* Error in query [SELECT u.* FROM users u WHERE u.alias='guest' AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))] [Table 'zabbix.users' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:546]
* Error in query [UPDATE sessions SET status=1 WHERE sessionid='f4bc26c8a219289c0dc5ba2bf6316bd8'] [Table 'zabbix.sessions' doesn't exist]
* Error in query [SELECT * FROM config WHERE ((configid BETWEEN 000000000000000 AND 099999999999999))] [Table 'zabbix.config' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:546]
* Unable to select configuration
* Error in query [SELECT * FROM profiles WHERE userid=0 AND ((profileid BETWEEN 000000000000000 AND 099999999999999)) ORDER BY userid ASC, profileid ASC] [Table 'zabbix.profiles' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:546]
gostaria de saber se alguem sabe como corrigir esse erro.Desde já agradecido.

[exkg]

Se tah instalando ... remove o banco e cria novamente.

O erro eh bastante claro: algumas tabelas NAO existem no teu banco.


[]s,
Luciano

[henderson]

banco de dados

alguem pode me explicar como eu faço pra apagar o banco de dados e criar um novo pro zabbix,pois sou novo e linux e estou com algumas dificuldades.

desde já agradecido e esperando um retorno,


Henderson.

[exkg]

Oi Henderson,

Se eh novo no Linux (e no ZABBIX) tens que ter cuidado com o que vai ler e receber como sugestoes para solucao dos erros/problemas encontrados ...

De uma forma simples precisa executar mysqladmin drop <nome do banco do zabbix>, mas aqui vao iniciar as tuas duvidas ... qual o usuario para o banco ? O teu banco tem senha ? O teu banco tah na mesma maquina ? O nome do banco que tuh criou eh zabbix ? Pelo teu log tuh estah (e pretende?!?!?) continuar utilizando MySQL ?


Sugiro uma olhada nos DOCs sobre o MySQL jah que criar/remover/limpar banco eh um processo que envolve outra ferramenta (PGsql, MySQL, Oracle ou SQLITE). Cada banco tem suas particularidades, blah, blah, blah ...


Boa sorte e nao deixa de pedir apoio sobre o ZABBIX qd precisar

[]s,
Luciano

[henderson]

estou instalando no cent0s 5.4 e autentico ele n servidor de banco de dados de outra máquina,e o usuario e banco tem o nome de zabbix.quando fiz o processo de instalação no ambiente web deu tudo ok,ele autenticou normal no banco de dados,aí quando finalizei a instalaçãofoi que ele apresentou esse erro:
* 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[/usr/local/share/zabbix/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:546]
* Error in query [SELECT u.*,s.* FROM sessions s,users u WHERE s.sessionid='f4bc26c8a219289c0dc5ba2bf6316bd8' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1280521442) OR (u.autologout=0)) AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))] [Table 'zabbix.sessions' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:546]
* Error in query [SELECT u.* FROM users u WHERE u.alias='guest' AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))] [Table 'zabbix.users' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:546]
* Error in query [UPDATE sessions SET status=1 WHERE sessionid='f4bc26c8a219289c0dc5ba2bf6316bd8'] [Table 'zabbix.sessions' doesn't exist]
* Error in query [SELECT * FROM config WHERE ((configid BETWEEN 000000000000000 AND 099999999999999))] [Table 'zabbix.config' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:546]
* Unable to select configuration
* Error in query [SELECT * FROM profiles WHERE userid=0 AND ((profileid BETWEEN 000000000000000 AND 099999999999999)) ORDER BY userid ASC, profileid ASC] [Table 'zabbix.profiles' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:546]

Aí é a minha duvida e não estou sabendo o que fazer,se é pra mexer no banco de dados do outro servidor,ou se tenho que mexer em alguma coisa na maquina onde está instalado o zabbix.

[lluner]

como esta configurado o ambiente .... o zabbix e o anco estao na mesma maquina

[henderson]

erro zabbix

o banco está configurado em outra máquina.e aí alguma sugestão para o erro:
* 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[/usr/local/share/zabbix/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:546]
* Error in query [SELECT u.*,s.* FROM sessions s,users u WHERE s.sessionid='f4bc26c8a219289c0dc5ba2bf6316bd8' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1280521442) OR (u.autologout=0)) AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))] [Table 'zabbix.sessions' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:546]
* Error in query [SELECT u.* FROM users u WHERE u.alias='guest' AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))] [Table 'zabbix.users' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:546]
* Error in query [UPDATE sessions SET status=1 WHERE sessionid='f4bc26c8a219289c0dc5ba2bf6316bd8'] [Table 'zabbix.sessions' doesn't exist]
* Error in query [SELECT * FROM config WHERE ((configid BETWEEN 000000000000000 AND 099999999999999))] [Table 'zabbix.config' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:546]
* Unable to select configuration
* Error in query [SELECT * FROM profiles WHERE userid=0 AND ((profileid BETWEEN 000000000000000 AND 099999999999999)) ORDER BY userid ASC, profileid ASC] [Table 'zabbix.profiles' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/usr/local/share/zabbix/include/db.inc.php:546]