Page 1 of 3

MySQCL C Library

Posted: Tue Nov 25, 2003 9:37 am
by tray
Hello,
Iim trying to install zoneminder, after running "./configure--with-mysql=/Usr/Local" I get an error
"You must call configure with the --with-mysql option"
"e.g. --with-mysql=/usr/local"

How can I identify the MySQL root location??

Re: MySQCL C Library

Posted: Tue Nov 25, 2003 4:19 pm
by rdmelin
Hi trevor,
It may be a typo in your post but /Usr/Local and /usr/local are not equivalent. The path is case sensitive. Also you need a space between configure and any options.
Next many current distros install MySQL in /usr . You might just look in /usr/share for mysql or run the command "locate mysql"
Hope this helps. :)

ross

Re: MySQCL C Library

Posted: Tue Nov 25, 2003 10:01 pm
by zoneminder
Hi Trevor,

I would suggest starting with --with-mysql=/usr and if that doesn't work do the 'locate' as Ross suggested and let us know.

Phil,

Re: MySQCL C Library

Posted: Tue Nov 25, 2003 10:51 pm
by carrthomas
Hi,

I am also trying to install ZM.
I have RedHat 8

'locate' shows mysql in /usr/share/mysql (with files errmsg.sys and errmsg.txt in the folder.)
also 'locate' shows mysql in /usr/lib/mysql and /var/lib/mysql and /usr/bin/mysql

which one do I need?

Also how do I know if mysql is the development installation needed and not the runtime one.

Thanks

Peter Thomas

Re: MySQCL C Library

Posted: Tue Nov 25, 2003 11:09 pm
by zoneminder
I would try --with-mysql=/usr as I mentioned earlier. Try doing a 'locate libmysqlclient.a' as that is the important one, or just 'locate libmysql' incase I have any typos.

Phil,

Re: MySQCL C Library

Posted: Wed Nov 26, 2003 8:29 am
by tray
Hi Guys,

Good to see the replies to my first ever post.

Yep, I realise linux is case sensitive, but the text-complete function in gnome counters some of this when combined with copy & paste.

Using 'Locate libmysqlclient.a' I get no results just a new prompt.

The location of mysql appears to be /usr/local/mysql

So my question now is what package do I need to add to my system. I have Red Hat 9, mysql 3.23.54a. Essentially the same question as Peter Thomas.

Cheers.

Re: MySQCL C Library

Posted: Wed Nov 26, 2003 9:10 am
by zoneminder
Hi Trevor,

I also have a RH9 system and this is what I've got on mine (from doing 'rpm -qa | grep mysql' )

mysql-server-3.23.58-1.9
mysql-devel-3.23.58-1.9
libdbi-dbd-mysql-0.6.5-5
mysql-3.23.58-1.9
mod_auth_mysql-1.11-12
php-mysql-4.2.2-17.2

Of these I think you can ignore the mod_auth one at least but having the rest on the system should get you a bit further. Strangely enough, considering we're both RH9, my mysql has been installed below /usr and not /usr/local.

Phil,

Re: MySQCL C Library

Posted: Wed Nov 26, 2003 5:50 pm
by carrthomas
Hi guys,

looks like I'm maybe out of luck on RH8.

rpm -qa`¦ grep myql gives:-

mysql -3.23.5.52-3
mysql-server-3.23.52-3

is all I have got!

'locate' does not find libmysqlclient.a either.

What should I go looking for on google for development use?

(APOLOGIES....... but I am on a steep learning curve guys !)

Peter

Re: MySQCL C Library

Posted: Thu Nov 27, 2003 12:16 am
by carrthomas
configure: error : zm requires libmysqlclient.a

I believe from google that RH8 has everything I need... I just need to include the development bits in my build for mysql? Is there a way to patch them in from my CD?


Thanks

Peter

Re: MySQCL C Library

Posted: Thu Nov 27, 2003 10:16 am
by dwhile
Assuming you have the RH8 disks then
insert disk 2 into the drive (it is disk 2 on RH9 so I hope its the same on RH8!)

as root type:

mount -v cdrom
cd /mnt/cdrom/RedHat/RPMS
rpm -Uvh mysql-3*.rpm
rpm -Uvh mysql-devel*.rpm
umount -v cdrom


That should have installed the mysql bits for you. One problem you might come across is that there may be packages on which they depend which aren't installed so the rpm command will fail.

Re: MySQCL C Library

Posted: Thu Nov 27, 2003 8:04 pm
by carrthomas
Day 4 Base camp1

I feel like my kid sister just kicked my LEGO.


As root I RPM'd as suggested . No problems (Thanks David)

Now I have

mysql-devel-3.23.52-3
mysql-3.23.52-3
mysql-server-3.23.52-3

I still get error on ./ configure as follows:-

checking for mysql_init in -lmsqlclient....no
configure:error : zm requires libmysqlclient.a



I know libmysqlclient.a is in /usr/lib/mysql because I can find it there now!

................:(

Peter

Re: MySQCL C Library

Posted: Thu Nov 27, 2003 10:19 pm
by carrthomas
Day 4 Base Camp 1 Sunshine at last!

./configure with all the trimmings now gives:-

configure:WARNING: now run 'Perl zmconfig.pl' to create your ZoneMinder configuration

on we go........

Thanks for the help

Peter

Re: MySQCL C Library

Posted: Mon Dec 01, 2003 7:05 am
by tray
Hi Guys,

Still no joy!
I've got the location of libmyclient; /usr/lib/mysql The problem is libmysqlclient.a isn't present only .so.10.0.0, .so.10, client_r.so.10.0.0.

I've got all the programs listed as per Philip Coombes. (however different versions)

I'm in the motions of finding if I require libmysqlclient.a ??
Also do I specify /usr/lib/mysql as the MySQL Root?? According to 'locate mysql' no mysql files exist under /usr/local/ or /usr

TDK
RH9 user

Re: MySQCL C Library

Posted: Mon Dec 01, 2003 7:20 am
by tray
Hi Guys,

Still no joy!
I've got the location of libmyclient; /usr/lib/mysql The problem is libmysqlclient.a isn't present only .so.10.0.0, .so.10, client_r.so.10.0.0.

I've got all the programs listed as per Philip Coombes. (however different versions)

I'm in the motions of finding if I require libmysqlclient.a ??
Also do I specify /usr/lib/mysql as the MySQL Root?? According to 'locate mysql' no mysql files exist under /usr/local/ or /usr

TDK
RH9 user

Re: MySQCL C Library

Posted: Mon Dec 01, 2003 7:25 am
by tray
Don't know how that happened??