Database connectivity error

[karanpreetsingh1990]

Hello,

I'm new to zabbix and have been trying to get an instance up and running with a remote MySql database but have hit a wall.

The connection suceeds from the backend and it's able to connect and start the zabbix-server but the setup on the frontend fails with the error:

• Error setting auto commit.

I've tried everything but can't seem to get it fixed. I would appreciate any help that can be provided for the same.

Thanks,
Karan

[karanpreetsingh1990]

Hello,

After much research I was able to resolve this. Turns out that even thought the Database user was set up to use the mysql_native_plugin, the default in the instance was still the newer scheme that doesn't seem to be working with the frontend or to be more specific php. I got the instance configuration changed to make the mysql_native_plugin. Once I got that changed and the instance restarted, this started working as expected.