NetBSD Problem Report #54632

From www@netbsd.org  Mon Oct 21 12:41:01 2019
Return-Path: <www@netbsd.org>
Received: from mail.netbsd.org (mail.netbsd.org [199.233.217.200])
	(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
	(Client CN "mail.NetBSD.org", Issuer "mail.NetBSD.org CA" (not verified))
	by mollari.NetBSD.org (Postfix) with ESMTPS id 32EAB7A155
	for <gnats-bugs@gnats.NetBSD.org>; Mon, 21 Oct 2019 12:41:01 +0000 (UTC)
Message-Id: <20191021124100.2C6437A1F1@mollari.NetBSD.org>
Date: Mon, 21 Oct 2019 12:41:00 +0000 (UTC)
From: g01@no.pl
Reply-To: g01@no.pl
To: gnats-bugs@NetBSD.org
Subject: No video of zoneminder monitor for usb camera
X-Send-Pr-Version: www-1.0

>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
>Closed-Date:    
>Last-Modified:  Wed Jun 09 02:52:25 +0000 2021
>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:/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:
-

>Release-Note:

>Audit-Trail:

State-Changed-From-To: open->feedback
State-Changed-By: maya@NetBSD.org
State-Changed-When: Tue, 13 Oct 2020 03:36:19 +0000
State-Changed-Why:
If you were using a USB webcam which is on xHCI, this is likely from no support for isoc endpoints. This is fixed in netbsd-current. Does using netbsd-current fix your issue?


State-Changed-From-To: feedback->open
State-Changed-By: dholland@NetBSD.org
State-Changed-When: Wed, 09 Jun 2021 02:52:25 +0000
State-Changed-Why:
Feedback mail bounces, not sure if we should try to investigate further
or just close it.


>Unformatted:

NetBSD Home
NetBSD PR Database Search

(Contact us) $NetBSD: query-full-pr,v 1.46 2020/01/03 16:35:01 leot Exp $
$NetBSD: gnats_config.sh,v 1.9 2014/08/02 14:16:04 spz Exp $
Copyright © 1994-2020 The NetBSD Foundation, Inc. ALL RIGHTS RESERVED.