No picture, synch errors, mysqld errors...

Support and queries relating to all previous versions of ZoneMinder
AngryButler
Posts: 9
Joined: Mon Jul 26, 2004 2:34 pm
Location: Grand Haven, Mi, USA

No picture, synch errors, mysqld errors...

Post by AngryButler »

Hello,

I'm having terrible problems with getting Zoneminder installed and running on my laptop. Everything compiles and makes just fine, the php appears to run well enough, but I get a bunch of errors from mysqld and syslog, and get no picture. I'm sure it's some type of permissions issue, but I have *no idea* where. Any help would be appreciated - it's been a long and frustrating night.

I've tried to include as much info as I could - excuse the verbosity, and thanks in advance.



I'm running Debian with the 2.6.7 kernel, and Zoneminder 1.19.4. A Philips QC4000, with pwc and pwcx drivers loaded.


root@AngryButler:/tmp# ps aux |grep zm

www-data 5666 0.0 0.7 8188 5576 ? S 09:52 0:00 /usr/bin/perl -wT /usr/local/bin/zmdc.pl status
www-data 5688 0.1 0.9 97028 7480 ? S 09:52 0:00 /usr/local/bin/zmc -d 0
www-data 5692 1.5 1.5 14796 12160 ? S 09:52 0:00 /usr/bin/perl -wT /usr/local/bin/zmfilter.pl
www-data 5698 0.3 0.5 7236 4576 ? S 09:52 0:00 /usr/bin/perl -wT /usr/local/bin/zmaudit.pl -d 900 -y
www-data 5703 0.3 0.6 7752 5004 ? S 09:52 0:00 /usr/bin/perl -wT /usr/local/bin/zmwatch.pl
www-data 5707 0.6 0.8 9052 6332 ? S 09:52 0:00 /usr/bin/perl -w /usr/local/bin/zmupdate.pl -c
root 5751 0.0 0.0 1572 460 pts/3 R+ 09:53 0:00 grep zm


Output from MySQLd:

040726 8:45:24 Aborted connection 1 to db: 'zm' user: 'root' host: `localhost' (Got timeout reading communica tion packets)
040726 8:49:47 Aborted connection 32 to db: 'zm' user: 'root' host: `localhost' (Got timeout reading communic ation packets)
040726 8:54:48 Aborted connection 36 to db: 'zm' user: 'root' host: `localhost' (Got timeout reading communic ation packets)
040726 8:57:15 Aborted connection 40 to db: 'zm' user: 'root' host: `localhost' (Got timeout reading communic ation packets)
040726 9:52:48 Aborted connection 183 to db: 'zm' user: 'root' host: `localhost' (Got an error reading commun ication packets)
040726 9:53:02 Aborted connection 201 to db: 'zm' user: 'tsuther' host: `localhost' (Got an error reading com munication packets)
040726 9:57:24 Aborted connection 197 to db: 'zm' user: 'root' host: `localhost' (Got an error reading commun ication packets)
040726 9:57:24 Aborted connection 190 to db: 'zm' user: 'root' host: `localhost' (Got an error reading commun ication packets)
040726 9:57:24 Aborted connection 203 to db: 'zm' user: 'root' host: `localhost' (Got an error reading commun ication packets)
040726 9:57:24 Aborted connection 192 to db: 'zm' user: 'root' host: `localhost' (Got an error reading commun ication packets)
040726 9:57:24 Aborted connection 186 to db: 'zm' user: 'root' host: `localhost' (Got an error reading commun ication packets)

root@AngryButler:/var/log# tail syslog
Jul 26 10:27:13 AngryButler zmc-d0[7213]: ERR [Capture failure for frame 0: Invalid argument]
Jul 26 10:27:13 AngryButler zmc-d0[7213]: ERR [Sync failure for frame 0: Invalid argument]
Jul 26 10:27:14 AngryButler zmc-d0[7213]: ERR [Capture failure for frame 0: Invalid argument]
Jul 26 10:27:14 AngryButler zmc-d0[7213]: ERR [Sync failure for frame 0: Invalid argument]
Jul 26 10:27:15 AngryButler zmc-d0[7213]: ERR [Capture failure for frame 0: Invalid argument]
Jul 26 10:27:15 AngryButler zmc-d0[7213]: ERR [Sync failure for frame 0: Invalid argument]
Jul 26 10:27:16 AngryButler zmc-d0[7213]: ERR [Capture failure for frame 0: Invalid argument]
Jul 26 10:27:16 AngryButler zmc-d0[7213]: ERR [Sync failure for frame 0: Invalid argument]
Jul 26 10:27:17 AngryButler zmc-d0[7213]: ERR [Capture failure for frame 0: Invalid argument]
Jul 26 10:27:17 AngryButler zmc-d0[7213]: ERR [Sync failure for frame 0: Invalid argument]


root@AngryButler:~/whoohoo/zm-1.19.4# ipcs -m

------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 0 root 600 737284 9 dest
0x00000000 425985 root 600 393216 2 dest
0x00000000 458754 root 600 393216 2 dest
0x00000000 491523 root 600 196608 2 dest
0x00000000 524292 root 600 393216 2 dest
0x00000000 557061 root 600 196608 2 dest
0x00000000 589830 root 600 196608 2 dest
0x00000000 1900551 root 644 110592 2 dest
0x00000000 983048 root 644 110592 2 dest
0x00000000 2031625 root 666 56160 1 dest
0x7a6d2001 3080202 www-data 700 5760448 1

root@AngryButler:~/whoohoo/zm-1.19.4# cat /proc/sys/kernel/shmall
134217728

root@AngryButler:~/whoohoo/zm-1.19.4# cat /proc/sys/kernel/shmmax
134217728

root@AngryButler:/tmp# cat zmdc.log

Server starting at 04/07/26 09:52:49
'zmc -d 0' started at 04/07/26 09:52:52
'zmc -d 0' starting at 04/07/26 09:52:52, pid = 5688
'zmfilter.pl' started at 04/07/26 09:52:52
'zmfilter.pl' starting at 04/07/26 09:52:52, pid = 5692
'zmaudit.pl -d 900 -y' started at 04/07/26 09:52:52
'zmaudit.pl -d 900 -y' starting at 04/07/26 09:52:52, pid = 5698
'zmwatch.pl' started at 04/07/26 09:52:53
'zmwatch.pl' starting at 04/07/26 09:52:53, pid = 5703
'zmupdate.pl -c' started at 04/07/26 09:52:53
'zmupdate.pl -c' starting at 04/07/26 09:52:53, pid = 5707
'zmupdate.pl -c' stopping at 04/07/26 09:57:24
'zmupdate.pl -c' died at 04/07/26 09:57:24, signal 14
'zmfilter.pl ' stopping at 04/07/26 09:57:24
'zmfilter.pl ' died at 04/07/26 09:57:24, signal 14
'zmwatch.pl ' stopping at 04/07/26 09:57:24
'zmwatch.pl ' died at 04/07/26 09:57:24, signal 14
'zmaudit.pl -d 900 -y' stopping at 04/07/26 09:57:24
'zmaudit.pl -d 900 -y' died at 04/07/26 09:57:24, signal 14
'zmc -d 0' stopping at 04/07/26 09:57:24
'zmc -d 0' died at 04/07/26 09:57:24
Server shutdown at 04/07/26 09:57:34


root@AngryButler:/tmp# cat zmpkg.log

Command: start
Executing: /usr/local/bin/zmdc.pl check
Removing shared memory
Executing: /usr/local/bin/zmfix
Executing: /usr/local/bin/zmdc.pl status
Executing: /usr/local/bin/zmdc.pl start zmc -d 0
Executing: /usr/local/bin/zmdc.pl start zmfilter.pl
Executing: /usr/local/bin/zmdc.pl start zmaudit.pl -d 900 -y
Executing: /usr/local/bin/zmdc.pl start zmwatch.pl
Executing: /usr/local/bin/zmdc.pl start zmupdate.pl -c
Command: stop
Executing: /usr/local/bin/zmdc.pl check
Executing: /usr/local/bin/zmdc.pl shutdown
Removing shared memory
User avatar
nugget
Posts: 42
Joined: Mon Dec 08, 2003 7:52 pm
Location: Sydney, Australia
Contact:

Post by nugget »

Assuming this is a new installation, rather than an old installation gone bad, do you know if the zm database was created correctly, and is it up and running.

Looking at your Mysqld error messages there's obviously some sort of connect issues to the database. The db would have to be running, otherwise I don't thing the zm daemons start...

Try:
ps -ef | grep mysql
This command should show you if the mysql daemon is running (mysqld_safe or safe_mysqld, depending on the version of mysql)

Can you log into the database and run a simple query. Assuming the database name is the default "zm", and you know the database user/password strings:
mysql -D zm --user=root --password
(asks for your root user's mysql password)
show tables;
select Username from Users;

The above two simple queries should return data in a table form. Otherwise there's a problem with mysql.

Let me know how you go, and we'll try some more stuff.
AngryButler
Posts: 9
Joined: Mon Jul 26, 2004 2:34 pm
Location: Grand Haven, Mi, USA

Thanks for the help....

Post by AngryButler »

Thanks for the reply...

Your assumption is correct - this is a new install.

The queries seem to return OK, but "admin" is the only record in the "users" table. I must admit, I'm not really sure how the permissions should be set - I've been using mysqlcc to look further into the tables and perms. I have also run these commands per the README:

mysql mysql < zmschema.sql
mysql mysql
grant select,insert,update,delete on <your database name>.* to
'<your first username>'@localhost identified by '<your first
password>';
grant select on <your database name>.* to '<your second
username>'@localhost identified by '<your second password>'
quit

Here are the results of the queries you had me try:

root@AngryButler:/# ps -ef |grep mysqld
mysql 2124 2007 0 00:21 pts/5 00:00:00 mysqld
root 6488 2002 0 00:55 pts/1 00:00:00 grep mysqld

root@AngryButler:/# mysql -D zm -u root -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 50 to server version: 4.0.20-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show tables;
+--------------+
| Tables_in_zm |
+--------------+
| Config |
| Events |
| Filters |
| Frames |
| Monitors |
| States |
| Stats |
| TriggersX10 |
| Users |
| Zones |
+--------------+
10 rows in set (0.00 sec)

mysql> select Username from Users;
+----------+
| Username |
+----------+
| admin |
+----------+
1 row in set (0.00 sec)

mysql> quit
Bye
User avatar
davide
Posts: 78
Joined: Mon Mar 22, 2004 1:04 am
Location: Italy

Post by davide »

you may not have correctly set up users and permissions in mysql,
can you post us the exact command you used for assigning mysql permissions? this command is needed to tell mysql what mysql users can use zm database

here is mine:

Code: Select all

mysql mysql < zmschema.sql 
mysql mysql 
grant select,insert,update,delete on zm.* to 
'zm_admin'@localhost identified by 'donaldduck'; 
grant select on zm.* to 'zm_user'@localhost identified by 'mickeymouse' 
quit 
(don't post us real passwords)

obvioulsy
zm_admin:donaldduck
and
zm_user:mickeymouse
are the same values I used in the "perl zmconfig.pl" script

the Users table contains the list of the users allowed to access via www and should have nothing to do with your problem.

regards,
User avatar
nugget
Posts: 42
Joined: Mon Dec 08, 2003 7:52 pm
Location: Sydney, Australia
Contact:

Post by nugget »

Sorry about any confusion from my last post ... I was trying to determine if the zm database was intact, if mysql was running correctly or if there was a bigger problem.

Sounds as if the database is intact, and as Davide suggests your permissions might not be correct. See if his advice solves your problem.

If not, it might be easier to remove the old zm database and recreate it. If you havn't completed any configuration steps then you have nothing worthwhile in the database. To remove the old database and create a fresh (empty) one do this:
1. shut down zm and mysql using the /etc/init.d scripts
2. cd /var/lib/mysql, and move the zm database to zm.old (just for safe keeping)
3. restart mysql, and follow the zoneminder installation instructions as follows:
cd <zm-install-dir>/db
mysql mysql < zmschema.sql

mysql mysql
grant select,insert,update,delete on <your database name>.* to '<your first username>'@localhost identified by '<your first password>';

grant select on <your database name>.* to '<your second username>'@localhost identified by '<your second password>'

quit
mysqladmin reload

4. Restart zoneminder and try again. Remember to remove the zm.old directory when you're happy with the new one.

Is there anything I've forgotten?
AngryButler
Posts: 9
Joined: Mon Jul 26, 2004 2:34 pm
Location: Grand Haven, Mi, USA

Post by AngryButler »



Thanks again. Davide, Here's the exact syntax I'm using to create the database and set the perms:


root@AngryButler:~/whoohoo/zm-1.19.4/db# mysql mysql < zmschema.sql -p
Enter password:
root@AngryButler:~/whoohoo/zm-1.19.4/db# mysql mysql
root@AngryButler:~/whoohoo/zm-1.19.4/db# mysql mysql -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 125 to server version: 4.0.20-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant select,insert,update,delete on zm.* to root@localhost identified by '<root password>';
Query OK, 0 rows affected (0.30 sec)

mysql> grant select on zm.* to tsuther@localhost identified by 'my password>';
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye
root@AngryButler:~/whoohoo/zm-1.19.4/db# mysqladmin reload -p
Enter password:
root@AngryButler:~/whoohoo/zm-1.19.4/db#

I did do as nugget suggested and removed the /var/lib/mysql/zm directory, then repeated the db creation process above.

I still get this kind of stuff when using the web-ui to change the database via the "options" dialog or view anything:


040726 8:45:24 Aborted connection 1 to db: 'zm' user: 'root' host: `localhost' (Got timeout reading communica tion packets)
040726 8:49:47 Aborted connection 32 to db: 'zm' user: 'root' host: `localhost' (Got timeout reading communic ation packets)

Here's the important bit of the zmconfig.txt file:

Name: ZM_DB_SERVER
Value: localhost
Description: Machine on which the database server is running

Name: ZM_DB_NAME
Value: zm
Description: Database containing the tables

Name: ZM_DB_USERA
Value: root
Description: Privileged DB user name, needs at least select, insert, update and delete privileges

Name: ZM_DB_PASSA
Value: <root password>
Description: Privileged DB user password

Name: ZM_DB_USERB
Value: tsuther
Description: Unprivileged DB user name, need just select privilege.

Name: ZM_DB_PASSB
Value: <my password>
Description: Unprivileged DB user password
User avatar
davide
Posts: 78
Joined: Mon Mar 22, 2004 1:04 am
Location: Italy

Post by davide »

Your configuration commands look corret, so I think it is a MySQL problem...

Are you shure mysql is working well? any other software using it?

I am not a mysql expert, so I can't help you much...

Try googling with "Got timeout reading communication packets" and see if you can find the source and the solution of your problem.

good luck.
User avatar
nugget
Posts: 42
Joined: Mon Dec 08, 2003 7:52 pm
Location: Sydney, Australia
Contact:

Post by nugget »

I'm at work atm, so can only offer limited support ... will have a better poke around when I get home.

Hmmm ... so far we've determined that your Mysql install is probably OK, but there's obviously a missing piece. The following error is interesting:

'zm' user: 'root' host: `localhost' (Got timeout reading communication packets)

