MySQL - Revision history

Burger: /* Disable Logging via cli */

2026-04-20T01:56:51Z

Disable Logging via cli

← Older revision		Revision as of 21:56, 19 April 2026
Line 205:		Line 205:
	mysql -u root zm -e "Update Config set Value = '-5' where Name = 'ZM_LOG_LEVEL_WEBLOG';"		mysql -u root zm -e "Update Config set Value = '-5' where Name = 'ZM_LOG_LEVEL_WEBLOG';"
	</pre>		</pre>
	And restart zm.		And restart zm. I would recommend setting this in a crontab on a zm server, just so you don't accidentally leave logging on at some point.

	===Set all video lengths to be 1 hour===		===Set all video lengths to be 1 hour===

Burger: /* Change All Cameras to Have mm/dd/yy Instead of dd/mm/yy in Timestamp */

2026-01-09T20:55:02Z

Change All Cameras to Have mm/dd/yy Instead of dd/mm/yy in Timestamp

← Older revision		Revision as of 16:55, 9 January 2026
Line 121:		Line 121:
	===Change All Cameras to Have mm/dd/yy Instead of dd/mm/yy in Timestamp===		===Change All Cameras to Have mm/dd/yy Instead of dd/mm/yy in Timestamp===
	(1.34)		(1.34)
	UPDATE Monitors SET LabelFormat ="%N - %m-%d-%Y ~~%H:%M:%S %z" WHERE LabelFormat ="%N - %Y-%m-%d~~ %H:%M:%S %z";		UPDATE Monitors SET LabelFormat ="%N - %m-%d-%Y %H:%M:%S %z";

	===Change All Cameras to Have mm/dd/yy and 12 hour / AM/PM in Timestamp===		===Change All Cameras to Have mm/dd/yy and 12 hour / AM/PM in Timestamp===
	(1.34)		(1.34)

Burger: /* Change All Cameras to Have mm/dd/yy and 12 hour / AM/PM in Timestamp */

2026-01-09T20:54:51Z

Change All Cameras to Have mm/dd/yy and 12 hour / AM/PM in Timestamp

← Older revision		Revision as of 16:54, 9 January 2026
Line 124:		Line 124:
	===Change All Cameras to Have mm/dd/yy and 12 hour / AM/PM in Timestamp===		===Change All Cameras to Have mm/dd/yy and 12 hour / AM/PM in Timestamp===
	(1.34)		(1.34)
	UPDATE Monitors SET LabelFormat ="%N - %m/%d/%Y %l:%M:%S %p" ~~WHERE LabelFormat ="%N - %Y-%m-%d %H:%M:%S %z";~~		UPDATE Monitors SET LabelFormat ="%N - %m/%d/%Y %l:%M:%S %p"
	~~The %z is for offset from GMT, which most people won't need. These can be found from the man page for date.~~
	~~Or:~~
	~~UPDATE Monitors SET LabelFormat ="%N - %m/%d/%Y %l:%M:%S %p" WHERE LabelFormat ="%N - %d/%m/%y %H:%M:%S";~~


	You can review the existing Timestamps with:		You can review the existing Timestamps with:
	select LabelFormat from Monitors\G		select LabelFormat from Monitors\G

Burger: /* Change All Cameras to Have Sun Sep 15 07:06:05 2015 Format */

2026-01-09T20:52:02Z

Change All Cameras to Have Sun Sep 15 07:06:05 2015 Format

← Older revision		Revision as of 16:52, 9 January 2026
Line 141:		Line 141:
	This benefits from having the day of the week in the string. Not necessary for legal use, but is useful if you review videos between two days of the week.		This benefits from having the day of the week in the string. Not necessary for legal use, but is useful if you review videos between two days of the week.

	UPDATE Monitors SET LabelFormat ="%N - %c~~" WHERE LabelFormat ="%N - %d/%m/%y %H:%M:%S~~";		UPDATE Monitors SET LabelFormat ="%N - %c";

	The day of the week is either %a (shorthand) or %A. For more details see http://strftime.org and http://zoneminder.readthedocs.io		The day of the week is either %a (shorthand) or %A. For more details see http://strftime.org and http://zoneminder.readthedocs.io

Burger: /* Change All Cameras to Have Sun Sep 15 07:06:05 2015 Format */

2026-01-09T20:49:55Z

Change All Cameras to Have Sun Sep 15 07:06:05 2015 Format

