Deploying Joomla: Difference between revisions

From The Opensource Knowledgebase
Jump to navigation Jump to search
how to deploy joomla
 
mNo edit summary
Line 5: Line 5:
<pre>
<pre>
hostname: infrabase1
hostname: infrabase1
Network: 172.16.149.128/25
Network: 10.1.65.0/24
IP Address : 172.16.149.176
IP Address : 10.1.65.11
Subnet Mask: 255.255.255.128
Subnet Mask: 255.255.255.0
Gateway: 172.16.176.129
Gateway: 10.1.65.1
DNS: 8.8.8.8
DNS: 8.8.8.8
sudo user: kedar
sudo user: kedar


Container: webserver
Container: webserver
Network: 10.0.3.0/24
Network: 10.1.65.0/24
IP Address : 10.0.3.211
IP Address : 10.1.65.107
Subnet Mask: 255.255.255.0
Gateway: 10.1.65.1
DNS: 8.8.8.8
sudo user: kedar
 
Container: db1
Network: 10.1.65.0/24
IP Address : 10.1.65.108
Subnet Mask: 255.255.255.0
Subnet Mask: 255.255.255.0
Gateway: 10.0.3.1
Gateway: 10.1.65.1
DNS: 8.8.8.8
DNS: 8.8.8.8
sudo user: kedar
sudo user: kedar
Line 23: Line 31:
PC type: Desktop
PC type: Desktop
OS: Ubuntu Desktop
OS: Ubuntu Desktop
IP Address: 172.16.162.65
IP Address: 10.1.65.160
sudo user:kedar
</pre>
</pre>
|}
|}
=Before you proceed=
=Before you proceed=
The domain used here is '''networked.com'''. This is a dummy domain used only for demonstration and required dns entries for this domain have already been done on a private dns server or in some cases, manual entries have been made to the host file to make the domain and any subdomains reachable on the network. This domain may be owned by someone else and we do not know who it is and we are not linked to them in any ways whatsoever. This domain has been used only for demo purpose. Joomla configured for this domain in this howto is not reachable on public IP. If you try networked.com and find any material that may be suitable / unsuitable to you, we are not the owners of the same and we are not responsible for the content whatsoever.
The domain used here is '''networked.com'''. This is used only for demonstration and required dns entries for this domain have already been done to the host file to make the domain and any subdomains reachable on the network. This domain may be owned by someone else and we do not know who it is and we are not linked to them. Wordpress configured for this domain in this howto is not reachable on public IP. If you try networked.com and find any material that may be suitable / unsuitable to you, we are not the owners of the same and we are not responsible for the content.
=SSH into the web server=
Webserver is a container created on the host server (infrabase1) having an ip address of 10.0.3.211 and is a private IP address. To read on how this container has been made, click [https://infrastructure-advisory.org/index.php?title=Virtualization_using_LXC here]. This container is not reachable from any machine except the host server (infrabase1). To be able to access the web server from any machine on the network that is able to reach the host (infrabase1) server, two things have been done
* '''For ssh access''' from User PC (Details mentioned in Infobox on the right, top corner), iptables have been used on host server (infrabase1) for port forwarding. The rule ensures that any request on the host (infrabase1 server), on port number 61300 will be port forwarded to 10.0.3.211 on port number 22.
<syntaxhighlight lang="bash">
sudo iptables -t nat -A PREROUTING -p tcp -i eno1 --dport 61300 -j DNAT --to-destination 10.0.3.211:22
sudo iptables -t nat -A PREROUTING -p tcp -i eno1 --dport 61301 -j DNAT --to-destination 10.0.3.137:22
sudo iptables-save
sudo service netfilter-persistent save
</syntaxhighlight>
If an error is observed while executing the last two commands, install the below two packages and execute the above commands again
: <code> sudo apt install netfilter-persistent iptables-persistent </code>
The second iptable rule is for port forwarding for the database server.
*'''For http access''' - This is required because '''Joomla''' will be served on port 80 by the web server container. Nginx web server has been installed on host server (inrabase1) and is configured as a reverse proxy. This ensures that any port 80 request that hits the infrabase1 server will be redirected to the webserver container ip. Since the web server container is running an apache webserver, depending on the header and configured virtual hosts, apache on webserver container will serve the necessary website. Nginx configuration as a reverse proxy can be found here.


=Introduction=
*We shall be creating a website using joomla with FQDN as: https://joomla.networked.net
*We shall be hosting the site on port number: 443
*We shall be using a self signed SSL certificate
*Host entry to ensure this website is reachable is done in the user PC, in absence of a DNS
=Pre-requisites installation=
=Pre-requisites installation=
* Log into the webserver. In this case the host name of the web server is webserver
* Log into the webserver and run the below commands
<syntaxhighlight lang="bash">
<syntaxhighlight lang="bash">
ssh kedar@172.16.149.176:61300
ssh kedar@10.1.65.107
sudo apt install apache2 php7.2 php7.2-curl php7.2-gd php7.2-intl php7.2-json php7.2-mbstring php7.2-mysql php7.2-soap php7.2-xml php7.2-xmlrpc php7.2-zip libapache2-mod-php7.2  
sudo apt install apache2 php7.2 php7.2-curl php7.2-gd php7.2-intl php7.2-json php7.2-mbstring php7.2-mysql php7.2-soap php7.2-xml php7.2-zip libapache2-mod-php7.2  
sudo apt install rsync nano openssl
sudo apt install rsync nano openssl
sudo a2enmod ssl
sudo a2enmod ssl
Line 54: Line 53:
sudo systemctl status apache2
sudo systemctl status apache2
</syntaxhighlight>
</syntaxhighlight>
=Database Creation=
=Database Creation=
*Database will be created in a mariadb server which is installed into a container created on the host server (infrabase1). DB server address is 10.0.3.137 and port forwarded as explained in step 2 above. Latest mariadb server has been installed and run the below commands after an ssh into the mariadb server.
*Database will be created in a mariadb server which is installed into a container created on the host server (infrabase1). Latest mariadb server has been installed and run the below commands after an ssh into the mariadb server.
<syntaxhighlight lang="bash">
<syntaxhighlight lang="bash">
sudo mysql -u root -p
sudo mysql -u root -p
CREATE DATABASE joomla;
CREATE DATABASE joomla;
GRANT ALL PRIVILEGES ON joomla.* TO "joomlauser"@"%" IDENTIFIED BY "123456";
GRANT ALL PRIVILEGES ON joomla.* TO "joomla"@"%" IDENTIFIED BY "123456";
FLUSH PRIVILEGES;
FLUSH PRIVILEGES;
quit;
quit;
</syntaxhighlight>
</syntaxhighlight>
*Disable bind address argument so that DB server is reachable by any host on the network and is not limited to the localhost
=Create self signed certificates=
* Log into the webserver and run the below commands
<syntaxhighlight lang="bash">
<syntaxhighlight lang="bash">
sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout /etc/ssl/private/joomla.key -out /etc/ssl/certs/joomla.crt
</syntaxhighlight>
</syntaxhighlight>
Search for bind-address argument and comment it by adding a # before the bind-address
* You can use a commercial self signed certificate if you have one or can also use free Lets Encrypt certificate
<syntaxhighlight lang="bash">
=Download Joomla=
#bind-address          = 127.0.0.1
 
</syntaxhighlight>
* Log into the webserver and run the below commands
*Restart mariadb
<syntaxhighlight lang="bash">
sudo systemctl restart mariadb
sudo systemctl status mariadb
</syntaxhighlight>
=Download & Extract Joomla=
Download & extract Joomla in the correct directory, giving permissions to the apache user
<syntaxhighlight lang="bash">
<syntaxhighlight lang="bash">
cd /var/www/html
cd /var/www/html
sudo mkdir joomla
sudo mkdir joomla
cd /home/kedar
cd /home/kedar
wget https://downloads.joomla.org/cms/joomla3/3-9-14/Joomla_3-9-14-Stable-Full_Package.zip?format=zip
wget https://downloads.joomla.org/cms/joomla3/3-9-14/Joomla_3-9-16-Stable-Full_Package.zip?format=zip
mv Joomla_3-9-14-Stable-Full_Package.zip?format=zip joomla.zip
mv Joomla_3-9-14-Stable-Full_Package.zip?format=zip joomla.zip
</syntaxhighlight>
=Deploy Joomla=
<syntaxhighlight lang="bash">
cd /home/kedar
mkdir joomlainstaller
mkdir joomlainstaller
cp joomla.zip joomlainstaller/
cp joomla.zip joomlainstaller/
Line 92: Line 88:
rm -rf joomla.zip
rm -rf joomla.zip
sudo rsync -avz . /var/www/html/joomla
sudo rsync -avz . /var/www/html/joomla
</syntaxhighlight>
* Change the ownership of the joomla folder to apache user
<syntaxhighlight lang="bash">
cd /var/www/html
cd /var/www/html
sudo chown -R www-data:www-data joomla/
sudo chown -R www-data:www-data joomla/
sudo ystemctl restart apache2
</syntaxhighlight>
</syntaxhighlight>
=Configure virtual hosts=
* Create virtual host for the website
*Create a file called as joomla.conf in /etc/apache2/sites-available/ folder. The contents of the file should like below
<syntaxhighlight lang="bash">
<syntaxhighlight lang="bash">
<VirtualHost joomla.networked.com:80>
cd /etc/apache2/sites-available
ServerAdmin admin@networked.com
sudo a2dissite 000-default.conf
ServerName joomla.networked.com
sudo a2dissite default-ssl.conf
ServerAlias joomla
sudo nano joomla.conf
     DocumentRoot   /var/www/html/joomla/
</syntaxhighlight>
* Add the below configuration in the joomla.conf file
<syntaxhighlight lang="apacheconf">
<IfModule mod_ssl.c>
        <VirtualHost _default_:443>
                ServerName     joomla.networked.net
                ServerAlias     joomla
                ServerAdmin     admin@networked.net
                DocumentRoot /var/www/html/joomla


ErrorLog ${APACHE_LOG_DIR}/error.log
                ErrorLog ${APACHE_LOG_DIR}/error.log
    CustomLog ${APACHE_LOG_DIR}/access.log combined
                CustomLog ${APACHE_LOG_DIR}/access.log combined
</VirtualHost>
                SSLEngine on
                SSLCertificateFile      /etc/ssl/certs/joomla.crt
                SSLCertificateKeyFile /etc/ssl/private/joomla.key
<FilesMatch "\.(cgi|shtml|phtml|php)$">
                                SSLOptions +StdEnvVars
                </FilesMatch>
                <Directory /usr/lib/cgi-bin>
                                SSLOptions +StdEnvVars
                </Directory>
</VirtualHost>
</IfModule>
</syntaxhighlight>
</syntaxhighlight>
*Save the file and exit
* Enable the site and Restart apache service
<syntaxhighlight lang="bash">
<syntaxhighlight lang="bash">
sudo a2ensite joomla.conf
sudo a2ensite joomla.conf
sudo systemctl restart apache2
sudo sysemctl restart apache2
</syntaxhighlight>
</syntaxhighlight>
* Using a browser navigate to https://joomla.networked.com
** Answer various questions based on some of the steps we have done above like db name, db user, db server etc.
** Login to joomla using the admin credentials


=Install Joomla=
=Conclusion=
*Open any browser of your choice and navigate to http://joomla.networked.com
* We have a working joomla website hosted on an apache web server. Explore the plugins and extensions and create a website or a corporate intranet
*Since joomla.networked.com is not reachable on public IP, it is necessary to either make entry in a local dns server or in the local host file. We have already done it so that joomla.networked.com resolves to the infrabase1 server
*Infrabase1 has nginx configured as a reverse proxy and redirects requests for joomla.networked.com on port 80 to the webserver container. This is required as the container is on private IP managed by the infrabase1 (LXC host).
*Webinstaller will start and answer various questions like db name, db username, db host, password etc. If all dependencies are installed, webinstaller will create the necessary tables in mariadb and joomla installation will begin.
*You will be asked to delete a '''.txt''' file in the /var/www/html/joomla/installation folder. Delete it, re-enter the db password and press next. If the db is reachable, all dependencies have been installed, the Joomla should proceed with installation. Once completed as a precaution, joomla websintaller will ask the installation folder to be removed. Remove the installation folder by running this command
:<code> cd /var/www/html/joomla</code>
:<code> sudo rm -rf installation </code>
*Once the folder has been deleted, click on the Administrator site button and start confiuring the website by downloading themes, plugins / extensions as required.
 
*Enjoy using Joomla.
 
=Watch Video=
<youtube width="470" height="240">XWagJSOnGwE</youtube>


[[Category: Intranet Applications]]
[[Category: Intranet Applications]]

Revision as of 03:42, 19 April 2020

Setup Details
hostname: infrabase1
Network: 10.1.65.0/24
IP Address : 10.1.65.11
Subnet Mask: 255.255.255.0
Gateway: 10.1.65.1
DNS: 8.8.8.8
sudo user: kedar

Container: webserver
Network: 10.1.65.0/24
IP Address : 10.1.65.107
Subnet Mask: 255.255.255.0
Gateway: 10.1.65.1
DNS: 8.8.8.8
sudo user: kedar

Container: db1
Network: 10.1.65.0/24
IP Address : 10.1.65.108
Subnet Mask: 255.255.255.0
Gateway: 10.1.65.1
DNS: 8.8.8.8
sudo user: kedar

User PC Details
PC type: Desktop
OS: Ubuntu Desktop
IP Address: 10.1.65.160

Before you proceed

The domain used here is networked.com. This is used only for demonstration and required dns entries for this domain have already been done to the host file to make the domain and any subdomains reachable on the network. This domain may be owned by someone else and we do not know who it is and we are not linked to them. Wordpress configured for this domain in this howto is not reachable on public IP. If you try networked.com and find any material that may be suitable / unsuitable to you, we are not the owners of the same and we are not responsible for the content.

Introduction

  • We shall be creating a website using joomla with FQDN as: https://joomla.networked.net
  • We shall be hosting the site on port number: 443
  • We shall be using a self signed SSL certificate
  • Host entry to ensure this website is reachable is done in the user PC, in absence of a DNS

Pre-requisites installation

  • Log into the webserver and run the below commands
ssh kedar@10.1.65.107
sudo apt install apache2 php7.2 php7.2-curl php7.2-gd php7.2-intl php7.2-json php7.2-mbstring php7.2-mysql php7.2-soap php7.2-xml php7.2-zip libapache2-mod-php7.2 
sudo apt install rsync nano openssl
sudo a2enmod ssl
sudo a2enmod rewrite
sudo systemctl restart apache2
sudo systemctl status apache2

Database Creation

  • Database will be created in a mariadb server which is installed into a container created on the host server (infrabase1). Latest mariadb server has been installed and run the below commands after an ssh into the mariadb server.
sudo mysql -u root -p
CREATE DATABASE joomla;
GRANT ALL PRIVILEGES ON joomla.* TO "joomla"@"%" IDENTIFIED BY "123456";
FLUSH PRIVILEGES;
quit;

Create self signed certificates

  • Log into the webserver and run the below commands
openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout /etc/ssl/private/joomla.key -out /etc/ssl/certs/joomla.crt
  • You can use a commercial self signed certificate if you have one or can also use free Lets Encrypt certificate

Download Joomla

  • Log into the webserver and run the below commands
cd /var/www/html
sudo mkdir joomla
cd /home/kedar
wget https://downloads.joomla.org/cms/joomla3/3-9-14/Joomla_3-9-16-Stable-Full_Package.zip?format=zip
mv Joomla_3-9-14-Stable-Full_Package.zip?format=zip joomla.zip

Deploy Joomla

cd /home/kedar
mkdir joomlainstaller
cp joomla.zip joomlainstaller/
cd joomlainstaller
unzip joomla.zip
cd joomlainstaller
rm -rf joomla.zip
sudo rsync -avz . /var/www/html/joomla
  • Change the ownership of the joomla folder to apache user
cd /var/www/html
sudo chown -R www-data:www-data joomla/
sudo ystemctl restart apache2
  • Create virtual host for the website
cd /etc/apache2/sites-available
sudo a2dissite 000-default.conf
sudo a2dissite default-ssl.conf
sudo nano joomla.conf
  • Add the below configuration in the joomla.conf file
<IfModule mod_ssl.c>
        <VirtualHost _default_:443>
                ServerName      joomla.networked.net
                ServerAlias     joomla
                ServerAdmin     admin@networked.net
                DocumentRoot /var/www/html/joomla

                ErrorLog ${APACHE_LOG_DIR}/error.log
                CustomLog ${APACHE_LOG_DIR}/access.log combined
                SSLEngine on
                SSLCertificateFile      /etc/ssl/certs/joomla.crt
                SSLCertificateKeyFile /etc/ssl/private/joomla.key
		<FilesMatch "\.(cgi|shtml|phtml|php)$">
                                SSLOptions +StdEnvVars
                </FilesMatch>
                <Directory /usr/lib/cgi-bin>
                                SSLOptions +StdEnvVars
                </Directory>
		</VirtualHost>
</IfModule>
  • Enable the site and Restart apache service
sudo a2ensite joomla.conf
sudo sysemctl restart apache2
  • Using a browser navigate to https://joomla.networked.com
    • Answer various questions based on some of the steps we have done above like db name, db user, db server etc.
    • Login to joomla using the admin credentials

Conclusion

  • We have a working joomla website hosted on an apache web server. Explore the plugins and extensions and create a website or a corporate intranet