Trying to connect with patched client

[elkay]

FYI, here is where it has SVN crossed out with GIT references. (in case it needs updating)

http://wiki.eqemulator.org/p?Complete_W ... etup_Guide

CANCEL THAT. Shit. My wine (not the linux version) wandered me to EQ1. Fail! Bear with me, this is my week off work and here I am still in front of a PC doing coding and SQL and server maintenance LOL!

[tyrbo]

[elkay]

Back to looking at this.. I see that the eq2 database (what I called my world db) and eq2ls database have some overlap. Is there a reason these were kept separate? I restored my eq2 db from backup again so that eq2ls script doesn't overwrite anything. Should I keep these separate, or perhaps a [better] merge attempt? I have my EQ1 database including login running off a single DB. Not that it's needed.. just seems better self-contained. What do you recommend?

[tyrbo]

The ones that overlap can probably live together, I had mine living together locally.
They were probably kept separate to avoid issues, but I didn't notice anything weird happening with them together.

Which ones overlap? Opcodes?

[elkay]

The ones that overlap can probably live together, I had mine living together locally.
They were probably kept separate to avoid issues, but I didn't notice anything weird happening with them together.

Which ones overlap? Opcodes?

I don't have the script output copied, but there was a bunch of deletes and inserts, with the deletes massively outweighing the insert #s. Backing out yet again, and tweaking a few things (buzz at this point and don't recall the exact ini changes), I got a whollllllle lot of green output now launching world (without minilogin) and a bunch of successful updates. Was still on port 9103. Still have the same red errors as previous, but hadn't made any of those suggested fixes yet. Closer to a fully working server without error. Something I noticed (but maybe never realized) - I don't get a server select. If I set the eq2emulator login server, do we not have options of our own servers? Is Minilogin the only option for that?

[tyrbo]

Server selection happens during character creation.

As far as I'm aware, 9104 is the _new_ updater port. If you can use 9104, you should.

[elkay]

Server selection happens during character creation.

As far as I'm aware, 9104 is the _new_ updater port. If you can use 9104, you should.

Tried switching after the previous success.

22:46:20 D Patcher : -Checking for updates.
22:46:25 W Patcher : Please wait...
22:46:50 D Patcher : --DB Schema exists! Checking for updates...
22:46:50 E Patcher : Error while getting updates!
22:46:50 I Patcher : DB Update check completed...

This is with 0.7.2 pre-compiled version.

[tyrbo]

Yeah, you'll most likely need a newer version from svn to use the new updater.

[Cynnar]

If I'm not mistaking, bugs table is the only table different in eq2ls and world. You can merge them together, or rather import the tables that only exist for eq2ls into world database.and have just one database.

A log file would help us determine what errors you are getting and how to fix it. Make sure you use the struct.xml files found in the source structs folder. Needs to be in same folder as world.exe (Loginserver needs structs.xml as well). Other possibilities are missing tables or columns, and all scripts folders should go into same sir as world.exe. Those are the most common reasons for errors.

Be sure you registered your server Account Management or your server will no show up on our login server.

9104 may be down. There was an IP change, and I'm not sure if Jabantiz has fixed it yet. Other than opcodes, everything should be in the database dump, and [mention]Ememjr[/mention] may have latest opcodes.

[Jabantiz]

We do not have a pre-compiled version for the new patcher yet. To use the new patcher you need to compile the source yourself from svn, using the precompiled exe's the old patcher on port 9103 should work.

As for your errors when updating it looks like it is trying to insert data but the table structure is off, try nuking your entire db for world then running it again.

[elkay]

We do not have a pre-compiled version for the new patcher yet. To use the new patcher you need to compile the source yourself from svn, using the precompiled exe's the old patcher on port 9103 should work.

As for your errors when updating it looks like it is trying to insert data but the table structure is off, try nuking your entire db for world then running it again.

Ok, that's probably a combination of the issue. Is the latest source compatible with live checked into the SVN? I'll also try a DB nuke (as stated, no real character data beyond creation).

[tyrbo]

Yes, the code on the public svn should work with live.

[elkay]

Rebuilding from SVN now. Building debug (didn't check before building). Was successful. Rebuilding release.

[elkay]

Build succeeded. Crash on launch from server. This was a clean server, eq2 database fresh create:

C:\EQ\EQ2EmuServer>eq2world
Module: EQ2EMu WorldServer, Version: 0.7.2

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.

00:07:49 I Init : Starting EQ2Emulator WorldServer...
00:07:49 I DB : Using database 'eq2' at 127.0.0.1
00:07:49 D World : Randomizing World...
00:07:49 D Init : ./LoginServer.ini read...
00:07:49 I Patcher : Connecting to DB PatchServer...
00:07:49 D Patcher : -Connected to Update Server: updates.eq2emulator.net:9104
00:07:49 D Patcher : -Checking for updates.
00:07:54 W Patcher : Please wait...
00:08:19 E DBCore : #1146: Table 'eq2.table_versions' doesn't exist
Query:
SHOW COLUMNS FROM table_versions
00:08:19 E Patcher : Version Table NOT Found! Creating...
00:08:19 D Patcher : --Setting table_version = 1...
00:08:19 E Patcher : Error while getting updates!
00:08:19 I Patcher : DB Update check completed...
00:08:19 I World : Loading System Data...
00:08:19 E DBCore : #1146: Table 'eq2.opcodes' doesn't exist
Query:
select distinct version_range1, version_range2 from opcodes
00:08:21 E DBCore : #1146: Table 'eq2.character_skillbar' doesn't exist
Query:
SELECT max(id) FROM character_skillbar
00:08:21 E DBCore : #1146: Table 'eq2.commands' doesn't exist
Query:
SELECT command, handler, required_status FROM commands where length(subcommand) = 0 ORDER BY handler asc
00:08:21 E DBCore : #1146: Table 'eq2.commands' doesn't exist
Query:
SELECT command, subcommand, handler, required_status FROM commands where length(subcommand) > 0 ORDER BY handler asc
00:08:21 E DBCore : #1146: Table 'eq2.factions' doesn't exist
Query:
SELECT id, name, type, description, default_level, negative_change, positive_change FROM factions

C:\EQ\EQ2EmuServer>

[elkay]

FYI.. been coder and also dev/qa support at once. Help me work with you through this.