1. what is 'localhost' in /etc/hosts? can you ping it?
2. what Mysql packages are installed? Have you installed server, client and the shared libraries?

Mysql works because we can log in and query the tables, so it looks like the mechanism that zoneminder uses to connect to the database isn't working very well - hence my questions above.

Don't give up yet ... we're getting closer!
AngryButler
Posts: 9
Joined: Mon Jul 26, 2004 2:34 pm
Location: Grand Haven, Mi, USA

Post by AngryButler »

localhost resolves to 127.0.0.1 as it should.

Is there a way to simulate the SQL queries/updates that ZM makes to mysql? That might be useful.

I have a snort database that appears to work properly. I'll do some googling later on...

Here are the mysql packages install (BTW, is there a better way to get this info?)


root@AngryButler:~/whoohoo/zm-1.19.4# apt-show-versions |grep mysql
libmysqlclient10/testing uptodate 3.23.56-2
php4-mysql/testing uptodate 4:4.3.4-4
libmysqlclient-dev/unstable uptodate 4.0.20-6
libdbd-mysql-perl/testing uptodate 2.9003-2
mysqlcc/testing uptodate 0.9.4-1
mysql-common/unstable uptodate 4.0.20-6
mysql-server/unstable upgradeable from 4.0.20-3 to 4.0.20-6
acidlab-mysql/testing uptodate 0.9.6b20-7
snort-mysql/testing uptodate 2.1.2-2
libmysqlclient12/unstable uptodate 4.0.20-6
mysql-client/unstable upgradeable from 4.0.20-3 to 4.0.20-6
root@AngryButler:~/whoohoo/zm-1.19.4#
User avatar
nugget
Posts: 42
Joined: Mon Dec 08, 2003 7:52 pm
Location: Sydney, Australia
Contact:

