Finally you are missing some required fields in your new auth table: Look at: http://web2py.com/books/default/chapter/29/9#Customizing-Auth to see the required fields.
On Mon, Mar 12, 2012 at 8:46 AM, Bruce Wade <bruce.w...@gmail.com> wrote: > Why are you doing this: auth=Auth(globals(),db) ? globals will not even > be processed it will only look at the first param and set it to db if the > db (second param) doesn't exist. > auth = Auth(db) is how it should be > > Also I think this is where your problem is: > auth.settings.table_user = auth_table # no idea what this line do... > > To customize the auth table: > > db.define_table( > auth.settings.table_user_name, > # fields > ) > > custom_auth_table = db[auth.settings.table_user_name] > # add validations > > auth.settings.table_user = custom_auth_table > > > On Mon, Mar 12, 2012 at 8:35 AM, Richard Vézina < > ml.richard.vez...@gmail.com> wrote: > >> Thank for the answer! >> >> But unfortunately for me it's not the origin of my problem it seems. >> >> Richard >> >> On Mon, Mar 12, 2012 at 11:12 AM, Bruce Wade <bruce.w...@gmail.com>wrote: >> >>> 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 >>> >> >> > > > -- > -- > Regards, > Bruce Wade > http://ca.linkedin.com/in/brucelwade > http://www.wadecybertech.com > http://www.warplydesigned.com > http://www.fitnessfriendsfinder.com > -- -- Regards, Bruce Wade http://ca.linkedin.com/in/brucelwade http://www.wadecybertech.com http://www.warplydesigned.com http://www.fitnessfriendsfinder.com