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
37
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
•
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
•
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...
Andrew Fletcher
•
On your local OSX environment using Terminal or iTerm you can create a MySQL...