server setup question

[Aescleal]

Try to update now. I changed the update server to use ticks around the column names.

Nice! I do have a new result after that. But spell_id is still giving me grief.
I dropped again and recreated my eq2 db, made sure permissions were set to all for my account (basically follow the directions thread again).
Here's the server output.

Code: Select all

[Status] Using database 'eq2' at 192.168.0.199
[Status] CURRENT_WORLD_VERSION:EQ2EMu 0.6.5 Developer Alpha
[Status] ./LoginServer.ini read.
[Status] Connecting to Update Server..
[Status]        Connected to Update Server: updates.eq2emulator.net:9103
[Status]        Checking for updates.
[Status]        Server is already up-to-date.
[Status] Loading opcodes..
[Status] Loading structs..
[Status] Loading command list..
[Status] Loaded 21 entity command lists.
[Status] Loaded 0 NPC(s).
[Status] Loaded 0 Object(s).
[Status] Loaded 0 GroundSpawn(s).
[Status] Loaded 0 Widget(s).
[Status] Loaded 0 Sign(s).
[Status] Loading ground spawn items..
[Status] Loading loot data..
[Status]        Loaded 0 loot tables.
[Status]        Loaded 0 loot drops.
[Status]        Loaded 0 spawn loot lists.
[Status] Loading Transporter Information..
[Status]        Loaded 0 Teleporter(s)
[Status] Loaded global variables list..
[Status] Loaded visual states list..
[Status] Loading World Time..
[Status] Loading items.. (this might take a few minutes)
[Status]        Loaded 0 Bag(s)
[Status]        Loaded 0 Food(s)
[Status]        Loaded 0 Weapon(s)
[Status]        Loaded 0 Armor/Shield Piece(s)
[Status]        Loaded 0 Skill Item(s)
[Status]        Loaded 0 Regular Items
[Status] Loading spells..
Error Loading Spells, Query: select spells.id, name, description, type, class_sk
ill, mastery_skill, tier, hp_req, power_req, cast_time, recast, radius, max_aoe_
targets, req_concentration, range, duration1, duration2, resistibility, hp_upkee
p, power_upkeep, duration_until_cancel, target_type, recovery, power_req_percent
, hp_req_percent, icon, icon2, icontype, success_message, fade_message, cast_typ
e, lua_script, call_frequency, interruptable, spell_visual, effect_message, min_
range, can_effect_raid, affect_only_group_members, hit_bonus, spell_text_color,
display_spell_tier, friendly_spell, group_spell from spells, spell_tiers where s
pells.id = spell_tiers.spell_id order by tier, Error: #1064: You have an error i
n your SQL syntax; check the manual that corresponds to your MySQL server versio
n for the right syntax to use near 'range, duration1, duration2, resistibility,
hp_upkeep, power_upkeep, duration_un' at line 1
[Status] Loading LUA spells..
[Status]        Loaded 2 LUA Spell(s)
[Status] Loading factions..
[Status]        Loaded 48 Factions
[Status] Loading skills..
[Status]        Loaded 129 Skills
[Status] Loading Quests..
[Status]        Loaded 0 Quest(s)
[Status] Loading Merchant Information..
[Status]        Loaded 0 Merchant List(s)
[Status]        Loaded 0 Merchant Multiplier(s)
[Status] Loading Spawn Script Information..
[Status] Loading EQ time of day..
<Rogean>: There is only Everquest and Food, no Sleep.
Starting factory Reader
Starting factory Writer
World server listening on: 192.168.0.199:9000
Starting static zones...
Connected to LoginServer: eq2emulator.net:9100

[LethalEncounter]

This time it is a World problem as world is querying without the ticks and your db is having a fit about it. I'll change the code for World, but it will take a day or two as I'm busy working on other things at the moment.

[Zcoretri]

This time it is a World problem as world is querying without the ticks and your db is having a fit about it. I'll change the code for World, but it will take a day or two as I'm busy working on other things at the moment.

If you want I can handle the ticks around the fields.

[LethalEncounter]

If you have time, sure

[Aescleal]

Progress! Now I'm getting a long list of missing opcode config. I'm just starting to learn about the lovely world of sql, so this is impressive to me.
Oh, and I've changed back to localhost in my ini files. MySQL doesn't like when I use my IP for some reason. I guess when I installed MySQL I used localhost. When I change it, the server won't run at all. So I'm back to localhost. Will that matter in the end?

