Database Error: frontend does not match Zabbix database

[Kane36]

Hello,

i have a big problem with my zabbix database, since i've changed my sql root password and restart the suse linux system.
Two other programs also use a sql database and they still work without any problems.
Only Zabbix shows now this failure message...




Here are the config files:

$DB['TYPE'] = 'MYSQL';
$DB['SERVER'] = 'localhost';
$DB['PORT'] = '0';
$DB['DATABASE'] = 'zabbix';
$DB['USER'] = 'zabbix';
$DB['PASSWORD'] = 'zabbix';

DBHost=localhost

DBName=zabbix

DBUser=zabbix

DBPassword=zabbix

Login with user zabbix to sql works




Here is the Zabbix_Server log

7147:20150912:232005.848 Starting Zabbix Server. Zabbix 2.4.0 (revision 48953).
7147:20150912:232005.855 ****** Enabled features ******
7147:20150912:232005.855 SNMP monitoring: YES
7147:20150912:232005.855 IPMI monitoring: YES
7147:20150912:232005.856 WEB monitoring: YES
7147:20150912:232005.856 VMware monitoring: YES
7147:20150912:232005.856 Jabber notifications: NO
7147:20150912:232005.856 Ez Texting notifications: YES
7147:20150912:232005.856 ODBC: NO
7147:20150912:232005.856 SSH2 support: YES
7147:20150912:232005.856 IPv6 support: NO
7147:20150912:232005.856 ******************************
7147:20150912:232005.856 using configuration file: /opt/zabbix/etc/zabbix_server.conf
7147:20150912:232005.858 [Z3005] query failed: [1033] Incorrect information in file: './zabbix/users.frm' [select userid from users limit 1]
7147:20150912:232005.858 cannot use database "zabbix": database is not a Zabbix database

I also tried this steps under sql

1.

mysql -u root -p
grant all privileges on zabbix.* to zabbix@localhost identified by 'zabbix';
flush privileges;
quit

2.

mysql -u root -p
update mysql.user set password=PASSWORD("zabbix") where User='zabbix';
quit

If i want backup the zabbix database i get this error




Has anyone an idea how to resolve this? I don't have much experience with sql and would loose a lot of work if my database is destroyed.
If i create a new one and insert it in the config files zabbix works again, but is complete empty....

[Kane36]

My database works now!
I contacted a linux specialist which also help us with linux problems in my work.
Now i had to pay about 100€ but the important thing is that i didn't loose all my zabbix data.
I didn't let explain him the solution because every minute of his time cost money.
He told me that mysql couldn't start the zabbix database because it is the only InnoDB of my sql databases.
He changed the parameter innodb_lofile_size from 256 to 5m and insert some commands via console.
Here is the history of his commands....

930 2015-09-14 06:38:46 vi /etc/my.cnf
931 2015-09-14 12:34:30 cd /var/lib/mysql/
932 2015-09-14 12:34:30 ls -l
933 2015-09-14 12:34:32 ls
934 2015-09-14 12:34:39 find -type d
935 2015-09-14 12:34:43 ls -l zabbix/
936 2015-09-14 12:34:52 ls -l /var/log/mysql/
937 2015-09-14 12:35:02 ls -lrt /var/log/
938 2015-09-14 12:35:06 less /var/log/messages
939 2015-09-14 12:35:33 dmesg | less
940 2015-09-14 12:36:06 less /var/log/warn
941 2015-09-14 12:36:10 cd /var/log/
942 2015-09-14 12:36:15 ls -l zabbix/
943 2015-09-14 12:36:21 ls -lrt zabbix/
944 2015-09-14 12:36:29 less zabbix/zabbix_server.
945 2015-09-14 12:36:31 less zabbix/zabbix_server.log
946 2015-09-14 12:36:55 mysql
947 2015-09-14 12:36:58 mysql zabbix/
948 2015-09-14 12:36:58 mysql zabbix
949 2015-09-14 12:37:01 mysql
950 2015-09-14 12:37:04 mysql mysql
951 2015-09-14 12:37:11 mysql -u root -p mysql
952 2015-09-14 12:37:58 cd /var/lib/mysql/zabbix/
953 2015-09-14 12:37:58 ls -l
954 2015-09-14 12:38:06 file *
955 2015-09-14 12:38:12 ls -l
956 2015-09-14 12:38:19 ls -lrt
957 2015-09-14 12:38:32 ls -lrSh
958 2015-09-14 12:38:47 ls -l *.frm
959 2015-09-14 12:38:49 file *.frm
960 2015-09-14 12:39:07 file ../mysql/*.frm
961 2015-09-14 12:39:11 file *.frm
962 2015-09-14 12:39:16 ls -l *.frm
963 2015-09-14 12:39:24 als -lrt *.frm
964 2015-09-14 12:39:27 ls -lrt *.frm
965 2015-09-14 12:39:35 vi users.frm
966 2015-09-14 12:39:42 head -n users.frm
967 2015-09-14 12:39:45 head -n 1 users.frm
968 2015-09-14 12:39:52 head -n 1 sessions.frm
969 2015-09-14 12:40:06 head -n 1 ../mysql/help_keyword.frm
970 2015-09-14 12:40:13 head -n 1 ../mysql/host.frm
971 2015-09-14 12:40:21 head -n 1 ../mysql/proc.frm
972 2015-09-14 12:40:27 find .. -type d
973 2015-09-14 12:40:44 head -n 1 ../otrs/link_state.frm
974 2015-09-14 12:40:59 mysql -u root -p mysql
975 2015-09-14 12:42:47 vi /etc/my.cnf
976 2015-09-14 12:43:02 ls -l /etc/my.cnf
977 2015-09-14 12:43:09 vi /etc/my.cnf
978 2015-09-14 12:43:23 ls -l /var/log/mysql/
979 2015-09-14 12:43:26 vi /etc/my.cnf
980 2015-09-14 12:43:36 ls -l /var/lib/mysql/
981 2015-09-14 12:43:51 less /var/lib/mysql/mysqld.log
982 2015-09-14 12:44:06 ls -lrt /var/lib/mysql/mysqld.log*
983 2015-09-14 12:44:20 less /var/lib/mysql/mysqld.log-20150914
984 2015-09-14 12:45:05 cd ..
985 2015-09-14 12:45:06 ls -l
986 2015-09-14 12:45:09 ls -l ib*
987 2015-09-14 12:45:27 less /var/lib/mysql/mysqld.log-20150914
988 2015-09-14 12:45:39 vi /etc/my.cnf
989 2015-09-14 12:46:00 less /var/lib/mysql/mysqld.log-20150914
990 2015-09-14 12:46:17 vi /etc/my.cnf
991 2015-09-14 12:46:24 /etc/init.d/mysql stop
992 2015-09-14 12:46:29 ps aux | grep mysql
993 2015-09-14 12:46:32 cd ..
994 2015-09-14 12:46:39 du -hcs mysql/
995 2015-09-14 12:46:43 df -h .
996 2015-09-14 12:46:45 cp -a mysql/ mysql.bak
997 2015-09-14 12:46:54 screen

show databases;
use zabbix
show tables;
select * FROM users;
select * FROM trends;
select * FROM rights;

[teskistajer]

well i searched the forum and found the exact problem (with solution)

https://www.zabbix.com/forum/showthread.php?t=12407

you wasted your money bro just google the problem next time
type Incorrect information in file: './zabbix/users.frm to google or zabbix forum

Edit : or if you needed fast solution you can contact with "zabbix paid support"
http://www.zabbix.com/consulting.php
http://www.zabbix.com/support.php