Skip to main content
I
iq11
Known Participant
December 27, 2018
Answered

Coldfusion login problem

  • December 27, 2018
  • 2 replies
  • 981 views

Hello,

  When I try to use the login page to go to my Application, I get the following error. I have already checked my username and password , they are correct.

We are using Oracle 11g database and Cold fusion 9. Please help ?

"

Error
Executing Database Query.

[Macromedia][Oracle JDBC
Driver][Oracle]ORA-01017: invalid username/password; logon denied
Please try the
following

"

Thanks

IQ

    This topic has been closed for replies.
    Correct answer WolfShade

    Are you storing the password in clear text (ie, not encrypted)?  If you are, that's generally not safe.  But double-check in the database to make sure the password is correct.  I know that in Oracle the default setting is to enforce CaSe-SeNsItIvE SELECTs.  Even a space could make a difference.

    If you are encrypting the password, I'd guess that the key may be incorrect.  Try generating a new key, and update the database with a refreshed version.

    Ignore all that.  LOL!  The issue isn't your login/pw for your app.. it's the login/pw for your DATABASE account.  CF cannot access the database.

    HTH,

    ^ _ ^

    2 replies

    D
    Community Expert
    Dave WattsCommunity Expert
    Community Expert
    December 27, 2018

    Typically, this means that you've entered incorrect values in the CF Administrator for your data source. But on another topic, you really shouldn't be using CF 9 any more. It's very old and not really suitable for use any more.

    Dave Watts, Fig Leaf Software

    Dave Watts, Eidolon LLC
    WolfShade
    WolfShadeCorrect answer
    Legend
    December 27, 2018

    Are you storing the password in clear text (ie, not encrypted)?  If you are, that's generally not safe.  But double-check in the database to make sure the password is correct.  I know that in Oracle the default setting is to enforce CaSe-SeNsItIvE SELECTs.  Even a space could make a difference.

    If you are encrypting the password, I'd guess that the key may be incorrect.  Try generating a new key, and update the database with a refreshed version.

    Ignore all that.  LOL!  The issue isn't your login/pw for your app.. it's the login/pw for your DATABASE account.  CF cannot access the database.

    HTH,

    ^ _ ^

    I
    iq11Author
    Known Participant
    December 27, 2018

    This is exactly the issue, resetting the password fixed the issue.

    WolfShade
    WolfShade
    Legend
    December 27, 2018

    Thank you for marking my answer as correct.  I do appreciate it.

    V/r,

    ^ _ ^

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices