Server Setup questions

[abndrew82]

Hello

I have a few questions on setting up a server on windows, I am following the guide here ( http://eq2emulator.net/wiki/index.php/A ... ows_Binary )

But thinking it may be missing some stuff, as some parts dont make sense, and it appears IRC is a ghost town currently

Such as Step 4 and 5

* 4. Download the latest Stable Win32 binary from one of the links on our SVN Links page.

* 5. Once you have it downloaded, use a zip utility to extract all the files into a work directory of your choice.

Now that there is an SVN from what I can tell you dont get a zip as it mentions to extract anything, so by this, it does now tell you what files from the SVN download need to be in your working directory.

I moved eq2world.exe and the config files directory, to a seperate folder to work out of, but keep getting errors.

What I have done so far is Got SQL running, got an Empty database named eq2, got Heidisql connecting to it.

I edited the 2 ini files it mentions in the guide as it says, and can post them if needed, but when I try to run the eq2world.exe, it doesnt update the database at all as I am expecting.

here is the output I get when I run eq2world.exe

D:\eq2emutest>EQ2World.exe
[Status] Using database 'eq2' at 127.0.0.1
Failed to open log file: logs/eq2emu_world_2192.log
[20100413 18:33:37] [Status] CURRENT_WORLD_VERSION:EQ2EMu 0.6.5 Developer Alpha
[20100413 18:33:37] [Status] ./LoginServer.ini read.
[20100413 18:33:37] [Status] Connecting to Update Server..
[20100413 18:33:38] [Status] Connected to Update Server: updates.eq2emulator.
net:9103
[20100413 18:33:38] [Status] Checking for updates.
Failed to open log file: logs/eq2emu_error_world_2192.log
[20100413 18:33:38] [Error] Login Server returned a fatal error: Bad password
Disabling reconnect.
[20100413 18:33:38] [Error] Error while getting updates!
[20100413 18:33:38] [Status] Loading opcodes..
[20100413 18:33:38] [Status] Loading structs..
[20100413 18:33:39] [Status] Loading command list..
[20100413 18:33:39] [Status] Clearing player online flags..
[20100413 18:33:39] [Status] Loaded 0 entity command lists.
[20100413 18:33:39] [Status] Loaded 0 NPC(s).
[20100413 18:33:39] [Error] Error in LoadNPCSpells query 'SELECT spell_list_id,
spell_id, spell_tier from spawn_npc_spells where spell_list_id > 0': #1146: Tabl
e 'eq2.spawn_npc_spells' doesn't exist
[20100413 18:33:39] [Status] Loaded 0 NPC Spell(s).
[20100413 18:33:39] [Error] Error in LoadNPCSkills query 'SELECT skill_list_id,
skill_id, starting_value from spawn_npc_skills': #1146: Table 'eq2.spawn_npc_ski
lls' doesn't exist
[20100413 18:33:39] [Status] Loaded 0 NPC Skill(s).
[20100413 18:33:39] [Error] Error in LoadNPCEquipment query 'SELECT equipment_li
st_id, item_id from spawn_npc_equipment': #1146: Table 'eq2.spawn_npc_equipment'
doesn't exist
[20100413 18:33:39] [Status] Loaded 0 NPC Equipment Piece(s).
[20100413 18:33:39] [Error] Error in LoadAppearances query 'SELECT distinct `typ
e` from npc_appearance where length(type) > 0': #1146: Table 'eq2.npc_appearance
' doesn't exist
[20100413 18:33:39] [Error] Error in LoadAppearances query 'SELECT `type`, spawn
_id, signed_value, red, green, blue from npc_appearance where length(type) > 0 o
rder by spawn_id': #1146: Table 'eq2.npc_appearance' doesn't exist
[20100413 18:33:39] [Status] Loaded 0 NPC Appearance(s).
[20100413 18:33:39] [Error] Error in LoadNPCAppearanceEquipmentData query 'SELEC
T spawn_id, slot_id, equip_type, red, green, blue, highlight_red, highlight_gree
n, highlight_blue from npc_appearance_equip order by spawn_id': #1146: Table 'eq
2.npc_appearance_equip' doesn't exist
[20100413 18:33:39] [Status] Loaded 0 NPC Equipment Appearance(s).
[20100413 18:33:39] [Status] Loaded 0 Object(s).
[20100413 18:33:39] [Status] Loaded 0 GroundSpawn(s).
[20100413 18:33:39] [Status] Loaded 0 Widget(s).
[20100413 18:33:39] [Status] Loaded 0 Sign(s).
[20100413 18:33:39] [Status] Loading ground spawn items..
[20100413 18:33:39] [Status] Loading loot data..
[20100413 18:33:39] [Error] Error in LoadLootTable query 'select id, name, minco
in, maxcoin, maxlootitems, lootdrop_probability, coin_probability from loottable
': #1146: Table 'eq2.loottable' doesn't exist
[20100413 18:33:39] [Error] Error in LoadLootDrop query 'select id, name, mincoi
n, maxcoin, maxlootitems, lootdrop_probability, coin_probability from loottable'
: #1146: Table 'eq2.loottable' doesn't exist
[20100413 18:33:39] [Error] Error in LoadSpawnLootList query 'select id, name, m
incoin, maxcoin, maxlootitems, lootdrop_probability, coin_probability from loott
able': #1146: Table 'eq2.loottable' doesn't exist
[20100413 18:33:39] [Status] Loading Transporter Information..
[20100413 18:33:39] [Status] Loaded 0 Teleporter(s)
[20100413 18:33:39] [Status] Loaded global variables list..
[20100413 18:33:39] [Status] Loaded visual states list..
[20100413 18:33:39] [Status] Loading World Time..
[20100413 18:33:39] [Status] Loading items.. (this might take a few minutes)
[20100413 18:33:39] [Error] Error in LoadItemAppearances query 'select item_id,
equip_type, red, green, blue, highlight_red, highlight_green, highlight_blue fro
m item_appearances order by item_id asc': #1146: Table 'eq2.item_appearances' do
esn't exist
[20100413 18:33:39] [Error] Error in LoadItemStats query 'select item_id, type,
subtype, value, text from item_stats order by item_id asc': #1146: Table 'eq2.it
em_stats' doesn't exist
[20100413 18:33:39] [Error] Error in LoadItemEffects query 'select item_id, desc
ription, percentage, bullet from item_effects order by item_id, id': #1146: Tabl
e 'eq2.item_effects' doesn't exist
[20100413 18:33:40] [Error] Error in LoadItemLevelOverride query 'select item_id
, adventure_class_id, tradeskill_class_id, level from item_levels_override order
by item_id asc': #1146: Table 'eq2.item_levels_override' doesn't exist
[20100413 18:33:40] [Status] Loaded 0 Normal Items
[20100413 18:33:40] [Status] Loaded 0 Baubles
[20100413 18:33:40] [Status] Loaded 0 Bags
[20100413 18:33:40] [Status] Loaded 0 Books
[20100413 18:33:40] [Status] Loaded 0 Food Items
[20100413 18:33:40] [Status] Loaded 0 Weapons
[20100413 18:33:40] [Status] Loaded 0 Ranged Weapons
[20100413 18:33:40] [Status] Loaded 0 Thrown Weapons
[20100413 18:33:40] [Status] Loaded 0 Armor Pieces
[20100413 18:33:40] [Status] Loaded 0 Shields
[20100413 18:33:40] [Status] Loaded 0 Skill Items
[20100413 18:33:40] [Status] Loaded 0 Total Items (took 1 seconds)
[20100413 18:33:40] [Error] Error in LoadNextUniqueItemID query 'SELECT max(id)
from character_items': #1146: Table 'eq2.character_items' doesn't exist
[20100413 18:33:40] [Status] Loading spells..
[20100413 18:33:40] [Error] Error Loading Spells, Query: select spells.`id`, `na
me`, `description`, `type`, `class_skill`, `mastery_skill`, `tier`, `hp_req`, `p
ower_req`, `cast_time`, `recast`, `radius`, `max_aoe_targets`, `req_concentratio
n`, `range`, `duration1`, `duration2`, `resistibility`, `hp_upkeep`, `power_upke
ep`, `duration_until_cancel`, `target_type`, `recovery`, `power_req_percent`, `h
p_req_percent`, `icon`, `icon2`, `icontype`, `success_message`, `fade_message`,
`cast_type`, `lua_script`, `call_frequency`, `interruptable`, `spell_visual`, `e
ffect_message`, `min_range`, `can_effect_raid`, `affect_only_group_members`, `hi
t_bonus`, `display_spell_tier`, `friendly_spell`, `group_spell`, `spell_book_typ
e` from spells, spell_tiers where spells.id = spell_tiers.spell_id order by `tie
r`, Error: #1146: Table 'eq2.spells' doesn't exist
[20100413 18:33:40] [Status] Loading LUA spells..
[20100413 18:33:40] [Status] Loaded 0 LUA Spell(s)
[20100413 18:33:40] [Status] Loading factions..
[20100413 18:33:40] [Error] Error Loading Factions, Query: SELECT id, name, type
, description, default_level, negative_change, positive_change from factions, Er
ror: #1146: Table 'eq2.factions' doesn't exist
[20100413 18:33:40] [Status] Loading skills..
[20100413 18:33:40] [Status] Loaded 0 Skills
[20100413 18:33:40] [Status] Loading Quests..
[20100413 18:33:40] [Status] Loaded 0 Quest(s)
[20100413 18:33:40] [Status] Loading Guilds..
[20100413 18:33:40] [Status] Loaded 0 Guild(s)
[20100413 18:33:40] [Status] Loading Merchant Information..
[20100413 18:33:40] [Status] Loaded 0 Merchant Inventory Item(s)
[20100413 18:33:40] [Status] Loaded 0 Merchant List(s)
[20100413 18:33:40] [Status] Loading Spawn Script Information..
[20100413 18:33:40] [Error] Error in LoadSpawnScriptData, Query: SELECT spawn_id
, spawnentry_id, spawn_location_id, lua_script from spawn_scripts, Error: #1146:
Table 'eq2.spawn_scripts' doesn't exist
[20100413 18:33:40] [Status] Loading Zone Script Information..
[20100413 18:33:40] [Error] Error in LoadZoneScriptData, Query: SELECT `id`, `lu
a_script` FROM `zones`, Error: #1146: Table 'eq2.zones' doesn't exist
[20100413 18:33:40] [Status] Loading EQ2 time of day..
Starting factory Reader
Starting factory Writer
[20100413 18:33:40] [Status] World server listening on: 71.77.148.20:9000
[20100413 18:33:40] [Status] Starting static zones...
[20100413 18:33:43] [Status] Got signal 2

[John Adams]

You don't see this?

Code: Select all

[20100413 18:33:38] [Error] Login Server returned a fatal error: Bad password
Disabling reconnect.

You ain't getting bupkiss til you make yourself a Login and Server Account via the portal Account Management page and use that name and password to connect to the loginserver (which is where you get a blank database).

[abndrew82]

I did see that, but wasnt sure if that cause all the errors, but my issue is

I have created the login account and the server account

And have that information in the ini files, so not sure what is erroring, I cant figure out what I am putting wrong.

Login Accounts
[ Edit ] 1. apsenn (id: 5736)
1 of 3 Login Accounts in use.

Server Accounts
[ Edit ] 1. GravdigersWorld (id: 1901)
1 of 2 Server Accounts in use.

And my ini files look like this

[LoginServer]
loginserver=eq2emulator.net
loginport=9100
worldname=GravdigersWorld
worldaddress=71.77.148.20
#internalworldaddress=INTERNAL_IP_HERE (If used, otherwise blank)
worldport=9000
locked=false
account=apsenn
password=mypasswordhere

Any ideas, unless its a password issue, but I have reset it twice thinking that may be it.

[John Adams]

Confusing as it may be, there is a Login Account (your player login to the game, and Account Manager here on the website) and a Server Account (what you put in the INI file). What the loginserver needs is the "World" user name and password, which is not the same as your Login Account.

That's the only thing I can think of that would be telling you it's a bad password.

[abndrew82]

Ok that made sense, so I was using the wrong login info there, as I was using the site login stuff

So I think I got past that error, but still getting other errors, here is the new output

D:\eq2emutest>EQ2World.exe
[Status] Using database 'eq2' at localhost
Failed to open log file: logs/eq2emu_world_2200.log
[20100413 19:56:49] [Status] CURRENT_WORLD_VERSION:EQ2EMu 0.6.5 Developer Alpha
[20100413 19:56:49] [Status] ./LoginServer.ini read.
[20100413 19:56:49] [Status] Connecting to Update Server..
Failed to open log file: logs/eq2emu_error_world_2200.log
[20100413 19:56:50] [Error] LoginServer::ConnectToUpdateServer: 'TCPConnection::
Connect(): connect() failed. Error: 10061'
[20100413 19:56:50] [Status] Loading opcodes..
[20100413 19:56:50] [Status] Loading structs..
[20100413 19:56:52] [Status] Loading command list..
[20100413 19:56:52] [Status] Clearing player online flags..
[20100413 19:56:52] [Status] Loaded 0 entity command lists.
[20100413 19:56:52] [Status] Loaded 0 NPC(s).
[20100413 19:56:52] [Error] Error in LoadNPCSpells query 'SELECT spell_list_id,
spell_id, spell_tier from spawn_npc_spells where spell_list_id > 0': #1146: Tabl
e 'eq2.spawn_npc_spells' doesn't exist
[20100413 19:56:52] [Status] Loaded 0 NPC Spell(s).
[20100413 19:56:52] [Error] Error in LoadNPCSkills query 'SELECT skill_list_id,
skill_id, starting_value from spawn_npc_skills': #1146: Table 'eq2.spawn_npc_ski
lls' doesn't exist
[20100413 19:56:52] [Status] Loaded 0 NPC Skill(s).
[20100413 19:56:52] [Error] Error in LoadNPCEquipment query 'SELECT equipment_li
st_id, item_id from spawn_npc_equipment': #1146: Table 'eq2.spawn_npc_equipment'
doesn't exist
[20100413 19:56:52] [Status] Loaded 0 NPC Equipment Piece(s).
[20100413 19:56:52] [Error] Error in LoadAppearances query 'SELECT distinct `typ
e` from npc_appearance where length(type) > 0': #1146: Table 'eq2.npc_appearance
' doesn't exist
[20100413 19:56:52] [Error] Error in LoadAppearances query 'SELECT `type`, spawn
_id, signed_value, red, green, blue from npc_appearance where length(type) > 0 o
rder by spawn_id': #1146: Table 'eq2.npc_appearance' doesn't exist
[20100413 19:56:52] [Status] Loaded 0 NPC Appearance(s).
[20100413 19:56:52] [Error] Error in LoadNPCAppearanceEquipmentData query 'SELEC
T spawn_id, slot_id, equip_type, red, green, blue, highlight_red, highlight_gree
n, highlight_blue from npc_appearance_equip order by spawn_id': #1146: Table 'eq
2.npc_appearance_equip' doesn't exist
[20100413 19:56:52] [Status] Loaded 0 NPC Equipment Appearance(s).
[20100413 19:56:52] [Status] Loaded 0 Object(s).
[20100413 19:56:52] [Status] Loaded 0 GroundSpawn(s).
[20100413 19:56:52] [Status] Loaded 0 Widget(s).
[20100413 19:56:52] [Status] Loaded 0 Sign(s).
[20100413 19:56:52] [Status] Loading ground spawn items..
[20100413 19:56:52] [Status] Loading loot data..
[20100413 19:56:52] [Error] Error in LoadLootTable query 'select id, name, minco
in, maxcoin, maxlootitems, lootdrop_probability, coin_probability from loottable
': #1146: Table 'eq2.loottable' doesn't exist
[20100413 19:56:52] [Error] Error in LoadLootDrop query 'select id, name, mincoi
n, maxcoin, maxlootitems, lootdrop_probability, coin_probability from loottable'
: #1146: Table 'eq2.loottable' doesn't exist
[20100413 19:56:52] [Error] Error in LoadSpawnLootList query 'select id, name, m
incoin, maxcoin, maxlootitems, lootdrop_probability, coin_probability from loott
able': #1146: Table 'eq2.loottable' doesn't exist
[20100413 19:56:52] [Status] Loading Transporter Information..
[20100413 19:56:52] [Status] Loaded 0 Teleporter(s)
[20100413 19:56:52] [Status] Loaded global variables list..
[20100413 19:56:52] [Status] Loaded visual states list..
[20100413 19:56:52] [Status] Loading World Time..
[20100413 19:56:52] [Status] Loading items.. (this might take a few minutes)
[20100413 19:56:52] [Error] Error in LoadItemAppearances query 'select item_id,
equip_type, red, green, blue, highlight_red, highlight_green, highlight_blue fro
m item_appearances order by item_id asc': #1146: Table 'eq2.item_appearances' do
esn't exist
[20100413 19:56:52] [Error] Error in LoadItemStats query 'select item_id, type,
subtype, value, text from item_stats order by item_id asc': #1146: Table 'eq2.it
em_stats' doesn't exist
[20100413 19:56:52] [Error] Error in LoadItemEffects query 'select item_id, desc
ription, percentage, bullet from item_effects order by item_id, id': #1146: Tabl
e 'eq2.item_effects' doesn't exist
[20100413 19:56:52] [Error] Error in LoadItemLevelOverride query 'select item_id
, adventure_class_id, tradeskill_class_id, level from item_levels_override order
by item_id asc': #1146: Table 'eq2.item_levels_override' doesn't exist
[20100413 19:56:52] [Status] Loaded 0 Normal Items
[20100413 19:56:52] [Status] Loaded 0 Baubles
[20100413 19:56:52] [Status] Loaded 0 Bags
[20100413 19:56:52] [Status] Loaded 0 Books
[20100413 19:56:52] [Status] Loaded 0 Food Items
[20100413 19:56:52] [Status] Loaded 0 Weapons
[20100413 19:56:52] [Status] Loaded 0 Ranged Weapons
[20100413 19:56:52] [Status] Loaded 0 Thrown Weapons
[20100413 19:56:52] [Status] Loaded 0 Armor Pieces
[20100413 19:56:52] [Status] Loaded 0 Shields
[20100413 19:56:52] [Status] Loaded 0 Skill Items
[20100413 19:56:52] [Status] Loaded 0 Total Items (took 0 seconds)
[20100413 19:56:52] [Error] Error in LoadNextUniqueItemID query 'SELECT max(id)
from character_items': #1146: Table 'eq2.character_items' doesn't exist
[20100413 19:56:53] [Status] Loading spells..
[20100413 19:56:53] [Error] Error Loading Spells, Query: select spells.`id`, `na
me`, `description`, `type`, `class_skill`, `mastery_skill`, `tier`, `hp_req`, `p
ower_req`, `cast_time`, `recast`, `radius`, `max_aoe_targets`, `req_concentratio
n`, `range`, `duration1`, `duration2`, `resistibility`, `hp_upkeep`, `power_upke

[John Adams]

Post your entire loginserver.ini (minus username and password of course) so I can see what's going on.

[abndrew82]

### --- This file tells world.exe what loginserver to connect to.
### --- Change the account and password fields to the information you used when you created your SERVER account.

### --- NOTE: the word "Server" is added to each server automaticly.

# READ README.TXT

[LoginServer]
loginserver=eq2emulator.net
loginport=9100
worldname=Drewtest
worldaddress=71.77.148.20
#internalworldaddress=INTERNAL_IP_HERE (If used, otherwise blank)
worldport=9000
locked=false
account=Username
password=Password
#autotableupdates retrieves the latest table updates and applies them to your database
#autotableupdates valid options=always, ask, and never
autotableupdates=always
#autotableverbose displays detailed information about the updates; options=true or false
autotableverbose=false
#autotabledata retrieves the latest data for tables like the opcodes table; options=true or false
autotabledata=true

[WorldServer]
Defaultstatus=
Unavailzone=

[UpdateServer]
updateserveraddress=eq2emulator.net
updateserverport=9101

[LoginConfig]
ServerMode=StandAlone
ServerPort=9100

[abndrew82]

Another question from my post that may be messing me up, is what is the directory stucture the files should be in, I currently have them like this

Also note if it matters running Windows 7

Directory of D:\eq2emutest

04/13/2010 08:09 PM <DIR> .
04/13/2010 08:09 PM <DIR> ..
04/13/2010 06:06 PM 4,531 charactersheet_struct.txt
04/13/2010 06:21 PM <DIR> Common Structs
04/13/2010 06:06 PM 9,797 CommonStructs.xml
04/13/2010 06:06 PM 3,382,784 EQ2World.exe
04/13/2010 06:06 PM 570 EQ2_Structs.xml
04/13/2010 06:06 PM 116,712 ItemStructs.xml
04/13/2010 07:54 PM 1,099 LoginServer.ini
04/13/2010 06:21 PM <DIR> Quests
04/13/2010 06:21 PM <DIR> SpawnScripts
04/13/2010 06:06 PM 61,469 SpawnStructs.xml
04/13/2010 06:21 PM <DIR> Spells
04/13/2010 08:09 PM 0 structure.txt
04/13/2010 06:21 PM <DIR> World Structs
04/13/2010 06:06 PM 304,934 WorldStructs.xml
04/13/2010 07:05 PM 255 world_db.ini
10 File(s) 3,882,151 bytes
7 Dir(s) 106,007,318,528 bytes free

[John Adams]

I'm a little confused, because your configuration is wrong:

[UpdateServer]
updateserveraddress=eq2emulator.net
updateserverport=9101

Should be:

[UpdateServer]
updateserveraddress=updates.eq2emulator.net
updateserverport=9103

But why I am confused is because your first console log shows the right URL:port...

[20100413 18:33:38] [Status] Connected to Update Server: updates.eq2emulator.
net:9103

but not your second one.

You also need a ./logs folder, so you stop getting errors on startup about unable to create logs.

You do not need all those *structs* folders, just the xml's themselves in the same folder as EQ2World.exe

[abndrew82]

That looks like that may have fixed the issues.

It is doing some DB updates now. But had one error so far during them

[20100413 20:21:24] Error in updating tables query '

update characters, zones set current_zone_id=zones.id where zones.name=current_zone': #1146: Table 'eq2.zones' doesn't exist
[20100413 20:21:24] Attempting to update database table 'characters' ... FAILED!

And is currently sitting at

[20100413 20:24:06] Attempting to update database table 'opcodes' data ... SUCCESS!

But nothing came up since that last success.

Not sure if I need to restart it now, this were the last few lines

[20100413 20:23:34] Table Update complete.
[20100413 20:23:34] Processing Data Updates.
[20100413 20:23:44] Attempting to update database table 'commands' data ... SUCCESS!
[20100413 20:23:56] Attempting to update database table 'factions' data ... SUCCESS!
[20100413 20:23:56] Attempting to update database table 'item_details_bag' data ... SUCCESS!
[20100413 20:23:56] Attempting to update database table 'items' data ... SUCCESS!
[20100413 20:24:06] Attempting to update database table 'opcodes' data ... SUCCESS!

NM on the restart, it just moved again, its going through updates still just moving slowly right now

[John Adams]

You have to connect for updates a few times, due to the update process not having a zones table while it's trying to do other things first.

You should be good to go. Now if you really want to freak out, go to the Project Status forum and download/source in the released database. After all that, it's the only thing you actually had to do

[abndrew82]

I had downloaded the eq2db.sql if that is what you are referring to

But having alot of troubles getting it imported.

Tried with HeidiSql and Command Line and it seems my mysql is shutting down, I get errors that Mysql has gone away and it starts failing the import.

[John Adams]

Ahh, the dreaded max_packet_size issue. If you know anything about MySQL, edit your my.cnf (or my.ini) and find the max_packet_size=1M and change that to 100M. Being a local, private MySQL instance, it won't hurt you to have it large.

The reason that happens is because I dumped the DB using "bulk inserts" and the tables are HUGE, so it is one helluva lot of data in a single query.

[abndrew82]

I have dealt with mysql a bit, not totally knowledged in it, but looking at the my.ini file now

I see a tmp_table_size=18M line

Along with a few other buffer size lines

But not a max_packet_size=1M

Can it just be added

[John Adams]

If that's the config file your MySQL is using, then yes. You should just be able to add it. Google around a bit about max_packet_size, and that should give you the info you need.