Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
icinga-migration opened this issue Dec 7, 2015 · 5 comments
Milestone

Comments

@icinga-migration
Copy link
Member

@icinga-migration icinga-migration commented Dec 7, 2015

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Dec 9, 2015

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Dec 11, 2015

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Dec 15, 2015

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Dec 16, 2015

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Dec 16, 2015

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

  • Target Version changed from Backlog to 2.1.1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
1 participant
You can’t perform that action at this time.