ZM 1.24.2 Package install: DBI conn failed: Unknown database

Forum for questions and support relating to the 1.24.x releases only.
Locked
Nadrek
Posts: 6
Joined: Wed Mar 10, 2010 3:27 am

ZM 1.24.2 Package install: DBI conn failed: Unknown database

Post by Nadrek »

Summary: I had a functional Zoneminder 1.24.1 install on Ubuntu 9.04 Jaunty 64-bit, and uninstalled it to try and install 1.24.2 for easier installation of a Logitech C250 USB camera. I have not since been able to install Zoneminder 1.24.2, either 1.24.2-1 from the Bluecherry repository or 1.24.2-2 from the Debian unstable (sid) repository.

Preferred Goal: To be able to install Zoneminder by dpkg, apt-get, aptitude, or some other way not involving compiling directly from the source code, as I'd like to be able to take advantage of package-based updates in the future. I'd like to have H.264 input stream support, the ability to use UVC webcams, and the ability to use Axis IP camera later in various modes.

In all cases, I always end up with the error:

Code: Select all

DBI connect('database=zm;host=localhost','zmuser',...) failed: Unknown database 'zm' at /usr/share/perl5/ZoneMinder/Config.pm line 89
Can't call method "prepare_cached" on an undefined value at /usr/share/perl5/ZoneMinder/Config.pm line 91.
BEGIN failed--compilation aborted at /usr/share/perl5/ZoneMinder/Config.pm line 100.
System details:

Code: Select all

Linux LH 2.6.28-18-generic #59-Ubuntu SMP Thu Jan 28 01:40:19 UTC 2010 x86_64 GNU/Linux
Ubuntu Jaunty 9.04 64-bit (upgraded in place via the package manager from 8.10 long ago)
MSI K9AGM-FID motherboard, Athlon X2 CPU, 4GB of DDR2 RAM.
Previous install: Zoneminder 1.24.1 from the normal Jaunty repository, which worked (ZM captured and did successful motion detection on a DIV3 stream from a nearby Windows machine running VLC and a USB Logitech Quickcam Communicate STX).

Steps I took to remove Zoneminder before each trial:

Code: Select all

sudo apt-get remove zoneminder
sudo apt-get remove mysql*
sudo apt-get autoremove
When trying to install from Bluecherry, the above removal resulted in my getting the Mysql "choose a root mysql password" prompt every time. Whether I chose a blank or a complex, random password made no difference to the final result. When trying to install from Debian unstable, this did not result in the mysql root password prompt.

The installation results from the repository:
deb http://zoneminder.bluecherry.net jaunty main

Code: Select all

Install zoneminder:
sudo apt-get install zoneminder

Now I get the mysql pick a root password prompt.  Results are identical for no password and a complex password.

Extracting templates from packages: 100%
Preconfiguring packages ...
Selecting previously deselected package mysql-common.
(Reading database ... 223049 files and directories currently installed.)
Unpacking mysql-common (from .../mysql-common_5.1.30really5.0.75-0ubuntu10.3_all.deb) ...
Selecting previously deselected package libnet-daemon-perl.
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.43-1_all.deb) ...
Selecting previously deselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2020-1_all.deb) ...
Selecting previously deselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.607-1_amd64.deb) ...
Selecting previously deselected package libmysqlclient15off.
Unpacking libmysqlclient15off (from .../libmysqlclient15off_5.1.30really5.0.75-0ubuntu10.3_amd64.deb) ...
Selecting previously deselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.008-1_amd64.deb) ...
Selecting previously deselected package mysql-client-5.0.
Unpacking mysql-client-5.0 (from .../mysql-client-5.0_5.1.30really5.0.75-0ubuntu10.3_amd64.deb) ...
Selecting previously deselected package mysql-server-core-5.0.
Unpacking mysql-server-core-5.0 (from .../mysql-server-core-5.0_5.1.30really5.0.75-0ubuntu10.3_amd64.deb) ...
Processing triggers for man-db ...
Setting up mysql-common (5.1.30really5.0.75-0ubuntu10.3) ...
Selecting previously deselected package mysql-server-5.0.
(Reading database ... 223401 files and directories currently installed.)
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.1.30really5.0.75-0ubuntu10.3_amd64.deb) ...
 * Stopping MySQL database server mysqld                                    [ OK ] 
