Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Error on installing DBD::mysql

by Anonymous Monk
on Sep 04, 2009 at 05:55 UTC ( [id://793369]=perlquestion: print w/replies, xml ) Need Help??

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Hi,

I am trying to install DBD::mysql. But I am getting following error message.
Could you please help me.

Error Mesage :

D:\DBD-mysql-4.012>perl Makefile.PL

mysql_config.pl, and an associated bat file, has been
successfully created under
   C:\wamp\bin\mysql\MYSQL5~1.36\bin

Unknown option: testdb
Unknown option: testhost
Unknown option: testuser


PLEASE NOTE:

For 'make test' to run properly, you must ensure that the
database user '' can connect to your MySQL server
and has the proper privileges that these tests require such
as 'drop table', 'create table', 'drop procedure', 'create procedure'
as well as others.

mysql> grant all privileges on test.* to ''@'localhost' identified by 's3kr1t';

You can also optionally set the user to run 'make test' with:

perl Makefile.pl --testuser=username

Unknown option: testpassword
Unknown option: testsocket
Unknown option: nocatchstderr
Unknown option: ssl
Unknown option: nofoundrows
Unknown option: force-embedded
I will use the following settings for compiling and testing:

  cflags        (mysql_config) = -I"C:\wamp\bin\mysql\MYSQL5~1.36\include"
  embedded      (mysql_config) =
  libs          (mysql_config) = -LC:\wamp\bin\mysql\MYSQL5~1.36\lib\opt -lmysql
client -lzlib
  mysql_config  (guessed     ) = mysql_config
  nocatchstderr (default     ) = 0
  nofoundrows   (default     ) = 0
  ssl           (guessed     ) = 0
  testdb        (default     ) = test
  testhost      (default     ) =
  testpassword  (default     ) =
  testsocket    (default     ) =
  testuser      (guessed     ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Argument "6.42_01" isn't numeric in numeric ge (>=) at Makefile.PL line 350, <PI
PE> line 75.
Checking if your kit is complete...
Looks good
Note (probably harmless): No library found for -lmysqlclient
Note (probably harmless): No library found for -lzlib
Note (probably harmless): No library found for oldnames.lib
Note (probably harmless): No library found for kernel32.lib
Note (probably harmless): No library found for user32.lib
Note (probably harmless): No library found for gdi32.lib
Note (probably harmless): No library found for winspool.lib
Note (probably harmless): No library found for comdlg32.lib
Note (probably harmless): No library found for advapi32.lib
Note (probably harmless): No library found for shell32.lib
Note (probably harmless): No library found for ole32.lib
Note (probably harmless): No library found for oleaut32.lib
Note (probably harmless): No library found for netapi32.lib
Note (probably harmless): No library found for uuid.lib
Note (probably harmless): No library found for ws2_32.lib
Note (probably harmless): No library found for mpr.lib
Note (probably harmless): No library found for winmm.lib
Note (probably harmless): No library found for version.lib
Note (probably harmless): No library found for odbc32.lib
Note (probably harmless): No library found for odbccp32.lib
Note (probably harmless): No library found for msvcrt.lib
*** You're using Microsoft Visual C++ compiler or similar but
    the LIB and INCLUDE environment variables are not both set.

    You need to run the VCVARS32.BAT batch file that was supplied
    with the compiler before you can use it.

    A copy of vcvars32.bat can typically be found in the following
    directories under your Visual Studio install directory:
        Visual C++ 6.0:     vc98\bin
        Visual Studio .NET: vc7\bin

    Find it, run it, then retry this.

    If you think this error is not correct then just set the LIB and
    INCLUDE environment variables to some value to disable the check. 
Thanks
Ashok

Replies are listed 'Best First'.
Re: Error on installing DBD::mysql
by Burak (Chaplain) on Sep 04, 2009 at 06:09 UTC
    The error message seems to be quite clear. Compiling DBD::mysql can be a complex issue on Windows. I suggest installing through ppm
    C:\>ppm-shell ppm 4.03 Copyright (C) 2007 ActiveState Software Inc. All rights reserved. ppm> install DBD::mysql
Re: Error on installing DBD::mysql
by Anonymous Monk on Sep 04, 2009 at 06:10 UTC
Re: Error on installing DBD::mysql
by Sinistral (Monsignor) on Sep 04, 2009 at 17:42 UTC

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://793369]
Approved by Burak
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others sharing their wisdom with the Monastery: (5)
As of 2024-04-24 18:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found