I used this script (http://code.google.com/p/web2py/source/browse/ scripts/setup-web2py-ubuntu.sh) to install web2py on a fresh linode.com VPS with Lucid. I created my postgres user and database as outlined in the web2py manual (http://web2py.com/book/default/chapter/ 11#PostgreSQL). When I try and connect to the postgres databse I get a "global name 'psycopg2' is not defined" error. I've done some searching and maybe it's due to mod_wsgi not being configured to the python version I am running (2.6.5) but when I use "ldd mod_wsgi.so" I get this output:
linux-gate.so.1 => (0xf57fe000) libpython2.6.so.1.0 => /usr/lib/libpython2.6.so.1.0 (0xb75ee000) libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0xb75d5000) libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0xb75d1000) libutil.so.1 => /lib/tls/i686/cmov/libutil.so.1 (0xb75cc000) libm.so.6 => /lib/tls/i686/cmov/libm.so.6 (0xb75a6000) libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0xb744c000) libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0xb7406000) libcrypto.so.0.9.8 => /lib/i686/cmov/libcrypto.so.0.9.8 (0xb72b4000) libz.so.1 => /lib/libz.so.1 (0xb729e000) /lib/ld-linux.so.2 (0xb7869000) Is that what it should be? I've tried extensive Google searches but am stumped at this point. importing psycopg2 from the python interpreter works. Thanks for any suggestions, Dave