4 Replies Latest reply on Dec 28, 2007 2:38 AM by Günter Schenk

    Login/Password Page Problems

      I'm creating a login page for the first time and it's not working at all. Page shows up fine but when I enter the L/P even though I know it's correct, it tells me the password is invalid. Why?

      The page's code is here: http://209.62.4.98/~parishpr/admin/login.txt

      I'm wondering if it's because the fields must start in my database with kt_login_id, kt_login_name, etc. instead of just id, name, etc.
        • 1. Re: Login/Password Page Problems
          Günter Schenk Level 4
          Hi Adam,

          ----
          it tells me the password is invalid. Why?
          ----

          did you decide on the "Encrypt Password" option ? In this case you need to make sure to increase the maximal allowed "varchars" value of the login table´s "password" column to, say, 240 -- if this value is too low, you might risk getting the encrypted password truncated, so it´s recommended to allow for some "overhead".

          -----
          I'm wondering if it's because the fields must start in my database with kt_login_id, kt_login_name, etc. instead of just id, name, etc.
          -----

          no, that´s not required.

          BTW, these days I´ve started my my own ADDT tutorials section on my website, and the first article I just published is about "Login tables: installation & configuration" -- maybe the following article will answer some of your questions:

          http://www.guenter-schenk.com/tutorials/tutorial.php?id=1

          Cheers,
          Günter Schenk
          Adobe Community Expert, Dreamweaver
          • 2. Re: Login/Password Page Problems
            Level 1
            Gunther,

            First off, great tutorial. After realizing first my row should've said name instead of user, I switched it but the password still wouldn't work. So I dumped the table altogether and went to your script. Installed it just fine and increased the password's VARCHAR to 240. Guess what? I still get an invalid password. I also get this on my index.php page:

            tNG Execution Trace - VIEW

            * tNG_login.executeTransaction
            o STARTER.Trigger_Default_Starter
            o tNG_login.doTransaction
            + BEFORE.Trigger_Default_FormValidation
            + tNG_login.prepareSQL
            + tNG_login.executeTransaction - execute sql
            + AFTER.Trigger_Login_MaxTriesCheck
            + AFTER.Trigger_Login_CheckLogin*
            + ERROR.Trigger_Login_MaxTriesIncrement
            * tNG_login.getRecordset
            * tNG_login.getFakeRsArr
            * tNG_login.getLocalRecordset
            * tNG_login.getFakeRecordset
            * tNG_login.getFakeRecordset

            Not sure if that means anything but it could help.

            I may have to try again without encryption.
            • 3. Re: Login/Password Page Problems
              Level 1
              Yea, that was the trick! Turning off encryption allowed me to login.
              • 4. Re: Login/Password Page Problems
                Günter Schenk Level 4
                Hi Adam,

                if you need the password encryption though, you can also change the column type to "mediumtext" -- this one can have a maximum length of 16,777,215 characters, what should be more than enough for whatever encrypted password ;-)

                Cheers,
                Günter Schenk
                Adobe Community Expert, Dreamweaver