Can't login into Thingworx, after the installation of Thingworx

[pshashipreetham]

 Last Error Log:

2021-09-24 03:02:46.289+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: ???] [S: ] [P: ] [T: http-nio-80-exec-1] Authentication failed: Please make sure the credentials are correct. 

Last Security Log:

2021-09-24 03:02:46.288+0000 [L: WARN] [O: S.c.t.s.a.AuthenticationUtilities] [I: ] [U: ???] [S: ] [P: ] [T: http-nio-80-exec-1] Authentication attempt #1 FAILED for [user = Administrator]: Invalid Password
2021-09-24 03:02:46.289+0000 [L: ERROR] [O: S.c.t.s.a.AuthenticationFilter] [I: ] [U: ???] [S: ] [P: ] [T: http-nio-80-exec-1] Authentication failed: Please make sure the credentials are correct.

Last Application log:

2021-09-24 02:55:17.263+0000 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-1] Datastore database...INITIALIZED
2021-09-24 02:56:17.184+0000 [L: WARN] [O: c.t.s.s.p.PlatformSubsystem] [I: ] [U: ] [S: ] [P: ] [T: pool-14-thread-1]  Thingworx System Metrics_---------------------------------------

 platform-settings.json:

{
	"PlatformSettingsConfig": {
		"AdministratorUserSettings": {
			"InitialPassword": "test@thingworx"
		},
		"ContentTypeSettings": {
			"supportedMediaEntityContentTypes":["image/svg+xml","image/png","image/gif","image/bmp","image/jpeg","application/pdf","image/vnd.microsoft.icon"]
		},
		"ExtensionPackageImportPolicy": {
		"importEnabled": true,
		"allowJarResources": true,
		"allowJavascriptResources": true,
		"allowCSSResources": true,
		"allowJSONResources": true,
		"allowWebAppResources": true,
		"allowEntities": true,
		"allowExtensibleEntities": true
		}
	},	
	"LicensingConnectionSettings":{
      "username":"*******",
      "password":"*******"
    },
	"PersistenceProviderPackageConfigs": {
		"PostgresPersistenceProviderPackage": {
			"ConnectionInformation": {
				"jdbcUrl": "jdbc:postgresql://localhost:5432/thingworx",
				"password": "Administrator",
				"username": "twadmin"
			}
		}
	}
}

@paic @slangley @c_lowy 

[slangley]

Hi @pshashipreetham.

Which version of ThingWorx did you install?  Per the Security log you provided, the password is incorrect.

Regards.

--Sharon

[pshashipreetham · Accepted solution]

Hi,

The issue is through installation something went wrong and the password is already stored and it is not taking the password provided in the platform-settings.json. Therefore running following query to reset the password in the user table to admin

UPDATE user_model SET "passwordHash" = '100000:ecbad5a6dc172f92cddd4743e6b4877724e0c675e6e2fc1c780ab62a2350f115acdbd3c6c582afd297a4c77fb5420520e3f36c2c5e12dbfc5fc9c4f3fc2d616d:6fd6785de35b500fb633ab13be4207dead6c26f922b32610c135f446fea2d4abbce57be9058457cddd4e3944fcf42b804c29dc8939a3c29ca6ac64001d0a982c' WHERE name = 'Administrator';

After this query the Credentials will be:
username: Administrator
password: admin

Thanks,
Shashi Preetham