Icingaweb2 + icingadb + object filter

Icinga DB
1

Hi,

We are slowly migrating to icingadb and we are facing one issue…

Using the full admin permission with NO object filter, everything works fine. But using object filter in icingadb give user this error:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.com’ at line 1

The only thing I can see, the username is an email and ends with .com … but if I completely remove the object filter for this account, no more SQL error…

The object filter is very simple…

host.name!=.something.&host.name!=.somethingelse.

EDIT: Find out that the GROUP is also containing .com , and after removing that, it works.

@theFeu Maybe it’s something to bring to dev :wink:

2

Hey there!
If you suspect that you found a bug, then the best course of action would be to open an issue on the GitHub repo of the project.
This is where our devs spend most of their time and it is much more unlikely to be overlooked than a post here on the forum :slight_smile: