Ok if I copy my custom auth models into a new app it keeps loading the page for ever and don't create the table at postgres level.
Richard On Tue, May 15, 2012 at 10:19 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Yes I try a new app without defining auth models myself, just changed the > connection string for postgres and it works. > > I don't have the typo in my code, it maybe happen when copy/paste the code > somehow. > > I just add this : auth=Auth(db, *hmac_key=Auth.get_or_create_key()*) > > No change. > > Richard > > > On Tue, May 15, 2012 at 10:04 AM, Massimo Di Pierro < > massimo.dipie...@gmail.com> wrote: > >> There is a typo in your code: >> >> uth.settings.hmac_key='sha512:**8e95c268-cc31-4119-890d-**a5790d3e05d3' >> >> should be >> >> auth.settings.hmac_key='sha512:**8e95c268-cc31-4119-890d-**a5790d3e05d3' >> >> although this is probably not the cause for your problems. Does it work >> if you use sqlite? Does it work if you use postgresql with a new database? >> >> On Monday, 14 May 2012 15:53:40 UTC-5, Richard wrote: >>> >>> Hello, >>> >>> I try one more time to upgrade to 1.99.7 today without succes. But now I >>> know what append... It works fine, until I try to logon with a user... >>> >>> In shell it works fine, can access to any tables... >>> >>> Is there change to the logon process has been changed between 1.99.4 and >>> 1.99.7? >>> >>> Thanks >>> >>> Richard >>> >>> On Thu, Mar 8, 2012 at 12:54 PM, Richard Vézina < >>> ml.richard.vez...@gmail.com> wrote: >>> >>>> Ping! >>>> >>>> Richard >>>> >>>> >>>> On Wed, Mar 7, 2012 at 10:48 AM, Richard Vézina < >>>> ml.richard.vez...@gmail.com> wrote: >>>> >>>>> I use to download source package and make my update by my own >>>>> (manually). I don't use the update feature. >>>>> >>>>> Here most of my db.py that contain db connection and all related >>>>> auth configuration : >>>>> >>>>> db=DAL('postgres://USER:**PASSWORD@127.0.0.1:5432/**DATABASE<http://USER:PASSWORD@127.0.0.1:5432/DATABASE>', >>>>> \ >>>>> migrate_enabled=False) >>>>> >>>>> >>>>> from gluon.tools import * >>>>> auth=Auth(globals(),db) # authentication/authorization >>>>> >>>>> auth_table = db.define_table( >>>>> auth.settings.table_user_name, >>>>> Field('first_name', length=128, default=None, >>>>> required=True, >>>>> notnull=True, >>>>> requires = IS_NOT_EMPTY(error_message=T(** >>>>> auth.messages.is_empty)), >>>>> ), >>>>> Field('last_name', length=128, default=None, >>>>> requires = IS_NOT_EMPTY(error_message=T(** >>>>> auth.messages.is_empty)), >>>>> ), >>>>> Field('email', length=128, default=None, unique=True, >>>>> label=T('Email'), >>>>> requires = [IS_EMAIL(error_message=T(** >>>>> auth.messages.invalid_email)), >>>>> IS_NOT_IN_DB(db, 'auth_user.email')], >>>>> ), >>>>> Field('password', 'password', length=256, >>>>> readable=False, label=T('Password'), >>>>> required=True, >>>>> notnull=True, >>>>> requires = CRYPT(min_length=auth.** >>>>> settings.password_min_length, >>>>> error_message=T('too short')) >>>>> ), >>>>> Field('registration_key', length=128, default=None, >>>>> writable=False, readable=False), >>>>> Field('reset_password_key', length=512, >>>>> writable=False, readable=False, default=None >>>>> ), >>>>> Field('initials','string',**length=5), >>>>> migrate=False, >>>>> format='%(first_name)s %(last_name)s (%(id)s)') >>>>> >>>>> auth.settings.table_user = auth_table # no idea what this line do... >>>>> >>>>> auth_table = db.define_table( >>>>> auth.settings.table_event_**name, >>>>> Field('time_stamp','datetime',**default=request.now), >>>>> Field('client_ip','string',**length=512,default=request.**client), >>>>> Field('user_id',db.auth_user), >>>>> Field('origin','string',**length=512), >>>>> Field('description','text'), >>>>> migrate=False,) >>>>> >>>>> auth_table = db.define_table( >>>>> auth.settings.table_group_**name, >>>>> Field('role','string',length=**512), >>>>> Field('description','text'), >>>>> migrate=False, >>>>> format='%(role)s (%(id)s)') >>>>> >>>>> auth_table = db.define_table( >>>>> auth.settings.table_**membership_name, >>>>> Field('user_id','db.auth_user'**), >>>>> Field('group_id','db.auth_**group'), >>>>> migrate=False,) >>>>> >>>>> db.auth_membership.user_id.**requires=IS_IN_DB(db,'auth_**user.id<http://auth_user.id>','%(first_name)s >>>>> %(last_name)s (%(id)s)') >>>>> db.auth_membership.group_id.**requires=IS_IN_DB(db,'auth_**group.id<http://auth_group.id> >>>>> ','%(role)s-%(**description)s (%(id)s)') >>>>> >>>>> db.auth_membership.user_id.**represent=\ >>>>> lambda value: (value!=None and "%(first_name)s %(last_name)s >>>>> (%(id)s)" %db.auth_user[value]) or 'None' >>>>> db.auth_membership.group_id.**represent=\ >>>>> lambda value: (value!=None and "%(role)s (%(id)s)" >>>>> %db.auth_group[value]) or 'None' >>>>> >>>>> db.define_table('auth_group_**allowed', >>>>> Field('id','id'), >>>>> Field('user_id','db.auth_user'**), >>>>> Field('group_id','db.auth_**group'), >>>>> Field('active_gr','boolean'), >>>>> migrate=False, >>>>> sequence_name='auth_group_**allowed_id_seq') >>>>> >>>>> db.auth_group_allowed.user_id.**requires=IS_IN_DB(db,'auth_**user.id<http://auth_user.id>','%(first_name)s >>>>> %(last_name)s (%(id)s)') >>>>> db.auth_group_allowed.group_**id.requires=IS_IN_DB(db,'auth_**group.id<http://auth_group.id>','%(role)s >>>>> (%(id)s)') >>>>> >>>>> db.auth_group_allowed.user_id.**represent=\ >>>>> lambda value: (value!=None and "%(first_name)s %(last_name)s >>>>> (%(id)s)" %db.auth_user[value]) or 'None' >>>>> db.auth_group_allowed.group_**id.represent=\ >>>>> lambda value: (value!=None and "%(role)s (%(id)s)" >>>>> %db.auth_group[value]) or 'None' >>>>> >>>>> auth_table = db.define_table( >>>>> auth.settings.table_**permission_name, >>>>> Field('group_id','db.auth_**group'), >>>>> Field('name','string',length=**512), >>>>> Field('table_name','string',**length=512), >>>>> Field('record_id','integer'), >>>>> migrate=False,) >>>>> >>>>> db.auth_permission.group_id.**requires=\ >>>>> IS_IN_DB(db,'auth_group.id','%**(role)s (%(id)s)') >>>>> >>>>> db.auth_permission.group_id.**represent=\ >>>>> lambda id: "%(role)s (%(id)s)" %db.auth_group[id] >>>>> >>>>> auth_table = db.define_table( >>>>> auth.settings.table_cas_name, >>>>> Field('user_id','integer'), >>>>> Field('created_on','datetime')**, >>>>> Field('url','string',length=**512), >>>>> Field('uuid','string',length=**512), >>>>> migrate=False,) >>>>> >>>>> crud=Crud(globals(),db) # for CRUD helpers using auth >>>>> service=Service(globals()) # for json, xml, jsonrpc, xmlrpc, >>>>> amfrpc >>>>> >>>>> crud.settings.auth=auth >>>>> >>>>> uth.settings.hmac_key='sha512:**8e95c268-cc31-4119-890d-** >>>>> a5790d3e05d3' >>>>> auth.define_tables() # creates all needed tables >>>>> auth.settings.actions_**disabled.append('profile') # prohibit users >>>>> to modify their profile >>>>> auth.settings.actions_**disabled.append('register') >>>>> >>>>> Thanks >>>>> >>>>> Richard >>>>> >>>>> >>>>> On Wed, Mar 7, 2012 at 10:24 AM, pbreit <pbreitenb...@gmail.com>wrote: >>>>> >>>>>> Are you able to upgrade to most recent version of Web2py? We might >>>>>> need to see more of your model code that specifies the DB and auth. >>>>> >>>>> >>>>> >>>> >>> >