MySQCL C Library

[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??

[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

[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]

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

[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]

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.

[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]

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]

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]

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]

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]

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]

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]

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]

Don't know how that happened??