Can't figure out how to configure database access on a Pi

Icinga Web
2

Hi! I am very curious to check out this product, but ran into an issue when
installing it on a Raspberry Pi 4 with Raspbian.

At the Database Resource step of IcingaWeb setup I get the error “Failed
to successfully validate the configuration: SQLSTATE[HY000] [2002] No such
file or directory”.

I have the following config:

Resource name: icingaweb_db
Database type: MySQL
Host: localhost
Database name: icingaweb_db

According to the install instructions, being a Debian-based OS, I should
have done this first:

Preparing Web Setup on Debian/Ubuntu

On Debian and derivates, you need to manually create a database and a
database user prior to starting the web wizard. This is due to local
security restrictions whereas the web wizard cannot create a
database/user through a local unix domain socket.

MariaDB [mysql]> CREATE DATABASE icingaweb2;

MariaDB [mysql]> GRANT ALL ON icingaweb2.* TO icingaweb2@localhost
IDENTIFIED BY ‘CHANGEME’; You may also create a separate administrative
account with all privileges instead.

Note: This is only required if you are using a local database as
authentication type.

However, I have no idea how to reach the MariaDB/mysql shell to run those
commands.

Very grateful for any help :slight_smile:

To “reach the MariaDB/MySQL shell” on a Debian machine, log in as root and
enter the command “mysql”.

Antony.

1 Like