26
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
•
Updating NPM packages using npm update and I'm seeing the following response
npm ERR! code E404
npm ERR! 404 Not Found - GET https://registry.npmjs.org/@fortawesome%2fpro-light-svg-icons - Not found
npm ERR! 404
npm ERR! 404 '@fortawesome/pro-light-svg-icons@^5.11.2' is not in this registry.
npm ERR! 404
@fortawesome:registry=https://npm.fontawesome.com/
npm ERR! 404 Note that you can also install from a
npm ERR! 404 tarball, folder, http url, or git url.
npm ERR! A complete log of this run...
Andrew Fletcher
•
Goal: Restrict content access through username and password entry on an Nginx...
Andrew Fletcher
•
Goal: I want to download a table list to a txt or csv file.
Initially, as a root...
Andrew Fletcher
•
Reviewing CKAN extensions and listing the extensions that have been created /...
Andrew Fletcher
•
Location of the base templates
cd...
Andrew Fletcher
•
Finding the issue with a server 500 error
The Nginx error logs are showing too much detail.
Nginx logs and test
There are no errors in the nginx log and sudo nginx -t looks fine
sudo nginx -tResponse
nginx: the configuration file /etc/nginx/nginx.conf syntax is ok
nginx: configuration file /etc/nginx/nginx.conf test is successful
Are the services running?
I'll start by doing a status check for
Nginx
PostgreSQL
jetty9
Supervisor
Nginx
sudo service nginx statusResponse
●...
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...
Andrew Fletcher
•
Before you can run CKAN for the first time, you need to run db init to...