Skip to content

Correct incompatibility between MySQL 8.x and Automation regular expressions #4903

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

Closed
TheWitness opened this issue Aug 21, 2022 · 0 comments
Closed
Labels
bug Undesired behaviour confirmed Bug is confirm by dev team resolved A fixed issue
Milestone

Comments

@TheWitness
Copy link
Member

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.

@TheWitness TheWitness added bug Undesired behaviour unverified Some days we don't have a clue labels Aug 21, 2022
@TheWitness TheWitness added this to the v1.2.23 milestone Aug 21, 2022
@TheWitness TheWitness added confirmed Bug is confirm by dev team and removed unverified Some days we don't have a clue labels Aug 21, 2022
TheWitness added a commit that referenced this issue Aug 21, 2022
MySQL 8.x regular expressions break Cacti Automation
TheWitness added a commit that referenced this issue Aug 21, 2022
The prior code would allow for injections.
@TheWitness TheWitness added the resolved A fixed issue label Aug 21, 2022
@github-actions github-actions bot locked and limited conversation to collaborators Nov 28, 2022
@netniV netniV changed the title MySQL 8.x regular expressions break Cacti Automation Correct incompatibility between MySQL 8.x and Automation regular expressions Dec 31, 2022
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Undesired behaviour confirmed Bug is confirm by dev team resolved A fixed issue
Projects
None yet
Development

No branches or pull requests

1 participant