MySQL newbie: Failed to determine directory of mysql.h

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:

#/h/jicman/bin/perl -w
use DBI;

my $h = 'sqlhost.mydsn.net';
my $dsn = "DBI:mysql:my_database:$h";
my $db_user_name = 'admin';
my $db_password = 'secret';
my ($id, $password);
my $dbh = DBI->connect($dsn, $db_user_name, $db_password);

and I get this error:


Using CPAN to download DBD::mysql driver, I get this error message:

install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC
contains: /h/jicman/lib/perl5/5.8.5/sun4 /h/jicman/lib/perl5/5.8.5
/h/jicman/lib/perl5/5.8.5/sun4 /h/jicman/lib/perl5/site_perl/5.8.5
/h/jicman/lib/perl5/site_perl ~jicman/lib/perl .) at (eval 1) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Multiplex, Proxy, Sponge.
 at Macros/MySQL.pl line 9

So, I go to CPAN and try to install that module

cpan> install DBD::mysql
CPAN: Storable loaded ok
Going to read /h/jicman/.cpan/Metadata
  Database was generated on Wed, 03 Nov 2004 09:08:40 GMT
Running install for module DBD::mysql
Running make for R/RU/RUDY/DBD-mysql-2.9004.tar.gz
CPAN: Digest::MD5 loaded ok
Checksum for
/h/jicman/.cpan/sources/authors/id/R/RU/RUDY/DBD-mysql-2.9004.tar.gz ok
x DBD-mysql-2.9004, 0 bytes, 0 tape blocks
x DBD-mysql-2.9004/t, 0 bytes, 0 tape blocks
x DBD-mysql-2.9004/t/mysql2.t, 4187 bytes, 9 tape blocks
x DBD-mysql-2.9004/t/akmisc.t, 27024 bytes, 53 tape blocks
...
...
x DBD-mysql-2.9004/ChangeLog, 40311 bytes, 79 tape blocks
x DBD-mysql-2.9004/constants.h, 1937 bytes, 4 tape blocks
x DBD-mysql-2.9004/TODO, 896 bytes, 2 tape blocks
Removing previously used /h/jicman/.cpan/build/DBD-mysql-2.9004

  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.
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.
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.
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.
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.
Failed to determine directory of mysql.h. Use

  perl Makefile.PL --cflags=-I<dir>

to set this directory. For details see the INSTALL.html file,
section "C Compiler flags" or type

  perl Makefile.PL --help
Running make test
  Make had some problems, maybe interrupted? Won't test
Running make install
  Make had some problems, maybe interrupted? Won't install

--

What can I do to fix this problem?  Don't forget that I am working from an
Unix server without root password.

thanks,

josé


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]