Server debug assistance please. [Archive]

View Full Version : Server debug assistance please.

Fulcrum

09-23-2010, 10:46 AM

Allrighty, I've had quite a bit of success setting up the new server, (thanks in no small part to the generous assistance from ya'll here in these forums), and have made it rather farther than I suspected I would at the beginning.

However, I've gotten to a point where I've repaired all the errors I've found solutions for in the forums... but for the rest, my search-fu of the forums fails me... I could use probably use a little nudge in the right direction for a few problems. If they're minor problems and easily repaired all the better.

Can log in to the server, can create a character of whatever sort, however, I've noticed the following bugs:

Missing: Description file for West Freeport on the character select screen.

Crash: The first time a character leaves the creator and enters the world, I have reliably crashed to the desktop. I have disabled the tutorial and have changed the tutorial zone from 'The Glooming Deep' and have set it to tutorial A, just in case someone manages to get into the tutorial. After the first crash the character can be logged in as normal and, generally, placed in it's own class trainer area.

No channel support: Upon logging in I get an error stating that I've been disconnected from the chatserver and to wait until it's restored. I suspect I have fat-fingered something in a setup file.... though after going over the files for the last few days I've not found the error. I've done all the port forwarding required. "Please wait while we reconnect you to the Universal Chat Service. Your request has not been sent." is the message given.

Movement: Character hovers above the ground and movement is impossible in most cases. I've looked in the forums for a solution... I have no #rules to accept and the #acceptrules command does not solve this issue. I've checked the DB tables for 'cancombat' and 'canlevitate' and since I'm using the latest builds and databases they appear to be intact. Some of the threads I've tracked down date back 2 years... I'm unsure whether any posts that old or older would be useful for today's builds.

Hailing/quest: Hailing one's guildmaster for the beginning newbie quest does not receive a reply, handing the note to them does not complete the quest. I have looked through the forums and found where it was suggested to copy the C:/eqemu/quests/plugins files into the folder C:/eqemu/plugins , however this has not solved this particular issue.

These are the main ones... once these are sorted through I'm sure I'll uncover others.

I'll post any specific files/folder/database information that will help.

Fulcrum

09-23-2010, 07:06 PM

Just an update:

Apply the sql updates to your database that come with the emulator code. Assuming you downloaded PEQ 1589 (I think that's the old number. There's a 1667 database available now) you would need to apply any with a number greater than that. They are in the utils/sql/svn directory.

The one in particular that is most likely to fix that one problem is 1618_zone.sql.

If that isn't it, look in the logs that the emulator creates in the logs directory for errors that will give you clues on where to troubleshoot next.

Missing: Description file for West Freeport on the character select screen.

Crash: The first time a character leaves the creator and enters the world, I have reliably crashed to the desktop. I have disabled the tutorial and have changed the tutorial zone from 'The Glooming Deep' and have set it to tutorial A, just in case someone manages to get into the tutorial. After the first crash the character can be logged in as normal and, generally, placed in it's own class trainer area.

No channel support: Upon logging in I get an error stating that I've been disconnected from the chatserver and to wait until it's restored. I suspect I have fat-fingered something in a setup file.... though after going over the files for the last few days I've not found the error. I've done all the port forwarding required. "Please wait while we reconnect you to the Universal Chat Service. Your request has not been sent." is the message given.

Movement: Character hovers above the ground and movement is impossible in most cases. FIXED

Hailing/quest: Hailing one's guildmaster for the beginning newbie quest does not receive a reply, handing the note to them does not complete the quest. FIXED

Fulcrum

09-25-2010, 07:50 AM

Another update:

Item/spell information issue: Seems that item and spell information can be accessed when it's in a shop's inventory/on a corpse... however once you buy it/pick it up/scribe it, I can no longer seem to get it to give it's information with a right-click or hovering the mouse over said item (except getting the item name). The items involved are functional and really do not impact the play of the game. Has anyone else had this minor issue or know a fix?

No channel support: Upon logging in I get an error stating that I've been disconnected from the chatserver and to wait until it's restored. I suspect I have fat-fingered something in a setup file.... though after going over the files for the last few days I've not found the error. I've done all the port forwarding required. Issue Solved.

Fulcrum

09-27-2010, 12:39 AM

Allrighty, by going through all the different guides, wiki entries, posts in other threads, dumb luck and so forth I've managed to pretty much cross almost everything off my initial list.
The only things remaining are:

New Character: Creating a new character still dumps me to the login screen the first time but the character is playable afterwards.

