This topic is locked

XML export and encrypted password

2/12/2006 9:22:02 AM
ASPRunnerPro General questions
A
a_melchiore author

Hi Sergey, I have a couple of issue with encrypted passwords and exporting to XML. I'm sending you a e-mail with screen print of item 2.

  1. If I select encrypt passwords then I can never log back in to my application. I get an error message indicating invalid login. My users already have passwords in the database. How do I get existing passwords to be accepted?
  2. When I tried to export to xml I get the following errors:
    a)This comes up in a msgbox after the file download dialog box is displayed:
    Internet Explorer cannot download...all&type=xml&btnSubmit=Export from localhost
    <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2439&image=1&table=forumtopics' class='bbc_emoticon' alt='B)' /> This is displayed when I click ok on the previous box.
    The page cannot be displayedThe page cannot be displayed

    There is a problem with the page you are trying to reach and it cannot be displayed.
    Please try the following:

    Click the Refresh button, or try again later.
    Open the localhost home page, and then look for links to the information

    you want.

    HTTP 500.100 - Internal Server Error - ASP error

    Internet Information Services
    Technical Information (for support personnel)

    Error Type:

    msxml3.dll (0x80004005)

    This name may not contain the '=' character:

    RemoteResolutionChecked-->=<--Yes

    /Triple/Tickets_export.asp, line 653
    Browser Type:

    Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)

    Page:

    GET /Triple/Tickets_export.asp

    Time:

    Sunday, February 12, 2006, 8:08:50 AM

    More information:

    Microsoft Support

admin 2/12/2006

Abel,
since you use passord encryption you need to encrypt passwords in your database. New user passwords are encypted by ASP pages automatically however existing passwords need to be encrypted in order to be accepted. Probably you need to write a small routine that goes through all existing records and encrypt passwords using MD5 function that can be found in include/md5.asp file.
XML export error is caused by = character in field name. We'll fix this in the next update. Meanwhile you can rename this field dropping equals sign and rebuild ASP code.