Trying to connect with patched client

[Jabantiz]

You could create a character but no server?

I believe with new clients you need to select the type of server you want, in this case you need to select the traditional types for emulator server to be listed.

[elkay]

You could create a character but no server?

I believe with new clients you need to select the type of server you want, in this case you need to select the traditional types for emulator server to be listed.

I got through character creation but no server to select. I had selected the standard server type as the first step. Nothing appears wrong on the server. Minilogin shows as connected to world. Will get you a screenshot in a sec.

[elkay]

Attached is screenshot of what I'm seeing. Also of note, many of my races are asking me to purchase them.

[Jabantiz]

Ok I just used the minilogin and live client (actually same version as your client) and it worked fine as you can see by this pic

serverselect.png

The fact that you have the [DEVL] in your pic as well as the races being locked seems to indicate something is going wrong with packets. So first thing is did you copy the xml structs (trunk/structs on svn) to the same folder that minilogin is in? Did you set up the world account in the login server DB and if so does the username/pass match the worldserver config file (loginserver.ini)?

[elkay]

Ok I just used the minilogin and live client (actually same version as your client) and it worked fine as you can see by this pic
serverselect.png

The fact that you have the [DEVL] in your pic as well as the races being locked seems to indicate something is going wrong with packets. So first thing is did you copy the xml structs (trunk/structs on svn) to the same folder that minilogin is in? Did you set up the world account in the login server DB and if so does the username/pass match the worldserver config file (loginserver.ini)?

Pulled the latest structs from SVN again. At some point I must have written some different ones there, as now when I launch the world I am seeing:

23:35:44 I World : Loading System Data...
23:35:50 E Packet : Warning: PacketStruct 'WS_DietyAbilities' uses an unknown opcode named 'OP_DietyAbilityWindow', this struct cannot be serialized directly.
23:35:51 I World : Loaded System Data (took 7 seconds)


I'm still getting the same disabled races and no server listed, though.

[Jabantiz]

You can ignore that warning, we are all getting it currently and it won't effect anything.

Usually with no server you can't even create a character, the fact that you can create seems to indicate that the login is sending that there is a world connected. Disabled races seems to indicate something going wrong with the packets I just don't know what as I cant reproduce it on my end. The minilogin should be using the same code that our login uses and you were able to create and select a server on that so it has to be some sort of configuration thing.

I will test a few things but I am currently at a loss of what is going wrong on your end.

[Jabantiz]

Did you set up a world account on your mini login? the login_worldservers table in the login DB, also make sure that your loginserver.ini has the same user/pass that you put into that table.

I just deleted my password from loginserver.ini and I got an error in world but minilogin still shows a server connected, when I log in I can start to create a character but all the races are locked.

Also the password in the table needs to be md5.

[elkay]

Did you set up a world account on your mini login? the login_worldservers table in the login DB, also make sure that your loginserver.ini has the same user/pass that you put into that table.

I just deleted my password from loginserver.ini and I got an error in world but minilogin still shows a server connected, when I log in I can start to create a character but all the races are locked.

Also the password in the table needs to be md5.

Yeah, I've done the password thing multiple times. There's only a certain number of things that could be failing here.

I decided to (again) clean slate my db. Since I want to get this up and running with some content, I would hate to get this to a working state at this point and then try to pull in content and start having problems again, so I opted to try to use what's currently in the SVN as a baseline. I'm also skipping Minilogin again for the moment, to try to minimize points of failure. In a nutshell:

I built the latest 0.7.3-dev x64 world from SVN here (simply opened solution in VS2017 and built for release, no code changes):

https://svn.eq2emulator.net/!/#eq2serve ... /trunk/win

I pulled structs from here:

https://svn.eq2emulator.net/!/#eq2serve ... nk/structs

I created an empty eq2 database and scripted in source from here:

https://svn.eq2emulator.net/!/#eq2conte ... mps/dev_db

I copied in scripts from here:

https://svn.eq2emulator.net/!/#eq2conte ... nk/scripts

My login_db.ini and world_db.ini both have correct MySQL login credentials.

My LoginServer.ini is as follows:

[LoginServer]
loginserver=eq2emulator.net
loginport=9100
worldname=EQ2 Rocks
worldaddress=eq2rocks.game-host.org
internalworldaddress=192.168.2.99
worldport=9105
locked=false
account=worldlogin
password=XXXXXXXX
autotableupdates=always
autotableverbose=false
autotabledata=true

[WorldServer]
Defaultstatus=
Unavailzone=

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

And using just this, my World output is as follows as it connects, updates, etc. There are a number of problems, including the initial database update failing because of a tables exists error. Also a bunch of other problems:

Module: EQ2EMu WorldServer, Version: 0.7.3-dev

Copyright (C) 2007-2011 EQ2Emulator. http://eq2emulator.net/

EQ2Emulator is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

EQ2Emulator is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.

/$$$$$$$$ /$$$$$$ /$$$$$$ /$$$$$$$$
| $$_____/ /$$__ $$ /$$__ $$| $$_____/
| $$ | $$ \ $$|__/ \ $$| $$ /$$$$$$/$$$$ /$$ /$$
| $$$$$ | $$ | $$ /$$$$$$/| $$$$$ | $$_ $$_ $$| $$ | $$
| $$__/ | $$ | $$ /$$____/ | $$__/ | $$ \ $$ \ $$| $$ | $$
| $$ | $$/$$ $$| $$ | $$ | $$ | $$ | $$| $$ | $$
| $$$$$$$$| $$$$$$/| $$$$$$$$| $$$$$$$$| $$ | $$ | $$| $$$$$$/
|________/ \____ $$$|________/|________/|__/ |__/ |__/ \______/
\__/

Website : http://eq2emulator.net
Forums : http://eq2emulator.net/phpBB3/
Contributors: http://eq2emulator.net/wiki/index.php/D ... ntributors
SVN : http://svn.eq2emulator.net/svn/eq2server

For more detailed logging, modify 'Level' param the log_config.xml file.

10:02:42 I Init : Starting EQ2Emulator WorldServer...
10:02:42 I DB : Using database 'eq2' at 127.0.0.1
10:02:42 D World : Randomizing World...
10:02:42 D Init : ./LoginServer.ini read...
10:02:42 I Patcher : Connecting to DB PatchServer...
10:02:42 I Patcher : Connected to patch server at updates.eq2emulator.net:9104
10:03:21 I Patcher : Downloading updates
10:03:29 I Patcher : Updates finished downloading
10:03:29 I Patcher : Executing updates
10:03:29 E Database : Error running MySQL queries from file 'eq2-updates.sql' (1050): Table 'item_details_adornments' already exists
10:03:29 I Patcher : Failed to update database
10:03:29 I World : Loading System Data...
10:03:34 E Packet : Warning: PacketStruct 'WS_DietyAbilities' uses an unknown opcode named 'OP_DietyAbilityWindow', this struct cannot be serialized directly.
10:03:36 E DBCore : #1146: Table 'eq2.statistics' doesn't exist
Query:
SELECT stat_id, stat_value, stat_date FROM statistics WHERE char_id=0 AND guild_id=0
10:03:36 I World : Loaded System Data (took 7 seconds)
10:03:36 W Threaded : Using Threaded loading of static data...
10:03:36 I Guilds : Loading Guilds...
10:03:36 W Thread : Item Loading Thread started.
10:03:36 I Guilds : Loaded 0 Guild(s)
10:03:36 I Recipes : Loading Recipe Books...
10:03:36 I DB : Using database 'eq2' at 127.0.0.1
10:03:36 W Thread : Spell Loading Thread started.
10:03:36 I Items : Loading Items...
10:03:36 I DB : Using database 'eq2' at 127.0.0.1
10:03:36 I Spells : Loading Spells...
10:03:36 D Recipes : Loaded 2619 Recipe Books
10:03:36 I Recipes : Loading Recipes...
10:03:36 D Recipes : Loaded 981 recipes
10:03:36 I Tradeskills: Loading Tradeskill Events...
10:03:36 D Tradeskills: Loaded 144 tradeskill events
10:03:36 I AA : Loading Alternate Advancements...
10:03:36 I AA : Loaded 0 Alternate Advancement(s)
10:03:36 I AA : Loading AA Tree Nodes...
10:03:36 I AA : Loaded 0 AA Tree Nodes
10:03:36 I Titles : Loading Titles...
10:03:36 D World : Loaded 472 Titles
10:03:36 I Languages : Loading Languages...
10:03:36 D World : Loaded 44 Languages
10:03:36 I Chat : Loading channels...
10:03:36 I LUA : Loading Spawn Scripts...
10:03:37 E LUA : Invalid Entry in spawn_scripts table for lua_script 'SpawnScripts/Generic/SpawnGroups.lua'
10:03:37 D LUA : Loaded 114358 SpawnScripts
10:03:37 I LUA : Loading Zone Scripts...
10:03:37 D LUA : Loaded 7 ZoneScripts
10:03:37 I World : Loading House Zone Data...
10:03:37 I World : Loading Heroic OP Data...
10:03:37 I World : Loading Race Types Data...
10:03:37 I World : - Loaded 0 Race Types
10:03:37 I World : Waiting for load threads to finish.
10:03:38 D Spells : Loading Spell Effects...
10:03:40 D Spells : Loaded 20437 Spell Effects.
10:03:40 D Spells : Loading Spell LUA Data...
10:03:40 D Spells : Loaded 25010 Spell LUA Data entries.
10:03:40 D Spells : Loading Spells Scripts...
10:03:43 D Items : Loaded 14674 Normal Items
10:03:43 D Items : Loaded 4205 Baubles
10:03:43 D Items : Loaded 350 Bags
10:03:43 D Items : Loaded 537 Books
10:03:43 D Items : Loaded 1609 Item Sets
10:03:43 D Items : Loaded 6677 House Items
10:03:43 D Items : Loaded 2627 Food Items
10:03:44 D Items : Loaded 20459 Weapons
10:03:44 D Items : Loaded 3548 Ranged Weapons
10:03:44 D Items : Loaded 157 Thrown Weapons
10:03:44 D Items : Loaded 62188 Armor Pieces
10:03:44 D Items : Loaded 5661 Shields
10:03:44 D Items : Loaded 24843 Skill Items
10:03:44 D Items : Loaded 0 Adornment Items
10:03:44 D Items : Loaded 25979 Recipe Book Items
10:03:44 D Items : Loaded 65 House Containers
10:03:44 D Items : Loading Item Appearances...
10:03:44 D Items : Loaded 0 Item Appearances
10:03:44 D Items : Loading Item Stats...
10:03:45 D Spells : Loaded 13552 SpellScripts
10:03:45 I Spells : Loaded 11500 Spells (took 9 seconds)
10:03:45 I Spells : Loading Spell Errors...
10:03:45 I Traits : Loading Traits...
10:03:45 I Traits : Loaded 0 Trait(s)
10:03:45 W Thread : Spell Loading Thread completed.
10:03:46 D Items : Loaded 451278 Item Stats
10:03:46 D Items : Loading Item Effects...
10:03:47 D Items : Loaded 167559 Item Effects
10:03:47 D Items : Loading Item Level Overrides...
10:03:47 D Items : Loaded 0 Item Level Overrides
10:03:47 I Items : Loaded 153029 Total Items (took 11 seconds)
10:03:47 I Collect : Loading Collections...
10:03:47 D Collect : Loaded 0 collections
10:03:47 D Collect : Loaded 0 collection items
10:03:47 D Collect : Loaded 0 collection rewards
10:03:47 I Merchants : Loading Merchants...
10:03:47 D Merchant : Clearing Merchant Inventory...
10:03:47 D Merchant : Loading Merchant Inventory...
10:03:47 D Merchant : Loaded 22638 Merchant Inventory Item(s)
10:03:47 D Merchant : Loaded 774 Merchant List(s)
10:03:47 I Quests : Loading Quests...
10:03:47 E LUA : Error loading cannot open Quests/Oakmyst/druids_legacy.lua: No such file or directory (file name: 'Quests/Oakmyst/druids_legacy.lua')
10:03:47 E LUA : Error loading cannot open Quests/StartcrestCommune/AngeliasCorrespondence.lua: No such file or directory (file name: 'Quests/StartcrestCommune/AngeliasCorrespondence.lua')
10:03:47 E LUA : Error loading cannot open Quests/StarcrestCommune/BogSludgeHunt.lua: No such file or directory (file name: 'Quests/StarcrestCommune/BogSludgeHunt.lua')
10:03:47 E LUA : Error loading cannot open Quests/StarcrestCommune/BuildingFawnsGarden.lua: No such file or directory (file name: 'Quests/StarcrestCommune/BuildingFawnsGarden.lua')
10:03:47 E LUA : Error loading cannot open Quests/StarcrestCommune/EruditeDebate.lua: No such file or directory (file name: ' Quests/StarcrestCommune/EruditeDebate.lua')
10:03:47 E LUA : Error loading cannot open Quests/StarcrestCommune/FarnsbysNewAxe.lua: No such file or directory (file name: 'Quests/StarcrestCommune/FarnsbysNewAxe.lua')
10:03:47 E LUA : Error loading cannot open Quests/StarcrestCommune/GatheringGlowmyst.lua: No such file or directory (file name: 'Quests/StarcrestCommune/GatheringGlowmyst.lua')
10:03:47 E LUA : Error loading cannot open Quests/StarcrestCommune/KittyWantstoPlay.lua: No such file or directory (file name: 'Quests/StarcrestCommune/KittyWantstoPlay.lua')
10:03:47 E LUA : Error loading cannot open Quests/StarcrestCommune/SoberingRemedy.lua: No such file or directory (file name: 'Quests/StarcrestCommune/SoberingRemedy.lua')
10:03:47 D Quest : Loaded 234 Quest(s)
10:03:47 W Thread : Item Loading Thread completed.
10:03:47 I World : Load threads finished.
10:03:47 I World : Total World startup time: 65 seconds.
10:03:47 D World : Starting factory Reader
10:03:47 D World : Starting factory Writer
10:03:47 I Net : World server listening on: eq2rocks.game-host.org:9105
10:03:47 I Net : World server listening on: 192.168.2.99:9105
10:03:47 I Zone : Starting static zones...
10:03:47 I IRC : Starting global IRC server...
10:03:47 D IRC : Connecting to IRC server irc.eq2emulator.net:6667.
10:03:47 D IRC : Successfully connected to the global IRC server!
10:03:47 D Thread : Starting console command thread...
10:03:47 I Console : Type 'help' or '?' and press enter for menu options.
10:03:47 D Thread : Starting autoinit loginserver thread...
10:03:48 I World : Connected to LoginServer: eq2emulator.net: 9100
10:03:48 D Login : Looking for Login Appearance Updates...
10:04:48 E DBCore : #1146: Table 'eq2.statistics' doesn't exist
Query:
INSERT INTO statistics (char_id, guild_id, stat_id, stat_value, stat_date) VALUES(0, 0, 101, 1514646216, 1514646216) ON DUPLICATE KEY UPDATE stat_value = 1514646216, stat_date = 1514646216;
10:04:48 E DBCore : #1146: Table 'eq2.statistics' doesn't exist
Query:
INSERT INTO statistics (char_id, guild_id, stat_id, stat_value, stat_date) VALUES(0, 0, 102, 0, 1514646216) ON DUPLICATE KEY UPDATE stat_value = 0, stat_date = 1514646216;
10:04:48 E DBCore : #1146: Table 'eq2.statistics' doesn't exist
Query:
INSERT INTO statistics (char_id, guild_id, stat_id, stat_value, stat_date) VALUES(0, 0, 107, 0, 1514646216) ON DUPLICATE KEY UPDATE stat_value = 0, stat_date = 1514646216;
10:04:48 E DBCore : #1146: Table 'eq2.statistics' doesn't exist
Query:
INSERT INTO statistics (char_id, guild_id, stat_id, stat_value, stat_date) VALUES(0, 0, 104, 0, 1514646288) ON DUPLICATE KEY UPDATE stat_value = 0, stat_date = 1514646288;
10:04:48 E DBCore : #1146: Table 'eq2.statistics' doesn't exist
Query:
INSERT INTO statistics (char_id, guild_id, stat_id, stat_value, stat_date) VALUES(0, 0, 105, 0, 1514646288) ON DUPLICATE KEY UPDATE stat_value = 0, stat_date = 1514646288;
10:04:48 E DBCore : #1146: Table 'eq2.statistics' doesn't exist
Query:
INSERT INTO statistics (char_id, guild_id, stat_id, stat_value, stat_date) VALUES(0, 0, 106, 0, 1514646288) ON DUPLICATE KEY UPDATE stat_value = 0, stat_date = 1514646288;

