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

I am trying to befriend Perl and MySQL database as you
can see from my topic. Actually its a first time iam
here, so i decided to write to the seekers of the
wisdom forum.
OS - Win2000; Perl - 5.6.1 build 635; and mysql;
Trying to use PPM to install DBD::Mysql module.
Already have installed DBI through it. The problem is: 
PPM interactive shell (2.2.0) - type 'help' for available commands.
PPM> install DBD-Mysql
Install package 'DBD-Mysql?' (y/N): y
Installing package 'DBD-Mysql'...
Error installing package 'DBD-Mysql': Read a PPD for 'DBD-Mysql', but 
+it is not intended for this build
of Perl (MSWin32-x86-multi-thread)
PPM>

[download]

 
I have already tried to install it manually through the downloading DB
+D-Mysql.tar.gz and run the makefile.pl file but it gives the error :
C:\drv for mysql\Msql-Mysql-modules-1.2216>makefile.pl
Which drivers do you want to install?

1) MySQL only
2) mSQL only (either of mSQL 1 or mSQL 2)
3) MySQL and mSQL (either of mSQL 1 or mSQL 2)

4) mSQL 1 and mSQL 2
5) MySQL, mSQL 1 and mSQL 2

Enter the appropriate number: [3] 1


Do you want to install the MysqlPerl emulation? You might keep your ol
+d
Mysql module (to be distinguished from DBD::mysql!) if you are concern
+ed
about compatibility to existing applications! [n]
Where is your MySQL installed? Please tell me the directory that
contains the subdir 'include'. [C:/mysql]
Which database should I use for testing the MySQL drivers? [test]
On which host is database test running (hostname, ip address
or host:port) [localhost]
User name for connecting to database test? [undef]
Password for connecting to database test? [undef]
Creating files for MySQL ....................
Checking if your kit is complete...
Looks good
Warning: prerequisite DBI 1.08 not found at C:/Perl/lib/ExtUtils/MakeM
+aker.pm line 343.
Warning: prerequisite Data::ShowTable failed to load: Can't locate Dat
+a/ShowTable.pm in @INC (@INC conta
ins: lib C:/Perl/lib C:/Perl/site/lib .) at (eval 26) line 3.
WARNING from evaluation of C:\drv for mysql\Msql-Mysql-modules-1.2216\
+mysql/Makefile.PL: Can't locate DB
I/DBD.pm in @INC (@INC contains: lib C:/Perl/lib C:/Perl/site/lib .) a
+t (eval 38) line 6.
BEGIN failed--compilation aborted at (eval 38) line 6.
Writing Makefile for Msql-Mysql-modules

C:\drv for mysql\Msql-Mysql-modules-1.2216>makefile.pl
Which drivers do you want to install?

1) MySQL only
2) mSQL only (either of mSQL 1 or mSQL 2)
3) MySQL and mSQL (either of mSQL 1 or mSQL 2)

4) mSQL 1 and mSQL 2
5) MySQL, mSQL 1 and mSQL 2

Enter the appropriate number: [3] 1


Do you want to install the MysqlPerl emulation? You might keep your ol
+d
Mysql module (to be distinguished from DBD::mysql!) if you are concern
+ed
about compatibility to existing applications! [n]
Warning: prerequisite DBI 1.08 not found at C:/Perl/lib/ExtUtils/MakeM
+aker.pm line 343, <STDIN> line 2.
Warning: prerequisite Data::ShowTable failed to load: Can't locate Dat
+a/ShowTable.pm in @INC (@INC conta
ins: lib C:/Perl/lib C:/Perl/site/lib .) at (eval 18) line 3, <STDIN> 
+line 2.
WARNING from evaluation of C:\drv for mysql\Msql-Mysql-modules-1.2216\
+mysql/Makefile.PL: Can't locate DB
I/DBD.pm in @INC (@INC contains: lib C:/Perl/lib C:/Perl/site/lib .) a
+t (eval 30) line 6.
BEGIN failed--compilation aborted at (eval 30) line 6.
Writing Makefile for Msql-Mysql-modules

[download]

I have no idea what to do.
Iam sorry for this big amount of information, but we need it.
Why while i installing it through PPM my build is
not apropriate?( I upgraded it with latest version of
Perl just right after i started getting that problem.
I really Have to install Perl support for Mysql.
Please help me.

Replies are listed 'Best First'.
Re: Perl and MySQL database.
by dws (Chancellor) on Feb 17, 2003 at 01:41 UTC
    Odd. I'm also running ActiveState 5.6.1, and at this moment PPM doesn't find a DBD-MySQL in the AS repository, though there is a DBD-Mysql.zip in http://ppm.activestate.com/PPMPackages/zips/6xx-builds-only/.

    You could try downloading the .zip, extracting the .ppd, and installing it via PPM. (The "install" command accepts .ppd files in addition to URLs).

    My guess is that this is a temporary hiccup in the AS repository. They happen now and then.

[reply]
Re: Perl and MySQL database.
by PodMaster (Abbot) on Feb 17, 2003 at 04:28 UTC
    What are you PPM settings?

    PPM has a notoriously broken shell, it is best to first search, then describe before attempting to install a package.

    You should check out (but you shouldn't need it) DBD::mysqlPP - Pure Perl MySQL driver for the DBI .

    jasonk is right on the money about you not having DBI installed (you may actually have DBI, but you need version 1.08 or higher)

    Why while i installing it through PPM my build is not apropriate?
    What are you PPM settings? (trying to use a 5.8x/5.5x repository with perl 5.6x ain't gonna fly)
    If you're sure you got the correct version, there is a program at my repository ( http://crazyinsomniac.perlmonk.org/perl/ppm/ ) which will help you install a package without the ppm shell (the very first releases of ActivePerl5.8 generated incorrect version signatures for the PPD's, and there were some other problems, so I ripped this out of the shell, to do a brute force install).

    I upgraded it with latest version of Perl ...
    That is not possible. The latest version of perl is 5.8.

    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.6x+5.8x. I take requests.
    ** The Third rule of perl club is a statement of fact: pod is sexy.

[reply]
Re: Perl and MySQL database.
by jasonk (Parson) on Feb 17, 2003 at 01:15 UTC

    I don't run windows, so I can't tell you why ppd isn't working, but the error message from when you tried to install it yourself is pretty clear, you have to have DBI installed before you can install DBD modules, the DBD modules can't work without DBI.

[reply]
Re: Perl and MySQL database.
by Hagbone (Monk) on Feb 17, 2003 at 01:47 UTC
    My only experience is with *nix as well, but I'd suggest trying the code below to confirm that DBI is available (as you say it is) .... if it is, then the list of drivers should include "mysql" if you have sucessfully loaded it. 
    #! /usr/bin/perl
use CGI;
use DBI;
print "DBI appears to be OK\n";
@driver_names = DBI->available_drivers ();
print "These DBI drivers are available: @driver_names\n";
exit (0);

    [download]
[reply]
[d/l]
Re: Perl and MySQL database.
by rdfield (Priest) on Feb 17, 2003 at 09:12 UTC
    Have you tried using ppm3? It looks in a different place in the Activestate hierarchy for its downloads, and may work better for you.

    rdfield

[reply]

Back to Seekers of Perl Wisdom