pkg/54632: No video of zoneminder monitor for usb camera

[g01%no.pl@localhost]

>Number:         54632
>Category:       pkg
>Synopsis:       No video of zoneminder monitor for usb camera
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    pkg-manager
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Mon Oct 21 12:45:00 +0000 2019
>Originator:     Guest01
>Release:        packages/NetBSD/amd64/8.0_2019Q2
>Organization:
-
>Environment:
NetBSD localhost 8.0 NetBSD 8.0 (GENERIC) #0: Tue Jul 17 14:59:51 UTC 2018  mkrepro%mkrepro.NetBSD.org@localhost:/usr/src/sys/arch/amd64/compile/GENERIC amd64

>Description:
I have configured monitor in zoneminder console for /dev/video0 device. The device is usb camera. When I click monitor there is not video.

Console log reports error:
Message: Unable to open input /dev/video0 due to: Connection timed out
File: zm_ffmpeg_camera.cpp
Line: 264
>How-To-Repeat:
Instal and configure zoneminder application:
1. export PKG_PATH="http://ftp.netbsd.org/pub/pkgsrc/packages/NetBSD/amd64/8.0_2019Q2/All/";
2. Install mysql-server-5.7.27 with command: pkg_add mysql-server
3. cp /usr/pkg/share/examples/rc.d/mysqld /etc/rc.d/
4. /etc/rc.d/mysqld onestart
5. /usr/pkg/bin/mysql_secure_installation
6. pkg_add zoneminder
7. echo "create user 'zmuser'@'localhost' identified by 'zmpass';" | mysql -u root -p
8. mysql -u root -p < /usr/pkg/share/zoneminder/db/zm_create.sql
9. echo "grant all on zm.* to 'zmuser@localhost' identified by 'zmpass';" | mysql -u root zm -p
10. Add in /usr/pkg/etc/httpd/httpd.conf
LoadModule php5_module lib/httpd/mod_php5.so
  <FilesMatch \.php$>
      SetHandler application/x-httpd-php
  </FilesMatch>
Include /usr/pkg/share/examples/zoneminder/apache/zoneminder.conf
11. Comment and uncomment in /usr/pkg/etc/httpd/httpd.conf
#LoadModule mpm_event_module lib/httpd/mod_mpm_event.so
LoadModule mpm_prefork_module lib/httpd/mod_mpm_prefork.so
12. /usr/pkg/share/examples/zoneminder/apache/zoneminder.conf:
# This Apache configuration puts ZoneMinder under /zm.
# Access is limited to localhost, as a safe default until
# intentionally changed.

ScriptAlias /zm/cgi-bin/ "/usr/pkg/libexec/zoneminder/cgi-bin/"

<Directory "/usr/pkg/libexec/zoneminder/cgi-bin">
  <RequireAny>
    Require ip 127.0.0.1
  </RequireAny>
</Directory>

Alias /zm "/usr/pkg/share/zoneminder/htdocs"

<Directory "/usr/pkg/share/zoneminder/htdocs">
  php_flag register_globals off
  php_flag short_open_tag on
  DirectoryIndex index.php
  <RequireAny>
    Require ip 127.0.0.1
  </RequireAny>
</Directory>

13. cp /usr/pkg/share/examples/rc.d/apache /etc/rc.d
14. /etc/rc.d/apache onestart
15. 127.0.0.1/zm
16. Start zoneminder console
17. Because of message in log:
"Can't execute: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'zm.E.StartTime' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"
do:
mysql -u root -p
set @@global.sql_mode='';
quit;
18. Add new monitor
Source type: Ffmpeg
Maximum FPS: 5
Source path: /dev/video0
Save
19. Options
PATH_ZMS: /zm/cgi-bin/nph-zms
Save
Cancel
20. Stop Zonemider Console
21. Start Zoneminder Console
22. Run monitor

>Fix:
-