Updated Windows Server Setup Guide - Page 8

OscarGrouch05 · #**106** 02-21-2010, 08:03 AM

well at the time i'm now running windows 7 ultimate, when i made that work was in windows nt 4.0 or windows xp pro it's all the same... when you type ipconfig you type it in the run command, if you want to really have fun with xp goto c:\windows\system32\ click on the icon gpedit click on administrative templates, network 80) if you understand a server your in luck now. alot of goodies in that program gpedit. if your going to setup a true server might want to use linux system for best results

Kobaz · #**107** 02-22-2010, 01:21 AM

since the W key is next to the Q key on a qwerty keyboard, I'm pretty sure that pew is just a typo for peq. Look at your keyboard (unless you are using dvorak).

Eva Aisling · #**108** 02-25-2010, 12:48 AM

I didn't understand instructions at #10 on how to use heidisql, so I used method suggested by this user:

Quote:

Originally Posted by spidey1170

I used a CL (command line) input into mysql for this:

Click on START, RUN and type CMD, this will pull up a command line interface

Next, type (without quotes): "mysql -u root -p"
Enter your password when prompted

Type "\u peq" and hit ENTER

Then you are able to type in the sql query, hit ENTER and it should work. Hope that helps =)...

I ended up with this error:
ERROR 1146 (42S02): Table 'peq.tblloginserveraccounts' doesn't exist
mysql>

Any input or advise would be greatly appreciated!

OscarGrouch05 · #**109** 02-25-2010, 08:58 PM

Eva Aising what Step 10 was telling you! if you saved the file EQEmuLoginServerDBInstall.sql copy and past it to C:\Program Files\HeidiSQL\data\peq

Eva Aisling · #**110** 03-03-2010, 01:27 PM

Quote:

Originally Posted by OscarGrouch05

copy and past it to C:\Program Files\HeidiSQL\data\peq

That folder does not exist on my computer, but thanks for trying to help! I just didn't know what a query was or why I was executing it and generally didn't know wtf was going on in heidi, but I understand now.

When I try to input the command into mysql prompt directly, I still get error stated in my post above. Heidisql reports that the row was affected and doesn't give me an error message. I assume that it worked just fine.

Whenever I use my start.bat, I almost immediately get a message saying that I cannot connect to login server. Error 10061. If anyone knows anything about dyndns or why I'm not able to connect to my own host server, please post here or send a PM to help. I have been searching for over a week now and can't get this working. I'm almost certain I completed the tutorial correctly and am just not getting a connection to dydns.

Eva Aisling · #**111** 03-04-2010, 11:50 AM

I finally got it working through some advice from other threads and a whole lot of trial and error. Here's the thread with my config file: http://www.eqemulator.org/forums/showthread.php?t=30723

Oogbar · #**112** 03-12-2010, 01:14 AM

SOAB!! Not being anywhere near C++ certed *i'm lucky enough to know how to even get Disk defrag to run, let alone how to play eq...*, payed UBER SUPER close attention to exactly what WAS TYPED into the pictures on the guide, and typed in what was typed in, not what i was being told to! I.E.: Instead of COD\PEQ_DB, it was CD\PEQ_DB!!! *Smashes head on keyboard* oogbar duuuum! oogbar smash dum...

SolidShake · #**113** 07-10-2010, 03:24 PM

Revision774-Bots.zip
is currently not on the Google code site,
if anyone could reupload it that would be awesome!

Knotthead · #**114** 07-17-2010, 05:33 PM

#4 (B) and (C) do not seem to work for me.

A) Then type: source peqdb_Rev859.sql; (actually used peqdb1589 as that is what downloaded through SVN for me)
This worked just fine for me.

B) Then type: source load_player.sql;
ERROR: Failed to open file 'xxxxxxxxxxxxxx.sql', error2
About 60 of these errors pop up.

C) Then type: source load_bots.sql;
ERROR: Failed to open file 'xxxxxxxxxxxx.sql', errror 2
7 errors of this type pop up.

The .sql files are in MYSQL\bin folder.
Load_bots.sql is 1KB in size.
Load_player.sql is 3KB in size.

I used the SVN update as instructed in the guide and it downloaded peqdb_1589.sql RAR file for me. I extracted and moved all the .sql files to the MYSQL\bin folder as instructed earlier in this thread.

I should not be getting these errors when I try to source the player and bot .sql
Anyone else run into this and maybe a workaround?

blackdragonsdg · #**115** 07-17-2010, 06:19 PM

You can not type source peqdb_rev1589.sql at the cl and expect it to work as you are missing the file path.

Example of usage:

