Salam rekan semua,
Maaf, kalau cross posting. Saya sudah menanyakan ke milis lain tetapi
belum mendapatkan jawaban. Barangkali rekan di linux-programming ada
yang bisa membantu.
Saya mencoba membuat script psp (python server pages) namun ketika
dijalankan menemukan
error seperti berikut:
----------------------------------
Hello there!
Mod_python error: "PythonHandler mod_python.psp"
Traceback (most recent call last):
File "/usr/lib/python2.4/site-packages/mod_python/apache.py", line
299, in HandlerDispatch
result = object(req)
File "/usr/lib/python2.4/site-packages/mod_python/psp.py", line 297,
in handler
p.run()
File "/usr/lib/python2.4/site-packages/mod_python/psp.py", line 208,
in run
exec code in global_scope
File "/data/project/learn/python/pypublish/mysql.psp", line 12, in ?
from mod_python import MySQLdb
ImportError: cannot import name MySQLdb
----------------------------------
Padahal MySQLdb terdapat di /usr/lib/python2.4/site-packages/MySQLdb
Source code saya seperti berikut :
----------------------------------
<html>
<%
if form.has_key('name'):
greet = 'Hello, %s!' % form['name'].capitalize()
else:
greet = 'Hello there!'
# end
%>
<h1><%= greet %></h1>
<%
# import MySQL module
from mod_python import MySQLdb
# connect
db = MySQLdb.connect(host="localhost", user="nobody", passwd="nobody",
db="qestar", unix_socket="/tmp/mysql.sock")
# create a cursor
cursor = db.cursor()
# execute SQL statement
cursor.execute("SELECT * FROM test")
# get the resultset as a tuple
result = cursor.fetchall()
# iterate through resultset
for record in result:
%>
<%= record[0] %> --> <%= record[1] %>
</html>
----------------------------------
Versi yang saya gunakan :
python2.4
MySQLdb nya dari module python2.4-mysqldb 1.2.1c3-1ubuntu1
tetapi kalau di jalankan dari shell dengan script di bawah ini bisa
berjalan dengan baik. artinya MySQLdb nya gak bermasalah.
#!/usr/bin/python
# import MySQL module
import MySQLdb
# connect
db = MySQLdb.connect(host="localhost", user="nobody", passwd="nobody",
db="qestar", unix_socket="/tmp/mysql.sock")
# create a cursor
cursor = db.cursor()
# execute SQL statement
cursor.execute("SELECT * FROM test")
# get the resultset as a tuple
result = cursor.fetchall()
# iterate through resultset
for record in result:
print record[0] , "-->", record[1]
Mohon pencerahan nya.
--
Berhenti langganan: [EMAIL PROTECTED]
Arsip dan info: http://linux.or.id/milis
