PDA

View Full Version : No Zoneserver available


Kanlei
06-27-2007, 01:41 AM
I couldn't find anything through search but I have fixed other problems from this forum. however I keep getting this error and I'm not sure why.


[Debug] [WORLD__LAUNCH] zone: nektulos reported state STARTED (1 starts)
[Debug] [WORLD__LAUNCH] zone: neriaka reported state STARTED (1 starts)
[Debug] [WORLD__LAUNCH] zone: neriakb reported state STARTED (1 starts)
[Debug] [WORLD__LAUNCH] zone: neriakc reported state STARTED (1 starts)
[Debug] [WORLD__LAUNCH] zone: nro reported state STARTED (1 starts)
[Debug] [WORLD__LAUNCH] zone: oasis reported state STARTED (1 starts)
[Debug] [WORLD__CLIENT] root: Attempting autobootup of neriakc (42)
[Debug] [WORLD__CLIENT_ERR] root: No zoneserver available to boot up.
[Debug] [WORLD__CLIENT] root: Attempting autobootup of cabeast (106)
[Debug] [WORLD__CLIENT_ERR] root: No zoneserver available to boot up.
[Debug] [WORLD__CLIENT_ERR] root: Received unknown EQApplicationPacket
[Debug] [WORLD__CLIENT_ERR] [OpCode OP_WorldLogout (0x7718) Size=0]
[Debug] [WORLD__CLIENT] root: Client disconnected (not active in process)
[Debug] [WORLD__LAUNCH] Removing launcher zone (1)

I get to character Select but I can't log in and I'm annoyed at this point. also i get this error and can't seem to get mysql to reconginize the items.sql


