Getting Started with Web/Database Technologies on the UM Research Server

This page is just a collection of information/links to assist students in figuring out how to run what is on willow.

Getting Started with MySQL on willow
MySQL Reference Manual
MySQL Reference Manual: Tutorial
Example EMP database website (some of the links on the other web site might not be working, but the links on this Getting Started with MIS 609 Technolgoies web page should be.
Description of the emp table
Listing of the emp table
Description of the dept table
Listing of the dept table
Description of the salgrade table
Listing of the salgrade table
Corrected PHP Script from EMP database website
How we got this script to work on willow

Questions

• What is willow's IP address?
• What web server is running on willow?
• How to access content from the web?
• Where should I put my html files, perl files, and PHP files, and what permissions should I give them, so they can be accessed from the web?


• Is there an example html page and perl CGI script I can use a model for writing CGI scripts that access a database?

• What is willow's IP address?
  130.74.110.16
• What web server is running on willow?
  Apache 2.0.44, at present.
• How to access content from the web?
  http://willow.olemiss.edu/mis609/yourfile.html or
  http://willow.olemiss.edu/~youraccountid/yourfile.html or
  
• Where should I put my html files, perl scripts, and PHP files, and what permissions should I give them, so they can be accessed from the web?
  You can put your html files under /usr/local/apache/htdocs/mis609/, or create a directory called public_html under your home account on willow, and put your html files in there. If you create a file called a.html in your public_html directory, you can then access it with a URL like this:
  http://willow.olemiss.edu/~jghale/a.html
  but substitute your willow account name for jghale in this case.
  If you were to put your a.html file in the /usr/local/apache/htdocs/mis609/ directory, you would access it with
  http://willow.olemiss.edu/mis609/a.html.
  You can put your PHP files in either of the directories where you can put html files.
  Put your Perl cgi scripts under /usr/local/apache/cgi-bin/mis609/. Your Perl cgi scripts should have execute permissions for all users. (chmod a+x yourfile.pl).
• Is there an example html page and perl CGI script I can use as a model for writing CGI scripts that access a database?
  http://willow.olemiss.edu/mis609/examples2.html. The html is at /usr/local/apache/htdocs/mis609/examples2.html. The cgi-script is at /usr/local/apache/cgi-bin/mis609/emp.pl.