Skip to main content
29
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
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
Recently I have been investigating one of my Linux server's speed using the...
Andrew Fletcher
Reviewing CKAN extensions and listing the extensions that have been created /...
Andrew Fletcher
Location of the base templates cd...
Andrew Fletcher
Looking to install Solr on your server?  Not sure if it worth the effort?  Well, Apache Solr is the open-source, popular, super fast open source enterprise search platform from the Apache Lucene project.  Written in Java, Solr is highly scalable, providing fault-tolerant distributed search and indexing. Let's walk through the steps I went through to install Solr on Centos 7.   Step 1: Java Check if Java is installed on your server: java -versionNot there - then JAVA is the...
Andrew Fletcher
Finding the issue with a server 500 error The Nginx error logs are showing too...
Andrew Fletcher
Focusing on the ckan.ini file (/etc/ckan/default/ckan.ini).  When I run the...
Andrew Fletcher
Following the instructions on CKAN DataStore with a little...
Andrew Fletcher
Working through a CKAN installation on Ubuntu 20.04 User sees a server 500...