How To Install PgAdmin 4 v4.5 on Ubuntu 18.04 LTS

Install PgAdmin on Ubuntu 18

PgAdmin is the leading graphical Open Source management, development and administration tool for PostgreSQL.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation PgAdmin on a Ubuntu 18.04 (Bionic Beaver) server.

Install PgAdmin on Ubuntu 18.04 LTS

Step 1. First make sure that all your system packages are up-to-date

sudo apt-get update
sudo apt-get upgrade

Step 2. Install Dependencies Packages.

First need to install the basic packages:

sudo apt-get install build-essential libssl-dev libffi-dev libgmp3-dev virtualenv python-pip libpq-dev python-dev

Step 3. Create the virtual environment.

Create the virtual enviroment:

virtualenv .pgadmin4

Next, Activate the virtual enviroment:

cd .pgadmin4
source bin/activate

Step 4. Installing PGAdmin 4 on Ubuntu 18.04 LTS.

Use the following command to download PgAdmin Python wheel:

wget https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v3.1/pip/pgadmin4-3.1-py2.py3-none-any.whl

Install PgAdmin 4 using the following command:

pip install pgadmin4-3.1-py2.py3-none-any.whl

Step 5. Configure PGAdmin 4.

Write the SERVER_MODE = False in lib/python2.7/site-packages/pgadmin4/config_local.py to configure to run in single-user mode:

echo "SERVER_MODE = False" >> lib/python2.7/site-packages/pgadmin4/config_local.py

Once you finished the configuration, use the following command to run PgAdmin 4:

python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py

Step 6. Access PgAdmin.

Once the installer finishes installing, it will show you the url, Username and Password. Just open that url in web browser and login using the username and password.

http://ip.add.re.ss:5050

Congratulation’s! You have successfully installed PgAdmin. Thanks for using this tutorial for installing PgAdmin in Ubuntu 18.04 LTS Bionic Beaver system. For additional help or useful information, we recommend you to check the official PgAdmin web site.

How To Install MariaDB 10.3.14 on Ubuntu 18.04 LTS

MariaDB

MariaDB is a an open source and cross-platform database engine and server, designed as a drop-in replacement for the well known and powerful MySQL database engine used on numerous web servers around the world. The application is geared toward database professionals that are in search of a scalable, robust, reliable and stable SQL server, a replacement for the MySQL database server.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation MariaDB in Ubuntu 18.04 LTS Bionic Beaver.

Install MariaDB on Ubuntu 18.04 LTS

Step 1. First make sure that all your system packages are up-to-date

apt-get update
apt-get upgrade

Step 2. Installing MariaDB on Ubuntu 18.04 LTS.

Installing MariaDB is as simple as running just one command below:

sudo apt install mariadb-server mariadb-client

If you want to install MariaDB 10.x Which is not included in distribution repository. We going to add MariaDB repo to our system:

sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
sudo add-apt-repository 'deb [arch=amd64] http://mirror.zol.co.zw/mariadb/repo/10.3/ubuntu bionic main'

Once the key is imported and the repository added you can install MariaDB with:

sudo apt update
sudo apt install mariadb-server mariadb-client

Once complete, you can verify MariaDB is installed by running the below command:

systemctl stop mariadb.service
systemctl start mariadb.service
systemctl enable mariadb.service

Step 3. Securing MariaDB after installation.

By default, MariaDB is not hardened. You can secure MariaDB using the mysql_secure_installation script. you should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MariaDB:

mysql_secure_installation

Configure it like this:

- Set root password? [Y/n] y
- Remove anonymous users? [Y/n] y
- Disallow root login remotely? [Y/n] y
- Remove test database and access to it? [Y/n] y
- Reload privilege tables now? [Y/n] y

To log into MariaDB, use the following command (note that it’s the same command you would use to log into a MySQL database):

mysql -u root -p

Congratulation’s! You have successfully installed MariaDB. Thanks for using this tutorial for installing MariaDB in Ubuntu 18.04 LTS (Bionic Beaver) system. For additional help or useful information, we recommend you to check the official MariaDB web site.

How To Install Bower 1.8.8 on Ubuntu 18.04 LTS

Install Bower on Ubuntu 18

