Getting a connectable server running....

[nosfentora]

Hi all,

still trying to get everything working with no luck connecting the client now....

Here's what I've done so far...

My server folder:

1) Pulled the server SVN - REV 1924
2) used EQ2World_x64.exe from SVN/trunk/bin
3) used config files from SVN/trunk/configs
4) used structs from SVN/trunk/structs
5) used zlib.dll from SVN/trunk/utils
6) used Items,Quests,SpawnScripts,Spells,ZoneScripts from SVN/Releases/eq2emulator/0.7.1/EQ2Emulator_0.7.1_Complete.zip

LoginServer.ini

Code: Select all

### --- 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=127.0.0.1
loginport=9100

worldname=Minilogin
worldaddress=127.0.0.1
#internalworldaddress=INTERNAL_IP_HERE (If used, otherwise blank)
worldport=9000
locked=false

account=xxx
password=xxx

#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=updates.eq2emulator.net
updateserverport=9103

[LoginConfig]
ServerMode=StandAlone
ServerPort=9100

My login server

1) used EQ2Minilogin.exe from SVN/trunk/bin
2) used configs and structs from SVN/releases/minilogin/1.02/EQ2Minilogin_1.02.zip
3) used db from SVN/releass/minilogin/1.02/eq2logindb.sql
4) updated loginserver opcodes table using world db table as source
5) updated loginserver.login_versions table to include '0.7.2-dev'

added account info to loginserver.account table
added worldserver info to loginserver.login_worldservers table

account & passwords match what is in LoginServer.ini

ran minilogin first, no errors, sits and waits for connection.

ran world_x64 and it populated the db. closed it and ran it again, no updates.

it connected to the login server.

fired up DoV retail install, CL 154351 Build 7198

login rejected: "Client version does not match the server's"
get the following error in Minilogin:

11:30:03 E Login : Error bad version: 1084 - Login Denied.
11:30:03 E Login : Login Denied! Bad version: 1084 (resp 6)

Then this from Minilogin

Code: Select all

11:30:26 E DBCore    : #1054: Unknown column 'world_max_level' in 'field list'
Query: insert into login_worldstats (world_id, world_status, current_players, current_zones, last_update, world_max_level) values(2, 1, 0, 0, NOW(), 50) ON DUPLICATE KEY UPDATE current_players=0,current_zones=0,world_max_level=50,world_status=1,last_update=NOW()

I know I'm missing something simple.... any ideas?

world log

Code: Select all

