always pb with zminit

[MK]

Linux localhost.localdomain 2.6.9-1.667 #1 Tue Nov 2 14:41:25 EST 2004 i686 athlon i386 GNU/Linux on a fedora core3

I show you what i did to install zm with yum:
- rpm --import /usr/share/rhn/RPM-GPG-KEY
- rpm --import /usr/share/rhn/RPM-GPG-KEY-fedora
- rpm --import http://atrpms.net/RPM-GPG-KEY.atrpms
- rpm --import ftp://download.computerntelecom.com/pub/RPM-GPG-KEY-CTU
then:
- yum -c http://www.computerntelecom.com/download/zm-fc3.repo install zm


after that:
Dependencies Resolved
Transaction Listing:
Install: zm.i386 0:1.21.3-1.0_FC3.root
Performing the following to resolve dependencies:
Install: a52dec.i386 0:0.7.4-6.rhfc3.at
Install: faad2.i386 0:2.0-2.rhfc3.at
Install: ffmpeg.i386 0:0.4.8-4.rhfc3.at
Install: imlib2.i386 0:1.1.2-3.rhfc3.at
Install: lame.i386 0:3.96.1-10.rhfc3.at
Install: liba52_0.i386 0:0.7.4-6.rhfc3.at
Install: perl-Device-SerialPort.i386 0:1.002-1
Install: perl-IO-stringy.noarch 0:2.109-FC3
Install: perl-MIME-tools.noarch 0:6.200_02-1.FC3
Install: perl-MailTools.noarch 0:1.66-1
Install: perl-Unicode-Map.i386 0:0.112-1
Install: perl-Unicode-String.i386 0:2.07-1
Is this ok [y/N]: y
Downloading Packages:
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing: perl-Unicode-Map 100 % done 1/13
Installing: perl-Unicode-String 100 % done 2/13
Installing: perl-IO-stringy 100 % done 3/13
Installing: perl-MailTools 100 % done 4/13
Installing: lame 100 % done 5/13
Installing: perl-MIME-tools 100 % done 6/13
Installing: liba52_0 100 % done 7/13
Installing: a52dec 100 % done 8/13
Installing: imlib2 100 % done 9/13
Installing: faad2 100 % done 10/13
Installing: ffmpeg 100 % done 11/13
Installing: perl-Device-SerialPort 100 % done 12/13
Installing: zm 100 % done 13/13

Installed: zm.i386 0:1.21.3-1.0_FC3.root
Dependency Installed: a52dec.i386 0:0.7.4-6.rhfc3.at faad2.i386 0:2.0-2.rhfc3.at ffmpeg.i386 0:0.4.8-4.rhfc3.at imlib2.i386 0:1.1.2-3.rhfc3.at lame.i386 0:3.96.1-10.rhfc3.at liba52_0.i386 0:0.7.4-6.rhfc3.at perl-Device-SerialPort.i386 0:1.002-1 perl-IO-stringy.noarch 0:2.109-FC3 perl-MIME-tools.noarch 0:6.200_02-1.FC3 perl-MailTools.noarch 0:1.66-1 perl-Unicode-Map.i386 0:0.112-1 perl-Unicode-String.i386 0:2.07-1
Complete!
Laughing



- root@localhost vital]# /sbin/service mysqld stop
Arrêt de MySQL : [ OK ]
[root@localhost vital]# /sbin/service httpd stop
Arrêt de httpd : [ OK ]
[root@localhost vital]# /sbin/service mysqld start
Démarrage de MySQL : [ OK ]
[root@localhost vital]# /sbin/service httpd start
Démarrage de httpd : [ OK ]


- [root@localhost vital]# /usr/lib/zm/bin/zminit
ERROR(/etc/zm.conf): ZM_DB_USER should exist and be not empty.

- vi /etc/zm.conf
# ZoneMinder config
ZM_DB_SERVER=localhost
ZM_DB_NAME=zm
ZM_DB_USER=toto
ZM_DB_PASS=XXXXX


