Yeah, it's all spelled fine (not like I typed it there, sorry!) and
the database exists. Obviously if web2py was connecting to PostgreSQL
it would give a "database not found" or a "cannot write to database"
error or something, not a python "cannot find psycopg2" module.
I think now that the question that needs answering is why can't WSGI
web2py see psycop2 even though terminal web2py can...? I'm not gonna
say BUG, but I can't work out what Im doing wrong!
On Apr 2, 1:40 am, Yarko Tymciurak <resultsinsoftw...@gmail.com>
wrote:
> On Apr 1, 4:40 pm, Richie <richie.d...@googlemail.com> wrote:
>
> > 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.
>
> A really basic check: have you created the database, "appdb", and
> given it no-password rights to user "posttgres" (? is that use spelled
> correctly???) for at least read and modify?
>
> - Yarko
>
>
>
> > "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 <thade...@thadeusb.com> 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 <richie.d...@googlemail.com> 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 <thade...@thadeusb.com> 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 <richie.d...@googlemail.com>
> > > >> 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 <thade...@thadeusb.com> 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
>
> > > >> >> <resultsinsoftw...@gmail.com> wrote:
> > > >> >> > On Apr 1, 3:12 pm, Thadeus Burgess <thade...@thadeusb.com> 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
> > > >> >> >> <richie.d...@googlemail.com> 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 web...@googlegroups.com.
> > > >> >> >> > To unsubscribe from this group, send email to
> > > >> >> >> > web2py+unsubscr...@googlegroups.com.
> > > >> >> >> > 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 web...@googlegroups.com.
> > > >> >> > To unsubscribe from this group, send email to
> > > >> >> > web2py+unsubscr...@googlegroups.com.
> > > >> >> > 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 web...@googlegroups.com.
> > > >> > To unsubscribe from this group, send email to
> > > >> > web2py+unsubscr...@googlegroups.com.
> > > >> > 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 web...@googlegroups.com.
> > > > To unsubscribe from this group, send email to
> > > > web2py+unsubscr...@googlegroups.com.
> > > > 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 web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
