DBD::mysql on Windows 2008 Server x64

Damon Abruzere <[email protected]> Fri, 20 Mar 2009 16:43:35 -0400
Newsgroups gmane.comp.db.mysql.perl
Message-ID <D1F2F2C11BE75946AD595B3C28421F9EC3298B823A@MICKEYMOUSE.abruzere.com>
I can't figure out how to get dbd-mysql or DBD::mysql to install on my Windows Server 2008 64bit box...

Here's a referenced Forum I've been using to try to solicit an answer if it helps.
http://forums.movabletype.org/2009/03/installation-problem-with-dbdmysql.html

Here's my setup...

Server:
- Windows 2008 Server x64 Enterprise Edition
- IIS 7

ActiveState ActivePerl - 5.10.0.1004
- which, as I've found out does not have ppm gui for x64 yet...
- I'm using the CLI

MySQL Server - 5.1.32

MovableType - 4.24-en

____________________________________________________________
So, I've even downloaded the source files from CPAN

"DBD-mysql-4.010.tar.gz"

- I unpacked them in to a local folder...

and I've tried 2 different methods to get it to install.

____________________________________________________________
(1) Add the package to ppm
____________________________________________________________
C:\Perl64\cpan\build\DBD-mysql-4.010>ppm repo add C:\Perl64\cpan\build\DBD-mysql-4.010
Downloading C:\Perl64\cpan\build\DBD-mysql-4.010 packlist...not found
Downloading C:\Perl64\cpan\build\DBD-mysql-4.010 packlist...not found
Downloading C:\Perl64\cpan\build\DBD-mysql-4.010 packlist...done
Repo 3 added.

C:\Perl64\cpan\build\DBD-mysql-4.010>ppm repo list
┌────┬──────┬──────────────────────────────────────┐
│ id │ pkgs │ name                                 │
├────┼──────┼──────────────────────────────────────┤
│  1 │ 9994 │ ActiveState Package Repository       │
│  2 │    0 │ cpan.uwinnipeg.ca                    │
│  3 │    0 │ C:\Perl64\cpan\build\DBD-mysql-4.010 │
└────┴──────┴──────────────────────────────────────┘
 (3 enabled repositories)

C:\Perl64\cpan\build\DBD-mysql-4.010>ppm list

.............(It still doesn't show up in the list!)

For grins, I tried to do a ppm install, but it didn't find the package I need for DBD-MySql.... UGH...


So I move on to my attempt #2...
____________________________________________________________

(2) Compile my own using Manual Installation
____________________________________________________________

This didn't work either and appears to be a permissions thing, but I don't have a clue what to use??? Can someone offer any suggestions?


C:\Perl64\cpan\build\DBD-mysql-4.010>perl Makefile.PL "--cflags=-IC:\Program Files\MySQL\MySQL Server 5.1\include" "--libs=-LC:\Program Files\MySQL\MySQL Server 5.1\lib\opt -lmysqlclient -lz -lm -lcrypt -lnsl" "--testuser=adminstrator" "--testpassword=password"
I will use the following settings for compiling and testing:

  cflags        (User's choice) = -IC:\Program Files\MySQL\MySQL Server 5.1\include
  embedded      (guessed      ) =
  libs          (User's choice) = -LC:\Program Files\MySQL\MySQL Server 5.1\lib\opt -lmysqlclient -lz -lm -lcrypt -lnsl
  nocatchstderr (default      ) = 0
  nofoundrows   (default      ) = 0
  ssl           (guessed      ) = 0
  testdb        (default      ) = test
  testhost      (default      ) =
  testpassword  (User's choice) = password
  testsocket    (default      ) =
  testuser      (User's choice) = adminstrator

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

Failed to create t\mysql.mtest: Permission denied at Makefile.PL line 196.

Thanks for any help you can provide.

Damon Abruzere