11:29:31 I Init: Starting EQ2Emulator WorldServer...
11:29:31 I DB: Using database 'eq2_db' at localhost
11:29:31 D World: Randomizing World...
11:29:31 D Init: ./LoginServer.ini read...
11:29:31 I Patcher: Connecting to DB PatchServer...
11:29:31 D Patcher: -Connected to Update Server: updates.eq2emulator.net:9103
11:29:31 D Patcher: -Checking for updates.
11:29:32 D Patcher: --DB Schema exists! Checking for updates...
11:29:32 D Patcher: --Max Version: 72027
11:29:32 D Patcher: --No Table Updates, continuing...
11:29:32 D Patcher: -No changes to DB Schema...
11:29:32 D Patcher: -No changes to DB Data...
11:29:32 I Patcher: DB Update check completed...
11:29:32 I World: Loading System Data...
11:29:33 I World: Loaded System Data (took 1 seconds)
11:29:33 I Spawn: Initializing Spawn Subsystem...
11:29:33 D Command: -Loading Entity Commands...
11:29:33 D Command: --Loaded 0 entity command(s)
11:29:33 D NPC: -Loading NPC data...
11:29:33 D NPC: --Loaded 0 NPC(s).
11:29:33 D NPC: --Loaded 0 NPC Spell(s).
11:29:33 D NPC: --Loaded 0 NPC Skill(s).
11:29:33 D NPC: --Loaded 0 NPC Equipment Piece(s).
11:29:33 D NPC: --Loaded 0 NPC Appearance(s).
11:29:33 D NPC: --Loaded 0 NPC Equipment Appearance(s).
11:29:33 D NPC: -Load NPC data complete!
11:29:33 D Object: -Loading Object data...
11:29:33 D Object: --Loaded 0 Object(s)
11:29:33 D Object: -Load Object data complete!
11:29:33 D Sign: -Loading Sign data...
11:29:33 D Sign: --Loaded 0 Sign(s)
11:29:33 D Sign: -Load Sign data complete!
11:29:33 D Widget: -Loading Widget data...
11:29:33 D Widget: --Loaded 0 Widget(s)
11:29:33 D Widget: -Load Widget data complete!
11:29:33 D GSpawn: -Loading Groundspawn data...
11:29:33 D GSpawn: --Loaded 0 GroundSpawn(s)
11:29:33 D GSpawn: --Loaded 0 GroundSpawn Entries.
11:29:33 D GSpawn: --Loaded 0 GroundSpawn Items.
11:29:33 D GSpawn: -Load Groundspawn data complete!
11:29:33 D Pet: -Loading Pet data...
11:29:33 D Pet: --Loaded 1707 Pet Names
11:29:33 D Pet: -Load Pet data complete!
11:29:33 D Loot: -Loading Spawn loot data...
11:29:33 D Loot: --Loading LootTables...
11:29:33 D Loot: --Loaded 0 loot tables.
11:29:33 D Loot: --Loading LootDrops...
11:29:33 D Loot: --Loaded 0 loot drops.
11:29:33 D Loot: --Assigning loot table(s) to spawn(s)...
11:29:33 D Loot: --Loaded 0 spawn loot lists.
11:29:33 D Loot: -Loading Spawn loot data complete!
11:29:33 D Transport: -Loading Transporters...
11:29:33 D Transport: --Loaded 0 Transporter(s)
11:29:33 D Transport: -Loading Transporters complete!
11:29:33 I Spawn: Initialize Spawn Subsystem complete (took 0 seconds)
11:29:33 W Reformat: JA: This is as far as I got, don't panic!
11:29:33 I Items: Loading Items...
11:29:33 D Items: 	Loaded 1 Normal Items
11:29:33 D Items: 	Loaded 0 Baubles
11:29:33 D Items: 	Loaded 1 Bags
11:29:33 D Items: 	Loaded 0 Books
11:29:33 D Items: 	Loaded 0 Food Items
11:29:33 D Items: 	Loaded 0 Weapons
11:29:33 D Items: 	Loaded 0 Ranged Weapons
11:29:33 D Items: 	Loaded 0 Thrown Weapons
11:29:33 D Items: 	Loaded 0 Armor Pieces
11:29:33 D Items: 	Loaded 0 Shields
11:29:33 D Items: 	Loaded 0 Skill Items
11:29:33 D Items: 	Loaded 0 Recipe Book Items
11:29:33 D Items: Loading Item Appearances...
11:29:33 D Items: 	Loaded 0 Item Appearances
11:29:33 D Items: Loading Item Stats...
11:29:33 D Items: 	Loaded 0 Item Stats
11:29:33 D Items: Loading Item Effects...
11:29:33 D Items: 	Loaded 0 Item Effects
11:29:33 D Items: Loading Item Level Overrides...
11:29:33 D Items: 	Loaded 0 Item Level Overrides
11:29:33 I Items: Loaded 2 Total Items (took 0 seconds)
11:29:33 I Spells: Loading Spells...
11:29:33 D Spells: Loading Spell Effects...
11:29:33 D Spells: 	Loaded 137 Spell Effects.
11:29:33 D Spells: Loading Spell LUA Data...
11:29:33 D Spells: 	Loaded 78 Spell LUA Data entries.
11:29:33 D Spells: Loading Spells Scripts...
11:29:33 D Spells: 	Loaded 124 SpellScripts
11:29:33 I Spells: Loaded 124 Spells (took 0 seconds)
11:29:33 I Traits: Loading Traits...
11:29:33 I Traits: --Loaded 147 Trait(s)
11:29:33 I Quests: Loading Quests...
11:29:33 D Quest: 	Loaded 0 Quest(s)
11:29:33 I Collect: Loading Collections...
11:29:33 D Collect: 	Loaded 553 collections
11:29:33 D Collect: 	Loaded 0 collection items
11:29:33 D Collect: 	Loaded 606 collection rewards
11:29:33 I Guilds: Loading Guilds...
11:29:33 I Guilds: 	Loaded 0 Guild(s)
11:29:33 I Recipes: Loading Recipe Books...
11:29:33 D Recipes: 	Loaded 0 Recipe Books 
11:29:33 I Recipes: Loading Recipes...
11:29:33 D Recipes: 	Loaded 0 recipes
11:29:33 I Titles: Loading Titles...
11:29:33 D World: 	Loaded 471 Titles
11:29:33 I Languages: Loading Languages...
11:29:33 D World: 	Loaded 0 Languages
11:29:33 I Chat: Loading channels...
11:29:33 I Merchants: Loading Merchants...
11:29:33 D Merchant: 	Clearing Merchant Inventory...
11:29:33 D Merchant: 	Loading Merchant Inventory...
11:29:33 D Merchant: 	Loaded 0 Merchant Inventory Item(s)
11:29:33 D Merchant: 	Loaded 0 Merchant List(s)
11:29:33 I LUA: Loading Spawn Scripts...
11:29:33 D LUA: 	Loaded 0 SpawnScripts
11:29:33 I LUA: Loading Zone Scripts...
11:29:33 D LUA: 	Loaded 0 ZoneScripts
11:29:33 D World: Starting factory Reader
11:29:33 D World: Starting factory Writer
11:29:33 I Net: World server listening on: 127.0.0.1:9000
11:29:33 I Zone: Starting static zones...
11:29:33 D Thread: Starting console command thread...
11:29:33 I Console: Type 'help' or '?' and press enter for menu options.
11:29:33 D Thread: Starting autoinit loginserver thread...
11:29:33 I World: Connected to LoginServer: 127.0.0.1: 9100
11:29:33 D Login: Looking for Login Zone Updates...
11:29:33 D Login: Looking for Login Appearance Updates...
11:34:06 W World: Got signal 2
11:34:06 D World: The world is ending!
11:34:06 D IRC: Shutting IRC down
11:34:06 D World: Shutting down zones...
11:34:06 I World: Shutting down all zones, please wait...
11:34:06 I World: Zone shutdown complete
11:34:06 D World: Shutting down LUA interface...
11:34:06 I World: Exiting... we hope you enjoyed your flight.

