Software Installation and Configuration

Launch your CloudLab experiment

Overview

MySQL



1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165

 
bash
wget --no-check-certificate https:/www.cs.wcupa.edu/lngo/data2/mysql-apt-config_0.8.17-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.17-1_all.deb

<details class="details details--default" data-variant="default"><summary>Configuring mysql-apt-config</summary>
<ul>
  <li>Press the <code class="language-plaintext highlighter-rouge">Tab</code> key to go to <code class="language-plaintext highlighter-rouge">Ok</code>, then press <code class="language-plaintext highlighter-rouge">Enter</code></li>
</ul>

<figure>
  <picture>
    <!-- Auto scaling with imagemagick -->
    <!--
      See https://www.debugbear.com/blog/responsive-images#w-descriptors-and-the-sizes-attribute and
      https://developer.mozilla.org/en-US/docs/Learn/HTML/Multimedia_and_embedding/Responsive_images for info on defining 'sizes' for responsive images
    -->
    
      
        <source class="responsive-img-srcset" srcset="/assets/img/courses/csc586/08-software/mysql-01-480.webp 480w,/assets/img/courses/csc586/08-software/mysql-01-800.webp 800w,/assets/img/courses/csc586/08-software/mysql-01-1400.webp 1400w," type="image/webp" sizes="95vw" />
      
    
    <img src="/assets/img/courses/csc586/08-software/mysql-01.png" width="50%" height="auto" data-zoomable="" loading="lazy" onerror="this.onerror=null; $('.responsive-img-srcset').remove();" />
  </picture>

  
</figure>

<div class="language-bash highlighter-rouge"><div class="highlight"><pre class="highlight"><code><table class="rouge-table"><tbody><tr><td class="rouge-gutter gl"><pre class="lineno">1
2
3
</pre></td><td class="rouge-code"><pre><span class="nb">sudo </span>apt-key adv <span class="nt">--keyserver</span> keyserver.ubuntu.com <span class="nt">--recv-keys</span> 467B942D3A79BD29
<span class="nb">sudo </span>apt-get update
<span class="nb">sudo </span>apt <span class="nb">install</span> <span class="nt">-y</span> mysql-community-server
</pre></td></tr></tbody></table></code></pre></div></div>

</details>
<details class="details details--default" data-variant="default"><summary>Configuring mysql-community-server</summary>
<ul>
  <li>Select and enter a root password</li>
  <li>Press the <code class="language-plaintext highlighter-rouge">Tab</code> key to go to <code class="language-plaintext highlighter-rouge">Ok</code>, then press <code class="language-plaintext highlighter-rouge">Enter</code></li>
  <li>Re-enter the above password when asked again, then <code class="language-plaintext highlighter-rouge">Tab</code> to <code class="language-plaintext highlighter-rouge">Ok</code> and <code class="language-plaintext highlighter-rouge">Enter</code>.</li>
</ul>

<figure>
  <picture>
    <!-- Auto scaling with imagemagick -->
    <!--
      See https://www.debugbear.com/blog/responsive-images#w-descriptors-and-the-sizes-attribute and
      https://developer.mozilla.org/en-US/docs/Learn/HTML/Multimedia_and_embedding/Responsive_images for info on defining 'sizes' for responsive images
    -->
    
      
        <source class="responsive-img-srcset" srcset="/assets/img/courses/csc586/08-software/mysql-02-480.webp 480w,/assets/img/courses/csc586/08-software/mysql-02-800.webp 800w,/assets/img/courses/csc586/08-software/mysql-02-1400.webp 1400w," type="image/webp" sizes="95vw" />
      
    
    <img src="/assets/img/courses/csc586/08-software/mysql-02.png" width="50%" height="auto" data-zoomable="" loading="lazy" onerror="this.onerror=null; $('.responsive-img-srcset').remove();" />
  </picture>

  
</figure>

