Running on 5.8.0 804

by john on January 2, 2003

I finally managed to get MT installed under ActivePerl 5.8.0 build 804. As I had previously mentioned, I’m not the only one having this problem, which is also evidenced by the number of referal entries I’m getting to those articles.

Hopefully this information will help someone. I’m just going to detail the two specific things that I believe are causing the trouble for most people, if anyone needs more details please let me know.


Issue #1
DBD-mysql is a module required by MT if you are using a mySQL backend but for some reason it isn’t in ActiveState’s default PPM repository and it is a bear to find on Jochen’s site. Go here to get it.

Issue #2
There is a file in the mysql\bin directory called libmysql.dll which is now required to be in your path, whereas with earlier versions of DBD-msql it was not. So either add that directory to your path or copy the file to c:\winnt\system32

Now that I’m running Apache with mod_perl the next project is to get MT running under it. Later.

{ 19 comments }

Chris January 4, 2003 at 4:12 am

Great!

I saw your hints from the MT Support Forum regarding Issue #1, John, and got that part solved, but it was Issue #2 that completely threw me. I’d never have found it out. Thanks!

john January 4, 2003 at 9:53 am

Glad to be of help!

The way I finally figured this out was that I ran mt-check.cgi from the command line rather than as a CGI from the web server. Windows then threw the error which made the problem clear.

ben January 28, 2003 at 6:48 pm

Hello I cant find the libmysql.dll I only find mysql.dll I placed that into my windows/system32 folder but to no avail please can you help?

I have install the DBI and DBD:mysql modules

john January 30, 2003 at 10:22 pm

What version of MYSQL do you have installed?

Pyran February 9, 2003 at 4:22 am

Doing a search on my box, I found it in c:\Program Files\mysql\lib\debug.

Michael February 12, 2003 at 11:46 am

Actually, it’s as simple as that: Execute

ppm install http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd

in your perl directory to get dbd-mysql

Marc February 23, 2003 at 8:49 am

John,

I don’t understand what I need to do to resolve the problem with Activestate. Please help.

john February 23, 2003 at 8:52 am

Have you gone through the steps documented here?

Marc February 23, 2003 at 9:02 am

Well, I don’t understand step #2, add it to what path? and how?

Sorry, fairly new to this.

john February 23, 2003 at 9:21 am

Probably would be easiest then just to copy that file to your windows system directory, which is most likely c:\winnt\system32

Marc February 23, 2003 at 9:31 am

I did that, well, I copied the file to c:\windows\system32 since I’m running this on XPHome.

Marc February 23, 2003 at 9:31 am

I did that, well, I copied the file to c:\windows\system32 since I’m running this on XPHome.

Still, when I run mt-check.cgi it says its not installed.

john February 23, 2003 at 10:03 am

Try running mt-check.cgi from the command line instead of your browser to see if any errors pop up that give you a clue.

perl mt-check.cgi

Marc February 23, 2003 at 10:11 am

It says the same thing as it did when run from the web.

Here is the error i get when i run mt.cgi

install_driver(mysql) failed: Can’t locate DBD/mysql.pm in @INC (@INC contains: c:\w\WEBSER~1\_scribs.net\www\mt\extlib c:\w\WEBSER~1\_scribs.net\www\mt\lib c:/perl/lib c:/perl/site/lib .) at (eval 4) line 3.
Perhaps the DBD::mysql perl module hasn’t been fully installed,
or perhaps the capitalisation of ‘mysql’ isn’t right.
Available drivers: ExampleP, Proxy, mysqlPP.

john February 23, 2003 at 10:17 am

I’m really not sure – my last suggestion is to verify you have a mysql.pm if not then try step 1 again.

Marc February 23, 2003 at 10:27 am

Its installed with Activeperl…

Marc February 23, 2003 at 10:34 am

Can I get perl for win32 from some place besides Activestate? They seem to suck major %(#@ ?

M Mitchell April 10, 2003 at 8:44 am

Thank you. I have been struggling with this for days. The path to the DLL fixed my problem on ActiveState Perl 5.8 + mySQL, so now I can run Mason on Win32 with mySQL access. Thanks.

Wei Yang May 5, 2004 at 4:49 pm

Since my PC is behind a firwall, I cannot just install DBD-mysql.ppd directly from a web site, so I copied the file to my local drive and tried to install it but got the following error:

C:\Perl\bin>ppm install C:\Perl\packages\DBD-mysql.ppd
Error: no suitable installation target found for package DBD-mysql.

Can anyone help?

Thanks,

Wei

Previous post:

Next post: