ZoneMinder Forums

Posted: **Wed May 01, 2024 6:45 am**

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?

Posted: **Fri Oct 04, 2024 12:39 pm**

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

Posted: **Fri Oct 04, 2024 8:24 pm**

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

Posted: **Sat Oct 05, 2024 2:22 am**

mdm55 wrote: ↑Wed May 01, 2024 6:45 am 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

ZoneMinder Forums

Mariadb ERROR 1698 (28000) on Debian 12 install

Mariadb ERROR 1698 (28000) on Debian 12 install

Re: Mariadb ERROR 1698 (28000) on Debian 12 install

Re: Mariadb ERROR 1698 (28000) on Debian 12 install

Re: Mariadb ERROR 1698 (28000) on Debian 12 install