Server Up for 2 Weeks, Now Won't Connect

Emmeric · #1 09-06-2011, 02:59 PM

Hi all:

Ran into Chardok with the wife on our server and logged out to make some item changes to the warrior epic. We've been playing for a couple weeks now - server restarts multiple times per day.

Suddenly now, I get an error popup when the .bat window reaches Loading zones...

Code:

[09.06. - 12:36:29] Starting Log: logs/eqemu_debug_world_3360.log
[09.06. - 12:36:29] [WORLD__INIT] Loading server configuration..
[09.06. - 12:36:29] [WORLD__INIT] Log settings loaded from log.ini
[09.06. - 12:36:29] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEmulator 0.8.0
[09.06. - 12:36:29] [WORLD__INIT] Added loginserver eqemulator.net:5998
[09.06. - 12:36:29] [WORLD__INIT] Connecting to MySQL...
[09.06. - 12:36:29] [WORLD__INIT] HTTP world service disabled.
[09.06. - 12:36:29] [WORLD__INIT] Loading variables..
[09.06. - 12:36:29] [WORLD__INIT] Loading zones..

[09.06. - 12:02:47] Starting Log: logs/eqemu_debug_0664.log
[09.06. - 12:02:47] [LAUNCHER__INIT] Loading server configuration..
[09.06. - 12:02:48] [NET__WORLD] WorldConnection connect: Connecting to the server localhost:9000 failed: TCPConnection::Connect(): connect() failed. Error: 10061
[09.06. - 12:02:48] [LAUNCHER__ERROR] worldserver.Connect() FAILED! Will retry.
[09.06. - 12:02:48] [LAUNCHER__INIT] Starting main loop...

I have read the threads about this error. This is what I have done:

I first erased the changes I made to the epic.
Then I deleted the epic from my inventory using Navicat in the inventory table.
Then I restarted the router.
Then I downloaded and installed SP4 for SQL2000.... from Microsoft.
I made sure my ports specifically for eqemu and my server were all open.
I reset my modem AND router.
I made sure I had a proper network connection using the wizard.
I double-checked my configs.

Still no connection.

Here is my config... though nothing changed since I started the server without hitches this morning...

Code:

<server>
	<world>
		<shortname>Butte</shortname>
		<longname>The Iron Knights</longname>

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

		<!-- Loginserver information.  Defaults shown -->
		<loginserver>
			<host>eqemulator.net</host>
			<port>5998</port>
			<account></account>
			<password></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="localhost" port="9000" telnet="disable"/>

		<!-- Sets the shared key used by zone/launcher to connect to world -->
		<key>xxxxxxxxxxxxxxxxxx</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>7779</port>
	</mailserver>

	<zones>
		<defaultstatus>0</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>localhost</host>
		<port>3306</port>
		<username>xxxxxxxxxxxxxxx</username>
		<password>xxxxxxxxx</password>
		<db>peq</db>
	</database>

	<!-- Launcher Configuration -->
	<launcher>
		<!-- <logprefix>logs/zone-</logprefix> -->
		<!-- <logsuffix>.log</logsuffix> -->
		<!-- <exe>zone.exe</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>

So... what am I missing here and do any of you have any suggestions?

Emmeric · #2 09-06-2011, 11:37 PM

Lacking suggestions, I obliterated all my files and reinstalled everything.

It works now, but I still have zero clue what might have caused a sudden failure to connect when I had a 2-week string of successes.

If anyone bothers to read this that has an answer... I used Navicat to attempt a dump of some of my DB tables. While it appeared to leave a dump file, it wouldn't source it when I tried to a few minutes later. Any suggestions there on dumping individual tables?

In the meantime, I am resorting to frequent db backups in its entirety.

**Akkadius** · #3 09-06-2011, 11:56 PM

Quote:

Originally Posted by Emmeric

Lacking suggestions, I obliterated all my files and reinstalled everything.

It works now, but I still have zero clue what might have caused a sudden failure to connect when I had a 2-week string of successes.

If anyone bothers to read this that has an answer... I used Navicat to attempt a dump of some of my DB tables. While it appeared to leave a dump file, it wouldn't source it when I tried to a few minutes later. Any suggestions there on dumping individual tables?

