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

Thanks Peter, but when I try to install it from CPAN, it prints this error
message:


  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

So, here is a better question: do I need to install the MySQL client on the
Unix server to be able to connect to MySQL server?



----- Original Message ----- 
From: "Peter P. Benac" <[email protected]>
To: "'jose isaias cabrera'" <[email protected]>;
<[email protected]>
Sent: Thursday, November 11, 2004 1:26 PM
Subject: 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]