Help to migrate zabbix from CentOS to Ubuntu

[vu_poppy]

Hi All,

As you know, The new version of zabbix don't support with CentOS 7. So, i want to migrate database from CentOS to Ubuntu. But, after import database to Ubuntu bionic, my table zabbix.users is empty. Can i create userid in zabbix.users ?

When table zabbix.users is empty, i can't log in zabbix web by user: Admin & password: zabbix.

The problem's happening when i finished install zabbix-server, import database and go to step login zabbix on web.

[LenR]

If Zabbix worked on Centos, it had a user table, it it's not there on your Ubunto system, you have a db migration problem. Check your other tables, do any have content? How did you migrate the database?

[vu_poppy]

Hi LenR,

On CentOS, it available a user table. But, i don't know when import and export to Ubuntu. it missed that table.

I run command export :
- mysqldump -uzabbix -p > zabbixdata.sql

and import:
- mysql -uroot -p zabbix < zabbixdata.sql

I also try to export by PHPMyAdmin. It same error.

[Atsushi]

Have you checked the contents of zabbixdata.sql?
I think it's better to explicitly specify the database name when you get the dump.

ex.

$ mysqldump -uzabbix -p zabbix > zabbixdata.sql

[vu_poppy]

Thanks Atsushi 's comment. I try to rebuild other zabbix-server. After input database, i receive error in below. I can't start zabbix-server.

[Atsushi]

The message in the image file you pasted is not an error. If Zabbix server cannot be started, please show the log of the error part.