Install Docker and Portainer inside Debian LXC inside Proxmox

Start with a base Debian server, then update sources repository:
apt-get update

Installing pre-requisites:
apt-get install ca-certificates
apt-get install curl
apt-get install gnupg
apt-get install lsb-release

Get the official Docker GPG key:
curl -fsSL https://download.docker.com/linux/debian/gpg | gpg --dearmor -o /usr/share/keyrings/docker-archive-keyring.gpg

Add the Docker Repository to the sources.list.d directory:

echo \

  "deb [arch=$(dpkg --print-architecture) signed-by=/usr/share/keyrings/docker-archive-keyring.gpg] https://download.docker.com/linux/debian \

  $(lsb_release -cs) stable" | tee /etc/apt/sources.list.d/docker.list > /dev/null

apt-get update

Install Docker Engine:

apt-get install docker-ce docker-ce-cli

apt-get install containerd.io

Install Portainer:
apt-get install docker.io

Enable (as part of start-up sequence) and Start Docker:
systemctl enable docker

systemctl start docker
systemctl status docker

Download, Install and Run Portainer:
docker run -d \
--name="portainer" \
--restart on-failure \
-p 9000:9000 \
-p 8000:8000 \
-v /var/run/docker.sock:/var/run/docker.sock \
-v portainer_data:/data \
portainer/portainer-ce:latest




Debian Server initial setup commands

Each time I setup a new Debian Server, I always do the same initial commands.  These commands will set the locale, date & time and base softwares.

SETTING LOCALE

dpkg-reconfigure locales


SETTING TIMEZONE

timedatectl
timedatectl list-timezones
timedatectl set-timezone Region/Location

for example: timedatectl set-timezone America/Chicago


UPDATING APT

apt-get update


UPGRADING OPERATING SYSTEM

apt-get upgrade

reboot

apt-get dist-upgrade


INSTALLING BUILD ESSENTIAL

apt-get install build-essential
apt-get install software-properties-common

How to install Ubuntu LXC Container with Desktop GUI

This guide will help you install Ubuntu desktop GUI from a Proxmox Standard Ubuntu 22.04 container template.

Start with updating APT

# apt update

Edit APT sources list with this (you may need to change jammy to your version code name)

# nano /etc/apt/sources.list

deb http://archive.ubuntu.com/ubuntu/ jammy main restricted universe multiverse
deb-src http://archive.ubuntu.com/ubuntu/ jammy main restricted universe multiverse
deb http://archive.ubuntu.com/ubuntu/ jammy-updates main restricted universe multiverse
deb-src http://archive.ubuntu.com/ubuntu/ jammy-updates main restricted universe multiverse
deb http://archive.ubuntu.com/ubuntu/ jammy-security main restricted universe multiverse
deb-src http://archive.ubuntu.com/ubuntu/ jammy-security main restricted universe multiverse
deb http://archive.ubuntu.com/ubuntu/ jammy-backports main restricted universe multiverse
deb-src http://archive.ubuntu.com/ubuntu/ jammy-backports main restricted universe multiverse
deb http://archive.canonical.com/ubuntu jammy partner
deb-src http://archive.canonical.com/ubuntu jammy partner

Update again

# apt update

Install XFCE & X11

# apt install xfce4 xfce4-goodies xorg dbus-x11 x11-xserver-utils

Install XRDP (so we can remote control using RDP)

# apt install xrdp

Make sure XRDP is installed and running

# systemctl status xrdp

Set which X-Session should be use

# update-alternatives --set x-session-manager /usr/bin/xfce4-session

Reboot and Test

# update-alternatives --set x-session-manager /usr/bin/xfce4-session

MySQL command to export CSV file from SQL query

Here is the command to export a particular MySQL table to CSV file:

Here is the syntax:

mysql -u root -p 123password123 -D mydatabase -e "SELECT * FROM product WHERE edu_price > 0 INTO OUTFILE '/tmp/edu.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY 'n';"

Break down details of the individual options:

-u (user)

-p (password)

-D (database)

 -e (execute command)

after the query add the following SQL Command:

INTO OUTFILE '/path/filename.csv'

FIELDS TERMINATED BY ','

ENCLOSED BY '"'

LINES TERMINATED BY 'n';

---------------

Please make sure to add ';' (semicolon) at the end of the MySQL command to end the SQL command.

How to execute MySQL command from command line

 Being able to execute a MySQL command from command line or from a Shell Script is very useful sometime.  A good example would be to schedule a particular MySQL SQL command to be executed in crontab.

Here is the syntax:

mysql -u root -p 123password123 -D mydatabase -e "SELECT * FROM product WHERE edu_price > 0 INTO OUTFILE '/tmp/edu.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY 'n';"

Break down details of the individual options:

-u (user)

-p (password)

-D (database)

 -e (execute command)

How to fix "The method driver /usr/lib/apt/methods/https could not be found."

ISSUE:

apt-get update

E: The method driver /usr/lib/apt/methods/https could not be found.

N: Is the package apt-transport-https installed?

HOW TO FIX:

cd /usr/lib/apt/methods; ln -s http https

TEST CONFIRM FIXED:

apt-get update

How to fix missing files / packages during apt-get for Ubuntu 12.04 LTS

Are you getting these errors?

W: Failed to fetch http://archive.ubuntu.com/ubuntu/dists/precise/main/binary-amd64/Packages  404  Not Found [IP: 91.189.88.142 80]

W: Failed to fetch http://archive.ubuntu.com/ubuntu/dists/precise/restricted/binary-amd64/Packages  404  Not Found [IP: 91.189.88.142 80]

W: Failed to fetch http://archive.ubuntu.com/ubuntu/dists/precise/universe/binary-amd64/Packages  404  Not Found [IP: 91.189.88.142 80]

W: Failed to fetch http://archive.ubuntu.com/ubuntu/dists/precise/main/binary-i386/Packages  404  Not Found [IP: 91.189.88.142 80]

W: Failed to fetch http://archive.ubuntu.com/ubuntu/dists/precise/restricted/binary-i386/Packages  404  Not Found [IP: 91.189.88.142 80]

W: Failed to fetch http://archive.ubuntu.com/ubuntu/dists/precise/universe/binary-i386/Packages  404  Not Found [IP: 91.189.88.142 80]

SOLUTION

Try changing the domain names in /etc/apt/sources.list from 

archive.ubuntu.com

security.ubuntu.com

to 

old-releases.ubuntu.com

FINAL RESULT

Example content of /etc/apt/sources.list:

deb http://old-releases.ubuntu.com/ubuntu precise main restricted universe

deb http://old-releases.ubuntu.com/ubuntu precise-updates main restricted universe

deb http://old-releases.ubuntu.com/ubuntu precise-security main restricted universe multiverse

deb http://old-releases.canonical.com/ubuntu precise partner