MySQCL C Library

Support and queries relating to all previous versions of ZoneMinder
carrthomas
Posts: 42
Joined: Tue Nov 25, 2003 10:11 pm

Re: MySQCL C Library

Post by carrthomas »

Trevor

I would try --with-mysql=/usr again as Phil mentioned earlier.

(do not put /mysql on the end of the path.) It worked for me after I had loaded the mysql-develop- module.

BTW it might be finger trouble with spelling ..I notice you put in libmyclient rather than libmysqlclient.

Best of luck

Peter


I'm stuck on the next bit with mysql < zmschema.sql ...Day 8 !...and still not working...

It's a race to the finish ;-) !
User avatar
zoneminder
Site Admin
Posts: 5215
Joined: Wed Jul 09, 2003 2:07 pm
Location: Bristol, UK
Contact:

Re: MySQCL C Library

Post by zoneminder »

Hi Peter,

What's the problem with 'mysql < zmschema.sql'??

Phil,
carrthomas
Posts: 42
Joined: Tue Nov 25, 2003 10:11 pm

Re: MySQCL C Library

Post by carrthomas »

Hi Phil,
I think I have a problem....probably several... I am lucky like that!
Certainly would appreciate some help (i am reading up about mysql at the moment). Thanks
Here is where I have got to:-


