[SOLVED] Arch - Can't connect to db at ....

Forum for questions and support relating to the 1.28.x releases only.
Post Reply
hedeon
Posts: 4
Joined: Mon Feb 09, 2015 3:08 pm

[SOLVED] Arch - Can't connect to db at ....

Post by hedeon » Mon Feb 09, 2015 3:18 pm

Hi

I really like to try ZoneMinder, but I suck in understanding SQL, PHP, Perl, Apache etc...
I am stuck no starting the service.
httpd starts fine, then when I go with zoneminder, I get:
systemctl start zoneminder.service
Job for zoneminder.service failed. See "systemctl status zoneminder.service" and "journalctl -xe" for details.

Code: Select all

 systemctl status zoneminder.service
zoneminder.service - ZoneMinder CCTV recording and security system
   Loaded: loaded (/usr/lib/systemd/system/zoneminder.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Mon 2015-02-09 14:56:30 GMT; 12s ago
  Process: 597 ExecStart=/usr/bin/zmpkg.pl start (code=exited, status=255)

Feb 09 14:56:30 ZoneMinderServer zmpkg.pl[597]: Can't connect to db at /usr/lib/perl5/ZoneMinder/Config.pm line 100.
Feb 09 14:56:30 ZoneMinderServer zmpkg.pl[597]: BEGIN failed--compilation aborted at /usr/lib/perl5/ZoneMinder/Config.pm line 100.
Feb 09 14:56:30 ZoneMinderServer zmpkg.pl[597]: Compilation failed in require at /usr/lib/perl5/ZoneMinder.pm line 33.
Feb 09 14:56:30 ZoneMinderServer zmpkg.pl[597]: BEGIN failed--compilation aborted at /usr/lib/perl5/ZoneMinder.pm line 33.
Feb 09 14:56:30 ZoneMinderServer zmpkg.pl[597]: Compilation failed in require at /usr/bin/zmpkg.pl line 37.
Feb 09 14:56:30 ZoneMinderServer zmpkg.pl[597]: BEGIN failed--compilation aborted at /usr/bin/zmpkg.pl line 37.
Feb 09 14:56:30 ZoneMinderServer systemd[1]: zoneminder.service: control process exited, code=exited status=255
Feb 09 14:56:30 ZoneMinderServer systemd[1]: Failed to start ZoneMinder CCTV recording and security system.
Feb 09 14:56:30 ZoneMinderServer systemd[1]: Unit zoneminder.service entered failed state.
Feb 09 14:56:30 ZoneMinderServer systemd[1]: zoneminder.service failed.

Any one has an idea?
Thanks for all the help
Last edited by hedeon on Tue Feb 10, 2015 1:14 pm, edited 1 time in total.

christophe_y2k
Posts: 102
Joined: Mon Oct 12, 2009 8:47 am
Location: EUROPE-FRANCE-MANDELIEU

Re: Arch - Can't connect to db at ....

Post by christophe_y2k » Mon Feb 09, 2015 9:44 pm

try to rebuild all perl module with perl cleaner
# perl-cleaner reallyall
after reinstall zoneminder

User avatar
knight-of-ni
Posts: 2367
Joined: Thu Oct 18, 2007 1:55 pm
Location: Shiloh, IL

Re: Arch - Can't connect to db at ....

Post by knight-of-ni » Tue Feb 10, 2015 1:43 am

That error message simply means zoneminder can't connect to your database.
It does not indicate that there is a problem with your Perl.

Standard dB troubleshooting applies here:
Is mysql running?
Did you create the zm database?
Is the the zonminder user account created and does it have the right permissions?
Are the database user account credentials correctly entered into zm.conf?

The following README is for Fedora, but the steps that show how to set up the database apply:
https://github.com/ZoneMinder/ZoneMinde ... DME.Fedora
Visit my blog for ZoneMinder related projects using the Raspberry Pi, Orange Pi, Odroid, and the ESP8266
All of these can be found at https://zoneminder.blogspot.com/

hedeon
Posts: 4
Joined: Mon Feb 09, 2015 3:08 pm

Re: Arch - Can't connect to db at ....

Post by hedeon » Tue Feb 10, 2015 9:55 am

knnniggett wrote:That error message simply means zoneminder can't connect to your database.
It does not indicate that there is a problem with your Perl.

Standard dB troubleshooting applies here:
Is mysql running?
Did you create the zm database?
Is the the zonminder user account created and does it have the right permissions?
Are the database user account credentials correctly entered into zm.conf?

The following README is for Fedora, but the steps that show how to set up the database apply:
Thanks for replays. As I said, I have completely 0 understanding of things like php, sql, etc... (maybe it is a time to change that?)
I have followed arch guide (can't post links) and there is nothing about setting up MySQL. I'll give a go the thread for fedora, and probably will comeback here if this won't help.

Thanks

hedeon
Posts: 4
Joined: Mon Feb 09, 2015 3:08 pm

Re: Arch - Can't connect to db at ....

Post by hedeon » Tue Feb 10, 2015 1:14 pm

Well, Setting up mySQL was the thing! Thank you very much, I will mark thread as solved.
However I have different problem now and was hoping that I could get pushed in to right direction once again. While trying to connect to ZM through browser, I am getting

Access Forbidden Error 403

I am trying to access it from different machine as local one has no GUI/monitor/keyboard

User avatar
knight-of-ni
Posts: 2367
Joined: Thu Oct 18, 2007 1:55 pm
Location: Shiloh, IL

Re: [SOLVED] Arch - Can't connect to db at ....

Post by knight-of-ni » Tue Feb 10, 2015 1:30 pm

That is a problem with your Apache config.
You need to look for "Allow from" and/or "Deny from" statements in your config and adjust them accordingly.
I'm not familiar with Arch so I can't be more preceise than that.
Visit my blog for ZoneMinder related projects using the Raspberry Pi, Orange Pi, Odroid, and the ESP8266
All of these can be found at https://zoneminder.blogspot.com/

hedeon
Posts: 4
Joined: Mon Feb 09, 2015 3:08 pm

Re: [SOLVED] Arch - Can't connect to db at ....

Post by hedeon » Tue Feb 10, 2015 3:29 pm

knnniggett wrote:That is a problem with your Apache config.
You need to look for "Allow from" and/or "Deny from" statements in your config and adjust them accordingly.
I'm not familiar with Arch so I can't be more preceise than that.
Cheers, Thank you a lot :)

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests