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

I've recently compiled and installed Perl on my windows2000 worktation, now I want to get DBD::mysql working (Update: I'm not using ActivePerl, so no PPM for me). So I downloaded mysql source, compiled it, installed it, it runs fine and dandy. Now I download DBD::mysql, extract it and try to make. After several configuration attempts, I finally end up with: 
perl Makefile.PL --cflags=-I"C:\Progra~1\MySQL\include" "--libs=-LC:\P
+rogra~1\MySQL\lib\opt -lmysqlclient"

[download]
which is where I happened to install the various libraries.
This is the "install" file I used to copy the files from where I compiled them to the final directory: 
mkdir C:\progra~1\mysql\bin
mkdir C:\progra~1\mysql\data
mkdir C:\progra~1\mysql\share
mkdir C:\progra~1\mysql\scripts

mkdir C:\progra~1\mysql\include
mkdir C:\progra~1\mysql\lib
mkdir C:\progra~1\mysql\lib\debug
mkdir C:\progra~1\mysql\lib\opt

copy client_release\*.exe C:\progra~1\mysql\bin
copy client_debug\mysqld.exe C:\progra~1\mysql\bin\mysqld-debug.exe
xcopy scripts\*.* C:\progra~1\mysql\scripts /E
xcopy share\*.* C:\progra~1\mysql\share /E

copy lib_debug\mysqlclient.lib C:\progra~1\mysql\lib\debug
copy lib_debug\libmysql.* C:\progra~1\mysql\lib\debug
copy lib_debug\zlib.* C:\progra~1\mysql\lib\debug
copy lib_release\mysqlclient.lib C:\progra~1\mysql\lib\opt
copy lib_release\libmysql.* C:\progra~1\mysql\lib\opt
copy lib_release\zlib.* C:\progra~1\mysql\lib\opt
copy include\*.h C:\progra~1\mysql\include
copy libmysql\libmysql.def C:\progra~1\mysql\include

[download]
And this is the output of the above perl Makefile / nmake:

C:\.cpan\build\DBD-mysql-2.9004>perl Makefile.PL --cflags=-I"C:\Progra
+~1\MySQL\i
nclude" "--libs=-LC:\Progra~1\MySQL\lib\opt -lmysqlclient"
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
I will use the following settings for compiling and testing:

  cflags        (Users choice) = -IC:\Progra~1\MySQL\include
  libs          (Users choice) = -LC:\Progra~1\MySQL\lib\opt -lmysqlcl
+ient
  nocatchstderr (default     ) = 0
  nofoundrows   (default     ) = 0
  ssl           (guessed     ) = 0
  testdb        (default     ) = test
  testhost      (default     ) =
  testpassword  (default     ) =
  testuser      (default     ) =

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

Argument "6.21_02" isn't numeric in numeric ge (>=) at Makefile.PL lin
+e 89.
Using DBI 1.46 (for perl 5.009001 on MSWin32-x86-multi-thread) install
+ed in c:/p
erl/site/lib/auto/DBI/
Writing Makefile for DBD::mysql

C:\.cpan\build\DBD-mysql-2.9004>nmake

Microsoft (R) Program Maintenance Utility   Version 6.00.9782.0
Copyright (C) Microsoft Corp 1988-1998. All rights reserved.

        cl -c  -Ic:/perl/site/lib/auto/DBI/ -IC:\Progra~1\MySQL\includ
+e  -nologo
 -Gf -W3 -MD -DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FC
+RYPT -DPER
L_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -DPERL_MSVCRT_READ
+FIX -MD -D
NDEBUG -O1    -DVERSION=\"2.9004\"  -DXS_VERSION=\"2.9004\"  "-IC:\per
+l\lib\CORE
"   dbdimp.c
dbdimp.c
dbdimp.c(1373) : warning C4244: '=' : conversion from 'unsigned __int6
+4 ' to 'ch
ar ', possible loss of data
dbdimp.c(1636) : warning C4244: 'return' : conversion from 'unsigned _
+_int64 ' t
o 'int ', possible loss of data
dbdimp.c(1638) : warning C4244: 'return' : conversion from 'unsigned _
+_int64 ' t
o 'int ', possible loss of data
dbdimp.c(1699) : warning C4244: '=' : conversion from 'unsigned __int6
+4 ' to 'un
signed long ', possible loss of data
        cl -c  -Ic:/perl/site/lib/auto/DBI/ -IC:\Progra~1\MySQL\includ
+e  -nologo
 -Gf -W3 -MD -DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FC
+RYPT -DPER
L_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -DPERL_MSVCRT_READ
+FIX -MD -D
NDEBUG -O1    -DVERSION=\"2.9004\"  -DXS_VERSION=\"2.9004\"  "-IC:\per
+l\lib\CORE
"   mysql.c
mysql.c
mysql.xs(355) : warning C4013: 'is_prefix' undefined; assuming extern 
+returning
int
Running Mkbootstrap for DBD::mysql ()
        C:\perl\bin\perl.exe -MExtUtils::Command -e chmod 644 mysql.bs
        C:\perl\bin\perl.exe myld link -out:blib\arch\auto\DBD\mysql\m
