queryserv.exe stuck on "Connecting To Mysql"

[AdrianD]

Try putting the comments back for this section.

	<!-- 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>

Quote for the guide on the wiki.

<launcher>
        <exe>zone.exe</exe>
        <!-- or... -->
        <exe>./zone</exe>
</launcher>
This option allows you to specify which zone binary the launcher will run. If you build your zone with perl support into ZonePerl.exe instead of Zone.exe, you can specify that here.

<launcher>
        <timers initial="20000" interval="2000" restart="10000" reterminate="10000">
</timers></launcher>
This element lets you configure various timers that the launcher uses. All values are in milliseconds.

restart - This is the time between when a zone goes down, and when it is started back up again.
reterminate - This is how long we wait after sending a kill signal to a zone before killing it again.
initial - This is the time we wait after booting the first zone on the machine before booting any more zones (to let shared memory load).
interval - This is the time between booting each subsequent zone.

<!-- File locations.  Defaults shown -->
<files>
        <!-- <spells>spells_us.txt</spells> -->
        <!-- <opcodes>opcodes.conf</opcodes> -->
        <!-- <logsettings>log.ini</logsettings> -->
        <!-- <eqtime>eqtime.cfg</eqtime> -->
</files>
These entries are provided if you need to override the names or locations of the needed files. You probably don't need to change these settings.

<!-- Directory locations.  Defaults shown -->
<directories>
        <!-- <maps>Maps</maps> -->
        <!-- <quests>quests</quests> -->
        <!-- <plugins>plugins</plugins> -->
</directories>
These entries are provided if you need to override the names or locations of the needed directories. You probably don't need to change these settings.

Comment out the launcher lines, specifically.

If you know what you are doing, by all means uncomment, comment, change, do whatever you want. If you are a novice like me, I suggest leaving things as they are UNTIL you get things up and running.

[AdrianD]

My server is listed on the server list as unlocked (I.E, it no longer says "locked", it now says 0), and a couple people have even joined it. I still get the black screen though, which I assume is because my client is too new.

If you log in to the loginserver within a few seconds of starting up your server, your server will show locked. Waiting a short time will show different. Either way, it doesn't matter if your system is running proper, you should be able to log in.

[MajinCry]

Originally Posted by AdrianD

Try putting the comments back for this section.

Comment out the launcher lines, specifically.

If you know what you are doing, by all means uncomment, comment, change, do whatever you want. If you are a novice like me, I suggest leaving things as they are UNTIL you get things up and running.

As I said, nothing about 'em was changed; I just un-commented them to ensure that the defaults were being applied.


It seems that the server itself is working, as two people with working clients joined it, which led to World.exe printing a bunch of stuff on the command line, unlike when I tried to join with the Steam client.

[AdrianD]

Originally Posted by MajinCry

As I said, nothing about 'em was changed; I just un-commented them to ensure that the defaults were being applied.


It seems that the server itself is working, as two people with working clients joined it, which led to World.exe printing a bunch of stuff on the command line, unlike when I tried to join with the Steam client.

I don't wish to argue semantics. Try putting the comments back to ensure the defaults are actually used instead of the examples given in those lines.

If zone is not working noone will be able to get in game. Everything you have appears to be fine up to this point.

[MajinCry]

Originally Posted by AdrianD

I don't wish to argue semantics. Try putting the comments back to ensure the defaults are actually used instead of the examples given in those lines.

If zone is not working noone will be able to get in game. Everything you have appears to be fine up to this point.

The lads joined after I posted the copy-pastes from CMD. I'll go host in the hopes that a lad or two will join, to show what World.exe outputs.

[AdrianD]

Sounds good. I'll log in if I can see it.

[MajinCry]

Originally Posted by AdrianD

Sounds good. I'll log in if I can see it.

Oh, tah cap'n. The name is some pseudo-German gibberish. "Barannach Messersink Fabrenast"

Edit: Alrighty, found that you joined. Here's what World.exe posted:

[World Server] Loading server configuration..
[World Server] CURRENT_VERSION: 1.1.3
[World Server] Added loginserver login.eqemulator.net:5998
[World Server] Connecting to MySQL...
[Status] Starting File Log 'logs/world_5304.log'
[World Server] HTTP world service disabled.
[World Server] Checking Database Conversions..
[Upgrade Script] No script update necessary
Perl Version is 5.12.3
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
============================================================
           EQEmu: Automatic Upgrade Check
============================================================
        (Windows) MySQL is in system path
        Path = C:\xampp\mysql\bin/mysql
============================================================
        Binary Database Version: (9086)
        Local Database Version: (9086)

        Database up to Date: Continuing World Bootup...
============================================================
[World Server] Loading variables..
[World Server] Loading zones..
[World Server] Clearing groups..
[World Server] Clearing raids..
[World Server] Loading items..
[World Server] Loading skill caps..
[World Server] Loading guilds..
[World Server] Loaded default rule set 'default'
[World Server] Loading EQ time of day..
[World Server] Loading launcher list..
[World Server] Reboot zone modes OFF
[World Server] Deleted 0 stale player corpses from database
[World Server] Loading adventures...
[World Server] Purging expired instances
[World Server] Loading char create info...
[World Server] Zone (TCP) listener started.
[World Server] Client (UDP) listener started.
[World Server] New TCP connection from 127.0.0.1:13509
[World Server] New TCP connection from 127.0.0.1:13512
[World Server] New TCP connection from 127.0.0.1:13515
[World Server] New TCP connection from 127.0.0.1:13517
[World Server] New connection from 50.12.254.115:56159
[World Server] Checking inbound connection 50.12.254.115 against BannedIPs table

[World Server] Connection 50.12.254.115 PASSED banned IPs check. Processing conn
ection.
[World Server] Account Attempting to be created: 'adrianduc1' status: 20
[World Server] Found 'TitaniumStartZoneID' rule setting: -1
[Status] SoF Start zone query: SELECT x, y, z, heading, start_zone, bind_id FROM
 start_zones WHERE zone_id = 1 AND player_class = 1 AND player_deity = 396 AND p
layer_race = 1

[Status] Found starting location in start_zones
[World Server] New connection from 50.12.254.115:56407
[World Server] Checking inbound connection 50.12.254.115 against BannedIPs table

[World Server] Connection 50.12.254.115 PASSED banned IPs check. Processing conn
ection.

When I joined, using the Steam Client, I was greeted with a blackscreen, and World.exe just posted "New connection from", and none of that other stuff.

[AdrianD]

Yes, that was me.

Feel free to delete that char.

I didn't notice anything unusual about the process so, it seems you are fine to login and create an agnostic human warrior out of Qeynos.

You have an extra line

[World Server] New TCP connection from 127.0.0.1:13517

You'll notice random logins from time to time if you restart the server frequently. This is due to something with the client when they try to choose the same server they had previously played on. When I saw this at first I thought it was like "field of dreams". In reality it's not.