Selecting previously deselected package libapr1.
Unpacking libapr1 (from .../libapr1_1.2.12-5ubuntu0.1_amd64.deb) ...
Selecting previously deselected package libpq5.
Unpacking libpq5 (from .../libpq5_8.3.9-0ubuntu9.04_amd64.deb) ...
Selecting previously deselected package libaprutil1.
Unpacking libaprutil1 (from .../libaprutil1_1.2.12+dfsg-8ubuntu0.3_amd64.deb) ...
Selecting previously deselected package apache2-utils.
Unpacking apache2-utils (from .../apache2-utils_2.2.11-2ubuntu2.6_amd64.deb) ...
Selecting previously deselected package apache2.2-common.
Unpacking apache2.2-common (from .../apache2.2-common_2.2.11-2ubuntu2.6_amd64.deb) ...
Selecting previously deselected package apache2-mpm-prefork.
Unpacking apache2-mpm-prefork (from .../apache2-mpm-prefork_2.2.11-2ubuntu2.6_amd64.deb) ...
Selecting previously deselected package apache2.
Unpacking apache2 (from .../apache2_2.2.11-2ubuntu2.6_all.deb) ...
Selecting previously deselected package php5-common.
Unpacking php5-common (from .../php5-common_5.2.6.dfsg.1-3ubuntu4.5_amd64.deb) ...
Selecting previously deselected package libapache2-mod-php5.
Unpacking libapache2-mod-php5 (from .../libapache2-mod-php5_5.2.6.dfsg.1-3ubuntu4.5_amd64.deb) ...
Selecting previously deselected package libarchive-zip-perl.
Unpacking libarchive-zip-perl (from .../libarchive-zip-perl_1.18-1_all.deb) ...
Selecting previously deselected package libconvert-binhex-perl.
Unpacking libconvert-binhex-perl (from .../libconvert-binhex-perl_1.119+pristine-3_all.deb) ...
Selecting previously deselected package libdate-manip-perl.
Unpacking libdate-manip-perl (from .../libdate-manip-perl_5.54-1_all.deb) ...
Selecting previously deselected package libemail-date-format-perl.
Unpacking libemail-date-format-perl (from .../libemail-date-format-perl_1.002-1_all.deb) ...
Selecting previously deselected package libio-stringy-perl.
Unpacking libio-stringy-perl (from .../libio-stringy-perl_2.110-4_all.deb) ...
Selecting previously deselected package libmime-lite-perl.
Unpacking libmime-lite-perl (from .../libmime-lite-perl_3.023-1_all.deb) ...
Selecting previously deselected package libmime-tools-perl.
Unpacking libmime-tools-perl (from .../libmime-tools-perl_5.427-2_all.deb) ...
Selecting previously deselected package libmime-perl.
Unpacking libmime-perl (from .../libmime-perl_5.427-2_all.deb) ...
Selecting previously deselected package libmime-types-perl.
Unpacking libmime-types-perl (from .../libmime-types-perl_1.26-1_all.deb) ...
Selecting previously deselected package libphp-serialization-perl.
Unpacking libphp-serialization-perl (from .../libphp-serialization-perl_0.29-1_all.deb) ...
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.1.30really5.0.75-0ubuntu10.3_all.deb) ...
 * Stopping MySQL database server mysqld                                    [ OK ] 
