System development or Technical something

Install icinga2 (2)

Install icinga2 (1) - AKAI TSUKI

install mariadb

# yum install -y mariadb mariadb-server
 Package                           Arch             Version                    Repository      Size
 mariadb                           x86_64           1:5.5.56-2.el7             base           8.7 M
 mariadb-server                    x86_64           1:5.5.56-2.el7             base            11 M
Installing for dependencies:
 perl-Compress-Raw-Bzip2           x86_64           2.061-3.el7                base            32 k
 perl-Compress-Raw-Zlib            x86_64           1:2.061-4.el7              base            57 k
 perl-DBD-MySQL                    x86_64           4.023-5.el7                base           140 k
 perl-DBI                          x86_64           1.627-4.el7                base           802 k
 perl-Data-Dumper                  x86_64           2.145-3.el7                base            47 k
 perl-IO-Compress                  noarch           2.061-2.el7                base           260 k
 perl-Net-Daemon                   noarch           0.48-5.el7                 base            51 k
 perl-PlRPC                        noarch           0.2020-14.el7              base            36 k
Updating for dependencies:
 mariadb-libs                      x86_64           1:5.5.56-2.el7             base           757 k

Transaction Summary
Install  2 Packages (+8 Dependent packages)
Upgrade             ( 1 Dependent package)

start mariadb

# systemctl enable mariadb
Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.
# systemctl start mariadb

initial setup for mariadb

# mysql_secure_installation


In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.

Set root password? [Y/n] Y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
 ... Success!

By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] Y
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] Y
 ... Success!

By default, MariaDB comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] Y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] Y
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!


# yum install -y icinga2-ido-mysql
 Package                 Arch         Version                     Repository                   Size
 icinga2-ido-mysql       x86_64       2.7.0-1.el7.icinga          icinga-stable-release       185 k

Transaction Summary
Install  1 Package

setup icinga db

# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 5.5.56-MariaDB MariaDB Server

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> CREATE DATABASE icinga;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE VIEW, INDEX, EXECUTE ON icinga.* TO 'icinga'@'localhost' IDENTIFIED BY '(your icinga pass)';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> quit
# mysql -u root -p icinga < /usr/share/icinga2-ido-mysql/schema/mysql.sql
Enter password:
# icinga2 feature enable ido-mysql
warning/cli: Feature 'ido-mysql' already enabled.
# icinga2 feature list
Disabled features: api command compatlog debuglog gelf graphite influxdb livestatus opentsdb perfdata statusdata syslog
Enabled features: checker ido-mysql mainlog notification