Not sure I understand. If auth.define_tables(username=True) web2py defined
this
db.auth_user.username.requires = \
[IS_MATCH('[\w\.\-]+'),
IS_NOT_IN_DB(db, db.auth_user.username)]
On Thursday, 31 May 2012 15:36:59 UTC-5, Osman Masood wrote:
>
> Thanks for the prompt response. Looks like according to the book, using
> 'username' should be allowed though:
> By default, web2py uses email for login. If instead you want to log in
> using username set auth.define_tables(username=True)
> Also:
> If you add a field called "username", it will be used in place of "email"
> for login. If you do, you will need to add a validator as well:
>
> 1.
>
> auth_table.username.requires = IS_NOT_IN_DB(db, auth_table.username)
>
>
> (from http://web2py.com/books/default/chapter/29/9)
>
> I can add in the functionality into tools.py, if you want.
> Thanks
>
> On Thursday, May 31, 2012 1:30:11 PM UTC-7, Massimo Di Pierro wrote:
>>
>> The email field is required. If you omit it there is nowhere to send
>> lost-password messages.
>>
>> Anyway. You just need:
>>
>> auth.define_tables(username=True, signature=False, migrate=False)
>>
>> You do not need all the code before that line.
>>
>> On Thursday, 31 May 2012 15:09:39 UTC-5, Osman Masood wrote:
>>>
>>> Hi,
>>> I have a custom table, and I'm trying to use a 'username' field instead
>>> of an 'email' field (since the book says if there's a username field, it
>>> will be used instead of the email field).
>>> However, whenever I try the 'forgot my username' function, it gives me
>>> an error, saying:
>>> <type 'exceptions.KeyError'> 'email'
>>> (Looks like it's trying to access the email field, which of course
>>> doesn't exist.)
>>>
>>> Here's my code:
>>> auth.settings.table_user_name = 'user'
>>> db.define_table(auth.settings.table_user_name,
>>> Field('username', length=60, unique=True, label='Email address'), #
>>> required
>>> Field('password', 'password', length=512, writable=False,
>>> readable=False, label='Password'), # required
>>> Field('registration_key', length=512, writable=False,
>>> readable=False, default=''), # required
>>> Field('reset_password_key', length=512, writable=False,
>>> readable=False, default=''), # required
>>> Field('registration_id', length=512, writable=False, readable=False,
>>> default=''), # required
>>> format='%(username)s')
>>>
>>> ## do not forget validators
>>> custom_auth_table = db[auth.settings.table_user_name] # get the
>>> custom_auth_table
>>> custom_auth_table.password.requires = [ CRYPT(key="mykey",
>>> digest_alg="sha512") ]
>>> custom_auth_table.username.requires = [
>>> IS_EMAIL(error_message=auth.messages.invalid_email),
>>> IS_NOT_IN_DB(db, custom_auth_table.username)] # we need this so
>>> that web2py uses username as the email address. unique is not good enough
>>> auth.settings.table_user = custom_auth_table # tell auth to use
>>> custom_auth_table
>>>
>>> ## configure auth policy
>>> auth.settings.registration_requires_verification = True
>>> auth.settings.registration_requires_approval = True
>>> auth.settings.reset_password_requires_verification = True
>>> auth.messages.verify_email = 'Click on the link http://' + \
>>> request.env.http_host + \
>>> URL(r=request,c='default',f='user',args=['verify_email']) + \
>>> '/%(key)s to verify your email'
>>> auth.messages.reset_password = 'Click on the link http://' + \
>>> request.env.http_host + \
>>> URL(r=request,c='default',f='user',args=['reset_password']) + \
>>> '/%(key)s to reset your password'
>>>
>>> auth.define_tables(username=True, signature=False, migrate=False)
>>>
>>> ## configure email
>>> mail=auth.settings.mailer
>>> mail.settings.server = 'smtp.gmail.com:587' or 'logging'
>>> mail.settings.sender = '[email protected]'
>>> mail.settings.login = '[email protected]:mypass'
>>>
>>>
>>> And here's the error traceback:
>>>
>>> Traceback (most recent call last):
>>> File "/home/www-data/web2py/gluon/restricted.py", line 205, in restricted
>>> exec ccode in environment
>>> File
>>> "/home/www-data/web2py/applications/Talent_Web/controllers/default.py"
>>> <https://ec2-204-236-184-137.us-west-1.compute.amazonaws.com/admin/default/edit/Talent_Web/controllers/default.py>,
>>> line 73, in <module>
>>> File "/home/www-data/web2py/gluon/globals.py", line 175, in <lambda>
>>> self._caller = lambda f: f()
>>> File
>>> "/home/www-data/web2py/applications/Talent_Web/controllers/default.py"
>>> <https://ec2-204-236-184-137.us-west-1.compute.amazonaws.com/admin/default/edit/Talent_Web/controllers/default.py>,
>>> line 34, in user
>>> return dict(form=auth())
>>> File "/home/www-data/web2py/gluon/tools.py", line 1196, in __call__
>>> return getattr(self,args[0])()
>>> File "/home/www-data/web2py/gluon/tools.py", line 2158, in
>>> retrieve_username
>>> old_requires = table_user.email.requires
>>> File "/home/www-data/web2py/gluon/dal.py", line 7180, in __getattr__
>>> return self[key]
>>> File "/home/www-data/web2py/gluon/dal.py", line 7120, in __getitem__
>>> return dict.__getitem__(self, str(key))
>>> KeyError: 'email'
>>>
>>>
