File monitoring-plugins-centreon-mysql.spec of Package monitoring-plugins-centreon-mysql

#
# spec file for package monitoring-plugins-centreon-mysql
#
# Copyright (c) 2025 SUSE LINUX Products GmbH, Nuernberg, Germany.
#
# All modifications and additions to the file contributed by third parties
# remain the property of their copyright owners, unless otherwise agreed
# upon. The license for this file, and modifications and additions to the
# file, is the same license as for the pristine package itself (unless the
# license for the pristine package is not an Open Source License, in which
# case the license is the MIT License). An "Open Source License" is a
# license that conforms to the Open Source Definition (Version 1.9)
# published by the Open Source Initiative.

# Please submit bugfixes or comments via http://bugs.opensuse.org/
#


Name:           monitoring-plugins-mysql
Summary:        centreon check to monitor mysql or mariadb over nrpe
License:        Apache-2.0
Group:          System/Monitoring
Version:        20250900
Release:        0
Url:            http://www.centreon.com/
Source0:        centreon_mysql.pl
Source1:        centreon_mysql.cfg
BuildArch:      noarch
BuildRequires:  nagios-rpm-macros
Requires:       perl
Requires:       net-tools
Requires:       perl-CryptX
Requires:       perl-DateTime
Requires:       perl-DBI
Requires:       perl-DBD-mysql
Requires:       perl-Digest-MD5
Requires:       perl-Encode
Requires:       perl-HTTP-ProxyPAC
Requires:       perl-IO-Socket-SSL
Requires:       perl-JSON-Path
Requires:       perl-JSON-XS
Requires:       perl-KeePass-Reader
Requires:       perl-LWP-Protocol-https
Requires:       perl-MIME-Base64
Requires:       perl-URI
Requires:       perl-URI-Encode
BuildRoot:      %{_tmppath}/%{name}-%{version}-build

%description
Centreon plugin to monitor mysql or mariadb over nrpe
backup : Check backups (only with mysql enterprise backup).
collection : Collect and compute SQL data.
connection-time : Check database connection time.
databases-size : Check MySQL/MariaDB databases and tables sizes.
innodb-bufferpool-hitrate : Check hitrate in the InnoDB Buffer Pool.
long-queries : Check current number of long queries.
myisam-keycache-hitrate : Check hitrate in the Myisam Key Cache.
open-files : Check number of open files.
open-tables : Check number of open tables.
password-expiration : Check user password expiration.
qcache-hitrate : Check hitrate in the Query Cache.
queries : Check average number of queries executed.
replication : Check MySQL replication (need to use --multiple).
slow-queries : Check number of slow queries since last check.
sql : Check SQL statement.
sql-string : Check SQL statement to query string pattern (You cannot have more than to fiels in select)
threads-connected : Check number of open connections.
uptime : Check MySQL uptime.

%prep

%build

%install
install -D -m755 %{SOURCE0} %buildroot/%{nagios_plugindir}/centreon_mysql.pl
install -D -m644 %{SOURCE1} %buildroot/%{nrpe_sysconfdir}/centreon_mysql.cfg

%clean
rm -rf %buildroot

%files 
%defattr(-,root,root)
# avoid build dependecy of nagios - own the dirs
%dir %{nagios_libdir}
%dir %{nagios_plugindir}
%dir %{nrpe_sysconfdir}
%{nagios_plugindir}/centreon_mysql*
%attr(0644,root,root) %config(noreplace) %{nrpe_sysconfdir}/centreon_mysql.cfg

%changelog