My server shows up. yet I cannot connect

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