[root@localhost zm-0.9.16]# mysql -p < db/zmschema.sql
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
[root@localhost zm-0.9.16]# mysql < db/zmschema.sql
[root@localhost zm-0.9.16]# make
make all-recursive
make[1]: Entering directory `/usr/local/zm-0.9.16'
Making all in src
make[2]: Entering directory `/usr/local/zm-0.9.16/src'
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zmc.o -MD -MP -MF ".deps/zmc.Tpo" \
-c -o zmc.o `test -f 'zmc.cpp' || echo './'`zmc.cpp; \
then mv ".deps/zmc.Tpo" ".deps/zmc.Po"; \
else rm -f ".deps/zmc.Tpo"; exit 1; \
fi
cc1plus: warning: changing search order for system directory "/usr/include"
cc1plus: warning: as it has already been specified as a non-system directory
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zm.o -MD -MP -MF ".deps/zm.Tpo" \
-c -o zm.o `test -f 'zm.cpp' || echo './'`zm.cpp; \
then mv ".deps/zm.Tpo" ".deps/zm.Po"; \
else rm -f ".deps/zm.Tpo"; exit 1; \
fi
cc1plus: warning: changing search order for system directory "/usr/include"
cc1plus: warning: as it has already been specified as a non-system directory
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zm_db.o -MD -MP -MF ".deps/zm_db.Tpo" \
-c -o zm_db.o `test -f 'zm_db.cpp' || echo './'`zm_db.cpp; \
then mv ".deps/zm_db.Tpo" ".deps/zm_db.Po"; \
else rm -f ".deps/zm_db.Tpo"; exit 1; \
fi
cc1plus: warning: changing search order for system directory "/usr/include"
cc1plus: warning: as it has already been specified as a non-system directory
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zm_config.o -MD -MP -MF ".deps/zm_config.Tpo" \
-c -o zm_config.o `test -f 'zm_config.cpp' || echo './'`zm_config.cpp; \
then mv ".deps/zm_config.Tpo" ".deps/zm_config.Po"; \
else rm -f ".deps/zm_config.Tpo"; exit 1; \
fi
cc1plus: warning: changing search order for system directory "/usr/include"
cc1plus: warning: as it has already been specified as a non-system directory
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zm_coord.o -MD
-MP -MF ".deps/zm_coord.Tpo" \
-c -o zm_coord.o `test -f 'zm_coord.cpp' || echo './'`zm_coord.cpp; \
then mv ".deps/zm_coord.Tpo" ".deps/zm_coord.Po"; \
else rm -f ".deps/zm_coord.Tpo"; exit 1; \
fi
cc1plus: warning: changing search order for system directory "/usr/include"
cc1plus: warning: as it has already been specified as a non-system directory
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zm_box.o -MD -MP -MF ".deps/zm_box.Tpo" \
-c -o zm_box.o `test -f 'zm_box.cpp' || echo './'`zm_box.cpp; \
then mv ".deps/zm_box.Tpo" ".deps/zm_box.Po"; \
else rm -f ".deps/zm_box.Tpo"; exit 1; \
fi
cc1plus: warning: changing search order for system directory "/usr/include"
cc1plus: warning: as it has already been specified as a non-system directory
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zm_image.o -MD
-MP -MF ".deps/zm_image.Tpo" \
-c -o zm_image.o `test -f 'zm_image.cpp' || echo './'`zm_image.cpp; \
then mv ".deps/zm_image.Tpo" ".deps/zm_image.Po"; \
else rm -f ".deps/zm_image.Tpo"; exit 1; \
fi
cc1plus: warning: changing search order for system directory "/usr/include"
cc1plus: warning: as it has already been specified as a non-system directory
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zm_event.o -MD
-MP -MF ".deps/zm_event.Tpo" \
-c -o zm_event.o `test -f 'zm_event.cpp' || echo './'`zm_event.cpp; \
then mv ".deps/zm_event.Tpo" ".deps/zm_event.Po"; \
else rm -f ".deps/zm_event.Tpo"; exit 1; \
fi
cc1plus: warning: changing search order for system directory "/usr/include"
cc1plus: warning: as it has already been specified as a non-system directory
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zm_zone.o -MD -MP -MF ".deps/zm_zone.Tpo" \
-c -o zm_zone.o `test -f 'zm_zone.cpp' || echo './'`zm_zone.cpp; \
then mv ".deps/zm_zone.Tpo" ".deps/zm_zone.Po"; \
else rm -f ".deps/zm_zone.Tpo"; exit 1; \
fi
cc1plus: warning: changing search order for system directory "/usr/include"
cc1plus: warning: as it has already been specified as a non-system directory
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zm_camera.o -MD -MP -MF ".deps/zm_camera.Tpo" \
-c -o zm_camera.o `test -f 'zm_camera.cpp' || echo './'`zm_camera.cpp; \
then mv ".deps/zm_camera.Tpo" ".deps/zm_camera.Po"; \
else rm -f ".deps/zm_camera.Tpo"; exit 1; \
fi
cc1plus: warning: changing search order for system directory "/usr/include"
cc1plus: warning: as it has already been specified as a non-system directory
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zm_local_camera.o -MD -MP -MF ".deps/zm_local_camera.Tpo" \
-c -o zm_local_camera.o `test -f 'zm_local_camera.cpp' || echo './'`zm_local_camera.cpp; \
then mv ".deps/zm_local_camera.Tpo" ".deps/zm_local_camera.Po"; \
else rm -f ".deps/zm_local_camera.Tpo"; exit 1; \
fi
cc1plus: warning: changing search order for system directory "/usr/include"
cc1plus: warning: as it has already been specified as a non-system directory
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zm_remote_camera.o -MD -MP -MF ".deps/zm_remote_camera.Tpo" \
-c -o zm_remote_camera.o `test -f 'zm_remote_camera.cpp' || echo './'`zm_remote_camera.cpp; \
then mv ".deps/zm_remote_camera.Tpo" ".deps/zm_remote_camera.Po"; \
else rm -f ".deps/zm_remote_camera.Tpo"; exit 1; \
fi
cc1plus: warning: changing search order for system directory "/usr/include"
cc1plus: warning: as it has already been specified as a non-system directory
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zm_monitor.o -MD -MP -MF ".deps/zm_monitor.Tpo" \
-c -o zm_monitor.o `test -f 'zm_monitor.cpp' || echo './'`zm_monitor.cpp; \
then mv ".deps/zm_monitor.Tpo" ".deps/zm_monitor.Po"; \
else rm -f ".deps/zm_monitor.Tpo"; exit 1; \
fi
cc1plus: warning: changing search order for system directory "/usr/include"
cc1plus: warning: as it has already been specified as a non-system directory
if gcc -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zm_debug.o -MD
-MP -MF ".deps/zm_debug.Tpo" \
-c -o zm_debug.o `test -f 'zm_debug.c' || echo './'`zm_debug.c; \
then mv ".deps/zm_debug.Tpo" ".deps/zm_debug.Po"; \
else rm -f ".deps/zm_debug.Tpo"; exit 1; \
fi
cc1: warning: changing search order for system directory "/usr/include"
cc1: warning: as it has already been specified as a non-system directory
if gcc -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zm_jpeg.o -MD -MP -MF ".deps/zm_jpeg.Tpo" \
-c -o zm_jpeg.o `test -f 'zm_jpeg.c' || echo './'`zm_jpeg.c; \
then mv ".deps/zm_jpeg.Tpo" ".deps/zm_jpeg.Po"; \
else rm -f ".deps/zm_jpeg.Tpo"; exit 1; \
fi
cc1: warning: changing search order for system directory "/usr/include"
cc1: warning: as it has already been specified as a non-system directory
g++ -g -O2 -L/usr/lib/mysql -o zmc zmc.o zm.o zm_db.o zm_config.o zm_coord.o zm_box.o zm_image.o zm_event.o zm_zone.o zm_camera.o zm_local_camera.o zm_remote_camera.o zm_monitor.o zm_debug.o zm_jpeg.o -L/usr/lib/mysql -lmysqlclient -ldl -lz -ljpeg
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zma.o -MD -MP -MF ".deps/zma.Tpo" \
-c -o zma.o `test -f 'zma.cpp' || echo './'`zma.cpp; \
then mv ".deps/zma.Tpo" ".deps/zma.Po"; \
else rm -f ".deps/zma.Tpo"; exit 1; \
fi
cc1plus: warning: changing search order for system directory "/usr/include"
cc1plus: warning: as it has already been specified as a non-system directory
g++ -g -O2 -L/usr/lib/mysql -o zma zma.o zm.o zm_db.o zm_config.o zm_coord.o zm_box.o zm_image.o zm_event.o zm_zone.o zm_camera.o zm_local_camera.o zm_remote_camera.o zm_monitor.o zm_debug.o zm_jpeg.o -L/usr/lib/mysql -lmysqlclient -ldl -lz -ljpeg
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zmu.o -MD -MP -MF ".deps/zmu.Tpo" \
-c -o zmu.o `test -f 'zmu.cpp' || echo './'`zmu.cpp; \
then mv ".deps/zmu.Tpo" ".deps/zmu.Po"; \
else rm -f ".deps/zmu.Tpo"; exit 1; \
fi
cc1plus: warning: changing search order for system directory "/usr/include"
cc1plus: warning: as it has already been specified as a non-system directory
g++ -g -O2 -L/usr/lib/mysql -o zmu zmu.o zm.o zm_db.o zm_config.o zm_coord.o zm_box.o zm_image.o zm_event.o zm_zone.o zm_camera.o zm_local_camera.o zm_remote_camera.o zm_monitor.o zm_debug.o zm_jpeg.o -L/usr/lib/mysql -lmysqlclient -ldl -lz -ljpeg
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zms.o -MD -MP -MF ".deps/zms.Tpo" \
-c -o zms.o `test -f 'zms.cpp' || echo './'`zms.cpp; \
then mv ".deps/zms.Tpo" ".deps/zms.Po"; \
else rm -f ".deps/zms.Tpo"; exit 1; \
fi
cc1plus: warning: changing search order for system directory "/usr/include"
cc1plus: warning: as it has already been specified as a non-system directory
g++ -g -O2 -L/usr/lib/mysql -o zms zms.o zm.o zm_db.o zm_config.o zm_coord.o zm_box.o zm_image.o zm_event.o zm_zone.o zm_camera.o zm_local_camera.o zm_remote_camera.o zm_monitor.o zm_debug.o zm_jpeg.o -L/usr/lib/mysql -lmysqlclient -ldl -lz -ljpeg
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zmf.o -MD -MP -MF ".deps/zmf.Tpo" \
-c -o zmf.o `test -f 'zmf.cpp' || echo './'`zmf.cpp; \
then mv ".deps/zmf.Tpo" ".deps/zmf.Po"; \
else rm -f ".deps/zmf.Tpo"; exit 1; \
fi
cc1plus: warning: changing search order for system directory "/usr/include"
cc1plus: warning: as it has already been specified as a non-system directory
g++ -g -O2 -L/usr/lib/mysql -o zmf zmf.o zm.o zm_db.o zm_config.o zm_coord.o zm_box.o zm_image.o zm_event.o zm_zone.o zm_camera.o zm_local_camera.o zm_remote_camera.o zm_monitor.o zm_debug.o zm_jpeg.o -L/usr/lib/mysql -lmysqlclient -ldl -lz -ljpeg
if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -g -O2 -MT zmfix.o -MD -MP -MF ".deps/zmfix.Tpo" \
-c -o zmfix.o `test -f 'zmfix.cpp' || echo './'`zmfix.cpp; \
then mv ".deps/zmfix.Tpo" ".deps/zmfix.Po"; \
else rm -f ".deps/zmfix.Tpo"; exit 1; \
fi
cc1plus: warning: changing search order for system directory "/usr/include"
cc1plus: warning: as it has already been specified as a non-system directory
g++ -g -O2 -L/usr/lib/mysql -o zmfix zmfix.o zm_debug.o zm_db.o zm.o -L/usr/lib/mysql -lmysqlclient -ldl -lz -ljpeg
make[2]: Leaving directory `/usr/local/zm-0.9.16/src'
Making all in web
make[2]: Entering directory `/usr/local/zm-0.9.16/web'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/usr/local/zm-0.9.16/web'
Making all in scripts
make[2]: Entering directory `/usr/local/zm-0.9.16/scripts'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/usr/local/zm-0.9.16/scripts'
Making all in db
make[2]: Entering directory `/usr/local/zm-0.9.16/db'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/usr/local/zm-0.9.16/db'
make[2]: Entering directory `/usr/local/zm-0.9.16'
make[2]: Nothing to be done for `all-am'.
make[2]: Leaving directory `/usr/local/zm-0.9.16'
make[1]: Leaving directory `/usr/local/zm-0.9.16'
[root@localhost zm-0.9.16]# make install
Making install in src
make[1]: Entering directory `/usr/local/zm-0.9.16/src'
make[2]: Entering directory `/usr/local/zm-0.9.16/src'
/bin/sh ../mkinstalldirs /usr/local/bin
/usr/bin/install -c zmc /usr/local/bin/zmc
/usr/bin/install -c zma /usr/local/bin/zma
/usr/bin/install -c zmu /usr/local/bin/zmu
/usr/bin/install -c zms /usr/local/bin/zms
/usr/bin/install -c zmf /usr/local/bin/zmf
/usr/bin/install -c zmfix /usr/local/bin/zmfix
make install-exec-hook
make[3]: Entering directory `/usr/local/zm-0.9.16/src'
( cd /usr/local/bin; mv zms /var/www/cgi-bin )
( cd /var/www/cgi-bin; chown apache:apache zms )
( cd /usr/local/bin; chmod u+s zmfix )
make[3]: Leaving directory `/usr/local/zm-0.9.16/src'
make[2]: Nothing to be done for `install-data-am'.
make[2]: Leaving directory `/usr/local/zm-0.9.16/src'
make[1]: Leaving directory `/usr/local/zm-0.9.16/src'
Making install in web
make[1]: Entering directory `/usr/local/zm-0.9.16/web'
make[2]: Entering directory `/usr/local/zm-0.9.16/web'
make[2]: Nothing to be done for `install-exec-am'.
/bin/sh ../mkinstalldirs /var/www/html/zm
mkdir /var/www/html/zm
/usr/bin/install -c -m 644 zm_actions.php /var/www/html/zm/zm_actions.php
/usr/bin/install -c -m 644 zm_config.php /var/www/html/zm/zm_config.php
/usr/bin/install -c -m 644 zm_db.php /var/www/html/zm/zm_db.php
/usr/bin/install -c -m 644 zm_funcs.php /var/www/html/zm/zm_funcs.php
/usr/bin/install -c -m 644 zm_html.php /var/www/html/zm/zm_html.php
/usr/bin/install -c -m 644 zm_html_view_bandwidth.php /var/www/html/zm/zm_html_view_bandwidth.php
/usr/bin/install -c -m 644 zm_html_view_function.php /var/www/html/zm/zm_html_view_function.php
/usr/bin/install -c -m 644 zm_html_view_none.php /var/www/html/zm/zm_html_view_none.php
/usr/bin/install -c -m 644 zm_html_view_video.php /var/www/html/zm/zm_html_view_video.php
/usr/bin/install -c -m 644 zm_html_view_console.php /var/www/html/zm/zm_html_view_console.php
/usr/bin/install -c -m 644 zm_html_view_image.php /var/www/html/zm/zm_html_view_image.php
/usr/bin/install -c -m 644 zm_html_view_optionhelp.php /var/www/html/zm/zm_html_view_optionhelp.php
/usr/bin/install -c -m 644 zm_html_view_watchevents.php /var/www/html/zm/zm_html_view_watchevents.php
/usr/bin/install -c -m 644 zm_html_view_cycle.php /var/www/html/zm/zm_html_view_cycle.php
/usr/bin/install -c -m 644 zm_html_view_login.php /var/www/html/zm/zm_html_view_login.php
/usr/bin/install -c -m 644 zm_html_view_options.php /var/www/html/zm/zm_html_view_options.php
/usr/bin/install -c -m 644 zm_html_view_watchfeed.php /var/www/html/zm/zm_html_view_watchfeed.php
/usr/bin/install -c -m 644 zm_html_view_error.php /var/www/html/zm/zm_html_view_error.php
/usr/bin/install -c -m 644 zm_html_view_logout.php /var/www/html/zm/zm_html_view_logout.php
/usr/bin/install -c -m 644 zm_html_view_postlogin.php /var/www/html/zm/zm_html_view_postlogin.php
/usr/bin/install -c -m 644 zm_html_view_watch.php /var/www/html/zm/zm_html_view_watch.php
/usr/bin/install -c -m 644 zm_html_view_event.php /var/www/html/zm/zm_html_view_event.php
/usr/bin/install -c -m 644 zm_html_view_monitor.php /var/www/html/zm/zm_html_view_monitor.php
/usr/bin/install -c -m 644 zm_html_view_restarting.php /var/www/html/zm/zm_html_view_restarting.php
/usr/bin/install -c -m 644 zm_html_view_watchstatus.php /var/www/html/zm/zm_html_view_watchstatus.php
/usr/bin/install -c -m 644 zm_html_view_events.php /var/www/html/zm/zm_html_view_events.php
/usr/bin/install -c -m 644 zm_html_view_montagefeed.php /var/www/html/zm/zm_html_view_montagefeed.php
/usr/bin/install -c -m 644 zm_html_view_settings.php /var/www/html/zm/zm_html_view_settings.php
/usr/bin/install -c -m 644 zm_html_view_zone.php /var/www/html/zm/zm_html_view_zone.php
/usr/bin/install -c -m 644 zm_html_view_filter.php /var/www/html/zm/zm_html_view_filter.php
/usr/bin/install -c -m 644 zm_html_view_montage.php /var/www/html/zm/zm_html_view_montage.php
/usr/bin/install -c -m 644 zm_html_view_frames.php /var/www/html/zm/zm_html_view_frames.php
/usr/bin/install -c -m 644 zm_html_view_stats.php /var/www/html/zm/zm_html_view_stats.php
/usr/bin/install -c -m 644 zm_html_view_zones.php /var/www/html/zm/zm_html_view_zones.php
/usr/bin/install -c -m 644 zm_html_view_filtersave.php /var/www/html/zm/zm_html_view_filtersave.php
/usr/bin/install -c -m 644 zm_html_view_montagestatus.php /var/www/html/zm/zm_html_view_montagestatus.php
/usr/bin/install -c -m 644 zm_html_view_user.php /var/www/html/zm/zm_html_view_user.php
/usr/bin/install -c -m 644 zm.php /var/www/html/zm/zm.php
/usr/bin/install -c -m 644 zm_styles.css /var/www/html/zm/zm_styles.css
/usr/bin/install -c -m 644 zm_wml.php /var/www/html/zm/zm_wml.php
/usr/bin/install -c -m 644 zm_wml_view_console.php /var/www/html/zm/zm_wml_view_console.php
/usr/bin/install -c -m 644 zm_wml_view_feed.php /var/www/html/zm/zm_wml_view_feed.php
make install-data-hook
make[3]: Entering directory `/usr/local/zm-0.9.16/web'
( cd /var/www/html/zm; chown apache:apache zm_actions.php zm_config.php zm_db.php zm_funcs.php zm_html.php zm_html_view_bandwidth.php zm_html_view_function.php
zm_html_view_none.php zm_html_view_video.php zm_html_view_console.php zm_html_view_image.php zm_html_view_optionhelp.php zm_html_view_watchevents.php zm_html_view_cycle.php zm_html_view_login.php zm_html_view_options.php zm_html_view_watchfeed.php zm_html_view_error.php zm_html_view_logout.php zm_html_view_postlogin.php zm_html_view_watch.php zm_html_view_event.php zm_html_view_monitor.php zm_html_view_restarting.php zm_html_view_watchstatus.php zm_html_view_events.php zm_html_view_montagefeed.php zm_html_view_settings.php zm_html_view_zone.php zm_html_view_filter.php zm_html_view_montage.php zm_html_view_frames.php zm_html_view_stats.php zm_html_view_zones.php zm_html_view_filtersave.php zm_html_view_montagestatus.php zm_html_view_user.php zm.php zm_styles.css zm_wml.php zm_wml_view_console.php zm_wml_view_feed.php )
( cd /var/www/html/zm; ln -s zm.php index.php )
make[3]: Leaving directory `/usr/local/zm-0.9.16/web'
make[2]: Leaving directory `/usr/local/zm-0.9.16/web'
make[1]: Leaving directory `/usr/local/zm-0.9.16/web'
Making install in scripts
make[1]: Entering directory `/usr/local/zm-0.9.16/scripts'
make[2]: Entering directory `/usr/local/zm-0.9.16/scripts'
/bin/sh ../mkinstalldirs /usr/local/bin
/usr/bin/install -c zmdc.pl /usr/local/bin/zmdc.pl
/usr/bin/install -c zmaudit.pl /usr/local/bin/zmaudit.pl
/usr/bin/install -c zmfilter.pl /usr/local/bin/zmfilter.pl
/usr/bin/install -c zmx10.pl /usr/local/bin/zmx10.pl
/usr/bin/install -c zmwatch.pl /usr/local/bin/zmwatch.pl
/usr/bin/install -c zmpkg.pl /usr/local/bin/zmpkg.pl
/usr/bin/install -c zmvideo.pl /usr/local/bin/zmvideo.pl
make[2]: Nothing to be done for `install-data-am'.
make[2]: Leaving directory `/usr/local/zm-0.9.16/scripts'
make[1]: Leaving directory `/usr/local/zm-0.9.16/scripts'
Making install in db
make[1]: Entering directory `/usr/local/zm-0.9.16/db'
make[2]: Entering directory `/usr/local/zm-0.9.16/db'
make[2]: Nothing to be done for `install-exec-am'.
make[2]: Nothing to be done for `install-data-am'.
make[2]: Leaving directory `/usr/local/zm-0.9.16/db'
make[1]: Leaving directory `/usr/local/zm-0.9.16/db'
make[1]: Entering directory `/usr/local/zm-0.9.16'
make[2]: Entering directory `/usr/local/zm-0.9.16'
make[2]: Nothing to be done for `install-exec-am'.
make[2]: Nothing to be done for `install-data-am'.
make[2]: Leaving directory `/usr/local/zm-0.9.16'
make[1]: Leaving directory `/usr/local/zm-0.9.16'
[root@localhost zm-0.9.16]# zmpkg.pl start
DBI->connect(database=zm;host=localhost) failed: Access denied for user: 'peter@localhost' (Using password: YES) 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.
[root@localhost zm-0.9.16]#
User avatar
zoneminder
Site Admin
Posts: 5215
Joined: Wed Jul 09, 2003 2:07 pm
Location: Bristol, UK
Contact:

Re: MySQCL C Library

Post by zoneminder »

Hi Peter,

Well the good news is your build is fine, it only seems to be warnings.

The bad news is that you seem to have a problem with your mysql users and privileges. Have you created your users using 'grant' as per the readme, then used mysqladmin to reload the grant tables? If that has worked you should be able to do

mysql -u<user> -p<pass> zm

and get a prompt for both of your ZM users. If you can't then there's no point in going onto the ZM side of things until this is sorted. I would keep reading about mysql but also if you are root just doing

mysql mysql

should get you into the main database from where

select * from user;

and

select * from db;

will tell you what the current users and privileges are.

Phil,
carrthomas
Posts: 42
Joined: Tue Nov 25, 2003 10:11 pm

Re: MySQCL C Library

Post by carrthomas »

Hi Phil,

Great stuff, Thanks.

"I think I have fixed mysql "......until we meet again!

Much cleaner build now,

just this problem to solve.....

[root@localhost zm-0.9.16]# zmpkg.pl start
Bareword "ZM_PATH_LOGS" not allowed while "strict subs" in use at /usr/local/bin/zmpkg.pl line 62.
BEGIN not safe after errors--compilation aborted at /usr/local/bin/zmpkg.pl line 63.


any clues?

Peter
carrthomas
Posts: 42
Joined: Tue Nov 25, 2003 10:11 pm

Re: MySQCL C Library

Post by carrthomas »

What an earth is going on.........I have never uttered a Bareword in my life!
carrthomas
Posts: 42
Joined: Tue Nov 25, 2003 10:11 pm

Re: MySQCL C Library

Post by carrthomas »

Any help gratefully received
Thanks
Peter
User avatar
zoneminder
Site Admin
Posts: 5215
Joined: Wed Jul 09, 2003 2:07 pm
Location: Bristol, UK
Contact:

Re: MySQCL C Library

Post by zoneminder »

Hi Peter,

Errors like this would normally indicate that the configuration substitution is not taking place and the usual reason for this is that zmconfig.pl has not been run successfully.

Try running

perl zmconfig.pl -noi

from your top level ZM directory and see if you can see any errors. Alternatively (or additionally) if you are familiar with mysql, check the Config table has entries in it, specifically the ZM_PATH_LOGS one above.

Phil,
carrthomas
Posts: 42
Joined: Tue Nov 25, 2003 10:11 pm

Re: MySQCL C Library

Post by carrthomas »

Hi,

Still on the case and here is where I have got to:-

I tried running

perl zmconfig.pl -noi

from my top level ZM directory and saw no errors returned on the command line. (is that where I was supposed to be looking?)

1) Is it necessary to immediately follow with make and make install again after running zmconfig.noi? …or can I go right into using the command zmpkg.pl start

The Zone minder readme document then states :-
"Finally check zm_config.php in the web directory and amend any configuration necessary in there."

2) Trouble is ..I don't know what I am looking at.. to amend in zm_config.php, I don't understand what to do with this statement?

3) While browsing through the forum looking for clues, I have come across mention of an ebuild . Where is it? Would it be better for me to use it. Presumably I am following the manual install in the readme document.


Thanks for the help,

Peter
carrthomas
Posts: 42
Joined: Tue Nov 25, 2003 10:11 pm

Re: MySQCL C Library

Post by carrthomas »

Hi guys,

I am going round in circles......MYSQL has come back to haunt me:-


[root@localhost bin]# mysql mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 44 to server version: 3.23.52

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT select,insert,update,delete ON zm.* To peter@localhost IDENTIFIED BY 'thomas';
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye
[root@localhost bin]# mysqladmin reload
[root@localhost bin]# mysql -u -p zm
ERROR 1045: Access denied for user: '-p@localhost' (Using password: NO)
[root@localhost bin]#


Peter
User avatar
zoneminder
Site Admin
Posts: 5215
Joined: Wed Jul 09, 2003 2:07 pm
Location: Bristol, UK
Contact:

Re: MySQCL C Library

Post by zoneminder »

Hi Peter,

Doing this

GRANT select,insert,update,delete ON zm.* To peter@localhost IDENTIFIED BY 'thomas';

means that to access mysql you have to do this

mysql -upeter -pthomas zm

rather than what you wrote which was this

mysql -u -p zm

which basically means that you are saying your user is called '-p'.

Phil,
carrthomas
Posts: 42
Joined: Tue Nov 25, 2003 10:11 pm

Re: MySQCL C Library

Post by carrthomas »

Hi guys,

[root@localhost bin]# zmpkg.pl start
[root@localhost bin]#

Mozilla Browser now pointing to http://localhost/zm/zm.php

Fatal error: Call to undefined function: mysql_pconnect() in /var/www/html/zm/zm_db.php on line 22

Peter
tray
Posts: 12
Joined: Tue Nov 25, 2003 9:31 am

Re: MySQCL C Library

Post by tray »

Hi,

I'm afraid I'm not making much progress.
Here's a posting of the reponses I get from my RH9 system.

[root@localhost zm-0.9.16]# locate mysqlclient
/usr/lib/mysql/libmysqlclient.so.10.0.0
/usr/lib/mysql/libmysqlclient.so.10
/usr/lib/mysql/libmysqlclient_r.so.10.0.0
/usr/lib/mysql/libmysqlclient_r.so.10
/usr/lib/mysql/libmysqlclient.a
/usr/lib/mysql/libmysqlclient.so
/usr/lib/mysql/libmysqlclient_r.a
/usr/lib/mysql/libmysqlclient_r.so

[root@localhost zm-0.9.16]# rpm -qa | grep mysql
mod_auth_mysql-1.11-12
mysql-devel-3.23.54a-11
mysql-3.23.54a-11
mysql-server-3.23.54a-11
php-mysql-4.2.2-17
libdbi-dbd-mysql-0.6.5-5

[root@localhost zm-0.9.16]# ./configure with mysql=/usr
configure: WARNING: you should use --build, --host, --target
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
configure: error: You must call configure with the --with-mysql option.
This tells configure where to find the MySql C library and headers.
e.g. --with-mysql=/usr/local or –with-mysql=/usr

[root@localhost zm-0.9.16]# ./configure with mysql=/usr/local
configure: WARNING: you should use --build, --host, --target
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
configure: error: You must call configure with the --with-mysql option.
This tells configure where to find the MySql C library and headers.
e.g. --with-mysql=/usr/local or --with-mysql=/usr

I hope this will assist anyone in helping me.

Cheers,
Trevor
carrthomas
Posts: 42
Joined: Tue Nov 25, 2003 10:11 pm

Re: MySQCL C Library

Post by carrthomas »

Trevor


You wrote:- [root@localhost zm-0.9.16]# ./configure with mysql=/usr/local


Do not forget the "--" bit of the the whole command expression.



Peter .

PS

Good to see you are still hanging in there Trevor.

I'm stuck on another bit when I launch the browser I get:-

Fatal error: Call to undefined function: mysql_pconnect() in /var/www/html/zm/zm_db.php on line 22


Do you Know we started this journey on 25 Nov 2003?!
I want get it working by 25 Dec 2003 ;-).....!


My wife's car was broken into so I have burning desire to succeed with this project.

It will be a good xmas present.
carrthomas
Posts: 42
Joined: Tue Nov 25, 2003 10:11 pm

Re: MySQCL C Library

Post by carrthomas »

Hi,

when I launch the browser I get:-

Fatal error: Call to undefined function: mysql_pconnect() in /var/www/html/zm/zm_db.php on line 22

I believe my problem is PHP not compiled with MYSQL support

I have REDHAT 8

I need a configure statement to get any further

For example It could be:-

./configure --prefix=usr/local/php –with-mysql=/usr/local/bin/mysql --with-apxs2=/usr/local/apache2/bin/apxs

but it isn’t..... because Redhat put stuff in different paths.

How do I work out what to do to add the right options?

Thanks

Peter
Locked