cloud engineer
Here’s how to list SQL instances within your GCP project.
gcloud sql instances list --project your-project-id |
Output:
NAME DATABASE_VERSION LOCATION TIER PRIMARY_ADDRESS PRIVATE_ADDRESS STATUS database1 SQLSERVER_2017_STANDARD us-central1-a db-n1-standard-1 - 10.10.10.11 RUNNABLE database2 SQLSERVER_2017_STANDARD us-central1-c db-n1-standard-1 - 10.10.10.12 RUNNABLE |
Here’s another way to list projects in a shared VPC.
gcloud compute shared-vpc list-associated-resources your-shared-host |
Output:
project1 PROJECT project2 PROJECT project3 PROJECT ... |
Two years ago, WordPress introduced Gutenberg block editor together with the release of WordPress version 5.0. Gutenberg essentially became the default editor starting with WordPress version 5.0. While many people love the Gutenberg editor, some people hate it. If you’re one of the many people who hate the Gutenberg editor, you can simply disable it by installing a plugin called Disable Gutenberg. This plugin will revert back to the classic editor.
Once installed, you should be able to see the Classic editor.
After working with Gutenberg for so long, I forgot the speed and agility of the classic editor. It’s much faster.
Here’s how to list AWS AMI (machine images) owned by yourself.
aws ec2 describe-images \ --query "Images[*].[Name,PlatformDetails]" \ --owners self \ --profile default \ --region us-east-1 \ --output text |
Output:
icecast-0.1 Linux/UNIX jekyll-0.3 Linux/UNIX docker-0.1 Linux/UNIX |
Specifying owners as self only display images owned by you.
I decided to log my commands for good record keeping. Here’s my script.
#!/bin/bash if [[ $# -eq 0 ]] ; then echo 'No arguments. Format: ./go.sh script.sh'; exit 0; fi log=log.txt echo '-------------------------------' >> $log date >> $log echo '---' >> $log cat $1 >> $log echo '---' >> $log /bin/bash $1 2>&1 | tee -a $log |
To run.
./go.sh script.sh |
Line by line explanation.
I was getting this error when downloading a file from a S3 bucket.
fatal error: An error occurred (403) when calling the HeadObject operation: Forbidden |
Turns out to be a permission issue. Use –acl bucket-owner-full-control.
# UPLOAD aws s3 cp file.txt s3://bucket-name/dir/ --acl bucket-owner-full-control upload: .\file.txt to s3://bucket-name/dir/fw.sh # DOWNLOAD aws s3 cp s3://bucket-name/dir/file.txt . --acl bucket-owner-full-control download: s3://bucket-name/dir/file.txt to .\file.txt |
You need to do for both upload and download.
Here’s how to create a firewall from service account to service account.
gcloud compute firewall-rules create "firewall-name" \ --description="firewall-description" \ --priority "1000" \ --direction INGRESS \ --action allow \ --network "network-name" \ --source-service-accounts="service@account.net" \ --target-service-accounts="service@account.net" \ --rules tcp:9001 |
Instead of source-range, it’s using source-service-accounts.
How to create a swap file.
A 2GB swap file.
dd if=/dev/zero of=/swapfile bs=1k count=2048k |
Activate.
mkswap /swapfile chmod 0600 /swapfile systemctl daemon-reload swapon /swapfile |
To make swap permanent, add to /etc/fstab.
/swapfile swap swap defaults 0 0 |
Check if swap is working.
cat /proc/swaps free -h |