EQEmulator Forums - reviving a somewhat older windows server, have some questions

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - reviving a somewhat older windows server, have some questions (https://www.eqemulator.org/forums/showthread.php?t=37521)

I'm also getting a TON of errors in every single zone launch and on other files:

queryserv:

Code:

---------------------------------------------

[11.17. - 23:56:07] Starting Log: logs/eqemu_error_queryserv_3732.log

[11.17. - 23:56:07] Failed to connect to database: Error: #2003: Can't connect to MySQL server on 'localhost' (0)

Various zone errors, all the same it seems:

Code:

---------------------------------------------

[11.17. - 23:56:17] Starting Log: logs/eqemu_error_zone_3584.log

[11.17. - 23:56:17] Error in Zone::LoadTickItems: SELECT it_itemid, it_chance, it_level, it_qglobal, it_bagslot FROM item_tick (#1146: Table 'peq.item_tick' doesn't exist)

Try 127.0.0.1 rather than localhost.

lerxst thanks, that got me a bit further. Still having issues but I think that's from losing the login database and having to rebuild it by hand, slowly.

ok new stumbling block. I redid my eqemu_config.xml and login.ini because my old versions were out of date and missing stuff for queryserv and what not. After fiddling with IPs and account names, I'm now to this in the login server window. Everything else seems to be functional at this point. ALL of my internal IPs are now 127.0.0.1, because using the computer's own address of 192.168.1.5 would get rejected for some strange reason.

Code:

[Debug] [11.18.13 - 23:28:45] Logging System Init.

[Debug] [11.18.13 - 23:28:45] Config System Init.

[Debug] [11.18.13 - 23:28:45] MySQL Database Init.

[Debug] [11.18.13 - 23:28:45] Encryption Initialize.

[Debug] [11.18.13 - 23:28:45] Encryption Loaded Successfully.

[Debug] [11.18.13 - 23:28:45] Server Manager Initialize.

[Network] [11.18.13 - 23:28:45] ServerManager listening on port 5998

[Debug] [11.18.13 - 23:28:45] Client Manager Initialize.

[Network] [11.18.13 - 23:28:45] ClientManager listening on Titanium stream.

[Network] [11.18.13 - 23:28:45] ClientManager listening on SoD stream.

[Debug] [11.18.13 - 23:28:45] Server Started.

[Network] [11.18.13 - 23:28:58] New world server connection from 127.0.0.1:49613

[Network Error] [11.18.13 - 23:28:58] Handle_NewLSInfo error, remote address was null, defaulting to stream address 127.0.0.1.

[World] [11.18.13 - 23:28:58] Server Tallon Zek Reborn(TZR) did not attempt to log in but this server requires a password.

EDIT: nevermind. Solved it. I had the password for the server login table encrypted SHA like accounts are, put it into plaintext and it worked fine. :)

Ok, I think this might be the last step to getting the server reanimated from the grave. I had forgotten that the old login db was a separate db, so in my fury to delete/reinstall mysql a few times a couple days ago, I deleted the whole directory after dumping peq, but forgetting about peqlogindb. I didn't empty recycle bin, recovered the raw data files, but don't have the server instance or anything in registry left. What's the easiest way to attach those raw data files to a server to extract whats in them? If I can get access, I can just migrate the data easy enough.

Edit: don't have the account data file..only had the adminregistration table and serverlisttype >.< by hand it is.

Sounds like you have really been thrown some bad luck here.
Hope you figure it out, I'll watch this thread for a few days in case you have more issues that I might be able to assist with.

Thanks Wolf, I think I actually managed to figure out most of it. I had to rebuild the login table by hand, which ended up making the tblLoginAccounts ID field out of sync with Accounts.lsaccount_id, so a simple query to rewrite that id to match the login table data made the rest sync up. Successfully logged in with multiple accounts now, characters, tested fights...I did briefly encounter a "invulnerable to melee" issue, but haven't since a reboot.

I do believe that unless unforeseen issues come up, the server is ready for play again, and luckily, all character and valuable player data is intact. :)

Thats good to hear. Also you made sure, double checked & triple checked, to run all the SQL that match up with the version of source you are updating to?

Yep, did that successfully. I'm still being very alert to other possible bugs popping up as a result of this transfer, but I'd rather have the headaches than lose all the progress the server has on its 50 or so characters, most of whom are max level (but horribly under-geared). :)

Just because I know a couple people are watching and have helped me a lot already, I just wanted to report everything looks smooth so far, and thank you for the assistance! :)

Ok I'm back. System works great on LAN...will not work for clients outside the router. They can get logged in and get to the server select screen..but they can't get character select. Black screen and dump to login screen. I know I have the port forwards needed (I did 7000-7100, 9000, and 5990-5999, to catch any ranges the server might want). I've gone so far as to temporarily DMZ the server machine itself. The OS firewall is completely disabled (and wouldn't matter since local works fine), and antivirus is not interfering either.

The only two things I can think of at this point would be either a config file being wrong somewhere, or Verizon FIOS blocking the world server's incoming ports, but not the login server's. When I watch the command windows on the server, internally I see the login server catch and resolve the login, then disconnect as it hands the client off to the world server, which I see clearly pick it up and proceed happily. When the client is remote instead of local, I see the login server pick up, resolve, and hand off...but the world server never receives the handoff.

