Zoneminder install using Monex private repo package from OBS - MySQL authentication error

Hoping the author of this repo has his ears on to resolve this error…

And/or anyone has a suggestion around this problem(MySQL credentials) . If this isn’t resolvable, I’ll start over installing ZoneMinder from source.

openSUSE 13.1 (with LXDE Desktop)
as a VMware Guest

Zoneminder installed using this “One-click” Install link

Problem (resolved)

systemctl start apache2.service


systemctl status apache2
apache2.service - The Apache Webserver
   Loaded: loaded (/usr/lib/systemd/system/apache2.service; disabled)
   Active: failed (Result: exit-code) since Sun 2014-07-13 16:07:30 PDT; 37s ago
  Process: 3558 ExecStop=/usr/sbin/start_apache2 -D SYSTEMD -DFOREGROUND -k graceful-stop (code=exited, status=1/FAILURE)
  Process: 3540 ExecStart=/usr/sbin/start_apache2 -D SYSTEMD -DFOREGROUND -k start (code=exited, status=1/FAILURE)
 Main PID: 3540 (code=exited, status=1/FAILURE)

Jul 13 16:07:29 linux-hf5m systemd[1]: Starting The Apache Webserver...
Jul 13 16:07:30 linux-hf5m start_apache2[3540]: AH00526: Syntax error on line 3 of /etc/apache2/conf.d/zm.conf:
Jul 13 16:07:30 linux-hf5m start_apache2[3540]: Invalid command 'php_admin_flag', perhaps misspelled or defined by a module not i...ration
Jul 13 16:07:30 linux-hf5m systemd[1]: apache2.service: main process exited, code=exited, status=1/FAILURE

Which was resolved by commenting out the offending line as follows


# turn short open tags on for zm directory
<Directory /srv/www/htdocs/zm/>
#        php_admin_flag short_open_tag On
        Options FollowSymLinks

Unresolved Problem
That allows apache2 to start, but when attempting to start the zoneminder service as follows, the following error occurs

systemctl start zm.service
systemctl status zm.service
zm.service - ZoneMinder Video Surveillance System
   Loaded: loaded (/usr/lib/systemd/system/zm.service; disabled)
   Active: failed (Result: exit-code) since Sun 2014-07-13 16:27:30 PDT; 1min 30s ago
  Process: 4259 ExecStart=/usr/bin/ start (code=exited, status=255)

Jul 13 16:27:30 linux-hf5m[4259]: DBI connect('database=zm;host=localhost','zm_admin',...)** failed: Access denied for user 'zm_admin'@'localhost' (using password: YES)** at /usr/lib/perl5/vendor_perl/5.18.1/ line 91.
Jul 13 16:27:30 linux-hf5m[4259]: Can't connect to db at /usr/lib/perl5/vendor_perl/5.18.1/ZoneMinder/ line 105.

So, it appears from the above error (which I BOLDed it looks like either MySQL should not have been setup with remote authentication or the MySQL “zm_admin” account credentials were not properly entered into the MySQL connection string.

I haven’t tried to reverse engineer/crack existing credentials in a situation like this before. If someone has an idea how to do so, TIA. But, assuming this isn’t possible I guess I’ll have to assume this package is broken and maybe resort to installing from source instead.


php5 modules must be enabled !!! (seems php5 is required — php alone is not working)

>a2enmod php5