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”.
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.
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”.
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
To “reach the MariaDB/MySQL shell” on a Debian machine, log in as root and
enter the command “mysql”.
So I got past that point, but now have a different problem
It says in the Monitor config “Cannot find the IDO schema. Please verify that the given database contains the schema and that the configured user has access to it.” - I tried to create a new database for it along the lines of:
MariaDB [mysql]> CREATE DATABASE icingawebido;
MariaDB [mysql]> GRANT ALL ON icingawebido.* TO icingawebido@localhost
IDENTIFIED BY ‘mypass’;