← Older revision		Revision as of 16:49, 9 January 2026
Line 143:		Line 143:
	UPDATE Monitors SET LabelFormat ="%N - %c" WHERE LabelFormat ="%N - %d/%m/%y %H:%M:%S";		UPDATE Monitors SET LabelFormat ="%N - %c" WHERE LabelFormat ="%N - %d/%m/%y %H:%M:%S";

	The day of the week is either %a (shorthand) or %A.For more details see http://strftime.org and http://zoneminder.readthedocs.io		The day of the week is either %a (shorthand) or %A. For more details see http://strftime.org and http://zoneminder.readthedocs.io

	===Check Value of AUTH_RELAY===		===Check Value of AUTH_RELAY===

Burger: /* Change All Cameras to Have Sun Sep 15 07:06:05 2015 Format */

2026-01-09T20:49:42Z

Change All Cameras to Have Sun Sep 15 07:06:05 2015 Format

← Older revision		Revision as of 16:49, 9 January 2026
Line 143:		Line 143:
	UPDATE Monitors SET LabelFormat ="%N - %c" WHERE LabelFormat ="%N - %d/%m/%y %H:%M:%S";		UPDATE Monitors SET LabelFormat ="%N - %c" WHERE LabelFormat ="%N - %d/%m/%y %H:%M:%S";

	The day of the week is either %a (shorthand) or %A.For more details see [strftime.org] and [zoneminder.readthedocs.io]		The day of the week is either %a (shorthand) or %A.For more details see http://strftime.org and http://zoneminder.readthedocs.io

	===Check Value of AUTH_RELAY===		===Check Value of AUTH_RELAY===

Burger: /* Change All Cameras to Have Sun Sep 15 07:06:05 2015 Format */

2026-01-09T20:49:20Z

Change All Cameras to Have Sun Sep 15 07:06:05 2015 Format

← Older revision		Revision as of 16:49, 9 January 2026
Line 143:		Line 143:
	UPDATE Monitors SET LabelFormat ="%N - %c" WHERE LabelFormat ="%N - %d/%m/%y %H:%M:%S";		UPDATE Monitors SET LabelFormat ="%N - %c" WHERE LabelFormat ="%N - %d/%m/%y %H:%M:%S";

	The day of the week is either %a (shorthand) or %A.For more details see strftime.org and zoneminder.readthedocs.io		The day of the week is either %a (shorthand) or %A.For more details see [strftime.org] and [zoneminder.readthedocs.io]

	===Check Value of AUTH_RELAY===		===Check Value of AUTH_RELAY===

Burger: /* Change All Cameras to Have mm/dd/yy and 12 hour / AM/PM in Timestamp */

2026-01-09T20:48:26Z

Change All Cameras to Have mm/dd/yy and 12 hour / AM/PM in Timestamp

← Older revision		Revision as of 16:48, 9 January 2026
Line 136:		Line 136:

	'''Note''' that for fail2ban, you may want to use the '''DATETIME_OVERRIDE_PATTERN''' in options. See [[ZMNinja]].		'''Note''' that for fail2ban, you may want to use the '''DATETIME_OVERRIDE_PATTERN''' in options. See [[ZMNinja]].

			===Change All Cameras to Have Sun Sep 15 07:06:05 2015 Format===

			This benefits from having the day of the week in the string. Not necessary for legal use, but is useful if you review videos between two days of the week.

			UPDATE Monitors SET LabelFormat ="%N - %c" WHERE LabelFormat ="%N - %d/%m/%y %H:%M:%S";

			The day of the week is either %a (shorthand) or %A.For more details see strftime.org and zoneminder.readthedocs.io

	===Check Value of AUTH_RELAY===		===Check Value of AUTH_RELAY===

Burger: /* Update Events Count on the Console if Event Count is Incorrect */

2025-12-25T19:29:29Z

Update Events Count on the Console if Event Count is Incorrect

← Older revision		Revision as of 15:29, 25 December 2025
Line 242:		Line 242:
	done		done
	</pre>		</pre>
			Tested in 1.36.

	===Print the Last 50 Times from a Given Monitor's Recordings===		===Print the Last 50 Times from a Given Monitor's Recordings===

Burger: /* Update Events Count on the Console if Event Count is Incorrect */

2025-12-25T19:25:34Z

Update Events Count on the Console if Event Count is Incorrect

