Private Login (Everquest not responding)

BigBlueWizard · #1 06-28-2016, 05:14 PM

I'm trying to play my server on the same computer as the client, and everything in the login and config files are set to 127.0.0.1 but whenever i launch the emulator, i am able to see my server by itself (like in Akka's guide), however it freezes and becomes not responsive once clicking play on the server. The login log shows that the client requested login and server but once i click play it shows client disconnected. I can try to post some logs in a bit. I'm away from my computer atm and typing this one my phone.

Btw, everything works fine when i use eqemulator host. Even when connected from a different computer in the same house.

Edit: everquest itself freezes i mean

**Uleat** · #2 06-28-2016, 05:33 PM

Post your config files, if you don't mind.

There's a few more things we can check there.

BigBlueWizard · #3 06-28-2016, 06:03 PM

[Login Server] New SoD client connection from 127.0.0.1:62590
[Login Server] Application packet received from client (size 14)
[Login Server] Session ready received from client.
[Login Server] Application packet received from client (size 36)
[Login Server] Login received from client.
[Login Server] Application packet received from client (size 12)
[Login Server] Server list request received from client.
[Login Server] Application packet received from client (size 16)
[Login Server] Play received from client, server number 2 sequence 5.
[Login Server] Client disconnected from the server, removing client.

From the login server... that's when EQ freezes

Here's my config

Code:

<?xml version="1.0">
<server>
	<world>
		<!-- Set the shortname to ONE word. The longname is what shows up on server list -->
		<shortname>Destiny</shortname>
		<longname>Destiny</longname>

		<!-- DO NOT EDIT ANY LINES BETWEEN HERE AND THE DATABASE SECTION -->
		<address>127.0.0.1</address>
		<localaddress>127.0.0.1</localaddress>

		<!-- Loginserver information. DO NOT EDIT -->
		<!-- <loginserver2> -->
			<!-- <host>login.eqemulator.net</host> -->
			<!-- <port>5998</port> -->
			<!-- <account></account> -->
			<!-- <password></password> -->
		<!-- </loginserver2> -->
		<loginserver1>
			<host>127.0.0.1</host>
			<port>5998</port>
			<account></account>
			<password></password>
		</loginserver1>


		<!-- <Server status. Default is unlocked DO NOT EDIT RIGHT NOW -->
		<!-- <locked/> -->
		<!-- <unlocked/> -->

		<!-- Sets the ip/port for the tcp connections. DO NOT EDIT -->
		<!-- <tcp ip="127.0.0.1" port="9000" telnet="disable"/> -->
		<tcp ip="127.0.0.1" port="9000" telnet="enable"/>

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

		<!-- Enable and set the port for the HTTP service. Defaults are shown -->
		<!-- <http port="9080" enabled="false" mimefile="mime.types" /> -->
		<http port="9080" enabled="true" mimefile="mime.types" />
	</world>

	<!-- Chatserver (channels) information. DO NOT EDIT -->
	<chatserver>
		<!-- <host>127.0.0.1</host> -->
		<!-- <port>7778</port> -->
		<host></host>
		<port>7500</port>
	</chatserver>

	<!-- Mailserver (in-game mail) information. DO NOT EDIT -->
	<mailserver>
		<!-- <host>127.0.0.1</host> -->
		<!-- <port>7778</port> -->
		<host></host>
		<port>7500</port>
	</mailserver>

	<zones>
	<!-- The defaultstatus is what status the new toons will have on your server -->
	<defaultstatus>0</defaultstatus>

	<!-- Sets port range for world to use to auto configure zones DO NOT EDIT RIGHT NOW-->
	<!-- <ports low="7000" high="7100"/> -->
	<ports low="7000" high="7400"/>
	</zones>

	<!-- Set username to root and password is your MySQL password and db to peq -->
	<database>
		<!-- <host>127.0.0.1</host> -->
		<!-- <port>3306</port> -->
		<!-- <username>xxxxxxx</username> -->
		<!-- <password>xxxxx</password> -->
		<!-- <db>peq</db> -->
	   <host>localhost</host>
	   <port>3306</port>
	   <username>xxxxxxxxx</username>
	   <password>xxxxxxxxxxxxx</password>
	   <db>peq</db>
	</database>	

	<qsdatabase>
		<!-- <host>127.0.0.1</host> -->
		<!-- <port>3306</port> -->
		<!-- <username>xxxxxxxxxx</username> -->
		<!-- <password>xxxxx</password> -->
		<!-- <db>peq</db> --> 
	   <host>localhost</host>
	   <port>3306</port>
	   <username>xxxxxxxxxxxxxxxxxxx</username>
	   <password>xxxxxxxxxxxx</password>
	   <db>peq</db>
	</qsdatabase>

	<webinterface>
		<port>9081</port>
	</webinterface>

	<!-- Launcher Configuration DO NOT EDIT-->
	<launcher>
	<!-- <logprefix>logs/zone-</logprefix> -->
	<!-- <logsuffix>.log</logsuffix> -->
	<!-- <exe>zone.exe</exe> -->
	<!-- <timers restart="10000" reterminate="10000"> -->
	</launcher>

	<!-- File locations. DO NOT EDIT -->
	<files>
	<!-- <spells>spells_us.txt</spells> -->
	<!-- <opcodes>opcodes.conf</opcodes> -->
	<!-- <logsettings>log.ini</logsettings> -->
	<!-- <eqtime>eqtime.cfg</eqtime> -->
	</files>
	<!-- Directory locations. DO NOT EDIT -->
	<directories>
	<!-- <maps>Maps</maps> -->
	<!-- <quests>quests</quests> -->
	<!-- <plugins>plugins</plugins> -->
	</directories>
