Skip to main content
I
iq11
Known Participant
October 22, 2019
Question

500 - Internal server error

  • October 22, 2019
  • 2 replies
  • 742 views

Hello everyone,

 We are getting an error As shown below on our Dev server

 

Error Occurred While Processing Request. Please try again.
Error Executing Database Query. [Macromedia][Oracle JDBC Driver]A username and password are required if the connection option 'authenticationMethod' is specified with a value of 'userIDPassword'.
The error occurred on line 28.

 

 

Whereas on our Prod server we are getting an error message as shown below

 

500 - Internal server error.

There is a problem with the resource you are looking for, and it cannot be displayed.

 

We would like the error message to be the same as that displayed on Dev server on our Prod server also. I have looked at the authentication.cfm file but could not see anything which can help me.

We think this is due to an incorrect setting in the Cold Fusion Administrator , Can someone help us with this issue ?

    This topic has been closed for replies.

    2 replies

    Charlie Arehart
    Community Expert
    Charlie ArehartCommunity Expert
    Community Expert
    October 23, 2019

    You want production to report the same level of detail about the errors as in dev? This may be a case of "be careful what you wish for".

     

    Yes, this IS something controlled by a setting in the admin, in that the debug output settings page has an option for "robust exception handling", which should be OFF in a production config (don't show as much detail) and is often turned ON in a development config (to show MORE detail).

     

    But really, one need NOT rely on THAT display of error details, in dev or prod. Instead one could implement error handling in their code, to have the error details tracked in a log, db, email, etc while the user sees a generic message saying  that the error has been handled and appropriate people notified. The cf docs (and many blog posts and presentations) detail how to setup error handling. Someone familiar with the concept could have something in place in minutes.

     

    Let us know if you need more help, and whether this has helped. 

    /Charlie (troubleshooter, carehart. org)
    I
    iq11Author
    Known Participant
    October 23, 2019

    Hi there,

       Please update me if there is any solution to this issue.

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