To setup GrassBlade LRS, your system must meet the following requirements:
- HTTP Server. For example: Apache.
- mod_rewrite
- curl and curl php module (php2-curl)
- PHP 7.3+
- MySQL 4+ (Preferred:5.1.10+)
- PDO PHP Module for MySQL
- Domain with SSL installed (recommended)
SQL Mode Issue Fix:
You might need to disable the: sql_mode=only_full_group_by which is enabled by default in MySQL 5.7.5+
If it cannot be changed from MySQL. Try these steps:
- Open: app/Config/database.php
- after the line:
'datasource' => 'Database/Mysql',
- Add the following line:
'settings' => array('@@SESSION.sql_mode' => "(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))",),People using GrassBlade LRS on Nginx, and IIS (on hosts like Azure). So the above requirements are more of a recommendation.
Recommendations for IIS/Windows Server:
– You might need to disable the WebDAV module. It blocks PUT requests, and some content that sends PUT requests will not work. Generally, it can be disabled using the web.config file. Sometimes you need to make other adjustments to enable PUT requests.
– There is a sample web.config file included in grassblade-lrs
Recommendations for NGINX:
– NGINX doesn’t use .htaccess but uses an nginx.conf file. There is a sample nginx.conf file in grassblade-lrs, you can use it as a reference to configure your NGINX server for URL rewrites.
Popular Hosting Services Used for GrassBlade LRS:
- GrassBlade Cloud LRS
- Lightning Base
- BlueHost
For large databases and/or LRS traffic you might need a good Dedicated Server and a good Server Admin, or use GrassBlade Cloud LRS.
Doesn’t work on:
Godaddy Managed WordPress: Not supported. They won’t disable mandatory caching.
WPEngine: Not supported. WPEngine stopped supporting .htaccess. And it also doesn’t allow custom nginx.conf. It was already having issues with databases with more than 500,000 statements.
Kinsta: We have faced major performance issues in one instance.