I am a long time user of icinga2 and this new setup I am making is causing me some trouble.
We are trying to setup a master node with icinga, icingaweb2 and grafana.
Icinga and Grafana are able to connect to my database.
But when I fill in all the same details in the GUI of icinga web2 I get my first hint of trouble:
Unable to check the server's version. This is usually not a critical error as there is probably only access to the database permitted which does not exist yet. If you are absolutely sure you are running PostgreSQL in a version equal to or newer than 9.1, you can skip the validation and safely proceed to the next step. The error was: SQLSTATE  could not connect to server: Permission denied Is the server running on host "URL" (10.250.10.60) and accepting TCP/IP connections on port 5432?
So I followed all of the setup instructions on the webpages. even configured all the settings in the config files but no succes.
IcingaWeb2 does not want to communicate with the RDS database while icinga is using it with IDO and grafana are happily running on the same machine and using the database. I googled a lot ofcourse but only found items from around 2014,
Perhaps I am missing some setting for icingaweb2 to make it work with a external database?
I have 2 databases
icingaweb2 both with a user name and password and
icingaweb=> select * from icingaweb_user;
name | active | password_hash |
icingaadmin | 1 | a4d46534e7332366c4b5449304a513171 | |
root@ # ps -ef | grep apache
apache 24553 25798 0 03:58 ? 00:00:00 /usr/sbin/httpd -DFOREGROUND
root 28183 18771 0 04:44 pts/1 00:00:00 grep --color=auto apache
root@# id apache
uid=48(apache) gid=48(apache) groups=48(apache),495(icingacmd),494(icingaweb2)
I am running out of ideas here to try