Re: MySQL newbie: Failed to determine directory of mysql.h

On Thu, Nov 11, 2004 at 11:06:55AM -0500, jose isaias cabrera wrote:
> 
> Greetings!
> 
> I am trying to connect from a unix server to a Windows 2000 MySQL server and
> I am having problems with the DBD::mysql perl module.  Here is the program:
[snip program]
> install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC
[snip the rest of the error message]
> 
> So, I go to CPAN and try to install that module
> 
> cpan> install DBD::mysql
[snip]
>   CPAN.pm: Going to build R/RU/RUDY/DBD-mysql-2.9004.tar.gz
> 
> Can't exec "mysql_config": No such file or directory at Makefile.PL line
> 174.
> readline() on closed filehandle PIPE at Makefile.PL line 176.
[snip]
> Failed to determine directory of mysql.h. Use

Yes, as you guessed correctly in the other message, since you have
neither mysql_config nor mysql.h on your system, this means that the
system is missing the MySQL client libraries.

What you need to do now is fetch the MySQL client source from
http://www.mysql.com/ (I personally would recommend version 4.0 or 4.1),
then compile and install them in your home dir (the MySQL configure
script honors the --prefix option, so you would want to configure it
with --prefix=/h/jicman).  After that, if /h/jicman/bin/ is in your
PATH, the DBD::mysql configuration should be able to find the
mysql_config binary, which would tell it where to find the MySQL header
files and libraries.

Hope this helps.

G'luck,
Peter

-- 
Peter Pentchev	[email protected]    [email protected]    [email protected]
PGP key:	http://people.FreeBSD.org/~roam/roam.key.asc
Key fingerprint	FDBA FD79 C26F 3C51 C95E  DF9E ED18 B68D 1619 4553
If there were no counterfactuals, this sentence would not have been paradoxical.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (FreeBSD)

iD8DBQFBlGgZ7Ri2jRYZRVMRAriVAJ9TEbWJBJtNGbSO1j0gKT0FkEH0aACfQ9Yo
JQOBPY9bwX21/dn1op163dc=
=YgYQ
-----END PGP SIGNATURE-----