Crash while logging into EQ

[Malk]

Hello,

i used this Tutorial: http://www.eqemulator.net/wiki/wikka.php?wakka=Windows

I can login into the Server and create a charakter...
But when i try to log in the Charakter I'm kicked to the Login-Screen.

Info:
AMD Dualcore (Brisbane) 2x1.9GHz
1GB RAM
Graphik: nforce 630a (GeForce 7050)
Windows XP SP2

Server and client are on the same PC.
The PC does not have a internet-Connection (to be sure the Client is not updating).

Logg:

LoginServer.ini read.
[Status] Loading opcodes..
Server mode: MiniLogin
Login server listening on port:5999
7703 New Server connection: 127.0.0.1 port: 5893
   0: 00 00 00 00 00 00 00 00 - 01 00 00 00              | ............
   0: 00 00 00 00 01 00 00 00 - 00 00 00 00 00 00 00 00  | ................
  16: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00  | ................
  32: 00 01 00 00 00                                     | .....
   0: A8 0A 23 06 00 00 00 00 - 02 00 00 00              | ..#.........
   0: 78 F6 E3 00 00 00 00 00 - 03 00 00 00              | x...........
   0: 00 50 5F 44 00 00 00 00 - 04 00 00 00              | .P_D........
   0: 00 00 00 00 01 00 00 00 - 00 00 00 00 00 00 00 00  | ................
  16: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00  | ................
  32: 00 02 00 00 00                                     | .....
   0: 69 6F 6E 55 00 00 00 00 - 05 00 00 00              | ionU........
   0: 00 00 00 00 01 00 00 00 - 00 00 00 00 00 00 00 00  | ................
  16: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00  | ................
  32: 00 03 00 00 00                                     | .....
   0: 00 00 00 00 01 00 00 00 - 00 00 00 00 00 00 00 00  | ................
  16: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00  | ................
  32: 00 04 00 00 00                                     | .....
   0: 00 00 00 00 01 00 00 00 - 00 00 00 00 00 00 00 00  | ................
  16: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00  | ................
  32: 00 05 00 00 00                                     | .....
122656 New client from ip: 127.0.0.1 port: 1315
Unknown packet:  .4233692 [92.153.64.0:15->0.0.0.0:0]
[OpCode 0x0003 (OP_Unknown) Size=11]
 00000: 00 06 00 00 00 00 00 00 - 00 00 00                | ...........

Failed to open log file: logs/eqemu_debug_world_3308.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...
Failed to open log file: logs/eqemu_world_3308.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..
Failed to open log file: logs/eqemu_error_world_3308.log
[Error] Could not load EQTime file eqtime.cfg
[Debug] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[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] Setting World to MiniLogin Server type
[Debug] [WORLD__LS] Connected to Loginserver: localhost:5999
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1304
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:1304
[Debug] [WORLD__LAUNCH] Adding pending launcher 1
[Debug] [WORLD__LAUNCH] Launcher Identified itself as 'zone'. Loading zone list.

[Debug] [WORLD__LAUNCH] Removing pending launcher 1. Adding zone to active list.

