On Apr 1, 4:40 pm, Richie <[email protected]> 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 <[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.
