This topic is locked

Invalid Login

1/25/2005 16:01:14
ASPRunnerPro General questions
sol_knar author

Hello,

I have asprunner set to create a login page with password and username pulled from a SQL table. I have the fields set to varchar. However I am unable to login. It still tells me that it was an invalid login. I can however login as a guest. Any thoughts?

Thanks,

William

CRS Computer Consulting

Sergey Kornilov admin 1/26/2005

William,
Could you zip and send to support@xlinesoft.com the whole content of ASPRunner output folder ( ASP files, include files, database etc.) along with the project file? I'll find what's wrong running it on my test box.

I
inetjunk 10/17/2007

Was this issue resolved? I'm experiencing the same problem. I've changed the field type from varchar to char and back, it doesn't help. This is the first time I've tried setting up a login profile with SQL, but I've been successful multiple times with MS Access.
Thanks in advance

Sergey Kornilov admin 10/17/2007

After you changed field type to VARCHAR make sure you removed trailing spaces from usernames/passwords.

I
iandbige 10/18/2007

I have experienced this problem as well, tracking the source in a debugger it looks like the password field is being compared to an MD5'd version, for me I use MySql so the passwords are not MD5 rather some other hash.
Still even when I stored a true MD5 in the password field there still is some problem?
Will keep looking into this, hey shouldn't I get paid for this? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=22371&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />

I
iandbige 10/19/2007

OK, Found out what the problem was, the passwords are in the clear unless you specifiy encrypt passwords in the security advanced. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=22376&image=1&table=forumreplies' class='bbc_emoticon' alt=':blink:' />