Installing Icinga DB on Debian; ?(using password: NO)?

Icinga 2
1

icinga2 version: r2.13.7-1
Debian 11
mariadb Ver 15.1 Distrib 10.5.18-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper

FWIW I’m attempting this installation in a Proxmox container.

Following installation instructions; Debian - Icinga DB

systemctl status icinga2; running

When I systemctl start icingadb

  • Why; (using password: NO) in the systemctl status message? I have a password set in /etc/icingadb/config.yml

  • Seems suspicious; localhost:0 I would think localhost

systemctl status icingadb

* icingadb.service - Icinga DB
     Loaded: loaded (/lib/systemd/system/icingadb.service; enabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Wed 2023-03-15 14:32:13 MST; 33min ago
    Process: 12388 ExecStart=/usr/sbin/icingadb --config /etc/icingadb/config.yml (code=exited, status=1/FAILURE)
   Main PID: 12388 (code=exited, status=1/FAILURE)
        CPU: 7ms

Mar 15 14:32:13 icinga0 systemd[1]: Starting Icinga DB...
Mar 15 14:32:13 icinga0 icingadb[12388]: Starting Icinga DB
Mar 15 14:32:13 icinga0 systemd[1]: Started Icinga DB.
Mar 15 14:32:13 icinga0 icingadb[12388]: Connecting to database at 'localhost:0'
Mar 15 14:32:13 icinga0 icingadb[12388]: database: Can't connect to database. Retrying
Mar 15 14:32:13 icinga0 icingadb[12388]: Error 1045: Access denied for user 'icingadb'@'localhost' (using password: NO)
                                         can't retry
                                         github.com/icinga/icingadb/pkg/retry.WithBackoff
                                                 github.com/icinga/icingadb/pkg/retry/retry.go:64
                                         github.com/icinga/icingadb/pkg/driver.RetryConnector.Connect
                                                 github.com/icinga/icingadb/pkg/driver/driver.go:32
                                         database/sql.(*DB).conn
                                                 database/sql/sql.go:1393
                                         database/sql.(*DB).PingContext
                                                 database/sql/sql.go:851
                                         database/sql.(*DB).Ping
                                                 database/sql/sql.go:873
                                         main.run
                                                 github.com/icinga/icingadb/cmd/icingadb/main.go:68
                                         main.main
                                                 github.com/icinga/icingadb/cmd/icingadb/main.go:37
                                         runtime.main
                                                 runtime/proc.go:250
                                         runtime.goexit
                                                 runtime/asm_amd64.s:1594
                                         can't connect to database
                                         github.com/icinga/icingadb/pkg/driver.RetryConnector.Connect
                                                 github.com/icinga/icingadb/pkg/driver/driver.go:32
                                         database/sql.(*DB).conn
                                                 database/sql/sql.go:1393
                                         database/sql.(*DB).PingContext
                                                 database/sql/sql.go:851
                                         database/sql.(*DB).Ping
                                                 database/sql/sql.go:873
                                         main.run
                                                 github.com/icinga/icingadb/cmd/icingadb/main.go:68
                                         main.main
                                                 github.com/icinga/icingadb/cmd/icingadb/main.go:37
                                         runtime.main
                                                 runtime/proc.go:250
                                         runtime.goexit
                                                 runtime/asm_amd64.s:1594
                                         can't connect to database
                                         main.run
                                                 github.com/icinga/icingadb/cmd/icingadb/main.go:70
                                         main.main
                                                 github.com/icinga/icingadb/cmd/icingadb/main.go:37
                                         runtime.main
                                                 runtime/proc.go:250
                                         runtime.goexit
                                                 runtime/asm_amd64.s:1594
Mar 15 14:32:13 icinga0 systemd[1]: icingadb.service: Main process exited, code=exited, status=1/FAILURE
Mar 15 14:32:13 icinga0 systemd[1]: icingadb.service: Failed with result 'exit-code'.
root@icinga0:~#
2

I haven’t resolved this error during the Debian install. I prefer to use Debian, however in the interest of learning how to do the install I switched to a Ubuntu 22.04 container and got past this step. Looks like a bug, or step missing in the Debian install documentation. I’ll raise an issue on GitHub.

3

Hello Jeff!

Indeed! What’s your Icinga DB config?

Best,
A/K

4

Time being what it is… Once I got this working on ubuntu I decided to move on to other projects even though I really would prefer to use Debian and not have ubuntu on my network(s)