To clarify, I'm using the SoD client, and it works internally perfectly...just does not work externally...and the server at this point is DMZ'd.

I shall include my eqemu_config.xml and login.ini files for scrutiny.

eqemu_config.xml:

Code:

<?xml version="1.0"?>

<server>

        <world>

                <shortname>TZR</shortname>

                <longname>Tallon Zek Reborn</longname>



                <!-- Only specify these two if you really think you need to.  (read: You don't) -->

                <address>96.252.231.59</address>

                <localaddress>192.168.1.25</localaddress>



                <!-- Loginserver information.  Defaults shown -->

                <loginserver>

                        <host>192.168.1.25</host>

                        <port>5998</port>

                        <account>(scrubbed for forum)</account>

                        <password>(scrubbed for forum)</password>

                </loginserver>



                <!-- Server status.  Default is unlocked -->

                <!--<locked/>-->

                <!-- <unlocked/> -->



                <!-- Sets the ip/port for the tcp connections.  Both zones and console (if enabled).  Defaults are shown -->

                <tcp ip="192.168.1.25" port="9000" telnet="disable"/>



                <!-- Sets the shared key used by zone/launcher to connect to world -->

                <key>(scrubbed for forum)</key>



                <!-- Enable and set the port for the HTTP service.  Defaults are shown -->

                <http port="9080" enabled="false" mimefile="mime.types" />

        </world>



        <!-- Chatserver (channels) information.  Defaults shown -->

        <chatserver>

                <host>channels.eqemulator.net</host>

                <port>7778</port>

        </chatserver>



        <!-- Mailserver (in-game mail) information.  Defaults shown -->

        <mailserver>

                <host>channels.eqemulator.net</host>

                <port>7778</port>

        </mailserver>



        <zones>

                <defaultstatus>20</defaultstatus>



                <!-- Sets port range for world to use to auto configure zones -->

                <ports low="7000" high="7100"/>

        </zones>



        <!-- Database configuration, replaces db.ini.  Defaults shown -->

        <database>

                <host>192.168.1.25</host>

                <port>3306</port>

                <username>root</username>

                <password>(scrubbed for forum)</password>

                <db>peq</db>

        </database>



        <qsdatabase>

                <host>192.168.1.25</host>

                <port>3306</port>

                <username>root</username>

                <password>(scrubbed for forum)</password>

                <db>peq</db>

        </qsdatabase>



        <!-- Launcher Configuration -->

        <launcher>

                <!-- <logprefix>logs/zone-</logprefix> -->

                <!-- <logsuffix>.log</logsuffix> -->

                <!-- <exe>zone.exe or ./zone</exe> -->

                <!-- <timers restart="10000" reterminate="10000"> -->

        </launcher>



        <!-- File locations.  Defaults shown -->

        <files>

                <!-- <spells>spells_us.txt</spells> -->

                <!-- <opcodes>opcodes.conf</opcodes> -->

                <!-- <logsettings>log.ini</logsettings> -->

                <!-- <eqtime>eqtime.cfg</eqtime> -->

        </files>

        <!-- Directory locations.  Defaults shown -->

        <directories>

                <!-- <maps>Maps</maps> -->

                <!-- <quests>quests</quests> -->

                <!-- <plugins>plugins</plugins> -->

        </directories>

</server>

Code:

[database]

host = 192.168.1.25

port = 3306

db = peq

user = root

password = (scrubbed for forum)

subsystem = MySQL



[options]

unregistered_allowed = FALSE

reject_duplicate_servers = FALSE

trace = TRUE

world_trace = FALSE

dump_packets_in = FALSE

dump_packets_out = FALSE

listen_port = 5998

local_network = 192.168.1.



[security]

plugin = EQEmuAuthCrypto

mode = 5



[Titanium]

port = 5998

opcodes = login_opcodes.conf



[SoD]

port = 5999

opcodes = login_opcodes_sod.conf



[schema]

account_table = tblLoginServerAccounts

world_registration_table = tblWorldServerRegistration

world_admin_registration_table = tblServerAdminRegistration

world_server_type_table = tblServerListType

Ok guys, figured it out I believe.
I have one of Verizon's newest ActionTec routers. I DO have the ports forwarded correctly, but for some lame reason, on the new models, the firewall inbound policy overrides the port forwards, whereas on previous models, the forwards overrode the global policy. I had to kill that policy and suddenly it works. Take note for anyone else with a similar issue. :)

I'm currently the one working with Khalathas, trying to connect to his server from my home PC via internet, OUTSIDE his LAN. I log in just fine, server select works fine, but when I get to Character Select, nothing works. I can see (and select between) my characters that were already there from when the server was active before. None of the buttons are responsive at all: Create New Character, Delete Character, Enter World, Quit... None of them trigger anything when clicked. Also, the character models seem glitchy and unstable.

I'm running Windows 10 (not activated), AMD FX 9370 8-core CPU, 32 GB DDR3 RAM, Dual MSI GTX660 Ti's in SLI

I have EQ operating from a single core on my CPU and I have Windows Firewall turned off. I'm using the EXACT SAME client file as Khalathas is using to connect locally.

Do you have a way of testing on a non-win10 machine?