Sorry, I probably used the psycopg windows binaries with web2py source so using those installers will not solve the problem.
On 11 ene, 08:53, Álvaro J. Iradier <airad...@gmail.com> wrote: > Thanks for your comments. > > Do you remember how you did it? I can make it work correctly when > using the source version of web2py, and I installpsycopgunder the > python installation (c:\python27). > > However, when trying the binary distribution, I have tried extracting > the files from thepsycopgversion for python 2.5, and putting them: > > a) Inside web2py\site-packages: They work if I start a shell and try > "import psycopg2", "psycopg2.connect(...)", etc. However they are not > detected as an available driver, and trying to connect the DAL to > Postgres fails with "Unable to import driver" > b) I tried putting the files inside the library.zip file created by > py2exe, but it just didn't work even when importing from the > application shell... > > I have managed to get it working using portable python + web2py source > distribution, but I think it would be easier to bundle it with web2py > binary. > > Greets. > > On Jan 11, 11:55 am, Alan Etkin <spame...@gmail.com> wrote: > > > I think i installed one of the listed binary files listed here without > > problems:http://stickpeople.com/projects/python/win-psycopg/ > > > Regards > > > On 10 ene, 17:14, Álvaro J. Iradier <airad...@gmail.com> wrote: > > > > 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. > >