+ysql.dll -
dll -nologo -nodefaultlib -release  -libpath:"c:\perl\lib\CORE"  -mach
+ine:x86 db
dimp.obj  mysql.obj   C:\perl\lib\CORE\perl59.lib C:\Progra~1\MySQL\li
+b\opt\mysq
lclient.lib "C:\Program Files\Microsoft Visual Studio\VC98\lib\oldname
+s.lib" "C:
\Program Files\Microsoft Visual Studio\VC98\lib\kernel32.lib" "C:\Prog
+ram Files\
Microsoft Visual Studio\VC98\lib\user32.lib" "C:\Program Files\Microso
+ft Visual
Studio\VC98\lib\gdi32.lib" "C:\Program Files\Microsoft Visual Studio\V
+C98\lib\wi
nspool.lib" "C:\Program Files\Microsoft Visual Studio\VC98\lib\comdlg3
+2.lib" "C:
\Program Files\Microsoft Visual Studio\VC98\lib\advapi32.lib" "C:\Prog
+ram Files\
Microsoft Visual Studio\VC98\lib\shell32.lib" "C:\Program Files\Micros
+oft Visual
 Studio\VC98\lib\ole32.lib" "C:\Program Files\Microsoft Visual Studio\
+VC98\lib\o
leaut32.lib" "C:\Program Files\Microsoft Visual Studio\VC98\lib\netapi
+32.lib" "C
:\Program Files\Microsoft Visual Studio\VC98\lib\uuid.lib" "C:\Program
+ Files\Mic
rosoft Visual Studio\VC98\lib\wsock32.lib" "C:\Program Files\Microsoft
+ Visual St
udio\VC98\lib\mpr.lib" "C:\Program Files\Microsoft Visual Studio\VC98\
+lib\winmm.
lib" "C:\Program Files\Microsoft Visual Studio\VC98\lib\version.lib" "
+C:\Program
 Files\Microsoft Visual Studio\VC98\lib\odbc32.lib" "C:\Program Files\
+Microsoft
Visual Studio\VC98\lib\odbccp32.lib" "C:\Program Files\Microsoft Visua
+l Studio\V
C98\lib\msvcrt.lib" -def:mysql.def
   Creating library blib\arch\auto\DBD\mysql\mysql.lib and object blib
+\arch\auto
\DBD\mysql\mysql.exp
mysqlclient.lib(mf_pack.obj) : error LNK2001: unresolved external symb
+ol __pctyp
e
mysqlclient.lib(mf_pack.obj) : error LNK2001: unresolved external symb
+ol ___mb_c
ur_max
blib\arch\auto\DBD\mysql\mysql.dll : fatal error LNK1120: 2 unresolved
+ externals

NMAKE : fatal error U1077: 'C:\perl\bin\perl.exe' : return code '0x600
+0'
Stop.

[download]
I googled for a while and found various references to linking to the 'release version', but as far as I can tell, thats what I'm doing. So I don't know. Anyone have a vague idea whaat I could try next?

Replies are listed 'Best First'.
Re: Win32 installing DBD::mysql, unresolved external symbol
by Animator (Hermit) on Jan 23, 2005 at 22:23 UTC

    Things went wrong during perl Makefile.PL.

    It tries to execute the mysql_config command, which should be in C:\Progra~1\MySQL\bin (check it?). This command returns the correct paths used by mysql (what the lib directory, is the include dir, ...).

    What you failed to do is add the C:\Progra~1\MySQL\bin to the PATH-environment variable (you can do this in the autoxexc.bat/nt file and/or via my computer (somewhere there is an option to do that).

[reply]
      Actually mysql_config wasn't in bin, but I did some hackery to make it work. It now finds mysql_config and generates the exact same error. Whups.
[reply]
Re: Win32 installing DBD::mysql, unresolved external symbol
by PodMaster (Abbot) on Jan 24, 2005 at 07:13 UTC
[reply]
      Thanks for the reply, I looked at my Makefile and it did indeed say "-MT" in the CCFLAGS variable. I tried changing that to all of the other variations you list in that node (-MD, -LD, etc), and none of them produce a different error. perl -V:ccflags produces 
      perl -V:ccflags
ccflags='-nologo -Gf -W3 -MD -DNDEBUG -O1 -DWIN32 -D_CONSOLE -DNO_STRI
+CT -DHAVE_
DES_FCRYPT  -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -
+DPERL_MSVC
RT_READFIX';

      [download]
      Which seems to be the same options that are in the CCFLAGS section of the make file for DBD::Mysql. Is there perhaps something else I need to change, or change else where?
[reply]
[d/l]
[select]
        What? perl -V:ccflags reveals the -MD option, which means link with MSVCRT.LIB . This means that mysqlclient.lib also needs to link with MSVCRT.LIB.

        MJD says "you can't just make shit up and expect the computer to know what you mean, retardo!"
        I run a Win32 PPM repository for perl 5.6.x and 5.8.x -- I take requests (README).
        ** The third rule of perl club is a statement of fact: pod is sexy.

[reply]
[d/l]

Back to Seekers of Perl Wisdom