source D:/MYSQL/bin/peqdb_rev1589.sql

When sourcing in the load_bots.sql, load_player.sql and so on you have to open the files and add the file paths to each line so the program knows where to look for each file.

Knotthead · #**116** 07-17-2010, 07:32 PM

Thanks Black,

I have absolutely no experience using C++, MYSQL, Pearl, etc. I am a total noob at programming.

when I am entering each line 1 at a time I get a result -
Query OK, 0 rows affected <0.00 sec>

Is this the results I am looking for?
Thanks for the help

blackdragonsdg · #**117** 07-17-2010, 10:47 PM

Yes, you could definitely see that once, twice, or not at all but that will depend on what it is that you are sourcing in.

You are entering each line one at a time? Each line meaning load_player.sql or the contents of load_player.sql? You seem to be on the right path but there might have been a slight misunderstanding.

So just to make sure we are on the same page. This is an example of what I meant before.

Contents of load_player.sql

Code:

source D:/Everquest/SVN/PEQ Database/player_tables/aa_timers.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/account.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/account_ip.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/account_rewards.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/adventure_details.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/adventure_members.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/adventure_stats.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/Banned_IPs.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/bugs.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/buyer.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/char_recipe_list.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/character_.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/character_activities.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/character_enabledtasks.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/character_tasks.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/character_backup.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/chatchannels.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/commands.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/completed_tasks.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/db_version.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/eventlog.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/faction_values.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/friends.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/gm_ips.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/group_id.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/group_leaders.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/guild_bank.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/guild_members.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/guild_ranks.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/guild_relations.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/guilds.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/hackers.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/inventory.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/instance_lockout.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/instance_lockout_player.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/keyring.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/launcher.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/launcher_zones.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/mail.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/merchantlist_temp.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/name_filter.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/object_contents.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/petitions.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/player_corpses.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/player_corpses_backup.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/player_titlesets.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/quest_globals.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/raid_details.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/raid_members.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/reports.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/respawn_times.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/rule_sets.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/rule_values.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/sharedbank.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/spell_globals.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/timers.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/trader.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/trader_audit.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/variables.sql;
source D:/Everquest/SVN/PEQ Database/player_tables/zone_flags.sql;

Your load_player.sql should look something like that and if it does then a simple sourcing of load_player.sql will source in all of those files.

Knotthead · #**118** 08-23-2010, 10:33 PM

OK, I've got everything compiled and installed.

Using minilogin on localhost only (127.0.0.1), so I have that IP address in all the correct spots.

I double click on my Serverstart.bat link and this error comes up with the c:\eqemu\eqlaunch.exe

[DEBUG] Starting log: logs/eqemu_debug_5744.log
[DEBUG] [LAUNCHER__INIT] Loading server configuration..
[DEBUG] [NET__WORLD] WorldConnection connect: Connecting to the server 127.0.0.1:9000 failed: TCPConnection::Connect(): connect() failed. Error 10061
[DEBUG] [LAUNCHER__ERROR] worldserver.Connect() FAILED! Will retry.
[DEBUG] [LAUNCHER__INIT] Starting main loop...

Just for giggles, I fire up my EQ game and login to only to find a blank server select screen.
I'm so close to playing on my own server I can taste it. What am I missing here that is causing me not to be able to connect my world sever?

Thanks for the help!
Knotthead

Nibor · #**119** 08-30-2010, 02:23 PM

When following this guide exactly this is what happens

1) Download and install Tortoise SVN∞.
After it's installed, navigate to your MySQL installation folder. In that directory, you should see a folder named bin - this is where you'll download the database to.

2) Right-click the folder and select SVN Checkout.
In the new window that pops up, where it says URL of Repository at the top, paste in:

http://projecteqdb.googlecode.com/svn/trunk
The line under that where it says Checkout directory: is the location of the folder you are downloading it to - keep an eye on that to make sure it's the correct folder.

Problems:
If you Install Mysql (Custom) and check C Include Files / Lib Files
you will recieve a warning that there are already files in the bin folder.

Also
When importing the database to the bin folder this way (currently rev1589) it creates the follow file path C:mysql/bin/projecteqdb/peqdatabase causing a failure at step 4a in the guide

A) Then type: source peqdb_Rev859.sql; (rev1589 in my case)
and press Enter.

I'm guessing since peqdb_rev1589.sql is not directly the bin folder and ends up in the peqdatabase folder ?

Nibor · #**120** 08-30-2010, 03:01 PM

Hopefully somebody can update it with regard to correct file/folder pathing so it works. I guess I need guide for dummies. *sigh* since I can't even get past step 4A