ZM 1.26.3 Ubuntu server

[Speranza]

Hi!
I have a problems, that I cant figured out.
So, I have Ubuntu 12.04.3 Server installed. I'm trying to install ZM 1.26.3 from launchpad (ppa:iconnor/zoneminder) or compile it from source- the result is similar:
when I do

Code: Select all

sudo apt-get install zoneminder

I've got

Code: Select all

Starting ZoneMinder: DBI connect('database=zm;host=localhost','zmuser',...) failed: Unknown database 'zm' at /usr/share/perl/5.14.2/ZoneMinder/Config.pm line 89
...
...(a lot of text in Russian)
...
E: Sub-process /usr/bin/dpkg returned an error code (1)

OK, I created database manually with

Code: Select all

mysql -uroot -p
mysql>create database zm;
mysql>grant all privileges on zm.* to 'zmuser'@'localhost' identified by "zmpass";
mysql>\q

but now I've got another database error:

Code: Select all

Can't execute: Table 'zm.Config' doesn't exist at /usr/share/perl/5.14.2/ZoneMinder/Config.pm line 100
BEGIN failed--compilation aborted at /usr/share/perl/5.14.2/ZoneMinder/Config.pm line 100.
Compilation failed in require at /usr/share/perl/5.14.2/ZoneMinder.pm line 33.
BEGIN failed--compilation aborted at /usr/share/perl/5.14.2/ZoneMinder.pm line 33.
Compilation failed in require at /usr/bin/zmpkg.pl line 37.
BEGIN failed--compilation aborted at /usr/bin/zmpkg.pl line 37.
failure

invoke-rc.d: initscript zoneminder, action "start" failed.
dpkg: не удалось обработать параметр zoneminder (--configure):
 подпроцесс установлен сценарий post-installation возвратил код ошибки 255
При обработке следующих пакетов произошли ошибки:
 zoneminder
E: Sub-process /usr/bin/dpkg returned an error code (1)

If I compile ZM from source, I've got similar errors but I see it in the web interface
1) there'is no database zm
2) there'is no table "Config" in the database zm

P.S. If I try to install 1.25 from ubuntu repos, I've got an error that Mysql is not running although it actually is.

So I haven't ideas what to do next. Please help! Sorry for my English

[parky]

Give the Puppet install a go on a new install of 12.04. I used that method the other week and it worked well almost as easy as the 1.25 package from the repositories.

I must say the new version runs a lot better allowing me to increase the frame rates on my continuously recording 8 camera system.

Thanks guys, for carrying on with the development of this excellent app

[Speranza]

Oh, no. Is there any other solution? Without reinstalling system?

[jheizer]

I had the same thing happen on a fresh install and when trying to update an existing install it is looking for the update script at the wrong path.

[knight-of-ni]

Looks like you created an empty database, but I don't see where you loaded the new dB schema into mysql.
Might want to refer to the WiKi docs for setting up the database.

[Speranza]

Looks like you created an empty database, but I don't see where you loaded the new dB schema into mysql.
Might want to refer to the WiKi docs for setting up the database.

Right! But I can't find any indtructions about database inicialisation! Could you please help me with link?

[knight-of-ni]

http://www.zoneminder.com/wiki/index.ph ... rom_Source

This is the step you are missing:

Code: Select all

mysql -uroot -p zm < path/to/zm_create.sql

[Speranza]

http://www.zoneminder.com/wiki/index.ph ... rom_Source

This is the step you are missing:

Code: Select all

mysql -uroot -p zm < path/to/zm_create.sql

Great!!!
Many many many thank you, Dude!!