Connect To Database Without Django

[yakster8]

I would like to connect to a database using python without Django. My site is at http://a-catering.heliohost.org/cgi-bin/menuDatabaseMakerWeb.py. It takes a text file and creates a table from it. Whenever I run it, I get a 500 Internal Server Error. I believe I've narrowed the problem down to the actual connection (connection = MySQLdb.connect). I created the database and the user/password through cpanel. Please let me know if I missed something.

 

Thank you.

 

The code is below:

 

#!/usr/bin/python

# date: 4/19/12

# description: Database creator for catering website

 

#The following imports the necessary modules

import cgitb; cgitb.enable()

import MySQLdb

 

print "Content-Type: text/html"

print

 

print "Attempting to create DB"

 

menuData = "/home/yakster8/public_html/menus.txt"

menus = open(menuData)

 

try:

connection = MySQLdb.connect(

host = "localhost",

user = yakster8_root,

passwd = password1234,

db = yakster8_menus

)

except:

print "Failed..."

 

print "Connected."

cursor = connection.cursor()

 

try:

cursor.execute("""drop table menu""")

except:

pass

 

sql = """CREATE TABLE menu

(name text,

category text,

imageLocation text,

dietaryConcerns text,

"""

 

# Create table

cursor.execute(sql)

connection.commit()

 

for line in menus:

line = line.strip() #removes leading and trailing white space

lineParts = line.split('\t')

sql = """

INSERT INTO menu

VALUES (%s,%s,%s,%s)

"""

 

parameters = (lineParts[0:4])

 

#The following runs the SQL against the cursor

cursor.execute(sql,parameters)

 

connection.commit()

 

print "Database created OK."

 

Nevermind, I forgot quotes in the connection script. Problem solved.