Enable TLS (SSL) database connection and certificate-based authentication
This note aims to show step by step how to generate a self-signed SAN SSL/TLS certificate on macOS Monterey and then configure a secure connection and certif...
Posts by Tag
- macOS 7
- terminal 5
- AWS 3
- command line 3
- SSH 2
- Alpine Linux 2
- MailChimp 1
- collation 1
- utf8_unicode_ci 1
- Cyrillic 1
- ORDER BY 1
- Zip 1
- EC2 1
- scp 1
- Amazon 1
- mysqldump 1
- SSH key 1
- get_headers 1
- allow_url_fopen 1
- AUTO_INCREMENT 1
- PHP 7 1
- php7cc 1
- Nginx 1
- AWS CLI 1
- Mac 1
- Sublime Text 1
- Xcode 1
- PHP 1
- homebrew 1
- calculation 1
- parseFloat 1
- toFixed 1
- checkbox 1
- setCustomValidity 1
- Apache Bench 1
- Apache Benchmark 1
- NTFS 1
- exFAT 1
- ulimit 1
- self-signed certificate 1
- Monterey 1
- SSL 1
- TLS 1
- PostgreSQL 1
- SubjectAltName 1
- SAN 1
- CN 1
macOS
Too many open files error on macOS
We’re going to increase an ulimit setting on macOS, but first let’s obtain the current limit of file descriptors via ulimit -n.
How to Write to NTFS Drives in macOS Mojave
In case you use NTFS formatted USB drives on your Mac, you can only open files stored on those drives, but you can’t change those files.
Working with AWS credentials on macOS
Check credentials
SSH keys are lost after macOS High Sierra reboot
To list all keys run
Create MySQL dump on EC2 instance and download it
We’re going to create a MySQL dump on an EC2 instance, compress and download this file to our local (Mac) machine.
Make a Zip Archive without a .DS_Store file on macOS
Let’s compress folder (current one) without the .DS_Store file
terminal
Set up PHP 7.2 on macOS Mojave (with homebrew)
To check the version of PHP in the terminal, type the following command:
Error: tool ’xcodebuild’ requires Xcode… on macOS
If you get the following error with npm install
Launch Sublime Text 3 from the terminal
$ echo $PATH
Create MySQL dump on EC2 instance and download it
We’re going to create a MySQL dump on an EC2 instance, compress and download this file to our local (Mac) machine.
Make a Zip Archive without a .DS_Store file on macOS
Let’s compress folder (current one) without the .DS_Store file
AWS
Install AWS CLI on macOS
Easiest way to install AWS CLI
Working with AWS credentials on macOS
Check credentials
SSH keys are lost after macOS High Sierra reboot
To list all keys run
command line
Set up PHP 7.2 on macOS Mojave (with homebrew)
To check the version of PHP in the terminal, type the following command:
Error: tool ’xcodebuild’ requires Xcode… on macOS
If you get the following error with npm install
Launch Sublime Text 3 from the terminal
$ echo $PATH
SSH
SSH keys are lost after macOS High Sierra reboot
To list all keys run
Create MySQL dump on EC2 instance and download it
We’re going to create a MySQL dump on an EC2 instance, compress and download this file to our local (Mac) machine.
Alpine Linux
How to reload Nginx on Alpine Linux
When you run the following command, Nginx will reload its configuration from a specified file without stopping the server
PHP 7 Compatibility Checker (php7cc)
$ apk add php7-phar
MailChimp
How to add email to MailChimp list using WordPress
```php <?php
collation
Extra Ukrainian letters are not sorted well
The problem is that Ukrainian letters are not sorted correctly by the alphabet, ie “і” and “є” are preceded by “а”, “б”, while using the ORDER BY operator in...
utf8_unicode_ci
Extra Ukrainian letters are not sorted well
The problem is that Ukrainian letters are not sorted correctly by the alphabet, ie “і” and “є” are preceded by “а”, “б”, while using the ORDER BY operator in...
Cyrillic
Extra Ukrainian letters are not sorted well
The problem is that Ukrainian letters are not sorted correctly by the alphabet, ie “і” and “є” are preceded by “а”, “б”, while using the ORDER BY operator in...
ORDER BY
Extra Ukrainian letters are not sorted well
The problem is that Ukrainian letters are not sorted correctly by the alphabet, ie “і” and “є” are preceded by “а”, “б”, while using the ORDER BY operator in...
Zip
Make a Zip Archive without a .DS_Store file on macOS
Let’s compress folder (current one) without the .DS_Store file
EC2
Create MySQL dump on EC2 instance and download it
We’re going to create a MySQL dump on an EC2 instance, compress and download this file to our local (Mac) machine.
scp
Create MySQL dump on EC2 instance and download it
We’re going to create a MySQL dump on an EC2 instance, compress and download this file to our local (Mac) machine.
Amazon
Create MySQL dump on EC2 instance and download it
We’re going to create a MySQL dump on an EC2 instance, compress and download this file to our local (Mac) machine.
mysqldump
Create MySQL dump on EC2 instance and download it
We’re going to create a MySQL dump on an EC2 instance, compress and download this file to our local (Mac) machine.
SSH key
SSH keys are lost after macOS High Sierra reboot
To list all keys run
get_headers
Does a remote file exist (using get_headers)?
As you probably know, a get_headers function in PHP typically returns something similar to:
allow_url_fopen
Does a remote file exist (using get_headers)?
As you probably know, a get_headers function in PHP typically returns something similar to:
AUTO_INCREMENT
Next AUTO_INCREMENT value
To get the next AUTO_INCREMENT value from a table run the following query:
PHP 7
PHP 7 Compatibility Checker (php7cc)
$ apk add php7-phar
php7cc
PHP 7 Compatibility Checker (php7cc)
$ apk add php7-phar
Nginx
How to reload Nginx on Alpine Linux
When you run the following command, Nginx will reload its configuration from a specified file without stopping the server
AWS CLI
Install AWS CLI on macOS
Easiest way to install AWS CLI
Mac
Install AWS CLI on macOS
Easiest way to install AWS CLI
Sublime Text
Launch Sublime Text 3 from the terminal
$ echo $PATH
Xcode
Error: tool ’xcodebuild’ requires Xcode… on macOS
If you get the following error with npm install
PHP
Set up PHP 7.2 on macOS Mojave (with homebrew)
To check the version of PHP in the terminal, type the following command:
homebrew
Set up PHP 7.2 on macOS Mojave (with homebrew)
To check the version of PHP in the terminal, type the following command:
calculation
How to fix imprecise calculations in JavaScript
What is it about? Try to execute some of the following examples in the browser console (or somehow using JavaScript) and you will see that sometimes there ar...
parseFloat
How to fix imprecise calculations in JavaScript
What is it about? Try to execute some of the following examples in the browser console (or somehow using JavaScript) and you will see that sometimes there ar...
toFixed
How to fix imprecise calculations in JavaScript
What is it about? Try to execute some of the following examples in the browser console (or somehow using JavaScript) and you will see that sometimes there ar...
checkbox
At least one checkbox must be selected (checked)
There is a form with multiple checkboxes and we’re going to make sure that at least one is checked using pure JavaScript. To set a custom validation error me...
setCustomValidity
At least one checkbox must be selected (checked)
There is a form with multiple checkboxes and we’re going to make sure that at least one is checked using pure JavaScript. To set a custom validation error me...
Apache Bench
Using Apache Bench for simple load testing
The following command runs 100 requests in total with 10 concurrent requests to example.com.
Apache Benchmark
Using Apache Bench for simple load testing
The following command runs 100 requests in total with 10 concurrent requests to example.com.
NTFS
How to Write to NTFS Drives in macOS Mojave
In case you use NTFS formatted USB drives on your Mac, you can only open files stored on those drives, but you can’t change those files.
exFAT
How to Write to NTFS Drives in macOS Mojave
In case you use NTFS formatted USB drives on your Mac, you can only open files stored on those drives, but you can’t change those files.
ulimit
Too many open files error on macOS
We’re going to increase an ulimit setting on macOS, but first let’s obtain the current limit of file descriptors via ulimit -n.
self-signed certificate
Enable TLS (SSL) database connection and certificate-based authentication
This note aims to show step by step how to generate a self-signed SAN SSL/TLS certificate on macOS Monterey and then configure a secure connection and certif...
Monterey
Enable TLS (SSL) database connection and certificate-based authentication
This note aims to show step by step how to generate a self-signed SAN SSL/TLS certificate on macOS Monterey and then configure a secure connection and certif...
SSL
Enable TLS (SSL) database connection and certificate-based authentication
This note aims to show step by step how to generate a self-signed SAN SSL/TLS certificate on macOS Monterey and then configure a secure connection and certif...
TLS
Enable TLS (SSL) database connection and certificate-based authentication
This note aims to show step by step how to generate a self-signed SAN SSL/TLS certificate on macOS Monterey and then configure a secure connection and certif...
PostgreSQL
Enable TLS (SSL) database connection and certificate-based authentication
This note aims to show step by step how to generate a self-signed SAN SSL/TLS certificate on macOS Monterey and then configure a secure connection and certif...
SubjectAltName
Enable TLS (SSL) database connection and certificate-based authentication
This note aims to show step by step how to generate a self-signed SAN SSL/TLS certificate on macOS Monterey and then configure a secure connection and certif...
SAN
Enable TLS (SSL) database connection and certificate-based authentication
This note aims to show step by step how to generate a self-signed SAN SSL/TLS certificate on macOS Monterey and then configure a secure connection and certif...
CN
Enable TLS (SSL) database connection and certificate-based authentication
This note aims to show step by step how to generate a self-signed SAN SSL/TLS certificate on macOS Monterey and then configure a secure connection and certif...