[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1306
[Debug] [WORLD__CONSOLE] New zoneserver #1 from 127.0.0.1:1306
[Debug] [WORLD__ZONE] [1] Zone started with name dynamic_01 by launcher zone
[Debug] [WORLD__ZONE] [1] Auto zone port configuration.  Telling zone to use por
t 7000
[Debug] [WORLD__LAUNCH] zone: dynamic_02 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1308
[Debug] [WORLD__CONSOLE] New zoneserver #2 from 127.0.0.1:1308
[Debug] [WORLD__ZONE] [2] Zone started with name dynamic_02 by launcher zone
[Debug] [WORLD__ZONE] [2] Auto zone port configuration.  Telling zone to use por
t 7001
[Debug] [WORLD__LAUNCH] zone: dynamic_03 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1310
[Debug] [WORLD__CONSOLE] New zoneserver #3 from 127.0.0.1:1310
[Debug] [WORLD__ZONE] [3] Zone started with name dynamic_03 by launcher zone
[Debug] [WORLD__ZONE] [3] Auto zone port configuration.  Telling zone to use por
t 7002
[Debug] [WORLD__LAUNCH] zone: dynamic_04 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1312
[Debug] [WORLD__CONSOLE] New zoneserver #4 from 127.0.0.1:1312
[Debug] [WORLD__ZONE] [4] Zone started with name dynamic_04 by launcher zone
[Debug] [WORLD__ZONE] [4] Auto zone port configuration.  Telling zone to use por
t 7003
[Debug] [WORLD__LAUNCH] zone: dynamic_05 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1314
[Debug] [WORLD__CONSOLE] New zoneserver #5 from 127.0.0.1:1314
[Debug] [WORLD__ZONE] [5] Zone started with name dynamic_05 by launcher zone
[Debug] [WORLD__ZONE] [5] Auto zone port configuration.  Telling zone to use por
t 7004
[Debug] [WORLD__CLIENT] New connection from 127.0.0.1:1316
[Debug] [NET__IDENT_TRACE] 127.0.0.1:1316: First opcode 0x4dd0 did not match exp
ected 0x2792
[Debug] [NET__IDENT_TRACE] 127.0.0.1:1316: Tried patch 6.2_world, and it did not
 match.
[Debug] [NET__IDENT_TRACE] 127.0.0.1:1316: First opcode 0x4dd0 did not match exp
ected 0x2ec9
[Debug] [NET__IDENT_TRACE] 127.0.0.1:1316: Tried patch 6.2_zone, and it did not
match.
[Debug] [NET__IDENT_TRACE] 127.0.0.1:1316: First opcode matched 0x4dd0 and lengt
h matched 464
[Debug] [NET__IDENTIFY] Identified stream 127.0.0.1:1316 with signature Titanium
_world
[Debug] [WORLD__CLIENT] Checking inbound connection 127.0.0.1 against BannedIPs
table
[Debug] [WORLD__CLIENT] Connection 127.0.0.1 PASSED banned IPs check.  Processin
g connection.
[Debug] [WORLD__CLIENT] malk: Logged in. Mode=(CharSel)
[Debug] [WORLD__CLIENT] malk: MiniLogin Account #1
[Debug] [WORLD__CLIENT] malk: Name approval request.  Name=Urmi, race=Vah Shir,
class=Rogue
[Debug] [WORLD__CLIENT] malk: Character creation request from  LS#0 (127.0.0.1:1
316) :
[Debug] [WORLD__CLIENT] malk: Name: Urmi
[Debug] [WORLD__CLIENT] malk: Race: 130  Class: 9  Gender: 0  Deity: 396  Start
zone: 13
[Debug] [WORLD__CLIENT] malk: STR  STA  AGI  DEX  WIS  INT  CHA    Total
[Debug] [WORLD__CLIENT] malk:  90  100  105   80   70   65   65     575
[Debug] [WORLD__CLIENT] malk: Face: 4  Eye colors: 6 6
[Debug] [WORLD__CLIENT] malk: Hairstyle: 255  Haircolor: 255
[Debug] [WORLD__CLIENT] malk: Beard: 255  Beardcolor: 255
[Debug] [WORLD__CLIENT] Validating char creation info...
[Debug] [WORLD__CLIENT] Found 0 errors in character creation request
[Status] Start zone query: SELECT x,y,z,zone_id,bind_id FROM start_zones WHERE p
layer_choice=13 AND player_class=9 AND player_deity=396 AND player_race=130

[Status] Found starting location in start_zones
[Debug] [WORLD__CLIENT] malk: Current location: sharvahl  0.75, -112.38, -181.62

[Debug] [WORLD__CLIENT] malk: Bind location: sharvahl  0.75, -112.38, -181.62
[Debug] [WORLD__CLIENT] malk: Character creation successful: Urmi
[Debug] [WORLD__CLIENT] malk: Attempting autobootup of tutorialb (189:0)
[Debug] [WORLD__ZONE] [5] Setting to 'tutorialb' (189:0)
[Debug] [WORLD__CLIENT] malk: Entering zone tutorialb (189:0)
[Debug] [WORLD__ZONE] [5] [tutorialb] Broadcasting a world time update
[Debug] [WORLD__ZONE] [5] [tutorialb] Setting to 'tutorialb' (189:0)
[Debug] [WORLD__CLIENT] malk: Sending client to zone tutorialb (189:0) at localh
ost:7004
[Debug] [WORLD__CLIENT] malk: Client disconnected (not active in process)

