Re: [icinga-users] Icingaweb2 broken after upgrade from Debian stretch to Buster

Marcel Weinberg Thu, 01 Aug 2019 14:29:47 -0700

Hi James,

ok, ldap as authentication backend explains why you did not need the icingaweb2 database.

Icingaweb2 is not communicating with the icinga2 service as such. Both "communicate" via the Icinga2 database. To make it simple, icinga2 receives all the check results -> writes them to the icinga2 database -> icingaweb2 reads from the icinga2 database to list host and service states.

Did you check the /etc/icingaweb2/resources.ini file from the previous icingaweb installation? It should contain the ldap configuration as well as the connection details for the icinga2 database. You can configure the resources (datasource in this case) via icingaweb2 in the browser as well: Configuration -> Application -> Resources.

You should see the hosts and services as soon as icingaweb2 has access to the database.

Is the notification feature enabled? Please verify it by running "icinga2 feature list". Please see https://icinga.com/docs/icinga2/latest/doc/15-troubleshooting/#notifications-troubleshooting for the notifications troubleshooting.

BR,

Marcel

Gesendet: Donnerstag, 01. August 2019 um 22:41 Uhr
Von: "James Allsopp" <jamesaalls...@googlemail.com>
An: "Icinga User's Corner" <icinga-users@lists.icinga.org>
Betreff: Re: [icinga-users] Icingaweb2 broken after upgrade from Debian stretch to Buster

Hi,

Realised the reason I didn't need the database was that I'm using ldap for authentication.

I think I have more that one problem now though, icinga is sending no errors via e-mail, although the logs look good.

Ah, I think one problem was not activating the new php7.3 in apache, solved with

a2enmod php7.3

systemctl restart apache2

I also had to change SERVICENAME to SERVICEDESC in mail-service-notification.sh which solved the errors in the logs I
was getting, but still not getting any warning emails.

Although I can log in, lots of breakage, menu on left disappears, can't see any hosts or services. Checked conf is still good.

icinga2logs seem fine, nothing in /var/log/icingaweb2

Thanks

James

On Wed, 31 Jul 2019 at 23:15, Marcel Weinberg <mweinberg...@email.de> wrote:

Hi,

icingaweb2 needs a database (the one you mentioned refering to the vultr post) to store the configuration. On Debian it's required to create the database manually. I would recommend the actual icinga documentation: https://icinga.com/docs/icingaweb2/latest/doc/02-Installation/

I am honestly a bit puzzled and don't know how it could have been working earlier if you don't have the database.

What I would do now is:

- take a backup of /etc/icingaweb2 to safe all the existing configuration files from your previous installation

- check the configured resources in /etc/icingaweb2/resources.ini and check which database was used

... if this does not help and you want to configure icingaweb2 from scratch again

- create the icingaweb2 database

- run `icingacli setup token create` on the icinga2 node to create a token

- go to http://<server-ip-or-fqnd>/icingaweb2/setup

The setup wizard will guide you through the setup in your browser. This includes the configuration of required datasources as well as a check that all required PHP modules are installed.

Btw, feel free to post this question at https://community.icinga.com/

Best regards,

Marcel
Gesendet: Mittwoch, 31. Juli 2019 um 23:31 Uhr
Von: "James Allsopp" <jamesaalls...@googlemail.com>
An: "Icinga User's Corner" <icinga-users@lists.icinga.org>
Betreff: [icinga-users] Icingaweb2 broken after upgrade from Debian stretch to Buster
Hi,

I managed to get icinga back up and running after the upgrade by upgrading the database using

mysql_upgrade -u root -p

and upgrading the schema using;

mysql -u root -p icingadb <2.8.0.sql

mysql -u root -p icingadb <2.8.1.sql

but I get nothing at all from the web interface, no errors just a blank page. I'm seeing GET requests in the apache2 logs though and nothing is being written in the log at /var/log/icingaweb2. .

Icinga2 should have upgraded from 2.6.0-2 to 2.10.3-2

Icingaweb2 should have upgraded from 2.4.1-1 to 2.6.2-3

I've checked the icinga2 feature is enabled for ido-mysql and command

I've added the correct timezone in /etc/php/7.3/apache2/php.ini

I've checked all the relevant packages are installed.

I'm not sure if I'm supposed to update the schema for the web client too? I've seen a site (https://www.vultr.com/docs/how-to-install-icinga-2-and-icinga-web-2-on-ubuntu-16-04) that states
mysql -u root -p icingaweb2 < /usr/share/icingaweb2/etc/schema/mysql.schema.sql
but I don't have an icingaweb2 database.

Here's my current structure of databases;

Your MariaDB connection id is 13
Server version: 10.3.15-MariaDB-1 Debian 10

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

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

MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| icinga_users |
| icingadb |
| information_schema |
| mysql |
| performance_schema |
+--------------------+
5 rows in set (0.000 sec)

MariaDB [icingadb]> show tables;
+----------------------------------------+
| Tables_in_icingadb |
+----------------------------------------+
| icinga_acknowledgements |
| icinga_commands |
| icinga_commenthistory |
| icinga_comments |
| icinga_configfiles |
| icinga_configfilevariables |
| icinga_conninfo |
| icinga_contact_addresses |
| icinga_contact_notificationcommands |
| icinga_contactgroup_members |
| icinga_contactgroups |
| icinga_contactnotificationmethods |
| icinga_contactnotifications |
| icinga_contacts |
| icinga_contactstatus |
| icinga_customvariables |
| icinga_customvariablestatus |
| icinga_dbversion |
| icinga_downtimehistory |
| icinga_endpoints |
| icinga_endpointstatus |
| icinga_eventhandlers |
| icinga_externalcommands |
| icinga_flappinghistory |
| icinga_host_contactgroups |
| icinga_host_contacts |
| icinga_host_parenthosts |
| icinga_hostchecks |
| icinga_hostdependencies |
| icinga_hostescalation_contactgroups |
| icinga_hostescalation_contacts |
| icinga_hostescalations |
| icinga_hostgroup_members |
| icinga_hostgroups |
| icinga_hosts |
| icinga_hoststatus |
| icinga_instances |
| icinga_logentries |
| icinga_notifications |
| icinga_objects |
| icinga_processevents |
| icinga_programstatus |
| icinga_runtimevariables |
| icinga_scheduleddowntime |
| icinga_service_contactgroups |
| icinga_service_contacts |
| icinga_servicechecks |
| icinga_servicedependencies |
| icinga_serviceescalation_contactgroups |
| icinga_serviceescalation_contacts |
| icinga_serviceescalations |
| icinga_servicegroup_members |
| icinga_servicegroups |
| icinga_services |
| icinga_servicestatus |
| icinga_statehistory |
| icinga_systemcommands |
| icinga_timeperiod_timeranges |
| icinga_timeperiods |
| icinga_zones |
| icinga_zonestatus |
+----------------------------------------+

Any help would be much appreciated,

Thanks

James
_______________________________________________ icinga-users mailing list icinga-users@lists.icinga.org https://lists.icinga.org/mailman/listinfo/icinga-users
_______________________________________________
icinga-users mailing list
icinga-users@lists.icinga.org
https://lists.icinga.org/mailman/listinfo/icinga-users

_______________________________________________ icinga-users mailing list icinga-users@lists.icinga.org https://lists.icinga.org/mailman/listinfo/icinga-users

_______________________________________________
icinga-users mailing list
icinga-users@lists.icinga.org
https://lists.icinga.org/mailman/listinfo/icinga-users

Re: [icinga-users] Icingaweb2 broken after upgrade from Debian stretch to Buster

Reply via email to