Gentoo and zoneminder

[zoneminder]

Have you (a) created your database and (b) defined any monitors?

Phil,

[tubs]

corey!

I am having this problem too

but the problem I had then was that no matter what I did it was still trying to auth to the server as zoneminder_admin@localhost even after I made the appropriate changes manualy in every config file I could find.

I have tried starting from scratch a couple of times, read the faq and search forums for hours but still,

# php /home/httpd/htdocs/zoneminder/zm.php
Warning: mysql_pconnect(): Access denied for user: 'zoneminder_admin@localhost' (Using password: YES) in /home/httpd/htdocs/zoneminder/zm_db.php on line 22
Could not connect to database: Access denied for user: 'zoneminder_admin@localhost' (Using password: YES)


Or if i try and open the zm.php with mozilla, it just keeps opening new pages?

I must have missed something trivial.
how did you fix this? please just point in the right direction ie which file will cause this error?

cheers
--tubs

[zoneminder]

Do you know for sure that you can connect to the DB from the command line using

mysql zm -uzoneminder_admin -p<password> -hlocalhost

If not then there is a problem with your DB user setup. If you can then it's an issue with ZM somewhere.

Phil,

[tubs]

I can access the site, the init script works and i get the output when i ask for its status..

'zmaudit.pl -d 900 -y' running at 04/10/06 23:44:07, pid = 5545, valid
'zmwatch.pl' running at 04/10/06 23:42:09, pid = 5521, valid
'zmc -d 0' pending at 04/10/07 00:05:27
'zmfilter.pl' pending at 04/10/07 00:14:15

i then manually exuecte zmc -d 0 and i get the response
Can't connect to server: Access denied for user: 'zoneminder_admin@localhost' (Using password: YES)

now when askedf for the admin username when running the config script i didint specify "zoneminder_admin" i specified the user "root" and it appears that the program got compiled with the default zoneminder_admin user instead. Yet all ther other .pl scripts have been configured properly and show that the db user = root when you go to edit them...

is this a bug? and do i have to create a user zoneminder_admin for mysql to make this happy? if so whats the password going to be?

cheers guys

--tubs

[securiteaze]

I can verify that zoneminder does work with gentoo, albeit with a little tweaking. Perhaps this bit from Section 3 in the online documentation will help. The first user and password is the zm admin user and the second is the viewer, within mysql.

For a new installation the simplest way to create your database and users is as follows,

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

HTH

[tubs]

Well it seems that the problem lies within my configuration, I believe here
--with-mysql=<your MySQL root>
i think i used /usr instead of /usr/lib, but cant recall...

--tubs

[securiteaze]

FWIW The following script is what I use build zoneminder

Code: Select all

./configure \
                --host=${CHOST} \
                --prefix=/usr \
                --infodir=/usr/share/info \
                --mandir=/usr/share/man \
                --with-mysql=/usr \
                --with-webdir=/www \
                --with-cgidir=/www/cgi-bin \
                --with-webuser=apache \
                --with-webgroup=apache \
                --with-ffmpeg=/usr/bin \
                --with-lame=/usr/bin &&

perl zmconfig.pl -f zmconfig-gentoo.txt -noi ||
echo "./configure failed"

[DarkSSJ]

Could you post the zmconfig-gentoo.txt file and some usefull tips? I'm going crazy o_O ...