I am just learning python and I am trying to create a simple
connection to a mysql table via Python and Apache, using a Python
program
Unfortunately I keep getting an internal server error (50), when I
bring it up in my browser ... information attached.
Any help would be appreciated ...
Thx, [EMAIL PROTECTED]
Information #1
error in /var/log/apache2/error.log
[Wed Feb 06 20:04:31 2008] [error] [client 127.0.0.1] (2)No such file
or directory: exec of '/var/www/cgi-bin/fig17_27.py' failed
[Wed Feb 06 20:04:31 2008] [error] [client 127.0.0.1] Premature end of
script headers: fig17_27.py
---
Information #2
directory information
[EMAIL PROTECTED]:/var/log/apache2$ cd /var/www/cgi-bin
[EMAIL PROTECTED]:/var/www/cgi-bin$ ls -al
total 24
drwxr-xr-x 2 root root 4096 2008-02-06 15:03 .
drwxr-xr-x 4 root root 4096 2008-02-02 20:53 ..
-rwxr-xr-x 1 root root 1569 2008-02-02 21:02 fig06_03.py
-rwxr-xr-x 1 root root 2067 2008-02-02 21:05 fig06_05.py
-rwxr-xr-x 1 root root 2031 2008-02-02 21:19 fig06_06.py
-rwxr-xr-x 1 root root 3489 2008-02-06 15:03 fig17_27.py
-
Web Error
http://localhost/cgi-bin/fig17_27.py
Internal Server Error
The server encountered an internal error or misconfiguration and was
unable to complete your request.
Please contact the server administrator, [EMAIL PROTECTED] and
inform them of the time the error occurred, and anything you might
have done that may have caused the error.
More information about this error may be available in the server error
log.
Apache/2.2.4 (Ubuntu) mod_python/3.3.1 Python/2.5.1 PHP/
5.2.3-1ubuntu6.3 Server at localhost Port 80
--
Program File
[EMAIL PROTECTED]:/var/www/cgi-bin$ cat fig17_27.py
#!/usr/local/bin/python
# Fig. 17.27: fig17_27.py
# Displays contents of the Authors table,
# ordered by a specified field.
import MySQLdb
import cgi
import sys
def printHeader( title ):
print Content-type: text/html
?xml version = 1.0 encoding = UTF-8?
!DOCTYPE html PUBLIC
-//W3C//DTD XHTML 1.0 Transitional//EN
DTD/xhtml1-transitional.dtd
html xmlns = http://www.w3.org/1999/xhtml;
xml:lang = en lang = en
headtitle%s/title/head
body % title
# obtain user query specifications
form = cgi.FieldStorage()
# get sortBy value
if form.has_key( sortBy ):
sortBy = form[ sortBy ].value
else:
sortBy = firstName
# get sortOrder value
if form.has_key( sortOrder ):
sortOrder = form[ sortOrder ].value
else:
sortOrder = ASC
printHeader( Authors table from Books )
# connect to database and retrieve a cursor
try:
connection = MySQLdb.connect( db = Books, user = root )
# error connecting to database
except MySQLdb.OperationalError, error:
print Error:, error
sys.exit( 1 )
# retrieve cursor
else:
cursor = connection.cursor()
# query all records from Authors table
cursor.execute( SELECT * FROM Authors ORDER BY %s %s %
( sortBy, sortOrder ) )
allFields = cursor.description # get field names
allRecords = cursor.fetchall() # get records
# close cursor and connection
cursor.close()
connection.close()
# output results in a table
print \ntable border = 1 cellpadding = 3
tr bgcolor = silver
# create table header
for field in allFields:
print td%s/td % field[ 0 ]
print /tr
# display each record as a row
for author in allRecords:
print tr
for item in author:
print td%s/td % item
print /tr
print /table
# obtain sorting method from user
print
\nform method = post action = /cgi-bin/fig17_27.py
Sort By:br /
# display sorting options
for field in allFields:
print input type = radio name = sortBy
value = %s / % field[ 0 ]
print field[ 0 ]
print br /
print br /\nSort Order:br /
input type = radio name = sortOrder
value = ASC checked = checked /
Ascending
input type = radio name = sortOrder
value = DESC /
Descending
br /br /\ninput type = submit value = SORT /
/form\n\n/body\n/html
--
http://mail.python.org/mailman/listinfo/python-list