Selecting previously deselected package php5.
Unpacking php5 (from .../php5_5.2.6.dfsg.1-3ubuntu4.5_all.deb) ...
Selecting previously deselected package php5-mysql.
Unpacking php5-mysql (from .../php5-mysql_5.2.6.dfsg.1-3ubuntu4.5_amd64.deb) ...
Selecting previously deselected package libdevice-serialport-perl.
Unpacking libdevice-serialport-perl (from .../libdevice-serialport-perl_1.04-2_amd64.deb) ...
Selecting previously deselected package zoneminder.
Unpacking zoneminder (from .../zoneminder_1.24.2-1_amd64.deb) ...
Selecting previously deselected package nullmailer.
Unpacking nullmailer (from .../nullmailer_1%3a1.04-1.1_amd64.deb) ...
Processing triggers for man-db ...
Processing triggers for ufw ...
Processing triggers for doc-base ...
Processing 1 added doc-base file(s)...
Registering documents with scrollkeeper...
Setting up libnet-daemon-perl (0.43-1) ...
Setting up libplrpc-perl (0.2020-1) ...
Setting up libdbi-perl (1.607-1) ...
Setting up libmysqlclient15off (5.1.30really5.0.75-0ubuntu10.3) ...

Setting up libdbd-mysql-perl (4.008-1) ...
Setting up mysql-client-5.0 (5.1.30really5.0.75-0ubuntu10.3) ...
Setting up mysql-server-core-5.0 (5.1.30really5.0.75-0ubuntu10.3) ...
Setting up mysql-server-5.0 (5.1.30really5.0.75-0ubuntu10.3) ...
 * Stopping MySQL database server mysqld                                    [ OK ] 
 * Reloading AppArmor profiles ...                                          [ OK ] 
 * Starting MySQL database server mysqld                                    [ OK ] 
 * Checking for corrupt, not cleanly closed and upgrade needing tables.

Setting up libapr1 (1.2.12-5ubuntu0.1) ...

Setting up libpq5 (8.3.9-0ubuntu9.04) ...

Setting up libaprutil1 (1.2.12+dfsg-8ubuntu0.3) ...

Setting up apache2-utils (2.2.11-2ubuntu2.6) ...
Setting up apache2.2-common (2.2.11-2ubuntu2.6) ...

Setting up apache2-mpm-prefork (2.2.11-2ubuntu2.6) ...
 * Starting web server apache2                                                     Syntax error on line 4 of /etc/apache2/conf.d/zoneminder.conf:
Invalid command 'php_flag', perhaps misspelled or defined by a module not included in the server configuration
                                                                            [fail]
invoke-rc.d: initscript apache2, action "start" failed.

Setting up apache2 (2.2.11-2ubuntu2.6) ...
Setting up php5-common (5.2.6.dfsg.1-3ubuntu4.5) ...
Setting up libapache2-mod-php5 (5.2.6.dfsg.1-3ubuntu4.5) ...
 * Reloading web server config apache2                                             
Setting up libarchive-zip-perl (1.18-1) ...
Setting up libconvert-binhex-perl (1.119+pristine-3) ...
Setting up libdate-manip-perl (5.54-1) ...
Setting up libemail-date-format-perl (1.002-1) ...
Setting up libio-stringy-perl (2.110-4) ...

Setting up libmime-lite-perl (3.023-1) ...
Setting up libmime-tools-perl (5.427-2) ...
Setting up libmime-perl (5.427-2) ...
Setting up libmime-types-perl (1.26-1) ...
Setting up libphp-serialization-perl (0.29-1) ...
Setting up mysql-server (5.1.30really5.0.75-0ubuntu10.3) ...
Setting up php5 (5.2.6.dfsg.1-3ubuntu4.5) ...
Setting up php5-mysql (5.2.6.dfsg.1-3ubuntu4.5) ...

