Dear forum ,
i am facing a problem with the mysql database connection after we migrated servers.
the steps i folowed where as follows
1. made a complete backup of zabbix database using mysql dump.
2. on a new server installed mysql
3. created the zabbix user with the same creds as in the old server.
4. granted the same privileges as in the documentation
5. restored the database from the file that was backed up.
i am facing the following problem
although i can connect to mysql using "mysql -uzabbix -p",
when i try to start the zabbix server the service is not starting telling me that "one of the child processes is dead".
i am able to start the zabbix service if i specify DBUser=zabbix@localhost. if i have the original value DBUser=zabbix.
The service will not start.
As a result in my frontend i get the notofocation that the zabbix service is not started and i do not get any data shown.
all other functionality is as expected. Data has migrated and i can see hosts and hostory information as well as all my maps and so
any suggestion will be appriciated. thank you
Billy Kantartzis
i am facing a problem with the mysql database connection after we migrated servers.
the steps i folowed where as follows
1. made a complete backup of zabbix database using mysql dump.
2. on a new server installed mysql
3. created the zabbix user with the same creds as in the old server.
4. granted the same privileges as in the documentation
5. restored the database from the file that was backed up.
i am facing the following problem
although i can connect to mysql using "mysql -uzabbix -p",
when i try to start the zabbix server the service is not starting telling me that "one of the child processes is dead".
i am able to start the zabbix service if i specify DBUser=zabbix@localhost. if i have the original value DBUser=zabbix.
The service will not start.
As a result in my frontend i get the notofocation that the zabbix service is not started and i do not get any data shown.
all other functionality is as expected. Data has migrated and i can see hosts and hostory information as well as all my maps and so
any suggestion will be appriciated. thank you
Billy Kantartzis
Comment