I setup my Linux server and it's supposedly up and running. I've disabled any firewalls and made my Linux box the DMZ behind my router. I run sudo ./world followed by sudo ./zone to get it up and running.
When I look at the server select screen I can see my server as online with 0 users connected.
When I try to connect to it, my client pretty much instantly drops me to the EQ username/password screen and something like this shows up in my world log:
Code:
[Debug] [NET__IDENTIFY] Identified stream 192.168.1.4:54309 with signature Titanium_world
[Debug] [WORLD__CLIENT] Checking inbound connection 192.168.1.4 against BannedIPs table
[Debug] [WORLD__CLIENT] Connection 192.168.1.4 PASSED banned IPs check. Processing connection.
Account Attempting to be created:Templus 0
Error in CreateAccount query 'INSERT INTO account SET name='Templus', status=0, lsaccount_id=187225, time_creation=UNIX_TIMESTAMP();' #1054: Unknown column 'time_creation' in 'field list'
[Debug] [WORLD__CLIENTLIST_ERR] Error adding local account for LS login: 'Templus', duplicate name?
[Debug] [WORLD__CLIENT_ERR] NOCLE: Bad/Expired session key '187225'
Not sure what's going on here. I'm guessing maybe I need to update my database with something? (i'm using the PEQ database)
I'm just running ./zone without passing it any arguments, is that alright to do? The guide said something about setting up a file to open zone with some arguments but I didn't quite understand what it was talking about for that step.
Here's what it looks like when I execute ./world:
Code:
woot@wootbuntu:/eqemu/server$ sudo ./world
[sudo] password for woot:
[Debug] Starting Log: logs/eqemu_debug_world.log
[Debug] [WORLD__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Warning: Unable to read log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEmulator 0.8.0
[Debug] [WORLD__INIT] Added loginserver eqemulator.net:5998
[Debug] [WORLD__INIT] Connecting to MySQL...
[Debug] [COMMON__THREADS] Starting TCPServerLoop with thread ID -1215804560
[Status] Starting Log: logs/eqemu_world.log
[Status] Using database 'peq' at localhost:3306
[Debug] [WORLD__INIT] HTTP world service disabled.
[Debug] [WORLD__INIT] Loading variables..
[Debug] [WORLD__INIT] Loading zones..
[Debug] [COMMON__THREADS] Starting TCPServerLoop with thread ID -1224197264
[Debug] [WORLD__INIT] Clearing groups..
[Debug] [WORLD__INIT] Clearing raids..
[Debug] [WORLD__INIT] Loading items..
[Status] libEMuShareMem.so loaded
shmat failed! Invalid argument
[Warning] requested shared memory of size:84188780 but that Key is already in use with size:1
[Warning] Resize not possible
[Warning] Could not attach to shared memory proceeding on isolated memory (share_id <= 0)
[Debug] [COMMON__THREADS] Starting DBAsyncLoop with thread ID -1232589968
[Status] Loading items from database: count=83375
[Debug] [WORLD__INIT] Loading guilds..
[Debug] [WORLD__INIT] Loaded default rule set 'default'
[Debug] [WORLD__INIT] Clearing temporary merchant lists..
[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] Loading adventures...
[Debug] [WORLD__INIT] Purging expired instances
[Debug] [WORLD__INIT] Zone (TCP) listener started.
[Debug] [WORLD__INIT] Client (UDP) listener started.
[Debug] [COMMON__THREADS] Starting EQStreamFactoryWriterLoop with thread ID -1333564560
[Debug] [COMMON__THREADS] Starting EQStreamFactoryReaderLoop with thread ID -1325171856
[Debug] [NET__IDENTIFY] Registered patch 6.2
[Debug] [NET__IDENTIFY] Registered patch Titanium
[Debug] [NET__IDENTIFY] Registered patch SoF
[Debug] [NET__IDENTIFY] Registered patch SoD
[Debug] [NET__IDENTIFY] Registered patch Live
[Debug] [WORLD__LS] Connecting to login server: eqemulator.net:5998
[Debug] [COMMON__THREADS] Starting TCPConnectionLoop with thread ID -1350349968
[Debug] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998
[Debug] [WORLD__LS] Loginserver provided 208.120.10.206 as world address
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:48835
[Debug] [WORLD__CONSOLE] New zoneserver #1 from 127.0.0.1:48835
[Debug] [WORLD__ZONE] [1] Zone started with name . by launcher NONE
[Debug] [WORLD__ZONE] [1] Auto zone port configuration. Telling zone to use port 7000
[Debug] [WORLD__CLIENT] New connection from 192.168.1.4:54309
[Debug] [NET__IDENT_TRACE] 192.168.1.4:54309: First opcode 0x4dd0 did not match expected 0x2792
[Debug] [NET__IDENT_TRACE] 192.168.1.4:54309: Tried patch 6.2_world, and it did not match.
[Debug] [NET__IDENT_TRACE] 192.168.1.4:54309: First opcode 0x4dd0 did not match expected 0x2ec9
[Debug] [NET__IDENT_TRACE] 192.168.1.4:54309: Tried patch 6.2_zone, and it did not match.
[Debug] [NET__IDENT_TRACE] 192.168.1.4:54309: First opcode matched 0x4dd0 and length matched 464
[Debug] [NET__IDENTIFY] Identified stream 192.168.1.4:54309 with signature Titanium_world
[Debug] [WORLD__CLIENT] Checking inbound connection 192.168.1.4 against BannedIPs table
[Debug] [WORLD__CLIENT] Connection 192.168.1.4 PASSED banned IPs check. Processing connection.
Account Attempting to be created:Templus 0
Error in CreateAccount query 'INSERT INTO account SET name='Templus', status=0, lsaccount_id=187225, time_creation=UNIX_TIMESTAMP();' #1054: Unknown column 'time_creation' in 'field list'
[Debug] [WORLD__CLIENTLIST_ERR] Error adding local account for LS login: 'Templus', duplicate name?
[Debug] [WORLD__CLIENT_ERR] NOCLE: Bad/Expired session key '187225'
Here's what it looks like when I load ./zone:
Code:
woot@wootbuntu:/eqemu/server$ sudo ./zone
[sudo] password for woot:
[Debug] Starting Log: logs/eqemu_debug_zone.log
[Debug] [ZONE__INIT] Loading server configuration..
[Debug] [ZONE__INIT] Warning: Unable to read log.ini
[Debug] [ZONE__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_zone.log
[Status] Using database 'peq' at localhost:3306
[Debug] [ZONE__INIT] CURRENT_ZONE_VERSION: EQEmulator 0.8.0
[Debug] [ZONE__INIT] Warning: Unable to read ./log.ini
[Debug] [ZONE__INIT] Mapping Incoming Opcodes
[Debug] [ZONE__INIT] Loading Variables
[Debug] [ZONE__INIT] Loading zone names
[Debug] [ZONE__INIT] Loading items
[Status] libEMuShareMem.so loaded
shmat failed! Invalid argument
[Warning] requested shared memory of size:84188780 but that Key is already in use with size:1
[Warning] Resize not possible
[Warning] Could not attach to shared memory proceeding on isolated memory (share_id <= 0)
[Debug] [COMMON__THREADS] Starting DBAsyncLoop with thread ID -1216324752
[Status] Loading items from database: count=83375
[Debug] [ZONE__INIT] Loading npc faction lists
[Debug] [ZONE__INIT] Loading loot tables
[Debug] [ZONE__INIT] Loading skill caps
[Debug] [ZONE__INIT] Loading spells
[Debug] [ZONE__INIT] Loading guilds
[Debug] [ZONE__INIT] Loading factions
[Debug] [ZONE__INIT] Loading titles
[Debug] [ZONE__INIT] Loading AA effects
[Debug] [ZONE__INIT] Loading tributes
[Debug] [ZONE__INIT] Loading corpse timers
[Debug] [ZONE__INIT] Loading commands
[Debug] command_init(): - Command 'acceptrules' set to access level 0.
[Debug] command_init(): - Command 'advnpcspawn' set to access level 150.
[Debug] command_init(): - Command 'aggro' set to access level 80.
[Debug] command_init(): - Command 'aggrozone' set to access level 100.
[Debug] command_init(): - Command 'ai' set to access level 100.
[Debug] command_init(): - Command 'altactivate' set to access level 0.
[Debug] command_init(): - Command 'appearance' set to access level 150.
[Debug] command_init(): - Command 'attack' set to access level 150.
[Debug] command_init(): - Command 'ban' set to access level 150.
[Debug] command_init(): - Command 'bestz' set to access level 0.
[Debug] command_init(): - Command 'bind' set to access level 200.
[Debug] command_init(): - Command 'cast' set to access level 0.
[Debug] command_init(): - Command 'castspell' set to access level 50.
[Debug] command_init(): - Command 'charbackup' set to access level 150.
[Debug] command_init(): - Command 'chat' set to access level 200.
[Debug] command_init(): - Command 'checklos' set to access level 50.
[Debug] command_init(): - Command 'connectworld' set to access level 0.
[Debug] command_init(): - Command 'connectworldserver' set to access level 200.
[Debug] command_init(): - Command 'copychar' set to access level 100.
[Debug] command_init(): - Command 'corpse' set to access level 50.
[Debug] command_init(): - Command 'crashtest' set to access level 200.
[Debug] command_init(): - Command 'cvs' set to access level 200.
[Debug] command_init(): - Command 'd1' set to access level 200.
[Debug] command_init(): - Command 'damage' set to access level 100.
[Debug] command_init(): - Command 'datarate' set to access level 100.
[Debug] command_init(): - Command 'date' set to access level 90.
[Debug] command_init(): - Command 'dbspawn' set to access level 0.
[Debug] command_init(): - Command 'dbspawn2' set to access level 100.
[Debug] command_init(): - Command 'delacct' set to access level 150.
[Debug] command_init(): - Command 'deletegraveyard' set to access level 200.
[Debug] command_init(): - Command 'delpetition' set to access level 20.
[Debug] command_init(): - Command 'depop' set to access level 50.
[Debug] command_init(): - Command 'depopzone' set to access level 100.
[Debug] command_init(): - Command 'distance' set to access level 80.
[Debug] command_init(): - Command 'doanim' set to access level 50.
[Debug] command_init(): - Command 'eitem' set to access level 200.
[Debug] command_init(): - Command 'emote' set to access level 80.
[Debug] command_init(): - Command 'equipitem' set to access level 50.
[Debug] command_init(): - Command 'face' set to access level 250.
[Debug] command_init(): - Command 'fear' set to access level 200.
[Debug] command_init(): - Command 'finditem' set to access level 0.
[Debug] command_init(): - Command 'findnpctype' set to access level 100.
[Debug] command_init(): - Command 'findspell' set to access level 50.
[Debug] command_init(): - Command 'findzone' set to access level 100.
[Debug] command_init(): - Command 'fixmob' set to access level 100.
[Debug] command_init(): - Command 'flag' set to access level 200.
[Debug] command_init(): - Command 'flagedit' set to access level 100.
[Debug] command_init(): - Command 'flags' set to access level 0.
[Debug] command_init(): - Command 'flymode' set to access level 50.
[Debug] command_init(): - Command 'fov' set to access level 80.
[Debug] command_init(): - Command 'freeze' set to access level 80.
[Debug] command_init(): - Command 'fz' set to access level 100.
[Debug] command_init(): - Command 'gassign' set to access level 100.
[Debug] command_init(): - Command 'gender' set to access level 50.
[Debug] command_init(): - Command 'getvariable' set to access level 200.
[Debug] command_init(): - Command 'gi' set to access level 200.
[Debug] command_init(): - Command 'ginfo' set to access level 20.
[Debug] command_init(): - Command 'giveitem' set to access level 200.
[Debug] command_init(): - Command 'givemoney' set to access level 150.
[Debug] command_init(): - Command 'globalview' set to access level 80.
[Debug] command_init(): - Command 'gm' set to access level 80.
[Debug] command_init(): - Command 'gmhideme' set to access level 0.
[Debug] command_init(): - Command 'gmspeed' set to access level 100.
[Debug] command_init(): - Command 'goto' set to access level 10.
[Debug] command_init(): - Command 'grid' set to access level 170.
[Debug] command_init(): - Command 'guild' set to access level 10.
[Debug] command_init(): - Command 'guildapprove' set to access level 0.
[Debug] command_init(): - Command 'guildcreate' set to access level 0.
[Debug] command_init(): - Command 'guildlist' set to access level 0.
[Debug] command_init(): - Command 'guilds' set to access level 0.
[Debug] command_init(): - Command 'haste' set to access level 100.
[Debug] command_init(): - Command 'hatelist' set to access level 80.
[Debug] command_init(): - Command 'heal' set to access level 10.
[Debug] command_init(): - Command 'help' set to access level 0.
[Debug] command_init(): - Command 'hideme' set to access level 80.
[Debug] command_init(): - Command 'hp' set to access level 0.
[Debug] command_init(): - Command 'incstat' set to access level 200.
[Debug] command_init(): - Command 'instance' set to access level 200.
[Debug] command_init(): - Command 'interrupt' set to access level 50.
[Debug] command_init(): - Command 'invul' set to access level 0.
[Debug] command_init(): - Command 'invulnerable' set to access level 80.
[Debug] command_init(): - Command 'ipban' set to access level 200.
[Debug] command_init(): - Command 'iplookup' set to access level 200.
[Debug] command_init(): - Command 'iteminfo' set to access level 10.
[Debug] command_init(): - Command 'itemsearch' set to access level 10.
[Debug] command_init(): - Command 'itemtest' set to access level 250.
[Debug] command_init(): - Command 'kick' set to access level 150.
[Debug] command_init(): - Command 'kill' set to access level 100.
[Debug] command_init(): - Command 'lastname' set to access level 50.
[Debug] command_init(): - Command 'level' set to access level 10.
[Debug] command_init(): - Command 'listnpcs' set to access level 20.
[Debug] command_init(): - Command 'listpetition' set to access level 50.
[Debug] command_init(): - Command 'loc' set to access level 0.
[Debug] command_init(): - Command 'lock' set to access level 150.
[Debug] command_init(): - Command 'log' set to access level 80.
[Debug] command_init(): - Command 'logs' set to access level 250.
[Debug] command_init(): - Command 'logsql' set to access level 200.
[Debug] command_init(): - Command 'los' set to access level 0.
[Debug] command_init(): - Command 'makepet' set to access level 50.
[Debug] command_init(): - Command 'mana' set to access level 50.
[Debug] command_init(): - Command 'manaburn' set to access level 10.
[Debug] command_init(): - Command 'manastat' set to access level 80.
[Debug] command_init(): - Command 'memspell' set to access level 50.
[Debug] command_init(): - Command 'mlog' set to access level 250.
[Debug] command_init(): - Command 'modifynpcstat' set to access level 150.
[Debug] command_init(): - Command 'motd' set to access level 150.
[Debug] command_init(): - Command 'movechar' set to access level 50.
[Debug] command_init(): - Command 'mystats' set to access level 50.
[Debug] command_init(): - Command 'name' set to access level 150.
[Debug] command_init(): - Command 'netstats' set to access level 200.
[Debug] command_init(): - Command 'nologs' set to access level 250.
[Debug] command_init(): - Command 'npccast' set to access level 80.
[Debug] command_init(): - Command 'npcedit' set to access level 100.
[Debug] command_init(): - Command 'npcemote' set to access level 150.
[Debug] command_init(): - Command 'npcloot' set to access level 80.
[Debug] command_init(): - Command 'npcsay' set to access level 150.
[Debug] command_init(): - Command 'npcshout' set to access level 150.
[Debug] command_init(): - Command 'npcspawn' set to access level 170.
[Debug] command_init(): - Command 'npcspecialatk' set to access level 0.
[Debug] command_init(): - Command 'npcspecialattack' set to access level 0.
[Debug] command_init(): - Command 'npcspecialattk' set to access level 80.
[Debug] command_init(): - Command 'npcstats' set to access level 80.
[Debug] command_init(): - Command 'npctypespawn' set to access level 10.
[Debug] command_init(): - Command 'nukebuffs' set to access level 50.
[Debug] command_init(): - Command 'nukeitem' set to access level 150.
[Debug] command_init(): - Command 'numauths' set to access level 200.
[Debug] command_init(): - Command 'object' set to access level 100.
[Debug] command_init(): - Command 'oocmute' set to access level 200.
[Debug] command_init(): - Command 'opcode' set to access level 250.
[Debug] command_init(): - Command 'optest' set to access level 255.
[Debug] command_init(): - Command 'path' set to access level 200.
[Debug] command_init(): - Command 'peekinv' set to access level 100.
[Debug] command_init(): - Command 'peqzone' set to access level 100.
[Debug] command_init(): - Command 'permaclass' set to access level 80.
[Debug] command_init(): - Command 'permagender' set to access level 80.
[Debug] command_init(): - Command 'permarace' set to access level 80.
[Debug] command_init(): - Command 'petitioninfo' set to access level 20.
[Debug] command_init(): - Command 'pf' set to access level 0.
[Debug] command_init(): - Command 'pvp' set to access level 100.
[Debug] command_init(): - Command 'qglobal' set to access level 100.
[Debug] command_init(): - Command 'race' set to access level 50.
[Debug] command_init(): - Command 'raidloot' set to access level 0.
[Debug] command_init(): - Command 'randomfeatures' set to access level 80.
[Debug] command_init(): - Command 'refreshgroup' set to access level 0.
[Debug] command_init(): - Command 'refundaa' set to access level 100.
[Debug] command_init(): - Command 'reloadpl' set to access level 0.
[Debug] command_init(): - Command 'reloadqst' set to access level 0.
[Debug] command_init(): - Command 'reloadquest' set to access level 150.
[Debug] command_init(): - Command 'reloadstatic' set to access level 150.
[Debug] command_init(): - Command 'reloadzonepoints' set to access level 150.
[Debug] command_init(): - Command 'reloadzps' set to access level 0.
[Debug] command_init(): - Command 'repop' set to access level 100.
[Debug] command_init(): - Command 'resetaa' set to access level 200.
[Debug] command_init(): - Command 'revoke' set to access level 200.
[Debug] command_init(): - Command 'rules' set to access level 250.
[Debug] command_init(): - Command 'save' set to access level 50.
[Debug] command_init(): - Command 'scribespell' set to access level 180.
[Debug] command_init(): - Command 'scribespells' set to access level 150.
[Debug] command_init(): - Command 'search' set to access level 0.
[Debug] command_init(): - Command 'sendop' set to access level 200.
[Debug] command_init(): - Command 'sendzonespawns' set to access level 150.
[Debug] command_init(): - Command 'serverinfo' set to access level 200.
[Debug] command_init(): - Command 'serverrules' set to access level 0.
[Debug] command_init(): - Command 'serversidename' set to access level 0.
[Debug] command_init(): - Command 'setaaexp' set to access level 0.
[Debug] command_init(): - Command 'setaapoints' set to access level 0.
[Debug] command_init(): - Command 'setaapts' set to access level 100.
[Debug] command_init(): - Command 'setaaxp' set to access level 100.
[Debug] command_init(): - Command 'setadventurepoints' set to access level 150.
[Debug] command_init(): - Command 'setallskill' set to access level 0.
[Debug] command_init(): - Command 'setanim' set to access level 200.
[Debug] command_init(): - Command 'setcrystals' set to access level 100.
[Debug] command_init(): - Command 'setexp' set to access level 0.
[Debug] command_init(): - Command 'setfaction' set to access level 170.
[Debug] command_init(): - Command 'setgraveyard' set to access level 200.
[Debug] command_init(): - Command 'setitemstatus' set to access level 100.
[Debug] command_init(): - Command 'setlanguage' set to access level 50.
[Debug] command_init(): - Command 'setlsinfo' set to access level 10.
[Debug] command_init(): - Command 'setpass' set to access level 150.
[Debug] command_init(): - Command 'setpvppoints' set to access level 100.
[Debug] command_init(): - Command 'setskill' set to access level 50.
[Debug] command_init(): - Command 'setskillall' set to access level 50.
[Debug] command_init(): - Command 'setstartzone' set to access level 80.
[Debug] command_init(): - Command 'setstat' set to access level 255.
[Debug] command_init(): - Command 'setxp' set to access level 100.
[Debug] command_init(): - Command 'showbuffs' set to access level 50.
[Debug] command_init(): - Command 'showpetspell' set to access level 200.
[Debug] command_init(): - Command 'showskills' set to access level 50.
[Debug] command_init(): - Command 'showstats' set to access level 50.
[Debug] command_init(): - Command 'shutdown' set to access level 150.
[Debug] command_init(): - Command 'si' set to access level 200.
[Debug] command_init(): - Command 'size' set to access level 50.
[Debug] command_init(): - Command 'spawn' set to access level 10.
[Debug] command_init(): - Command 'spawnfix' set to access level 170.
[Debug] command_init(): - Command 'spawnstatus' set to access level 100.
[Debug] command_init(): - Command 'spellinfo' set to access level 10.
[Debug] command_init(): - Command 'spfind' set to access level 0.
[Debug] command_init(): - Command 'spoff' set to access level 80.
[Debug] command_init(): - Command 'spon' set to access level 80.
[Debug] command_init(): - Command 'stun' set to access level 100.
[Debug] command_init(): - Command 'summon' set to access level 80.
[Debug] command_init(): - Command 'summonitem' set to access level 200.
[Debug] command_init(): - Command 'suspend' set to access level 150.
[Debug] command_init(): - Command 'synctod' set to access level 90.
[Debug] command_init(): - Command 'task' set to access level 250.
[Debug] command_init(): - Command 'testspawn' set to access level 200.
[Debug] command_init(): - Command 'testspawnkill' set to access level 200.
[Debug] command_init(): - Command 'texture' set to access level 10.
[Debug] command_init(): - Command 'time' set to access level 90.
[Debug] command_init(): - Command 'timers' set to access level 200.
[Debug] command_init(): - Command 'timezone' set to access level 90.
[Debug] command_init(): - Command 'title' set to access level 50.
[Debug] command_init(): - Command 'traindisc' set to access level 150.
[Debug] command_init(): - Command 'undyeme' set to access level 0.
[Debug] command_init(): - Command 'unfreeze' set to access level 80.
[Debug] command_init(): - Command 'unlock' set to access level 150.
[Debug] command_init(): - Command 'unscribespell' set to access level 180.
[Debug] command_init(): - Command 'unscribespells' set to access level 180.
[Debug] command_init(): - Command 'uptime' set to access level 10.
[Debug] command_init(): - Command 'version' set to access level 0.
[Debug] command_init(): - Command 'viewmessage' set to access level 100.
[Debug] command_init(): - Command 'viewmessages' set to access level 0.
[Debug] command_init(): - Command 'viewnpctype' set to access level 100.
[Debug] command_init(): - Command 'viewpetition' set to access level 20.
[Debug] command_init(): - Command 'wc' set to access level 200.
[Debug] command_init(): - Command 'weather' set to access level 80.
[Debug] command_init(): - Command 'worldshutdown' set to access level 200.
[Debug] command_init(): - Command 'wp' set to access level 170.
[Debug] command_init(): - Command 'wpadd' set to access level 170.
[Debug] command_init(): - Command 'wpinfo' set to access level 170.
[Debug] command_init(): - Command 'zclip' set to access level 80.
[Debug] command_init(): - Command 'zcolor' set to access level 80.
[Debug] command_init(): - Command 'zhdr' set to access level 0.
[Debug] command_init(): - Command 'zheader' set to access level 80.
[Debug] command_init(): - Command 'zone' set to access level 50.
[Debug] command_init(): - Command 'zonebootup' set to access level 150.
[Debug] command_init(): - Command 'zoneinstance' set to access level 50.
[Debug] command_init(): - Command 'zonelock' set to access level 100.
[Debug] command_init(): - Command 'zoneshutdown' set to access level 150.
[Debug] command_init(): - Command 'zonespawn' set to access level 250.
[Debug] command_init(): - Command 'zonestatus' set to access level 150.
[Debug] command_init(): - Command 'zsafecoords' set to access level 80.
[Debug] command_init(): - Command 'zsave' set to access level 80.
[Debug] command_init(): - Command 'zsky' set to access level 80.
[Debug] command_init(): - Command 'zstats' set to access level 80.
[Debug] command_init(): - Command 'zunderworld' set to access level 80.
[Debug] command_init(): - Command 'zuwcoords' set to access level 80.
[Debug] [ZONE__INIT] 239 commands loaded
[Debug] [ZONE__INIT] Loaded default rule set 'default'
[Debug] [ZONE__INIT] Loading Tasks
[Debug] [ZONE__INIT] Loading embedded perl XS
[Debug] [ZONE__INIT] Loading quests
[Quest] Starting Log: logs/eqemu_quest_zone.log
[Quest] Tying perl output to eqemu logs
[Quest] Creating EQEmuIO=HASH(0x9a27dc0)
[Quest] Creating EQEmuIO=HASH(0x9a231d8)
[Quest] Loading perlemb plugins.
[Quest] Unable to read perl file 'plugin.pl'
[Quest] Loading perl commands...
[Quest] Unable to read perl file 'commands.pl'
[Debug] [ZONE__INIT] Entering sleep mode
[Debug] [NET__IDENTIFY] Registered patch 6.2
[Debug] [COMMON__THREADS] Starting TCPConnectionLoop with thread ID -1334719632
[Debug] [NET__IDENTIFY] Registered patch Titanium
[Debug] [NET__IDENTIFY] Registered patch SoF
[Debug] [NET__IDENTIFY] Registered patch SoD
[Debug] [NET__IDENTIFY] Registered patch Live
[Debug] [COMMON__THREADS] Main thread running with thread id -1216321840
[Debug] [NET__WORLD] Connected to World: 127.0.0.1:9000
[Debug] [ZONE__WORLD] World indicated port 7000 for this zone.
[Debug] [ZONE__INIT] Starting EQ Network server on port 7000
[Debug] [COMMON__THREADS] Starting EQStreamFactoryWriterLoop with thread ID -1352668304
[Debug] [COMMON__THREADS] Starting EQStreamFactoryReaderLoop with thread ID -1344275600
[Debug] [COMMON__THREADS] Ending TCPConnectionLoop with thread ID -1334719632
[Debug] [COMMON__THREADS] Starting TCPConnectionLoop with thread ID -1361061008
Any assistance on this matter would be much appreciated. I feel like I'm very very close to getting everything working but at the moment I'm just lost.
Thanks!
EDIT:
I got it working simply by adding a datetime field to my account table called "time_creation", but I'm running into another problem now. I try to create a new character and enter the world and it says ZONE UNAVAILABLE. My zone executable also has a Segmentation fault... This is what's showing up:
world:
Code:
[Status] Start zone query: SELECT x,y,z,zone_id,bind_id FROM start_zones WHERE player_choice=10 AND player_class=3 AND player_deity=215 AND player_race=5
[Status] Found starting location in start_zones
[Debug] [WORLD__CLIENT] Templus: Current location: felwithea -301.00, 0.00, 4.00
[Debug] [WORLD__CLIENT] Templus: Bind location: felwithea -301.00, 0.00, 4.00
[Debug] [WORLD__CLIENT] Templus: Character creation successful: Templus
[Debug] [WORLD__CLIENT] Templus: Attempting autobootup of tutorialb (189:0)
[Debug] [WORLD__ZONELIST] Removing zoneserver #1 at :7000
[Debug] [WORLD__ZONELIST] Hold Zones mode is ON - rebooting lost zone
[Debug] [WORLD__CLIENT_ERR] Templus: Zone bootup timer expired, bootup failed or too slow.
zone:
Code:
[Status] Loading Doors from database...
[Status] Loading AA information...
[Error] Starting Log: logs/eqemu_error_zone.log
[Error] Error in GetAASkillVars 'SELECT a.cost, a.max_level, a.hotkey_sid, a.hotkey_sid2, a.title_sid, a.desc_sid, a.type, COALESCE((SELECT p.prereq_index_num FROM (SELECT a2.skill_id, @row := @row + 1 AS prereq_index_num FROM altadv_vars a2) AS p WHERE p.skill_id = a.prereq_skill), 0) AS prereq_skill_index, a.prereq_minpoints, a.spell_type, a.spell_refresh, a.classes, a.berserker, a.spellid, a.class_type, a.name, a.cost_inc, a.aa_expansion, a.special_category, a.sof_type, a.sof_cost_inc, a.sof_max_level, a.sof_next_skill, a.clientver, a.account_time_required FROM altadv_vars a WHERE skill_id=2': #1054: Unknown column 'a.account_time_required' in 'field list'
Segmentation fault
Let me try adding an account_time_required boolean perhaps to the database =\ .. I feel like my database is just totally messed up :(
EDIT:
Adding a boolean (default of 0) called account_time_required allows me to log into a zone.. so I guess that works now, but again I'm forced to wonder what other problems I'll run into due to a database that's not setup right (default peq database)
EDIT:
Now when I try using the #zone command it says in game "This zone is not ready to receive visitors yet. Please try again in a few moments."
messages in my world:
Code:
[Debug] [WORLD__ZONE] [2] [tutorialb] ZoneToZone request for Templus current zone 189 req zone 54
[Debug] [WORLD__ZONE] [2] [tutorialb] Processing ZTZ for egress from zone for client Templus
[Debug] [WORLD__ZONE_ERR] FAILED to boot a zone for Templus
messages in my zone:
Code:
[Status] Zoning 'Templus' to: gfaydark (54) - (0) x=10.000000, y=-20.000000, z=0.000000
[Debug] Zone request from Templus
0: 54 65 6D 70 6C 75 73 00 - 00 00 00 00 00 00 00 00 | Templus.........
16: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
32: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
48: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
64: BD 00 00 00 00 00 13 C3 - 00 00 90 41 00 00 A0 41 | ...........A...A
80: 01 00 00 00 00 00 00 00
Whats wrong this time? Why isn't my zone loading? =\