Bower manages the components for a website like frameworks, libraries, assets, and utilities. It keeps track all the components and checks regularly for their updates. Bower uses a manifest file bower.json file to keep track of packages.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation Bower on a Ubuntu 18.04 (Bionic Beaver) server.

Install Bower on Ubuntu 18.04 LTS

Step 1. First make sure that all your system packages are up-to-date

sudo apt-get update
sudo apt-get upgrade

 

Step 2. Installing Install Node.js.

First of all, you need to install node.js on your system:

sudo apt-get install python-software-properties
curl -sL https://deb.nodesource.com/setup_8.x | sudo -E bash -
sudo apt-get install nodejs

Step 3. Installing Bower on Ubuntu 18.04 LTS.

Install Bower using NPM:

sudo npm install -g bower

Let’s check the installed version of bower on your system using following command:

bower --version

1.8.2

Install packages with bower install:

bower install <package>

A package can be a GitHub shorthand, a Git endpoint, a URL, and more:

# installs the project dependencies listed in bower.json
bower install
# registered package
bower install jquery
# GitHub shorthand
bower install desandro/masonry
# Git endpoint
bower install git://github.com/user/package.git
# URL
bower install http://example.com/script.js

Congratulation’s! You have successfully installed Bower. Thanks for using this tutorial for installing Bower in Ubuntu 18.04 LTS Bionic Beaver system. For additional help or useful information, we recommend you to check the official Bower web site.

How To Install Chamilo LMS 1.11.8 on Ubuntu 18.04 LTS

Install Chamilo on Ubuntu 18

Chamilo is an open-source (under GNU/GPL licensing) e-learning and content management system, aimed at improving access to education and knowledge globally. It is backed up by the Chamilo Association, which has goals including the promotion of the software, the maintenance of a clear communication channel and the building of a network of services providers and software contributors. The Chamilo project aims at ensuring the availability and quality of education at a reduced cost, through the distribution of its software free of charge, the improvement of its interface for 3rd world countries devices portability and the provision of a free access public e-learning campus.

This article assumes you have at least basic knowledge of linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation Chamilo on a Ubuntu 18.04 (Bionic Beaver) server.

Install Chamilo on Ubuntu 18.04 LTS

Step 1. First make sure that all your system packages are up-to-date

sudo apt-get update
sudo apt-get upgrade

Step 2. Install LAMP (Linux, Apache, MariaDB and PHP) server.

A Ubuntu 18.04 LAMP server is required. If you do not have LAMP installed, you can follow our guide here. Also install all required PHP modules:

apt-get install php7.1-cli php7.1-gd php7.1-opcache php7.1-mysql php7.1-json php7.1-mcrypt php7.1-xml php7.1-curl

You’ll need to also adjust some settings in your php.ini. Open up the file and edit these two variables:

nano /etc/php/7.1/apache2/php.ini

Also, add/modify the following settings:

date.timezone = 'America/New_York'
max_execution_time = 300
max_input_time = 600
memory_limit = 256M
post_max_size = 100M
upload_max_filesize = 100M
short_open_tag = Off
safe_mode = Off
magic_quotes_gpc = Off
magic_quotes_runtime = Off
session.cookie_httponly = On
extension = xapian.so

Step 3. Installing Chamilo on Ubuntu 18.04 LTS.

First thing to do is to go to Chamilo’s download page and download the latest stable version of Chamilo, At the moment of writing this article it is version 1.10:

wget https://github.com/chamilo/chamilo-lms/releases/download/v1.11.6/chamilo-1.11.6-php7.zip

Unpack the Chamilo archive to the document root directory on your server:

unzip chamilo-1.11.6-php7.zip -d /var/www/html/

We will need to change some folders permissions:

chown -R www-data: /var/www/html/

Step 4. Configuring MariaDB for Chamilo.

By default, MariaDB is not hardened. You can secure MariaDB using the mysql_secure_installation script. you should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MariaDB:

mysql_secure_installation

Configure it like this:

- Set root password? [Y/n] y
- Remove anonymous users? [Y/n] y
- Disallow root login remotely? [Y/n] y
- Remove test database and access to it? [Y/n] y
- Reload privilege tables now? [Y/n] y

Next we will need to log in to the MariaDB console and create a database for the Chamilo. Run the following command:

mysql -u root -p