[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
Error in GetItemsCount query 'SELECT MAX(id),count(*) FROM items' #1146: Table '
peq.items' doesn't exist
Error: SharedDatabase::LoadItems() (sharemem): GetItemsCount() returned -1
[Debug] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring
[Debug] [WORLD__INIT] Loading guilds..
[Debug] [RULES__CHANGE] Loading rule set 'default' (2)
[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

any help would be awesome

Kanlei
06-27-2007, 01:50 AM
thought i'd add this in case you ask.

config.xml file

<?xml version="1.0">
<server>
<world>
<shortname>minlogin</shortname>
<longname>My Minilogin</longname>

<!-- Only specify these two if you really think you need to. (read: You don't) -->
<!-- <address>xxx.xxx.xx.234</address> -->
<!-- <localaddress>127.0.0.1</localaddress> -->

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>xxx.xxx.xx.234 </host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>

<!-- Server status. Default is unlocked -->
<!--<locked/>-->
<!-- <unlocked/> -->

<!-- Sets the ip/port for the tcp connections. Both zones and console (if enabled). Defaults are shown -->
<tcp ip="localhost" port="9000" telnet="disable"/>

<!-- 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. Defaults are shown -->
<http port="9080" enabled="false" mimefile="mime.types" />
</world>

<!-- Chatserver (channels) information. Defaults shown -->
<chatserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>

<!-- Mailserver (in-game mail) information. Defaults shown -->
<mailserver>
<host>channels.eqemulator.net</host>
<port>7779</port>
</mailserver>

<zones>
<defaultstatus>20</defaultstatus>

<!-- Sets port range for world to use to auto configure zones -->
<ports low="7000" high="7100"/>
</zones>

<!-- Database configuration, replaces db.ini. Defaults shown -->
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>xxxx</password>
<db>peq</db>
</database>

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

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

Kanlei
06-27-2007, 08:06 AM
I have both spells files in my directory in case you mention that too.

Kanlei
06-28-2007, 03:47 PM
I've tried changing address and such with no luck solving this. so Now i'm starting from scratch. I am able to logon and play on a server. and now attempting to create my own server for the site before I try to make a minilogin server. this time I'm going to use the AX_classic_db. since I can't solve the issue with items.sql not sourcing in the peq_db. However I'm still going to try and figure out why I was getting that error in case someone else gets it. could just me been tired cause been trying to do this after working hours. who knows but i'm 99% sure I followed the guide 100%. however when i try to do the line set password for 'root'@'localhost' = OLD_PASSWORD('*****'); it gives me this Query ok, 0 row affected (0.00sec) should that not be 0 rows affected?

Kanlei
06-28-2007, 06:30 PM
ok now I have a server setup on site now. so that's a start. was having trouble with world.exe opening after clicking on start.bat and closing immediately. After playing with the config file and changing and saving old config files as backups and stuff and then changing a old files name back to config somehow eqgame_config.xml.full came up and i saved that which made the other config files icon change into a web browser icon and some how made the damn thing work. I don't know but it now works. :-D but still have issues but least the server shows up on the site when i have it open. and as i am typeing this and let the world.exe keep running umm! i just realized i was being dumb again (hehe techy) and the zoneservers loaded correctly and now i can log in but having an issue with items even with the ax_classic I'll post the message after i login on my character.

Kanlei
06-28-2007, 06:50 PM
---------------------------------------------
[06.29. - 16:00:38] Starting Log: logs/eqemu_error_world_3508.log
[06.29. - 16:00:38] DBLoadItems query 'select source,itemclass,name,lore,idfile,id,weight,norent ,nodrop,size,slots,price,icon,UNK012,UNK013,benefi tflag,tradeskills,cr,dr,pr,mr,fr,astr,asta,aagi,ad ex,acha,aint,awis,hp,mana,ac,deity,skillmodvalue,U NK033,skillmodtype,banedmgrace,banedmgamt,banedmgb ody,magic,casttime_,reqlevel,bardtype,bardvalue,li ght,delay,reclevel,recskill,elemdmgtype,elemdmgamt ,range,damage,color,classes,races,UNK054,maxcharge s,itemtype,material,sellrate,UNK059,casttime,UNK06 1,procrate,combateffects,shielding,stunresist,stri kethrough,extradmgskill,extradmgamt,spellshield,av oidance,accuracy,charmfileid,factionmod1,factionmo d2,factionmod3,factionmod4,factionamt1,factionamt2 ,factionamt3,factionamt4,charmfile,augtype,augslot 1type,augslot1unk,augslot2type,augslot2unk,augslot 3type,augslot3unk,augslot4type,augslot4unk,augslot 5type,augslot5unk,ldontheme,ldonprice,ldonsold,bag type,bagslots,bagsize,bagwr,book,booktype,filename ,banedmgraceamt,augrestrict,loregroup,pendingloref lag,artifactflag,summonedflag,favor,fvnodrop,endur ,dotshielding,attack,regen,manaregen,endurancerege n,haste,damageshield,recastdelay,recasttype,guildf avor,augdistiller,UNK123,UNK124,attuneable,nopet,U NK127,pointtype,potionbelt,potionbeltslots,stacksi ze,notransfer,stackable,UNK134,clickeffect,clickty pe,clicklevel,clicklevel2,proceffect,proctype,proc level,proclevel2,worneffect,worntype,wornlevel,wor nlevel2,focuseffect,focustype,focuslevel,focusleve l2,scrolleffect,scrolltype,scrolllevel,scrolllevel 2,updated from items order by id', #1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range,damage,color,classes,races,UNK054,maxcharge s,itemtypselect source,itemclass,name,lore,idfile,id,weight,norent ,nodrop,size,slots,price,icon,UNK012,UNK013,benefi tflag,tradeskills,cr,dr,pr,mr,fr,astr,asta,aagi,ad ex,acha,aint,awis,hp,mana,ac,deity,skillmodvalue,U NK033,skillmodtype,banedmgrace,banedmgamt,banedmgb ody,magic,casttime_,reqlevel,bardtype,bardvalue,li ght,delay,reclevel,recskill,elemdmgtype,elemdmgamt ,range,damage,color,classes,races,UNK054,maxcharge s,itemtype,material,sellrate,UNK059,casttime,UNK06 1,procrate,combateffects,shielding,stunresist,stri kethrough,extradmgskill,extradmgamt,spellshield,av oidance,accuracy,charmfileid,factionmod1,factionmo d2,factionmod3,factionmod4,factionamt1,factionamt2 ,factionamt3,factionamt4,charmfile,augtype,augslot 1type,augslot1unk,augslot2type,augslot2unk,augslot 3type,augslot3unk,augslot4type,augslot4unk,augslot 5type,augslot5unk,ldontheme,ldonprice,ldonsold,bag type,bagslots,bagsize,bagwr,book,booktype,filename ,banedmgraceamt,augrestrict,loregroup,pendingloref lag,artifactflag,summonedflag,favor,fvnodrop,endur ,dotshielding,attack,regen,manaregen,endurancerege n,haste,damageshield,recastdelay,recasttype,guildf avor,augdistiller,UNK123,UNK124,attuneable,nopet,U NK127,pointtype,potionbelt,potionbeltslots,stacksi ze,notransfer,stackable,UNK134,clickeffect,clickty pe,clicklevel,clicklevel2,proceffect,proctype,proc level,proclevel2,worneffect,worntype,wornlevel,wor nlevel2,focuseffect,focustype,focuslevel,focusleve l2,scrolleffect,scrolltype,scrolllevel,scrolllevel 2,updated from items order by id
[06.29. - 16:00:38] If you got boat loads of errors, make sure you sourced: utils/items-0.6.0-DR2-0.6.1-DR1-convert.sql

[06.29. - 16:00:39] Could not load EQTime file eqtime.cfg


this is the error message log that i have reguarding the items file.

Note:
"If you got boat loads of errors, make sure you sourced: utils/items-0.6.0-DR2-0.6.1-DR1-convert.sql" I have seen this in the error message and I do not see where this file exists cause mysql doesn't either. any help would be grateful as well as why peq_db items is giving me the same problem.

Kanlei
06-28-2007, 07:34 PM
Just shifted from server on eqemu to minilogin and getting same no zoneserver available to boot up error. gonna let world.exe sit for a while and see what happens. I see that the dynamic_01 to 06 are more stable and not stopping and starting from my first attempt at starting a minilogin.


[06.29. - 17:22:05] [WORLD__LAUNCH] Removing pending launcher 1. Adding zones to active list.
[06.29. - 17:22:10] [WORLD__LAUNCH] zones: dynamic_01 reported state STARTED (1 starts)
[06.29. - 17:22:30] [WORLD__LAUNCH] zones: dynamic_02 reported state STARTED (1 starts)
[06.29. - 17:22:32] [WORLD__LAUNCH] zones: dynamic_03 reported state STARTED (1 starts)
[06.29. - 17:22:34] [WORLD__LAUNCH] zones: dynamic_04 reported state STARTED (1 starts)
[06.29. - 17:22:36] [WORLD__LAUNCH] zones: dynamic_05 reported state STARTED (1 starts)
[06.29. - 17:24:13] [WORLD__CLIENT] New connection from 202.128.21.234:49429
[06.29. - 17:24:13] [NET__IDENT_TRACE] 202.128.21.234:49429: First opcode 0x4dd0 did not match expected 0x2792
[06.29. - 17:24:13] [NET__IDENT_TRACE] 202.128.21.234:49429: Tried patch 6.2_world, and it did not match.
[06.29. - 17:24:13] [NET__IDENT_TRACE] 202.128.21.234:49429: First opcode 0x4dd0 did not match expected 0x2ec9
[06.29. - 17:24:13] [NET__IDENT_TRACE] 202.128.21.234:49429: Tried patch 6.2_zone, and it did not match.
[06.29. - 17:24:13] [NET__IDENT_TRACE] 202.128.21.234:49429: First opcode matched 0x4dd0 and length matched 464
[06.29. - 17:24:13] [NET__IDENTIFY] Identified stream 202.128.21.234:49429 with signature Titanium_world
[06.29. - 17:24:13] [WORLD__CLIENT] New client from 202.128.21.234:49429
[06.29. - 17:24:13] [WORLD__CLIENT] root: Logged in. Mode=(CharSel)
[06.29. - 17:24:13] [WORLD__CLIENT] root: MiniLogin Account #2
[06.29. - 17:25:34] [WORLD__CLIENT] root: Name approval request. Name=Booboo, race=Iksar, class=Monk
[06.29. - 17:25:34] [WORLD__CLIENT] root: Character creation request from LS#0 (202.128.21.234:49429) :
[06.29. - 17:25:34] [WORLD__CLIENT] root: Name: Booboo
[06.29. - 17:25:34] [WORLD__CLIENT] root: Race: 128 Class: 7 Gender: 1 Deity: 203 Start zone: 12
[06.29. - 17:25:34] [WORLD__CLIENT] root: STR STA AGI DEX WIS INT CHA Total
[06.29. - 17:25:34] [WORLD__CLIENT] root: 95 75 100 95 80 75 55 575
[06.29. - 17:25:34] [WORLD__CLIENT] root: Face: 4 Eye colors: 7 7
[06.29. - 17:25:34] [WORLD__CLIENT] root: Hairstyle: 255 Haircolor: 255
[06.29. - 17:25:34] [WORLD__CLIENT] root: Beard: 255 Beardcolor: 255
[06.29. - 17:25:34] [WORLD__CLIENT] Validating char creation info...
[06.29. - 17:25:34] [WORLD__CLIENT] Found 0 errors in character creation request
[06.29. - 17:25:34] [WORLD__CLIENT] root: Current location: cabeast -50.00, 421.00, 6.75
[06.29. - 17:25:34] [WORLD__CLIENT] root: Bind location: cabeast -50.00, 421.00, 6.75
[06.29. - 17:25:34] [WORLD__CLIENT] root: Character creation successful: Booboo
[06.29. - 17:25:34] [WORLD__CLIENT] root: Attempting autobootup of cabeast (106)
[06.29. - 17:25:34] [WORLD__CLIENT_ERR] root: No zoneserver available to boot up.
[06.29. - 17:26:06] [WORLD__CLIENT] root: Attempting autobootup of cabeast (106)
[06.29. - 17:26:06] [WORLD__CLIENT_ERR] root: No zoneserver available to boot up.
[06.29. - 17:26:10] [WORLD__CLIENT] root: Attempting autobootup of cabeast (106)
[06.29. - 17:26:10] [WORLD__CLIENT_ERR] root: No zoneserver available to boot up.
[06.29. - 17:26:16] [WORLD__CLIENT_ERR] root: Received unknown EQApplicationPacket
[06.29. - 17:26:16] [WORLD__CLIENT_ERR] [OpCode OP_WorldLogout (0x7718) Size=0]
[06.29. - 17:26:16] [WORLD__CLIENT] root: Client disconnected (not active in process)


any ideas? If not don't worry i'm still at it cause I'm determinded to get this to work!

Kanlei
06-28-2007, 07:47 PM
OK just so that everyone knows. I AM STUPID! I didn't wait long enough before attempting to sign in actually took about 5 min before zoneserver kicked in so not really an error just me not patient enough. so if you run into this. this is why. However I already have a different thread which i'm going to post more on cause the items_db for both peq and ax_classic are not working. need to find out why.