Post by nugget »

I agree with your last assumption - there's probably something about the way ZM connects to the database...

ZM uses the PERL DBI module to connect to the database ... if you're competent with PERL you might be able to cobble together a simple script to query one of the database tables - there's plenty of programming examples in the ZM perl scripts. Let me know how you get on, if you have no luck I'll have a go at putting together a simple script a little later on. Unless someone with better knowledge wants to jump in at this point?

PERL isn't one of my strong skills, and I'm still getting familiar with Mysql (my experience is commercial databases on larger machines).
AngryButler
Posts: 9
Joined: Mon Jul 26, 2004 2:34 pm
Location: Grand Haven, Mi, USA

More info...

Post by AngryButler »

There is such a thing as a mysql.log! Funny, I didn't think of that before.

It appears that the timing from mysqld output correspond to the timing of a particular query listed in /var/log/mysql/mysql.log. From the query it looks like it's trying to poll the monitor I have defined (which, remember, has never worked) I will try to manually make the indicated query and report back when I can. Thanks for the help (and moral support!)

BTW, I don't know *any* PERL.

See example below in boldface....


/var/log/mysql/mysql.log

040728 20:21:42 28 Connect root@localhost on zm
28 Query select * from Config
28 Quit
1 Query select count(Id) as ZoneCount from Zones where MonitorId = '1'
27 Query update Config set Value = '1.19.4' where Name = 'ZM_DYN_LAST_VERSION'
27 Query update Config set Value = '1091060501' where Name = 'ZM_DYN_LAST_CHECK'
29 Connect root@localhost on zm
040728 20:21:44 30 Connect root@localhost on
30 Init DB zm
30 Query select Id, Name, Function+0, Device, Channel, Format, Width, Height, Palette, Orientation+0, LabelFormat, LabelX, LabelY, ImageBufferCount, WarmupCount, PreEventCount, PostEventCount, SectionLength, FrameSkip, MaxFPS, FPSReportInterval, RefBlendPerc from Monitors where Function != 'None' and Type = 'Local' and Device = 0
30 Query select Name, Value, Type from Config order by Id

