zmpkg.pl DBI connect failure

Support and queries relating to all previous versions of ZoneMinder
Locked
sick347
Posts: 85
Joined: Tue Mar 28, 2006 5:19 pm

zmpkg.pl DBI connect failure

Post by sick347 »

list,

I have spent a good deal of time just getting the install to this point (spent many hours dealing with mysql stuff) and I think I have finally made it to the end!!!

I am excited!

It appears that I have one last error (I hope) before I get ZM running.

Does anyone have comments on what it is I'm doing wrong here?

thanks
-frank

frank@wdshss:/usr/local/bin> zmpkg.pl start
DBI connect('database=zm;host=localhost','db_admin',...) failed: Access denied for user ''@'localhost' to database 'zm' at /usr/local/bin/zmpkg.pl line 49
Can't call method "prepare_cached" on an undefined value at /usr/local/bin/zmpkg.pl line 52.
BEGIN failed--compilation aborted at /usr/local/bin/zmpkg.pl line 60.
frank@wdshss:/usr/local/bin>
got my eye on you!
wmoore
Posts: 43
Joined: Mon Mar 29, 2004 2:25 am

Post by wmoore »

How did the DB build proceedures go? Did you have any trouble granting user rights to the ZM db? It looks like the DB user was not properly initialized.

Beyond that, is MySQL Running? If so, you may want to verify that ZM is looking for the socket in the proper place. I have seen occasions where MySQL and ZM are looking for mysql.soc in different places.

-WAM
jameswilson
Posts: 5111
Joined: Wed Jun 08, 2005 8:07 pm
Location: Midlands UK

Post by jameswilson »

have you entered the passwords you want to use in zminit
James Wilson

Disclaimer: The above is pure theory and may work on a good day with the wind behind it. etc etc.
http://www.securitywarehouse.co.uk
sick347
Posts: 85
Joined: Tue Mar 28, 2006 5:19 pm

Post by sick347 »

wmoore,

that's a good question.

I actually did a second post because the make failed and I'm not sure what, if anything, that has to do with the DB.

I was successful with the zm_create.sql script and did verify that the ZM DB was in the list of databases in mysql.

And yes I did get mysql runnning and it does get started on boot.

I think this could be due to a make problem...it just refuses to make.

I don't know what to do at this point.

-frank
got my eye on you!
wmoore
Posts: 43
Joined: Mon Mar 29, 2004 2:25 am

Post by wmoore »

Hummm...

Well, it sounds like you didn't get a clean make. If that is the case you will have issues. The make step is obviously not optional. I'll look for your other post.

In the above issue:
failed: Access denied for user ''@'localhost' to database 'zm'
I would "expect" to see somthing like ...

Access denied for user 'zmuser'@'localhost' t database 'zm'

My guess is that is why jameswilson is thinking about zminit. As I remember, this version handels the old zmconfig.pl info automatically... probably at the end of the make process.

Did this step have any errors ?:

grant select,insert,update,delete on <your database name>.* to '<username>'@localhost identified by '<password>';

If not, then I would focus on the make issue.

-WAM
Locked