- [root@localhost vital]# /usr/lib/zm/bin/zminit
Enter MySQL Administrator username: vital
Enter password:
ERROR 1045: Access denied for user: 'vital@localhost' (Using password: YES)
ERROR 1045: Access denied for user: 'vital@localhost' (Using password: YES)
Loading config from '/usr/lib/zm/init/zmconfig.txt'
Loading config from '/etc/zm.conf'
Loading config from DB
DBI connect('database=zm;host=localhost','vital',...) failed: Access denied for user: 'vital@localhost' (Using password: YES) at /usr/lib/zm/init/zmoptions line 1524
Error: unable to load options from database: Access denied for user: 'vital@localhost' (Using password: YES)
Saving config to DB
DBI connect('database=zm;host=localhost','vital',...) failed: Access denied for user: 'vital@localhost' (Using password: YES) at /usr/lib/zm/init/zmoptions line 1434
Error: unable to save options to database: Access denied for user: 'vital@localhost' (Using password: YES)

- [root@localhost vital]# /usr/lib/zm/bin/zminit
Enter MySQL Administrator username: root
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
ERROR 1045: Access denied for user: 'vital@localhost' (Using password: YES)
Loading config from '/usr/lib/zm/init/zmconfig.txt'
Loading config from '/etc/zm.conf'
Loading config from DB
DBI connect('database=zm;host=localhost','vital',...) failed: Access denied for user: 'vital@localhost' (Using password: YES) at /usr/lib/zm/init/zmoptions line 1524
Error: unable to load options from database: Access denied for user: 'vital@localhost' (Using password: YES)
Saving config to DB
DBI connect('database=zm;host=localhost','vital',...) failed: Access denied for user: 'vital@localhost' (Using password: YES) at /usr/lib/zm/init/zmoptions line 1434
Error: unable to save options to database: Access denied for user: 'vital@localhost' (Using password: YES)

- [root@localhost vital]# vi /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


- [root@localhost vital]# /usr/lib/zm/bin/zminit
Enter MySQL Administrator username: mysql
Enter password:
ERROR 1044 at line 2: Access denied for user: '@localhost' to database 'zm'
ERROR 1045: Access denied for user: 'vital@localhost' (Using password: YES)
Loading config from '/usr/lib/zm/init/zmconfig.txt'
Loading config from '/etc/zm.conf'
Loading config from DB
DBI connect('database=zm;host=localhost','vital',...) failed: Access denied for user: 'vital@localhost' (Using password: YES) at /usr/lib/zm/init/zmoptions line 1524
Error: unable to load options from database: Access denied for user: 'vital@localhost' (Using password: YES)
Saving config to DB
DBI connect('database=zm;host=localhost','vital',...) failed: Access denied for user: 'vital@localhost' (Using password: YES) at /usr/lib/zm/init/zmoptions line 1434
Error: unable to save options to database: Access denied for user: 'vital@localhost' (Using password: YES)

[root@localhost vital]# mysqlshow
+-----------+
| Databases |
+-----------+
| mysql |
| test |
+-----------+

conclusion : I tried all the passwords I know, but nothing. The install procees seems to be ok, but no zmdatabase appears.

ps: I have seen the forum, this one particularly, http://www.zoneminder.com/forums/viewtopic.php?t=4451 but it doesn't seem to solve my pb.


thx 4 your reply

[cordel]

You can put any user and password you want in the zm.conf.
Put the user for init must be a administrative user ie. root
Did you set a password for root in the database (is not the same as root that you login to the desktop with)?
If not then try using root and leave the password blank.
Regards,
Cordel

[MK]

[root@localhost vital]# /usr/bin/mysqladmin -u root password 'xxxxxx

[root@localhost vital]# /sbin/service mysqld stop
050805 10:26:48 mysqld ended

Arrêt de MySQL : [ OK ]
[root@localhost vital]# /sbin/service mysqld start
Démarrage de MySQL : [ OK ]


[root@localhost vital]# /usr/lib/zm/bin/zminit
Enter MySQL Administrator username: root
Enter password:
Loading config from '/usr/lib/zm/init/zmconfig.txt'
Loading config from '/etc/zm.conf'
Loading config from DB
Saving config to DB


my mistake: I have forgot I have to set a root (or an other user) password even if mysql is install by rpm. It used to do it automatically when I install it myself .....

thx codel

[MK]

[root@localhost vital]# /etc/rc.d/init.d/zm start
Starting ZoneMinder: [ OK ]

now, I 'm going to trys setting up my logitech quickcam pro 4000!!