040728 20:21:48 29 Query select * from Filters where (AutoArchive = 1 or AutoDelete = 1 or AutoUpload = 1 or AutoEmail = 1 or AutoMessage = 1 or AutoExecute != '') order by Name
29 Query select * from Filters where (AutoArchive = 1 or AutoDelete = 1 or AutoUpload = 1 or AutoEmail = 1 or AutoMessage = 1 or AutoExecute != '') order by Name
040728 20:21:54 31 Connect root@localhost on
31 Init DB zm
31 Query select Id, Name, Function+0, Device, Channel, Format, Width, Height, Palette, Orientation+0, LabelFormat, LabelX, LabelY, ImageBufferCount, WarmupCount, PreEventCount, PostEventCount, SectionLength, FrameSkip, MaxFPS, FPSReportInterval, RefBlendPerc from Monitors where Function != 'None' and Type = 'Local' and Device = 0
31 Query select Name, Value, Type from Config order by Id
040728 20:22:10 32 Connect root@localhost on zm
32 Query select * from Monitors
040728 20:22:14 33 Connect root@localhost on
33 Init DB zm
33 Query select Id, Name, Function+0, Device, Channel, Format, Width, Height, Palette, Orientation+0, LabelFormat, LabelX, LabelY, ImageBufferCount, WarmupCount, PreEventCount, PostEventCount, SectionLength, FrameSkip, MaxFPS, FPSReportInterval, RefBlendPerc from Monitors where Function != 'None' and Type = 'Local' and Device = 0
33 Query select Name, Value, Type from Config order by Id
040728 20:22:20 32 Query select * from Monitors
040728 20:22:30 32 Query select * from Monitors
040728 20:22:40 32 Query select * from Monitors
040728 20:22:50 32 Query select * from Monitors
040728 20:22:54 34 Connect root@localhost on
34 Init DB zm
34 Query select Id, Name, Function+0, Device, Channel, Format, Width, Height, Palette, Orientation+0, LabelFormat, LabelX, LabelY, ImageBufferCount, WarmupCount, PreEventCount, PostEventCount, SectionLength, FrameSkip, MaxFPS, FPSReportInterval, RefBlendPerc from Monitors where Function != 'None' and Type = 'Local' and Device = 0
34 Query select Name, Value, Type from Config order by Id
040728 20:23:00 32 Query select * from Monitors


