Zoneminder database problems... first time user. Help Please

Support and queries relating to all previous versions of ZoneMinder
Locked
kingpikey
Posts: 3
Joined: Wed Sep 05, 2007 12:13 am

Zoneminder database problems... first time user. Help Please

Post by kingpikey »

ok i followed the instructions in the readme, rpms seem to have installed correctly.

when i go to
https://myip:81/zm/
i get this...

Code: Select all

 Could not connect to database: Access denied for user 'zmuser'@'localhost' (using password: YES)  
I've been googling my fingers off, searched here, zoneminder forums, etc etc. Please help!!
kingpikey
Posts: 3
Joined: Wed Sep 05, 2007 12:13 am

Post by kingpikey »

forgot to mention, I followed the instructions I found here... followed the readme.
http://www.clarkconnect.com/forums/show ... art=2&vc=1

I'm trying to get this installed on ClarkConnect.


Thanks in advance.
agilseguranca
Posts: 9
Joined: Tue Jun 26, 2007 6:33 pm
Location: Itapetinga - Bahia - Brasil

Post by agilseguranca »

kingpikey wrote:forgot to mention, I followed the instructions I found here... followed the readme.
http://www.clarkconnect.com/forums/show ... art=2&vc=1

I'm trying to get this installed on ClarkConnect.


Thanks in advance.
Check in MySQL if this user exists, look the default password too: u:zmuser p:zmpass

Using PhpMyAdmin can be easier.

Sorry my english... :oops:
Laevi
Posts: 42
Joined: Mon Aug 27, 2007 1:50 pm

Post by Laevi »

you're filling in 'YES' as pass when you try to connect to mysql database while it should be 'zmpass'. switch it :roll:
we4zonM
Posts: 56
Joined: Fri May 30, 2008 7:21 am

Post by we4zonM »

How do you tell Zoneminder to use a different username and password when you start it? Such as using "yes" instead of "zmpass"?
User avatar
cordel
Posts: 5210
Joined: Fri Mar 05, 2004 4:47 pm
Location: /USA/Washington/Seattle

Post by cordel »

That is covered in the documentation:
http://www.zoneminder.com/wiki/index.ph ... n#Building

Third paragraph.
we4zonM
Posts: 56
Joined: Fri May 30, 2008 7:21 am

Post by we4zonM »

To build ZoneMinder the first thing you need to do is run the included configure script to define some initial configuration. If you are happy with the default settings for the database host (‘localhost’), name (‘zm’), user (‘zmuser’) and password (‘zmpass’) then you can just type

./configure --with-webdir=<your> --with-cgidir=<your>

where --with-webdir is the directory to which you want to install the PHP files, and --with-cgidir is the directory to which you want to install CGI files. These directories could be /var/www/html/zm and /var/www/cgi-bin for example.

If you want to override any of the default database values then you can append them to the configure command, for example to use a database password of ‘zmnewpass’ do

./configure --with-webdir=<your> --with-cgidir=<your> ZM_DB_PASS=zmnewpass

and so on. The values you can use are ZM_DB_HOST, ZM_DB_NAME, ZM_DB_USER and ZM_DB_PASS. Other than the database name, which is substituted into the database creation script, these values can easily be changed after this step.
This does mention ZM_DB_USER and ZM_DB_PASS, but this is for changing it at build time. If you have already built it, it does not tell you how to change it! I tried editing the zm.conf file and that seemed to work.
User avatar
cordel
Posts: 5210
Joined: Fri Mar 05, 2004 4:47 pm
Location: /USA/Washington/Seattle

Post by cordel »

There is that as well, just the configured database user must match what is in zm.conf.
Locked