new install on Ubuntu 1804 issues

[rupertm1e6]

Hello Forum,

Im a new user to ZoneMinder and not super linux savvy.
I followed the instruction and installed lamp server stuff, got the distro from Isaac's page, etc. Basically a normal install with out much in the way of hickups. The mysql user and password I updated in the conf file. But now Im getting these messages when trying to run. Im suspicious that there is something going on with the mysql server user name or something. Any suggestions or recommendation would be appreciated.

Thank you for your help!
Matt

Below is the errors and log info.

Job for zoneminder.service failed because the control process exited with error code.
See "systemctl status zoneminder.service" and "journalctl -xe" for details.
rupertm@ubuntu64:~$ systemctl status zoneminder.service
● zoneminder.service - ZoneMinder CCTV recording and surveillance system
Loaded: loaded (/lib/systemd/system/zoneminder.service; enabled; vendor preset: enabled)
Active: activating (auto-restart) (Result: exit-code) since Tue 2019-08-20 18:49:56 UTC; 4s ago
Process: 17229 ExecStart=/usr/bin/zmpkg.pl start (code=exited, status=1/FAILURE)
rupertm@ubuntu64:~$ journalctl -xe
-- Subject: Unit zoneminder.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit zoneminder.service has failed.
--
-- The result is RESULT.
Aug 20 18:50:27 ubuntu64 systemd[1]: zoneminder.service: Service hold-off time over, scheduling restart.
Aug 20 18:50:27 ubuntu64 systemd[1]: zoneminder.service: Scheduled restart job, restart counter is at 388.
-- Subject: Automatic restarting of a unit has been scheduled
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Automatic restarting of the unit zoneminder.service has been scheduled, as the result for
-- the configured Restart= setting for the unit.
Aug 20 18:50:27 ubuntu64 systemd[1]: Stopped ZoneMinder CCTV recording and surveillance system.
-- Subject: Unit zoneminder.service has finished shutting down
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit zoneminder.service has finished shutting down.
Aug 20 18:50:27 ubuntu64 systemd[1]: Starting ZoneMinder CCTV recording and surveillance system...
-- Subject: Unit zoneminder.service has begun start-up
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit zoneminder.service has begun starting up.
Aug 20 18:50:27 ubuntu64 sudo[17374]: root : TTY=unknown ; PWD=/usr/share/zoneminder/www ; USER=www-data ; COMMA
Aug 20 18:50:27 ubuntu64 sudo[17374]: pam_unix(sudo:session): session opened for user www-data by (uid=0)
Aug 20 18:50:27 ubuntu64 sudo[17374]: pam_unix(sudo:session): session closed for user www-data
Aug 20 18:50:27 ubuntu64 sudo[17377]: root : TTY=unknown ; PWD=/usr/share/zoneminder/www ; USER=www-data ; COMMA
Aug 20 18:50:27 ubuntu64 sudo[17377]: pam_unix(sudo:session): session opened for user www-data by (uid=0)
Aug 20 18:50:27 ubuntu64 zmpkg.pl[17351]: DBI connect('database=zm;host=localhost','root',...) failed: Access denied
Aug 20 18:50:27 ubuntu64 zmpkg.pl[17351]: Can't connect to db at /usr/share/perl5/ZoneMinder/Config.pm line 166.
Aug 20 18:50:27 ubuntu64 zmpkg.pl[17351]: BEGIN failed--compilation aborted at /usr/share/perl5/ZoneMinder/Config.pm
Aug 20 18:50:27 ubuntu64 zmpkg.pl[17351]: Compilation failed in require at /usr/share/perl5/ZoneMinder.pm line 33.
Aug 20 18:50:27 ubuntu64 zmpkg.pl[17351]: BEGIN failed--compilation aborted at /usr/share/perl5/ZoneMinder.pm line 3
Aug 20 18:50:27 ubuntu64 zmpkg.pl[17351]: Compilation failed in require at /usr/bin/zmdc.pl line 67.
Aug 20 18:50:27 ubuntu64 zmpkg.pl[17351]: BEGIN failed--compilation aborted at /usr/bin/zmdc.pl line 67.
Aug 20 18:50:27 ubuntu64 sudo[17377]: pam_unix(sudo:session): session closed for user www-data
Aug 20 18:50:27 ubuntu64 systemd[1]: zoneminder.service: Control process exited, code=exited status=1
Aug 20 18:50:27 ubuntu64 systemd[1]: zoneminder.service: Failed with result 'exit-code'.
Aug 20 18:50:27 ubuntu64 systemd[1]: Failed to start ZoneMinder CCTV recording and surveillance system.
-- Subject: Unit zoneminder.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit zoneminder.service has failed.
--
-- The result is RESULT.

[bbunge]

What install instructions did you use?

Here is a fool proof script that will install everything you need to run Zoneminder on a server install, a desktop install or a bare bones Bionic.

https://wiki.zoneminder.com/Ubuntu_Serv ... ell_script

[iconnor]

You changed the username and password in zm.conf but it looks like you didn't tell mysql about it.

[rupertm1e6]

Thank you Iconnor and Bbunge!

Yeah Ill look over the wiki and try fixing what I have. Iconner to your point Im having a mysql issue. Is it possible to uninstall mysql with a apt-get remove and then reinstall and have it wipe clean the passwords for a fresh start?

Again Thank you both for your help!!
Matt

[bbunge]

Just create a new user in MySQL like this:

mysql -uroot -p -e "grant all on zm.* to 'newuser'@localhost identified by 'newpass';"

You will be prompted for the mysql password. Substitute newuser and newpass for what you used in zm.conf