I needed to change my database port and now the gui will not connect.
systems:
database is on a server qa-zbx-clusterdb
zabbix-server is on qa-zbx-node1
gui and other php scritps is on qa-zbx-web01
I needed to change my database port and now the gui will not connect.
I was building up a model of a large system with HA and failover. We tried to use the MySQL 8.0.16 Sandbox,, I got it up and going, but found as we added systems the high IO of zabbix quickly out paced the hardware we used. So I wanted to just back down to a single instance database. In doing this I move the database port from the 6446 to 3306.
in MySQL user table I have a user zabbix@% with all privileges on zabbix.*
I edited the zabbix_server.conf and restarted that service. I seeing the zabbix_server.log and it is now connecting.
Next I edited the /usr/share/zabbix/conf/zabbix.conf.php to change the port.
my problem is when I watch the in coming connections I still see connections on port 6446.
I tried to remove the zabbix-web and reinstall.
I wrote a cheesey php connection test that works, then I added a query to the database that works ok,
Wondering if there is a different place the port for the database connection I can edits?
database is on a server qa-zbx-clusterdb
zabbix-server is on qa-zbx-node1
gui and other php scritps is on qa-zbx-web01
I needed to change my database port and now the gui will not connect.
I was building up a model of a large system with HA and failover. We tried to use the MySQL 8.0.16 Sandbox,, I got it up and going, but found as we added systems the high IO of zabbix quickly out paced the hardware we used. So I wanted to just back down to a single instance database. In doing this I move the database port from the 6446 to 3306.
in MySQL user table I have a user zabbix@% with all privileges on zabbix.*
I edited the zabbix_server.conf and restarted that service. I seeing the zabbix_server.log and it is now connecting.
Next I edited the /usr/share/zabbix/conf/zabbix.conf.php to change the port.
my problem is when I watch the in coming connections I still see connections on port 6446.
I tried to remove the zabbix-web and reinstall.
I wrote a cheesey php connection test that works, then I added a query to the database that works ok,
Wondering if there is a different place the port for the database connection I can edits?