Zone Text Missing: For Freeport east and west in the character creator. (Not sure what the fix is, but I've found the 'missing' text in dbstr_us.txt)

*NEW* Login: I can log into the server with no problem, however when someone remote attempts to log in, they inform me that
they get either the message 'You need to patch' or 'Password Incorrect' without making any changes to their client.
When they make the login attempt, I'm watching the server for some sign of
their activity and see nothing.

The person in question also says that he can log into other servers without issue so it's definitely on my end of things. Could it be that I have Dyndns set up improperly?

Any help on these issues would be greatly appreciated.

Domingodarkrage

09-29-2010, 01:40 AM

lerxst2112

09-29-2010, 02:06 AM

The movement problem is generally the result of not applying required SQL updates to your database.

Look in the trunk\EQEmuServer\utils\sql\svn directory and apply any required updates that are numbered higher than the database number you have installed. You may also want to apply the optional updates, but you should probably read them first and decide if that's what you want.

Fulcrum

09-29-2010, 07:22 AM

How did you fix the movement problem? I'm currently having that issue, as well as npc's not responding to hails.

I'm about to start setting mine up so others can join. If I come across your problem I'll post what I find.

Aye, it took me a little time to comb through the file folders of the SVN directory for the correct updates.

I'd been looking in the folder *\Eqemusvnfiles\DB\PEQdatabase\updates on a wild goose-chase, but all of the files in there
seemed to be applied to the database already.

Thanks to a tip in the right direction, I found the required files in the following directory:
*\eqemusvnfiles\eqemu\trunk\eqemuserver\utils\sql

... and apply all the (non-optional) updates in there that are of a number > your database... which can be found in your
PEQ datadbase under the heading of db_version, (I used the suggested Navicat lite.)

This solved both the problems with being stuck in place and the unresponsive quest NPC's for me.

Fulcrum

10-01-2010, 06:06 PM

Allrighty, to combat the 1017 error I've taken a few steps which haven't particularly fixed the problem, but have made this issue potentially fix-able.

I've replaced the flakey router and modem, both of which worked but HAD been hit by lightning more than once... I wasn't getting ping returns from either local or remote machines until I did so.

I killed the Windows firewall and installed a more customizable... and frankly better... firewall program.

I can still log in from my own machine, however any remote clients cannot connect due to a 1017 error.

I just grabbed a capture of my Eqemu_config.xml and a copy of the login_opcodes.... just to see if there's not something I'm overlooking. Mind you, I haven't really bothered to clean up the config, so you're going to see a lot of junk in there... (which I don't think matters, but then again, I'm more used to turning a pipe-wrench than playing nice with computer-code. ;)

<?xml version="1.0">
<server>
<world>
<shortname>Junk</shortname>
<longname>The Server That's Not Behaving</longname>






<loginserver>

<host>eqemulator.net</host>
<port>5998</port>
<account>nopeguessagain</account>
<password>nawtachance</password>
</loginserver>






<tcp ip="the.dyndns.address" port="9000" telnet="enable"/>



<key>JerryGarciaLivesForever</key>



<http port="9080" enabled="false" mimefile="mime.types" />
</world>


<chatserver>
<host>192.168.1.2</host>


<port>7779</port>
</chatserver>


<mailserver>
<host>192.168.1.2</host>


<port>7779</port>
</mailserver>

<zones>
<defaultstatus>20</defaultstatus>


<ports low="7000" high="7010"/>
</zones>


<database>

<host>127.0.0.1</host>
<port>3306</port>
<username>NotTheRealUsername!</username>
<password>NotTheRealPassword!</password>
<db>peq</db>
</database>


<launcher>




</launcher>


<files>
<spells>spells_us.txt</spells>
<opcodes>opcodes.conf</opcodes>
<logsettings>log.ini</logsettings>
<eqtime>eqtime.cfg</eqtime>
</files>

<directories>
<maps>Maps</maps>
<quests>quests</quests>
<plugins>plugins</plugins>
</directories>
</server>

login_opcodes....
#EQEmu Public Login Server OPCodes
OP_SessionReady=0x0001
OP_Login=0x0002
OP_ServerListRequest=0x0004
OP_PlayEverquestRequest=0x000d
OP_PlayEverquestResponse=0x0021
OP_ChatMessage=0x0016
OP_LoginAccepted=0x0017
OP_ServerListResponse=0x0018
OP_Poll=0x0029
OP_EnterChat=0x000f
OP_PollResponse=0x0011

And here's login.ini if it'l help:

[database]
host = localhost
port = 3306
db = eqemu
user = user
password = password
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 = 192.168.1.2

[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

Domingodarkrage

10-03-2010, 07:07 PM

I gave up on privately hosting a game without using eqemulator's login because I could not resolve similar issues that you are getting now, and some router problems.

However, I thought that having the !<--- and -----> in your config file disabled that line, which looks like it would disable your login server from those on the outside. If anyone knows the real effect, please state it. I am also more familiar with a pipe wrench than this stuff.

Fulcrum

10-04-2010, 04:53 PM

New Character: Creating a new character still dumps me to the login screen the first time but the character is playable afterwards.

Zone Text Missing: For Freeport east and west in the character creator. (Not sure what the fix is, but I've found the 'missing' text in dbstr_us.txt)

*NEW* Login: I can log into the server with no problem, however when someone remote attempts to log in, they inform me that
they get either the message 'You need to patch' or 'Password Incorrect' without making any changes to their client.
When they make the login attempt, I'm watching the server for some sign of
their activity and see nothing. Problem solved.

It had nothing at all to do with the configs or the emulator itself. It had everything to do with the firewall/modem/router combination I was using for my network.

They were bickering about the network traffic, even with all of the correct ports open on BOTH the modem and router.

Once I got them cooperating, everything just kinda popped into place and works a charm so far.