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

Jose,

    This error indicates you do not have DBD::mysql installed or you don't
have it installed in the default locations.  You need to install the MySQL
Bundle from CPAN into it's default location or use lib to tell your script
where to find it.

Regards,
Pete
----
Peter P. Benac, CCNA
Celtic Spirit Networking
Providing Network and Systems Project Management and Installation and Web
Hosting.
Phone: 919-618-2557
Web: http://www.emacolet.com
Need quick reliable Systems or Network Management advice visit
http://www.nmsusers.org

To have principles...
             First have courage.. With principles comes integrity!!!




-----Original Message-----
From: jose isaias cabrera [mailto:[email protected]] 
Sent: Thursday, November 11, 2004 11:07 AM
To: [email protected]
Subject: 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]


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