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 <[email protected] > wrote: > Ping! > > Richard > > > On Wed, Mar 7, 2012 at 10:48 AM, Richard Vézina < > [email protected]> 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:[email protected]: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','%(first_name)s >> %(last_name)s (%(id)s)') >> db.auth_membership.group_id.requires=IS_IN_DB(db,'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','%(first_name)s >> %(last_name)s (%(id)s)') >> db.auth_group_allowed.group_id.requires=IS_IN_DB(db,'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 <[email protected]> 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. >> >> >> >
