mysql errors: HELP!

static · Post by **static** » Wed May 17, 2006 12:51 am

getting the following message after installing ZM on my ubuntu system using documentation for Debian, with only reservation that i compiled the code from source, as the apt way didn't work (needs some older packages that are no longer available) :

Warning: mysql_pconnect() [function.mysql-pconnect]: Lost connection to MySQL server during query in /var/www/zm/zm_db.php on line 21
Could not connect to database: Lost connection to MySQL server during query

never dealt with mysql, can anyone give me some ideas how to go about fixing the issue?
i have not touched the zm.conf

also upon exec'ing the following here is what i get:

root@ubuntu:/usr/local/etc# mysql -u zmuser -p
Enter password: <type in "zmpass">
ERROR 1045: Access denied for user: 'zmuser@localhost' (Using password: YES)

Thanks
Alex

Post by **zoneminder** » Wed May 17, 2006 9:51 pm

Have you 'grant'ed your zmuser the right privileges? It migth also be worth trying to find the mysql log and checking that there is nothing odd in that.

static · Post by **static** » Fri May 19, 2006 1:43 am

Hi

Thanks for help

I understand that it's just a hobby project, but is there a step by step documentation about how to install and configure ZM (i am not even talking about using it)

I tried to follow the debian short doc along with the "Install" section of the main doc, but ended up with non complying mysql and these errors upon "make install":

make[4]: Entering directory `/home/ababkin/security/ZoneMinder-1.22.1/web/graphics'
( cd /var/www/zm/graphics; chown apache:apache arrow-d.gif arrow-dl.gif arrow-dr.gif arrow-l.gif arrow-r.gif arrow-u.gif arrow-ul.gif arrow-ur.gif arrow-l-u.gif arrow-l-d.gif center.gif seq-u.gif seq-d.gif point-g.gif point-o.gif point-r.gif spacer.gif )
chown: `apache:apache': invalid user
make[4]: *** [install-data-hook] Error 1
make[4]: Leaving directory `/home/ababkin/security/ZoneMinder-1.22.1/web/graphics'
make[3]: *** [install-data-am] Error 2
make[3]: Leaving directory `/home/ababkin/security/ZoneMinder-1.22.1/web/graphics'
make[2]: *** [install-am] Error 2
make[2]: Leaving directory `/home/ababkin/security/ZoneMinder-1.22.1/web/graphics'
make[1]: *** [install-recursive] Error 1
make[1]: Leaving directory `/home/ababkin/security/ZoneMinder-1.22.1/web'
make: *** [install-recursive] Error 1

Please help

Alex

Post by **zoneminder** » Fri May 19, 2006 10:21 am

I assume you have followed the install instructions in the README?

The problem you are gettign is because you have defined your web user and group as apache in configure, however on your system this account does not appear to exist. You will probably have to use a different name, for instance wwwroot.