Code: Select all

[Status] Using database 'eq2' at localhost
[Status] CURRENT_WORLD_VERSION:EQ2EMu 0.6.5 Developer Alpha
[Status] ./LoginServer.ini read.
[Status] Connecting to Update Server..
[Status]        Connected to Update Server: updates.eq2emulator.net:9103
[Status]        Checking for updates.
[Status]        Server is already up-to-date.
[Status] Loading opcodes..
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
Opcode OP_MapRequest is missing from opcode configuration.
[Status] Loading structs..
[Status] Loading command list..
[Status] Loaded 21 entity command lists.
[Status] Loaded 0 NPC(s).
[Status] Loaded 0 Object(s).
[Status] Loaded 0 GroundSpawn(s).
[Status] Loaded 0 Widget(s).
[Status] Loaded 0 Sign(s).
[Status] Loading ground spawn items..
[Status] Loading loot data..
[Status]        Loaded 0 loot tables.
[Status]        Loaded 0 loot drops.
[Status]        Loaded 0 spawn loot lists.
[Status] Loading Transporter Information..
[Status]        Loaded 0 Teleporter(s)
[Status] Loaded global variables list..
[Status] Loaded visual states list..
[Status] Loading World Time..
[Status] Loading items.. (this might take a few minutes)
[Status]        Loaded 0 Bag(s)
[Status]        Loaded 0 Food(s)
[Status]        Loaded 0 Weapon(s)
[Status]        Loaded 0 Armor/Shield Piece(s)
[Status]        Loaded 0 Skill Item(s)
[Status]        Loaded 0 Regular Items
[Status] Loading spells..
Error Loading Spells, Query: select spells.id, name, description, type, class_sk
ill, mastery_skill, tier, hp_req, power_req, cast_time, recast, radius, max_aoe_
targets, req_concentration, range, duration1, duration2, resistibility, hp_upkee
p, power_upkeep, duration_until_cancel, target_type, recovery, power_req_percent
, hp_req_percent, icon, icon2, icontype, success_message, fade_message, cast_typ
e, lua_script, call_frequency, interruptable, spell_visual, effect_message, min_
range, can_effect_raid, affect_only_group_members, hit_bonus, spell_text_color,
display_spell_tier, friendly_spell, group_spell from spells, spell_tiers where s
pells.id = spell_tiers.spell_id order by tier, Error: #1064: You have an error i
n your SQL syntax; check the manual that corresponds to your MySQL server versio
n for the right syntax to use near 'range, duration1, duration2, resistibility,
hp_upkeep, power_upkeep, duration_un' at line 1
[Status] Loading LUA spells..
[Status]        Loaded 2 LUA Spell(s)
[Status] Loading factions..
[Status]        Loaded 0 Factions
[Status] Loading skills..
[Status]        Loaded 129 Skills
[Status] Loading Quests..
[Status]        Loaded 0 Quest(s)
[Status] Loading Merchant Information..
[Status]        Loaded 0 Merchant List(s)
[Status]        Loaded 0 Merchant Multiplier(s)
[Status] Loading Spawn Script Information..
[Status] Loading EQ time of day..
Breaking your databases!!
Starting factory Reader
Starting factory Writer
World server listening on: localhost:9000
Starting static zones...
Connected to LoginServer: eq2emulator.net:9100

[LethalEncounter]

Localhost is fine for your world_db.ini file, but if you use localhost in your LoginServer.ini file, then noone other than you will be able to login to your server. Try running this query and restarting world:

update table_versions set download_version=0;

That will force World to download the updates again and should solve your opcode problem.

[Aescleal]

Localhost is fine for your world_db.ini file, but if you use localhost in your LoginServer.ini file, then noone other than you will be able to login to your server.

So what is the best way to for MySQL to use IP address instead of localhost? Reinstall? Because that is fast enough to do too.
Sorry, don't feel as though you have to give me lessons on how to use MySQL. I'll get that figured out or start over!

[Aescleal]

Localhost is fine for your world_db.ini file, but if you use localhost in your LoginServer.ini file, then noone other than you will be able to login to your server. Try running this query and restarting world:

update table_versions set download_version=0;

That will force World to download the updates again and should solve your opcode problem.

Damn, you guys are gonna hate me. I ran update table_versions set download_version=0;
and now the 'commands' table has an issue as well. Zcoretri? is that you?

Code: Select all

