Updated Windows Server Setup Guide

[Knotthead]

#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]

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]

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]

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

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]

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