ZoneMinder Forums

I am seeing some events with a timestamp of 1969-12-31.

This seems to only happen on my newer builds using Ubuntu. I used to standardize on CentOS but have since made the switch to Ubuntu.

Running Ubuntu Server 9.04 amd64 (seeing this on 32bit boxes also)
Zoneminder built according to this guide:
http://www.zoneminder.com/forums/viewtopic.php?t=14281

I noticed that normando and cordel were troubleshooting this at the beginning of the year in 1.23.x:
http://www.zoneminder.com/forums/viewto ... light=1969

zmf is disabled and this is still happening.

Like normando, I verified that these timestamps are being written to the database with the 1969 timestamp.

I have not configured any php TZ yet.

Can anybody point me in the right direction?

Check the bug list for MySQL as well as make sure your machine is not overloaded and you have MySQL properly tuned. MySQL Provides all the time stamps n the database.

I may be way off base here, but I seem to remember seeing that on my system too...

I was using Modect and I think it occured when I looked at an event before it was finished recording.

Keith

I think that I resolved the timestamp issues by doing the following:

FIRST INSTALL mysqltuner:
sudo -i
apt-get install mysqltuner

STOP ZONEMINDER
/etc/init.d/zm stop

STOP MYSQL
/etc/init.d/mysql stop

EDIT YOUR my.cnf FILE
vi /etc/mysql/my.cnf

UNCOMMENT skip-innodb OR ADD IT IF IT IS NOT IN THERE

MAKE SURE THE THE FOLLOWING PARAMETERS ARE SET:
key_buffer = 16M
max_allowed_packet = 32M
thread_stack = 128K
thread_cache_size = 8
query_cache_limit = 1M
query_cache_size = 24M

ADD THESE PARAMETERS:
tmp_table_size = 32M
max_heap_table_size = 16M

SAVE AND EXIT

START MYSQL
/etc/init.d/mysql start

START ZONEMINDER
/etc/init.d/zm start

IF YOU WANT TO TUNE YOUR OWN SYSTEM, LET YOUR SYSTEM RUN NORMALLY FOR ABOUT 15 MINUTES AND THEN RUN:
mysqltuner

IT WILL ASK YOU FOR YOUR MYSQL ROOT USERNAME AND PASSWORD SO ENTER IT

ONCE YOU ENTER YOUR USERNAME AND PASSWORD IT WILL GIVE YOU SOME RECOMMENDATIONS. I WOULD GUESS THAT IF YOU APPLY THE ABOVE SETTINGS IT WILL NOT RECOMMEND ANY CHANGES.

You can disregard this:
General recommendations:
Enable the slow query log to troubleshoot bad queries

You will probably find that your system will run with greater efficiency

I have Zm 1.22.3 under mandriva 2007 from livecd. I use to consider the performance to be excellent but tried mysqltuner just to see what happends and now i and getting even better performance.

This might be something every one should try. Just make a copy of your my.cnf in case you want to return to original settings.

I was worried about installation of mysqltunner but finally discovered that is a script that you download (no need to install) .
All i had to do was.

wget -O mysqltuner.pl http://tools.assembla.com/mysqltuner/br ... format=txt
chmod 775 mysqltuner.pl

To run it just go to the palce you have it and type
perl mysqltuner.pl

This is someting i has never done before and there are some recommendations that i have to read more about. I have just applied the ones you mentioned and i can see a increase in performance,