Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 03-06-2008, 05:44 PM
RamsiMage
Fire Beetle
 
Join Date: Jan 2008
Posts: 26
Default 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.
Reply With Quote
  #2  
Old 03-06-2008, 05:52 PM
RamsiMage
Fire Beetle
 
Join Date: Jan 2008
Posts: 26
Default

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.
Reply With Quote
  #3  
Old 03-06-2008, 06:04 PM
AndMetal
Developer
 
Join Date: Mar 2007
Location: Ohio
Posts: 648
Default

Quote:
Originally Posted by RamsiMage View Post
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.
__________________
GM-Impossible of 'A work in progress'
A non-legit PEQ DB server
How to create your own non-legit server

My Contributions to the Wiki
Reply With Quote
  #4  
Old 03-06-2008, 06:10 PM
RamsiMage
Fire Beetle
 
Join Date: Jan 2008
Posts: 26
Default

Thanks for the swift reply. Much appreciated.
Reply With Quote
  #5  
Old 03-06-2008, 06:42 PM
RamsiMage
Fire Beetle
 
Join Date: Jan 2008
Posts: 26
Default

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.
Reply With Quote
  #6  
Old 03-06-2008, 11:49 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

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.
Reply With Quote
  #7  
Old 03-07-2008, 05:09 AM
RamsiMage
Fire Beetle
 
Join Date: Jan 2008
Posts: 26
Default

Quote:
Originally Posted by cavedude View Post
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.
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.
Reply With Quote
  #8  
Old 03-07-2008, 06:10 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

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.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 05:34 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3