malformed.org does the blog thing

The docs for zoneminder are pretty good, but I have a couple issues when I’m getting it going and I may as well put it here for the next time I have to deal with it.

My current config line:

./configure --with-webdir=/var/www/zm.malformed.org/ --with-cgidir=/var/www/zm.malformed.org/cgi-bin/ --with-mysql=/usr/ --with-webuser=www-data --with-webgroup=www-data --with-ffmpeg=/usr/local/ --with-lame=/usr/

In Zoneminder 1.21.4 the schema doesn’t seem to be correct for at least mysql 4.0.24. I don’t really care enough to figure out if it’s 4.1 or 5.0 (ack!) only.

The first error in the schema results in:
ERROR 1136 at line 378: Column count doesn't match value count at row 1
This is resolved by changing line 378 from:

insert into Users values ('','admin',password('admin'),'',1,'View','Edit','Edit','Edit',NULL);
to
insert into Users values ('','admin',password('admin'),'',1,'View','Edit','Edit','Edit','Edit','High',NULL);

Next error is:
ERROR 1048 at line 378: Column 'MonitorIds' cannot be null
This is resolved by changing line 378 from:
MonitorIds tinytext NOT NULL,
to
MonitorIds tinytext default NULL,

This is all discussed, with a patch, on the zoneminder forums.

I also have the following in /etc/sysctl.conf:

kernel.shmmax=157286400
kernel.shmall=157286400

Other than that I can basically follow the docs and have it turn out OK.