</server>

Code:

[database]
host = localhost
port = 3306
db = peq
user = xxxxxxxxxxxxxx
password = xxxxxxxxxxxxxxxx
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 127.0.0.1
auto_create_accounts = TRUE

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = loginserver_server_accounts
world_registration_table = loginserver_world_server_registration
world_admin_registration_table = loginserver_server_admin_registration
world_server_type_table = loginserver_server_list_type

**Uleat** · #4 06-28-2016, 06:43 PM

In your login.ini file, try changing your host to 127.0.0.1 instead of localhost.

There could be a resolution issue.

BigBlueWizard · #5 06-28-2016, 06:54 PM

No dice ...

I did notice world was doing this both before and after your recommended change... does this have anything to do with what's going on?

Code:

[World Server] New connection from 127.0.0.1:56925
[World Server] Checking inbound connection 127.0.0.1 against BannedIPs table
[World Server] Connection 127.0.0.1 PASSED banned IPs check. Processing connection.
[World Server] Account Attempting to be created: 'XXXXXXX' status: 0
[MySQL Error] 1062: Duplicate entry 'XXXXXXX' for key 'name'
 INSERT INTO account SET name='XXXXXX', status=0, lsaccount_id=2, time_creation=UNIX_TIMESTAMP();

**Uleat** · #6 06-28-2016, 07:15 PM

I don't know that process...

But, looking at that function, it's definitely returning a failure value.

(I manually create all of my accounts.)

DanCanDo · #7 06-28-2016, 08:19 PM

How come the the schema has different table names ? Is that an older, or different one?
(Just curious)

Code:

[schema]
account_table = loginserver_server_accounts
world_registration_table = loginserver_world_server_registration
world_admin_registration_table = loginserver_server_admin_registration
world_server_type_table = loginserver_server_list_type

Mine has this:

Code:

