Uly.me

cloud engineer

apt

Database Clients on Linux

You can run database clients on your Linux distro by installing them.

MySQL

$ yum install mysql
$ apt install mysql

Postgress

$ yum install postgresql postgresql-client
$ apt install postgresql postgresql-client

MSSQL

$ yum install mysql-tools
$ apt install mssql-tools

Apt Locked Files

If you tried to run apt update and you get this error, try the following.

$ apt update
E: Could not get lock /var/lib/dpkg/lock-frontend - open (11: Resource temporarily unavailable) [duplicate]

Kill the process.

$ sudo killall apt apt-get

If that doesn’t work, remove the locked files.

$ sudo rm /var/lib/apt/lists/lock
$ sudo rm /var/cache/apt/archives/lock
$ sudo rm /var/lib/dpkg/lock*

Run apt update again.

Ubuntu Speedtest

Install Speedtest CLI.

sudo apt-get install gnupg1 apt-transport-https dirmngr
export INSTALL_KEY=379CE192D401AB61
sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys $INSTALL_KEY
echo "deb https://ookla.bintray.com/debian generic main" | sudo tee  /etc/apt/sources.list.d/speedtest.list
sudo apt-get update
sudo apt-get install speedtest

To run.

speedtest

Result.

$ speedtest
   Speedtest by Ookla
     Server: City of Columbus - Columbus, OH (id = 40410)
        ISP: Spectrum
    Latency:     9.39 ms   (0.63 ms jitter)
   Download:   117.74 Mbps (data used: 60.3 MB)                               
     Upload:    11.81 Mbps (data used: 5.6 MB)                               
Packet Loss:     0.0%
 Result URL: https://www.speedtest.net/result/c/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxxx (redacted)

Google SDK Install on Debian or Ubuntu

Here’s the script.

echo "deb [signed-by=/usr/share/keyrings/cloud.google.gpg] \
  https://packages.cloud.google.com/apt cloud-sdk main" | \
  sudo tee -a /etc/apt/sources.list.d/google-cloud-sdk.list
sudo apt-get install apt-transport-https ca-certificates
sudo curl https://packages.cloud.google.com/apt/doc/apt-key.gpg | \
  sudo apt-key --keyring /usr/share/keyrings/cloud.google.gpg add -
sudo apt-get update && sudo apt-get install google-cloud-sdk

Sublime Text 3

Looking for a text editor for editing code? Check out Sublime Text 3. You can install the text editor using several package managers depending on your Linux distro. There’s apt, yum, zypper, pacman and dnf. Here’s the Apt install of Sublime Text 3.

echo "deb https://download.sublimetext.com/ apt/stable/" | sudo tee /etc/apt/sources.list.d/sublime-text.list
sudo apt-get update
sudo apt-get install sublime-text