Describe the bug

MySQL 8.x has implemented proper Regular Expression handling which has broken Cacti's automation.

To Reproduce

Steps to reproduce the behavior:

1. Install base Cacti 1.2.22

2. Setup automation on a network

3. Run that automation

4. See errors in the Cacti log

Expected behavior

Cacti should operate correctly.

Additional context

The way we were running regular expressions was awkward but worked. In the new MySQL, full Unicode support is available and it appears like RLIKE is broken in the new implementation, so we will move to REGEXP using a substring search convention as a replacement for a while till MariaDB catches up. Not that they won't, but some people still using MySQL/MariaDB 5.x, etc.