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