Raised This Month: $7 Target: $400
 1% 

Is MySQL 8.0+ supported?


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
ZASTRELIS
Veteran Member
Join Date: Nov 2010
Location: Siberia, Irkutsk
Old 07-16-2019 , 12:40   Is MySQL 8.0+ supported?
Reply With Quote #1

Is SourceMod supports MySQL 8.0+?

Code:
L 07/17/2019 - 00:33:52: SourceMod error session started
L 07/17/2019 - 00:33:52: Info (map "de_dust2") (file "errors_20190717.log")
L 07/17/2019 - 00:33:52: [SM] Exception reported: Failed to connect to SourceBans DB, [1251]: Client does not support authentication protocol requested by server; consider upgrading MySQL client
L 07/17/2019 - 00:33:52: [SM] Blaming: sbchecker.smx
L 07/17/2019 - 00:33:52: [SM] Call stack trace:
L 07/17/2019 - 00:33:52: [SM]   [0] SetFailState
L 07/17/2019 - 00:33:52: [SM]   [1] Line 72, sbchecker.sp::OnDatabaseConnected
L 07/17/2019 - 00:33:53: [sourcecomms.smx] Connecting to database failed: [1251]: Client does not support authentication protocol requested by server; consider upgrading MySQL client
L 07/17/2019 - 00:33:53: [FuckYou.smx] fucking_data: DB_CONNECT failure ([1251]: Client does not support authentication protocol requested by server; consider upgrading MySQL client)
L 07/17/2019 - 00:33:53: [SourceSleuth.smx] SourceSleuth: Database connection error: [1251]: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Last edited by ZASTRELIS; 07-16-2019 at 12:42.
ZASTRELIS is offline
asherkin
SourceMod Developer
Join Date: Aug 2009
Location: OnGameFrame()
Old 07-16-2019 , 13:21   Re: Is MySQL 8.0+ supported?
Reply With Quote #2

Your server is using the caching_sha2_password authentication strategy that was only implemented in MySQL 8.0 (and made the default in the same release), you will need to switch back to mysql_native_password to let SourceMod (and many other things) connect. There are no plans to add caching_sha2_password support to SourceMod.
__________________

Last edited by asherkin; 07-16-2019 at 13:22.
asherkin is offline
ZASTRELIS
Veteran Member
Join Date: Nov 2010
Location: Siberia, Irkutsk
Old 07-16-2019 , 13:26   Re: Is MySQL 8.0+ supported?
Reply With Quote #3

Quote:
Originally Posted by asherkin View Post
Your server is using the caching_sha2_password authentication strategy that was only implemented in MySQL 8.0 (and made the default in the same release), you will need to switch back to mysql_native_password to let SourceMod (and many other things) connect. There are no plans to add caching_sha2_password support to SourceMod.
Is it will be as solution?
Code:
[mysqld]
...
default_authentication_plugin   = mysql_native_password
...

root@localhost [(none)]> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
ZASTRELIS is offline
ZASTRELIS
Veteran Member
Join Date: Nov 2010
Location: Siberia, Irkutsk
Old 07-16-2019 , 21:03   Re: Is MySQL 8.0+ supported?
Reply With Quote #4

no utf8mb support, no mysql8 :\ solution not works..

Last edited by ZASTRELIS; 07-16-2019 at 21:26.
ZASTRELIS is offline
CrazyHackGUT
AlliedModders Donor
Join Date: Feb 2016
Location: Izhevsk, Russia
Old 07-17-2019 , 09:39   Re: Is MySQL 8.0+ supported?
Reply With Quote #5

For using UTF8MB4, you need upgrade to SM 1.10. SM 1.9 and older doesn't support UTF8MB4.
__________________
My english is very bad. I am live in Russia. Learning english language - very hard task for me...
CrazyHackGUT is offline
Send a message via ICQ to CrazyHackGUT Send a message via Skype™ to CrazyHackGUT
ZASTRELIS
Veteran Member
Join Date: Nov 2010
Location: Siberia, Irkutsk
Old 07-20-2019 , 06:21   Re: Is MySQL 8.0+ supported?
Reply With Quote #6

Quote:
Originally Posted by CrazyHackGUT View Post
For using UTF8MB4, you need upgrade to SM 1.10. SM 1.9 and older doesn't support UTF8MB4.
You sure with 1.10?
ZASTRELIS is offline
Peace-Maker
SourceMod Plugin Approver
Join Date: Aug 2008
Location: Germany
Old 07-21-2019 , 07:16   Re: Is MySQL 8.0+ supported?
Reply With Quote #7

Yes.
__________________
Peace-Maker is offline
SugarDx
Member
Join Date: Jun 2017
Old 12-22-2021 , 19:12   Re: Is MySQL 8.0+ supported?
Reply With Quote #8

Quote:
Originally Posted by asherkin View Post
Your server is using the caching_sha2_password authentication strategy that was only implemented in MySQL 8.0 (and made the default in the same release), you will need to switch back to mysql_native_password to let SourceMod (and many other things) connect. There are no plans to add caching_sha2_password support to SourceMod.
I apologize for digging up an old thread, but is this still the plan? If so, this is very concerning from a security standpoint given the amount of time that has passed. Unfortunately I'm not finding any other discussions on the subject elsewhere.

As a side note, I've had no issues with MySQL 8.0 and SourceMod. They seem to work flawlessly together these days.
__________________
SugarDx is offline
asherkin
SourceMod Developer
Join Date: Aug 2009
Location: OnGameFrame()
Old 12-22-2021 , 20:13   Re: Is MySQL 8.0+ supported?
Reply With Quote #9

Quote:
Originally Posted by SugarDx View Post
I apologize for digging up an old thread, but is this still the plan? If so, this is very concerning from a security standpoint given the amount of time that has passed. Unfortunately I'm not finding any other discussions on the subject elsewhere.
Yes - SM uses the 5.5 client driver which doesn't have support for caching_sha2_password, and in later versions where it is supported it is an external plugin which is difficult to distribute alongside SM. mysql_native_password is secure as long as either the MySQL users DB or the communication channel is protected - and it is very rare to use SM with remote MySQL servers (in part due to the significant performance considerations).
__________________
asherkin is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 04:21.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode