EQEmulator Forums - Peal is giveing me issues..

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)

- - Peal is giveing me issues.. (https://www.eqemulator.org/forums/showthread.php?t=24578)

Peal is giveing me issues..

I'm following the wiki and I'm at the Pearl install commands. The issue is a missing file.

Code:

ppm> install DBD-mysql

====================

Install 'DBD-mysql' version 3.0002 in ActivePerl 5.8.7.813.

====================

====================

Install 'DBD-mysql' version 3.0002 in ActivePerl 5.8.7.813.

====================

Error: error downloading 'http://ppm.activestate.com/PPMPackages/5.8-windows/MSW

in32-x86-multi-thread-5.8/DBD-mysql-3.0002.tar.gz': 404 Not Found

ppm>

I've done some digging and located two files that MAY work, but I'm not sure how to get Pearl to use the new URL found...
INDEX FOUND HERE

I'm guessing one of these:
DBD-mysql-SimpleMySQL-0.5.tar.gz
DBD-mysqlPP-0.04.tar.gz

This change is likely due to the recent changes with MYSQL..

Quote:

On 16 January 2008, less than six weeks ago, Sun announced their definitive agreement to acquire MySQL AB.

Any thoughts on a fix or workaround?

Thks.

I located a valid link for the correct file, now to get it installed somehow.

http://search.cpan.org/CPAN/authors/...-3.0002.tar.gz

Still open to ideas as I learn on the job here.

Quote:

Originally Posted by RamsiMage (Post 144223)

now to get it installed somehow.

Luckily, there is an INSTALL.html file in DBD-mysql-3.0002.tar.gz:

Quote:

Windows

ActivePerl offers a PPM archive of DBD::mysql. All you need to do is typing

ppm
install DBI
install DBD-mysql

This will fetch the modules via HTTP and install them. If you need to use a WWW proxy server, the environment variable HTTP_proxy must be set:

set HTTP_proxy=http://my.proxy.server:8000/
ppm
install DBI
install DBD-mysql

Of course you need to replace the host name my.proxy.server and the port number 8000 with your local values.

If the above procedure doesn't work, please upgrade to the latest version of ActivePerl. Versions before build 623 are known to have problems.

PPM 3 is said to miss DBD::mysql in the repository. Thus use of PPM 3 is discouraged, in favour of PPM 2. If you need to use PPM 3, try

ppm
rep add PPM2 http://ppm.activestate.com/PPMPackages/5.6plus/
rep 2
install DBI
install DBD-mysql

Hopefully, that should get you up and running.

Thanks for the swift reply. Much appreciated.

Well.. Here's what I ended up doing:

Code:

ppm> rep add PPM3 D:\EMU_SERVER

Repositories:

[1] ActiveState Package Repository

[2] ActiveState PPM2 Repository

[3] PPM3

ppm> install DBD-mysql

====================

Install 'DBD-mysql' version 3.0002 in ActivePerl 5.8.7.813.

====================

====================

Install 'DBD-mysql' version 3.0002 in ActivePerl 5.8.7.813.

====================

Error: Package 'DBD-mysql' not found. Please 'search' for it first.

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

====================

Install 'DBD-mysql' version 4.005 in ActivePerl 5.8.7.813.

====================

Downloaded 1000326 bytes.

Extracting 40/40: blib

Installing C:\Perl\site\lib\auto\DBD\mysql\mysql.bs

Installing C:\Perl\site\lib\auto\DBD\mysql\mysql.dll

Installing C:\Perl\site\lib\auto\DBD\mysql\mysql.exp

Installing C:\Perl\site\lib\auto\DBD\mysql\mysql.lib

Installing C:\Perl\site\lib\auto\DBD\mysql\mysql.pdb

Installing C:\Perl\html\site\lib\Bundle\DBD\mysql.html

Installing C:\Perl\html\site\lib\DBD\mysql.html

Installing C:\Perl\html\site\lib\DBD\mysql\INSTALL.html

Files found in blib\arch: installing files in blib\lib into architecture depende

nt library tree

Installing C:\Perl\site\lib\Bundle\DBD\mysql.pm

Installing C:\Perl\site\lib\DBD\mysql.pm

Installing C:\Perl\site\lib\DBD\mysql\GetInfo.pm

Installing C:\Perl\site\lib\DBD\mysql\INSTALL.pod

Successfully installed DBD-mysql version 4.005 in ActivePerl 5.8.7.813.

ppm>

I deleted PPM3 a few times and replaced it with various URL's, including the one posted in the help file. None worked. The last one was a local directory that contained the zip and unzip file, and it still didn't install it. Finally, I used the url posted at the end of my code box, however it installed 4.0005 which will hopefully work. I'll find out tomorrow after I get some sleep.

If I do have issues with this new version, is there any reason why I can just copy the files myself? That is, use the 3.0002 version files and copy them to the locations listed in the code box?

Thks for the help.

May I ask what exacty you are trying to do?

If it's simply to setup EQEmu you don't need to fiddle with ppm. ActivePerl gives you everything you need right out of the box. We used to require people to grab additional modules but that hasn't been the case in quite some time.

Quote:

Originally Posted by cavedude (Post 144237)

Well, I started this simply because the EZ server was down for a good part of the night yesterday. It grew into wanting to learn some basics of DB building/managing. Now I see some basics but the "how" and "why" are way to fuzzy for my liking, so it's time to get answers.

In other words, I'm here to learn and in the process, get my own EMU server working.

G.

But what I'm saying is, why are you working with ppm? The ActivePerl package gives you everything you need in one shot, no need to grab DBD-mysql.