Trying to connect with patched client

[elkay]

I'd say call him Lord Doljonijiarnimorinar, but we can just call him Lord Bob for short.

I'm back in the rhythm enough to be dangerous with this haha. I'll see what I can do with different combinations to work this out.

I had done clean again, 9103 didn't want to pull anything but it may have not been 10 minutes since I tried. 9104 pulled clean and I get no DB errors, including editing out that one struct that was throwing an error. I'd also gone your suggested route already of just living with minilogin pointing to a separate DB until it seems to be working, then deal with figuring out the merge after. On my client I got the client version mismatch again with it being separate DB - do I just copy the whole opcodes table over into the loginserver opcodes table to fix that?

[Cynnar]

Yes copy them over to eq2ls or whatever your loginserver db is.

[elkay]

Yes copy them over to eq2ls or whatever your loginserver db is.

Ok, that got me back to being able to get to character creation through Minilogin. This is a blank database updated from 9104, loginserver db sourced to a separate db from the script included with 1.04. Still the same problem of missing races and no server to select.

I tried connecting on 9103 again and it won't pull any updates. It was at least 30 minutes I waited before trying, so I don't think it's a blocking issue. Also, can you confirm if the opcodes pulled from update via 9104 are correct for Minilogin? One more thing to try - would you mind sharing the script I should be using to create the eq2ls database? Since my Minilogin was 1.03 even though it said 1.04 as the zip file name, I'm wondering if maybe that is also part of the problem. Also wondering about CommonStructs.xml/LoginStructs.xml.. I have those also from that 1.04 zip that may not be correct.

Btw, that "wrong" 1.04 zip file is out on the SVN.

https://svn.eq2emulator.net/!/#eq2serve ... login/1.04

Running out of things to try here lol!

[elkay]

FYI 9103 is still DOA against an empty (but created) eq2 database.

15:55:24 I Init : Starting EQ2Emulator WorldServer...
15:55:24 I DB : Using database 'eq2' at 127.0.0.1
15:55:24 D World : Randomizing World...
15:55:24 D Init : ./LoginServer.ini read...
15:55:24 I Patcher : Connecting to DB PatchServer...
15:55:24 I Patcher : Connected to patch server at updates.eq2emulator.net:9103
15:55:47 I World : Loading System Data...
15:55:47 E DBCore : #1146: Table 'eq2.opcodes' doesn't exist
Query:

[Cynnar]

Ok, that got me back to being able to get to character creation through Minilogin

If you can get to character creation then you have the latest opcodes, or at least the opcodes needed for your client. Minilogin would not let you get that far.

FYI 9103 is still DOA against an empty (but created) eq2 database.

After patching with the new patcher (9104) it will tell the old patcher (9103) that you are at or above patch level and patching is not needed.

would you mind sharing the script I should be using to create the eq2ls database?

I'm not able to grab this. I ran off and forgot half my laptop cord, and I will not be home until Thursday. Maybe someone else can help here. I will say I don't think anything has changed in the database since flight paths table was added, and I believe that minilogin would complain about missing tables.

Also wondering about CommonStructs.xml/LoginStructs.xml.. I have those also from that 1.04 zip that may not be correct.

These are not correct anymore. Use the ones from the source code SVN. Possibly why you are having issues.

The only other thing I can think of is your server is not properly registered in the eq2ls for minilogin. Can you create a character on your server if you are connected to loginserver and not minilogin?

[elkay]

I had an empty eq2 database when connecting to 9103 and it still wasn't giving me anything.

I had gotten to a point where I was able to get a character created and logged in via the public login server. I still have that backup I can restore to. Let me try seeing of CommonStructs/LoginStructs are wrong.

[elkay]

We're in business! Fully logged into the server via Minilogin into world with a toon!

So..... LoginStructs.xml was the culprit this whole time (regarding using Minilogin and missing races/no server list).

Now... quite literally the only place I found a different copy (that turns out to be I think the copy I need) was in the 1.8 Server Pack. If you can find the correct version of LoginStructs.xml *anywhere* else (even anywhere in SVN and even within "1.04" Minilogin zip file) please let me know where/how I overlooked it. The version I'm using is literally nowhere else that I can find.

Also - are the 2 neutral races disabled for everyone? Aerakyn and Freeblood... actually I had never heard of them until just now lol. I haven't played EQ2 Live in a few years.

[elkay]

Oh.. and also apparently my eq2ls.sql is also out of date, albeit usable. I think I need a more current version of that, too.

I just noticed in my Minilogin window:

