Setting up server. MYSQL Is messed up

Astaldoath · #1 01-23-2008, 08:03 PM

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 · #2 01-24-2008, 12:06 AM

Quote:

Originally Posted by Astaldoath

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 · #3 01-24-2008, 01:28 AM

Might need to run something like this ;

Code:

SET PASSWORD FOR 'eq'@'localhost' = OLD_PASSWORD('newpwd');

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

Astaldoath · #4 01-24-2008, 05:23 AM

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 · #5 01-24-2008, 05:31 AM

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 · #6 01-24-2008, 06:07 AM

Quote:

Originally Posted by Angelox

Might need to run something like this ;

Code:

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 · #7 01-24-2008, 06:08 AM

Quote:

Originally Posted by 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

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

Astaldoath · #8 01-24-2008, 06:24 AM

Quote:

Originally Posted by Xgen

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 · #9 01-24-2008, 06:28 AM

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 · #10 01-24-2008, 06:34 AM

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 · #11 01-24-2008, 07:07 AM

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

Code:

---------------------------------------------
[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 · #12 01-24-2008, 09:18 AM

Quote:

Originally Posted by Astaldoath

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 · #13 01-24-2008, 09:21 AM

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

Angelox · #14 01-24-2008, 09:44 AM

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 · #15 01-24-2008, 10:03 AM

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.