I believe that the password field that web2py generates for MySQL is a varchar 32 which causes truncation of hashed passwords and prevents login. I was able to manually alter the field to varchar 128, reset my password and then it worked.
On Aug 18, 3:05 am, ed <[email protected]> wrote: > I can now login but the password is not encrypted in auth_user. Is it > possible the password field in login, edit profile and change password > are not encrypted so that when comparison is made to the > auth_user.password it is not equal and issues error "Invalid login"? > > On Aug 18, 3:50 pm, mdipierro <[email protected]> wrote: > > > Yes, after auth.define_tables() > > > db.auth_user.password.requires=[] > > > On Aug 18, 2:30 am, ed <[email protected]> wrote: > > > > How can I override password encryption. I want to check if the content > > > of password is the same as what I inputted. Is this possible? > > > > On Aug 18, 3:26 pm, mdipierro <[email protected]> wrote: > > > > > This is odd. You should be able to login. I do not see how this can > > > > fail. > > > > > Have you changed anything else? > > > > Has anybody else tried Ath withmysql? > > > > > Massimo > > > > > On Aug 18, 2:13 am, ed <[email protected]> wrote: > > > > > > auth_user.registration_key is blank. > > > > > > On Aug 18, 3:00 pm, mdipierro <[email protected]> wrote: > > > > > > > All I meant is visithttp://..../yourapp/appadmin > > > > > > and check what is in the registration_key field of those records. > > > > > > > On Aug 18, 1:56 am, ed <[email protected]> wrote: > > > > > > > > I registered 2 users and both were inmysqldatabase tables > > > > > > > auth_user, > > > > > > > auth_group, auth_event and auth_memebership. I remembered their > > > > > > > passwords and logged out. When I login, message "Invalid login" > > > > > > > was > > > > > > > displayed. You suggested trying appamdin, but didn't know how to > > > > > > > execute this. Sorry. > > > > > > > > On Aug 18, 1:00 pm, mdipierro <[email protected]> wrote: > > > > > > > > > Can you tell us more? What is in the database after > > > > > > > > registration? Try > > > > > > > > appamdin. > > > > > > > > > On Aug 17, 11:01 pm, ed <[email protected]> wrote: > > > > > > > > > > In sqlite I was able to register and login. However, inmysqlI > > > > > > > > > was > > > > > > > > > able to register only and was not able to login. > > > > > > > > > > On Aug 18, 11:49 am, ed <[email protected]> wrote: > > > > > > > > > > > Hi, > > > > > > > > > > I recently downloaded web2py 1.66 and tried Welcome app out > > > > > > > > > > of the box > > > > > > > > > > using sqlite, it worked. I changed tomysqland "Invalid > > > > > > > > > > login" is > > > > > > > > > > displayed. I only changed a line in db.py db= DAL("mysql:// > > > > > > > > > > root:xxxxxxx...@localhost:3306/alumnidb") so that i can > > > > > > > > > > usemysql. > > > > > > > > > > Thank you in advance. > > > > > > > > > > Cheers, > > > > > > > > > > ed --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
