Cannot see world after login

Wonkanator · #1 12-30-2010, 01:44 PM

I was using the wiki for Windows server dated 3/28/2010. Of course once I went through the install, I noticed it was very out dated. I am using all the software builds noted in the wiki steps Perl 5.1, Mysql 5.0.85, etc.

1. I am running on Server 2003 fully patched, etc. I am using the minilogin and the latest server-bots and DBs, etc.
2. when I run ipconfig, my IP address shows as 70.234.***.*** using DSL connection.... in \etc hosts I see 127.0.0.1 localhost
3. I added the 70.234.***.***:5998 per another thread to hosts.
4. startserver.bat seems to load everthing and I do not see errors within the cmd prompt.

#1 - the guide mentions a bunch of folders being created under eqemu \build, \quests, etc...actually some are created when you unzip the server-bots but based upon some other posts, I might be missing some folders.

#2 - What port should I be using for SoF? (yes never connected to EQ and never patched.)

#3 - What is SQL command to change the IP address for my account? In the wiki guide it mentions assigning 127.0.0.1 but should I be using 70.234.***.***?

#4 - please let me know ANY files or pics I need to post.

Thanks in advance...

werebat · #2 12-30-2010, 03:34 PM

I used that same guide a few weeks ago and it worked like a charm. Retrace your steps, it is not outdated.

If you are using SoD and MiniLogin then you will need to do one extra step by updating your opcodes.
If you are using SoF or earlier and MiniLogin then the guide is just fine.

Wonkanator · #3 01-03-2011, 05:07 PM

Changed everthing back and using port 5999...Can log in but still cannot select the created world.