Setting up libdevice-serialport-perl (1.04-2) ...
Setting up zoneminder (1.24.2-1) ...
DBI connect('database=zm;host=localhost','zmuser',...) failed: Unknown database 'zm' at /usr/share/perl/5.10/ZoneMinder/Config.pm line 89
Can't call method "prepare_cached" on an undefined value at /usr/share/perl/5.10/ZoneMinder/Config.pm line 91.
BEGIN failed--compilation aborted at /usr/share/perl/5.10/ZoneMinder/Config.pm line 100.
Compilation failed in require at /usr/bin/zmupdate.pl line 50.
BEGIN failed--compilation aborted at /usr/bin/zmupdate.pl line 50.
dpkg: error processing zoneminder (--configure):
 subprocess post-installation script returned error exit status 255
Setting up nullmailer (1:1.04-1.1) ...
 * Starting mail-transfer-agent:                                            [ OK ] 

Processing triggers for libc6 ...
ldconfig deferred processing now taking place
Errors were encountered while processing:
 zoneminder
E: Sub-process /usr/bin/dpkg returned an error code (1)

The installation results from
deb http://http.us.debian.org/debian unstable main contrib non-free
(whether or not I comment out the bluecherry repository)

Code: Select all

sudo apt-get install zoneminder



Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  libarchive-zip-perl libconvert-binhex-perl libdate-manip-perl
  libdbd-mysql-perl libdbi-perl libdevice-serialport-perl
  libemail-date-format-perl libio-stringy-perl libmime-lite-perl libmime-perl
  libmime-tools-perl libmime-types-perl libmysqlclient16 libnet-daemon-perl
  libphp-serialization-perl libplrpc-perl mysql-client-5.1 mysql-common
  mysql-server mysql-server-5.1 php5 php5-mysql
Suggested packages:
  dbishell tinyca
The following NEW packages will be installed:
  libarchive-zip-perl libconvert-binhex-perl libdate-manip-perl
  libdbd-mysql-perl libdbi-perl libdevice-serialport-perl
  libemail-date-format-perl libio-stringy-perl libmime-lite-perl libmime-perl
  libmime-tools-perl libmime-types-perl libmysqlclient16 libnet-daemon-perl
  libphp-serialization-perl libplrpc-perl mysql-client-5.1 mysql-common
  mysql-server mysql-server-5.1 php5 php5-mysql zoneminder
0 upgraded, 23 newly installed, 0 to remove and 1074 not upgraded.
Need to get 28.5MB of archives.
After this operation, 84.2MB of additional disk space will be used.
Do you want to continue [Y/n]? Y
WARNING: The following packages cannot be authenticated!
  mysql-common libplrpc-perl libdbi-perl libmysqlclient16 libdbd-mysql-perl
  mysql-client-5.1 mysql-server-5.1 libarchive-zip-perl libdate-manip-perl
  libmime-lite-perl libmime-types-perl libphp-serialization-perl mysql-server
  php5 php5-mysql libdevice-serialport-perl zoneminder