[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType

**Uleat** · #8 06-28-2016, 09:45 PM

The top one is probably from Akka's Installer.

The bottom one (like mine too,) is definitely what's been around since KLS was a greenie :P

DanCanDo · #9 06-28-2016, 09:55 PM

Oh ok. I was a little befuzzled at the table names, but I've never tried out Akka's installer.
I assume his installer enters those table names in to the DB then.

BigBlueWizard · #10 06-28-2016, 11:18 PM

Quote:

Originally Posted by Uleat

I don't know that process...

But, looking at that function, it's definitely returning a failure value.

(I manually create all of my accounts.)

Ok, i'm stumped... i'm still getting that error even though I changed my autocreateaccounts to FALSE in my login.ini

Also, EQ still freezes when trying to hit play

Could this first error have anything to do with the second???

BigBlueWizard · #11 06-29-2016, 12:45 AM

Well, here's an update. It definitely does have to do with that error. I was able to log in to my server by turning auto create accounts back to TRUE and then made a brand new one (before I had been using already created accounts - which was the issue)... even if I had autocreate on FALSE

These accounts were also in my regular accounts table that I used for eqemulator host server... perhaps that was the issue???

Anyway, everything seems to work great now, except I still can't use my old accounts... No more red error messages when logging in ... I even changed the IP addresses to my actual computer's instead of 127.0.0.1 and was able to log in from another computer in the house (using the newly created account).

So, to Sum up... still a lingering issue of old accounts and that error... but there's a workaround now...

I did get some red error code the first time I created a character on the new account and logged in, but it hasn't returned upon logging in again multiple times and it doesn't seem to have affected anything, but if someone would let me know if it is a hidden issue / what the solution is, i'd appreciate it.

Code:

[World Server] Checking inbound connection x.x.x.x against BannedIPs table
[World Server] Connection x.x.x.x PASSED banned IPs check. Processing connection.
[World Server] Account Attempting to be created: 'xxxxxxx' status: 0
[Status] SoF Start zone query: SELECT x, y, z, heading, start_zone, bind_id FROM start_zones WHERE zone_id = 49 AND player_class = 15 AND player_deity = 211 AND player_race = 10

[Status] Found starting location in start_zones
[MySQL Error] 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
 REPLACE INTO `character_bind` (id, zone_id, instance_id, x, y, z, heading, slot) VALUES (19661936, 19661900, 19660476, 0.000000, 0.000000, 0.000000, -2.000000, 1079274700), (0, 1079197696, 0, 0.000000, 0.000000, 0.000000, -2.000000, 1079274700),

BigBlueWizard · #12 06-29-2016, 01:06 AM

Ok.... So, I figured it out!!!

It turns out, the accounts (in the accounts table) I used for the regular eqemulator hosted public server, they either already had a loginserver account ID for them, or somehow one was randomly generated... but it was a huge number... something like 3687367 and the table loginserveraccounts created an account with the same name / pw... like I had been using on the public eqemu hosted server, but it created a new loginserver ID number that was a single digit and counting (such as 4). These didn't match, thus where I was getting that duplicate error....

Still don't know what's going on with the last error I got when creating a new character (in the post above)... so if someone wouldn't mind helping me out with that i'd appreciate it.

Hopefully this helps anyone else who gets stuck like myself!!

Nightrider84 · #13 06-29-2016, 12:39 PM

Your missing a table in your character_bind in sql. Rather the table for your character_bind is probobly messed up slightly, Go through the table and check the values based on what the error is popping out. Also id change your








<loginserver1>
<host>127.0.0.1</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver1>

to this
<loginserver1>
<host>127.0.0.1</host>
<port>5998</port>
<account>XXXXX</account>
<password>XXXXX</password>
</loginserver1>
<loginserver2>
<host>login.eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver2>

Causes less issues related to logging in to the server.

Also if your logging in from a computer outside of your network on your private login make sure that this is filled out

<address>Your Public IP</address> -->
<localaddress>LEAVE BLANK CAUSES CONNECTION PROBLEMS</localaddress> -->

BigBlueWizard · #14 06-29-2016, 01:14 PM

Yeah, I had just commented out the eqemulator.net host loginserver while working on the private login. I've uncommented it now, but it didn't have any effect/interfere with the issues I was having. Appreciate the advice though

As far as the character_bind issue:

Code:

Here's my table
#      name            datatype                 length / set
1	id               INT                        (11)            
2	slot            INT                          (4)              
3	zone_id        SMALLINT                     (11)   
4	instance_id     MEDIUMINT                    (11) 
5	x               FLOAT               
6	y               FLOAT                
7	z               FLOAT                
8	heading          FLOAT

Could the issue be that the game's syntax said it was trying to do ID, then zone_id and the table up above has slot at (2), and not last, like the error below produced??

Code:

 REPLACE INTO `character_bind` (id, zone_id, instance_id, x, y, z, heading, slot)

btw, I used Akka's new server install (all in one thing), so everything is stock... i'm guessing other's probably have this error too

If this is the problem, what's the fix?? simply moving my table around and putting zoneid at (2) and slot at 8 ?

Thanks in advance

Nightrider84 · #15 06-29-2016, 08:49 PM

No the order in which they are listed shouldn't be an issue at all. From what I can see its trying to put incorrect values into your character_bind. The character bind itself is fine but the values its trying to put in are completely wrong. I could be something related to the character creation itself for incorrect bind points on the character. Maybe check the starting location for some of the races and see if the zone id's match up to where they are suppose to spawn.