Erro após atualizar zabbix

[nizopi]

Boa noite, sou iniciante no Zabbix e estava tudo funcionando normalmente, após um apt-get upgrade e reinicio do servidor não consigo mais logar na interface web do Zabbix, aparece a seguinte mensagem:

Configuration file error
DB type "MYSQL" is not supported by current setup.

Sei que ele atualizou o zabbix-frontend-php e algo relacionando ao MySQL, depois disso fiz o comando apt-get autoremove que foi indicado pelo próprio sistema.

o Linux é o Ubuntu server bionic

Poderiam me ajudar ?

[Hernandes Martins]

Olá meu caro,

1- Qual a versão do Mysql ?
2- Qual a versão atual do zabbix ?
3- Qual a mensagem de erro que aparece no log zabbix_server.log?

[nizopi]

Boa tarde Hernandes Martins , desculpa a demora, só tivemos acesso hoje ao servidor;

1- Qual a versão do Mysql ?
mysql Ver 15.1 Distrib 10.0.34-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

2- Qual a versão atual do zabbix ?
zabbix_server (Zabbix) 3.4.14
Revision 84877 14 September 2018, compilation time: Sep 14 2018 07:23:21


3- Qual a mensagem de erro que aparece no log zabbix_server.log?
No log aparece varios dados, como se ele estivesse rodando normalmente e gravando os dados, mas não sei se realmente isso esta acontecendo, vou te mandar uma parte do final do log:

