I found something in the archive.
This seems to be multiple python versions issue, but still do not have a
solution. Unfortunately, this server is preinstalled with python2.4 and
I am trying to use 2.6, which can't be probably found under mod_wsgi
Julius
V Štvrtok, 27. máj 2010 o 12:54 +0200, Julius Minka napísal(a):
> I was too fast.
> It works when accessed on port.
>
> It doesn't when accessed through mod_wsgi:
>
> File "gluon/sql.py", line 3835, in DAL
> migrate=migrate, fake_migrate=fake_migrate)
> File "gluon/sql.py", line 959, in __init__
> self._pool_connection(lambda : psycopg2.connect(msg))
> File "gluon/sql.py", line 830, in _pool_connection
> self._connection = f()
> File "gluon/sql.py", line 959, in <lambda>
> self._pool_connection(lambda : psycopg2.connect(msg))
> NameError: global name 'psycopg2' is not defined
>
> how are both environments different?
> Julius
>
>
>
>
> V Štvrtok, 27. máj 2010 o 12:20 +0200, Julius Minka napísal(a):
> > I found the reason by removing exception catching when connecting to
> > Postgres in gluon/sql.py.
> > It told me that this line
> > self._execute("SET standard_conforming_strings=on;")
> > is a problem.
> > I commented it out and everything is fine until now.
> > Can this removal have a side effect?
> > Julius
> >
> >
> > V Štvrtok, 27. máj 2010 o 10:41 +0200, Julius Minka napísal(a):
> > > I did that as first thing. No luck.
> > > I changed it to IP as I it works from command line.
> > >
> > > Julius
> > >
> > > V Streda, 26. máj 2010 o 19:41 -0500, Thadeus Burgess napísal(a):
> > > > Try
> > > >
> > > > postgres://w2p:passw...@localhost:5432/w2p
> > > >
> > > > --
> > > > Thadeus
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > On Wed, May 26, 2010 at 5:17 PM, Julius Minka <j...@minka.sk> wrote:
> > > > > This is virtual server with centos 5.5 in internet.
> > > > > I have successfully instaled web2py with Apache and mod_wsgi based
> > > > > mainly on instructions from
> > > > > http://web2py.com/AlterEgo/default/show/239 and
> > > > > http://web2py.com/AlterEgo/default/show/240
> > > > >
> > > > > Probably last step is missing.
> > > > > I am getting this error when accessing site from internet:
> > > > > RuntimeError: Failure to connect to DB. Tried 5 times
> > > > >
> > > > > when I start it from command line, it shows support for PostgreSQL:
> > > > > python2.6 web2py/web2py.py -i xx.xx.xx.xx -p 7777 -a password
> > > > >
> > > > > web2py Enterprise Web Framework
> > > > > Created by Massimo Di Pierro, Copyright 2007-2010
> > > > > Version 1.78.3 (2010-05-17 21:59:39)
> > > > > Database drivers available: PostgreSQL
> > > > > Starting hardcron...
> > > > > WARNING:root:GUI not available because Tk library is not installed
> > > > > please visit:
> > > > > http://......
> > > > >
> > > > >
> > > > > I can verify access from command line:
> > > > > psql -U w2p -d w2p -h 127.0.0.1 -p 5432
> > > > > Password for user w2p:
> > > > > Welcome to psql 8.1.21, the PostgreSQL interactive terminal.
> > > > >
> > > > > Type: \copyright for distribution terms
> > > > > \h for help with SQL commands
> > > > > \? for help with psql commands
> > > > > \g or terminate with semicolon to execute query
> > > > > \q to quit
> > > > >
> > > > > w2p=# \q
> > > > >
> > > > > It works.
> > > > >
> > > > >
> > > > > In ... web2py/applications/welcome/models/db.py
> > > > > db = DAL('postgres://w2p:passw...@127.0.0.1:5432/w2p')
> > > > >
> > > > > What could be the problem? I have no further idea how to verify the
> > > > > reason for failure of connection.
> > > > >
> > > > > Julius
> > > > >
> > > > >
> > > > >
> > >
> > >
> >
> >
>
>
