932
edits
Changes
Adding an exercise that confirms the services are working together.
'''Perform the following steps:'''
#Install '''MySQL''' (you may notice that it's actually called 'mariadb-server''MariaDB''' now).<br/><br/> The MySQL and MariaDB are actually two <u>separate</u> projects run by different groups, yet they are compatible; therefore, you can use documentation from one to configure the other. <br><br>#'''NOTE:''' When installing mysqlmariadb, make certain that you have not just the '''client''' but also the '''server software'''.#When you start the MySQL service, you will receive get some instructions contained in check the system log file for instructions regarding how to set the root password. Even though we will not configure our MySQL service to be accessible over the network, it is accepted as a "best practice" configuring for network access for each MySQL installation.
#Note that the MySQL service has two root passwords:<ul><li>For the localhost</li><li>For external requests</li></ul>
#Refer to the log file to learn how to run the two commands in order to generate the appropriate passwords.<br><br>NOTE: Use a password you make up yourself, but do <u>not</u> generate a secret password, since you will be storing that password in a plain text file for later reference.
=== Test Connection to MySQL Database Server ===
*While the web server (with php), and MySQL server may be workingindividually, we need to ensure that they can connect to each other.*Since we are going to be this test will involve storing the database password in a plain-text html file, we want to make sure no one else can access it.
*Modify the Directory statement for your private directory to prevent any machine other than your vm1 from accessing it.
*Re-start the web-server and try to access the page from another machine. Make sure that you can not do so before you continue.
*TODO: Install the '''php-mysql''' module so that the installation of php your web server is using can execute sql statements. A quick demo You will have to restart the service after intalling it.*Create a page proving like the one described [http://php.net/manual/en/mysqli.quickstart.connections.php here] to test that your web server can connect to the database (replace the user, password, and database with values appropriate for your machine).*once that page shows a successful connection workson your VM this step is complete.
'''Record steps, commands, and your observations on this investigation in your OPS335 lab log-book'''
<!--
== COMPLETING THE LAB ==
You now have a complete LAMP stack and could host a variety of web-pages that could include dynamically generated content and database access.
'''Depending on your professor you will either be asked to submit the lab in class, or online. Follow the appropriate set of instructions below.'''
'''Arrange evidence (command output) for each of these items on your screen, then ask your instructor to review them and sign off on the lab's completion:'''
<!--::<span style="color:green;font-size:1.5em;">✓</span>Your webmail showing your inbox
::<span style="color:green;font-size:1.5em;">✓</span>Your webmail sending an email out
::<span style="color:green;font-size:1.5em;">✓</span>You receiving that mail on an exernal account-->To be completed by an instructor who uses in-class submissions.
==EXPLORATION QUESTIONS==