root@AngryButler:/var/log# mysqld
mysqld: ready for connections.
Version: '4.0.20-log' socket: '/var/run/mysqld/mysqld.sock' port: 0
040728 20:21:36 Aborted connection 11 to db: 'zm' user: 'root' host: `localhost' (Got an error reading communication packets)
040728 20:21:39 Aborted connection 14 to db: 'zm' user: 'root' host: `localhost' (Got an error reading communication packets)
040728 20:21:39 Aborted connection 15 to db: 'zm' user: 'root' host: `localhost' (Got an error reading communication packets)
040728 20:21:44 Aborted connection 30 to db: 'zm' user: 'root' host: `localhost' (Got an error reading communication packets)
040728 20:21:54 Aborted connection 31 to db: 'zm' user: 'root' host: `localhost' (Got an error reading communication packets)
040728 20:22:14 Aborted connection 33 to db: 'zm' user: 'root' host: `localhost' (Got an error reading communication packets)
040728 20:22:54 Aborted connection 34 to db: 'zm' user: 'root' host: `localhost' (Got an error reading communication packets)
AngryButler
Posts: 9
Joined: Mon Jul 26, 2004 2:34 pm
Location: Grand Haven, Mi, USA

Post by AngryButler »

BTW when I run the query above manually, it returns what appears to be one good record from zm.Monitors. No mysqld errors are generated, so things still point to at ZM issue of some type.

On another note, is there a way to *completely* wipe out the existing ZM install? I've already reinstalled a couple of times after deleting the binaries (the ones I could find...), the sources, and the zm database.
User avatar
nugget
Posts: 42
Joined: Mon Dec 08, 2003 7:52 pm
Location: Sydney, Australia
Contact:

More info!

Post by nugget »

I found a reference via Google to the Mysql mailing lists http://lists.mysql.com/, which I hadn't looked at yet. Looks like good info.

Anyway, the first reference I found was the following link
http://lists.mysql.com/mysql/168652
Add

skip-log-warnings

in your my.cnf. log-warnings seems to have been enabled by default since
4.0.19.
The note indicates that the above is a config change which was introduced with Mysql 4.20 (which I think you are running). See if this helps.

Otherwise, if you're about to boldly reinstall Zoneminder perhaps you could consider installing Mysql v3.23 instead of 4.x? My latest upgrade adventure cost me a couple of weeks of pain I never solved, mainly due to installing MySQL v 4.20. I gave in, and reinstalled EVERYTHING (RedHat, PERL, Apache, PHP, MySQL 3.23, ...) and got a working Zoneminder.

Have a play with the above config file, maybe a poke around on lists.mysql.com. The important question you probably need to ask is how much pain is involved with reinstallation, compared to moving forward with the current installation?
User avatar
nugget
Posts: 42
Joined: Mon Dec 08, 2003 7:52 pm
Location: Sydney, Australia
Contact:

Post by nugget »

I think I've figured it out, doesn't quite work for my Mysql 3.23 install...

1. Edit your my.cnf file (probably /etc/my.cnf). For the [mysqld] section add the following line:
skip-log-warnings

2. stop Zoneminder and mysql, then restart mysql.
Have a look in /var/log/mysqld.log, and check for any recent errors. If none, then:

3. restart Zoneminder and try again.

I tried the above for my install, but I got an error "unrecognised option --log-warnings", so obviously this is something introduced with v4.x
AngryButler
Posts: 9
Joined: Mon Jul 26, 2004 2:34 pm
Location: Grand Haven, Mi, USA

Post by AngryButler »

OK, here's what I did...

1) I did an apt-get -t testing mysql-server to upgrade to the testing version. Same Problem.

2) I did an apt-get remove mysql-server, then a apt-get -t stable mysql-server resulting in the installation of a 3.xxx version. This rendered the my.cnf file incompatible, and caused goofy permissions problems.

3) Then I did apt-get upgrade mysql-server to get it to the unstable version 4.0.18(?) and the error messages went "away."

Go figure.

Of course now I have an entirely different problem. I'll post here as I'm not sure if I should start a new Topic...



When I run "zmc --device 0" I get this in the syslog:

Jul 29 17:24:38 AngryButler zmc-d0[6498]: INF [Debug Level = 0, De bug Log = ]
Jul 29 17:24:38 AngryButler kernel: pwc set_video_mode(640x480 @ 1 0, palette 15).
Jul 29 17:24:38 AngryButler kernel: pwc decode_size = 5.
Jul 29 17:24:38 AngryButler zmc-d0[6498]: ERR [Failed to set pictu re attributes: Invalid argument]

Here's more info:

root@AngryButler:/tmp# zmu -d 0 -q -v
Video Capabilities
Name: Logitech QuickCam Pro 4000
Type: 1
Can capture
Video Channels: 1
Audio Channels: 1
Maximum Width: 640
Maximum Height: 480
Minimum Width: 160
Minimum Height: 120
Window Attributes
X Offset: 0
Y Offset: 0
Width: 640
Height: 480
Picture Atributes
Palette: 15 - YUV 4:2:0 Planar
Colour Depth: 24
Brightness: 32256
Hue: 65535
Colour :32768
Contrast: 64512
Whiteness: 65535
Channel 0 Attributes
Name: Webcam
Channel: 0
Flags: 0
Type: 2 - Camera
Format: 49151 - Unknown

root@AngryButler:/tmp# xawtv
This is xawtv-3.93, running on Linux/i686 (2.6.7)
Cannot open plugin directory ${exec_prefix}/lib/libquicktime
Did you forget "make install"? You need it because
libquicktime cannot load plugins out of the sourcetree
/dev/video0 [v4l]: no overlay support
v4l-conf had some trouble, trying to continue anyway
config: invalid value for input: Television
valid choices for "input": "Webcam"
ioctl: VIDIOCMCAPTURE(frame=0;height=120;width=160;format=7): Invalid argument
ioctl: VIDIOCMCAPTURE(frame=0;height=120;width=160;format=3): Invalid argument
ioctl: VIDIOCMCAPTURE(frame=0;height=120;width=160;format=4): Invalid argument
ioctl: VIDIOCMCAPTURE(frame=0;height=120;width=160;format=5): Invalid argument
ioctl: VIDIOCMCAPTURE(frame=0;height=120;width=160;format=1): Invalid argument
ioctl: VIDIOCMCAPTURE(frame=0;height=120;width=160;format=13): Invalid argument

xawtv *does* produce a picture.
Locked