Ebta Setiawan ebta

Installing docker on Ubuntu 20.04 / 22.04

Full reference here: https://docs.docker.com/engine/install/ubuntu/

Setup the repository

sudo apt-get update
sudo apt-get install apt-transport-https ca-certificates curl gnupg lsb-release

Add Docker’s official GPG key:

Installing MySQL

Update the package index on your server

sudo apt update && sudo apt upgrade -y

Install MySQL Server

sudo apt install mysql-server

Configuring MySQL

MySQL 5.6 + adminer

Example docker compose save as ex. mysql-5.6-adminer.yml

version: '3.1'
services:
  db56:
    image: mysql:5.6
    command: --default-authentication-plugin=mysql_native_password
    restart: always
 environment:

Stop your databases

service mysqld stop

Modify /etc/my.cnf file add skip-grant-tables

sudo nano /etc/my.cnf

Add skip-grant-tables in [mysqld] section

Codeigniter 3 server configuration for Nginx & Apache

Web Server Site Configuration

Recommended Apache Configuration

Use the following configuration in Apache's httpd.conf file or within a virtual host configuration. Note that you should set DocumentRoot and ServerName fit to your environment:

Cronjob Check

Referensi: https://askubuntu.com/a/85560

Do not redirect error output to /dev/null and grep /var/log/syslog for cron output.

grep cron /var/log/syslog

You can immediately show errors when saving a file after editing /etc/crontab or files inside /etc/cron.d/ with:

tail -f /var/log/syslog | grep --line-buffered cron

1. Update your system

First, run the apt command to apply security updates:

sudo apt update
sudo apt upgrade

2. Download and run openvpn-install.sh script

DOwnload installation script using short url as follow and update chmod :

wget https://git.io/vpn -O openvpn-ubuntu-install.sh

Custom format for displaying bytes as kb, mb, gb or tb.

Response to a few places on the internet: https://productforums.google.com/forum/#!topic/docs/x_T_N-yRUYg And here: https://stackoverflow.com/questions/1533811/how-can-i-format-bytes-a-cell-in-excel-as-kb-mb-gb-etc

Here is one that I have been using:

[<1000000]0.00," KB";[<1000000000]0.00,," MB";0.00,,," GB"

	#!/bin/sh
	# Simple script to update a WordPress install (core, plugins, themes and languages) using wp-cli.
	# Usually we expect to run this from cron.
	# Written by Kitson Consulting and released into the public domain.

	if [ $# -ne 1 ]
	then
	echo "Usage: $0 </path/to/wordpress/install>" >&2
	exit 1
	fi

	# Save this file ex. /etc/systemd/system/myapp.service
	# then run using: systemctl <start\|status\|restart\|stop\|enable> myapp

	[Unit]
	Description=My PHP APP Service
	# May your script needs MySQL or other services to run, eg. MySQL Memcached
	Requires=mysqld.service memcached.service
	After=mysqld.service memcached.service

	[Service]