Comments (5)
Hi Jesse,
I'm using 2 vps with Ubuntu 20.04.1 LTS (GNU/Linux 5.4.0-42-generic x86_64). 1 for DB server with Mysql Server version: 8.0.20-0 and 1 for web server with SlickStack.
I just ran ss-install-mysql and error disappeared.
As I said, everything works fine, but I use ss-purge because "I feel" (I didn't do a real test) that clear caches option in wordpress isn't do the job so I do it in terminal.
Btw, it would be useful to have an option to turn off all server caches as in cloudflare developer mode.
If you want me to provide more information about the system, just tell me or if you want to check directly on my server, there is no problem.
from slickstack.
Hello @corzel I'm not sure what OS you are running but that does not look like Ubuntu.
SlickStack only supports Ubuntu 20.04 LTS with MySQL 8.0 at this time, running other software is at your own risk. If you want to play around with other software that is awesome but please provide more information to the community and maybe as you continue to debug the situation you can post your findings here. Cheers!
from slickstack.
Sorry, I read over your Issue very quickly. I think this is simply a failed MySQL connection here, due to authentication... an open Issue we are having with the newest MySQL 8.0 builds: #49
Anyway sha256_password
and caching_sha2_password
are both supported by MySQL 8.0:
https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html
...It seems you installed MariaDB instead of MySQL perhaps, so even if your initial setup worked fine, the SlickStack scripts are probably unable to connect to your database based on default script settings:
MariaDB Server does not currently support either the sha256_password or the caching_sha2_password authentication plugins. See MDEV-9804 for more information.
MariaDB Server does not support either of these authentication plugins. This is mainly because:
To use the protocol, one has to distribute the server's public key to all MariaDB users, which can be cumbersome and impractical.
The server gets the password in clear text which can cause problems if the user is convinced to connect to a malicious server.
From here: https://mariadb.com/kb/en/authentication-plugin-sha-256/
The real issue is that the ss-install-mysql
SlickStack script is currently broken as far as initial MySQL configuration.
from slickstack.
Following up on this complicated issue:
We have made several changes in the past few years to make the MySQL installation more straightforward. The biggest change is we now have a new separate script ss-install-mysql-database
that creates databases if not exist, creates all the database users and passwords, grants privileges, and etc.
Ref: https://github.com/littlebizzy/slickstack/blob/master/bash/ss-install-mysql-database.txt
This script now supports both Ubuntu 18.04 and Ubuntu 20.04 and going forward, most of our scripts will have support for various Ubuntu LTS releases directly in the code, so that they work cross-OS versions.
We are using caching_sha2_password
for Ubuntu 20.04 (MySQL 8.0) machines and mysql_native_password
for Ubuntu 18.04 (MySQL 5.7) machines for best compatibility.
These improvements were made more confusing because of some breaking changes that MySQL introduced in the 8.0 version tree that were very poorly documented, so I apologize if I jumped to conclusions here @corzel
We still need to improve the MySQL installation process, it's always been the most difficult module to deal with for me personally and probably will continue to be, due to the finicky nature of MySQL.
from slickstack.
As I said, everything works fine, but I use ss-purge because "I feel" (I didn't do a real test) that clear caches option in wordpress isn't do the job so I do it in terminal.
Btw, it would be useful to have an option to turn off all server caches as in cloudflare developer mode.
Interesting concept btw, if you can open a new Issue for this it would be great, thanks!
from slickstack.
Related Issues (20)
- Allow tuning of PHP8 JIT settings (opcache.jit options in php.ini) HOT 4
- Cloudflare real visitor IP support in Nginx config HOT 18
- Option to allow only Cloudflare IPs to connect to origin server HOT 2
- OpenVZ PHP-FPM "Unable to set priority for the master process: Permission denied" HOT 9
- Support for custom Permissions Policy HTTP header in Nginx HOT 6
- Improve WP-Cron robustness for Multisite environments HOT 3
- Scanning WordPress core files to check if intact or broken HOT 4
- Redirect .php extension to WordPress if not exists HOT 4
- Why deny /wp-admin/load-styles.php and /wp-admin/load-scripts.php? HOT 3
- Nginx access log enabled by default but nginx.conf says not HOT 5
- Spam Content HOT 1
- Expose additional options for ss remote backup HOT 2
- support for local development ? HOT 1
- 403 Error on Static Assets with Query Strings on SlickStack.io HOT 1
- Implement Server-Wide Connection Limit to Mitigate Request Overload HOT 1
- ss-config had a build version update, but ss-update-config didn't HOT 4
- Can't get it to work out of the box? HOT 1
- 403 google bot error
- Consider optional cache warming script that can fire on cron schedules
- Can't install due to 403 HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from slickstack.