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.
