Results 1 to 6 of 6

Thread: Tornado - .dbLogin/Forgot Password

  1. #1
    Join Date
    Dec 2002
    Location
    Albany, NY
    Posts
    115

    Tornado - .dbLogin/Forgot Password

    Frank,

    The .dbLogin/Forgot Password doesn't work. The following error is sent after clicking the 'Forgot Password" button'

    (209-999 Property Syntax Error)
    Invalid Mail-From Address

    Here's my .dbLogin Code:

    Dim login as string = ""
    login = "Type=db||SQL=SELECT password,"
    login = login & "email FROM password WHERE ID = '[[ID]]'|"
    login = login & "LoginTitle=Login|FromAddr=NYAutoMail@h01rg_nt2.fh wa.dot.gov|"
    login = login & "EmailSubject=Your Password|"
    login = login & "EmailBody=Your password/id is : [[LoginID]]/[[password]]"
    .dbLogin = login

    What syntax is wrong here?

    Also, I needed to use the .dbMail for the SMTP Server and testrun parameters. that's why the SMTP Server parameter is missing from .dbLogin

    What do you suggest?

  2. #2
    Join Date
    Oct 2002
    Posts
    933
    I detect two problems -

    1. The "From" address breaks the system RE. Use a new RE to handle that. Add ->

    .dbEmailAddrRegEx = "\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*([,;]\s*\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*)*"


    2. After that try to see whether it'll send. If not then use a simple address like paul@yahoo.com and repeat the test.

    When I use your "From" address to test here, it is not working (...destination not valid within DNS...). If I use a simple one like frank@aspdb.com then it'll work.

    Resolve this first and I'll add the Email RE to the system test that'll handle this kind of Email Address.


    FK

  3. #3
    Join Date
    Dec 2002
    Location
    Albany, NY
    Posts
    115
    Frank,

    Nothing I tried worked. Still receiving the same error. I have email you some sample code I'm using to test this out. You'll need to set your DNS to point to the password table. I'm using msSQL server here.

    Paul

  4. #4
    Join Date
    Oct 2002
    Posts
    933
    try the working example I sent you and also use the same params in a simple dbMail app to verify their values.

    FK

  5. #5
    Join Date
    Jul 2004
    Posts
    39
    We figured out our problem... FINALLY.

    The dbMail function was conflicting with the dbLogin function for some reason.. we were under the impression that you needed dbMail in addition to the dbLogin for a forgotten password.

    -all is well with this issue now

    Quick question though-
    it says in the documentation that you need to designate the SMTP server in the dblogin function, but for some reason it still works without it. Will this cause problems??

    JM

  6. #6
    Join Date
    Oct 2002
    Posts
    933
    OH, the mail functionis included in the Login function. If SMTP server is not included then it'll use th edefualt one in IIS. It is better to speicfy that so that when you move the application, it'll not give you unexpected results.


    Frank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •