ZoneMinder Forums

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>

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

have you entered the passwords you want to use in zminit

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

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