Case sensitive

Icinga Web Modules Icinga Director
1

Hi,
when i search for an object in Director, i.e. an object in “Service Apply Rules” I see it is case sensitive.

Is it possible to set case insensitive that research?

Thanks a lot
Mario

|cinga Web 2 Version|2.11.4|
|Git commit|11453bfa92a70a44efbf7f966f5e7f27e9300a28|
|PHP Version|7.4.3-4ubuntu2.19|
|Git commit date|2023-01-26|
Icinga Director 1.10.2
Ubuntu server 20.04

2

If I search for an apply rule it is case insensitive:
Screenshot 2024-01-31 at 11.57.59
director: 1.11.0

1 Like
3

Hi,

we have the same problem like Mario.
Case insensitive doesn’t work in director.

director 1.11.0
Icinga Web 2 Version 2.12.1
PHP-Version 8.1.27

Thanks a lot.
Wolfgang

1 Like
4

@moreamazingnick could you tick on “Show SQL” and paste the result?
image

Thanks

In my case, query is:
SELECT o.id, o.uuid, o.object_name, o.disabled, o.assign_filter,
o.apply_for FROM icinga_service AS o WHERE (object_type = ‘apply’) AND
(service_set_id IS NULL) AND (“o”.“object_name” LIKE ‘%all%’ OR
“o”.“assign_filter” LIKE ‘%all%’) ORDER BY o.object_name ASC LIMIT 25

On my Postgres db director, if I use ILIKE instead LIKE, query is case insensitive but I can’t change the director code.

5

good catch!
the director behaves differently with postgres and mariadb/mysql.

if you think it is a bug / not a feature please open an issue in github.

best regards
nicolas

1 Like
6

I have opened an issue

7

I currently do not have a postgres director instance to test that but if you are brave you can try this on a non prod test environment without any guarantee…

https://github.com/moreamazingnick/icingaweb2-module-incubator/releases/tag/v0.20.0.2