History show nothing expect sql-syntax

Icinga Web
, ,
1

Here I am again, when I click on the web interface on history I only get sql-syntax … that´s not what I would like to see … anybody have some ideas?

image
image1023×383 75.1 KB

Greetings

2

You have been trying so many changes during your session and maybe your database(s) got screwed up. I’d recommend to to drop them all and recreate a empty but clean database:

# systemctl stop icinga2
# mysql -u root -p
DROP DATABASE icinga;
CREATE DATABASE icinga;
exit

# mysql -u root -p icinga < /usr/local/share/icinga2-ido-mysql/schema/mysql.sql
# systemctl start icinga2

(adapt the name of the database to your needs)

3

What will happening with my monitoring, when i do this?

All of my configuration will be away, or?

4

You will lose your history. Your config is not defined in the database but conf files, right?

5

Wait a moment. I didn’t follow the previous discussion, but before you purge your database please tell me the following:

  • which Icinga Web 2 version is this?
  • have you entered a charset for the IDO resource, and which if so?
    • please try changing the charset to latin1 if not
6
  • My Icinga Web Version is 2.8.1
  • I don´t have any charset for my ido ressource (I will try latin1)
7

It works, thank you!