Changes between Version 9 and Version 10 of Csle2022/Agenda/databaseandweb

Timestamp:

Nov 18, 2022, 1:02:53 PM (2 years ago)

Author:

admin

Comment:

--

Csle2022/Agenda/databaseandweb

@@ -131 +131 @@
     <Directory /var/www/web.dhammikalalantha.com/public_html>
         Options -Indexes +FollowSymLinks
-        AllowOverride All
     </Directory>
 
@@ -154 +153 @@
     <Directory /var/www/wp.dhammikalalantha.com/public_html>
         Options -Indexes +FollowSymLinks
-        AllowOverride All
     </Directory>
 
@@ -177 +175 @@
     <Directory /var/www/lms.dhammikalalantha.com/public_html>
         Options -Indexes +FollowSymLinks
-        AllowOverride All
     </Directory>
 
@@ -247 +244 @@
 == Installing Wordpress CMS ==
 
+WordPress is a free and open-source content management system (CMS) written in PHP language. Features include a plugin architecture and a template system, referred to within WordPress as "Themes". WordPress was originally created as a blog-publishing system but has evolved to support other web content types including more traditional mailing lists and Internet fora, media galleries, membership sites, learning management systems (LMS) and online stores.
+
+If you are hoping to start a blog or any other site WordPress would a most convenient and suitable choice. Then let's see how we can install WordPress in your own server.
+
+WordPress is written using PHP and it uses MySQL/MariaDB for storing its data we can install it in a LAMP stack environment. So as the first step we are going to create a database in MySQL/MariaDB as below.
+
+First login the MySQL server,
+
+{{{
+mysql -u root -p
+}}}
+
+Then create the database.
+
+{{{
 CREATE DATABASE wordpress DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
-
+}}}
+
+Then create a user for the database.
+
+{{{
 CREATE USER 'wordpressuser'@'localhost' IDENTIFIED BY 'dala1234';
-
+}}}
+
+Next you need to grant permissions to user to do any operations on the database as below.
+
+{{{
 GRANT ALL ON wordpress.* TO 'wordpressuser'@'localhost';
-
+}}}
+
+Then you have to set the authentication plugin to mysql_native_password plugin which will enable to login using the above created username and password.
+
+{{{
 UPDATE mysql.user set plugin = 'mysql_native_password' where User = 'wordpressuser';
-
+}}}
+
+Lastly, flush privileges for these changes to take effect immediately. Then exit the mysql server.
+
+{{{
 FLUSH PRIVILEGES;
-
 EXIT;
+}}}
+
+=== Install additional PHP extensions ===
+
+WordPress needs additional PHP extensions for its plugins to work. First, let’s update and install the necessary extensions using the following commands. Next for the extensions to start working, restart the Apache server.
+
+{{{
+sudo apt update
+sudo apt install php-curl php-gd php-mbstring php-xml php-xmlrpc php-soap php-intl php-zip
+sudo systemctl restart apache2
+}}}
+
+=== Allow Apache’s .htaccess to Handle Override and Rewrite Rules on the WordPress Site ===
+
+In Apache, .htaccess files provide a way to make configuration changes on a per-directory basis. To Enable this you have to go the virtual host configuration file of the WordPress site and add the AllowOverride directive within the Directory block pointing to the website’s document root.
+
+{{{
+<VirtualHost *:80>
+    ServerName wp.dhammikalalantha.com
+    ServerAlias wp.dhammikalalantha.com
+    ServerAdmin webmaster@wp.dhammikalalantha.com
+    DocumentRoot /var/www/wp.dhammikalalantha.com/public_html
+
+    <Directory /var/www/wp.dhammikalalantha.com/public_html>
+        Options -Indexes +FollowSymLinks
+        AllowOverride All
+    </Directory>
+
+    ErrorLog ${APACHE_LOG_DIR}/wp.dhammikalalantha.com-error.log
+    CustomLog ${APACHE_LOG_DIR}/wp.dhammikalalantha.com-access.log combined
+</VirtualHost>
+}}}
+
+Then enable the Apache rewrite module.
+
+{{{
+sudo a2enmod rewrite
+}}}
+
+Next verify the configuration changes for the Syntax errors and restart Apache to make changes effective.
+
+{{{
+sudo apache2ctl configtest
+sudo systemctl restart apache2
+}}}
 
 == Moodle Installation ==