Fresh install problem on Ubuntu 22.04.3 LTS
Posted: Fri Nov 17, 2023 5:48 am
I just installed Ubuntu server (Jammy) on my machine. I then installed Zoneminder, following these instructions:
https://zoneminder.readthedocs.io/en/la ... buntu.html.
Everything went fine, with no problems until the last step which is the one that starts Zoneminder.
It dumped the following systemd log message:
$ systemctl status zoneminder.service
× zoneminder.service - ZoneMinder CCTV recording and surveillance system
Loaded: loaded (/lib/systemd/system/zoneminder.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Thu 2023-11-16 21:23:53 PST; 38s ago
Docs: http://zoneminder.readthedocs.org/en/latest/
Process: 29985 ExecStart=/usr/bin/zmpkg.pl start (code=exited, status=255/EXCEPTION)
CPU: 88ms
Nov 16 21:23:53 rahula zmpkg[29985]: ERR [Error reconnecting to db: errstr:Access denied for user 'www-data'@'localhost' (using password: NO) error val:]
Nov 16 21:23:53 rahula zmpkg.pl[29985]: Unable to connect to DB. ZM Cannot continue.
So I'm guessing that something went wrong with the DB setup, but I'm a bit rusty on mysql etc. I'm hoping this is obvious to someone. I've seen other instructions that include steps for creating a DB user, but the instructions I followed didn't ask me to do that, so I didn't. This is the Zoneminder from the Ubuntu Repo, which claims to be version 1.36.12+dfsg1-1
https://zoneminder.readthedocs.io/en/la ... buntu.html.
Everything went fine, with no problems until the last step which is the one that starts Zoneminder.
It dumped the following systemd log message:
$ systemctl status zoneminder.service
× zoneminder.service - ZoneMinder CCTV recording and surveillance system
Loaded: loaded (/lib/systemd/system/zoneminder.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Thu 2023-11-16 21:23:53 PST; 38s ago
Docs: http://zoneminder.readthedocs.org/en/latest/
Process: 29985 ExecStart=/usr/bin/zmpkg.pl start (code=exited, status=255/EXCEPTION)
CPU: 88ms
Nov 16 21:23:53 rahula zmpkg[29985]: ERR [Error reconnecting to db: errstr:Access denied for user 'www-data'@'localhost' (using password: NO) error val:]
Nov 16 21:23:53 rahula zmpkg.pl[29985]: Unable to connect to DB. ZM Cannot continue.
So I'm guessing that something went wrong with the DB setup, but I'm a bit rusty on mysql etc. I'm hoping this is obvious to someone. I've seen other instructions that include steps for creating a DB user, but the instructions I followed didn't ask me to do that, so I didn't. This is the Zoneminder from the Ubuntu Repo, which claims to be version 1.36.12+dfsg1-1