DB problem ?

Forum for questions and support relating to the 1.24.x releases only.
Locked
timf
Posts: 132
Joined: Mon Mar 21, 2005 4:07 pm
Location: Lytham St.Annes Lancs.

DB problem ?

Post by timf »

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.
Flasheart
Posts: 342
Joined: Thu Jul 06, 2006 2:27 pm

Re: DB problem ?

Post by Flasheart »

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.
timf
Posts: 132
Joined: Mon Mar 21, 2005 4:07 pm
Location: Lytham St.Annes Lancs.

Re: DB problem ?

Post by timf »

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
Locked