Access Denied - Database Issues

Support and queries relating to all previous versions of ZoneMinder
Locked
richware
Posts: 3
Joined: Mon Jun 26, 2006 11:01 pm

Access Denied - Database Issues

Post by richware »

Working with ZoneMinder 1.22.1 on Fedora core 5. when I run zmpkg.pl start I get the following error:

[root@localhost ~]# zmpkg.pl start
DBI connect('database=zm;host=localhost','zmuser',...) failed: Access denied for user 'zmuser'@'localhost' (using password: YES) at /usr/lib/perl5/site_perl/5.8.8/ZoneMinder/Config.pm line 89
Can't call method "prepare_cached" on an undefined value at /usr/lib/perl5/site_perl/5.8.8/ZoneMinder/Config.pm line 91.
BEGIN failed--compilation aborted at /usr/lib/perl5/site_perl/5.8.8/ZoneMinder/Config.pm line 100.
Compilation failed in require at /usr/lib/perl5/site_perl/5.8.8/ZoneMinder.pm line 33.
BEGIN failed--compilation aborted at /usr/lib/perl5/site_perl/5.8.8/ZoneMinder.pm line 33.
Compilation failed in require at /usr/local/bin/zmpkg.pl line 45.
BEGIN failed--compilation aborted at /usr/local/bin/zmpkg.pl line 45.

I saw several other posts about the Access Denied issue and tried some of the commands but to no avail.

Please help! Thanks
User avatar
cordel
Posts: 5210
Joined: Fri Mar 05, 2004 4:47 pm
Location: /USA/Washington/Seattle

Re: Access Denied - Database Issues

Post by cordel »

richware wrote: [root@localhost ~]# zmpkg.pl start
DBI connect('database=zm;host=localhost','zmuser',...) failed: Access denied for user 'zmuser'@'localhost' (using password: YES) at /usr/lib/perl5/site_perl/5.8.8/ZoneMinder/Config.pm line 89
Are you sure you created the user zmuser in mysql?
Can you login to the database through the command line or do you get an error that access for zmuser is denied as well?

What procedures did you use to setup the database?
What have you tried to correct it?

Regards,
Corey
richware
Posts: 3
Joined: Mon Jun 26, 2006 11:01 pm

Post by richware »

Yes, using the web interface, (webmin) I created zmuser under the global and database users in Mysql. I even added it to the users table in the zm database.

I since have uninstalled zoneminder 1.22.1 and dropped the zm database and installed 1.22.2. I tried to follow the instructions in the readme.pdf file under the topic "Building" . I am getting the same error msg previously posted. I tried also modifing the zm.conf file to use root with no password and root with my fedora logon password. I admit I'm not an expert in linux, (but give me a PC and I can wow ya)

I appreciate your response!
User avatar
cordel
Posts: 5210
Joined: Fri Mar 05, 2004 4:47 pm
Location: /USA/Washington/Seattle

Post by cordel »

If you just follow the instructions in the readme you would do fine. The only other thing you have to do is turn off SELinux in FC.

Regards,
Corey
richware
Posts: 3
Joined: Mon Jun 26, 2006 11:01 pm

Post by richware »

OK, I got it running, MySql was not set up correctly. The console now launches. Is there a set of instructions for setting this up to work with X10 cameras sending to the VR31a wireless receiver and the VA11a usb adapter?

Thanks again
User avatar
cordel
Posts: 5210
Joined: Fri Mar 05, 2004 4:47 pm
Location: /USA/Washington/Seattle

Post by cordel »

You need to install a capture card and to set it up in zm. You should find most of it in the README

Regards,
Corey
Locked