Zoneminder 1.36x on FreeBSD 14.0 issue

[beliawicker]

Hello,
I just upgraded a working instance of zoneminder-1.36.33_2 to zoneminder-1.36.33_3 and from all the sudden it's not able to access the DB with error:
geometry dash lite

Code: Select all

Unable to connect to ZM db using dsn mysql:host=localhost;dbname=zm;charset=utf8

SQLSTATE[HY000] [1045] Access denied for user 'zmuser'@'localhost' (using password: YES)

I checked my DB grants again and everything seems fine to me:

Code: Select all

+--------------------------------------------------------+
| Grants for zmuser@localhost                            |
+--------------------------------------------------------+
| GRANT USAGE ON *.* TO `zmuser`@`localhost`             |
| GRANT ALL PRIVILEGES ON `zm`.* TO `zmuser`@`localhost` |
+--------------------------------------------------------+

Does any one you run Zoneminder on FreeBSD and got the same issue? Any advice?
Thanks in advance!

[blaczero]

Not sure, but I'd verify the grants and roles after you verify the password.

https://mariadb.com/kb/en/show-grants/