MySQCL C Library

Support and queries relating to all previous versions of ZoneMinder
tray
Posts: 12
Joined: Tue Nov 25, 2003 9:31 am

MySQCL C Library

Post 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??
User avatar
rdmelin
Posts: 863
Joined: Wed Oct 29, 2003 2:23 pm
Location: Ellensburg, WA USA

Re: MySQCL C Library

Post 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
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 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,
carrthomas
Posts: 42
Joined: Tue Nov 25, 2003 10:11 pm

Re: MySQCL C Library

Post 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
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 »

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,
tray
Posts: 12
Joined: Tue Nov 25, 2003 9:31 am

Re: MySQCL C Library

Post 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.
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 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,
carrthomas
Posts: 42
Joined: Tue Nov 25, 2003 10:11 pm

Re: MySQCL C Library

Post 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
carrthomas
Posts: 42
Joined: Tue Nov 25, 2003 10:11 pm

Re: MySQCL C Library

Post 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
dwhile
Posts: 16
Joined: Fri Nov 14, 2003 9:40 am

Re: MySQCL C Library

Post 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.
carrthomas
Posts: 42
Joined: Tue Nov 25, 2003 10:11 pm

Re: MySQCL C Library

Post 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
carrthomas
Posts: 42
Joined: Tue Nov 25, 2003 10:11 pm

Re: MySQCL C Library

Post 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
tray
Posts: 12
Joined: Tue Nov 25, 2003 9:31 am

Re: MySQCL C Library

Post 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
tray
Posts: 12
Joined: Tue Nov 25, 2003 9:31 am

Re: MySQCL C Library

Post 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
tray
Posts: 12
Joined: Tue Nov 25, 2003 9:31 am

Re: MySQCL C Library

Post by tray »

Don't know how that happened??
Locked