2135:20180917:143334.643 slow query: 4.946464 sec, "insert into history_uint (itemid,clock,ns,value) values (45218,1537205608,706202888,2),(45235,1537205608,7 06202888,1),(44931,1537205608,706202888,0),(45229, 1537205608,706202888,1),(45108,1537205608,70620288 8,0),(44919,1537205608,706202888,7776),(45119,1537 205608,706202888,0),(44914,1537205608,706202888,54 488),(44946,1537205608,706202888,0),(45115,1537205 608,706202888,543976),(45096,1537205608,706202888, 0),(44904,1537205608,706202888,2384),(45080,153720 5608,706202888,62880),(44920,1537205608,706202888, 7120),(45122,1537205608,706202888,0),(44922,153720 5608,706202888,0),(45109,1537205608,706202888,0),( 45092,1537205608,706202888,170784),(44948,15372056 08,706202888,0),(45118,1537205608,706202888,0),(44 949,1537205608,706202888,0),(44934,1537205608,7062 02888,0),(45110,1537205608,706202888,0),(45098,153 7205608,706202888,0),(45107,1537205608,706202888,0 ),(45202,1537205608,706202888,2),(44921,1537205608 ,706202888,0),(44917,1537205608,706202888,0),(4490 0,1537205608,706202888,0),(44925,1537205608,706202 888,15848),(44932,1537205608,706202888,0),(45069,1 537205608,706202888,127024),(45195,1537205608,7062 02888,1),(44926,1537205608,706202888,3520),(44923, 1537205608,706202888,1320),(45120,1537205608,70620 2888,0),(45191,1537205608,706202888,2),(44938,1537 205608,706202888,0),(45112,1537205608,706202888,0) ,(44927,1537205608,706202888,800),(45105,153720560 8,706202888,0),(45075,1537205608,706202888,93672), (45083,1537205608,706202888,802504),(44918,1537205 608,706202888,27912),(44908,1537205608,706202888,0 ),(45123,1537205608,706202888,0),(44911,1537205608 ,706202888,0),(44909,1537205608,706202888,320),(44 933,1537205608,706202888,0),(45074,1537205608,7062 02888,129344),(44936,1537205608,706202888,0),(4467 9,1537205608,966285226,2),(44684,1537205608,966285 226,2),(44725,1537205608,966285226,1),(44590,15372 05608,966285226,63328),(44604,1537205608,966285226 ,132264),(44438,1537205608,966285226,4896),(44729, 1537205608,966285226,2),(43928,1537205608,96628522 6,1),(44450,1537205608,966285226,0),(44687,1537205 608,966285226,2),(44575,1537205608,966285226,0),(4 4426,1537205608,966285226,0),(44711,1537205608,966 285226,1),(44608,1537205608,966285226,128896),(444 21,1537205608,966285226,1320),(44408,1537205608,96 6285226,0),(44581,1537205608,966285226,130016),(44 697,1537205608,966285226,1),(44707,1537205608,9662 85226,1),(40386,1537205608,966285226,1199084),(447 12,1537205608,966285226,2),(44731,1537205608,96628 5226,1),(44699,1537205608,966285226,2),(44683,1537 205608,966285226,2),(44692,1537205608,966285226,1) ,(44702,1537205608,966285226,1),(44698,1537205608, 966285226,1),(44703,1537205608,966285226,2),(44721 ,1537205608,966285226,1),(44682,1537205608,9662852 26,2),(44677,1537205608,966285226,2),(44691,153720 5608,966285226,1),(44685,1537205608,966285226,2),( 44690,1537205608,966285226,2),(44716,1537205608,96 6285226,1),(44728,1537205608,966285226,1),(44695,1 537205608,966285226,1),(44726,1537205608,966285226 ,1),(44713,1537205608,966285226,1),(44724,15372056 08,966285226,2),(44686,1537205608,966285226,2),(44 397,1537205608,966285226,0),(44443,1537205608,9662 85226,1055656),(44255,1537205608,966285226,5368709 12),(44439,1537205608,966285226,0),(44580,15372056 08,966285226,129880),(44445,1537205608,966285226,0 ),(44615,1537205608,966285226,0),(44603,1537205608 ,966285226,0),(40347,1537205608,967144430,1),(4022 7,1537205608,967171030,1),(40107,1537205608,967193 030,1),(33808,1537205608,970581743,0),(23308,15372 05608,970777144,1537205608),(45188,1537205609,2423 25428,2),(45204,1537205609,242325428,1),(45210,153 7205609,242325428,2),(45221,1537205609,242325428,2 ),(45194,1537205609,242325428,1),(45081,1537205609 ,242325428,161096),(44945,1537205609,242325428,0), (44953,1537205609,242325428,0),(45225,1537205609,2 42325428,1),(45180,1537205609,242325428,2),(45207, 1537205609,242325428,1),(45208,1537205609,24232542 8,2),(45182,1537205609,242325428,1),(45220,1537205 609,242325428,2),(45196,1537205609,242325428,1),(4 5190,1537205609,242325428,1),(45226,1537205609,242 325428,2),(45216,1537205609,242325428,2),(45212,15 37205609,242325428,2),(45197,1537205609,242325428, 2),(45205,1537205609,242325428,1),(45234,153720560 9,242325428,2),(45183,1537205609,242325428,2),(452 13,1537205609,242325428,2),(45224,1537205609,24232 5428,2),(45206,1537205609,242325428,1),(45192,1537 205609,242325428,1),(45222,1537205609,242325428,2) ,(44943,1537205609,242325428,0),(45228,1537205609, 242325428,2),(45198,1537205609,242325428,1),(45200 ,1537205609,242325428,1),(45223,1537205609,2423254 28,2),(45070,1537205609,242325428,65600),(45230,15 37205609,242325428,1),(45181,1537205609,242325428, 1),(45214,1537205609,242325428,2),(45231,153720560 9,242325428,1),(45187,1537205609,242325428,1),(449 03,1537205609,242325428,0),(45233,1537205609,24232 5428,2),(45217,1537205609,242325428,2),(45215,1537 205609,242325428,2),(45073,1537205609,242325428,0) ,(45193,1537205609,242325428,1),(45185,1537205609, 242325428,2),(45209,1537205609,242325428,2),(23309 ,1537205609,243321232,984608768),(50609,1537205609 ,246113243,0),(33809,1537205609,248382452,0),(4470 8,1537205609,515756320,1),(44587,1537205609,515756 320,0),(44430,1537205609,515756320,5168),(44730,15 37205609,515756320,2),(44609,1537205609,515756320, 63616),(44696,1537205609,515756320,1),(44681,15372 05609,515756320,2),(44259,1537205609,515756320,1), (44678,1537205609,515756320,2),(44680,1537205609,5 15756320,2),(44719,1537205609,515756320,2),(44717, 1537205609,515756320,2),(44715,1537205609,51575632 0,2),(44727,1537205609,515756320,1),(44935,1537205 609,614642515,0),(45189,1537205609,614642515,1),(4 5232,1537205609,614642515,1),(45186,1537205609,614 642515,1),(45201,1537205609,614642515,2),(45078,15 37205609,614642515,353136),(45227,1537205609,61464 2515,1),(45097,1537205609,614642515,0),(45203,1537 205609,614642515,1),(45199,1537205609,614642515,1) ,(45219,1537205609,614642515,2),(44916,1537205609, 614642515,648),(45211,1537205609,614642515,2),(404 39,1537205609,614642515,1199080),(45184,1537205609 ,614642515,1),(52117,1537205609,620148037,32);
"
2125:20180917:143400.776 slow query: 16.952231 sec, "select i.itemid,i.hostid,i.status,i.type,i.value_type,i.k ey_,i.snmp_community,i.snmp_oid,i.port,i.snmpv3_se curityname,i.snmpv3_securitylevel,i.snmpv3_authpas sphrase,i.snmpv3_privpassphrase,i.ipmi_sensor,i.de lay,i.trapper_hosts,i.logtimefmt,i.params,i.state, i.authtype,i.username,i.password,i.publickey,i.pri vatekey,i.flags,i.interfaceid,i.snmpv3_authprotoco l,i.snmpv3_privprotocol,i.snmpv3_contextname,i.las tlogsize,i.mtime,i.history,i.trends,i.inventory_li nk,i.valuemapid,i.units,i.error,i.jmx_endpoint,i.m aster_itemid from items i,hosts h where i.hostid=h.hostid and h.status in (0,1) and i.flags<>2"
2129:20180917:143402.424 slow query: 36.204982 sec, "delete from history_uint where itemid=39049 limit 5000"
2125:20180917:143405.501 slow query: 4.671783 sec, "select distinct t.triggerid,t.description,t.expression,t.error,t.p riority,t.type,t.value,t.state,t.lastchange,t.stat us,t.recovery_mode,t.recovery_expression,t.correla tion_mode,t.correlation_tag from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and h.status in (0,1) and t.flags<>2"

================================================== ================================================== ==========================

Informações adicionais:

Em anexo o retorno do comando: systemctl status mysql

E o comando tail -f /var/log/mysql/error.log

não retorna nada, volta para o #

Atenciosamente.

[nizopi]

Erro MySQL

[nizopi]

Boa Tarde, encontramos um link no fórum que nos ajudou a solucionar o problema, pode marcar como resolvido por favor:

o Link:

https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/45843-zabbix-3-0-db-type-mysql-is-not-supported-by-current-setup-possible-values/page2

Seguimos o procedimento citado pelo MR_Andrew

Só não executamos o comando abaixo por não sabermos qual sua função exatamente, se alguém puder nos explicar ficaremos gratos.

# php -r "phpinfo();" 2>/dev/null | egrep -i ^mysql | grep Support MysqlI Support => enabled
Atenciosamente.