Install these packages without verification [y/N]? 
Get:1 http://http.us.debian.org unstable/main mysql-common 5.1.44-3 [75.1kB]
Get:2 http://us.archive.ubuntu.com jaunty/main libnet-daemon-perl 0.43-1 [46.9kB]
Get:3 http://http.us.debian.org unstable/main libplrpc-perl 0.2020-2 [36.0kB]
Get:4 http://http.us.debian.org unstable/main libdbi-perl 1.609-1 [800kB]
Get:5 http://us.archive.ubuntu.com jaunty/main libconvert-binhex-perl 1.119+pristine-3 [30.9kB]
Get:6 http://us.archive.ubuntu.com jaunty/universe libemail-date-format-perl 1.002-1 [6354B]
Get:7 http://us.archive.ubuntu.com jaunty/main libio-stringy-perl 2.110-4 [94.7kB]
Get:8 http://http.us.debian.org unstable/main libmysqlclient16 5.1.44-3 [1982kB]
Get:9 http://us.archive.ubuntu.com jaunty/main libmime-tools-perl 5.427-2 [238kB]
Get:10 http://http.us.debian.org unstable/main libdbd-mysql-perl 4.013-1 [137kB]
Get:11 http://http.us.debian.org unstable/main mysql-client-5.1 5.1.44-3 [8723kB]
Get:12 http://us.archive.ubuntu.com jaunty/universe libmime-perl 5.427-2 [21.0kB]
Get:13 http://http.us.debian.org unstable/main mysql-server-5.1 5.1.44-3 [11.9MB]
Get:14 http://http.us.debian.org unstable/main libarchive-zip-perl 1.30-2 [94.9kB]
Get:15 http://http.us.debian.org unstable/main libdate-manip-perl 6.07-1 [2345kB]
Get:16 http://http.us.debian.org unstable/main libmime-lite-perl 3.027-1 [76.3kB]
Get:17 http://http.us.debian.org unstable/main libmime-types-perl 1.28-1 [31.2kB]
Get:18 http://http.us.debian.org unstable/main libphp-serialization-perl 0.33-1 [10.8kB]
Get:19 http://http.us.debian.org unstable/main mysql-server 5.1.44-3 [69.5kB]  
Get:20 http://http.us.debian.org unstable/main php5 5.3.1-5 [1070B]            
Get:21 http://http.us.debian.org unstable/main php5-mysql 5.3.1-5 [72.9kB]     
Get:22 http://http.us.debian.org unstable/main libdevice-serialport-perl 1.04-2+b1 [79.1kB]
Get:23 http://http.us.debian.org unstable/main zoneminder 1.24.2-2+b1 [1604kB] 
Fetched 28.5MB in 60s (469kB/s)                                                
Preconfiguring packages ...
Selecting previously deselected package mysql-common.
(Reading database ... 223796 files and directories currently installed.)
Unpacking mysql-common (from .../mysql-common_5.1.44-3_all.deb) ...
Selecting previously deselected package libnet-daemon-perl.
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.43-1_all.deb) ...
Selecting previously deselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2020-2_all.deb) ...
Selecting previously deselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.609-1_amd64.deb) ...
Selecting previously deselected package libmysqlclient16.
Unpacking libmysqlclient16 (from .../libmysqlclient16_5.1.44-3_amd64.deb) ...
Selecting previously deselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.013-1_amd64.deb) ...
Selecting previously deselected package mysql-client-5.1.
Unpacking mysql-client-5.1 (from .../mysql-client-5.1_5.1.44-3_amd64.deb) ...
Processing triggers for man-db ...
Setting up mysql-common (5.1.44-3) ...
Selecting previously deselected package mysql-server-5.1.
(Reading database ... 224069 files and directories currently installed.)
Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.44-3_amd64.deb) ...
Selecting previously deselected package libarchive-zip-perl.
Unpacking libarchive-zip-perl (from .../libarchive-zip-perl_1.30-2_all.deb) ...
Selecting previously deselected package libconvert-binhex-perl.
Unpacking libconvert-binhex-perl (from .../libconvert-binhex-perl_1.119+pristine-3_all.deb) ...
Selecting previously deselected package libdate-manip-perl.
Unpacking libdate-manip-perl (from .../libdate-manip-perl_6.07-1_all.deb) ...
Selecting previously deselected package libemail-date-format-perl.
Unpacking libemail-date-format-perl (from .../libemail-date-format-perl_1.002-1_all.deb) ...
Selecting previously deselected package libio-stringy-perl.
Unpacking libio-stringy-perl (from .../libio-stringy-perl_2.110-4_all.deb) ...
Selecting previously deselected package libmime-lite-perl.
Unpacking libmime-lite-perl (from .../libmime-lite-perl_3.027-1_all.deb) ...
Selecting previously deselected package libmime-tools-perl.
Unpacking libmime-tools-perl (from .../libmime-tools-perl_5.427-2_all.deb) ...
Selecting previously deselected package libmime-perl.
Unpacking libmime-perl (from .../libmime-perl_5.427-2_all.deb) ...
Selecting previously deselected package libmime-types-perl.
Unpacking libmime-types-perl (from .../libmime-types-perl_1.28-1_all.deb) ...
Selecting previously deselected package libphp-serialization-perl.
Unpacking libphp-serialization-perl (from .../libphp-serialization-perl_0.33-1_all.deb) ...
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.1.44-3_all.deb) ...
Selecting previously deselected package php5.
Unpacking php5 (from .../archives/php5_5.3.1-5_all.deb) ...
Selecting previously deselected package php5-mysql.
Unpacking php5-mysql (from .../php5-mysql_5.3.1-5_amd64.deb) ...
Selecting previously deselected package libdevice-serialport-perl.
Unpacking libdevice-serialport-perl (from .../libdevice-serialport-perl_1.04-2+b1_amd64.deb) ...
Selecting previously deselected package zoneminder.
Unpacking zoneminder (from .../zoneminder_1.24.2-2+b1_amd64.deb) ...
Processing triggers for man-db ...
Processing triggers for doc-base ...
Processing 1 added doc-base file(s)...
Registering documents with scrollkeeper...
Processing triggers for libapache2-mod-php5 ...
 * Reloading web server config apache2                                          Setting up libnet-daemon-perl (0.43-1) ...
