Hi,
I'm relatively new to web2py and am attempting to set up my production
environment for the first time. I'm running Apache2.2 with mod_wsgi,
python 2.7, & web2py 1.88.2 on Win XP SP3. If I run web2py without
Apache by running: 'python web2py.py -a "<recycle>" -i 127.0.0.1 -p
8000' I can access both my application and the admin interface without
any problems. Once I try to access my site running behind Apache
though, I receive a ticket containing the following trackback:
Traceback (most recent call last):
File "C:\web2py\gluon\restricted.py", line 188, in restricted
exec ccode in environment
File "C:/web2py/applications/lunch/models/db.py", line 11, in
<module>
db = DAL('mssql://lunch:lu...@b1ts003/lunch1')
File "C:\web2py\gluon\sql.py", line 4048, in DAL
raise RuntimeError, "%s (tried 5 times)" % exception
RuntimeError: global name 'pyodbc' is not defined (tried 5 times)
If I run web2py in terminal mode and import pyodbc I don't receive any
errors:
C:\web2py>python web2py.py -S welcome -P
No handlers could be found for logger "web2py"
web2py Enterprise Web Framework
Created by Massimo Di Pierro, Copyright 2007-2010
Version 1.88.2 (2010-10-29 23:04:43)
Database drivers available: SQLite3, MSSQL/DB2
Python 2.7 (r27:82525, Jul 4 2010, 09:01:59) [MSC v.1500 32 bit
(Intel)] on win
32
Type "help", "copyright", "credits" or "license" for more information.
(InteractiveConsole)
>>> import pyodbc
>>>
I'm sure I'm probably just missing something in my confiration, but
after scouring the web2py book and searching Google I haven't been
able to find a solution. I'd greatly appreciate any suggestions, or
if you need additional info, please let me know!
Thanks,
Adam
