Highlighted

Coldfusion login problem

Explorer ,
Dec 27, 2018

Copy link to clipboard

Copied

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

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,

^ _ ^

Views

358

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Coldfusion login problem

Explorer ,
Dec 27, 2018

Copy link to clipboard

Copied

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

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,

^ _ ^

Views

359

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Dec 27, 2018 0
LEGEND ,
Dec 27, 2018

Copy link to clipboard

Copied

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,

^ _ ^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Dec 27, 2018 0
Explorer ,
Dec 27, 2018

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Dec 27, 2018 0
LEGEND ,
Dec 27, 2018

Copy link to clipboard

Copied

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

V/r,

^ _ ^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Dec 27, 2018 0
Adobe Community Professional ,
Dec 27, 2018

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Dec 27, 2018 1