Skip to main content
E
ebcohen
Inspiring
September 23, 2022
Answered

Suddenly Locked Out of ColdFusion 2021 Admin Console

  • September 23, 2022
  • 1 reply
  • 1081 views

Today I was changing the datasource for my client variables. I had initially specified a remote SQL Server database, but wanted to change it to a local SQL Server datasource. Apparently there was a permissions problem with the username I had specified for the datasource and it was causing a "select permission was denied error." Next thing I knew I was logged out of the ColdFusion 2021 Administrator and could not log back in. I kept getting "Invalid User name or Password. Please try again." I know I didn't change my password so this didn't make any sense. Just in case, however, I did use the passwordreset.BAT file in the ColdFusion/bin directory. But I still cannot login.

I am on Windows Server 2019, and it is the trial version of Enterprise. (I am moving to a new server).

Any help greatly appreciated. I would not want to have to start over setting this server up.

Thank you.

    This topic has been closed for replies.
    Correct answer ebcohen

    Hi @ebcohen ,

    It's unfortunate to hear of the installation troubles with ColdFusion 2021. From what you have shared so far, it's most likely a minor problem. Take heart. 

     

    From what I can see, there are clues:

    1.  You did perform some actions on datasources, which are indirectly related to the ColdFusion Administrator.
    2.  You did use the PasswordReset.bat tool, but that didn't help.
    3.  You called the datasource configuration file "NEO-datasources", which is incorrect. Correct is neo-datasource.xml. In any case, you did edit the configuration file, as a result of which the issue was temporarily solved. 

     

    To me these clues suggest the following:

    • The datasource changes you made might have modified or corrupted the file neo-datasource.xml. Ensure the file's name is correct.
      Also make sure the file's content is valid. For example, by comparing it with that of a previously working neo-datasource.xml.
    • If you had copied the file neo-datasources.xml from a previous ColdFusion installation, then you should also copy the file /cfusion/lib/seed.properties into the lib directory of the current installation.

     

    Remember to restart ColdFusion after you make the changes. It might help to try the password-reset tool once again.


    Thanks again for the help Charlie and BKBK. After calculating all the time I already spent on this, I decided it was easier to uninstall and reinstall ColdFusion. I am hopeful that the issue won't reappear, but so far I have reset my settings and things seem to work with logging in and out of the CF admin. Now I can get back to sort out "real" issues.

    1 reply

    Priyank Shrivastava.
    Community Manager
    Priyank Shrivastava.Community Manager
    Community Manager
    September 23, 2022

    Hi @ebcohen ,

     

    Have you restarted the CF after using Passwordreset.bat? If not, please try once and let me know if that resolves your issue or not.

    Please add a screenshot of the error and also let me know which browser are you using?

     

    Thanks, Priyank Shrivastava
    E
    ebcohenAuthor
    Inspiring
    September 23, 2022

    I have restarted CF (Using the services control panel) several times, but no joy. 
    I am using Chrome browser, and as far as a screenshot, it's just the regular login, but it says I am not putting in the right password:

     

    E
    ebcohenAuthor
    Inspiring
    September 23, 2022

    BTW, here is the log entry in coldfusion-out log file:

    Sep 23, 2022 12:28:08 PM Information [http-nio-8500-exec-3] - Invalid login for user admin

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