This is the DBD for MySQL. When doing a:
perl Makefile.PL

I get the following:

(note: I have loaded MySQL server/client via RPM for RH 6.1, and it works peachy), also DBI is loaded, and so is perl

Here goes. . .

root@localhost Msql-Mysql-modules-1.2209]# 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]
Where is your MySQL installed? Please tell me the directory that
contains the subdir 'include'. [/usr/local] /usr/local
Cannot find one of include/mysql/mysql.h, include/mysql.h in /usr/local at lib/DBD/mysql/Install.pm line 165, <STDIN> chunk 3.
[root@localhost Msql-Mysql-modules-1.2209]#

doing a

find / -name mysql.h

comes up with nothing.

How, where, etc. can I get this file and the appropriate files to finish a proper install?

Thank you.

It wants to know where you installed mysql...

The default is /usr/local/mysql

Some people want to put it in the www directory, or other areas, such as /www/users/mysql

You need to give it the right path to the "mysql" subdirectory. That directory contains the following subdirectories:


Which is what it's looking for.



------------------
POSTCARDS.COM -- Everything Postcards on the Internet www.postcards.com
LinkSQL FAQ: www.postcards.com/FAQ/LinkSQL/

Pugdog,

I am missing something critical. I am going to ask a favor, which would be immensely helpful even though it appears absolutely like I should know this

Can you tell me exactly what files I need to have Links SQL operating. I have been downloading MySQL, Perl-DBI, blah blah, and everything goes peachy, and I have done a search for the files you have said, the directories:

find / -name pugdog's files

And it is missing something. So if you could, would, can you reply back with exactly the RPM's I need to finish this install, and where they are located?

I know your time is valueable, so if you can help me out, I'll send you some penguin caffeinated peppermints, if you e-mail me at daywizard@yahoo.com and lemme know a mailing address for you.

Needing some hand holding,

Daywizard

All you need to do -- really -- is find the path to your 'mysql' directory. Let's say it's in the default location /usr/local/


in answer to this question, (it's telling you exactly what it wants....) you'd make the path '/usr/local/mysql' since the 'include' directory is IN the 'mysql' directory. That's what I was showing you with the file list. It's just trying to find the location of where you put 'mysql'

Give that a try!

Well, what you really need is the mysql header files which you may not have even if you've installed mysql. If you used RPM's to install mysql, make sure you installed the 'Include files and libraries' rpm, not just the server and client tools.

If you installed the binary, or built from source, you should have the header files there and normally the DBD::mysql will find them on it's own.

How'd you setup mysql?

Cheers,

Alex

I set it up from RPM's and you are right, it is missing those header files (I suppose), basically mysql.h

What I'd like to know is what RPM holds this information? Which RPM specificially, because no matter how many RPM's I 'rpm' from mysql.com it doesn't seem to snag it.

Anyone want to give me the exact file name I would need, or the Perl -MCPAN one I would execute would do me a great favor.

Feel free to include a URL if you can.

Cheers,

DW

I don't use Linux, so the RPM's are a bit of a black art.

You could download the mysql tar file, and let it expand into a subdirectory, and copy the files over.

The mysql site has a pretty complete list of files for download, that would solve any install problem

Assuming you are on RedHat and an Intel machine (not mips), you want:

Server: http://www.mysql.com/...L-3.22.32-1.i386.rpm
Client: http://www.mysql.com/...t-3.22.32-1.i386.rpm
Headers: http://www.mysql.com/...l-3.22.32-1.i386.rpm
Libraries: http://www.mysql.com/...d-3.22.32-1.i386.rpm

and install them in that order and you should be set.

Cheers,

Alex