Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Tools

Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...)

Reply
 
Thread Tools Display Modes
  #1  
Old 11-09-2005, 08:47 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

I'm using ISS.

A combo upgrade isn't the way to go in this case. Not because of the software, but due to the difficulty of upgrading the database so as to incorperate all the changes made while preserving the user's personal data. Plus, a combo would be a big waste of bandwidth. Why make people download a 15MB file to upgrade when all they need is a 1MB?

Basically, everytime a release is made the main installer will updated, and a much smaller upgrade pack will be released that would upgrade from 2.0+ up to whatever the current version is.
Reply With Quote
  #2  
Old 01-04-2006, 12:48 PM
gottasummer
Discordant
 
Join Date: Mar 2004
Location: New Hampshire, USA
Posts: 267
Default

Will save me an hour or two, thanks.

Might make me switch my server to windows, linux build isn't working properly, well, mostly my fault hehe, mysql keeps going away, urg it is happening to me still but I will try some more.

Am loading database then going to try it out.

Thanks. Saves me about 5 hours
Reply With Quote
  #3  
Old 02-26-2006, 06:00 AM
MarCrush
Fire Beetle
 
Join Date: Feb 2005
Posts: 15
Exclamation

I noticed something wrong with your batch while you automacilly sourcing in your DB. You need to put a -p in the command (prompts for password) in the mysql command in your batch file otherwise it fails to source the database when root has a wrong password (i.e. blank password when a password exists). People that don't have a password for the root user just press enter.

Visual Example of what I am talking about:

You current have the batch file without the -p parameter.
Code:
@echo off
echo Please wait several minutes while your database is sourced...
mysql -u root < db.txt
You need to add the -p to the command so users can type in their passwords (most people set passwords to the root account because of security reasons).
Code:
@echo off
echo Please wait several minutes while your database is sourced...
mysql -u root -p < db.txt
Adding the -p parameter will being something like this:
Code:
Please wait several minutes while your database is sourced...
Enter Password:
After the user enters the password it will then be source into the database.

This is one problem I found in your Server Pack setup and can be easily fixed.
Reply With Quote
  #4  
Old 02-26-2006, 08:29 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

It's not really a problem it's intentional. Most of the people who use the Installer don't have root passwords setup because they don't have a good enough working knowledge of MySQL to do so (if they did they wouldn't need the installer, now would they?) My belief was and still is having an extra password prompt could lead to noobs becoming confused and the whole point of the installer is to avoid that.

More advanced users who setup a root password or who would just like to do everything themselves may download the raw pack, same software just no installer.
Reply With Quote
  #5  
Old 02-26-2006, 09:46 AM
MarCrush
Fire Beetle
 
Join Date: Feb 2005
Posts: 15
Default

Yeah, a lot of people don't even know how to use a computer really good. I just pointed that out because I'm too lazy (not really). I'm probably going to redo my server raw anyway. You could also make the echo text say:
Code:
Please enter your password and then wait several minutes while your database is sourced.
If you don't have a root password or don't know what it is just press enter.
Enter Password:
Pre-typed batch code:
Code:
@echo off
echo Please enter your password and then wait several minutes while your database is sourced.
echo If you don't have a root password or don't know what it is just press enter.
mysql -u root -p < db.txt
The database deletes it self when you click Finish on the setup dialog, you should put a checkbox saying "Delete database files" and have it checked by default.

Just some tips and advice you can do to improve your server pack. You should also post your DB standalone somewhere on these boards also .
Reply With Quote
Reply

Thread Tools
Display Modes

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:57 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