Yup, you were right, couldn't import.
so:
* downloaded and installed psycopg2 for python 2.7
* bounced the web2py server
Now, I get:
ApptestApp
* Index
Welcome to my new app
Thanks Massimo, you saved the day!
now, if only only sapdb was as easy going ;). Speaking of that, got an
email this morning with a few things to look at (the assumption is my
setup is bad ;) )
thanks,
Mart :)
On Mar 31, 3:08 pm, Massimo Di Pierro <massimo.dipie...@gmail.com>
wrote:
> open the web2py shell
>
> python web2py.py -S welcome -N
>
> and type
>
> >>> import psycopg2
>
> does it work? My guess is not. Either psycopg2 is not installed
> propery or you have conflicting python versions.
>
> On Mar 31, 1:52 pm, mart <msenecal...@gmail.com> wrote:
>
>
>
>
>
>
>
> > Hi,
>
> > I'm trying to install web2py with postgreSQL 9.0.3 and getting this
> > error when launching a test app:
>
> > Traceback (most recent call last):
> > File "C:\web\web_prod\web2py\gluon\restricted.py", line 188, in
> > restricted
> > exec ccode in environment
> > File "C:/web/web_prod/web2py/applications/appTest/models/db.py",
> > line 17, in <module>
> > db = DAL('postgres://postgres:*******@localhost/test') # if
> > not, use SQLite or other DB
> > File "C:\web\web_prod\web2py\gluon\dal.py", line 3665, in __init__
> > raise RuntimeError, "Failure to connect, tried 5 times:\n%s" %
> > error
> > RuntimeError: Failure to connect, tried 5 times:
> > global name 'psycopg2' is not defined
>
> > This is what I did:
> > * installed latest web2py (1.94.6) from source.
> > * downloaded and installed postgreSQL 9.0.3
> > * created test app with the wizard
>
> > I had to install on widows, so I used shared services, which seemed
> > like the easiest deployment (because on I have no clue how to deploy
> > web2y on Windows)
>
> > Can anyone tell the where & how to define psycopg2 with this setup?
>
> > Thanks,
> > Mart :)
