I had to change my connection string to this: db_users = DAL('postgres:psycopg2://warplyde_fto:password@localhost /warplyde_fto')
On Mon, Mar 12, 2012 at 7:23 AM, Richard Vézina <ml.richard.vez...@gmail.com > wrote: > Curious if the issue I have with my app coulb become from the new pg8000 > driver?? > > > https://groups.google.com/forum/?fromgroups#!searchin/web2py/%5Bweb2py%5D$20my$20app$20not$20works$20with$20web2py$201.99.7/web2py/i7wx6JVTOtw/JlaULRp8G0AJ > > Do I have to change anything in my connection string with the new web2py > 1.99.7?? > > Thanks > > Richard > > > On Sun, Mar 11, 2012 at 8:39 PM, Massimo Di Pierro < > massimo.dipie...@gmail.com> wrote: > >> fixing in trunk (while at PyCon print) >> >> >> On Saturday, 10 March 2012 17:16:57 UTC-6, Alan Etkin wrote: >>> >>> Line 1999 in trunk: >>> self.driver = drivers.get('pg8000') >>> Should be: >>> self.driver = self.drivers.get('pg8000') >>> >>> On Mar 10, 8:07 pm, Alan Etkin <spame...@gmail.com> wrote: >>> > If something changed (as now pg adapter supports pg8000 driver), old >>> > uri strings would have to be accepted also. I'd say it's is a bug. >>> > There seems to be a list/dict conflict in dal. >>> > >>> > On Mar 10, 2:16 pm, Bruce Wade <bruce.w...@gmail.com> wrote: >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > > db_users = DAL('postgres://warplyde_fto:**password@localhost >>> /warplyde_**fto') >>> > >>> > > Has something been changed in how we need to make database >>> connections >>> > > to postgres? >>> > >>> > > Traceback (most recent call last): >>> > > File >>> > > "/home/bruce/Development/wct_**dev/web2py_dev/projects/fto/**gluon/restricted.py", >>> >>> > > line 205, in restricted >>> > > exec ccode in environment >>> > > File "/home/bruce/Development/wct_**dev/web2py_dev/projects/fto/** >>> applications/signon/models/db.**py" >>> > > <http://127.0.0.1:8000/admin/**edit/signon/models/db.py<http://127.0.0.1:8000/admin/edit/signon/models/db.py>>, >>> line 14, in >>> > > <module> >>> > > db_users = DAL('postgres://warplyde_fto:**password@localhost >>> /warplyde_**fto') >>> > > File >>> > > "/home/bruce/Development/wct_**dev/web2py_dev/projects/fto/**gluon/dal.py", >>> >>> > > line 5968, in __init__ >>> > > raise RuntimeError, "Failure to connect, tried %d times:\n%s" % >>> > > (attempts, tb) >>> > > RuntimeError: Failure to connect, tried 5 times: >>> > > Traceback (most recent call last): >>> > > File >>> > > "/home/bruce/Development/wct_**dev/web2py_dev/projects/fto/**gluon/dal.py", >>> >>> > > line 5955, in __init__ >>> > > self._adapter = ADAPTERS[self._dbname](*args) >>> > > File >>> > > "/home/bruce/Development/wct_**dev/web2py_dev/projects/fto/**gluon/dal.py", >>> >>> > > line 1999, in __init__ >>> > > self.driver = drivers.get('pg8000') >>> > > AttributeError: 'list' object has no attribute 'get' >>> > >>> > > -- >>> > > -- >>> > > Regards, >>> > > Bruce Wadehttp://ca.linkedin.com/in/**brucelwadehttp://www.** >>> wadecybertech.comhttp:.<http://ca.linkedin.com/in/brucelwadehttp://www.wadecybertech.comhttp:.> >>> .. >> >> > -- -- Regards, Bruce Wade http://ca.linkedin.com/in/brucelwade http://www.wadecybertech.com http://www.warplydesigned.com http://www.fitnessfriendsfinder.com