45
results
Andrew Fletcher
•
Recently I came across this piece of gold when dealing with databases, particularly relational ones like MySQL, managing transactions efficiently is crucial to ensure data integrity and consistency. In MySQL, transactions are used to group several SQL commands into a single unit that either completely succeeds or completely fails, ensuring that a database remains in a consistent state.
Managing transactions efficiently in databases like MySQL is crucial for ensuring data integrity and...
Andrew Fletcher
•
When Solr is displaying results on the site, first step is to log in the server...
Andrew Fletcher
•
Having updated Solr, re-indexing wasn't working. The error in the logs...
Andrew Fletcher
•
On an Ubuntu 20.02 system with Nginx, you can utilize the following commands to...
Andrew Fletcher
•
Cleaning out or clearing data in Solr can be done in a few different ways,...
Andrew Fletcher
•
In an environment that is running
Ubuntu 20.02
Nginx
Solr
The default Nginx conf is located /etc/nginx/sites-available/ and contains something similar to:
server {
listen 80;
listen [::]:80;
server_name uat.oursite.com;
return 301 http://uat.oursite.com$request_uri;
}
server {
listen 80;
listen [::]:80;
listen 443 ssl;
ssl_certificate /etc/ssl/certs/Bundle.crt;
ssl_certificate_key /etc/ssl/private/MultidomainWildcard.key;
# Security...
Andrew Fletcher
•
These steps are for Drupal 8 and 9.
Export your database
Order here is...
Andrew Fletcher
•
Update Ubuntu 20.04
To begin update the server using the command
sudo apt update...
Andrew Fletcher
•
Goal: I want to download a table list to a txt or csv file.
Initially, as a root...
Andrew Fletcher
•
Whilst attempting to download the latest config.zip file for Solr, I was greeted...
Andrew Fletcher
•
Installing PHP on OSX and it installed PHP 8.2.x. However, for my applications I need to run 8.1.x. How do you switch the current PHP version?
Current version
Check the current PHP version by executing the command
php -vResponse:
PHP 8.2.2 (cli) (built: Feb 5 2023 12:38:16) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.2.2, Copyright (c) Zend Technologies
with Zend OPcache v8.2.2, Copyright (c), by Zend Technologies
Unlink PHP
To change your PHP version, begin...
Andrew Fletcher
•
Setting up the admin password.
Process:
1. Edit jetty.xml
To begin you...
Andrew Fletcher
•
In this article I'll walk through the steps I went through to install Solr on...
Andrew Fletcher
•
Looking to install Solr on your server? Not sure if it worth the...
Andrew Fletcher
•
The following the CKAN source install docs from start to finish including solr....