7.0.0beta1 - Second proxy

[Cory Jones]

Hi All
I have Server running with one proxy has been working in our test environment for a few weeks now with no issue. I have tried to setup a new proxy but at the end of the setup the proxy service will not start giving the below error.

Job for zabbix-proxy.service failed because the service did not take the steps required by its unit configuration.

when i run systemctl status zabbix-proxy.service the only thing that stands out is below

Process: 2404 ExecStart=/usr/sbin/zabbix_proxy -c $CONFFILE (code=exited, status=0/SUCCESS)

and i see this in the logs.

2448:20240424:153853.296 using configuration file: /etc/zabbix/zabbix_proxy.conf
2448:20240424:153853.299 cannot use database "zabbix_proxy": Zabbix proxy cannot work with a Zabbix server database
2451:20240424:153905.545 Starting Zabbix Proxy (passive) [svrnmzp02]. Zabbix 7.0.0beta3 (revision 11b4728fed8).

I have compared the config to the running proxy and everthing sees to be the same.

Any help would be appreciated

[Cory Jones]

I found the issue, during the database installation and config run this command. Then Import initial schema and data. Complete the setup and check that the proxy is communication with the server then rerun the below command changing creators = 1 to creators = 0

sudo mysql -uroot -p'rootDBpass' -e "set global log_bin_trust_function_creators = 1;"

Just realized it does state this on the Zabbix Download page.

[cyber]

"2448:20240424:153853.299 cannot use database "zabbix_proxy": Zabbix proxy cannot work with a Zabbix server database"
You seem to have created server DB for your proxy ... They are different. Or .. there is something with installation scripts of beta3...

[Cory Jones]

I found the issue, during the database installation and config run this command. Then Import initial schema and data. Complete the setup and check that the proxy is communication with the server then rerun the below command changing creators = 1 to creators = 0

sudo mysql -uroot -p'rootDBpass' -e "set global log_bin_trust_function_creators = 1;"

Just realized it does state this on the Zabbix Download page.