PSNick
18 contributions
17.2k contribution views
Recognition
Posts
-
Published Question
Removing subdomains/certificates from Spaces?
Hello, I currently have 4 subdomains on my spaces, but I'm only using one and want to remove the rest as I need them for other resources and I keep getting emails every month about DO updating my SSL certificate for t... -
Published Question
Managed MySQL database error: Unknown column in 'where clause'
Hello, I am using OpenLiteSpeed WordPress 1-Click from the marketplace and a Managed MySQL 8 Database. There's a specific and well known plugin I need to run the website: Easy Digital Downloads. On a fresh install, wi... -
Published Question
Managed MySQL: Failed to create table
Hello, I'm using Managed MySQL and the OpenLiteSpeed WordPress 1-Click image. Enabling some css or js options in the bundled LSCache plugin shows the following error: Failed to create table cssjs! SQL: CREATE TABLE I...Accepted Answer: Hi, What if you directly run CREATE TABLE IF NOT EXISTS `wp_litespeed_cssjs` (`id` bigint(20) NOT NULL AUTO_INCREMENT, `hash_name` varchar(60) NOT NULL COMMENT "hash.filetype", `src` text NOT NULL COMMENT "full url ... -
Published Answer
OpenLiteSpeed WordPress + Managed Redis. Connection Test: Failed
It looks like redis-cli doesn’t support SSL, so you need to take a few extra steps: sudo apt update sudo apt install redis...Accepted Answer: It looks like redis-cli doesn’t support SSL, so you need to take a few extra steps: sudo apt update sudo apt install redis... -
Published Question
OpenLiteSpeed WordPress + Managed Redis. Connection Test: Failed
Hello, I have created a droplet using the OpenLiteSpeed WordPress 1-Click image. I have also created a Managed Redis DB to use for object cache, however I am unable to connect the bundled LSCache WordPress plugin to t...Accepted Answer: It looks like redis-cli doesn't support SSL, so you need to take a few extra steps: ``` sudo apt update sudo apt install redis-tools stunnel4 sudo nano /etc/default/stunnel4 Add the following line: ENABLED=1 sudo nano... -
Published Question
Recovery for Managed MySQL + Redis
Hello, I'll soon start an e-commerce website for digital files based on WordPress and EDD and thought the ideal setup would be: OpenLiteSpeed Wordpress (from the marketplace) Managed MySQL Managed Redis Spaces for the...Accepted Answer: Hi there @PSNick, This sounds like a solid setup, I like it! It also gives you the chance to, later on, scale up your webserver to multiple web servers and add a load balancer. Regarding, the MySQL restore, I would re... -
Published Question
"Cannot open display" error on a GIMP batch script.
Hello, For an application I need to run simple batch scripts using GIMP. Once the command is executed, the error I get is: Cannot open display: It seems that even using the --no-interface flag it requires a display...