[dev.icinga.com #10790] "Problems - Service Grid" does not work with host names that contain only digits

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/10790

Created by wanchai on 2015-12-07 21:08:40 +00:00

Assignee: wanchai
Status: Resolved (closed on 2015-12-16 10:40:04 +00:00)
Target Version: 2.1.1
Last Update: 2015-12-16 11:03:03 +00:00 (in Redmine)

---

The "Problems - Service Grid" page does not work if there are host objects that have names consisting only of digits. The SQL displayed on the screen contains "WHERE ... AND so.name1 in (2001, 2002)" at the end. 2001 and 2002 are host names, so the query should probably read "WHERE ... AND so.name1 in ('2001', '2002')", i.e. quotes are missing.

Environment: icinga2 2.4.1, icingaweb2 2.1.0 running on Debian 8.

Attachments

• errors1 wanchai - 2015-12-15 17:48:02 +00:00
• errors2 wanchai - 2015-12-15 17:48:02 +00:00

Changesets

2015-12-16 10:37:30 +00:00 by aklimov d087ae2

Make Service Grid working with host names that contain only digits

fixes #10790

[icinga-migration]

Updated by jmeyer on 2015-12-09 14:15:05 +00:00

• Category set to Monitoring
• Target Version set to Backlog

Hi,

thanks for your report. We'll have a look into it soon.

Best regards,
Johannes

[icinga-migration]

Updated by aklimov on 2015-12-11 17:28:51 +00:00

• Status changed from New to Feedback
• Assigned to set to wanchai

Hello wanchai

Please tell your RDBMS, its version, the whole SQL "displayed on the screen" and the exact URL you requested.

Best,
Alex

[icinga-migration]

Updated by wanchai on 2015-12-15 17:57:21 +00:00

• File added errors1
• File added errors2

Please see the attached files for the error messages. My DB is PostgreSQL 9.4.5. The URL is
/icingaweb2/monitoring/list/servicegrid?problems

The messages looks slightly different now, but that's because they came from another server. Same environment, though.

Here we have WHERE ... AND so.name1 IN (2000, 'debian8', 'win7'). I suppose so.name1 is a string and the set it's tested against contains one integer and two strings.

[icinga-migration]

Updated by aklimov on 2015-12-16 10:40:04 +00:00

• Status changed from Feedback to Resolved
• Done % changed from 0 to 100

Applied in changeset d087ae2.

[icinga-migration]

Updated by jmeyer on 2015-12-16 11:03:03 +00:00

• Target Version changed from Backlog to 2.1.1