AMXX 1.9 - build 5294 mysql

alliedmodders / amxmodx

AMX Mod X - Half-Life 1 Scripting and Administration

http://www.amxmodx.org/

489 stars 197 forks source link

AMXX 1.9 - build 5294 mysql #1033

Open DeNeDe opened 2 years ago

DeNeDe commented 2 years ago

I'm using version 1.9 - build 5294 and i have problems using the admins sql feature or any other plugin that has sql feature Despite the fact all credentials are in order it doesn't want to connect. Ive tried both localhost and 127.0.0.1 for the host Using MariaDB 10.6 Should the mysql module be update or code re-written ?

bigdaddy424 commented 2 years ago

Do you get this on the server console? Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/local/mysql/lib/plugin/caching_sha2_password.so: cannot open

DeNeDe commented 2 years ago

Ohh no I got [AMXX] SQL error: can't connect: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 0' this is for the admins the other plugins just say can't connect to the database

bigdaddy424 commented 2 years ago

a quick google search leads to this https://stackoverflow.com/questions/3578147/mysql-error-2013-lost-connection-to-mysql-server-at-reading-initial-communic

DeNeDe commented 2 years ago

wow... jeeez thanks (sarcasm) of course ive tried that still didnt worked. idea is any other script i have work just fine using those credentials to connect to the database

DeNeDe commented 2 years ago

i've found the fix for it without any security risks ive looked in the database and the root account is for localhost but since in the config scripts we use 127.0.0.1 we just need to make another account for root for the host 127.0.0.1 (yes i use root under linux) yes i know..the 2 are the same, but not kinda (yes ive tried at first to use localhost instead of 127.0.0.1 in the configs but gave other errors)