Search found 6 matches

by jerrypaulick
Sun Jan 14, 2024 4:25 pm
Forum: ZoneMinder 1.32.x
Topic: Remote database errors - "('debian-sys-maint'@'localhost') does not exist"
Replies: 2
Views: 28676

Re: Remote database errors - "('debian-sys-maint'@'localhost') does not exist"

setovi wrote: Mon Sep 12, 2022 3:35 pm I solved it by substituting that user with the right zmuser for my environment, dropping the database, and restoring the mysqldump backup.
Yes, this does the trick. I've put more details on how to do that on my other post if anyone needed a hint as of how to go about it.
by jerrypaulick
Sat Jan 13, 2024 8:09 pm
Forum: ZoneMinder 1.32.x
Topic: The user specified as a definer ('debian-sys-maint'@'localhost') does not exist
Replies: 8
Views: 73294

Re: The user specified as a definer ('debian-sys-maint'@'localhost') does not exist

Fixed!! Thanks! I dumped the db, went in and searched the dump file and found two instances of the debian-sys-maint and replaced them with zmuser Reloaded the DB and all good, thanks! Thanks, this seemed to help. - I've traced the issue back to the day where I moved my whole ZM instance from physic...
by jerrypaulick
Fri Mar 18, 2022 7:52 am
Forum: ZoneMinder 1.36.x
Topic: Correcting wrong aspect ratio with passthrough recording
Replies: 8
Views: 2606

Re: Correcting wrong aspect ratio with passthrough recording

I played with the encoderparams yesterday, tried adding the -aspect 16:9 in multiple ways, but it didn't seem to have an effect on the final file. I will probably write a bash script that will fix the file once the event is complete and run it through the Filters. It's probably good to say that even...
by jerrypaulick
Thu Mar 17, 2022 7:33 am
Forum: ZoneMinder 1.36.x
Topic: Correcting wrong aspect ratio with passthrough recording
Replies: 8
Views: 2606

Re: Correcting wrong aspect ratio with passthrough recording

Have you considered Storage -> Optional Encoder Parameters (?) I tried it and it didn't do anything. I don't think these settings are used for passthrough saving, but were used before when the video files were assembled from the individual jpgs. For the Filters solution, I am wondering how to avoid...
by jerrypaulick
Sun Mar 13, 2022 5:23 pm
Forum: ZoneMinder 1.36.x
Topic: Correcting wrong aspect ratio with passthrough recording
Replies: 8
Views: 2606

Correcting wrong aspect ratio with passthrough recording

Hi, I've got one camera that's 4MP and 16/9, which would normally mean a 2560x1440 video. However, the raw video stream out of the camera introduces itself as [SAR 4:3 DAR 64:27], as per the ffprobe output: Stream #0:0: Video: h264 (High), yuvj420p(pc, progressive), 2560x1440 [SAR 4:3 DAR 64:27], 10...
by jerrypaulick
Tue Dec 08, 2020 12:52 pm
Forum: Non-ZoneMinder Chat
Topic: Finally upgraded and the space saving is huge! #yay
Replies: 0
Views: 11908

Finally upgraded and the space saving is huge! #yay

Post just for fun, I recently upgraded from ooooold version (1.27?) to recent ZoneMinder 1.32, so I could FINALLY get that x264 passthrough recording instead of millions of single jpegs. Actually I wasn't even planning on it, just tried it out in a sandbox VM to see how it all works and stuff... Wel...