This will prompt you for a password, so enter your MariaDB root password and hit Enter. Once you are logged in to your database server you need to create a database for Chamilo installation:

CREATE DATABASE chamilodb;
CREATE USER 'chamilouser'@'localhost' IDENTIFIED BY 'Pa$$worD123';
GRANT ALL PRIVILEGES ON chamilodb.* TO 'chamilouser'@'localhost';
FLUSH PRIVILEGES;
quit

Step 5. Configuring Apache web server for Chamilo.

Create a new virtual host directive in Apache. For example, create a new Apache configuration file named ‘chamilo.conf’ on your virtual server:

touch /etc/apache2/sites-available/chamilo.conf
ln -s /etc/apache2/sites-available/chamilo.conf /etc/apache2/sites-enabled/chamilo.conf
nano /etc/apache2/sites-available/chamilo.conf

Add the following lines:

<VirtualHost *:80>
ServerAdmin [email protected]
DocumentRoot /var/www/html
ServerName your-domain.com
ServerAlias www.your-domain.com
<Directory /var/www/html/>
Options FollowSymLinks
AllowOverride All
</Directory>
ErrorLog /var/log/apache2/your-domain.com-error_log
CustomLog /var/log/apache2/your-domain.com-access_log common

Save and close the file. Restart the apache service for the changes to take effects:

a2ensite chamilo.conf
a2enmod rewrite
systemctl restart apache2

Step 6. Accessing Chamilo.

Chamilo will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://yourdomain.com/ or http://server-ip/ and complete the required the steps to finish the installation. If you are using a firewall, please open port 80 to enable access to the control panel.
chamilo_ubuntu_install

Congratulation’s! You have successfully installed Chamilo. Thanks for using this tutorial for installing Chamilo e-learning and content management system on your Ubuntu 18.04 LTS (Bionic Beaver) system. For additional help or useful information, we recommend you to check the official Chamilo web site.

How To Install BlogoText CMS on Ubuntu 18.04 LTS

Install BlogoText CMS on Ubuntu 18

BlogoText is an open source, lightweight, web publishing platform (CMS) for creating minimalist blogs and websites.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation BlogoText CMS on a Ubuntu 18.04 (Bionic Beaver) server.

BlogoText features:

    • Blog with comments and RSS feeds
    • Links sharing
    • RSS Reader
    • Images/Files uploading and sharing
    • JSON/ZIP/HTML import-export; WordPress import
    • Support Addons

Install BlogoText CMS on Ubuntu 18.04 LTS

Step 1. First make sure that all your system packages are up-to-date

sudo apt-get update
sudo apt-get upgrade

Step 2. Install LAMP (Linux, Apache, MariaDB and PHP) server.

A Ubuntu 18.04 LAMP server is required. If you do not have LAMP installed, you can follow our guide here. Also install all required PHP modules:

apt-get install php7.1-cli php7.1-mbstring php7.1-gd php7.1-opcache php7.1-mysql php7.1-json php7.1-mcrypt php7.1-xml php7.1-curl

You’ll need to also adjust some settings in your php.ini. Open up the file and edit these two variables:

nano /etc/php/7.1/apache2/php.ini

Also, add/modify the following settings:

date.timezone = 'America/New_York'
file_uploads = On
allow_url_fopen = On
short_open_tag = On
memory_limit = 256M
upload_max_filesize = 100M
max_execution_time = 360

Step 3. Installing BlogoText CMS on Ubuntu 18.04 LTS.

First thing to do is to go to BlogoText’s download page and download the latest stable version of BlogoText, At the moment of writing this article it is version 3.7:

https://github.com/BlogoText/blogotext/archive/3.7.6.zip
unzip 3.7.6.zip
sudo mv blogotext-3.7.6 /var/www/html/blogotext

We will need to change some folders permissions:

chown -R www-data:www-data /var/www/html/blogotext/
chmod -R 755 /var/www/html/blogotext/

Step 4. Configuring MariaDB for BlogoText CMS.

By default, MariaDB is not hardened. You can secure MariaDB using the mysql_secure_installation script. you should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MariaDB:

mysql_secure_installation

Configure it like this:

- Set root password? [Y/n] y
- Remove anonymous users? [Y/n] y
- Disallow root login remotely? [Y/n] y
- Remove test database and access to it? [Y/n] y
- Reload privilege tables now? [Y/n] y