login server log

Code: Select all

11:29:26 I DB: Using database 'eq2ls' at localhost
11:29:26 I Login: =====================================
11:29:26 I Login: Initializing LoginServer...
11:29:26 I Login: LoginServer.ini read.
11:29:26 I Login: Loading opcodes...
11:29:26 I Login: Loading Structs... SUCCESS!
11:29:26 I Login: Loading world list...
11:29:26 I Login: Login server listening on port: 9100
11:29:26 I Login: Kickstarting LoginServer Heartbeat...
11:29:33 I Login: 6390 New Server connection: 127.0.0.1, port: 52210
11:29:49 I Login: New client from ip: 127.0.0.1, port: 64879
11:30:03 I Login: New client from ip: 127.0.0.1, port: 64879
11:30:03 E Login: Error bad version: 1084 - Login Denied.
11:30:03 E Login: Login Denied! Bad version: 1084 (resp 6)
11:30:26 E DBCore: #1054: Unknown column 'world_max_level' in 'field list'
Query:
insert into login_worldstats (world_id, world_status, current_players, current_zones, last_update, world_max_level) values(2, 1, 0, 0, NOW(), 50) ON DUPLICATE KEY UPDATE current_players=0,current_zones=0,world_max_level=50,world_status=1,last_update=NOW()

Lastly, I was going to try and use the DB from eq2content REV 13 - SVN/releases/milestone_1/eq2db.zip, however when i tried sourcing it I get an error about the mysql server going away.

MySQL is local, the only thing i can think of is that some of the queries are too large to run in one shot based on my config. I need to look into that more - unless someone has a solution.

Thanks in advance for any help and advice!

[xinux]

11:30:03 E Login : Error bad version: 1084 - Login Denied.
11:30:03 E Login : Login Denied! Bad version: 1084 (resp 6)

The box set exe doesn't work since we don't have the opcodes for 1084 so we are using version 1096 for DoV.



This should get you connected if your using a DoV client.

1. Rename/backup your UI folder and use the this one instead............http://toxic04.com/UI-DoV.zip
2. Rename/backup your everquest2.exe and use this one..................http://toxic04.com/EverQuest2-DoV.zip

[nosfentora]

Thanks xinux, I'll give it a shot and see what happens!

[nosfentora]

I'm assuming I shouldn't try and update the client, correct?

I used your supplied files and was able to log in.

At the character creation, name selection, play / enter world minilogin crashed and here is the log

Code: Select all

