How To Install OwnCloud 2.5.4 on Ubuntu 18.04 LTS

Install OwnCloud on Ubuntu 18

OwnCloud is a free and open-source software which enables you to create a private “file-hosting” cloud. OwnCloud is similar to DropBox service with the diference of being free to download and install on your private server. Owncloud made by PHP and backend database MySQL (MariaDB), SQLLite or PostgreSQL. OwnCloud also enables you to easily view and sync address book, calendar events, tasks and bookmarks. You can access it via the good looking and easy to use web interface or install OwnCloud client on your Desktop or Laptop machine (supports Linux, Windows and MacOS).

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 OwnCloud on a Ubuntu 18.04 (Bionic Beaver) server.

Install OwnCloud 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

Step 3. Installing OwnCloud 10 on Ubuntu 18.04 LTS.

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

wget https://download.owncloud.org/community/owncloud-10.0.9.zip
unzip owncloud-10.0.9.zip
sudo mv owncloud /var/www/html/owncloud/

We will need to change some folders permissions:

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

Step 4. Configuring MariaDB for OwnCloud.

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 OwnCloud. 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 OwnCloud installation:

CREATE DATABASE ownclouddb;
CREATE USER 'ownclouduser'@'localhost' IDENTIFIED BY 'YOURPASSWORD';
GRANT ALL ON ownclouddb.* TO 'ownclouduser'@'localhost';
FLUSH PRIVILEGES;
exit

Step 5. Configuring Apache web server for OwnCloud.

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

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

Add the following lines:

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

Now, we can restart Apache web server so that the changes take place:

a2ensite owncloud.conf
a2enmod rewrite
a2enmod headers
a2enmod env
a2enmod dir
a2enmod mime
systemctl restart apache2.service

Step 6. Accessing OwnCloud Configuration.

To configure ownCloud, we will use the web interface. So, go ahead and open up a web browser and point it to http://your-domain.com. You should see a web page like this. Enter username and password for the administrator user account, click on the ‘Advanced options’ hyperlink and enter the data directory (or leave the default setting), then enter database username, database password, database name, host (localhost) and click ‘Finish setup’.
Install-OwnCloud-9-on-Ubuntu-16.04
Install-OwnCloud-9-Ubuntu-16.04
OwnCloud-9-Ubuntu-16.04-Upload
Congratulation’s! You have successfully installed OwnCloud. Thanks for using this tutorial for installing OwnCloud on Ubuntu 18.04 LTS (Bionic Beaver) system. For additional help or useful information, we recommend you to check the official OwnCloud web site.

How To Install Mattermost 5.10.0 on Ubuntu 18.04 LTS

Install Mattermost on Ubuntu 18

Mattermost is an open source, private cloud Slack-alternative. A workplace messaging system for web, PCs and phones, released under the MIT license.

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 Mattermost on a Ubuntu 18.04 LTS (Bionic Beaver) server.

Install Mattermost on Ubuntu 18.04

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

Step 3. Installing Mattermost Server on Ubuntu 18.04 LTS.

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

wget https://releases.mattermost.com/5.1.0/mattermost-5.1.0-linux-amd64.tar.gz

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

tar -xvzf mattermost*.gz
sudo mv mattermost /opt

Next, create a storage directory for file:

sudo mkdir /opt/mattermost/data

Set up a system user and group called mattermost that will run this service, and set the ownership and permissions:

sudo useradd --system --user-group mattermost
sudo chown -R mattermost:mattermost /opt/mattermost
sudo chmod -R g+w /opt/mattermost

Set up the database driver through the /opt/mattermost/config/config.json file. In it, search for “DriverName” and “DataSource” lines and change as follows:

"DriverName": "mysql"
"DataSource": "mattermostuser:new_password_here@tcp(localhost:3306)/mattermost?charset=utf8mb4,utf8&readTimeout=30s&writeTimeout=$""

Step 4. Create a systemd unit for Mattermost.

Create a systemd file for Mattermost, /etc/systemd/system/mattermost.service and, in it, paste the following configuration:

nano /etc/systemd/system/mattermost.service

Add following content:

[Unit]
Description=Mattermost
After=network.target
After=mariadb.service
Requires=mariadb.service

[Service]
Type=notify
ExecStart=/opt/mattermost/bin/mattermost
TimeoutStartSec=3600
Restart=always
RestartSec=10
WorkingDirectory=/opt/mattermost
User=mattermost
Group=mattermost
LimitNOFILE=49152

[Install]
WantedBy=mariadb.service

Next, run the commands below to start Mattermost service:

systemctl daemon-reload
systemctl start mattermost.service
systemctl enable mattermost.service

Step 7. Accessing Mattermost.

