View unanswered posts | View active topics It is currently Thu Oct 30, 2014 2:11 pm



Reply to topic  [ 3 posts ] 
DB problem ? 
Author Message

Joined: Mon Mar 21, 2005 5:07 pm
Posts: 86
Location: Lytham St.Annes Lancs.
Post DB problem ?
HI Guys,

long time no post - just moved house and re-setting up ZM.

Had to install a new HD for events and image storage - pretty sure I did it right in fstab and ownership etc

Everything appears to be running until I try and view stored events.

When I click on one it brings up the event but always with a duration of 0 and no content.

Looking in the syslog I see this:

Dec 23 10:53:37 localhost zms[3457]: FAT [Unable to load event 307, not found in DB]

I also noticed that mysql is complaining about corrupted tables for events - so I went into mysql and repaired the table.

As before I have symbolic links in /usr/share/zoneminder for events and images pointing to /var/cache/zoneminder/ events and /var/cache/zoneminder/images. BUt no images or events are getting stored there !

Any ideas ?

Cheers Tim

Edit - put the original storage drive back in and restored fstab etc. Still no stored images plus the sources on the control page stay orange rather than green when zm is running.


Sun Dec 23, 2012 12:13 pm
Profile

Joined: Thu Jul 06, 2006 3:27 pm
Posts: 341
Post Re: DB problem ?
Hi Tim,

The symbolic links should work ok (but check the wiki about upgrading zm, at least in debian it will delete the links, recreate the original dir structure and zmaudit will delete all your records!).

The obvious suggestion is that the newly created dirs that the symbolic links point to don't have permission for zm to write to.


Mon Dec 24, 2012 9:06 am
Profile

Joined: Mon Mar 21, 2005 5:07 pm
Posts: 86
Location: Lytham St.Annes Lancs.
Post Re: DB problem ?
Hi Flash,

thanks for the tip - after a good nights sleep and a fresh start I realized I had a type in the symbolic link !

Permissions were all set ok, just me being dumb with symbolic linking :-)

All is good now.

Merry Christmas

Tim


Mon Dec 24, 2012 12:31 pm
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 3 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group