My server shows up. yet I cannot connect

bazz701 · #1 05-26-2008, 08:24 PM

My server, King's Bastion, shows up on the server list, yet when I choose to connect to it, nothing happens cept that it hangs, and then boots me to the login screen. No error prompts were shown in the logs so I dont know whats wrong.

Anyone have any ideas,

here is my log,
__________________________________________________ ______________

[Debug] Starting Log: logs/eqemu_debug_world_3996.log
[Debug] [WORLD__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Log settings loaded from log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[Debug] [WORLD__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_world_3996.log
[Status] Using database 'ax_classic' at localhost:3306
[Debug] [WORLD__INIT] Starting HTTP world service...
[Debug] [WORLD__HTTP] Loaded mime types from mime.types
[Debug] [WORLD__INIT] Loading variables..
[Debug] [WORLD__INIT] Loading zones..
[Debug] [WORLD__INIT] Clearing groups..
[Debug] [WORLD__INIT] Clearing temporary merchant lists..
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=55059
[Debug] [WORLD__INIT] Loading guilds..
[Debug] [RULES__CHANGE] Loading rule set 'default' (0)
[Debug] [RULES__CHANGE] Set rule Character:AutosaveIntervalS to value 300
[Debug] [RULES__CHANGE] Set rule Character:CorpseDecayTimeMS to value 10800000
[Debug] [RULES__CHANGE] Set rule Character

eathExpLossLevel to value 6
[Debug] [RULES__CHANGE] Set rule Character:EnduranceRegenMultiplier to value 100

[Debug] [RULES__CHANGE] Set rule Character:ExpMultiplier to value 1.000000000000
0
[Debug] [RULES__CHANGE] Set rule Character:HPRegenMultiplier to value 100
[Debug] [RULES__CHANGE] Set rule Character:LeaveCorpses to value true
[Debug] [RULES__CHANGE] Set rule Character:LeaveNakedCorpses to value false
[Debug] [RULES__CHANGE] Set rule Character:ManaRegenMultiplier to value 100
[Debug] [RULES__CHANGE] Set rule Character:MaxLevel to value 65
[Debug] [RULES__CHANGE] Set rule Combat:BaseCritChance to value 0.0000000000000
[Debug] [RULES__CHANGE] Set rule Combat:BerserkBaseCritChance to value 0.0600000
000000
[Debug] [RULES__CHANGE] Set rule Combat:NPCBashKickLevel to value 6
[Debug] [RULES__CHANGE] Set rule Combat:WarBerBaseCritChance to value 0.03000000
00000
[Debug] [RULES__CHANGE] Set rule GM:MinStatusToZoneAnywhere to value 200
[Debug] [RULES__CHANGE] Set rule Guild:MaxMembers to value 2048
[Debug] [RULES__CHANGE] Set rule Pets:AttackCommandRange to value 150.0000000000
000
[Debug] [RULES__CHANGE] Set rule Skills:MaxTrainTradeskills to value 21
[Debug] [RULES__ERROR] Unable to find rule 'Spells:BardSpellAggroMod'
[Debug] [RULES__ERROR] Unable to interpret rule record for Spells:BardSpellAggroMod
[Debug] [RULES__ERROR] Unable to find rule 'Spells:PetSpellAggroMod'
[Debug] [RULES__ERROR] Unable to interpret rule record for Spells:PetSpellAggroMod
[Debug] [RULES__ERROR] Unable to find rule 'Spells:SpellAggroModifier'
[Debug] [RULES__ERROR] Unable to interpret rule record for Spells:SpellAggroModi
fier
[Debug] [RULES__CHANGE] Set rule World:ClientKeepaliveTimeoutMS to value 65000
[Debug] [RULES__CHANGE] Set rule World:ZoneAutobootTimeoutMS to value 60000
[Debug] [RULES__CHANGE] Set rule Zone:GraveyardTimeMS to value 1200000
[Debug] [RULES__CHANGE] Set rule Zone:EnableShadowrest to value false
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZWhenLoading to value true
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZAtWaypoints to value true
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZWhenMoving to value true
[Debug] [RULES__CHANGE] Set rule Map:FixPathingZOnSendTo to value true
[Debug] [RULES__CHANGE] Set rule Watermap:FishingLineLength to value 40.00000000
00000
[Debug] [RULES__CHANGE] Set rule Watermap:CheckForWaterWhenFishing to value true

[Debug] [RULES__CHANGE] Set rule Watermap:CheckForWaterOnSendTo to value true
[Debug] [RULES__CHANGE] Set rule Watermap:CheckForWaterWhenMoving to value true
[Debug] [RULES__CHANGE] Set rule Watermap:CheckForWaterAtWaypoints to value true

[Debug] [RULES__CHANGE] Set rule Watermap:CheckWaypointsInWaterWhenLoading to va
lue true
[Debug] [RULES__CHANGE] Set rule Character:HealOnLevel to value true
[Debug] [RULES__CHANGE] Set rule Character:FeignKillsPet to value false
[Debug] [RULES__CHANGE] Set rule Character:ItemManaRegenCap to value 15
[Debug] [RULES__CHANGE] Set rule Character:ItemHealthRegenCap to value 15
[Debug] [RULES__CHANGE] Set rule Watermap:FishingRodLength to value 30.000000000
0000
[Debug] [RULES__CHANGE] Set rule Character

eathItemLossLevel to value 10
[Debug] [WORLD__INIT] Loaded default rule set 'default'
[Debug] [WORLD__INIT] Loading EQ time of day..
[Debug] [WORLD__INIT] Loading launcher list..
[Debug] [WORLD__INIT] Reboot zone modes ON
[Debug] [WORLD__INIT] Deleted 0 stale player corpses from database
[Debug] [WORLD__INIT] Deleted 0 stale player backups from database
[Debug] [WORLD__INIT] Zone (TCP) listener started.
[Debug] [WORLD__INIT] Client (UDP) listener started.
[Debug] [NET__IDENTIFY] Registered patch 6.2
[Debug] [NET__IDENTIFY] Registered patch Titanium
[Debug] [NET__IDENTIFY] Registered patch Anniversary
[Debug] [NET__IDENTIFY] Registered patch Live
[Debug] [WORLD__LS] Connecting to login server...
[Debug] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:4985
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:4985
[Debug] [WORLD__LAUNCH] Adding pending launcher 1
[Debug] [WORLD__LAUNCH] Launcher Identified itself as 'zones'. Loading zone list
.
[Debug] [WORLD__LAUNCH] Removing pending launcher 1. Adding zones to active list
.
[Debug] [WORLD__LAUNCH] zones: dynamic_01 reported state STARTED (1 starts)
[Debug] [WORLD__LAUNCH] zones: dynamic_02 reported state STARTED (1 starts)
[Debug] [WORLD__LAUNCH] zones: dynamic_03 reported state STARTED (1 starts)
[Debug] [WORLD__LAUNCH] zones: dynamic_04 reported state STARTED (1 starts)
[Debug] [WORLD__LAUNCH] zones: dynamic_05 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:4991
[Debug] [WORLD__CONSOLE] New zoneserver #1 from 127.0.0.1:4991
[Debug] [WORLD__ZONE] [1] Zone started with name dynamic_01 by launcher zones
[Debug] [WORLD__ZONE] [1] Auto zone port configuration. Telling zone to use por
t 7000
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:4992
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:4993
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:4994
[Debug] [WORLD__CONSOLE] New zoneserver #2 from 127.0.0.1:4993
[Debug] [WORLD__CONSOLE] New zoneserver #3 from 127.0.0.1:4992
[Debug] [WORLD__ZONE] [3] Zone started with name dynamic_05 by launcher zones
[Debug] [WORLD__ZONE] [3] Auto zone port configuration. Telling zone to use por
t 7001
[Debug] [WORLD__ZONE] [2] Zone started with name dynamic_04 by launcher zones
[Debug] [WORLD__ZONE] [2] Auto zone port configuration. Telling zone to use por
t 7002
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:4995
[Debug] [WORLD__CONSOLE] New zoneserver #4 from 127.0.0.1:4995
[Debug] [WORLD__CONSOLE] New zoneserver #5 from 127.0.0.1:4994
[Debug] [WORLD__ZONE] [5] Zone started with name dynamic_02 by launcher zones
[Debug] [WORLD__ZONE] [5] Auto zone port configuration. Telling zone to use por
t 7003
[Debug] [WORLD__ZONE] [4] Zone started with name dynamic_03 by launcher zones
[Debug] [WORLD__ZONE] [4] Auto zone port configuration. Telling zone to use por
t 7004

----------------------------------------------------------------------
I just dont know

**trevius** · #2 05-26-2008, 10:52 PM

Post your EQEmu config file and make sure to remove your password from it when you do!

Also, verify that you have port range forwarding setup in your router to direct ports 7000-7100 and 9000 to your server's IP.

bazz701 · #3 05-26-2008, 11:25 PM

Here is the config file:

<?xml version="1.0">
<server>
<world>
<shortname>King's Bastion</shortname>
<longname>King's Bastion</longname>


<address>192.168.1.102</address>
<localaddress>127.0.0.1</localaddress>


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


<key>some long random string</key>


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


<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>********</password>
<db>ax_classic</db>
</database>
</server>

and im currently checking port forewarding for 7000-7100 and 9k.

thanks.

bazz701 · #4 05-26-2008, 11:33 PM

Also, when the server is up and running as it is right now, the secondary cmd prompt window displays the title "sleeping".

**trevius** · #5 05-27-2008, 03:44 AM

Try changing the following:

Code:

<shortname>King's Bastion</shortname>
<longname>King's Bastion</longname>

<!-- Only specify these two if you really think you need to. -->
<address>192.168.1.102</address>
<localaddress>127.0.0.1</localaddress>

To the following:

Code:

<shortname>kings</shortname>
<longname>King's Bastion</longname>

<!-- Only specify these two if you really think you need to. -->
<!-- <address>NEVER SET THIS</address> -->
<!-- <localaddress>NEVER SET THIS</localaddress> -->

And see if that works for you. Short names don't work with apostrophes as far as I know and making them short doesn't hurt hehe. It is the name that will show up in the UI files after a character logs into your server. That is what differentiates character UI configs from server to server. As for the address and localaddress sections, you aren't supposed to set them unless you 100% know what you are doing and why you are doing it, which I doubt you do (no offense).

bazz701 · #6 05-27-2008, 09:30 AM

OK, so after fixing those errors, I can now enter the server as far as the character creation screen, and I can make new characters, but I cannot log in... It says zone unavailable.

What causes this?

bazz701 · #7 05-27-2008, 06:14 PM

As I search the forums, I have found others with similar problems, One says to use navicat to change something the "grave" or whatever... but with navicat open, nothing is displayed... and it says when I try to open connection that "access denied for user 'root'@'localhost'(using password: NO)

Not sure if that is part of the problem, also, I have found these errors within the cmd window

----------------------------------------------------------------------
[Debug] [RULES__ERROR] Unable to find rule 'Spells:BardSpellAggroMod'
[Debug] [RULES__ERROR] Unable to interpret rule record for Spells:BardSpellAggro
Mod
[Debug] [RULES__ERROR] Unable to find rule 'Spells:PetSpellAggroMod'
[Debug] [RULES__ERROR] Unable to interpret rule record for Spells:PetSpellAggroM
od
[Debug] [RULES__ERROR] Unable to find rule 'Spells:SpellAggroModifier'
[Debug] [RULES__ERROR] Unable to interpret rule record for Spells:SpellAggroModi
fier
-----------------------------------------------------------------------

not sure if that has any issue...

the sleeping window never initializes anything after the the server is up, though now charater creation is available.

bazz701 · #8 05-27-2008, 06:31 PM

Ok, so here is what happens in the cmd window when i try to load a character into the game:

[Debug] [NET__IDENT_TRACE] 192.168.1.103:2077: First opcode 0x4dd0 di
expected 0x2792
[Debug] [NET__IDENT_TRACE] 192.168.1.103:2077: Tried patch 6.2_world,
not match.
[Debug] [NET__IDENT_TRACE] 192.168.1.103:2077: First opcode 0x4dd0 di
expected 0x2ec9
[Debug] [NET__IDENT_TRACE] 192.168.1.103:2077: Tried patch 6.2_zone,
not match.
[Debug] [NET__IDENT_TRACE] 192.168.1.103:2077: First opcode matched 0
ength matched 464
[Debug] [NET__IDENTIFY] Identified stream 192.168.1.103:2077 with sig
nium_world
[Debug] [WORLD__CLIENT] New client from 192.168.1.103:2077
[Debug] [WORLD__CLIENT] bazz701: Logged in. Mode=(CharSel)
[Debug] [WORLD__CLIENT] bazz701: LS Account #110121
[Debug] [WORLD__CLIENT] bazz701: Attempting autobootup of qeynos2 (2)
[Debug] [WORLD__CLIENT] bazz701: Attempting autobootup of qeynos2 (2)

Anyone?????

xxarthurxx · #9 05-27-2008, 08:20 PM

download navicat and install it and get it to load you db then i would look into the zone type tables for you BD... i remember encountering this problem when i removed the zoneline table (the table that tells each zone where there is a zone line) check through navi cat and open up each table and make sure all the right stuff is in there... if all the zone tables are not in there then it will say zone unavaliable when trying to load your character in.

In the event that the zone tables are not all in I would re source the DB completly or from an older working backup

bazz701 · #10 05-27-2008, 08:34 PM

Ok, so I got navicat working, and went into the zone table... but one column is completely blank... the "file_name" column for all zones is blank... does that mean that the server doesnt know what to lead for each zone?

Or is that supposed to be that way as "short_name" and "long_name" are filled in...???

Thanks for the help.

xxarthurxx · #11 05-27-2008, 09:05 PM

whats inside the tables doesnt really matter as far as loading the zone... it matters if the tables themselves are right. so there has to be a Zone_flag table i wish i could see all the needed tables so i could make sure they are all there but i cant right now im at work :/ something you could try in the meantime is to re-source a new database with a diffrent database name and then cross referance them and make sure there are all the right tables... if you original is missing some of them what you can do is just copy over the missing ones from the new db.

having an active backup is always nice so you can backup any table mistakes right away

bazz701 · #12 05-27-2008, 09:19 PM

SOmething I never really thought of is... do I need a copy of EQ T Edition installed on the host computer(server)... or just the other files... it never occured to me that I may have forgotten that vital step.

**trevius** · #13 05-27-2008, 09:26 PM

You don't need Titanium on the server PC. But, you DO need to copy the spells files to the eqemu directory as stated in the server setup guide wiki.

It looks like you are running a current version of the databases that include the newer rules, but you don't have the correct eqemu code version to use the newer rules. You might want to try using emu version 1108 which is the most recent listed on the downloads page.

Also, make sure you sourced all of the database files needed. If you are running PEQ database, you need to have both load_player.sql and the peqdb_XXXXx.sql sourced in. It is all there in the wiki here:

http://www.eqemulator.net/wiki/wikka...ka=ws992mysql5

Oh, and the zone table doesn't need anything filled in on the filename column. That is probably the old way it used to lookup zone .map files, but I think it just does them by shortname now.

bazz701 · #14 05-27-2008, 09:36 PM

Trev,
I am currently running 1108 on my server machine, with the spells_**.txt files both imported form a working Titanium Edition.

I followed the guide to the letter, but must have mieed something...

would restarting the guide from scratch(i.e. restarting the server, not including perl and such) be my only other option??

Also, I am using Angelox DB, and sourced it in correctly as the guide told me.. so otherwise im unsure of what to do now.

bazz701 · #15 05-28-2008, 12:14 AM

The Zone_Flags tables only show 2 things.... first column has charID with 241 only row, and zoneID with 89..... thats it, is that my issue?