Mattermost will be available on HTTP port 8065 by default. Open your favorite browser and navigate to http://your-domain.com:8065 or http://ip-address:8065 and continue to configure Mattermost by entering an email address and creating an account. If you are using a firewall, please open port 8065 to enable access to the control panel.

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

How To Install Shopware 5.5.8 on Ubuntu 18.04 LTS

Install Shopware on Ubuntu 18

Shopware is the next generation of open source e-commerce software made in Germany. Based on bleeding edge technologies like Symfony 2, Doctrine 2 and Zend Framework Shopware comes as the perfect platform for your next e-commerce project. Furthermore Shopware provides an event-driven plugin system and an advanced hook system, giving you the ability to customize every part of the platform.

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 Shopware on a Ubuntu 18.04 LTS (Bionic Beaver) server.

Install Shopware 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

Step 3. Installing Shopware on Ubuntu 18.04 LTS.

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

wget https://github.com/shopware/shopware/archive/v5.4.6.zip
unzip v5.4.6.zip -d /var/www/html
cd /var/www/html/shopware-5.4.6
cp -a * ..

We will need to change some folders permissions:

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

Step 4. Configuring MariaDB for Shopware.

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 Shopware. 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 Shopware installation:

CREATE DATABASE shopware;
GRANT ALL PRIVILEGES ON shopware.* TO 'shopware'@'localhost' IDENTIFIED BY 'strong_password';
FLUSH PRIVILEGES;
\q

Step 5. Configuring Apache web server for Shopware.

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

touch /etc/apache2/sites-available/shopware.conf
ln -s /etc/apache2/sites-available/shopware.conf /etc/apache2/sites-enabled/shopware.conf
nano /etc/apache2/sites-available/shopware.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
Order allow,deny
allow from all
</Directory>
ErrorLog /var/log/apache2/your-domain.com-error_log
CustomLog /var/log/apache2/your-domain.com-access_log common
</VirtualHost>

Now, we can restart Apache web server so that the changes take place:

a2ensite shopware.conf
a2enmod rewrite
systemctl restart apache2.service

Step 6. Accessing Shopware e-commerce.

Shopware 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.

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

How To Install Vsftpd 3.0.3 on Ubuntu 18.04 LTS

Install Vsftpd on Ubuntu 18

FTP stands for “file transfer protocol”, and it allows you to transfer files to a remote computer. The most common FTP server software for Ubuntu is the vsftpd package, which stands for “very secure FTP daemon.” It’s the default FTP package for Ubuntu, and most other Linux distributions as well.

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 OpenLiteSpeed on a Ubuntu 18.04 (Bionic Beaver) server.

Install Vsftpd 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 VSFTPD on Ubuntu 18.04 LTS.

To install VSFTPD, run the following command from your Terminal:

sudo apt install vsftpd

Step 3. Configure VSFTPD.

After it is successfully installed, Let us go ahead and configure:

### nano /etc/vsftpd.conf

Controls whether anonymous logins are permitted or not.
anonymous_enable=NO

# Allow local users to login
local_enable=YES

# Set 'write_enable' to YES in order to allow changes to the filesystem
write_enable=YES

# to enable ASCII uploads (to prevent uploaded scripts etc. from breaking),
# without the DoS risk of SIZE and ASCII downloads. ASCII mangling should be
# on the client anyway..
ascii_upload_enable=YES
ascii_download_enable=YES

# You can set the root directory of the FTP users. if not specified, users' home directory equals FTP home directory
local_root=public_html

Save and close the file. Restart vsftpd service to take effect the changes:

sudo systemctl restart vsftpd
sudo systemctl enable vsftpd

Check if vsftpd service is running or not using command:

sudo systemctl status vsftpd

Sample output:

