Loading "mysql" saver ... *FATAL*: MYSQL ERROR

ihtus · Post by **ihtus** » Wed Mar 15, 2006 1:05 pm

I installes statistics for cs..and that is what i get after parsing cs_logs (in cron):
Loading referee ... done
Loading "halflife" scanner ...
Loading "halflife" definitions ... done
Loading "cstrike" definitions ... done
Loading "halflife" weapons ... done
Loading "cstrike" weapons ... done
Loading "halflife" bonuses ... done
Loading "cstrike" bonuses ... done
Processing all definitions ... done
Done loading scanner.
Loading "mysql" saver ... *FATAL*: MYSQL ERROR: Client does not support authentication protocol requested by server; consider upgrading MySQL client

ihtus · Post by **ihtus** » Wed Mar 15, 2006 1:06 pm

I decided to transfer my stats from my old hosting => here!
and this is what i get on parsing in cron on my OLD hosting server:

Loading referee ... done
Loading "halflife" scanner ...
Loading "halflife" definitions ... done
Loading "cstrike" definitions ... done
Loading "halflife" weapons ... done
Loading "cstrike" weapons ... done
Loading "halflife" bonuses ... done
Loading "cstrike" bonuses ... done
Processing all definitions ... done
Done loading scanner.
Loading "mysql" saver ...
Initializing pstats_c_plrdata_halflife_cstrike ... done
Initializing pstats_c_plrmaps_halflife_cstrike ... done
Initializing pstats_c_plrvictims_halflife_cstrike ... done
Initializing pstats_c_plrweapons_halflife_cstrike ... done
Initializing pstats_c_plrroles_halflife_cstrike ... done
Initializing pstats_c_gamemaps_halflife_cstrike ... done
Initializing pstats_c_gameweapons_halflife_cstrike ... done
done

PsychoStats v2.3 has been initializied.
Main config source: stats.cfg

Gathering "halflife:cstrike" Logs (player tracking by "name") ...
Source: /home/iht1/cs_logs/
777 logs found (26.08 MB) (Last updated: never)

[ 0%][ 1][00:00:00][ 0 B] L1114000.log
[ 0%][ 2][00:00:00][ 12.00 KB] L1114001.log
[ 0%][ 3][00:00:00][ 1.66 KB] L1114002.log
[ 1%][ 4][00:00:00][ 1.71 KB] L1114003.log
[ 1%][ 5][00:00:00][ 1.71 KB] L1114004.log
[ 1%][ 6][00:00:00][ 1.71 KB] L1114005.log
[ 1%][ 7][00:00:00][ 1.67 KB] L1114006.log
[ 1%][ 8][00:00:00][ 4.06 KB] L1114007.log
[ 1%][ 9][00:00:00][ 1.22 KB] L1114008.log
.........................................................................

Post by **SHAdmin** » Wed Mar 15, 2006 3:58 pm

When you are exporting your database from your old host, remember to export it in mySQL 4 format only. No other version of mysql format will work for restoring it on the server.

ihtus · Post by **ihtus** » Wed Mar 15, 2006 4:35 pm

SHadmin wrote:When you are exporting your database from your old host, remember to export it in mySQL 4 format only. No other version of mysql format will work for restoring it on the server.

i am not exporting it! i am building it from the begining! i made a blank db and after that run a script (from cron - /home/my_cpanel_username/psychostats/stats.pl) that processes the logs of the game and full that db with data. The steps how i am installing it are HERE
i really need someones help

ihtus · Post by **ihtus** » Wed Mar 15, 2006 4:39 pm

this is the old host configuration:
Apache Version 1.3.33 (Unix)
Perl Version 5.8.7
PHP Version 4.3.11
Mysql Version 4.0.25-standard

ihtus · Post by **ihtus** » Wed Mar 15, 2006 4:42 pm

actually i can import the db..but - day by day i am getting new logs of my game and need that logs to be processed (by /home/my_cpanel_username/psychostats/stats.pl) and introduced to db. The problem is in processing logs and introducing in db..

ihtus · Post by **ihtus** » Wed Mar 15, 2006 4:45 pm

here is the result of site that had processed the logs - http://ihtus.dl.am/
and here is when no logs were processed (Loading "mysql" saver ... *FATAL*: MYSQL ERROR: Client does not support authentication protocol requested by server; consider upgrading MySQL client) - http://www.ihtus.thesmokylounge.com/stats/

ihtus · Post by **ihtus** » Wed Mar 15, 2006 6:57 pm

i think this is the solution - http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:

mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

what should i write for "some_user" and "some_host" ?

ihtus · Post by **ihtus** » Wed Mar 15, 2006 9:44 pm

SHadmin: I think i found a solution - http://dev.mysql.com/doc/refman/5.0/en/old-client.html

but when i run

Code: Select all

mysql> SET PASSWORD FOR
 -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

i get this error "#1044 - Access denied for user 'user'@'localhost' to database 'mysql'"

maybe mysql admin should try this :
"Tell the server to use the older password hashing algorithm:

Start mysqld with the --old-passwords option.

Assign an old-format password to each account that has had its password updated to the longer 4.1 format. You can identify these accounts with the following query:

mysql> SELECT Host, User, Password FROM mysql.user
-> WHERE LENGTH(Password) > 16;

For each account record displayed by the query, use the Host and User values and assign a password using the OLD_PASSWORD() function and either SET PASSWORD or UPDATE, as described earlier."

or this - http://sourceforge.net/docman/display_d ... p_id=64772

ihtus · Post by **ihtus** » Wed Mar 15, 2006 9:52 pm

THe same problem is here - http://www.slashtalk.com/showthread.php ... 6#post2296

Loading "mysql" saver ... FATAL: MYSQL ERROR

Loading "mysql" saver ... FATAL: MYSQL ERROR