Monitoraggio di mysql con Zabbix - Revision history

Gabriele.vivinetto at 10:57, 26 July 2023

2023-07-26T10:57:44Z

← Older revision		Revision as of 10:57, 26 July 2023
Line 10:		Line 10:

	* Definire le macro nel template Mysql Agent2		* Definire le macro nel template Mysql Agent2
	MYSQL.DSN
			MYSQL.DSN = tcp://localhost:3306

			MYSQL.USERNAME = zabbix_agent

	MYSQL.PASSWORD		MYSQL.PASSWORD
	~~MYSQL.USERNAME~~

	=Agent=		=Agent=

Gabriele.vivinetto at 14:03, 11 February 2023

2023-02-11T14:03:57Z

← Older revision		Revision as of 14:03, 11 February 2023
Line 6:		Line 6:

	GRANT REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW ON . TO 'zabbix_agent'@'localhost';		GRANT REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW ON . TO 'zabbix_agent'@'localhost';

			* Installare il Template Mysql Agent2 https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/mysql_agent2

	* Definire le macro nel template Mysql Agent2		* Definire le macro nel template Mysql Agent2
	~~MYSQL_DSN~~		MYSQL.DSN
	~~MYSQL_PASSWORD~~		MYSQL.PASSWORD
	~~MYSQL_USERNAME~~		MYSQL.USERNAME

	=Agent=		=Agent=

Gabriele.vivinetto at 14:03, 11 February 2023

2023-02-11T14:03:17Z

← Older revision		Revision as of 14:03, 11 February 2023
Line 1:		Line 1:
			=Agent2=

			* Creare lo user, con questi diritti:

			CREATE USER 'zabbix_agent'@'localhost' IDENTIFIED BY '<password>';

			GRANT REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW ON . TO 'zabbix_agent'@'localhost';

			* Definire le macro nel template Mysql Agent2
			MYSQL_DSN
			MYSQL_PASSWORD
			MYSQL_USERNAME

			=Agent=

	* Sul server Zabbix, aggiungere il template		* Sul server Zabbix, aggiungere il template
	Template DB MySQL		Template DB MySQL

Gabriele.vivinetto at 10:28, 20 October 2020

2020-10-20T10:28:36Z

← Older revision		Revision as of 10:28, 20 October 2020
Line 13:		Line 13:

	exit		exit

			* Impostare la homedir per lo user zabbix:
			systemctl stop zabbix-agent.service
			usermod zabbix --home /var/lib/zabbix
			systemctl start zabbix-agent.service

	* Creare il file .my.cnf coi dettagli di login:		* Creare il file .my.cnf coi dettagli di login:

Gabriele.vivinetto at 15:25, 4 October 2018

2018-10-04T15:25:00Z

← Older revision		Revision as of 15:25, 4 October 2018
Line 32:		Line 32:
	* impostare le permission		* impostare le permission
	chown zabbix:zabbix .my.cnf		chown zabbix:zabbix .my.cnf
	chmod 0644 .my.~~cbnf~~		chmod 0644 .my.cnf

	* Verificare la connessione come zabbix agent:		* Verificare la connessione come zabbix agent:

Gabriele.vivinetto at 14:27, 3 September 2018

2018-09-03T14:27:53Z

← Older revision		Revision as of 14:27, 3 September 2018
Line 44:		Line 44:

	=Riferimenti=		=Riferimenti=
	[http://yallalabs.com/linux/how-to-monitor-mysqlmariadb-using-zabbix-server/ How to Monitor MYSQL/MariaDB Using Zabbix Server - YallaLabs]		*[http://yallalabs.com/linux/how-to-monitor-mysqlmariadb-using-zabbix-server/ How to Monitor MYSQL/MariaDB Using Zabbix Server - YallaLabs]
	[https://stackoverflow.com/questions/34805211/monitoring-mysql-with-zabbix-agent Monitoring MySQl with Zabbix Agent - Stack Overflow]		*[https://stackoverflow.com/questions/34805211/monitoring-mysql-with-zabbix-agent Monitoring MySQl with Zabbix Agent - Stack Overflow]

Gabriele.vivinetto: Created page with "* Sul server Zabbix, aggiungere il template Template DB MySQL * Sulla macchina da monitorare, creare l'utente di monitoraggio: mysql -u root create user 'zabbix_agent'@'..."

2018-09-03T14:26:08Z

Created page with "* Sul server Zabbix, aggiungere il template Template DB MySQL * Sulla macchina da monitorare, creare l'utente di monitoraggio: mysql -u root create user 'zabbix_agent'@'..."

New page

* Sul server Zabbix, aggiungere il template
Template DB MySQL

* Sulla macchina da monitorare, creare l'utente di monitoraggio:

mysql -u root

create user 'zabbix_agent'@'localhost' IDENTIFIED BY 'Password';

GRANT USAGE ON *.* TO 'zabbix_agent'@'localhost' IDENTIFIED BY 'Password';

flush privileges;

exit

* Creare il file .my.cnf coi dettagli di login:
mkdir -p /var/lib/zabbix
chown zabbix:zabbix /var/lib/zabbix

cd /var/lib/zabbix/
sudoedit .my.cnf

<pre>
[mysql]
user=zabbix_agent
password=Password
[mysqladmin]
user=zabbix_agent
password=Password
</pre>

* impostare le permission
chown zabbix:zabbix .my.cnf
chmod 0644 .my.cbnf

* Verificare la connessione come zabbix agent:

echo "show databases;" | sudo -u zabbix mysql

Database
information_schema

* Verificare che i trigger siano abilitati e non Unsupported

=Riferimenti=
[http://yallalabs.com/linux/how-to-monitor-mysqlmariadb-using-zabbix-server/ How to Monitor MYSQL/MariaDB Using Zabbix Server - YallaLabs]
[https://stackoverflow.com/questions/34805211/monitoring-mysql-with-zabbix-agent Monitoring MySQl with Zabbix Agent - Stack Overflow]