Setting up server. MYSQL Is messed up

[Astaldoath]

Ok dont ask me how but some how mysql is messed up. It will not allow me to change the root password. When I sourced my peq database It give me a few warnings, no errors. I followed the guide exactly, its my 3rd re install trying to get it to work. It worked the first time but I dropped my database in navicat because tables were missing data. Now my server cannot connect to the database. Please help me, im not a noob ive done this before with a different guide about 1 year ago. Thanks

Error btw

---------------------------------------------
[01.24. - 03:07:00] Starting Log: logs/eqemu_error_zone_3876.log
[01.24. - 03:07:00] Failed to connect to database: Error: #1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

I am using the MYSQL 5.0.45

[sesmar]

Error btw

---------------------------------------------
[01.24. - 03:07:00] Starting Log: logs/eqemu_error_zone_3876.log
[01.24. - 03:07:00] Failed to connect to database: Error: #1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

I am using the MYSQL 5.0.45

I am not sure what version of MySql the precompiled binaries are compiled against but I believe that it is still MySql 4.x not 5 so that would be the reason for the error you are getting here. You can either start using MySql 4.x or compile your own binaries against your version of MySql.

[Angelox]

Might need to run something like this ;
SET PASSWORD FOR 'eq'@'localhost' = OLD_PASSWORD('newpwd');

This will enable password compatibility for 5x with the old 4x binaries

[Astaldoath]

ahh, so should I actually use mysql 4.whatever not 5, ive had nothing but trouble trying to use 5 but thats what the new guide says. If so what version of perl should I get?

[Astaldoath]

If someone can help me get this running correctly im gonna edit the wikki. The guide now does not work and thats probably why everyone is having so many problems. I would love to get a hold of techguy

[Astaldoath]

Might need to run something like this ;
SET PASSWORD FOR 'eq'@'localhost' = OLD_PASSWORD('newpwd');

This will enable password compatibility for 5x with the old 4x binaries

so angelox should I be using 5.0.45 or 4.xxx. I saw you congradulated that guy on the guide so it must be working right?

[Xgen]

If someone can help me get this running correctly im gonna edit the wikki. The guide now does not work and thats probably why everyone is having so many problems. I would love to get a hold of techguy

The pdf guide? It worked just fine for me a few days ago using mysql 5.x

[Astaldoath]

The pdf guide? It worked just fine for me a few days ago using mysql 5.x

