queryserv.exe stuck on "Connecting To Mysql"

[MajinCry]

Originally Posted by Shendare

Ahh... when did you download the client from Steam?

Daybreak updated the Steam client from the supported RoF version to a new, unsupported TDS version in mid-June. The myriad undocumented changes haven't yet been reverse-engineered and added into the server code to get the latest version working.

Just downloaded it around three days ago.

And bah, I even just finished re-downloading, making sure to stop Steam from updating it.

From what I've read, the reason we cannot share the client is because, uh, that would be sharing the files.

Gonna go make a new thread discussing XDelta, and how we can use that to make patches for the various clients kicking around, allowing everyone to be able to get the optimal version.

Originally Posted by AdrianD

Hello. I'm far from an expert of computer stuff. I just like to try and solve problems.

It seems like there may be an issue with zone. If zone were connecting, you would see in the world window something similar to "[World Server] New TCP connection from 127.0.0.1:1186" and several more listings than you have based on what you set in your `launcher` table in your database.

I also noticed there are lines in your config file which are uncommented and vary from the default file. I'm not sure if this would affect anything.

I didn't see it mentioned whether this was a fresh install. I assume it is.

All the lines in the .ini were there by default, I just un-commented them to make sure that everything was set to the default settings.

Aye, it's a fresh install.


I found that if I do the following:

Windows + R -> cmd
type in the following:
shared_memory.exe
start world.exe
start zone.exe
start ucs.exe
start queryserv.exe
start eqlaunch.exe zone

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.


So yeah. The guide on setting up a server for Windows 7 needs to be updated.

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