[elkay]

I stand freaking corrected. Doing everything above (which I'd done before), I am able to log into my server fully with a toon. Didn't do anything different than the other times! Annnnnyway.. going to check out Minilogin issue now.

Any thoughts on the above errors? The missing eq2.statistics error keeps popping up every 30-60 seconds on the world log.

[elkay]

Also, Minilogin is back to doing as before. Many races asking to purchase, server not listed at server select in last step of character creation.

I had initially had the eq2ls as a separate database, but I got the client version mismatch error again. I took the non-duplicate tables from eq2ls and merged them into the main eq2 database, and pointed Minilogin at the main eq2 database. Not sure if/how this would cause a problem.

[elkay]

Think I'm seeing the problem, at least as far as Minilogin is concerned. Looks like the opcode tables don't line up and neither has all of the data. Working on trying to merge them at the moment. Is there an already merged version somewhere that has all of them?

[elkay]

Nevermind, I'm an idiot and had select top 1000. Looks like the opcodes table in eq2 has everything. This returns no results:

select * from eq2ls.opcodes where id not in (select id from eq2.opcodes)

So.... still think this is an opcodes issue (maybe I somehow don't have the minilogin database script I need?).. but back to the drawing board.

[Cynnar]

10:03:34 E Packet : Warning: PacketStruct 'WS_DietyAbilities' uses an unknown opcode named 'OP_DietyAbilityWindow', this struct cannot be serialized directly.

This one can be ignored. I think you can remove this from the structs file if you want to suppress the warning.

10:03:36 E DBCore : #1146: Table 'eq2.statistics' doesn't exist

This one says you are missing statistics table in your e2 database. I think [mention]Jabantiz[/mention] said something before about a lockout timer on our patcher service. Wait 10 min or so before launching world again to make sure you are not locked out.

10:03:47 E LUA : Error loading cannot open Quests/Oakmyst/druids_legacy.lua: No such file or directory (file name: 'Quests/Oakmyst/druids_legacy.lua')

all these LUA errors are saying that it cannot find your scripts. All the scripts folders like Items, Quest, etc located on the SVN need to be in the same dir as the world.exe file.

Might I suggest that you also try to first connect to the old patcher

Code: Select all

updateserverport=9103

Then wait about 10 min then connect to new patcher

Code: Select all

updateserverport=9104

Then source in the current db.
The only thing I can think of is new patcher is not pushing some needed tables that old patcher does push.

Also make sure minilogin has the struct .XML files in the same dir as the .exe.

[elkay]

The script folders are all pulled from the SVN and in the same folder as the world exe. I'm not hitting any lockout timer like before with the update server. Tried switching back to 9103, didn't change anything. Minilogin exe is in the same folder as world, so should have the same access to the same files.

If I were to clean slate this (again), what order should I be doing the database work in? Obivously create the eq2 empty db first, then what? Should I let the patcher go next, or source the content db first? And should I patch against 9103 then 9104 or do one or the other? At what point should I be sourcing the loginserver script? Before or after all of this? (prefer one db instead of 2)

Going to keep farting around with this to see what I can come up with until you advise on best order of doing all of this.

[Cynnar]

Have you tried commenting out internalworldaddress? I don't even remember using this when I set mine up.

It seems like you have everything setup correctly with exception of login and World sharing the same db. It is possible to share, I made a server pack that way but it's outdated.

If you did nuke everything and start again I would start with login using separate db until you get everything working. I would connect to 9103 patcher first then connect to 9104 after. Check that you can connect, then source in the content after verification.

I don't think the server ghost likes you very much. I have the same problem with it. I always wind up with crazy things happening that no one else seems to have. Maybe we should name it.