


Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
This document details a network administrator's experience installing apache, mysql, and php for educational and personal web projects. The author discusses the reasons behind the installation, the installation process, and the challenges encountered, including the use of css and javascript for layout and the limitations of certain routers for external access.
Typology: Assignments
1 / 4
This page cannot be seen from the preview
Don't miss anything!



John E Evans EdTech 552 Apache/MySql/PHP Server Install In accomplishing the tasks for this assignment, my goal was not so much to create a particular kind of site, but to go through the process. Since starting, I have identified an education purpose for what I have done. I have worked as a network administrator for most of my career, but I never had web server responsibilities. I played with an old version of Apache on Win98 a long time ago, but not since. I’ve also done a little with IIS, but I really don’t like it. I have had several web project ideas floating in my head for some time both personal and educational, and knew that I was going to want the server-side scripting of PHP and would eventually need a database. I was already aware of MySQL and planned to use it some day. My computer science degree is so old that Databases was not a required class. My first databases were built around custom-written programming. So I have ordered a couple of textbooks that teach combined MySQL and PHP. One project I have meant to do is a rewrite of my homepage, which is a portal I created for quickly navigating to my frequently visited websites. The original was static HTML text and was looking dated and cluttered. I rewrote it using CSS and a little but of JavaScript to get it looking better. I then used my new AppServ install for testing. Everything installed quite easily, although there were some minor differences between my installation and the tutorial. Not a big deal. The Apache and MySQL services loaded without error. I like the overall package of AppServ, but I plan to look at others as well. One in particular I am interested in is IndigoAMPP, which combines Apache, MySQL, PHP and IndigoPerl. Installation, as I said was very straightforward, and the default page was up and running quickly. PHP also responded as it should.
Here is the typical network layout. Since I carry a laptop pretty much everywhere I go, it changes sometimes. The router presents a problem for external access to my network. The FortiNet 60 does not have traditional port forwarding. It is a full blown router, firewall and content filter. I especially like it because I can configure the firewall in every detail. I may decide to swap it out in the future if I decide to put up a permanent server. I have a Cisco 2600-series router somewhere in the recesses of my basement. Despite the lack of port forwarding, I still went through the other steps in case I can put together alternate access. The next step, then, was setting up a dynamic DNS account and getting a host configured. The site recognized my external IP address correctly and the name resolves correctly using nslookup. I have to assume that had port forwarding been available, external access would work fine.
Extra Credit I have also previously researched blogging software. I wanted to find something in the open source world so that I have full control of the software, rather than using a blogging site. I am running a package called Pilot, which is quite flexible. It uses CSS templates, so the layout can be just about anything one would want. In addition, it is written in PHP and uses flat files rather than a SQL database. It performs well for me, but I really don’t know how well it scales. A high traffic site will probably require the SQL database backend. Backing up the blog is a simple matter of copying the files. The following was laid out in CSS and some of the PHP code modified by me. Note: all images were converted to gif before importing to Word in order to keep the file size down. 250K is not bad!