Service Start Errors

themutt · Post by **themutt** » Sat Jan 08, 2005 9:32 pm

Getting error message trying to start service, zm 1.19.5 :

service zm start
Starting ZoneMinder: DBI connect('database=zm;host=mycomputer.home.com','me',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client 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.
[FAILED]

Running Mandrake 10.1 with latest mysql client installed, MySQL41-client, using KDE 3.3.2. Any ideas. TIA

dbradshaw · Post by **dbradshaw** » Sun Jan 09, 2005 9:00 am

The latest version of sql uses a different method for authenticating passwords - I only know this because you are where I was ten days ago.

Try this
Log into mysql (mysql mysql -uroot -ppassword) and execute the following line at the prompt:
mysql> SET PASSWORD FOR 'auser'@'ahost' = OLD_PASSWORD('password');

substitute for auser, ahost and password whatever you are using (do not forget the quotes), repeat for each of your users.

Dave

themutt · Post by **themutt** » Sun Jan 09, 2005 7:40 pm

Thanks for sql info. Tried but go more errors -
service zm start
Starting ZoneMinder: Bareword "ZM_PATH_LOGS" not allowed while "strict subs" inuse at /usr/local/bin/zmpkg.pl line 62.
BEGIN not safe after errors--compilation aborted at /usr/local/bin/zmpkg.pl line 63.
Have zm 1.19.2 working in Mdk 10, same multiboot system, all hardware the same. Trying to get something to work. Apache and PHP check ok in 10.1, camera works okay in 10.1. When I use Mozilla to go to zm just a blank page shows up. zmc --device 0 gives me a "No Monitor Found" error in syslog but running zmu -d 0 -q -v yields good data although the last line is Format: 0 - PAL which I thought was NTSC.

Sort of at a loss. Apache, PHP, and camera all working. ZMU works but ZMC and webpage don't. Seems like it may be a database or database access error but not sure. Any ideas appreciated.

Post by **zoneminder** » Sun Jan 09, 2005 8:32 pm

It looks like your Config is not in the db correctly. Did you run zmconfig.pl?

Phil

themutt · Post by **themutt** » Mon Jan 10, 2005 10:24 am

Started over again. Removed mysql and zm and reinstalled from scratch. Now getting a make error.
make all-recursive
make[1]: Entering directory `/usr/local/install/zm-1.19.5'
Making all in src
make[2]: Entering directory `/usr/local/install/zm-1.19.5/src'
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -I/usr/include -g -O2 -MTzmc.o -MD -MP -MF ".deps/zmc.Tpo" \
-c -o zmc.o `test -f 'zmc.cpp' || echo './'`zmc.cpp; \
then mv -f ".deps/zmc.Tpo" ".deps/zmc.Po"; \
else rm -f ".deps/zmc.Tpo"; exit 1; \
fi
In file included from zmc.cpp:25:
zm_db.h:23:25: mysql/mysql.h: No such file or directory
In file included from zmc.cpp:25:
zm_db.h:27: error: `MYSQL' does not name a type
make[2]: *** [zmc.o] Error 1
make[2]: Leaving directory `/usr/local/install/zm-1.19.5/src'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/local/install/zm-1.19.5'
make: *** [all] Error 2
May try going back to earlier version if no fix for above.

Post by **zoneminder** » Mon Jan 10, 2005 8:58 pm

Did you reun the ZM configure script? If you reinstalled mysql it might have put headers in a different place. Also you need to install the mysql development packages and not just the server. Is the mysql.h file on your system anywhere?

Phil

themutt · Post by **themutt** » Tue Jan 11, 2005 6:42 am

Development package missing, that took care of make issue. Now have everything reinstalled with no change from above, no web page, zmc gives me a "NO MONITOR FOUND", zmu returns correct data. Have tried suggestions above, no luck. Have tried reentering user data using > grant all privileges on database.* to username@"servername" identified by 'password'; mysql sytax but no luck. Have looked in php.ini and php5.ini. both have safe mode off and short tags on. Perl module for X10::Activehome is not installed, config for X10 is off, but I don' t have any X10 and my zm 1.19.2 works okay without it. Looked in /var/lib/mysql/zm and found about 30 files including 3 config files so that seems okay. Zmschema.txt looks okay. In /var/www/html/zm have about 60 files but the events, images, sounds, and tmp directories are not there. Running out of ideas, any suggestions.

themutt · Post by **themutt** » Tue Jan 11, 2005 10:04 pm

Finally got past the protocol problem as mentioned above, don't know why its now working possibly syntax error on earlier attempt. Good reference on this issue is http://dev.mysql.com/doc/mysql/en/Password_hashing.html . Now when I run
service zm start I get -
Starting ZoneMinder: Bareword "ZM_PATH_LOGS" not allowed while "strict subs" inuse at /usr/local/bin/zmpkg.pl line 62.
BEGIN not safe after errors--compilation aborted at /usr/local/bin/zmpkg.pl line 63.
Zmc still yields "NO MONITOR FOUND" and zmu returns corrrect data. My system apparently doesn't like something in the program code.

themutt · Post by **themutt** » Tue Jan 11, 2005 11:09 pm

Got zm to start as a service after rerunning perl ./zmconfig.pl and perl ./zmconfig.pl -noi. Unfortunately this locked up my keyboard but a step in the right direction. After removing zm as a service at boot, now back to zmc --device 0 still yielding a "No monitors found" message and no webpage.

themutt · Post by **themutt** » Wed Jan 12, 2005 6:02 pm

Got zm 1.19.5 working in Mdk 10.1 using KDE 3.3.2. To summarize in case someone else can use the info.
1) The " Client does not support authentication protocol " was resolved with
SET PASSWORD FOR 'auser'@'ahost' = OLD_PASSWORD('password');
it took more than one try, see http://dev.mysql.com/doc/mysql/en/Password_hashing.html
2) The "Bareword "ZM_PATH_LOGS" not allowed while "strict subs" inuse" was resolved by rerunning perl ./zmconfig.pl and perl./zmconfig.pl -noi. For some reason this had to be repeated.
3) When running zm as a sevice locked up my keyboard I switched to XDM from KDM. Loading the dm last may also help. This problem likely unique to my system since KDE 3.3.2 is not supported in Mandrake 10.1.
4) Got the web page to work by installing the php5-mysql package for my system. Apache and PHP were working okay but needed the extra package.
5) Got the webcam image to show up in zm-console using mozilla by using conservative settings. The webcam was particularly sensitive to the Monitor Capture width and height settings. Also changed video out to jpeg using zmconfig.pl.