Web Programming with Python CGI A website that hosts a database management system for a bookshop

• Linux OS: Ubuntu 14.0
• Apache2
• MySQL Ver 14.14
• Python 2.7.6
• Jinja2 (Template Engine)

Download and save repo in directory /var/www Make sure to make every .py file in /cgi-bin executable; otherwise, it'll incur an Internal Server Error.

To install and connect MYSQL to Python,

sudo apt-get install mysql-server
sudo apt-get install python-mysqldb

To install Jinja2, download Markupsafe, Jinja, Werkzeug, Passlib, unpack tarball and run the following (for both):

sudo python setup.py install

To access MySQL:

mysql -u root -p password

sudo service apache2 status
sudo service apache2 start
sudo service apache2 restart

1. Enable cgi using the command: sudo a2enmod cgi

   optional: install python support: sudo apt-get install libapache2-mod-python

2. Add the following lines to /etc/apache2/apache2.conf

   ScriptAlias /cgi-bin/ "/var/www/cgi-bin/"
   <Directory "/var/www/cgi-bin">
      AllowOverride None
      Options ExecCGI
      AddHandler cgi-script .cgi .py
      Order allow,deny
      Allow from all
   </Directory>
   
   <Directory "/var/www/cgi-bin">
   Options All
   </Directory>
   

In the file /etc/apache2/sites-available/000-default.conf, set the default page as follows:

```
DirectoryIndex index.py
DocumentRoot /var/www/cgi-bin
```

3. In /var/www/ create folder 'cgi-bin'. This is where all cgi files will be stored. Go to http://localhost/cgi-bin/<cgi_file.py>

Bootstrap Theme and Template taken from Start Bootstrap. Start Bootstrap was created by and is maintained by David Miller, Managing Parter at Iron Summit Media Strategies.