17:02:01 D Login : Character 'Testtoon' (108) approved for server: EQ2 Rocks (1), data: 63227
17:02:01 D Login : Successfully created character 'Testtoon' (108) for account 1 on server_id 2!
17:02:23 D World : Removing connection...
17:02:59 D Login : Saving picture for account 2 character 108 server 1
17:02:59 E Database : Error 1146 running MySQL query: Table 'eq2ls.ls_character_picture' doesn't exist
INSERT INTO `ls_character_picture` (`server_id`, `account_id`, `character_id`, `picture`) VALUES (1, 2, 108, '89504e470d0a1a0a0000000d4948445200000060000000a6080600000025298a91000063004944415478daecbd696f6369962696c600066c4f55e5128b62d3beefa2568ada4589a42492a2a85d94487113f755fb120a8562c988c8aaacacacea19cfb4bba78d99e9b1a7c76e346cb86d63bcc2b061c01f6c6000fba3e14ff60ff0d7e3e739f72a227b71bbdb9591951d95020e2e455124ef79ce79ce73def7bdeffde8a31f7e7ef8f9e1e7879f1f7e7ef8f9e1e7879f1f7e7e

(that encoded string goes on quite longer than that but I snipped it)

[Cynnar]

17:02:59 E Database : Error 1146 running MySQL query: Table 'eq2ls.ls_character_picture' doesn't exist

I believe that this is for the paperdoll. You can turn off paperdoll in the database. Not sure where, but [mention]Jabantiz[/mention] said it was possible.

Now... quite literally the only place I found a different copy (that turns out to be I think the copy I need) was in the 1.8 Server Pack.

Hmm, I could have sworn that Jabantiz had committed that to SVN. Will do that when I get home if Jab doesn't get to it first.

are the 2 neutral races disabled for everyone? Aerakyn and Freeblood... actually I had never heard of them until just now lol. I haven't played EQ2 Live in a few years.

I'm not sure on this. I think Jabantiz added Aerakyn at some point, but I've not tested.

I'm the same way I stopped playing live around 2011. AoD was released, but I didn't play much then, and ironically it is the client is use the most.i rarely connect with the latest live that is connectable.

[Jabantiz]

First of all 9103 will not work with ne code, that is the old patcher and the new patcher currently on svn can't communicate with it correctly so it will just hang and time out and eventually continue on. Current SVN should only be using 9104.

When starting from a fresh db you need to hit the patcher first to create the tables, then source the dump from content svn after, this is because content svn does not include every table like character and statistics, after all you don't need a copy of the player info for your own server.

All structs should be in the struct folder and they are all up to date. Can you not see the login server structs in that folder? Should be there for minilogin server users.

Login db very rarely changes, I think the table you are missing is the only change in the past couple of years. Here is the create code for that table.

Code: Select all

CREATE TABLE `ls_character_picture` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`server_id` INT(10) UNSIGNED NOT NULL,
	`account_id` INT(10) UNSIGNED NOT NULL,
	`character_id` INT(10) NOT NULL,
	`picture` TEXT NOT NULL,
	PRIMARY KEY (`id`),
	UNIQUE INDEX `character_id` (`character_id`, `server_id`, `account_id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;

And this is for character pictures like Cynnar said.

[Jabantiz]

Also - are the 2 neutral races disabled for everyone? Aerakyn and Freeblood... actually I had never heard of them until just now lol. I haven't played EQ2 Live in a few years.

Both should be enabled, I know Freeblood is for sure as that was a hassle trying to figure it out, I am pretty sure I got Aerakyn enabled as well, I will have to double check on them to be sure though.

[elkay]

Thanks, Jabantiz!

Table creation fixed the Minilogin error. That table was missing.

If the LoginStructs.xml is on the SVN in a structs folder, that file is not publicly viewable. Also, if that file controls the last 2 races being playable, it's possible mine is still not the most recent version.

[Jabantiz]

Yea it is in the structs folder, thought it was a public file like the rest. Here is the latest version of it.

[elkay]

Also, regarding the few script errors I still see. As far as I can tell, I'm completely current from the SVN on those. The errors I still see are:

19:02:13 I LUA : Loading Spawn Scripts...
19:02:13 E LUA : Invalid Entry in spawn_scripts table for lua_script 'SpawnScripts/Generic/SpawnGroups.lua'
19:02:14 D LUA : Loaded 114358 SpawnScripts

And

19:02:24 I Quests : Loading Quests...
19:02:24 E LUA : Error loading cannot open Quests/Oakmyst/druids_legacy.lua: No such file or directory (file name: 'Quests/Oakmyst/druids_legacy.lua')
19:02:24 E LUA : Error loading cannot open Quests/StartcrestCommune/AngeliasCorrespondence.lua: No such file or directory (file name: 'Quests/StartcrestCommune/AngeliasCorrespondence.lua')
19:02:24 E LUA : Error loading cannot open Quests/StarcrestCommune/BogSludgeHunt.lua: No such file or directory (file name: 'Quests/StarcrestCommune/BogSludgeHunt.lua')
19:02:24 E LUA : Error loading cannot open Quests/StarcrestCommune/BuildingFawnsGarden.lua: No such file or directory (file name: 'Quests/StarcrestCommune/BuildingFawnsGarden.lua')
19:02:24 E LUA : Error loading cannot open Quests/StarcrestCommune/EruditeDebate.lua: No such file or directory (file name: ' Quests/StarcrestCommune/EruditeDebate.lua')
19:02:24 E LUA : Error loading cannot open Quests/StarcrestCommune/FarnsbysNewAxe.lua: No such file or directory (file name: 'Quests/StarcrestCommune/FarnsbysNewAxe.lua')
19:02:24 E LUA : Error loading cannot open Quests/StarcrestCommune/GatheringGlowmyst.lua: No such file or directory (file name: 'Quests/StarcrestCommune/GatheringGlowmyst.lua')
19:02:24 E LUA : Error loading cannot open Quests/StarcrestCommune/KittyWantstoPlay.lua: No such file or directory (file name: 'Quests/StarcrestCommune/KittyWantstoPlay.lua')
19:02:24 E LUA : Error loading cannot open Quests/StarcrestCommune/SoberingRemedy.lua: No such file or directory (file name: 'Quests/StarcrestCommune/SoberingRemedy.lua')
19:02:24 D Quest : Loaded 234 Quest(s)

No idea on the SpawnScripts error, but as far as the quests, there is no Quests/StarcrestCommune folder on the SVN, so those 8 errors are valid. There is also no Quests/Oakmyst/druids_legacy.lua on the SVN.

[elkay]

Yea it is in the structs folder, thought it was a public file like the rest. Here is the latest version of it.

Cool beans, will try this now.

Also, not sure you weeded through every single one of my posts, but I also found that the Minilogin zip file on the SVN, though it says 1.04, is actually only 1.03. I was already given a working copy of 1.04, but that zip file should probably be updated with proper 1.04, as well as this struct file and .sql with the missing table.