Failed to open log file: logs/eqemu_debug_3360.log
[Debug] [LAUNCHER__INIT] Loading server configuration..
[Debug] [LAUNCHER__INIT] Starting main loop...
[Debug] [NET__WORLD] Connected to World: 127.0.0.1:9000
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_01.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_02.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_03.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_04.
[Debug] [LAUNCHER__WORLD] World told us to start zone dynamic_05.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_01, but it is alre
ady running.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_02, but it is alre
ady running.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_03, but it is alre
ady running.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_04, but it is alre
ady running.
[Debug] [LAUNCHER__ERROR] World told us to start zone dynamic_05, but it is alre
ady running.
[Debug] [LAUNCHER__STATUS] Starting zone dynamic_01
[Debug] [LAUNCHER__STATUS] Zone dynamic_01 has been started.
[Debug] [LAUNCHER__STATUS] Waiting 20000 milliseconds before booting the second
zone.
[Debug] [LAUNCHER__STATUS] Starting zone dynamic_02
[Debug] [LAUNCHER__STATUS] Zone dynamic_02 has been started.
[Debug] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zon
e.
[Debug] [LAUNCHER__STATUS] Starting zone dynamic_03
[Debug] [LAUNCHER__STATUS] Zone dynamic_03 has been started.
[Debug] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zon
e.
[Debug] [LAUNCHER__STATUS] Starting zone dynamic_04
[Debug] [LAUNCHER__STATUS] Zone dynamic_04 has been started.
[Debug] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zon
e.
[Debug] [LAUNCHER__STATUS] Starting zone dynamic_05
[Debug] [LAUNCHER__STATUS] Zone dynamic_05 has been started.
[Debug] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zon
e.

Any Ideas?

[Huppy]

You need a file called log.ini in your eqemu folder. If you don't have one, just
make one with a text editor, with nothing in it. OR,
grab it from the /trunk/EQEmuServer/utils/defaults folder where it usually is.

[Malk]

i made a log.ini, but it doesnt solve the problem...:(

On another PC in LAN i can only log into the server screen. When i try to log into a server, i get back to login after 60 sec.
On the Server i still can log into the server, but when entering the world-> Login-Screen.

[Huppy]

Do you also have a logs folder in your eqemu folder ? By the looks of it,
there is probably a few things missing that you need.
http://www.eqemulator.org/forums/showthread.php?t=32980
This covers a public server guide, but there is things you can read about
to help.

[Malk]

in your Guide there is MySQL 5.1.**
But in the guid i have read

NOTE: In mysql 5.1.* they introduced a new reserved keyword 'range' into the sql language, unfortunately the items table in the peq database already has a field named "range". To avoid this conflict we're using a 5.0.* version.

I'm using 5.0.85
and Perl 5.10.1.1008

I will read the guide tomorrow. Its after midnight here...

[lerxst2112]

Try applying this SQL to your database. It is the part of required update 1711 that is currently missing in the PEQ database.

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;

[Malk]

yeah, thank you lerxst2112.
It works... but only on the PC on which the server is.

If I try to login from another PC i only get to the Server-Choose, after that I am kicked back to the login-Screen...

Did i anything wrong with the eqhost?
I typed in the IP:Port of the Server...
In the world.exe-Window he shows, when I log in (on the same PC). When i log in from some other PC, he doesnt show anything... only in the Mini-Login-Window.

[c0ncrete]

What are your entries for <address> and <localaddress> in eqemu_config.xml?

Also, are you using SoD clients? You'll probably need to do this. It's how I got mine working.

[Malk]

<address>localhost</address>
<localaddress>localhost</localaddress>

I use the Titanium-Edition.

Question: When i create a Account for Mini-Login i have to type in a "minilogin_ip". Usually its 127.0.0.1.
Do i have to type in the Adress of the Server, or of the client?

edit: Typing in the client-IP also doesnt work.

edit2: THANKS @ c0ncrete
I typed in the "concrete" IP-Adress of the Server, not localhost. Now it works

[c0ncrete]

I think you can leave those two lines completely commented out if you're only going to be running on a local network.

[johno]

Originally Posted by lerxst2112

Try applying this SQL to your database. It is the part of required update 1711 that is currently missing in the PEQ database.

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;

pulling hair till i found this tasty nugget.

where is this documented?

[lerxst2112]

Originally Posted by johno

pulling hair till i found this tasty nugget.

where is this documented?

In every guide that tells you to apply the sql updates once you've sourced the PEQ database. There were some issues with the database release before the latest one where some updates were applied and some were not and you needed to backtrack a bit, but if you're using the latest version then you just need to apply anything newer than 1900.

[SBellew75]

Might be a silly question, but how big is your 'maps' directory? My map file kept downloading corrupted and I finally had to SVN the files individually. My 'maps' directory is ~1.7Gb

[lerxst2112]

Mine is 3.56 GB.

[strider51]

Mine is also 1.7 gb. are there additional maps that I should download?