Search found 271 matches

by BiloxiGeek
Tue Sep 25, 2018 10:01 am
Forum: ZoneMinder 1.32.x
Topic: API error or expected?
Replies: 4
Views: 2688

Re: API error or expected?

Tried pulling up one event via API using https://hostname/zm/api/events/14003.json Got some errors and then the expected result: Notice (8): Use of undefined constant ZM_DB_SSL_CA_CERT - assumed 'ZM_DB_SSL_CA_CERT' [CORE/Cake/Model/ConnectionManager.php, line 69] Notice (8): Use of undefined constan...
by BiloxiGeek
Tue Sep 25, 2018 9:42 am
Forum: ZoneMinder 1.32.x
Topic: API error or expected?
Replies: 4
Views: 2688

Re: API error or expected?

It looks like I'm seeing quite a few lines of errors whenever I try something via curl and the API. For example, just pulling events.json I get quite a few lines of seemingly errors before the json data: First I authenticate using: curl --silent --insecure -d "username=useid&password=passwo...
by BiloxiGeek
Mon Sep 24, 2018 4:36 pm
Forum: ZoneMinder 1.32.x
Topic: API error or expected?
Replies: 4
Views: 2688

API error or expected?

I've got some perl scripts I've used just to futz around with the API a bit here and there. Since updating to 1.32.0 I'm seeing some errors that I don't believe were there before the update. When deleting an event via the API using curl -b /root/cookies.txt --silent --insecure -XDELETE https://serve...
by BiloxiGeek
Mon Sep 24, 2018 4:27 pm
Forum: ZoneMinder 1.32.x
Topic: Upgrades issues
Replies: 10
Views: 4985

Re: Upgrades issues

so BiloxiGeek you were able to get a quick resolution and ZM is working now? Yes, the web interface is working once I got the config file issue figured out. Working through some API issues now that seem to be affecting zmNinja. But I haven't gotten the problem figured out much less a solution yet.
by BiloxiGeek
Fri Sep 21, 2018 4:05 pm
Forum: ZoneMinder 1.32.x
Topic: Upgrades issues
Replies: 10
Views: 4985

Re: Upgrades issues

Read through /usr/share/doc/zoneminder-1.23.0/README.

It does not mention needing to move /etc/zm/www/zoneminder.conf into /etc/httpd/conf.d/ so apache can read it upon startup. Once I copied that file over things started looking much better.
by BiloxiGeek
Fri Sep 21, 2018 2:52 pm
Forum: ZoneMinder 1.32.x
Topic: Upgrades issues
Replies: 10
Views: 4985

Upgrades issues

This morning my zm setup got updated via yum and I've lost access to all my monitors. Can't view any of the defined monitors. The events that are showing can't be viewed as well, they also can't be deleted. I'm betting I just need to refresh something in the setup but it's eluding me at the moment. ...
by BiloxiGeek
Thu May 11, 2017 12:28 pm
Forum: ZoneMinder 1.30.x
Topic: Events cleared, why are frames still in database.
Replies: 4
Views: 3163

Re: Events cleared, why are frames still in database.

Possibly this will help: Make the following changes: character-set-server = latin1 collation-server = latin1_swedish_ci Note: The above settings are actually the Mariadb default. Changing back to default is necessary to avoid errors when logging into Zoneminder. This was added on 01APR17 but is not...
by BiloxiGeek
Wed May 10, 2017 2:24 pm
Forum: ZoneMinder 1.30.x
Topic: Events cleared, why are frames still in database.
Replies: 4
Views: 3163

Re: Events cleared, why are frames still in database.

Forgot this... Every time I run zmaudit.pl I get this message: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 2 at /usr/bin/zmaudit.pl line 384. The zoneminder is 1.30.3...
by BiloxiGeek
Wed May 10, 2017 2:16 pm
Forum: ZoneMinder 1.30.x
Topic: Events cleared, why are frames still in database.
Replies: 4
Views: 3163

Events cleared, why are frames still in database.

Been noticing this behavior lately. I try to review any events on my setup at least once a day and if nothing of interest happened I just delete the events. Lately I've been coming along after that process and running zmaudit.pl which clears out the events from the database and cleans up the filesys...
by BiloxiGeek
Mon May 08, 2017 4:07 pm
Forum: ZoneMinder 1.30.x
Topic: Flush old data from ibd files
Replies: 7
Views: 8958

Re: Flush old data from ibd files

Deleted 5 events using the web UI. Checking from mysql I see no events but 909 frames. Ran zmaudit and checked mysql again, same state. Events are deleted but frames are not. The frames themselves are deleted from the filesystem, just the reference in the Frames table remains. [root@zone zm]# zmaudi...
by BiloxiGeek
Mon May 08, 2017 1:43 pm
Forum: ZoneMinder 1.30.x
Topic: Flush old data from ibd files
Replies: 7
Views: 8958

Re: Flush old data from ibd files

Just started up ZM, forced an alarm on one monitor just to have one event to play with. I see the appropriate entries in the Events and Frames tables. Then I deleted the event. The Events table now has no rows, but the Frames table still shows all the Frames. Stopped ZM, ran zmaudit.pl and it delete...
by BiloxiGeek
Mon May 08, 2017 12:55 pm
Forum: ZoneMinder 1.30.x
Topic: Flush old data from ibd files
Replies: 7
Views: 8958

Re: Flush old data from ibd files

Got all the row in Frames deleted, ran the optimize table Frames and now Frames.ibd is about 147kB. Much better! Starting the same procedure on Logs now.
by BiloxiGeek
Mon May 08, 2017 12:26 pm
Forum: ZoneMinder 1.30.x
Topic: Flush old data from ibd files
Replies: 7
Views: 8958

Re: Flush old data from ibd files

I see year old frames showing up. I did a little googling later yesterday and I'm currently deleting old frames a little at a time while zoneminder is shut down. When I started I had over 30 million rows in the Frames table. Once I get it cleaned out I'll run the optimize process and see what happen...
by BiloxiGeek
Sun May 07, 2017 7:07 pm
Forum: ZoneMinder 1.30.x
Topic: Flush old data from ibd files
Replies: 7
Views: 8958

Flush old data from ibd files

Got 1.30.3 working, I've switched the database to use innodb_file_per_table. Right now I have no events showing up, the filesystem is empty for all the monitors. But when I look at the files in /var/lib/mysql/zm/ I see that Frames.ibd and Logs.ibd are 3 and 5 GB in size and Stats.ibd is about 240MB....
by BiloxiGeek
Fri Apr 15, 2016 11:26 am
Forum: Website Issues
Topic: Spam edits on the wiki.
Replies: 14
Views: 22668

Re: Spam edits on the wiki.

User "lary" posting spam. I replaced the junk with "Spam"