Setting up libplrpc-perl (0.2020-2) ...
Setting up libdbi-perl (1.609-1) ...
Setting up libmysqlclient16 (5.1.44-3) ...

Setting up libdbd-mysql-perl (4.013-1) ...
Setting up mysql-client-5.1 (5.1.44-3) ...
Setting up mysql-server-5.1 (5.1.44-3) ...
 * Stopping MySQL database server mysqld                                 [ OK ] 
 * Starting MySQL database server mysqld                                 [ OK ] 
 * Checking for corrupt, not cleanly closed and upgrade needing tables.

Setting up libarchive-zip-perl (1.30-2) ...
Setting up libconvert-binhex-perl (1.119+pristine-3) ...
Setting up libdate-manip-perl (6.07-1) ...
Setting up libemail-date-format-perl (1.002-1) ...
Setting up libio-stringy-perl (2.110-4) ...

Setting up libmime-lite-perl (3.027-1) ...
Setting up libmime-tools-perl (5.427-2) ...
Setting up libmime-perl (5.427-2) ...
Setting up libmime-types-perl (1.28-1) ...
Setting up libphp-serialization-perl (0.33-1) ...
Setting up mysql-server (5.1.44-3) ...
Setting up php5 (5.3.1-5) ...
Setting up php5-mysql (5.3.1-5) ...
Setting up libdevice-serialport-perl (1.04-2+b1) ...
Setting up zoneminder (1.24.2-2+b1) ...
DBI connect('database=zm;host=localhost','zmuser',...) failed: Unknown database 'zm' at /usr/share/perl5/ZoneMinder/Config.pm line 89
Can't call method "prepare_cached" on an undefined value at /usr/share/perl5/ZoneMinder/Config.pm line 91.
BEGIN failed--compilation aborted at /usr/share/perl5/ZoneMinder/Config.pm line 100.
Compilation failed in require at /usr/bin/zmupdate.pl line 50.
BEGIN failed--compilation aborted at /usr/bin/zmupdate.pl line 50.
dpkg: error processing zoneminder (--configure):
 subprocess post-installation script returned error exit status 255
Processing triggers for libc6 ...
ldconfig deferred processing now taking place
Errors were encountered while processing:
 zoneminder
E: Sub-process /usr/bin/dpkg returned an error code (1)
I have already changed /etc/hosts 127.0.0.1 entry to have the same name as /etc/hostname. I was unable to find any copy of rc.conf on my machine per a prior post regarding name changes.

What other information can I provide that would help in diagnosis?

Thank you,
Nadrek



What other information can I provide that would be helpful?
Top
Locked

Return to “ZoneMinder 1.24.x”