[web2py] Web2py binary distribution and psycopg2 driver

[Álvaro J . Iradier]

Hi,

I was trying to distribute an application with web2py binary for
windows, but I required the PostgreSQL driver. So I copied the
psycopg2 files to site-packages in the web2py binary folder.

If I start a shell from an application, I can import psycopg2 and
connect to the database. However, it looks like the DAL does not
recognize the psycopg2 driver. I am getting the error:


Traceback (most recent call last):
  File "gluon/restricted.py", line 204, in restricted
  File "C:/Users/airadier/Downloads/web2py_win/web2py/applications/
init/models/10_db.py", line 13, in <module>
  File "gluon/dal.py", line 4749, in __init__
RuntimeError: Failure to connect, tried 5 times:
Traceback (most recent call last):
  File "gluon/dal.py", line 4736, in __init__
  File "gluon/dal.py", line 1867, in __init__
RuntimeError: Unable to import driver

My guess is when DAL is being initialized, the site-packages folder is
not yet in the sys.path, so the following fails:

    try:
        import psycopg2
        from psycopg2.extensions import adapt as psycopg2_adapt
        drivers.append('PostgreSQL')
    except ImportError:
        logger.debug('no psycopg2 driver')

Is there a reason for this? Is it a bug or a feature?

Is there other way to acomplish these? And is it allowed to distribute
a binary web2py including the PostgreSQL driver?

Thanks in advance.