Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

DBD-mysql installation on win7 64-bit

by dxxd116 (Beadle)
on Sep 19, 2012 at 03:27 UTC ( #994400=perlquestion: print w/replies, xml ) Need Help??
dxxd116 has asked for the wisdom of the Perl Monks concerning the following question:

Hey, Monks: I used "ppm install DBD-Mysql" to install the module. Even though the console show the installation is successful. When I tested it, it simply does not work as expected(Failing to connect to the database). However, I can install and DBD-MysqlPP correctly and get it work as expected. Please advise what to do in this case.

My "perl -V" produce the following:

Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Users\cai xingliang>ppm uninstall dbd::mysql DBD-mysql: uninstalled C:\Users\cai xingliang>ppm install dbd-mysql Downloading DBD-mysql-4.022...done Unpacking DBD-mysql-4.022...done Generating HTML for DBD-mysql-4.022...done Updating files in site area...done 12 files installed C:\Users\cai xingliang>cd /d d:/study/perl/test d:\study\perl\test> Database alive!1348024795 Database alive!1348024795 $VAR1 = bless( {}, 'DBI::db' ); DBI::db $VAR1 = bless( {}, 'DBI::db' ); Database alive!1348024795 d:\study\perl\test> Reconnecting to mysql server... Reconnecting to mysql server... Reconnecting to mysql server... Terminating on signal SIGINT(2) d:\study\perl\test>perl -V Summary of my perl5 (revision 5 version 16 subversion 0) configuration +: Platform: osname=MSWin32, osvers=5.2, archname=MSWin32-x64-multi-thread uname='' config_args='undef' hint=recommended, useposix=true, d_sigaction=undef useithreads=define, usemultiplicity=define useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=und +ef use64bitint=define, use64bitall=undef, uselongdouble=undef usemymalloc=n, bincompat5005=undef Compiler: cc='cl', ccflags ='-nologo -GF -W3 -MD -Zi -DNDEBUG -Ox -GL -fp:pr +ecise -DWIN32 -D_CONSOLE -DNO_STRICT -DWIN64 -DCON SERVATIVE -DPERL_TEXTMODE_SCRIPTS -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_ +CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO', optimize='-MD -Zi -DNDEBUG -Ox -GL -fp:precise', cppflags='-DWIN32' ccversion='14.00.40310.41', gccversion='', gccosandvers='' intsize=4, longsize=4, ptrsize=8, doublesize=8, byteorder=12345678 d_longlong=undef, longlongsize=8, d_longdbl=define, longdblsize=8 ivtype='__int64', ivsize=8, nvtype='double', nvsize=8, Off_t='__in +t64', lseeksize=8 alignbytes=8, prototype=define Linker and Libraries: ld='link', ldflags ='-nologo -nodefaultlib -debug -opt:ref,icf -lt +cg -libpath:"C:\Perl\lib\CORE" -machine:AMD64' libpth=\lib libs=oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.lib +comdlg32.lib advapi32.lib shell32.lib ole32.lib ol eaut32.lib netapi32.lib uuid.lib ws2_32.lib mpr.lib winmm.lib versio +n.lib odbc32.lib odbccp32.lib comctl32.lib buffero verflowU.lib msvcrt.lib perllibs=oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.l +ib comdlg32.lib advapi32.lib shell32.lib b oleaut32.lib netapi32.lib uuid.lib ws2_32.lib mpr.lib winmm.lib ve +rsion.lib odbc32.lib odbccp32.lib comctl32.lib buf feroverflowU.lib msvcrt.lib libc=msvcrt.lib, so=dll, useshrplib=true, libperl=perl516.lib gnulibc_version='' Dynamic Linking: dlsrc=dl_win32.xs, dlext=dll, d_dlsymun=undef, ccdlflags=' ' cccdlflags=' ', lddlflags='-dll -nologo -nodefaultlib -debug -opt: +ref,icf -ltcg -libpath:"C:\Perl\lib\CORE" -machi ne:AMD64' Characteristics of this binary (from libperl): Compile-time options: HAS_TIMES HAVE_INTERP_INTERN MULTIPLICITY PERLIO_LAYERS PERL_DONT_CREATE_GVSV PERL_IMPLICIT_CONTEXT PERL_IMPLICIT_SYS PERL_MALLOC_WRAP PERL_PRESERVE_IVUV PL_OP_SLAB +_ALLOC USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES USE_LOCALE USE_LOCALE_COLLATE USE_LOCALE_CTYPE USE_LOCALE_NUMERIC USE_PERLIO USE_PERL_ATOF USE_SITECUSTOMIZE Locally applied patches: ActivePerl Build 1600 [295879] Built under MSWin32 Compiled at Jun 11 2012 12:05:31 @INC: C:/Perl/site/lib C:/Perl/lib . d:\study\perl\test>

Replies are listed 'Best First'.
Re: DBD-mysql installation on win7 64-bit
by Anonymous Monk on Sep 20, 2012 at 07:02 UTC
    Try increasing verbosity, use  DBI->trace(2);
      I upgrade to the latest version of PERL 5.16.1. Then the problem is solved. Thank you any way.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://994400]
Approved by Jim
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (2)
As of 2017-03-26 10:34 GMT
Find Nodes?
    Voting Booth?
    Should Pluto Get Its Planethood Back?

    Results (315 votes). Check out past polls.