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

Reply via email to