<ul>
  <li>Select <code class="language-plaintext highlighter-rouge">User Strong Password Encryption (RECOMMENDED" width="50%" zoomable=true %}</code></li>
  <li>Press the <code class="language-plaintext highlighter-rouge">Tab</code> key to go to <code class="language-plaintext highlighter-rouge">Ok</code>, then press <code class="language-plaintext highlighter-rouge">Enter</code></li>
</ul>

<figure>
  <picture>
    <!-- Auto scaling with imagemagick -->
    <!--
      See https://www.debugbear.com/blog/responsive-images#w-descriptors-and-the-sizes-attribute and
      https://developer.mozilla.org/en-US/docs/Learn/HTML/Multimedia_and_embedding/Responsive_images for info on defining 'sizes' for responsive images
    -->
    
      
        <source class="responsive-img-srcset" srcset="/assets/img/courses/csc586/08-software/mysql-03-480.webp 480w,/assets/img/courses/csc586/08-software/mysql-03-800.webp 800w,/assets/img/courses/csc586/08-software/mysql-03-1400.webp 1400w," type="image/webp" sizes="95vw" />
      
    
    <img src="/assets/img/courses/csc586/08-software/mysql-03.png" width="50%" height="auto" data-zoomable="" loading="lazy" onerror="this.onerror=null; $('.responsive-img-srcset').remove();" />
  </picture>

  
</figure>

<ul>
  <li>Run the following command and provide the password to test the MySQL server:</li>
  <li><code class="language-plaintext highlighter-rouge">mysql -u root -p</code></li>
  <li>To quit MySQL, type <code class="language-plaintext highlighter-rouge">\q</code></li>
</ul>

<figure>
  <picture>
    <!-- Auto scaling with imagemagick -->
    <!--
      See https://www.debugbear.com/blog/responsive-images#w-descriptors-and-the-sizes-attribute and
      https://developer.mozilla.org/en-US/docs/Learn/HTML/Multimedia_and_embedding/Responsive_images for info on defining 'sizes' for responsive images
    -->
    
      
        <source class="responsive-img-srcset" srcset="/assets/img/courses/csc586/08-software/mysql-04-480.webp 480w,/assets/img/courses/csc586/08-software/mysql-04-800.webp 800w,/assets/img/courses/csc586/08-software/mysql-04-1400.webp 1400w," type="image/webp" sizes="95vw" />
      
    
    <img src="/assets/img/courses/csc586/08-software/mysql-04.png" width="50%" height="auto" data-zoomable="" loading="lazy" onerror="this.onerror=null; $('.responsive-img-srcset').remove();" />
  </picture>

  
</figure>

<ul>
  <li>Create a file named <code class="language-plaintext highlighter-rouge">.my.cnf</code> (run <code class="language-plaintext highlighter-rouge">sudo nano /root/.my.cnf</code>)directly inside <code class="language-plaintext highlighter-rouge">/root</code> with the following content:</li>
</ul>

<div class="language-bash highlighter-rouge"><div class="highlight"><pre class="highlight"><code><table class="rouge-table"><tbody><tr><td class="rouge-gutter gl"><pre class="lineno">1
2
3
</pre></td><td class="rouge-code"><pre><span class="o">[</span>client]
<span class="nv">user</span><span class="o">=</span>root
<span class="nv">password</span><span class="o">=</span>”MYSQL_ROOT_PASS”
</pre></td></tr></tbody></table></code></pre></div></div>

<ul>
  <li>Test the effectiveness of this passwordless setup</li>
</ul>

<div class="language-bash highlighter-rouge"><div class="highlight"><pre class="highlight"><code><table class="rouge-table"><tbody><tr><td class="rouge-gutter gl"><pre class="lineno">1
2
3
4
5
6
</pre></td><td class="rouge-code"><pre><span class="nb">sudo </span>su
mysql
<span class="o">&gt;</span> <span class="se">\q</span>
<span class="nb">exit
sudo</span> <span class="nt">-H</span> mysql
<span class="o">&gt;</span> <span class="se">\q</span>
</pre></td></tr></tbody></table></code></pre></div></div>

<figure>
  <picture>
    <!-- Auto scaling with imagemagick -->
    <!--
      See https://www.debugbear.com/blog/responsive-images#w-descriptors-and-the-sizes-attribute and
      https://developer.mozilla.org/en-US/docs/Learn/HTML/Multimedia_and_embedding/Responsive_images for info on defining 'sizes' for responsive images
    -->
    
      
        <source class="responsive-img-srcset" srcset="/assets/img/courses/csc586/08-software/mysql-05-480.webp 480w,/assets/img/courses/csc586/08-software/mysql-05-800.webp 800w,/assets/img/courses/csc586/08-software/mysql-05-1400.webp 1400w," type="image/webp" sizes="95vw" />
      
    
    <img src="/assets/img/courses/csc586/08-software/mysql-05.png" width="50%" height="auto" data-zoomable="" loading="lazy" onerror="this.onerror=null; $('.responsive-img-srcset').remove();" />
  </picture>

  
</figure>

</details>
---

## Apache

- Run the following commands

~~~bash
sudo apt install -y apache2 php libapache2-mod-php php-cli php-mysql php-cgi php-curl php-json php-apcu php-gd php-xml php-mbstring

 


1

 
sudo systemctl  COMMAND  apache2.service

or, more simply:



1

 
sudo systemctl  COMMAND  apache2

where COMMAND can be: status, start, stop, restart, reload.



1

 
tail -f /var/log/apache2/error_log

 


1

 
sudo apachectl configtest

 


1

 
mkdir ~/public_html

 


1
2

 
sudo a2enmod userdir
sudo systemctl reload apache2

 


1

 
ll /etc/apache2/mods-enabled/userdir.*

PHP



1
2
3

 
<?php
echo "Hello from PHP";
?>

PHP/phpmyadmin



1

 
sudo apt-get install -y phpmyadmin

Drupal



1
2
3

 
sudo su
cd
wget https:/ftp.drupal.org/files/projects/drupal-9.4.2.tar.gz

 


1
2
3
4
5

 
$ mysql
mysql> create database drupal;
mysql> create user drupal@localhost identified by "DRUPAL_DB_PASS";
mysql> grant all on drupal.* to drupal@localhost;
mysql> quit;

 


1
2

 
$ tar xzf drupal-9.4.2.tar.gz
$ mv drupal-9.4.2 /var/www/html/$(hostname -f | awk -F\. '{print $1}')_drupal
Error: File system 


1
2
3
4
5
6

 
$ clear
$ cd /var/www/html/$(hostname -f | awk -F\. '{print $1}')_drupal
$ pwd
$ apt install -y acl
$ mkdir sites/default/files
$ setfacl -m g:www-data:rwx sites/default/files
Error: Settings File 


1
2
3

 
$ pwd
$ cp sites/default/default.settings.php sites/default/settings.php
$ setfacl -m g:www-data:rw sites/default/settings.php
Warnings: Clean URLS 


1
2
3

 
$ pwd
$ a2enmod rewrite
$ mv .htaccess /etc/apache2/conf-available/drupal.conf

 


1
2

 
$ a2enconf drupal
$ systemctl reload apache2

Challenge: Automating the process