13:12:25 I DB: Using database 'eq2ls' at localhost
13:12:25 I Login: =====================================
13:12:25 I Login: Initializing LoginServer...
13:12:25 I Login: LoginServer.ini read.
13:12:25 I Login: Loading opcodes...
13:12:25 I Login: Loading Structs... SUCCESS!
13:12:25 I Login: Loading world list...
13:12:25 I Login: Login server listening on port: 9100
13:12:25 I Login: Kickstarting LoginServer Heartbeat...
13:12:31 I Login: 6631 New Server connection: 127.0.0.1, port: 41214
13:12:37 I Login: New client from ip: 127.0.0.1, port: 57697
13:12:37 I Login: Using Login Packet version: 1096
13:12:38 W Opcode: Unknown Opcode OP_Unknown, 0000 (0)
13:13:25 E DBCore: #1054: Unknown column 'world_max_level' in 'field list'
Query:
insert into login_worldstats (world_id, world_status, current_players, current_zones, last_update, world_max_level) values(2, 1, 0, 0, NOW(), 50) ON DUPLICATE KEY UPDATE current_players=0,current_zones=0,world_max_level=50,world_status=1,last_update=NOW()
13:13:31 E DBCore: #1054: Unknown column 'world_max_level' in 'field list'
Query:
insert into login_worldstats (world_id, world_status, current_players, current_zones, last_update, world_max_level) values(2, 1, 0, 0, NOW(), 50) ON DUPLICATE KEY UPDATE current_players=0,current_zones=0,world_max_level=50,world_status=1,last_update=NOW()
13:13:36 W Opcode: Unknown Opcode OP_Unknown, 0000 (0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'skin_color',225,218,216)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'eye_color',204,204,204)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'hair_color1',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'hair_color2',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'hair_highlight',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'hair_type_color',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'hair_type_highlight_color',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'hair_face_color',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'hair_face_highlight_color',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'wing_color1',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'wing_color2',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'shirt_color',255,255,255)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'unknown_chest_color',255,255,255)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'pants_color',255,255,255)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'unknown_legs_color',255,255,255)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'unknown9',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue, signed_value) values(1,'eye_type',-45,0,0, 1)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue, signed_value) values(1,'ear_type',-83,89,0, 1)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue, signed_value) values(1,'eye_brow_type',-22,-17,34, 1)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue, signed_value) values(1,'cheek_type',-93,25,0, 1)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue, signed_value) values(1,'lip_type',-51,15,-84, 1)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue, signed_value) values(1,'chin_type',74,-26,-71, 1)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue, signed_value) values(1,'nose_type',-7,-97,-1, 1)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue, signed_value) values(1,'body_size',-58,0,0, 1)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'soga_skin_color',198,192,182)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'soga_eye_color',0,0,95)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'soga_hair_color1',204,204,204)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'soga_hair_color2',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'soga_hair_highlight',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'soga_hair_type_color',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'soga_hair_type_highlight_color',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'soga_hair_face_color',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'soga_hair_face_highlight_color',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'soga_wing_color1',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'soga_wing_color2',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'soga_shirt_color',255,255,255)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'soga_unknown_chest_color',255,255,255)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'soga_pants_color',255,255,255)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'soga_unknown_legs_color',255,255,255)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue) values(1,'soga_unknown13',0,0,0)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue, signed_value) values(1,'soga_eye_type',-39,0,0, 1)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue, signed_value) values(1,'soga_ear_type',28,5,0, 1)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue, signed_value) values(1,'soga_eye_brow_type',87,25,-75, 1)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue, signed_value) values(1,'soga_cheek_type',-72,-98,0, 1)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue, signed_value) values(1,'soga_lip_type',-93,11,-22, 1)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue, signed_value) values(1,'soga_chin_type',0,85,81, 1)
13:13:39 E DBCore: #1054: Unknown column 'login_characters_id' in 'field list'
Query:
insert into login_char_colors (login_characters_id, type, red, green, blue, signed_value) values(1,'soga_nose_type',31,95,90, 1)
13:13:39 I Login: Successfully created character 'Nosfentora' (1) for account 2 on server_id 1!
13:13:40 E DBCore: #1054: Unknown column 'login_characters_id' in 'where clause'
Query:
SELECT type, signed_value, red, green, blue from login_char_colors where login_characters_id = 1

I'm guessing the db schema is incorrect.

should i be using a different db for the login db other than

3) used db from SVN/release/minilogin/1.02/eq2logindb.sql

or should i be using the svn/releases/minilogin/1.02 minilogin and not the svn/trunk/bin version?

[nosfentora]

I modified the tables to accommodate the missing fields and the minilogin errors have gone away.

am able to log in now and run around. Yay! I love progress!

Thanks xinux!

[nosfentora]

Found the answer to my problem

Lastly, I was going to try and use the DB from eq2content REV 13 - SVN/releases/milestone_1/eq2db.zip, however when i tried sourcing it I get an error about the mysql server going away.

MySQL is local, the only thing i can think of is that some of the queries are too large to run in one shot based on my config. I need to look into that more - unless someone has a solution.

here: viewtopic.php?f=51&t=2358

EDIT:
implelentation of solution: http://forums.mysql.com/read.php?35,545 ... #msg-56470