EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)
-   -   World.exe crashing when somebody joins... (https://www.eqemulator.org/forums/showthread.php?t=32352)

psalm 10-23-2010 02:10 AM

World.exe crashing when somebody joins...
 
When somebody connect to my server, world.exe promptly crashes (world.exe has stopped working, close the program etc.)

The last line world.exe shows before it crashes is:


[Debug] [WORLD_CLIENT] New connection from xxx.x.x.x:xxxxx
[Debug] [WORLD_LAUNCH] zone: dynamic_01 reported state STARTED <2 starts>


The login screen ingame just stays at 'Logging in to the server. Please wait....'



Any ideas?

psalm 10-23-2010 09:11 AM

world.exe
 
---------------------------------------------
[10.23. - 13:57:31] Starting Log: logs/eqemu_debug_world_4804.log
[10.23. - 13:57:31] [WORLD__INIT] Loading server configuration..
[10.23. - 13:57:31] [WORLD__INIT] Log settings loaded from log.ini
[10.23. - 13:57:31] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[10.23. - 13:57:31] [WORLD__INIT] Connecting to MySQL...
[10.23. - 13:57:31] [WORLD__INIT] Starting HTTP world service...
[10.23. - 13:57:31] [WORLD__HTTP] Loaded mime types from mime.types
[10.23. - 13:57:31] [WORLD__INIT] Loading variables..
[10.23. - 13:57:31] [WORLD__INIT] Loading zones..
[10.23. - 13:57:31] [WORLD__INIT] Clearing groups..
[10.23. - 13:57:31] [WORLD__INIT] Clearing temporary merchant lists..
[10.23. - 13:57:31] [WORLD__INIT] Loading items..
[10.23. - 13:57:31] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring
[10.23. - 13:57:31] [WORLD__INIT] Loading guilds..
[10.23. - 13:57:31] [RULES__CHANGE] Loading rule set 'default' (1)
[10.23. - 13:57:31] [RULES__CHANGE] Set rule GM:MinStatusToZoneAnywhere to value 250
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:MaxLevel to value 65
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:LeaveCorpses to value true
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:LeaveNakedCorpses to value true
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:ExpMultiplier to value 0.7500000000000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:DeathExpLossLevel to value 10
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:CorpseDecayTimeMS to value 86400000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:AutosaveIntervalS to value 300
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:HPRegenMultiplier to value 100
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:ManaRegenMultiplier to value 100
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:EnduranceRegenMultiplier to value 100
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Guild:MaxMembers to value 2048
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Skills:MaxTrainTradeskills to value 21
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Pets:AttackCommandRange to value 150.0000000000000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule World:ZoneAutobootTimeoutMS to value 120000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule World:ClientKeepaliveTimeoutMS to value 95000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule World:UseBannedIPsTable to value true
[10.23. - 13:57:31] [RULES__CHANGE] Set rule World:MaxClientsPerIP to value -1
[10.23. - 13:57:31] [RULES__CHANGE] Set rule World:ExemptMaxClientsStatus to value -1
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Aggro:PetSpellAggroMod to value 10
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Aggro:SongAggroMod to value 33
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Aggro:SpellAggroMod to value 100
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Combat:BaseCritChance to value 0.0000000000000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Combat:WarBerBaseCritChance to value 0.0299999993294
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Combat:BerserkBaseCritChance to value 0.0599999986589
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Combat:NPCBashKickLevel to value 6
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:ConsumptionMultiplier to value 200
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Spells:AutoResistDiff to value 15
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Spells:ResistChance to value 2.0000000000000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Spells:ResistMod to value 0.4000000059605
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Spells:PartialHitChance to value 0.6999999880791
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Combat:ClientBaseCritChance to value 0.0000000000000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Zone:NPCGlobalPositionUpdateInterval to value 60000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule NPC:MinorNPCCorpseDecayTimeMS to value 600000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule NPC:MajorNPCCorpseDecayTimeMS to value 1200000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Zone:GraveyardTimeMS to value 1200000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Zone:EnableShadowrest to value true
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Map:FixPathingZWhenLoading to value true
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Map:FixPathingZAtWaypoints to value true
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Map:FixPathingZWhenMoving to value true
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Map:FixPathingZOnSendTo to value false
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Zone:ClientLinkdeadMS to value 180000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule NPC:UseItemBonusesForNonPets to value true
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaSendTo to value 20.0000000000000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaLoading to value 20.0000000000000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaMoving to value 20.0000000000000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaWaypoint to value 20.0000000000000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:HealOnLevel to value false
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:FeignKillsPet to value false
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:ItemManaRegenCap to value 15
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemHealthRegenCap to value 15
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Combat:UseIntervalAC to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Combat:PetAttackMagicLevel to value 30
[10.23. - 13:57:32] [RULES__CHANGE] Set rule NPC:SayPauseTimeInSec to value 10
[10.23. - 13:57:32] [RULES__CHANGE] Set rule NPC:OOCRegen to value 0
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Aggro:SmartAggroList to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Aggro:SittingAggroMod to value 35
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Aggro:MeleeRangeAggroMod to value 20
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Aggro:CurrentTargetAggroMod to value 0
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Aggro:CriticallyWoundedAggroMod to value 100
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Aggro:SlowAggroMod to value 450
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Aggro:IncapacitateAggroMod to value 500
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Aggro:MovementImpairAggroMod to value 175
[10.23. - 13:57:32] [RULES__CHANGE] Set rule NPC:BuffFriends to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:DeathItemLossLevel to value 10
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Watermap:CheckWaypointsInWaterWhenLoading to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Watermap:CheckForWaterAtWaypoints to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Watermap:CheckForWaterWhenMoving to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Watermap:CheckForWaterOnSendTo to value false
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Watermap:CheckForWaterWhenFishing to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Watermap:FishingRodLength to value 30.0000000000000
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Watermap:FishingLineLength to value 40.0000000000000
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemDamageShieldCap to value 30
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemAccuracyCap to value 150
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemAvoidanceCap to value 100
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemCombatEffectsCap to value 100
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemShieldingCap to value 35
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemSpellShieldingCap to value 35
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemDoTShieldingCap to value 35
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemStunResistCap to value 35
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemStrikethroughCap to value 35
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Spells:PartialHitChanceFear to value 0.2500000000000
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:MQWarpExemptStatus to value -1
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:MQZoneExemptStatus to value -1
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:MQGateExemptStatus to value -1
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:MQGhostExemptStatus to value -1
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:EnableMQWarpDetector to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:EnableMQZoneDetector to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:EnableMQGateDetector to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:EnableMQGhostDetector to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:MQWarpDetectorDistance to value 4900.0000000000000
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:MQWarpLagThreshold to value 140.0000000000000
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:MQWarpThresholdTimer to value 90000.0000000000000
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Combat:EnableFearPathing to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Combat:FleeHPRatio to value 22
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Combat:FleeIfNotAlone to value false
[10.23. - 13:57:32] [WORLD__INIT] Loaded default rule set 'default'
[10.23. - 13:57:32] [WORLD__INIT] Loading EQ time of day..
[10.23. - 13:57:32] [WORLD__INIT] Loading launcher list..
[10.23. - 13:57:32] [WORLD__INIT] Reboot zone modes ON
[10.23. - 13:57:32] [WORLD__INIT] Deleted 0 stale player corpses from database
[10.23. - 13:57:32] [WORLD__INIT] Deleted 0 stale player backups from database
[10.23. - 13:57:32] [WORLD__INIT] Zone (TCP) listener started.
[10.23. - 13:57:32] [WORLD__INIT] Client (UDP) listener started.
[10.23. - 13:57:32] [NET__IDENTIFY] Registered patch 6.2
[10.23. - 13:57:32] [NET__IDENTIFY] Registered patch Titanium
[10.23. - 13:57:32] [NET__IDENTIFY] Registered patch Anniversary
[10.23. - 13:57:32] [NET__IDENTIFY] Registered patch Live
[10.23. - 13:57:32] [WORLD__LS] Connecting to login server...
[10.23. - 13:57:32] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998
[10.23. - 13:57:32] [WORLD__LS] Loginserver provided 87.194.34.223 as world address
[10.23. - 13:57:51] [WORLD__ZONE] New TCP connection from 127.0.0.1:52629
[10.23. - 13:57:51] [WORLD__CONSOLE] New launcher from 127.0.0.1:52629
[10.23. - 13:57:51] [WORLD__LAUNCH] Adding pending launcher 1
[10.23. - 13:57:51] [WORLD__LAUNCH] Launcher Identified itself as 'zone'. Loading zone list.
[10.23. - 13:57:51] [WORLD__LAUNCH] Removing pending launcher 1. Adding zone to active list.
[10.23. - 13:57:56] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (1 starts)
[10.23. - 13:57:58] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (1 starts)
[10.23. - 13:58:16] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (2 starts)
[10.23. - 13:58:18] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (2 starts)
[10.23. - 13:58:36] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (3 starts)
[10.23. - 13:58:38] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (3 starts)
[10.23. - 13:58:56] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (4 starts)
[10.23. - 13:58:58] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (4 starts)
[10.23. - 13:59:16] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (5 starts)
[10.23. - 13:59:18] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (5 starts)
[10.23. - 13:59:36] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (6 starts)
[10.23. - 13:59:38] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (6 starts)
[10.23. - 13:59:56] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (7 starts)
[10.23. - 13:59:58] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (7 starts)
[10.23. - 14:00:16] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (8 starts)
[10.23. - 14:00:18] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (8 starts)
[10.23. - 14:00:36] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (9 starts)
[10.23. - 14:00:38] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (9 starts)
[10.23. - 14:00:56] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (10 starts)
[10.23. - 14:00:58] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (10 starts)
[10.23. - 14:01:01] [WORLD__CLIENT] New connection from 127.0.0.1:55441



[IMG]http://img137.imageshack.us/img137/7788/serverx.jpg[/IMG]

bad_captain 10-23-2010 09:40 AM

[10.23. - 13:57:31] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring
[10.23. - 13:57:58] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (1 starts)

I would assume there are DB updates that need to be run (items aren't loaded), as well as your Zones are crashing every 18 seconds (most likely a DB error as well). Check all sql updates, then try again. Until the zone stops crashing, I don't think anyone will be able to join.

psalm 10-23-2010 10:18 AM

Bad_Captain,

Could you elaborate on how I go about updating?

Sorry for the inconvenience.

psalm 10-23-2010 10:23 AM

Also, I get these errors also, are these also due to requring updates?


[10.23. - 14:57:25] [LAUNCHER__WORLD] World told us to start zone dynamic_01.
[10.23. - 14:57:25] [LAUNCHER__WORLD] World told us to start zone dynamic_02.
[10.23. - 14:57:25] [LAUNCHER__WORLD] World told us to start zone dynamic_03.
[10.23. - 14:57:25] [LAUNCHER__WORLD] World told us to start zone dynamic_04.
[10.23. - 14:57:25] [LAUNCHER__WORLD] World told us to start zone dynamic_05.
[10.23. - 14:57:25] [LAUNCHER__ERROR] World told us to start zone dynamic_01, but it is already running.
[10.23. - 14:57:25] [LAUNCHER__ERROR] World told us to start zone dynamic_02, but it is already running.
[10.23. - 14:57:25] [LAUNCHER__ERROR] World told us to start zone dynamic_03, but it is already running.
[10.23. - 14:57:25] [LAUNCHER__ERROR] World told us to start zone dynamic_04, but it is already running.
[10.23. - 14:57:25] [LAUNCHER__ERROR] World told us to start zone dynamic_05, but it is already running.

joligario 10-23-2010 10:51 AM

Those are normal. Ignore them.

bad_captain 10-23-2010 12:34 PM

What version of the server are you running?
What version of the database are you running?

If you don't know, when/where did you get the binaries, or did you compile yourself? What database file did you run? Did you try to update and now you're getting these errors, or are you setting up for the first time?

In the log you provided, I see: [10.23. - 13:57:31] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0 - If I'm correct, the newest versions say 0.8.0? If so, these binaries are old.

Assuming you want to update your server to the newest build- Back everything up. You don't want to wipe anything out and lose all of your characters! Get the latest build from the svn (Andrew80k uploaded the rev1708 binaries a couple days ago) Then download the latest database (PEQ I assume?) rev-1667 I think. Update the database, then check the server binaries in Utils/sql/svn for any revs later than 1667. You may also want to check the changelog.txt in the server folder for any sql changes not put in it's own script file. Also, if you have accounts and characters already created, you would need to check for any updates for those tables (character_, account, etc.) Some of the guides floating around may help as well.

psalm 10-23-2010 12:57 PM

Bad Captain,


i used the PEQ LoY server pack (http://www.peqtgc.com/downloads.php) which, now looking, is very out of date.

I presume theres no way to run an out of date pack? (the server is only for a few friends).

I'm a little lost with it all, but was following some database update guide on the peq forum, for which I downloaded the peqdb_rev1667 and the quest files. I had replaced the quest files, and am trying to update my mysql database with the new peqdb file, but navicat is bugging out.

The readme for the peqdb states:
Update Setup:

1. Unpack peqdb_Revxxx.sql.gz using winrar, gzip, whatever you use.
2. Source drop_system.sql.
3. Source the new peqdb_Revxxx.sql into your database.
4. Enter the updates folder, read the readme.txt there and be sure to source in any updates since the last time you updated.


But when i get to executing the peqdv.sql in navi, it just seems to time out, it processes 59/59, but stays at 0% and keeps timing (it was at 300seconds typing this)



I'm not sure where to go from here.

bad_captain 10-23-2010 01:11 PM

I assume you could if everything matched up (also depending on the client used to connect), but it's probably best to update. More features, etc. You will also be able to get better help if you're working with the most recent files.

Also, it takes 10-15 minutes on my server to load the PEQ full DB script (granted it's a really old PC) via MySQL Query Browser. I have more luck running the scripts via the command line. The full file is like 150 MB. I'm not sure if navicat can do that, but I assume it does.

psalm 10-23-2010 01:24 PM

Bad Captain,


I'm likely growing annoying now,

but how exactly do I source through the CMD? The only reason I'm using navicat, is because it's GUI and, thus easier for me to grasp :)

bad_captain 10-23-2010 04:20 PM

I assume you're using windows.. Open command prompt. Navigate to mysql bin folder. Mine is C:/Program Files/MySql/MYSQL Server 5.0/bin. Once in that folder type:
mysql -u USERNAME -p peq

substituting your username, and database name if it's not peq. It should prompt for your password. Enter it, then you should be in, with the peq database selected. You can then type source load_system.sql in or the peq_xxx.sql file.

I'm definitely no mysql guru, but that should work. Again, make sure you backup, unless there's no data worth keeping, then it would be best to just wipe everything and start fresh.

Check out http://www.eqemulator.net/wiki/wikka...ka=ws992mysql5 or http://www.eqemulator.net/wiki/wikka.php?wakka=Windows. The sourcing should be much faster that with the GUI. Just switch back after for any other changes if you're more familiar with Navi.

psalm 10-23-2010 04:55 PM

I presume I'm supposed to move the peqdb files (player_tables/updates/drop_player.sql etc. etc. etc.) to where my actual database is?

How do I actually find where my database is located? Because the PEQ server pack created it for me, and I cannot find it anywhere within the mysql folders, or anywhere obvious on c:

is there a command to throw in mysql-cmd to tell me where it is, so i can transfer the files across + source them.

psalm 10-23-2010 05:49 PM

ok, I misunderstood what you said,

sourced now.

bad_captain 10-23-2010 05:57 PM

Good to hear. Now, just update your binaries, and hopefully everything will run fine. If there are more errors, post them, and we may be able to figure out which updates to run. Good luck!

psalm 10-23-2010 06:09 PM

I tried to run it after i sourced all the peqdb files (I'm not sure if I was supposed to source the update folder contents, but did anyway)

The server start failed to find pretty much everything, so I assume I broke it by doing so.

Any ideas?

I'm actually just reinstalling peq server pack, and will start it a fresh.

How do I update the binaris? By binaries, is that the eqmu itself?

psalm 10-23-2010 06:14 PM

Do I source the 'updates' folder in the same dir as peqdb_rev1667.sql ?

or just drop_system/peqdb?

psalm 10-23-2010 06:24 PM

Ok, I just tried running the server. All goes well - made a character etc.

when I load into the world - it just pops up 'zone not available' - I'm happy it's no longer crashing the world.exe, just need to know what to do now :)

psalm 10-23-2010 07:22 PM

Straight up swapping world.exe / zone.exe out for newer versions - presents the error 'The program can't start because perl510.dll is missing from your computer.'

any ideas?

rencro 10-23-2010 07:48 PM

Im not sure you are applying the updates properly. Now there are several methods to update the sqls, but I think first you want to know why you are updating them.. So long boring wall of text explanation follows:

Peq, one of the databases commonly used for the emulator, will hold all the structures required by the core to work properly, as well peq database holds all the spawn/creature info. When peq releases a database, they will label it with a number that relates to the latest core it was made for. As I write this that would be peqdb_rev1667.sql. This means that all the sql for the "core" up to 1667 are applied, as well as any changes peq has for spawns/creatures, ect..

EQemulator is in a constantly evolving state, changes are sometimes made to the way the database and core interact with each other and this will require an sql update to "an existing database", in this case if you applied the peq_rev1667 database, but then decided to update your emulator, or core, to say the latest binary release of 1708, then any sql's numbering above 1667 would need to be applied, unless they state "optional" of course. For this example these would be 1696_modify_zone_and_object_tables.sql as this sql falls between the last version of your peq db, 1667, and the current version of your core, 1708....

To get a better appreciation of the process it would be better to pull the source yourself and recompile whenever a dev releases a new push, which would require an sql update if one was pushed with that version. The reality is most people just use the precompiled binaries, but you should still understand the process nonetheless.

Eventually, peq will update to a newer version, and they will have incorporated all the sql updates that were released between their last db and the new one they are releasing..

rencro 10-23-2010 07:55 PM

Quote:

Originally Posted by psalm (Post 193586)
Straight up swapping world.exe / zone.exe out for newer versions - presents the error 'The program can't start because perl510.dll is missing from your computer.'

any ideas?

You have an old version of perl installed on your machine, more than likely when you installed the all-in-one server from earlier it installed what was then needed..

Also straight up swapping should not be done, use all the files from the current binary release, to a new directory, if you were not planning on deleting your old one....

psalm 10-23-2010 07:59 PM

.
 
Thanks for posting Rencro,

I admit, I am alittle beyond my depth here heh, but I feel it's slowly coming together.

I just uninstalled perl, and reinstalled perl 5.10 - which resolved my last error.

I no longer get the 'zone is not available' pop up ingame at char select, but now when i enter the worl, i am presented with the 'YOU HAVE BEEN DISCONECTED!' black screen.


Any ideas?

psalm 10-23-2010 08:17 PM

Quote:

Originally Posted by rencro (Post 193588)
Also straight up swapping should not be done, use all the files from the current binary release, to a new directory, if you were not planning on deleting your old one....

Ok, I am running 1708 now, with all the relevant files, in a new folder.

The World/Zone seems to be working fine, however, EQEmu Login Server crashes on startup (from startup bat)

Using Port: 5999
Dumping Inbound packets.
Dumping Outbound packets.
Database Server: localhost
Database Catalog: eqdb -- is that correct?
Database Username: equser
Database Password: equser

MYSQL CONNECT FAILED:
localhost
equser
equser
eqdb
Query failed:





So I think I need to change those fields to root/password and peq, respectively?

But where?

rencro 10-23-2010 08:34 PM

Make sure you have your config files set up, thats where you will be setting username/password and database settings used..Refer to your old config files for guidance since it seemed you were past this step on previous setup..

psalm 10-23-2010 08:46 PM

Checked my config, matches my previous one.

Still getting the 'YOU HAVE BEEN DISCONNECTED!' message upon hitting enter world at char select.

I've made the zone (kaladima) that the specific char is entering static, but to no avail.


Here is my config.


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

<!-- address has to be specified for minilogin to work -->
<address>127.0.0.1</address>
<localaddress>127.0.0.1</localaddress>

<!-- Loginserver information. -->
<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>make up some random string of characters here</key>

<!-- Enable and set the port for the HTTP service -->
<http port="9080" enable="true" mimefile="mime.types"/>
</world>

<!-- Database configuration, replaces db.ini -->
<database>
<host>localhost</host>
<port>3306</port>
<username>eq</username>
<password>eq</password>
<db>peq</db>
</database>
</server>

psalm 10-23-2010 09:11 PM

I presume the below is whats causing the disconnect, as it seems to no be able to find the character. I tried creating a new char, and logging straight in, but had the same problem.

Quote:

World.exe

[Error] in AdventureManager:::GetLeaderboardInfo: Select ch.name, ch.id, adv_stats.* from adventure_stats AS adv_stats left join character_ AS ch on adv_stats.player_id = ch.id; (#1146: Table 'peq.adventure_stats' doesn't exist)
Error in GetCharacterInfo query 'SELECT id, account_id, zonename, instanceid, x, y, z, FROM character_ WHERE name='Gold'' #1054: Unknown column 'instanceid' in field list'

[debug] [WORLD_CLIENT_ERR] mini: Could not get CharInfo for 'Gold'
[debug] [WORLD_CLIENT] mini: Client disconnected (not active in process)

rencro 10-23-2010 09:45 PM

Ok,,,,,,, so you are still using your old player tables from the old install and you did not drop_players when you upgraded peq..

You would'nt want to drop the players if you wanted to preserve existing characters, but I'm thinking in your case there prob arent many existing chars, so best thing is to drop world and players on yor peq db, and install it again, as well as the updated sql 1696..

You could preserve your chars if you wanted, but you would need to apply any sql's that modified those tables from when your db was initially made.

rencro 10-23-2010 09:59 PM

Take a read here for basic info on db

http://www.peqtgc.com/phpBB2/viewtopic.php?t=7112

psalm 10-23-2010 10:00 PM

Rencro,

I'm going to run a fresh install.

I really appreciate your tolerance :)

rencro 10-23-2010 10:08 PM

Np, when you get this going and having your own world to play in, it "almost" brings back that feeling of playing eq for the first time...

psalm 10-23-2010 10:35 PM

Yea, I bet!


I've reinstalled - ran system/players/rev .sql

replaced the quest files

and am running from the new binaries.


I no longer see any server in server select.

World.exe is spamming me with -
Error 'DBAsyncCB_LoadVariables failed !GetAnswer: '#1146: Table 'peq.variables doesn't exist'

rencro 10-23-2010 11:09 PM

Not sure if you are following a guide but give this thread a good look through, focus on the db parts (phase3)..

http://www.eqemulator.org/forums/showthread.php?t=31783

Are you a navicat user, or do you use mysql command line? Are you comfortable with command line?

psalm 10-23-2010 11:20 PM

I've tried both my actual ip and 127.0.0.1, just wont present a server at server select.




Quote:

[10.23. - 20:10:34] Starting Log: logs/eqemu_debug_world_2656.log
[10.23. - 20:10:34] [WORLD__INIT] Loading server configuration..
[10.23. - 20:10:34] [WORLD__INIT] Log settings loaded from log.ini
[10.23. - 20:10:34] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEmulator 0.8.0
[10.23. - 20:10:34] [WORLD__INIT] Added loginserver 127.0.0.1:5999
[10.23. - 20:10:34] [WORLD__INIT] Connecting to MySQL...
[10.23. - 20:10:34] [WORLD__INIT] Starting HTTP world service...
[10.23. - 20:10:34] [WORLD__HTTP] Loaded mime types from mime.types
[10.23. - 20:10:34] [WORLD__INIT] Loading variables..
[10.23. - 20:10:34] [WORLD__INIT] Loading zones..
[10.23. - 20:10:34] [WORLD__INIT] Clearing groups..
[10.23. - 20:10:34] [WORLD__INIT] Clearing raids..
[10.23. - 20:10:34] [WORLD__INIT] Loading items..
[10.23. - 20:10:39] [WORLD__INIT] Loading guilds..
[10.23. - 20:10:39] [GUILDS__ERROR] Error loading guilds 'SELECT id, name, leader, minstatus, motd, motd_setter,channel,url FROM guilds': #1146: Table 'peq.guilds' doesn't exist
[10.23. - 20:10:39] [WORLD__INIT] No rule set configured, using default rules
[10.23. - 20:10:39] [WORLD__INIT] Clearing temporary merchant lists..
[10.23. - 20:10:39] [WORLD__INIT] Loading EQ time of day..
[10.23. - 20:10:39] [WORLD__INIT] Loading launcher list..
[10.23. - 20:10:39] [WORLD__INIT] Reboot zone modes OFF
[10.23. - 20:10:39] [WORLD__INIT] Deleted -1 stale player corpses from database
[10.23. - 20:10:39] [WORLD__INIT] Deleted -1 stale player backups from database
[10.23. - 20:10:39] [WORLD__INIT] Loading adventures...
[10.23. - 20:10:39] [WORLD__INIT] Purging expired instances
[10.23. - 20:10:39] [WORLD__INIT] Zone (TCP) listener started.
[10.23. - 20:10:39] [WORLD__INIT] Client (UDP) listener started.
[10.23. - 20:10:39] [NET__IDENTIFY] Registered patch 6.2
[10.23. - 20:10:39] [NET__IDENTIFY] Registered patch Titanium
[10.23. - 20:10:39] [NET__IDENTIFY] Registered patch SoF
[10.23. - 20:10:39] [NET__IDENTIFY] Registered patch SoD
[10.23. - 20:10:39] [NET__IDENTIFY] Registered patch Live
[10.23. - 20:10:39] [WORLD__LS] Connecting to login server: 127.0.0.1:5999
[10.23. - 20:10:39] [WORLD__LS] Connected to Loginserver: 127.0.0.1:5999
[10.23. - 20:10:54] [WORLD__ZONE] New TCP connection from 127.0.0.1:54799
[10.23. - 20:10:54] [WORLD__CONSOLE] New launcher from 127.0.0.1:54799
[10.23. - 20:10:54] [WORLD__LAUNCH] Adding pending launcher 1
[10.23. - 20:10:54] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:10:54] [WORLD__LAUNCH] Removing pending launcher 1. Adding zone to active list.
[10.23. - 20:10:54] [WORLD__LAUNCH] Removing launcher zone (1)
[10.23. - 20:11:04] [WORLD__ZONE] New TCP connection from 127.0.0.1:54800
[10.23. - 20:11:04] [WORLD__CONSOLE] New launcher from 127.0.0.1:54800
[10.23. - 20:11:04] [WORLD__LAUNCH] Adding pending launcher 2
[10.23. - 20:11:09] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:11:09] [WORLD__LAUNCH] Removing pending launcher 2. Adding zone to active list.
[10.23. - 20:11:09] [WORLD__LAUNCH] Removing launcher zone (2)
[10.23. - 20:11:14] [WORLD__ZONE] New TCP connection from 127.0.0.1:54801
[10.23. - 20:11:14] [WORLD__CONSOLE] New launcher from 127.0.0.1:54801
[10.23. - 20:11:14] [WORLD__LAUNCH] Adding pending launcher 3
[10.23. - 20:11:19] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:11:19] [WORLD__LAUNCH] Removing pending launcher 3. Adding zone to active list.
[10.23. - 20:11:19] [WORLD__LAUNCH] Removing launcher zone (3)
[10.23. - 20:11:24] [WORLD__ZONE] New TCP connection from 127.0.0.1:54803
[10.23. - 20:11:24] [WORLD__CONSOLE] New launcher from 127.0.0.1:54803
[10.23. - 20:11:24] [WORLD__LAUNCH] Adding pending launcher 4
[10.23. - 20:11:29] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:11:29] [WORLD__LAUNCH] Removing pending launcher 4. Adding zone to active list.
[10.23. - 20:11:29] [WORLD__LAUNCH] Removing launcher zone (4)
[10.23. - 20:11:34] [WORLD__ZONE] New TCP connection from 127.0.0.1:54804
[10.23. - 20:11:34] [WORLD__CONSOLE] New launcher from 127.0.0.1:54804
[10.23. - 20:11:34] [WORLD__LAUNCH] Adding pending launcher 5
[10.23. - 20:11:39] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:11:39] [WORLD__LAUNCH] Removing pending launcher 5. Adding zone to active list.
[10.23. - 20:11:39] [WORLD__LAUNCH] Removing launcher zone (5)
[10.23. - 20:11:44] [WORLD__ZONE] New TCP connection from 127.0.0.1:54807
[10.23. - 20:11:44] [WORLD__CONSOLE] New launcher from 127.0.0.1:54807
[10.23. - 20:11:44] [WORLD__LAUNCH] Adding pending launcher 6
[10.23. - 20:11:49] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:11:49] [WORLD__LAUNCH] Removing pending launcher 6. Adding zone to active list.
[10.23. - 20:11:49] [WORLD__LAUNCH] Removing launcher zone (6)
[10.23. - 20:11:54] [WORLD__ZONE] New TCP connection from 127.0.0.1:54818
[10.23. - 20:11:54] [WORLD__CONSOLE] New launcher from 127.0.0.1:54818
[10.23. - 20:11:54] [WORLD__LAUNCH] Adding pending launcher 7
[10.23. - 20:11:59] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:11:59] [WORLD__LAUNCH] Removing pending launcher 7. Adding zone to active list.
[10.23. - 20:11:59] [WORLD__LAUNCH] Removing launcher zone (7)
[10.23. - 20:12:04] [WORLD__ZONE] New TCP connection from 127.0.0.1:54819
[10.23. - 20:12:04] [WORLD__CONSOLE] New launcher from 127.0.0.1:54819
[10.23. - 20:12:04] [WORLD__LAUNCH] Adding pending launcher 8
[10.23. - 20:12:09] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:12:09] [WORLD__LAUNCH] Removing pending launcher 8. Adding zone to active list.
[10.23. - 20:12:09] [WORLD__LAUNCH] Removing launcher zone (8)
[10.23. - 20:12:14] [WORLD__ZONE] New TCP connection from 127.0.0.1:54820
[10.23. - 20:12:14] [WORLD__CONSOLE] New launcher from 127.0.0.1:54820
[10.23. - 20:12:14] [WORLD__LAUNCH] Adding pending launcher 9
[10.23. - 20:12:19] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:12:19] [WORLD__LAUNCH] Removing pending launcher 9. Adding zone to active list.
[10.23. - 20:12:19] [WORLD__LAUNCH] Removing launcher zone (9)
[10.23. - 20:12:24] [WORLD__ZONE] New TCP connection from 127.0.0.1:54821
[10.23. - 20:12:24] [WORLD__CONSOLE] New launcher from 127.0.0.1:54821
[10.23. - 20:12:24] [WORLD__LAUNCH] Adding pending launcher 10
[10.23. - 20:12:29] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:12:29] [WORLD__LAUNCH] Removing pending launcher 10. Adding zone to active list.
[10.23. - 20:12:29] [WORLD__LAUNCH] Removing launcher zone (10)
[10.23. - 20:12:34] [WORLD__ZONE] New TCP connection from 127.0.0.1:54822
[10.23. - 20:12:34] [WORLD__CONSOLE] New launcher from 127.0.0.1:54822
[10.23. - 20:12:34] [WORLD__LAUNCH] Adding pending launcher 11
[10.23. - 20:12:39] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:12:39] [WORLD__LAUNCH] Removing pending launcher 11. Adding zone to active list.
[10.23. - 20:12:39] [WORLD__LAUNCH] Removing launcher zone (11)
[10.23. - 20:12:44] [WORLD__ZONE] New TCP connection from 127.0.0.1:54823
[10.23. - 20:12:44] [WORLD__CONSOLE] New launcher from 127.0.0.1:54823
[10.23. - 20:12:44] [WORLD__LAUNCH] Adding pending launcher 12
[10.23. - 20:12:49] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:12:49] [WORLD__LAUNCH] Removing pending launcher 12. Adding zone to active list.
[10.23. - 20:12:49] [WORLD__LAUNCH] Removing launcher zone (12)
[10.23. - 20:12:54] [WORLD__ZONE] New TCP connection from 127.0.0.1:54825
[10.23. - 20:12:54] [WORLD__CONSOLE] New launcher from 127.0.0.1:54825
[10.23. - 20:12:54] [WORLD__LAUNCH] Adding pending launcher 13
[10.23. - 20:12:59] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:12:59] [WORLD__LAUNCH] Removing pending launcher 13. Adding zone to active list.
[10.23. - 20:12:59] [WORLD__LAUNCH] Removing launcher zone (13)
[10.23. - 20:13:04] [WORLD__ZONE] New TCP connection from 127.0.0.1:54827
[10.23. - 20:13:04] [WORLD__CONSOLE] New launcher from 127.0.0.1:54827
[10.23. - 20:13:04] [WORLD__LAUNCH] Adding pending launcher 14
[10.23. - 20:13:09] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:13:09] [WORLD__LAUNCH] Removing pending launcher 14. Adding zone to active list.
[10.23. - 20:13:09] [WORLD__LAUNCH] Removing launcher zone (14)
[10.23. - 20:13:14] [WORLD__ZONE] New TCP connection from 127.0.0.1:54926
[10.23. - 20:13:14] [WORLD__CONSOLE] New launcher from 127.0.0.1:54926
[10.23. - 20:13:14] [WORLD__LAUNCH] Adding pending launcher 15
[10.23. - 20:13:20] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:13:20] [WORLD__LAUNCH] Removing pending launcher 15. Adding zone to active list.
[10.23. - 20:13:20] [WORLD__LAUNCH] Removing launcher zone (15)
[10.23. - 20:13:25] [WORLD__ZONE] New TCP connection from 127.0.0.1:54929
[10.23. - 20:13:25] [WORLD__CONSOLE] New launcher from 127.0.0.1:54929
[10.23. - 20:13:25] [WORLD__LAUNCH] Adding pending launcher 16
[10.23. - 20:13:29] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:13:29] [WORLD__LAUNCH] Removing pending launcher 16. Adding zone to active list.
[10.23. - 20:13:29] [WORLD__LAUNCH] Removing launcher zone (16)
[10.23. - 20:13:34] [WORLD__ZONE] New TCP connection from 127.0.0.1:54930
[10.23. - 20:13:34] [WORLD__CONSOLE] New launcher from 127.0.0.1:54930
[10.23. - 20:13:34] [WORLD__LAUNCH] Adding pending launcher 17
[10.23. - 20:13:39] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:13:39] [WORLD__LAUNCH] Removing pending launcher 17. Adding zone to active list.
[10.23. - 20:13:39] [WORLD__LAUNCH] Removing launcher zone (17)
[10.23. - 20:13:45] [WORLD__ZONE] New TCP connection from 127.0.0.1:54931
[10.23. - 20:13:45] [WORLD__CONSOLE] New launcher from 127.0.0.1:54931
[10.23. - 20:13:45] [WORLD__LAUNCH] Adding pending launcher 18
[10.23. - 20:13:50] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:13:50] [WORLD__LAUNCH] Removing pending launcher 18. Adding zone to active list.
[10.23. - 20:13:50] [WORLD__LAUNCH] Removing launcher zone (18)
[10.23. - 20:13:55] [WORLD__ZONE] New TCP connection from 127.0.0.1:54932
[10.23. - 20:13:55] [WORLD__CONSOLE] New launcher from 127.0.0.1:54932
[10.23. - 20:13:55] [WORLD__LAUNCH] Adding pending launcher 19
[10.23. - 20:14:00] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[10.23. - 20:14:00] [WORLD__LAUNCH] Removing pending launcher 19. Adding zone to active list.
[10.23. - 20:14:00] [WORLD__LAUNCH] Removing launcher zone (19)
Quote:

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

<!-- Only specify these two if you really think you need to. -->
<address>87.194.34.223</address>
<localaddress>127.0.0.1</localaddress>

<!-- Loginserver information. -->
<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>

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

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

Quote:

###Your current configuration is as follows:

loginserver.ini:
[LoginServer]
loginserver=127.0.0.1
loginport=5999
worldname=My Minilogin
worldaddress=87.194.34.223
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=
[ChatChannelServer]

worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=Minilogin
ServerPort=5999


psalm 10-23-2010 11:21 PM

I have navi, but it seems slow, I'm generally using cmd

psalm 10-23-2010 11:23 PM

I'm actually using the PEQ self installaton thing, then updating that through source.

I'm not really following a guide.


All times are GMT -4. The time now is 03:27 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.