vsftpd.service - vsftpd FTP server
 Loaded: loaded (/lib/systemd/system/vsftpd.service; enabled; vend
 Active: active (running) since Thu 2018-07-16 17:28:31 IST; 31s a
 Process: 2040 ExecStartPre=/bin/mkdir -p /var/run/vsftpd/empty (co
 Main PID: 2043 (vsftpd)
 Tasks: 1
 Memory: 492.0K
 CPU: 46ms
 CGroup: /system.slice/vsftpd.service
 └─2043 /usr/sbin/vsftpd /etc/vsftpd.conf

Jul 16 17:36:31 ubuntuserver systemd[1]: Starting vsftpd FTP server.
Jul 16 17:36:31 ubuntuserver systemd[1]: Started vsftpd FTP server.
 
Jul1617:36:31ubuntuserversystemd[1]:StartingvsftpdFTPserver.
Jul1617:36:31ubuntuserversystemd[1]:StartedvsftpdFTPserver.

Step 4. Configure Firewall.

In case you have UFW firewall enabled, execute the bellow command to allow incoming traffic to FTP ports:

sudo ufw allow from any to any port 20,21,10000:10100 proto tcp

Step 5. Create FTP User.

We will now create a new user that we will use to log into FTP. In this example, we will create a new user called chedelics:

sudo adduser chedelics

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

How To Install Fork CMS 5.5.2 on Ubuntu 18.04 LTS

Install Fork CMS on Ubuntu 18

Fork CMS is an open source content management system. It comes with an intuitive and user friendly interface. It offers powerful apps and killer themes that helps to make your website more shine.

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 Fork open source content management systems on a Ubuntu 18.04 (Bionic Beaver) server.

Install Fork 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-gd php7.1-opcache php7.1-mysql php7.1-json php7.1-mcrypt php7.1-xml php7.1-curl

Step 3. Installing Fork CMS on Ubuntu 18.04 LTS.

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

wget https://www.fork-cms.com/frontend/files/releases/forkcms-5.3.1.tar.gz
tar -xvzf forkcms-5.3.1.tar.gz
sudo mv forkcms /var/www/html/forkcms

We will need to change some folders permissions:

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

Step 4. Configuring MariaDB for Fork 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 Fork 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 Fork CMS installation:

CREATE DATABASE forkcms;
CREATE USER 'forkcmsuser'@'localhost' IDENTIFIED BY 'new_password_here';
GRANT ALL ON forkcms.* TO 'forkcmsuser'@'localhost' IDENTIFIED BY 'user_password_here' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EXIT;

Step 5. Configuring Apache web server for Fork CMS.

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

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

Add the following lines:

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

Now, we can restart Apache web server so that the changes take place:

a2ensite forkcms.conf
a2enmod rewrite
systemctl restart apache2.service

Step 6. Accessing Fork CMS.

Fork CMS will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://your-domain.com/install.php or http://server-ip/install.php 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.

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

How To Install Zabbix 4.2 on Ubuntu 18.04 LTS

Install Zabbix on Ubuntu 18

Zabbix is an open source monitoring tool that is ideal for monitoring your cloud servers. Zabbix is very flexible, information can be retrieved using HTTP/SNMP or by installing a Zabbix agent on the machines to monitor, and allows a lot of customization.

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 Zabbix in Ubuntu 18.04 LTS Bionic Beaver.

Install Zabbix 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

Step 3. Installing Zabbix on Ubuntu 18.04 LTS.

The latest version of Zabbix Server is 3.4 but the version available on Ubuntu repositories is 3.0. To install version 3.4, you need to add Zabbix repositories for this version:

wget http://repo.zabbix.com/zabbix/3.4/ubuntu/pool/main/z/zabbix-release/zabbix-release_3.4-1+bionic_all.deb
dpkg -i zabbix-release_3.4-1+bionic_all.deb

After adding zabbix apt repository in your system, Now update package lists and install Zabbix using commands:

apt update
apt install -y zabbix-server-mysql zabbix-frontend-php zabbix-agent

Step 4. Zabbix Configuration.

sudo nano /etc/zabbix/zabbix_server.conf

Adjust the following values and make a note of the password you’ve chosen. You’ll need it later too.

DBName=zabbixdb
DBUser=zabbix
DBPassword=your_password_here

Step 5. Configure MariaDB Database for Zabbix.

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 MySQL.

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 Zabbix. 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 the Zabbix software:

create user 'zabbix'@'localhost' identified by 'your_chosen_password_here';
create database zabbixdb;
grant all privileges on zabbixdb.* to 'zabbix'@'localhost';
flush privileges;
exit;

After creating the zabbix database and user we need to import the zabbix initial database using the below commands:

cd /usr/share/doc/zabbix-server-mysql
zcat create.sql.gz | mysql -u root -p zabbixdb

Step 6. Configure Apache web server for Zabbix.

First, we’ll move the Zabbix apache file from the package directory:

sudo cp /usr/share/doc/zabbix-frontend-php/examples/apache.conf /etc/apache2/conf-available/zabbix.conf
sudo a2enconf zabbix.conf
sudo a2enmod alias

We should adjust php timezone as per zabbix recommended settings:

### nano /etc/zabbix/apache.conf
    php_value max_execution_time 300
    php_value memory_limit 128M
    php_value post_max_size 16M
    php_value upload_max_filesize 2M
    php_value max_input_time 300
    php_value always_populate_raw_post_data -1
    php_value date.timezone Europe/Rome

Restart the Apache and zabbix service for the changes to take effect:

systemctl restart zabbix-server zabbix-agent apache2

Step 7. Accessing Zabbix.

will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://your-domain.com/zabbix or http://server-ip/zabbix 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.
zabbix-3.4-setup

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

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.