← Older revision		Revision as of 15:25, 25 December 2025
Line 224:		Line 224:
	===Update Events Count on the Console if Event Count is Incorrect===		===Update Events Count on the Console if Event Count is Incorrect===

	for i in {1..100}		<pre>
	do		for i in {1..100}
	mysql -u root zm -e "update Event_Summaries set TotalEvents= (Select count(*) from Events where MonitorID='$i') where MonitorID='$i';"		do
	mysql -u root zm -e "update Event_Summaries set HourEvents= (Select count(*) from Events_Hour where MonitorID='$i') where MonitorID='$i';"		mysql -u root zm -e "update Event_Summaries set TotalEvents= (Select count(*) from Events where MonitorID='$i') where MonitorID='$i';"
	mysql -u root zm -e "update Event_Summaries set DayEvents= (Select count(*) from Events_Day where MonitorID='$i') where MonitorID='$i';"		mysql -u root zm -e "update Event_Summaries set HourEvents= (Select count(*) from Events_Hour where MonitorID='$i') where MonitorID='$i';"
	mysql -u root zm -e "update Event_Summaries set WeekEvents= (Select count(*) from Events_Week where MonitorID='$i') where MonitorID='$i';"		mysql -u root zm -e "update Event_Summaries set DayEvents= (Select count(*) from Events_Day where MonitorID='$i') where MonitorID='$i';"
	mysql -u root zm -e "update Event_Summaries set MonthEvents= (Select count(*) from Events_Month where MonitorID='$i') where MonitorID='$i';"		mysql -u root zm -e "update Event_Summaries set WeekEvents= (Select count(*) from Events_Week where MonitorID='$i') where MonitorID='$i';"
	mysql -u root zm -e "update Event_Summaries set ArchivedEvents= (Select count(*) from Events_Archived where MonitorID='$i') where MonitorID='$i';"		mysql -u root zm -e "update Event_Summaries set MonthEvents= (Select count(*) from Events_Month where MonitorID='$i') where MonitorID='$i';"
			mysql -u root zm -e "update Event_Summaries set ArchivedEvents= (Select count(*) from Events_Archived where MonitorID='$i') where MonitorID='$i';"

	mysql -u root zm -e "update Event_Summaries set TotalEventDiskSpace= (Select Sum(DiskSpace) from Events where MonitorID='$i') where MonitorID='$i';"		mysql -u root zm -e "update Event_Summaries set TotalEventDiskSpace= (Select Sum(DiskSpace) from Events where MonitorID='$i') where MonitorID='$i';"
	mysql -u root zm -e "update Event_Summaries set HourEventDiskSpace= (Select Sum(DiskSpace) from Events_Hour where MonitorID='$i') where MonitorID='$i';"		mysql -u root zm -e "update Event_Summaries set HourEventDiskSpace= (Select Sum(DiskSpace) from Events_Hour where MonitorID='$i') where MonitorID='$i';"
	mysql -u root zm -e "update Event_Summaries set DayEventDiskSpace= (Select Sum(DiskSpace) from Events_Day where MonitorID='$i') where MonitorID='$i';"		mysql -u root zm -e "update Event_Summaries set DayEventDiskSpace= (Select Sum(DiskSpace) from Events_Day where MonitorID='$i') where MonitorID='$i';"
	mysql -u root zm -e "update Event_Summaries set WeekEventDiskSpace= (Select Sum(DiskSpace) from Events_Week where MonitorID='$i') where MonitorID='$i';"		mysql -u root zm -e "update Event_Summaries set WeekEventDiskSpace= (Select Sum(DiskSpace) from Events_Week where MonitorID='$i') where MonitorID='$i';"
	mysql -u root zm -e "update Event_Summaries set MonthEventDiskSpace= (Select Sum(DiskSpace) from Events_Month where MonitorID='$i') where MonitorID='$i';"		mysql -u root zm -e "update Event_Summaries set MonthEventDiskSpace= (Select Sum(DiskSpace) from Events_Month where MonitorID='$i') where MonitorID='$i';"
	mysql -u root zm -e "update Event_Summaries set ArchivedEventDiskSpace= (Select Sum(DiskSpace) from Events_Archived where MonitorID='$i') where MonitorID='$i';"		mysql -u root zm -e "update Event_Summaries set ArchivedEventDiskSpace= (Select Sum(DiskSpace) from Events_Archived where MonitorID='$i') where MonitorID='$i';"
	done		done
			</pre>

	===Print the Last 50 Times from a Given Monitor's Recordings===		===Print the Last 50 Times from a Given Monitor's Recordings===