• twitter image
  • facebook image
  • youtube image
  • linkedin image
Language: CMS Made Simple Czech CMS Made Simple France CMS Made Simple Spain CMS Made Simple Hungary CMS Made Simple Russia CMS Made Simple Netherlands

All times are UTC




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Solved: "authentication method unknown" during installation
PostPosted: Sun Aug 18, 2019 11:45 pm 
Offline
New Member
New Member

Joined: Sun Aug 18, 2019 6:31 pm
Posts: 1
Hi,

I ran into the following issue while installing CMSMS 2.3-beta6 on a CentOS 7 server, with Apache 2.4, PHP 7.3 and MySQL (Percona) 8.0.15. I installed from the PHAR file, i.e., cmsms-2.3-beta6-install.php.

After I created a MySQL user and database for CMSMS, I entered these details in the corresponding screen in the installation process, and got the following error:

Quote:
The server requested authentication method unknown to the client


I found out that MySQL changed the default authentication plugin from mysql_native_password to caching_sha2_password as of version 8.0.4. You can read more about this here:
https://dev.mysql.com/doc/relnotes/mysq ... 8-0-4.html
https://dev.mysql.com/doc/refman/8.0/en ... 2-password

This has no effect when MySQL is upgraded in place for an existing CMSMS installation. The problem arises when a new database user is created, in MySQL version 8.0.4 or later.

Workaround:
Code:
mysql> CREATE USER 'cmsuser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourPasswordHere';

This creates a database user while expressly selecting mysql_native_password authentication.

I trust that future versions of CMSMS (or perhaps I should say, future versions of the PHP MySQLi extension?) will support the newer SHA2 authentication mechanisms.

I am posting this here in hope that it may be useful to someone. I am new here, so if I posted in the wrong place then please point me in the right direction.

Cheers!
H.

P.S. The eagle-eyed reader may have noticed that I'm on PHP 7.3, while CMSMS 2.3 officially calls for <=7.2. I'm pleased to say I've had no issues so far.


Top
  Profile  
 
Share On:
Share on Facebook Share on Twitter Share on Google+
 Post subject: Re: Solved: "authentication method unknown" during installat
PostPosted: Mon Aug 19, 2019 1:26 pm 
Offline
Dev Team Member
Dev Team Member
User avatar

Joined: Tue Oct 19, 2004 6:44 pm
Posts: 8158
Location: Fernie British Columbia, Canada
quick research says that the mysqli extension to PHP does not support this (yet).

_________________
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.


Top
  Profile  
 
Share On:
Share on Facebook Share on Twitter Share on Google+
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
A2 Hosting