did you use 5.0.45 or 5.0.37, It works for me with 37 not 45. Im back to square one. Where are the variables in the database located now :( not in variables.sql ruletables or rule sets :( This was my whole problem in the beginning, now I cannot set my xp motd ect.... Not sure if the version of PEQ i got is messed up or what

[Angelox]

Most of us use 5x, There's no big problem with 5x, void the password fix which is easy too.
You can probably get quicker answers to your questions using the search feature on these forums.

[Astaldoath]

I did search around. I didnt find any relevent answers. 99% of the thread ended with the user fixing his own problem and no actual fix posted

[Astaldoath]

So my zone.exe keeps crashing here is my log file (windows wont let me delete it either lol)

---------------------------------------------
[01.24. - 13:51:56] Starting Log: logs/eqemu_debug_zone_3844.log
[01.24. - 13:51:56] [ZONE__INIT] Loading server configuration..
[01.24. - 13:51:56] [ZONE__INIT] Log settings loaded from log.ini
[01.24. - 13:51:56] [ZONE__INIT] Connecting to MySQL...
[01.24. - 13:51:56] [ZONE__INIT] CURRENT_ZONE_VERSION: EQEMu 0.7.0
[01.24. - 13:51:56] [ZONE__INIT] Log settings loaded from ./log.ini
[01.24. - 13:51:56] [ZONE__INIT] Mapping Incoming Opcodes
[01.24. - 13:51:56] [ZONE__INIT] Loading Variables
[01.24. - 13:51:56] [ZONE__INIT] Loading zone names
[01.24. - 13:51:56] [ZONE__INIT] Loading items
[01.24. - 13:51:57] [ZONE__INIT] Loading npc faction lists
[01.24. - 13:51:57] [ZONE__INIT] Loading loot tables
[01.24. - 13:52:28] [ZONE__INIT] Loading skill caps
[01.24. - 13:52:28] [ZONE__INIT] Loading guilds
[01.24. - 13:52:28] [ZONE__INIT] Loading factions
[01.24. - 13:52:28] [ZONE__INIT] Loading titles
[01.24. - 13:52:28] [ZONE__INIT] Loading AA effects
[01.24. - 13:52:28] [ZONE__INIT] Loading tributes
[01.24. - 13:52:29] [ZONE__INIT] Loading corpse timers
[01.24. - 13:52:29] [ZONE__INIT] Loading commands
[01.24. - 13:52:29] [ZONE__INIT] 198 commands loaded
[01.24. - 13:52:29] [RULES__ERROR] Failed to find ruleset 'default' for load operation. Canceling.
[01.24. - 13:52:29] [ZONE__INIT] No rule set configured, using default rules
[01.24. - 13:52:29] [ZONE__INIT] Loading embedded perl XS
[01.24. - 13:52:29] [ZONE__INIT] Loading quests
[01.24. - 13:52:29] [ZONE__INIT] Entering sleep mode
[01.24. - 13:52:29] [NET__IDENTIFY] Registered patch 6.2
[01.24. - 13:52:29] [NET__IDENTIFY] Registered patch Titanium
[01.24. - 13:52:29] [NET__IDENTIFY] Registered patch Anniversary
[01.24. - 13:52:29] [NET__IDENTIFY] Registered patch Live
[01.24. - 13:52:29] [NET__WORLD] Connected to World: 127.0.0.1:9000
[01.24. - 13:52:29] [ZONE__WORLD] World indicated port 7002 for this zone.
[01.24. - 13:52:29] [ZONE__INIT] Starting EQ Network server on port 7002
[01.24. - 13:53:05] The next weather check for zone: freportw will be in 8224 seconds.
[01.24. - 13:53:10] Zone: freportw has weather of type 1.
[01.24. - 13:53:10] Zone: freportw(9) has weather type = 1. The weather timer has been enabled.
[01.24. - 13:53:10] [WORLD__CLIENT] New connection from 70.16.83.109:1661
[01.24. - 13:53:11] [NET__IDENT_TRACE] 70.16.83.109:1661: First opcode 0x7752 did not match expected 0x2792
[01.24. - 13:53:11] [NET__IDENT_TRACE] 70.16.83.109:1661: Tried patch 6.2_world, and it did not match.
[01.24. - 13:53:11] [NET__IDENT_TRACE] 70.16.83.109:1661: First opcode 0x7213 did not match expected 0x2ec9
[01.24. - 13:53:11] [NET__IDENT_TRACE] 70.16.83.109:1661: Tried patch 6.2_zone, and it did not match.
[01.24. - 13:53:11] [NET__IDENT_TRACE] 70.16.83.109:1661: First opcode 0x7752 did not match expected 0x4dd0
[01.24. - 13:53:11] [NET__IDENT_TRACE] 70.16.83.109:1661: Tried patch Titanium_world, and it did not match.
[01.24. - 13:53:11] [NET__IDENT_TRACE] 70.16.83.109:1661: First opcode matched 0x7213 and length matched 68
[01.24. - 13:53:11] [NET__IDENTIFY] Identified stream 70.16.83.109:1661 with signature Titanium_zone
[01.24. - 13:53:11] [WORLD__CLIENT] New client from 70.16.83.109:1661
---------------------------------------------
[01.24. - 13:52:29] Starting Log: logs/eqemu_quest_zone_3844.log
[01.24. - 13:52:29] Tying perl output to eqemu logs
[01.24. - 13:52:29] Creating EQEmuIO=HASH(0x11364bc)
[01.24. - 13:52:29] Creating EQEmuIO=HASH(0x1143038)
[01.24. - 13:52:29] Loading perlemb plugins.
[01.24. - 13:52:29] Loading perl commands...
[01.24. - 13:53:13] Argument "spar2" isn't numeric in numeric eq (==) at quests/freportw/Thena_Lonnes.pl line 23.
[01.24. - 13:53:13] Use of uninitialized value in numeric eq (==) at quests/freportw/Thena_Lonnes.pl line 23.
[01.24. - 13:53:14] Argument "spar1" isn't numeric in numeric eq (==) at quests/freportw/Ran-un.pl line 24.
[01.24. - 13:53:14] Use of uninitialized value in numeric eq (==) at quests/freportw/Ran-un.pl line 24.
[01.24. - 13:53:16] Use of uninitialized value in numeric eq (==) at quests/freportw/Thena_Lonnes.pl line 23.
[01.24. - 13:53:18] Use of uninitialized value in numeric eq (==) at quests/freportw/Ran-un.pl line 24.
[01.24. - 13:53:19] Use of uninitialized value in numeric eq (==) at quests/freportw/Thena_Lonnes.pl line 23.
[01.24. - 13:53:22] Use of uninitialized value in numeric eq (==) at quests/freportw/Thena_Lonnes.pl line 23.
[01.24. - 13:53:22] Use of uninitialized value in numeric eq (==) at quests/freportw/Ran-un.pl line 24.
[01.24. - 13:53:25] Use of uninitialized value in numeric eq (==) at quests/freportw/Thena_Lonnes.pl line 23.
[01.24. - 13:53:27] Use of uninitialized value in numeric eq (==) at quests/freportw/Ran-un.pl line 24.
[01.24. - 13:53:29] Use of uninitialized value in numeric eq (==) at quests/freportw/Thena_Lonnes.pl line 23.
[01.24. - 13:53:31] Use of uninitialized value in numeric eq (==) at quests/freportw/Ran-un.pl line 24.
[01.24. - 13:53:32] Use of uninitialized value in numeric eq (==) at quests/freportw/Thena_Lonnes.pl line 23.
[01.24. - 13:53:35] Use of uninitialized value in numeric eq (==) at quests/freportw/Thena_Lonnes.pl line 23.
[01.24. - 13:53:35] Use of uninitialized value in numeric eq (==) at quests/freportw/Ran-un.pl line 24.
[01.24. - 13:53:38] Use of uninitialized value in numeric eq (==) at quests/freportw/Thena_Lonnes.pl line 23.
[01.24. - 13:53:39] Use of uninitialized value in numeric eq (==) at quests/freportw/Ran-un.pl line 24.
[01.24. - 13:54:14] Terminating on signal SIGHUP(1)



So yeah im gonna drop my database and try resourcing with a new download. Hope this helps. All my installs seem to be ok. I did the SQL updates in the change log also, not sure if I did them correctly. I got some errors lol

[Xgen]

did you use 5.0.45 or 5.0.37, It works for me with 37 not 45. Im back to square one. Where are the variables in the database located now :( not in variables.sql ruletables or rule sets :( This was my whole problem in the beginning, now I cannot set my xp motd ect.... Not sure if the version of PEQ i got is messed up or what


Ah, your using PEQ, I did the setup using the Angelox database.

[Astaldoath]

yeah, i reinstalled windows and im downloading the database via CVS so we will see what happens now

[Angelox]

If you use AX_CLASSIC for the first time, then you need to install the full version, then update with the latest "core update" so you get all the newest sql fixes.

[Astaldoath]

Ok I finished reformatting and re installing. Everything is working except zone.exe is crashing. Im gonna get the log file and past here. I am using PEQ database also. So any help will be greatly appreciated. I will search the forums for the answer in the mean time.

[Astaldoath]

Ok there are no errors in the log file as far as I can tell so ill post it here.
World

---------------------------------------------
[01.24. - 17:02:27] Starting Log: logs/eqemu_debug_world_0248.log
[01.24. - 17:02:27] [WORLD__INIT] Loading server configuration..
[01.24. - 17:02:27] [WORLD__INIT] Log settings loaded from log.ini
[01.24. - 17:02:27] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[01.24. - 17:02:27] [WORLD__INIT] Connecting to MySQL...
[01.24. - 17:02:27] [WORLD__INIT] Starting HTTP world service...
[01.24. - 17:02:27] [WORLD__HTTP] Loaded mime types from mime.types
[01.24. - 17:02:27] [WORLD__INIT] Loading variables..
[01.24. - 17:02:27] [WORLD__INIT] Loading zones..
[01.24. - 17:02:27] [WORLD__INIT] Clearing groups..
[01.24. - 17:02:27] [WORLD__INIT] Clearing temporary merchant lists..
[01.24. - 17:02:27] [WORLD__INIT] Loading items..
[01.24. - 17:02:33] [WORLD__INIT] Loading guilds..
[01.24. - 17:02:33] [RULES__CHANGE] Loading rule set 'default' (1)
[01.24. - 17:02:33] [WORLD__INIT] Loaded default rule set 'default'
[01.24. - 17:02:33] [WORLD__INIT] Loading EQ time of day..
[01.24. - 17:02:33] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[01.24. - 17:02:33] [WORLD__INIT] Loading launcher list..
[01.24. - 17:02:33] [WORLD__INIT] Reboot zone modes OFF
[01.24. - 17:02:33] [WORLD__INIT] Deleted 0 stale player corpses from database
[01.24. - 17:02:33] [WORLD__INIT] Deleted 0 stale player backups from database
[01.24. - 17:02:33] [WORLD__INIT] Zone (TCP) listener started.
[01.24. - 17:02:33] [WORLD__INIT] Client (UDP) listener started.
[01.24. - 17:02:33] [NET__IDENTIFY] Registered patch 6.2
[01.24. - 17:02:33] [NET__IDENTIFY] Registered patch Titanium
[01.24. - 17:02:33] [NET__IDENTIFY] Registered patch Anniversary
[01.24. - 17:02:33] [NET__IDENTIFY] Registered patch Live
[01.24. - 17:02:33] [WORLD__LS] Connecting to login server...
[01.24. - 17:02:33] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998
[01.24. - 17:02:33] [WORLD__LS] Loginserver provided 70.16.83.109 as world address
[01.24. - 17:04:10] [WORLD__ZONE] New TCP connection from 127.0.0.1:1797
[01.24. - 17:04:10] [WORLD__CONSOLE] New launcher from 127.0.0.1:1797
[01.24. - 17:04:10] [WORLD__LAUNCH] Adding pending launcher 1
[01.24. - 17:04:10] [WORLD__LAUNCH] Launcher Identified itself as 'zone'. Loading zone list.
[01.24. - 17:04:10] [WORLD__LAUNCH] Removing pending launcher 1. Adding zone to active list.
[01.24. - 17:04:15] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (1 starts)
[01.24. - 17:04:37] [WORLD__LAUNCH] zone: dynamic_02 reported state STARTED (1 starts)
[01.24. - 17:04:40] [WORLD__LAUNCH] zone: dynamic_03 reported state STARTED (1 starts)
[01.24. - 17:04:43] [WORLD__LAUNCH] zone: dynamic_04 reported state STARTED (1 starts)
[01.24. - 17:04:45] [WORLD__LAUNCH] zone: dynamic_05 reported state STARTED (1 starts)
[01.24. - 17:04:46] [WORLD__ZONE] New TCP connection from 127.0.0.1:1805
[01.24. - 17:04:46] [WORLD__ZONE] New TCP connection from 127.0.0.1:1806
[01.24. - 17:04:46] [WORLD__CONSOLE] New zoneserver #1 from 127.0.0.1:1806
[01.24. - 17:04:46] [WORLD__CONSOLE] New zoneserver #2 from 127.0.0.1:1805
[01.24. - 17:04:46] [WORLD__ZONE] [2] Zone started with name dynamic_01 by launcher zone
[01.24. - 17:04:46] [WORLD__ZONE] [2] Auto zone port configuration. Telling zone to use port 7000
[01.24. - 17:04:46] [WORLD__ZONE] [1] Zone started with name dynamic_03 by launcher zone
[01.24. - 17:04:46] [WORLD__ZONE] [1] Auto zone port configuration. Telling zone to use port 7001
[01.24. - 17:04:46] [WORLD__ZONE] New TCP connection from 127.0.0.1:1807
[01.24. - 17:04:46] [WORLD__ZONE] New TCP connection from 127.0.0.1:1808
[01.24. - 17:04:46] [WORLD__CONSOLE] New zoneserver #3 from 127.0.0.1:1808
[01.24. - 17:04:46] [WORLD__CONSOLE] New zoneserver #4 from 127.0.0.1:1807
[01.24. - 17:04:46] [WORLD__ZONE] [4] Zone started with name dynamic_02 by launcher zone
[01.24. - 17:04:47] [WORLD__ZONE] [4] Auto zone port configuration. Telling zone to use port 7002
[01.24. - 17:04:47] [WORLD__ZONE] [3] Zone started with name dynamic_04 by launcher zone
[01.24. - 17:04:47] [WORLD__ZONE] [3] Auto zone port configuration. Telling zone to use port 7003
[01.24. - 17:04:47] [WORLD__ZONE] New TCP connection from 127.0.0.1:1809
[01.24. - 17:04:47] [WORLD__CONSOLE] New zoneserver #5 from 127.0.0.1:1809
[01.24. - 17:04:47] [WORLD__ZONE] [5] Zone started with name dynamic_05 by launcher zone
[01.24. - 17:04:47] [WORLD__ZONE] [5] Auto zone port configuration. Telling zone to use port 7004
[01.24. - 17:05:25] [WORLD__CLIENT] New connection from 70.16.83.109:1811
[01.24. - 17:05:25] [NET__IDENT_TRACE] 70.16.83.109:1811: First opcode 0x4dd0 did not match expected 0x2792
[01.24. - 17:05:25] [NET__IDENT_TRACE] 70.16.83.109:1811: Tried patch 6.2_world, and it did not match.
[01.24. - 17:05:25] [NET__IDENT_TRACE] 70.16.83.109:1811: First opcode 0x4dd0 did not match expected 0x2ec9
[01.24. - 17:05:25] [NET__IDENT_TRACE] 70.16.83.109:1811: Tried patch 6.2_zone, and it did not match.
[01.24. - 17:05:25] [NET__IDENT_TRACE] 70.16.83.109:1811: First opcode matched 0x4dd0 and length matched 464
[01.24. - 17:05:25] [NET__IDENTIFY] Identified stream 70.16.83.109:1811 with signature Titanium_world
[01.24. - 17:05:25] [WORLD__CLIENT] New client from 70.16.83.109:1811
[01.24. - 17:05:25] [WORLD__CLIENT] Astaldoath: Logged in. Mode=(CharSel)
[01.24. - 17:05:25] [WORLD__CLIENT] Astaldoath: LS Account #81707
[01.24. - 17:06:06] [WORLD__CLIENT] Astaldoath: Attempting autobootup of neriakb (41)
[01.24. - 17:06:07] [WORLD__ZONE] [5] Setting to 'neriakb' (41)
[01.24. - 17:06:07] [WORLD__CLIENT] Astaldoath: Entering zone neriakb (41)
[01.24. - 17:06:07] [WORLD__ZONE] [5] [neriakb] Broadcasting a world time update
[01.24. - 17:06:07] [WORLD__ZONE] [5] [neriakb] Setting to 'neriakb' (41)
[01.24. - 17:06:07] [WORLD__CLIENT] Astaldoath: Sending client to zone neriakb (41) at 70.16.83.109:7004
[01.24. - 17:06:07] [WORLD__CLIENT] Astaldoath: Client disconnected (not active in process)
[01.24. - 17:07:06] [WORLD__ZONELIST] Removing zoneserver #5 at :7004
[01.24. - 17:07:07] [WORLD__LAUNCH] zone: dynamic_05 reported state STOPPED (1 starts)
[01.24. - 17:07:17] [WORLD__LAUNCH] zone: dynamic_05 reported state STARTED (2 starts)
[01.24. - 17:07:18] [WORLD__ZONE] New TCP connection from 127.0.0.1:1818
[01.24. - 17:07:18] [WORLD__CONSOLE] New zoneserver #6 from 127.0.0.1:1818
[01.24. - 17:07:18] [WORLD__ZONE] [6] Zone started with name dynamic_05 by launcher zone
[01.24. - 17:07:18] [WORLD__ZONE] [6] Auto zone port configuration. Telling zone to use port 7005


part 2 coming

[Astaldoath]

AH HA

[01.24. - 17:08:48] [WORLD__CLIENT_ERR] Astaldoath: Received unknown EQApplicationPacket
[01.24. - 17:08:48] [WORLD__CLIENT_ERR] [OpCode OP_FloatListThing (0x6a1b) Size=18]
[01.24. - 17:08:48] [WORLD__CLIENT_ERR] 0000: 24 12 13 43 c9 76 6c c4 - 55 c4 13 c2 02 5f 85 10 | $..C

[Astaldoath]

lol im stupid, please delete this thread and my other one. Sorry bout this guys