Results 1 to 2 of 2

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

  1. #1
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    10,823
    Blog Entries
    1

    Default 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.

    Platform:
    openSUSE 13.1 (with LXDE Desktop)
    as a VMware Guest

    Zoneminder installed using this "One-click" Install link
    http://software.opensuse.org/ymp/hom...ery=ZoneMinder

    Problem (resolved)
    Running
    Code:
    systemctl start apache2.service
    Results
    Code:
    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

    /etc/apache2/conf.d/zm.conf
    Code:
    # turn short open tags on for zm directory
    <Directory /srv/www/htdocs/zm/>
    #        php_admin_flag short_open_tag On
            Options FollowSymLinks
    </Directory>
    Unresolved Problem
    That allows apache2 to start, but when attempting to start the zoneminder service as follows, the following error occurs
    Code:
    systemctl start zm.service
    Code:
    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/zmpkg.pl start (code=exited, status=255)
    
    Jul 13 16:27:30 linux-hf5m zmpkg.pl[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/Zo...onfig.pm line 91.
    Jul 13 16:27:30 linux-hf5m zmpkg.pl[4259]: Can't connect to db at /usr/lib/perl5/vendor_perl/5.18.1/ZoneMinder/Config.pm 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.

    TSU

  2. #2

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

    Quote Originally Posted by tsu2 View Post
    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.

    Platform:
    openSUSE 13.1 (with LXDE Desktop)
    as a VMware Guest

    Zoneminder installed using this "One-click" Install link
    http://software.opensuse.org/ymp/hom...ery=ZoneMinder

    Problem (resolved)
    Running
    Code:
    systemctl start apache2.service
    Results
    Code:
    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

    /etc/apache2/conf.d/zm.conf
    Code:
    # turn short open tags on for zm directory
    <Directory /srv/www/htdocs/zm/>
    #        php_admin_flag short_open_tag On
            Options FollowSymLinks
    </Directory>
    Unresolved Problem
    That allows apache2 to start, but when attempting to start the zoneminder service as follows, the following error occurs
    Code:
    systemctl start zm.service
    Code:
    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/zmpkg.pl start (code=exited, status=255)
    
    Jul 13 16:27:30 linux-hf5m zmpkg.pl[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/Zo...onfig.pm line 91.
    Jul 13 16:27:30 linux-hf5m zmpkg.pl[4259]: Can't connect to db at /usr/lib/perl5/vendor_perl/5.18.1/ZoneMinder/Config.pm 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.

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

    >a2enmod php5

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •