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
27
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
•
To resolve the CVE-2022-48624 vulnerability on Ubuntu using Nginx, it's crucial...
Andrew Fletcher
•
In many terminal text editors, you use find command as reference in Terminal...
Andrew Fletcher
•
In an environment that is running
Ubuntu 20.02
Nginx
Solr
The default...
Andrew Fletcher
•
These steps are for Drupal 8 and 9.
Export your database
Order here is...
Andrew Fletcher
•
Adding an SSL wildcard certificate to an Ubuntu server involves several steps. A wildcard certificate can secure subdomains of a domain with a single certificate. Here's a general outline of the process:
I'll be using an existing wildcard certificate.
sudo apt update && sudo apt upgrade -y
Copy the certificate
sudo cp /etc/letsencrypt/live/your_domain/fullchain.pem /etc/ssl/your_domain.crt
sudo cp /etc/letsencrypt/live/your_domain/privkey.pem /etc/ssl/your_domain.keyAdd the...
Andrew Fletcher
•
When logging into Ubuntu server you will see a response similar to
Welcome to...
Andrew Fletcher
•
Forcing https and www or non-www is a process that I was a custom to through...
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
•
Recently I have been investigating one of my Linux server's speed using the copy [cp] command. This came about due to 'upgrading' the server from Centos 6 to 7. Once I had migrated a domain, I ran the following command
yes | cp -rf 'stg/core' 'tmpdir'To my surprise, the first run of this command took over 38 minutes to complete. Crap! Yes a simple cp -a command is a very painful and slow process. Read more about the pain and times under Centos 7 in this...
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
•
Listen in on the ports being used on your server. To do so, run the...
Andrew Fletcher
•
Error with Nginx
When running an Nginx test, the following response was being...