Next we will need to log in to the MariaDB console and create a database for the BlogoText CMS. Run the following command:

mysql -u root -p

This will prompt you for a password, so enter your MariaDB root password and hit Enter. Once you are logged in to your database server you need to create a database for BlogoText CMS installation:

CREATE DATABASE chamilodb;
CREATE USER 'chamilouser'@'localhost' IDENTIFIED BY 'Pa$$worD123';
GRANT ALL PRIVILEGES ON chamilodb.* TO 'chamilouser'@'localhost';
FLUSH PRIVILEGES;
quit

Step 5. Configuring Apache web server for BlogoText CMS.

Create a new virtual host directive in Apache. For example, create a new Apache configuration file named ‘blogotext.conf’ on your virtual server:

touch /etc/apache2/sites-available/blogotext.conf
ln -s /etc/apache2/sites-available/blogotext.conf /etc/apache2/sites-enabled/blogotext.conf
nano /etc/apache2/sites-available/blogotext.conf

Add the following lines:

<VirtualHost *:80>
ServerAdmin [email protected]
DocumentRoot /var/www/html/blogotext
ServerName your-domain.com
ServerAlias www.your-domain.com
<Directory /var/www/html/blogotext/>
Options FollowSymLinks
AllowOverride All
</Directory>
ErrorLog /var/log/apache2/your-domain.com-error_log
CustomLog /var/log/apache2/your-domain.com-access_log common

Save and close the file. Restart the apache service for the changes to take effects:

a2ensite blogotext.conf
a2enmod rewrite
systemctl restart apache2

BlogoText will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://your-domain.com/ or http://server-ip/ and complete the required the steps to finish the installation. If you are using a firewall, please open port 80 to enable access to the control panel.

blogotext-install

Congratulation’s! You have successfully installed BlogoText CMS. Thanks for using this tutorial for installing BlogoText content management system on your Ubuntu 18.04 LTS (Bionic Beaver) system. For additional help or useful information, we recommend you to check the official BlogoText web site.

How To Install FFmpeg 4.1.3.tar.bz2 on Ubuntu 18.04 LTS

FFmpeg

FFmpeg is a cross-platform solution for streaming audio and video as well as recording and conversion. There’s also a great PHP package called ffmpeg-php that allows for easy use of FFmpeg from inside PHP scripts. In this tutorial i will show you the easy way to install ffmpeg and ffmpeg-php (php extension).

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation FFmpeg on an Ubuntu 18.04 Bionic Beaver server.

Install FFmpeg on Ubuntu 18.04 LTS

Step 1. First make sure that all your system packages are up-to-date

sudo apt-get update
sudo apt-get upgrade

Step 2. Installing FFmpeg on Ubuntu 18.04 LTS.
Method 1. Install FFmpeg using PPA:

You’ll need to add FFmpeg’s PPA (personal package archive) to your system:

sudo add-apt-repository ppa:jonathonf/ffmpeg-3
sudo apt update
sudo apt install ffmpeg libav-tools x264 x265

Method 2. Install FFmpeg using default repository Ubuntu:

Install FFmpeg on Ubuntu is to use the apt command:

sudo apt install ffmpeg

To check for a installed ffmpeg version run:

### ffmpeg -version
ffmpeg version 3.4.2-1build1 Copyright (c) 2000-2018 the FFmpeg developers

Congratulation’s! You have successfully installed FFmpeg. Thanks for using this tutorial for installing FFmpeg on your Ubuntu 18.04 LTS Bionic Beaver. For additional help or useful information, we recommend you to check the official FFmpeg web site.

How To Install Let’s Encrypt SSL for Nginx on Ubuntu 18.04 LTS

Install Let’s Encrypt SSL for Nginx on Ubuntu 18

Let’s Encrypt is a free open certificate authority (CA) that provides free certificates for websites and other services. The service, which is backed by the Electronic Frontier Foundation, Mozilla, Cisco Systems, and Akamai. Unfortunately, LetsEncrypt.org certificates currently have a 3 month lifetime. This means you’ll need to renew your certificate quarterly for now.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation Let’s Encrypt SSL for Nginx on Ubuntu 18.04 LTS server.

Install Let’s Encrypt SSL for Nginx on Ubuntu 18.04 LTS

