Mariadb ERROR 1698 (28000) on Debian 12 install

[mdm55]

I followed the instructions for Debian 12 (Bookworm) provided here:

https://zoneminder.readthedocs.io/en/la ... 1-bullseye

and at

Step 5: Configure database

mariadb -u zmuser -p zm < /usr/share/zoneminder/db/zm_create.sql

I received the following error:

ERROR 1698 (28000): Access denied for user 'zmuser'@'localhost'

The installed version of mariadb is Server version: 10.11.6-MariaDB-0+deb12u1 Debian 12

zm.conf shows:
# ZoneMinder database name
ZM_DB_NAME=zm

# ZoneMinder database user
ZM_DB_USER=zmuser

# ZoneMinder database password
ZM_DB_PASS=zmpass


Any suggestions?

[rcrail]

Were you able to resolve this issue? I have same problem.

[rcrail]

My fix was to run:
a2enconf zoneminder, then
systemctl reload apache2, which failed with "Invalid command 'RewriteEngine', perhaps misspelled or defined by a module not included in the server configuration".
entered: a2enmod rewrite && sudo service apache2 restart, then
systemctl restart apache2
systemctl reload apache2.service
systemctl restart zoneminder.service

[blaczero]

I followed the instructions for Debian 12 (Bookworm) provided here:

https://zoneminder.readthedocs.io/en/la ... 1-bullseye

and at

Step 5: Configure database

mariadb -u zmuser -p zm < /usr/share/zoneminder/db/zm_create.sql

I received the following error:

ERROR 1698 (28000): Access denied for user 'zmuser'@'localhost'

The installed version of mariadb is Server version: 10.11.6-MariaDB-0+deb12u1 Debian 12

zm.conf shows:
# ZoneMinder database name
ZM_DB_NAME=zm

# ZoneMinder database user
ZM_DB_USER=zmuser

# ZoneMinder database password
ZM_DB_PASS=zmpass


Any suggestions?

You would not run the zoneminder instruction as the SQL user to create the db. See the readme:

mysql -u root -p < /usr/share/zoneminder/db/zm_create.sql
or
sudo mysql < /usr/share/zoneminder/db/zm_create.sql

You have zmuser in there as the account running the sql script