[Debug] Starting Log: logs/eqemu_debug_world_3860.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 localhost:5999
[Debug] [WORLD__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_world_3860.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] [WORLD__INIT] Clearing groups..
[Debug] [WORLD__INIT] Clearing raids..
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=84588
[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] [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 Underfoot
[Debug] [NET__IDENTIFY] Registered patch HoT
[Debug] [WORLD__LS] Connecting to login server: localhost:5999
[Debug] [WORLD__LS] Connected to Loginserver: localhost:5999

servers clients CMD
LoginServer.ini read.
[Status] Loading opcodes..
Server mode: MiniLogin
Login server listening on port:5999
4234 New Server connection: 127.0.0.1 port: 10504
0: 74 68 65 20 70 72 6F 6D - 69 73 65 64 20 6C 61 6E | the promised lan
16: 64 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | d...............
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: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
80: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
96: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
112: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
128: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
144: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
160: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
176: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
192: 00 00 00 00 00 00 00 00 - 00 70 72 6F 6D 69 73 65 | .........promise
208: 64 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | d...............
224: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
240: 00 00 00 00 00 00 00 00 - 00 00 00 6C 6F 63 61 6C | ...........local
256: 68 6F 73 74 00 00 00 00 - 00 00 00 00 00 00 00 00 | host............
272: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
288: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
304: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
320: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
336: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
352: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
368: 00 00 00 00 00 00 00 00 - 6C 6F 63 61 6C 68 6F 73 | ........localhos
384: 74 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | t...............
400: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
416: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
432: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
448: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
464: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
480: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
496: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
512: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
528: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
544: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
560: 00 00 00 30 2E 33 2E 31 - 30 00 00 00 00 00 00 00 | ...0.3.10.......
576: 00 00 00 00 00 00 00 00 - 00 00 00 00 30 2E 38 2E | ............0.8.
592: 30 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | 0...............
608: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
624: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
640: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 | .............
45047 New client from ip: 127.0.0.1 port: 2090

Wonkanator · #4 01-03-2011, 08:59 PM

OK I am closer...I can launch the world and create a character..but cannot enter the zone.. I am booted back to the log in with error at bottom

[Debug] command_init(): - Command 'zuwcoords' set to access level 80.
[Debug] [ZONE__INIT] 240 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_2012.log
[Quest] Tying perl output to eqemu logs
[Quest] Creating EQEmuIO=HASH(0xc4c6f14)
[Quest] Creating EQEmuIO=HASH(0xc4b8754)
[Quest] Loading perlemb plugins.
[Quest] Unable to read perl file 'plugin.pl'
[Quest] Subroutine Cwd::fastcwd redefined at C:/Perl/lib/Cwd.pm line 812.
[Quest] Subroutine Cwd::getcwd redefined at C:/Perl/lib/Cwd.pm line 812.
[Quest] Subroutine Cwd::abs_path redefined at C:/Perl/lib/Cwd.pm line 812.
[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] [NET__IDENTIFY] Registered patch Titanium
[Debug] [NET__IDENTIFY] Registered patch SoF
[Debug] [NET__IDENTIFY] Registered patch SoD
[Debug] [NET__IDENTIFY] Registered patch Underfoot
[Debug] [NET__IDENTIFY] Registered patch HoT
[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
[Status] Booting cabeast (106:0)
[Debug] The next weather check for zone: cabeast will be in 9950 seconds.
[Status] Loading spawn conditions...
[Status] Loading static zone points...
[Status] Loading spawn groups...
[Status] Loading spawn2 points...
[Status] Loading player corpses...
[Status] Loading traps...
[Status] Loading adventure flavor text...
[Status] Loading ground spawns...
[Status] Loading Ground Spawns from DB...
[Status] Loading World Objects from DB...
[Status] Loading Objects from DB...
[Status] Loading doors for cabeast ...
[Status] Loading Doors from database...
[Status] Loading AA information...
[Status] Loading AA Effects...
[Status] Loaded 361 AA Effects.
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
[Status] Successfully loaded Zone Config.
[Status] Loading timezone data...
[Status] Init Finished: ZoneID = 106, Time Offset = 0
Map header: 44303 faces, 648 nodes, 62493 facelists
Loaded map: 132909 vertices, 44303 faces
Map BB: (-1161.53 -> 573.78, -741.72 -> 1377.44, -129.94 -> 167.94)
Map ./Maps/cabeast.map loaded.
Water Map ./Maps/cabeast.wtr not found.
[Error] Starting Log: logs/eqemu_error_zone_2012.log
[Error] Path File ./Maps/cabeast.path not found.
[Debug] Zone: cabeast has weather of type 1.
[Debug] Zone: cabeast(106) has weather type = 1. The weather timer has been enab
led.
[Normal] Starting Log: logs/eqemu_zone_2012.log
[Normal] ---- Zone server cabeast, listening on port:7000 ----
[Status] Zone Bootup: cabeast (106: 0)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [09:02 am]
[Debug] [WORLD__CLIENT] New connection from 127.0.0.1:1036
[Debug] [NET__IDENT_TRACE] 127.0.0.1:1036: First opcode 0x4d38 did not match exp
ected 0x2792
[Debug] [NET__IDENT_TRACE] 127.0.0.1:1036: Tried patch 6.2_world, and it did not
match.
[Debug] [NET__IDENT_TRACE] 127.0.0.1:1036: First opcode 0x4d38 did not match exp
ected 0x2ec9
[Debug] [NET__IDENT_TRACE] 127.0.0.1:1036: Tried patch 6.2_zone, and it did not
match.
[Debug] [NET__IDENT_TRACE] 127.0.0.1:1036: First opcode 0x4d38 did not match exp
ected 0x4dd0
[Debug] [NET__IDENT_TRACE] 127.0.0.1:1036: Tried patch Titanium_world, and it di
d not match.
[Debug] [NET__IDENT_TRACE] 127.0.0.1:1036: First opcode 0x4d38 did not match exp
ected 0x7213
[Debug] [NET__IDENT_TRACE] 127.0.0.1:1036: Tried patch Titanium_zone, and it did
not match.
[Debug] [NET__IDENT_TRACE] 127.0.0.1:1036: First opcode 0x4d38 did not match exp
ected 0x6c3c
[Debug] [NET__IDENT_TRACE] 127.0.0.1:1036: Tried patch SoF_world, and it did not
match.
[Debug] [NET__IDENT_TRACE] 127.0.0.1:1036: First opcode matched 0x737e and lengt
h matched 68
[Debug] [NET__IDENTIFY] Identified stream 127.0.0.1:1036 with signature SoF_zone

[Debug] [WORLD__CLIENT] New client from 127.0.0.1:1036
Error in FinishConnState2(): !dbaq[1]->GetAnswer(): #1054: Unknown column 'time_
creation' in 'field list'
Client disconnected (cs=e): Solzek
Dropping client: Process=false, ip=127.0.0.1, port=1036
[Debug] Client 'Solzek' was destroyed before reaching the connected state:
[Debug] Client sent initial zone packet, but we never got their player info from
the database.
[Status] Zone Shutdown: cabeast (106)
[Normal] Zone shutdown: going to sleep

wolfwalkereci · #5 01-03-2011, 09:48 PM

Make a barbarian and see if it lets you create it and zones you into Halas
Report any error you may encounter.

lerxst2112 · #6 01-03-2011, 10:03 PM

You need to run this SQL against your database. It is from 1711_account_restricted_aa.sql. You may also be missing other updates.

ALTER TABLE `altadv_vars` ADD `account_time_required` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `clientver`;
ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;

If the first line causes an error, then you should only run the last two lines.

Wonkanator · #7 01-03-2011, 10:14 PM

OK...I found a post about that and the 1711 SQL. Do I need to run all sqls in the SQL_UPDATES folder? I am running the newest DB rev.

I was able to create a Iksar SK and zone into east cab... not able to access field of bone "This zone is not ready...." message.

lerxst2112 · #8 01-03-2011, 10:46 PM

In general, you need to run the required updates for anything newer than your database version. 1711 is a different case because even though the DB version is newer than that, it doesn't have that update applied.

It never hurts to look at the updates and make sure your database matches just to be sure.

Wonkanator · #9 01-06-2011, 09:17 AM

Yeah I ran all the updates just to be sure. Server has been running great except for a couple "time" issues. i.e. world is like in haste mode. 6 minutes game time will pass in a few seconds real time. Recycling DB clears it. Does not happen that often at all so not a real concern.