Step 1. First make sure that all your system packages are up-to-date

apt-get update
apt-get upgrade

Step 2. Installing Let’s Encrypt SSL on Ubuntu 18.04 LTS.

First, Add certbot to the repository:

sudo add-apt-repository ppa:certbot/certbot
sudo apt update
sudo apt install python-certbot-nginx

Step 3. Setup Domain Name to Server Block.

Certbot automates the configuration of SSL for Nginx by looking for the server_name directive that matches the domain you’re requesting a certificate for. If you have already configured the server_name directive previously, you can skip to Step 4.

Step 4. Generate Certs using Certbot.

First, We can now generate certs using certbot. Replace intanramona.net with your own domain:

sudo certbot --nginx -d intanramona.net -d www.intanramona.net

Enter an email address where you can be contacted in case of urgent renewal and security notices:

Please read the Terms of Service at
https://letsencrypt.org/documents/LE-SA-v1.2-November-15-2017.pdf. You must
agree in order to register with the ACME server at
https://acme-v01.api.letsencrypt.org/directory
-------------------------------------------------------------------------------
(A)gree/(C)ancel:

Press a and ENTER to agree to the Terms of Service:

Would you be willing to share your email address with the Electronic Frontier
Foundation, a founding partner of the Let's Encrypt project and the non-profit
organization that develops Certbot? We'd like to send you email about EFF and
our work to encrypt the web, protect its users and defend digital rights.
-------------------------------------------------------------------------------
(Y)es/(N)o:

Press n and ENTER to not share your email address with EFF:

Obtaining a new certificate
Performing the following challenges:
http-01 challenge for intanramona.net
http-01 challenge for www.intanramona.net
Waiting for verification...
Cleaning up challenges
Deploying Certificate to VirtualHost /etc/nginx/sites-enabled/default
Deploying Certificate to VirtualHost /etc/nginx/sites-enabled/default

If successful, you will be able to choose between enabling both http and https access or forcing all requests to redirect to https:

Please choose whether or not to redirect HTTP traffic to HTTPS, removing HTTP access.
-------------------------------------------------------------------------------
1: No redirect - Make no further changes to the webserver configuration.
2: Redirect - Make all requests redirect to secure HTTPS access. Choose this for
new sites, or if you're confident your site works on HTTPS. You can undo this
change by editing your web server's configuration.
-------------------------------------------------------------------------------
Select the appropriate number [1-2] then [enter] (press 'c' to cancel):

Press 2 and ENTER to redirect HTTP traffic to HTTPS:

Redirecting all traffic on port 80 to ssl in /etc/nginx/sites-enabled/default
Redirecting all traffic on port 80 to ssl in /etc/nginx/sites-enabled/default

-------------------------------------------------------------------------------
Congratulations! You have successfully enabled https://devtest1.com and
https://www.devtest1.com

You should test your configuration at:
https://www.ssllabs.com/ssltest/analyze.html?d=intanramona.net
https://www.ssllabs.com/ssltest/analyze.html?d=www.intanramona.net
-------------------------------------------------------------------------------

IMPORTANT NOTES:
- Congratulations! Your certificate and chain have been saved at:
/etc/letsencrypt/live/intanramona.net/fullchain.pem
Your key file has been saved at:
/etc/letsencrypt/live/intanramona.net/privkey.pem
Your cert will expire on 2018-12-05. To obtain a new or tweaked
version of this certificate in the future, simply run certbot again
with the "certonly" option. To non-interactively renew *all* of
your certificates, run "certbot renew"
- If you like Certbot, please consider supporting our work by:

Donating to ISRG / Let's Encrypt: https://letsencrypt.org/donate
Donating to EFF: https://eff.org/donate-le

Step 5. Setup auto renewal Let’s Encrypt.

Let’s Encrypt certificates are valid for 3 month, they need to be checked for renewal periodically. Certbot will automatically run twice a day and renew any certificate that is within thirty days of expiration:

sudo certbot renew --dry-run

Congratulation’s! You have successfully installed Let’s Encrypt. Thanks for using this tutorial for installing Let’s Encrypt SSL on Ubuntu 18.04 LTS Bionic Beaver system. For additional help or useful information, we recommend you to check the official Let’s Encrypt web site.