>From command line python "db = DAL('postgres://posttg...@localhost:
5432/appdb')" gives a "FATAL: no pg_hba.conf entry for host
"127.0.0.1", user "postgres", database "appdb", SSL off" but this is a
different issue that I can sort out later! It is still accessing that
postgres server to get that error, which web2py isn't.
"import psycopg2" works perfectly.
Seems like web2py's dal.py module cannot find psycop2 even though
command line python can, but I have no idea why. Path probs? I'm
clueless!
On Apr 1, 9:55 pm, Thadeus Burgess <[email protected]> wrote:
> And to triple make sure... from the shell printing sys.version gives
> exactly the same, date, revision, GCC version ?
>
> mod_wsgi was compiled with the same version of python installed?
>
> So just to make sure you only get the GlobalName when you access
> web2py through mod_wsgi ?
>
> tburg...@***-dev:~/Applications/web2py$ python web2py.py -S welcome
>
> >>> db = DAL('postgres://user:p...@localhost:1234/database')
>
> Correct?
>
> and
>
> tburg...@***-dev:~/Applications/web2py$ python
>
> >>> import psycopg2
>
> -Thadeus
>
> On Thu, Apr 1, 2010 at 2:46 PM, Richie <[email protected]> wrote:
> > Worked fine..
>
> > 2.5.2 (r252:60911, Jan 20 2010, 23:30:56)
> > [GCC 4.2.4 (Ubuntu 4.2.4-1ubuntu3)]
>
> > Same version!
>
> > Extra confused now...
>
> > On Apr 1, 9:42 pm, Thadeus Burgess <[email protected]> wrote:
> >> So mod_wsgi will not let you print, try this (before your db=DAL(...)
> >> statement)
>
> >> import sys
>
> >> tmp_file = open('/path/to/a/writable/file.txt', 'w')
> >> tmp_file.write(sys.version)
> >> tmp_file.close()
>
> >> db = DAL(...)
>
> >> Try and access default controller (you will get an error, but now we
> >> have a file) Open up the file, and make sure the version corresponds
> >> to the one your shell is using.
>
> >> Probably not the most elegant way, but its quick.
>
> >> -Thadeus
>
> >> On Thu, Apr 1, 2010 at 2:39 PM, Richie <[email protected]> wrote:
> >> > @Thadeus
>
> >> > Statement 1 it is. How do I check the version mod_wsgi is using?
>
> >> > I really appreciate the help!
>
> >> > On Apr 1, 9:22 pm, Thadeus Burgess <[email protected]> wrote:
> >> >> We are confused.
>
> >> >> 1) He said he gets the error when "I try to access default controller".
>
> >> >> 2) He did not say "I try to access psycopg2 from my controller".
>
> >> >> I take what he said to mean (statement 1) he cannot connect to
> >> >> postgres with web2py. Perhaps he really ment statement 2, in which you
> >> >> are correct.
>
> >> >> -Thadeus
>
> >> >> On Thu, Apr 1, 2010 at 2:16 PM, Yarko Tymciurak
>
> >> >> <[email protected]> wrote:
> >> >> > On Apr 1, 3:12 pm, Thadeus Burgess <[email protected]> wrote:
> >> >> >> Make sure mod_wsgi is running the same version of python that you
> >> >> >> have
> >> >> >> psycopg2 installed.
>
> >> >> > that is not the point / problem here;
>
> >> >> > anyway, python web2py.py -S welcome, and an attempt to "import
> >> >> > psycopg2" from that shell will show that you can import it fine from
> >> >> > the web2py app level; gluon.dal imports it, and your app doesn't get
> >> >> > to see it for a reason.
>
> >> >> >> -Thadeus
>
> >> >> >> On Thu, Apr 1, 2010 at 1:48 PM, Richie <[email protected]>
> >> >> >> wrote:
> >> >> >> > I can import psycopg2 from a python shell, but I'm getting
> >> >> >> > "NameError:
> >> >> >> > global name 'psycopg2' is not defined" when I try to access my
> >> >> >> > default
> >> >> >> > controller. I'm setup with Apache and MOD WSGI. Anyone got any
> >> >> >> > ideas?
>
> >> >> >> > Thanks!
>
> >> >> >> > Rich
>
> >> >> >> > --
> >> >> >> > You received this message because you are subscribed to the Google
> >> >> >> > Groups "web2py-users" group.
> >> >> >> > To post to this group, send email to [email protected].
> >> >> >> > To unsubscribe from this group, send email to
> >> >> >> > [email protected].
> >> >> >> > For more options, visit this group
> >> >> >> > athttp://groups.google.com/group/web2py?hl=en.
>
> >> >> > --
> >> >> > You received this message because you are subscribed to the Google
> >> >> > Groups "web2py-users" group.
> >> >> > To post to this group, send email to [email protected].
> >> >> > To unsubscribe from this group, send email to
> >> >> > [email protected].
> >> >> > For more options, visit this group
> >> >> > athttp://groups.google.com/group/web2py?hl=en.
>
> >> > --
> >> > You received this message because you are subscribed to the Google
> >> > Groups "web2py-users" group.
> >> > To post to this group, send email to [email protected].
> >> > To unsubscribe from this group, send email to
> >> > [email protected].
> >> > For more options, visit this group
> >> > athttp://groups.google.com/group/web2py?hl=en.
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "web2py-users" group.
> > To post to this group, send email to [email protected].
> > To unsubscribe from this group, send email to
> > [email protected].
> > For more options, visit this group
> > athttp://groups.google.com/group/web2py?hl=en.
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