In the meantime, I am resorting to frequent db backups in its entirety.

Sounds like you are running this out of your house and your ISP's DHCP lease on your router/modem expired.

http://whatsmyip.org

Just a guess.

Emmeric · #4 09-07-2011, 01:13 AM

I use the EQEmu login server. I don't think I have my IP in any of the configs.

We have the server up and running now and can make characters, however, there are no mobs.

No NPCs, no mobs, nothing. All empty. My NPC tables are all in the DB and full...

Anyone have a hint on this one? It's late for me here... why is my world empty?

lerxst2112 · #5 09-07-2011, 01:37 AM

If you updated code, make sure you also applied the required sql updates.

Check your logs for errors. If queries are failing you'll probably see something in there.

Emmeric · #6 09-07-2011, 09:09 AM

Quote:

Originally Posted by lerxst2112

If you updated code, make sure you also applied the required sql updates.

Check your logs for errors. If queries are failing you'll probably see something in there.

I am pretty sure I got everything required over 1900, but I will go back and hit everything else I thought I didn't need (the bot updates).

I was wondering during the night whether my mysql version was causing it (5.1.54) but I would think the entire server would be unloadable, not just NPCs.

Your post sounds correct. Will post back results.

Emmeric · #7 09-07-2011, 10:46 AM

Required bot spells. Didn't think I needed it because I don't use bots. Shows you what thinking does.... All fixed now.

haha

Thanks, lerxst.

Emmeric · #8 09-07-2011, 03:20 PM

Quote:

Originally Posted by Akkadius

Sounds like you are running this out of your house and your ISP's DHCP lease on your router/modem expired.

http://whatsmyip.org

Just a guess.

Assuming this might have been the case, what might I have done to avoid or fix this without having to completely reinstall the DB and emulator?

Emmeric · #9 10-16-2011, 12:14 PM

Hmm, everything was running smooth and again the connection issue.

Opening Navicat, I cannot connect to Localhost_3306. Connected fine yesterday.

Error is:

2003 Can't connect to MySQL server on 'localhost' (10061)

MySQL webpages indicate this is a network connection issue. Why is this, what should I be doing and how do I prevent this repeating error in the future?

Emmeric · #10 10-16-2011, 05:00 PM

Since I wasn't getting any responses, I uninstalled mysql and reinstalled.

I was able to connect to my DB right away using Navicat, but upon investigating an error regarding the "Hackers" table, the whole thing locked out again with a connection issue.

What I saw before it locked up was the Hackers table empty - but empty as in not even a field with a (null) in it.

So, I uninstalled mysql and reinstalled again. Then, I attempted to back-up my DB using a back-up copy. Mysql refused to use the back-up. Couldn't open it.

Since I had just connected, I made a new back-up and then attempted to start the server after the Hackers Table deletion.

Server started fine and we are logged in.

My question is, what caused mysql to stop reading my db and/or why did the Hackers Table corrupt itself and cause this and how do I avoid it in the future?

I set my Lan to reserve an IP for my machine. If it was a connection issue, then that should be solved for the future. But what of the table?

(note: we have 3 accounts on the server, all in the same house. None of us attempted to "hack" anything.

Emmeric · #11 10-16-2011, 09:10 PM

Well, that didn't really work, either. A complete reinstall of mysql worked exactly once. Cannot backup the Db and any attempt to restart the server after being shut down results in a failure to connect.

Using navicat to connect, I get an error trying to connect to localhost_3306:

2003 - Can't connect to MySql server on 'localhost' (10061)

Any input? At all?

ChaosSlayerZ · #12 10-16-2011, 10:33 PM

its possible that your DB and its backup got corrupted. Specially if you keeping them both on same HDD, and it got a bad sector somewhere

Emmeric · #13 10-17-2011, 09:13 AM

Quote:

Originally Posted by ChaosSlayerZ

its possible that your DB and its backup got corrupted. Specially if you keeping them both on same HDD, and it got a bad sector somewhere

A restart fixed the 2003 error and a diskcheck ran during the reboot on its own. There must have been some kind of corruption, though my hdd is solid state. Probably some descriptor somewhere.