Skip to main content
28
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
Setting up the admin password.   Process: 1. Edit jetty.xml To begin you...
Andrew Fletcher
After cloning a site, next you will want to import the config file.  Which...
Andrew Fletcher
Reviewing CKAN extensions and listing the extensions that have been created /...
Andrew Fletcher
Location of the base templates cd /usr/lib/ckan/default/src/ckan/ckan/templatesWhereas as the location of the plugin that displays the new template cd /usr/lib/ckan/default/src/ckanext-{project}/ckanext/{project}/templatesTo alter the home main page, edit the  cd...
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
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...