04 Jan

Install ONLYOFFICE Docs on Ubuntu 20.04

by kayals
in Linux, System Administration
Comments

To install ONLYOFFICE Docs on Ubuntu 20.04, you can follow these steps: Add the ONLYOFFICE repository to your system: Copy code echo "deb http://download.onlyoffice.com/repo/debian squeeze main" | sudo tee/etc/apt/sources.list.d/onlyoffice.list Install the public GPG key: Copy code sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys CB2DE8E5 Update the package index: Copy code sudo apt update Install ONLYOFFICE Docs: Copy code sudo apt install onlyoffice-documentserver After the installation is complete, open your web browser and go to...

Read More
terraform
18 Jan

Install Terraform on Ubuntu 20.x

by kayals
in Docker, Linux, System Administration
Comments

sudo apt-get update && sudo apt-get install -y gnupg software-properties-common curl curl -fsSL https://apt.releases.hashicorp.com/gpg | sudo apt-key add - sudo apt-add-repository "deb [arch=amd64] https://apt.releases.hashicorp.com $(lsb_release -cs) main" sudo apt-get update && sudo apt-get install terraform Verify the installation terraform -help Enable tab completion touch ~/.bashrc OR touch ~/.zshrc Install the autocomplete package terraform -install-autocomplete...

Read More
linux
28 Dec

Add static routes to Ubuntu under Netplan

by kayals
in Linux, System Administration
Comments

If you're on the 10.40.24.0 network, the route target would be 10.40.24.250. If you're on the 10.40.28.0 network, it's 10.40.28.250, and so on. The 10.40.28.0 network is used in this experiment.   Edit the /etc/netplan/01-netcfg.yaml file. Here is an example from skayal.com. network: version: 2 renderer: networkd ethernets: eth0: addresses: [ 10.40.28.108/24 ] gateway4: 10.40.28.1 nameservers: search: [ skayal.com ] addresses: - 208.82.128.10 - 208.82.128.2 routes: - to: 10.10.0.0/16 via: 10.40.28.250 - to: 10.20.0.0/16 via: 10.40.28.250   Save your changesnetplan tryYou should see the routes...

Read More
mysql
30 Nov

Forcing innodb recovery of a corrupted database

by kayals
in Linux, MySQL
Comments

* Take dump of all databases:
# mysqldump --skip-lock-tables -A > alldb.sql * * Check where MySQL keeps its files(in my case it's /var/lib/mysql/):
# mysql -NBe "SELECT @@datadir" * /var/lib/mysql/ * * Stop MySQL
# mysqladmin shut * * Move old MySQL files to safe place 
# mv /var/lib/mysql /var/lib/mysql.old * * Create new system database
# mkdir /var/lib/mysql * # sudo apt-get install mysql-server * * Start MySQL
# /etc/init.d/mysql start * * Restore the dump
#...

Read More
mariadb
20 Jul

Upgrading MariaDB from 10.0 to 10.1 to 10.2 on Ubuntu 16.04 / 17.10

by kayals
in Linux, System Administration
Comments

Prepare MariaDB for Upgrade To prepare MariaDB for Upgrade, logon to the database server as root with the root password and run the commands below sudo mysql -u root -p Then run the commands below to set innodb_fast_shutdown to 0 mysql> SET GLOBAL innodb_fast_shutdown = 0; Backup Your Databases It’s always important to backup your databases before attempting to upgrade To back up, run the commands below against each database you wish...

Read More
cli
08 Jul

How to Enable Apache Mod_Rewrite on Ubuntu

by kayals
in Linux, System Administration
Comments

Enable mod_rewrite Enable any Apache module using the a2enmod command. Command below on your Ubuntu server: $ sudo a2enmod rewrite In case the module is already enabled on your server, you will get an alert message. Restart Apache once you make any change to its configuration. Type the command below on a terminal window: $ sudo systemctl restart apache2 Server is now ready to accept rewrite rules.     ...

Read More
linux
29 May

How To Install Linux, Apache, MySQL, PHP (LAMP) stack on Ubuntu 18.04

by kayals
in System Administration
Comments

Introduction A "LAMP" stack is a group of open-source software that is typically installed together to enable a server to host dynamic websites and web apps. This term is actually an acronym which represents the Linux operating system, with the Apache web server. The site data is stored in a MySQL database, and dynamic content is processed by PHP. In this guide, we will install a LAMP...

Read More
letsencrypt
02 Apr

Lets Encrypt Certs on Multiple Apache Virtual Hosts- Ubuntu

by kayals
in System Administration
Comments

OPTIONAL - Install software-properties-common # apt-get install software-properties-common Step 1 — Download the Let’s Encrypt Client # sudo add-apt-repository ppa:certbot/certbot # apt-get update # apt-get install python-certbot-apache Step 2 — Set Up the Certificates Generating the first SSL certificate # sudo certbot --apache -d skayal.com   Generating the second SSL certificate # sudo certbot --apache -d test.com -d www.test.com Step 3 — Set Up Auto-Renewal # sudo crontab -e Add 15 3 * * * /usr/bin/certbot renew --quiet Verify status...

Read More
apache2
21 Mar

How to uninstall and remove Apache2 on Ubuntu or Debian

by kayals
in System Administration
Comments

$ sudo service apache2 stop Then uninstall Apache2 and its dependent packages. Use purge option instead of remove with apt-get command. The former option will try to remove dependent packages, as well as any configuration files created by them. In addition, use autoremove option as well, to remove any other dependencies that were installed with Apache2, but are no longer used by any other package. $ sudo...

Read More
mariadb
21 Mar

How to install MariaDB 10.3 on Ubuntu 18.04 and CentOS 7

by kayals
in System Administration
Comments

Before you can install MariaDB 10.3, you may need to uninstall the current version of MariaDB server. You can ignore this if upgrading.  On Ubuntu, run: sudo apt-get remove mariadb-server For CentOS 7, run: sudo yum remove mariadb-server Install MariaDB 10.3 on Ubuntu 18.04 To install MariaDB 10.3 on Ubuntu 18.04, you need to add MariaDB repository on to the system. Step 1: Install software-properties-common if missing: sudo apt-get install software-properties-common Step 2: Import MariaDB gpg key: Run...

Read More