Perl DBI && mysql

[waxox]

I am running into some problems installing the mysql module for the perl DBI on RH 7.
I am running into trouble with the Makefile.pl program. The program Makefile.pl needs to know where a couple of files are located (mysql.h && libmysqlclient.a or.so). I posted the output from the program at the bottom of this post.
First there is no mysql.h header file on my machine (so I made one && that worked ..so far). Second there is no libmysqlclient.a file on my machine. I have not been able to get around this problem. Here is the output of the Makfiel.pl program:

[my_bash_shell]# perl Makefile.pl
Which drivers do you want to install?

1) MySQL only
2) mSQL only (either of mSQL 1 or mSQL 2)
3) MySQL and mSQL (either of mSQL 1 or mSQL 2)

4) mSQL 1 and mSQL 2
5) MySQL, mSQL 1 and mSQL 2

Enter the appropriate number: [3] 1


Do you want to install the MysqlPerl emulation? You might keep your old
Mysql module (to be distinguished from DBD::mysql!) if you are concerned
about compatibility to existing applications! [n] n
Where is your MySQL installed? Please tell me the directory that
contains the subdir 'include'. [/usr] /usr/
Where is your MySQL installed? Please tell me the directory that
contains the subdir 'lib'. [/usr/] /usr/
Cannot find one of lib/mysql/libmysqlclient.a, lib/libmysqlclient.a, lib/mysql/libmysqlclient.so, lib/libmysqlclient.so in /usr/ at lib/DBD/mysql/Install.pm line 165, <STDIN> line 4.
[my_bash_shell]#

ps. I already have the perl DBI, Data-Dumper and Data-ShowTable modules installed with no problems (I tested && tested again).

:)

[kel]

It looks like its asking for the location of some files that go with MySQL applications(server/client).

Are you going to be installing MySQL? Do that first if you are. Then you'll have the information to input to the installer

[waxox]

I already have mysql installed on my system (seems to work fine). I installed mysql with the OS. I didn't install it myself manually so the location of the files were not known to me. I did search (grep) for the files with no luck.
It looks like its asking for the location of some files that go with MySQL applications(server/client).
Then you'll have the information to input to the installer

That is correct, but I cannot find the files that the "Msql-Mysql-module" is looking for and I already have mysql installed with a couple of databases created. I thought there might be something different about the RH 7 distro of mysql(-version 3.23.22).
:confused:

[kel]

Try looking in /usr/local/lib or /usr/local. I think that's where it usually installs to.

[waxox]

Try looking in /usr/local/lib or /usr/local. I think that's where it usually installs to.
If I had installed MySQL manually (not with the Distro), I would have installed it under /usr/local, but RH 7 installed MySQL for me and I cannot find where it (RH 7) put the files, or if they are even there at all.
They are def not under /usr/local/. I do have some similar files related to MySQL in /usr/lib/mysql/ (&& header files in /usr/include/) but not the exact ones the mSQL-MySQL-module is looking for. Any other suggestions?
:(

[kel]

Originally posted by waxox:

I do have some similar files related to MySQL in /usr/lib/mysql/ (&& header files in /usr/include/) but not the exact ones the mSQL-MySQL-module is looking for. Any other suggestions?

In the directory /usr/lib/mysql is there a directory called 'bin'(so the full pathe would be /usr/lib/mysql/bin)?

[waxox]

In the directory /usr/lib/mysql is there a directory called 'bin'(so the full pathe would be /usr/lib/mysql/bin)?
No there is no subdir(s) under /usr/lib/mysql/. Just two files named libmysqlclient.so.9 and libmysqlclient.so.9.0.0 .
:confused:


A programmer is a person who passes as an exacting expert on the basis of being able to turn out, after innumerable punching, an infinite series of incomprehensible answers calculated with micrometric precisions from vague assumptions based on debatable figures taken from inconclusive documents and carried out on instruments of problematical accuracy by persons of dubious reliability and questionable mentality for the avowed purpose of annoying and confounding a hopelessly defenseless department that was unfortunate enough to ask for the information in the first place.
-- IEEE Grid newsmagazine

[waxox]

I am changing distros to SuSE. RH 7 is so buggy :( .anyone else out there running RH 7 with MySQL and Perl?
Having a Database isn't terrible useful unless you can use it from your favorite programming language.

The doctrine of human equality reposes on this: that there is no man
really clever who has not found that he is stupid.
-- Gilbert K. Chesterson

[kel]

i am but I installed mysql myself, manually. Sorry I couldn't help more

[waxox]

thx for the feedback kel. I will post the answer to my problem when I figure it out (if I do). I have a feeling I am just going to have to re-install MySQL myself (manually, no distro). BUT I was hoping there might be an easier way.
Oh well, such is life.

ps. how can I make a backup of the MySQL databases I already have setup?

Military intelligence is a contradiction in terms.
-- Groucho Marx

egrep -n '^[a-z].*\(' $ | sort -t':' +2.0