Skip to main content
18-Opal
September 24, 2021
Solved

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

  • September 24, 2021
  • 2 replies
  • 5137 views

 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 

Best answer by pshashipreetham

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

2 replies

Community Manager
September 24, 2021

Hi @pshashipreetham.

 

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

 

Regards.

 

--Sharon

pshashipreetham18-OpalAuthorAnswer
18-Opal
October 1, 2021

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