I defined a custom auth_user table:
db.define_table(
auth.settings.table_user_name,
Field('title',length=8,requires=IS_IN_SET(['de
heer','mevrouw'],zero=T('Select a value')),label='Aanheft * '),
Field('firstName',length=32,requires=IS_LENGTH(32,error_message=T('length
exceeds 32 characters')),label='Voornaam'),
Field('lastName',length=64,default='',requires=[IS_LENGTH(64,error_message=T('length
exceeds 64 charactrer')),IS_NOT_EMPTY()],notnull=True,label='Achternaam *
'),
Field('shortname',default='',requires=[IS_LENGTH(128,error_message=T('length
exceeds 128
characters')),IS_EMPTY_OR(IS_NOT_IN_DB(db,'custom_auth_table.shortname',error_message=T('shortname
already in database')))],notnull=True,unique=True),
Field('phone',length=16,requires=IS_LENGTH(16,error_message='length
exceeds 16 characters'),label='Telefoon'),
Field('email',length=128,default='',requires=[IS_LENGTH(128,error_message=T('length
exceeds 128 characters')),IS_EMAIL(error_message=T('invalid
email')),IS_NOT_IN_DB(db,'custom_auth_table.email',error_message=T('email
already in database'))],notnull=True,unique=True,label='E-mail * '),
Field('username',length=32,default='',requires=[IS_LENGTH(32,error_message=T('length
exceeds 32
charactrer')),IS_NOT_EMPTY(),IS_NOT_IN_DB(db,'custom_auth_table.username',error_message=T('username
already in
database'))],notnull=True,unique=True,writable=False,readable=False,label='Gebruikersnaam
* '),
Field('password',
type='password',length=512,requires=[IS_STRONG(),CRYPT()],readable=False,label='Wachtwoord
* '),
Field('nodeID','reference
node',default='',requires=[IS_IN_DB(db,'node.id','%(id)s',zero=T('Select a
value'))],ondelete='CASCADE',notnull=True,label='NodeID *
',writable=False,readable=False),
Field('comment',type='text',requires=IS_LENGTH(512,error_message=T('length
exceeds 512 characters'))),
Field('registration_key',length=512,default='',writable=False,readable=False),
Field('reset_password_key',length=512,default='',writable=False,readable=False),
Field('registration_id',length=512,default='',writable=False,readable=False),
Field('createdOn',type='datetime',default=request.now),
Field('modifiedOn',type='datetime',default=request.now,update=request.now))
## get the custom_auth_table
custom_auth_table = db[auth.settings.table_user_name]
## tell auth to use custom_auth_table
auth.settings.table_user = custom_auth_table
## to prevent the auth_cas table from being created
auth.settings.cas_domains = None
## create all tables needed by auth if not custom tables
auth.define_tables(migrate=True,username=True,signature=False)
When I enter a user I get the following error:
Traceback (most recent call last):
File "/Library/Python/2.6/site-packages/web2py/gluon/restricted.py", line
209, in restricted
exec ccode in environment
File
"/Library/Python/2.6/site-packages/web2py/applications/init/controllers/appadmin.py"
<http://127.0.0.1:8000/admin/default/edit/init/controllers/appadmin.py>, line
444, in <module>
File "/Library/Python/2.6/site-packages/web2py/gluon/globals.py", line 185,
in <lambda>
self._caller = lambda f: f()
File
"/Library/Python/2.6/site-packages/web2py/applications/init/controllers/appadmin.py"
<http://127.0.0.1:8000/admin/default/edit/init/controllers/appadmin.py>, line
129, in insert
if form.accepts(request.vars, session):
File "/Library/Python/2.6/site-packages/web2py/gluon/sqlhtml.py", line 1223,
in accepts
hideerror=hideerror,
File "/Library/Python/2.6/site-packages/web2py/gluon/html.py", line 1952, in
accepts
status = self._traverse(status,hideerror)
File "/Library/Python/2.6/site-packages/web2py/gluon/html.py", line 820, in
_traverse
newstatus = c._traverse(status,hideerror) and newstatus
File "/Library/Python/2.6/site-packages/web2py/gluon/html.py", line 820, in
_traverse
newstatus = c._traverse(status,hideerror) and newstatus
File "/Library/Python/2.6/site-packages/web2py/gluon/html.py", line 820, in
_traverse
newstatus = c._traverse(status,hideerror) and newstatus
File "/Library/Python/2.6/site-packages/web2py/gluon/html.py", line 820, in
_traverse
newstatus = c._traverse(status,hideerror) and newstatus
File "/Library/Python/2.6/site-packages/web2py/gluon/html.py", line 827, in
_traverse
newstatus = self._validate()
File "/Library/Python/2.6/site-packages/web2py/gluon/html.py", line 1706, in
_validate
(value, errors) = validator(value)
File "/Library/Python/2.6/site-packages/web2py/gluon/validators.py", line
2505, in __call__
return self.other(value)
File "/Library/Python/2.6/site-packages/web2py/gluon/validators.py", line
558, in __call__
table = self.dbset.db[tablename]
File "/Library/Python/2.6/site-packages/web2py/gluon/dal.py", line 7136, in
__getitem__
return self.__getattr__(str(key))
File "/Library/Python/2.6/site-packages/web2py/gluon/dal.py", line 7143, in
__getattr__
return ogetattr(self, key)
AttributeError: 'DAL' object has no attribute 'custom_auth_table'
What's wrong with this way of defining a custom auth_user table?
Annet
--