[Status] Using database 'eq2' at localhost
[Status] CURRENT_WORLD_VERSION:EQ2EMu 0.6.5 Developer Alpha
[Status] ./LoginServer.ini read.
[Status] Connecting to Update Server..
[Status]        Connected to Update Server: updates.eq2emulator.net:9103
[Status]        Checking for updates.
[Status]        Processing Data Updates.
[Error] Error in updating tables query 'replace into commands (`id`,`command`,`s
ubcommand`,`handler`,`required_status`)  values(362,'giveitem','',101,200)': #10
54: Unknown column 'command' in 'field list'
[Error]         Attempting to update database table 'commands' data ... FAILED!
[Error] Error in updating tables query 'replace into commands (`id`,`command`,`s
ubcommand`,`handler`,`required_status`)  values(162,'house','',999,0)': #1054: U
nknown column 'command' in 'field list'
[Status]        Data Update complete.
[Status] Loading opcodes..
[Status] Loading structs..
[Status] Loading command list..
[Status] Loaded 21 entity command lists.
[Status] Loaded 0 NPC(s).
[Status] Loaded 0 Object(s).
[Status] Loaded 0 GroundSpawn(s).
[Status] Loaded 0 Widget(s).
[Status] Loaded 0 Sign(s).
[Status] Loading ground spawn items..
[Status] Loading loot data..
[Status]        Loaded 0 loot tables.
[Status]        Loaded 0 loot drops.
[Status]        Loaded 0 spawn loot lists.
[Status] Loading Transporter Information..
[Status]        Loaded 0 Teleporter(s)
[Status] Loaded global variables list..
[Status] Loaded visual states list..
[Status] Loading World Time..
[Status] Loading items.. (this might take a few minutes)
[Status]        Loaded 0 Bag(s)
[Status]        Loaded 0 Food(s)
[Status]        Loaded 0 Weapon(s)
[Status]        Loaded 0 Armor/Shield Piece(s)
[Status]        Loaded 0 Skill Item(s)
[Status]        Loaded 0 Regular Items
[Status] Loading spells..
Error Loading Spells, Query: select spells.id, name, description, type, class_sk
ill, mastery_skill, tier, hp_req, power_req, cast_time, recast, radius, max_aoe_
targets, req_concentration, range, duration1, duration2, resistibility, hp_upkee
p, power_upkeep, duration_until_cancel, target_type, recovery, power_req_percent
, hp_req_percent, icon, icon2, icontype, success_message, fade_message, cast_typ
e, lua_script, call_frequency, interruptable, spell_visual, effect_message, min_
range, can_effect_raid, affect_only_group_members, hit_bonus, spell_text_color,
display_spell_tier, friendly_spell, group_spell from spells, spell_tiers where s
pells.id = spell_tiers.spell_id order by tier, Error: #1064: You have an error i
n your SQL syntax; check the manual that corresponds to your MySQL server versio
n for the right syntax to use near 'range, duration1, duration2, resistibility,
hp_upkeep, power_upkeep, duration_un' at line 1
[Status] Loading LUA spells..
[Status]        Loaded 2 LUA Spell(s)
[Status] Loading factions..
[Status]        Loaded 48 Factions
[Status] Loading skills..
[Status]        Loaded 129 Skills
[Status] Loading Quests..
[Status]        Loaded 0 Quest(s)
[Status] Loading Merchant Information..
[Status]        Loaded 0 Merchant List(s)
[Status]        Loaded 0 Merchant Multiplier(s)
[Status] Loading Spawn Script Information..
[Status] Loading EQ time of day..
Please wait, we're still loading...
Starting factory Reader
Starting factory Writer
World server listening on: localhost:9000
Starting static zones...
Connected to LoginServer: eq2emulator.net:9100

[LethalEncounter]

heh np, If you are running the database on the same server you are hosting your World on, localhost will work fine for the db. If you are using a database on a different computer what you need to do is login as your root user and create a new user that can login. Use the grant sql command:

grant all privileges on {db name here}.* to {username here}@{hostname here} identified by '{password here}';
flush privileges;

[LethalEncounter]

Localhost is fine for your world_db.ini file, but if you use localhost in your LoginServer.ini file, then noone other than you will be able to login to your server. Try running this query and restarting world:

update table_versions set download_version=0;

That will force World to download the updates again and should solve your opcode problem.

Damn, you guys are gonna hate me. I ran update table_versions set download_version=0;
and now the 'commands' table has an issue as well. Zcoretri? is that you?

Code: Select all

[Status] Using database 'eq2' at localhost
[Status] CURRENT_WORLD_VERSION:EQ2EMu 0.6.5 Developer Alpha
[Status] ./LoginServer.ini read.
[Status] Connecting to Update Server..
[Status]        Connected to Update Server: updates.eq2emulator.net:9103
[Status]        Checking for updates.
[Status]        Processing Data Updates.
[Error] Error in updating tables query 'replace into commands (`id`,`command`,`s
ubcommand`,`handler`,`required_status`)  values(362,'giveitem','',101,200)': #10
54: Unknown column 'command' in 'field list'
[Error]         Attempting to update database table 'commands' data ... FAILED!
[Error] Error in updating tables query 'replace into commands (`id`,`command`,`s
ubcommand`,`handler`,`required_status`)  values(162,'house','',999,0)': #1054: U
nknown column 'command' in 'field list'
[Status]        Data Update complete.
[Status] Loading opcodes..
[Status] Loading structs..
[Status] Loading command list..
[Status] Loaded 21 entity command lists.
[Status] Loaded 0 NPC(s).
[Status] Loaded 0 Object(s).
[Status] Loaded 0 GroundSpawn(s).
[Status] Loaded 0 Widget(s).
[Status] Loaded 0 Sign(s).
[Status] Loading ground spawn items..
[Status] Loading loot data..
[Status]        Loaded 0 loot tables.
[Status]        Loaded 0 loot drops.
[Status]        Loaded 0 spawn loot lists.
[Status] Loading Transporter Information..
[Status]        Loaded 0 Teleporter(s)
[Status] Loaded global variables list..
[Status] Loaded visual states list..
[Status] Loading World Time..
[Status] Loading items.. (this might take a few minutes)
[Status]        Loaded 0 Bag(s)
[Status]        Loaded 0 Food(s)
[Status]        Loaded 0 Weapon(s)
[Status]        Loaded 0 Armor/Shield Piece(s)
[Status]        Loaded 0 Skill Item(s)
[Status]        Loaded 0 Regular Items
[Status] Loading spells..
Error Loading Spells, Query: select spells.id, name, description, type, class_sk
ill, mastery_skill, tier, hp_req, power_req, cast_time, recast, radius, max_aoe_
targets, req_concentration, range, duration1, duration2, resistibility, hp_upkee
p, power_upkeep, duration_until_cancel, target_type, recovery, power_req_percent
, hp_req_percent, icon, icon2, icontype, success_message, fade_message, cast_typ
e, lua_script, call_frequency, interruptable, spell_visual, effect_message, min_
range, can_effect_raid, affect_only_group_members, hit_bonus, spell_text_color,
display_spell_tier, friendly_spell, group_spell from spells, spell_tiers where s
pells.id = spell_tiers.spell_id order by tier, Error: #1064: You have an error i
n your SQL syntax; check the manual that corresponds to your MySQL server versio
n for the right syntax to use near 'range, duration1, duration2, resistibility,
hp_upkeep, power_upkeep, duration_un' at line 1
[Status] Loading LUA spells..
[Status]        Loaded 2 LUA Spell(s)
[Status] Loading factions..
[Status]        Loaded 48 Factions
[Status] Loading skills..
[Status]        Loaded 129 Skills
[Status] Loading Quests..
[Status]        Loaded 0 Quest(s)
[Status] Loading Merchant Information..
[Status]        Loaded 0 Merchant List(s)
[Status]        Loaded 0 Merchant Multiplier(s)
[Status] Loading Spawn Script Information..
[Status] Loading EQ time of day..
Please wait, we're still loading...
Starting factory Reader
Starting factory Writer
World server listening on: localhost:9000
Starting static zones...
Connected to LoginServer: eq2emulator.net:9100

Ahh your entire database is messed up. Run this command and restart World so that is rebuilds your tables:

delete from table_versions;

[Aescleal]

Fantastic! Okay, so now I'm just down to the Error Loading Spells.

Code: Select all

[Status] Using database 'eq2' at localhost
[Status] CURRENT_WORLD_VERSION:EQ2EMu 0.6.5 Developer Alpha
[Status] ./LoginServer.ini read.
[Status] Connecting to Update Server..
[Status]        Connected to Update Server: updates.eq2emulator.net:9103
[Status]        Checking for updates.
[Status]        Server is already up-to-date.
[Status] Loading opcodes..
[Status] Loading structs..
[Status] Loading command list..
[Status] Loaded 21 entity command lists.
[Status] Loaded 0 NPC(s).
[Status] Loaded 0 Object(s).
[Status] Loaded 0 GroundSpawn(s).
[Status] Loaded 0 Widget(s).
[Status] Loaded 0 Sign(s).
[Status] Loading ground spawn items..
[Status] Loading loot data..
[Status]        Loaded 0 loot tables.
[Status]        Loaded 0 loot drops.
[Status]        Loaded 0 spawn loot lists.
[Status] Loading Transporter Information..
[Status]        Loaded 0 Teleporter(s)
[Status] Loaded global variables list..
[Status] Loaded visual states list..
[Status] Loading World Time..
[Status] Loading items.. (this might take a few minutes)
[Status]        Loaded 0 Bag(s)
[Status]        Loaded 0 Food(s)
[Status]        Loaded 0 Weapon(s)
[Status]        Loaded 0 Armor/Shield Piece(s)
[Status]        Loaded 0 Skill Item(s)
[Status]        Loaded 0 Regular Items
[Status] Loading spells..
Error Loading Spells, Query: select spells.id, name, description, type, class_sk
ill, mastery_skill, tier, hp_req, power_req, cast_time, recast, radius, max_aoe_
targets, req_concentration, range, duration1, duration2, resistibility, hp_upkee
p, power_upkeep, duration_until_cancel, target_type, recovery, power_req_percent
, hp_req_percent, icon, icon2, icontype, success_message, fade_message, cast_typ
e, lua_script, call_frequency, interruptable, spell_visual, effect_message, min_
range, can_effect_raid, affect_only_group_members, hit_bonus, spell_text_color,
display_spell_tier, friendly_spell, group_spell from spells, spell_tiers where s
pells.id = spell_tiers.spell_id order by tier, Error: #1064: You have an error i
n your SQL syntax; check the manual that corresponds to your MySQL server versio
n for the right syntax to use near 'range, duration1, duration2, resistibility,
hp_upkeep, power_upkeep, duration_un' at line 1
[Status] Loading LUA spells..
[Status]        Loaded 2 LUA Spell(s)
[Status] Loading factions..
[Status]        Loaded 48 Factions
[Status] Loading skills..
[Status]        Loaded 129 Skills
[Status] Loading Quests..
[Status]        Loaded 0 Quest(s)
[Status] Loading Merchant Information..
[Status]        Loaded 0 Merchant List(s)
[Status]        Loaded 0 Merchant Multiplier(s)
[Status] Loading Spawn Script Information..
[Status] Loading EQ time of day..
<Baron-Sprite>: this directory isn't even my pr0n one damnit
Starting factory Reader
Starting factory Writer
World server listening on: localhost:9000
Starting static zones...
Connected to LoginServer: eq2emulator.net:9100

[John Adams]

Hey, you're almost home.

You could install a 5.0.x MySQL instead of the 5.1, if you really think that is the problem. The fix to that may take a little more time.

I am not sure why "range" would freak out as a function name when name, unix_timestamp, index, and many other reserved words are used and don't require ticks... but who knows. I haven't gotten into MySQL 5.1 yet, nor 6.0.

[Aescleal]

Yes, I'm going that route. I'm downloading it tonight and get it installed.
I'll post any strangeness. I'll post any goodness!

[Aescleal]

Hey, you're almost home.

You could install a 5.0.x MySQL instead of the 5.1, if you really think that is the problem. The fix to that may take a little more time.

I am not sure why "range" would freak out as a function name when name, unix_timestamp, index, and many other reserved words are used and don't require ticks... but who knows. I haven't gotten into MySQL 5.1 yet, nor 6.0.

Okay, I uninstalled 5.1 and installed MySQL 5.0.77.
All problems went away... Started world, saw a few errors. Restarted world and received no errors. Server is running smooth.
I have not tested with minilogin yet, but I'm extremely impressed. It's great to know this issue was related to a db version.

I think it's safe to say that 5.1 was the problem and 5.0.x should be the defacto MySQL version to use for this EMU.

Next milestone for me is minilogin.

Thanks for all your help and patience.

[LethalEncounter]

Wait until you see all the things that Scatman and John Adams have done on the content side. They have been doing some awesome stuff with the data as well, it just isn't finished so it isn't release yet. But once Tess comes up take a look on it