Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Activestate 5.8 + DBD-mysql a no-go?

by Phaysis (Pilgrim)
on Jan 07, 2003 at 15:14 UTC ( [id://224986] : perlquestion . print w/replies, xml ) Need Help??

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

I have a major issue I've not been able to resolve yet; was wondering if anyone else has come across this problem and has found a solution. I upgraded my Activestate 5.00x installation last night to 5.8. I began running different scripts to determine how much the new upgrade has broken things. Much to my displeasure, things where broken indeed.

Most of my dependancy problems were solved by installing missing modules from the Activestate ppm archives. However, there's one that can't be resolved: my major problem is that DBD::mysql no longer exists for Activestate, at least not this version. I need that module.

What AS has offered as a replacement is DBD::mysqlPP, a "pure perl" version of the mysql driver. Might be fine and all but apparently socket/pipe support (which is used by the mysqlPP driver) is not properly configured out of the box. So, I copied the DBD/mysql.pm module from my AS 5.00x backup into the new directory, and DBI does not see the module in its driver list. I plan to do more investigation this evening, but I do not see a decent solution.

If I can't get this resolved, I'll have to get the socket/pipe support needed by DBD-mysqlPP working and will have to update (!!) all of my scripts which have previously used the DBD::mysql driver to use the DBD::mysqlPP driver. So much for cross-platform development.

Is something wrong with this picture, or am I looking at the picture wrong? I use Activestate on Win98se as a testbed for my linux webserver projects. If I can't get my scripts to work cross-platform, there's little sense in using this testbed for more rapid development. I'm now considering going back to AS 5.00x just to keep myself sane.

Does any of this make sense?

-Shawn / (Ph) Phaysis
If idle hands are the tools of the devil, are idol tools the hands of god?

Replies are listed 'Best First'.
Re: Activestate 5.8 + DBD-mysql a no-go?
by bart (Canon) on Jan 07, 2003 at 19:34 UTC
    Sorry I can't be of any immediate assistence... but IMO, you should ask on the DBI-users mailing list. Many of the DBD developers are on that list, and perhaps somebody can even help you to a binary build of DBD::mysql for your platform.

    To subscribe: http://lists.perl.org/showlist.cgi?name=dbi-users

Re: Activestate 5.8 + DBD-mysql a no-go?
by CountZero (Bishop) on Jan 07, 2003 at 22:02 UTC

    DBD::mysql works for AS Perl 5.6, so you could always upgrade to Perl 5.6 ;-)

    As far as Perl 5.8 is concerned, have a look at this.

    CountZero

    "If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law

      Hmm.

      Thanks for the pointer. I tried it; installed without a hitch under ppm3. However, it doesn't work. Says something like this:

      install_driver(mysql) failed: Can't load 'C:/Perl/site/lib/auto/DBD/my +sql/mysql.dll' for module DBD::mysql: load_file:One of the library fi +les needed to run this application cannot be found at C:/Perl/lib/Dyn +aLoader.pm line 229. at (eval 1) line 3
      Not sure what to do. I take it that the precompiled binaries in the ppd aren't statically linked and they're needing a library file (Which one? Doesn't say) that doesn't exist on my system. ::sighs::

      I'm thinking about downgrading back to ActivePerl 5.6 so I can get some sanity back. I'll come back around to 5.8 when ActiveState catches up. (muted grumbling)

      -Shawn / (Ph) Phaysis
      If idle hands are the tools of the devil, are idol tools the hands of god?

        Same old, same old, do it by hand, visit http://crazyinsomniac.perlmonk.org/perl/ppm/ for help+.

        You should also view some of the threads I mention PPM in, as they discuss resolving problems with PPM


        MJD says you can't just make shit up and expect the computer to know what you mean, retardo!
        ** The Third rule of perl club is a statement of fact: pod is sexy.

        It looks like you need mysql.dll at 'c:/Perl/site/lib/auto/DBD/mysql/mysql.dll'

        I checked my (Perl 5.6) installation and I indeed found this mysql.dll at that location. Perhaps the 5.6 version will work for 5.8 too.

        I'll be happy to e-mail you this mysql.dll if you give me your e-mail address.

        CountZero (karl.moens at marsh dot com / karl.moens at pandora dot be)

        "If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law