developer resources
Codebales holds an ever growing number of solutions to problems that we have experienced in our day to day code writing
Selected filter
118
results
Andrew Fletcher
•
I've recently upgraded the server Ubuntu 20.04 updating the PHP version from 7.4 to 8.1. However, when I've attempted to export the MySQL database using the command
drush sql-dump --extra-dump=--no-tablespaces --result-file=../sql/db-2023-02-25.sqlI seeing the following response
> mysqldump: Couldn't execute 'FLUSH TABLES': Access denied; you need (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this operation (1227)
In SqlCommands.php line 242:
Unable to dump...
Andrew Fletcher
•
Find by file name
To perform a find command in terminal use
find / -name...
Andrew Fletcher
•
Reviewing CKAN extensions and listing the extensions that have been created /...
Andrew Fletcher
•
Location of the base templates
cd...
Andrew Fletcher
•
I had generated a backup of key directories on the server - see Create a...
Andrew Fletcher
•
An approach to generating a backup server is using a shell script. A script can define directories to backup, and pass those directories as arguments to the tar utility, which creates an archive file. The archive file can then be moved or copied to another location.
Example Shell Script
#!/bin/bash
#
# Backup script
#
# NAME: daily-backup.sh
# PATH: /mnt/e/bin
# DESC: Backup scripts, documents and configuration files to .tar
#
# What to backup
# backup_files="/home...
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...
Andrew Fletcher
•
Before you can run CKAN for the first time, you need to run db init to initialise your database:
ckan -c /etc/ckan/default/ckan.ini db initIf this fails due to a permission issue, then the user and group assigned are incorrect. Or if you are a root user, you can use sudo
sudo ckan -c /etc/ckan/default/ckan.ini db initIf you forget this step you'll see a 500 server error:
503 Service Unavailable: This site is currently offline. The database is not initialised.
Cleaning your...
Andrew Fletcher
•
Creating a bash script
Bash scripts are files containing code that tell your...
Andrew Fletcher
•
How do you generate a .pem file from an existing .ppk key?
Is putty on your...
Andrew Fletcher
•
In this woalk through I am going to use GitHub. However, the steps are...
Andrew Fletcher
•
On your local OSX environment using Terminal or iTerm you can create a MySQL...