My server shows up. yet I cannot connect

[bazz701]

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:DeathExpLossLevel 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:DeathItemLossLevel 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]

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]

Here is the config file:

<?xml version="1.0">
<server>
<world>
<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>

<!-- Loginserver information. -->
<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>some long random string</key>

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

<!-- Database configuration, replaces db.ini. -->
<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]

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

[trevius]

Try changing the following:

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

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

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]

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]

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]

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]

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]

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]

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]

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.php?wakka=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]

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]

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?

[bazz701]

One other thing I might add,

the cmd Prompt window that displays "sleeping" displays a "0:sleeping" not 7005 sleeping as the guide says... might this be part of the issue?

[trevius]

The 0 just means that you have no clients connected. When you get a person logged in, that will show the zone name and number of players in that zone. Each time another person loads in, it will change to the zone they are loading into and the total number of chars in that zone.

Are you able to connect to any other server and get past the char select screen? I would try that first to confirm that your Titanium install is working properly and that you don't have a dual core CPU issue causing your problem.

The only problem I can see is that your spell rules aren't being recognized, which either means your eqemu code is corrupted somehow, or if you compiled the source yourself, it had errors and didn't completely properly maybe.

Some things that I would try 1 at a time to see what happens:

1. Make sure you can connect to another server and get all of the way into it without problems.
2. Download the win32 1108 code of the emu again and install it overwriting all of your files accept for your config file.
3. Download the PEQ DB and follow the directions in the wiki to setup your db to use PEQ. You can still keep your AX_Classic db there so that you can easily switch back just by editing your config file. Test and see if the PEQ db works for you.
4. Post your config file again without the password information.
5. Check ALL log files in your eqemu/logs directory and post any here that look important or show errors.
6. Check which version of perl and mysql you are running and post them here. I believe there are issues with some of the newest versions.
7. Post the Operating System you are running and any other system information you might think is important.

That should be enough to keep you busy for a while. Let us know what happens.

[bazz701]

Ok, so now comes the outcome to the steps... tho I only made it to setp 3 when I got a server running and I could create and play on.


It seems that all my coding and sourcing were correct, but something didnt fit right with angelox DB on my computer.

So, I guess for now, I will be remaining with PEQ, tho I am curious if I can disable the PoK books for the time being... I want to make my server as close to old school EQ as I can, I.e. Pre PoP, so that the porting by means of wizard and druid become more meaningful.

Thanks for all the time everyone has put into to helping me.

Also, by no means am I saying that Angelox DB is bugged or errored, but I just couldnt get it to work on my machine, through some form of error on my own.

Trev, thanks, I now have a server up and running and have something to delve hours and hours into, for the programming aspect, as well as creation of my own quests and an entire DB once I get the hang of the setup as of current.

and everyone else, thanks for the help!!!!!!

(PEQ DB running smooth as of now, King's Bastion 2, will be experimenting with all kinds of changes as I understand what I can do)

[trevius]

I highly recommend checking out GeorgeS' tools from his section of the forums. You can find the link to his website with all of the downloads in his signature in his posts. Make sure you download and install his ODBC drivers from the bottom part of his website. Also, make sure you run the register_ocx.bat file in the resource folder of his tools.

His tools will let you quickly jump into world building and customize as you slowly learn more info about the rest of the Emu customizing process. Also, you will definitely want a copy of Navicat Lite to make your direct database changes quick and simple.

That info should get you off to a good start.