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
•
Install the CKAN package
Begin by cleaning up your server environment....
Andrew Fletcher
•
If you're planning to create extensions, generating CKAN from source is the...
Andrew Fletcher
•
CKAN extensions - adding to your installation
Following the information...
Andrew Fletcher
•
Goal: Restrict content access through username and password entry on an Nginx server.
1: Apache Utilities Package
First, update your server’s package index:
sudo apt updateCheck if the utilities package exists in your environment by executing the command
dpkg --get-selections | grep apacheResponse:
apache2-utils install
libapache-pom-java installSo it exists. But what do you do if it doesn't exist?
How come I need to install apache-utils? To restrict access you will be using...
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
•
Setting up the admin password.
Process:
1. Edit jetty.xml
To begin you...
Andrew Fletcher
•
Reviewing CKAN extensions and listing the extensions that have been created /...