Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #31  
Old 11-18-2013, 01:05 AM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

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)
Reply With Quote
  #32  
Old 11-18-2013, 01:18 AM
lerxst2112
Demi-God
 
Join Date: Aug 2010
Posts: 1,743
Default

Try 127.0.0.1 rather than localhost.
Reply With Quote
  #33  
Old 11-18-2013, 06:20 PM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

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.
Reply With Quote
  #34  
Old 11-19-2013, 12:39 AM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

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.
Reply With Quote
  #35  
Old 11-19-2013, 02:16 PM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

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.
Reply With Quote
  #36  
Old 11-19-2013, 03:07 PM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

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.
Reply With Quote
  #37  
Old 11-20-2013, 03:15 PM
wolfwalkereci
Discordant
 
Join Date: Dec 2005
Posts: 435
Default

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.
__________________

Reply With Quote
  #38  
Old 11-21-2013, 02:57 PM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

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.
Reply With Quote
  #39  
Old 11-21-2013, 03:41 PM
wolfwalkereci
Discordant
 
Join Date: Dec 2005
Posts: 435
Default

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?
__________________

Reply With Quote
  #40  
Old 11-21-2013, 04:28 PM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

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).
Reply With Quote
  #41  
Old 11-25-2013, 10:09 PM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

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!
Reply With Quote
  #42  
Old 12-05-2013, 07:53 PM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

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>
login.ini:
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
Reply With Quote
  #43  
Old 12-07-2013, 08:26 PM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

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.
Reply With Quote
  #44  
Old 07-28-2016, 09:28 PM
Fangb0n3r
Fire Beetle
 
Join Date: Jun 2007
Posts: 4
Default

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.
Reply With Quote
  #45  
Old 07-28-2016, 09:55 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

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

Compilin' Dirty
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 09:23 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3