How to recover localhost password of thingworx composer if i forgot my password

Forum|Forum|9 years ago
February 22, 2017
4 replies
9293 views

i have set Administrator password and i am trying to login but it seems i am trying to enter invalid is there any way to get my password back or set it without having older one...?

Troubleshooting

Best answer by ankigupta

Hi Kedar,

If you have any other Administrator user then you can reset the Password using that user.

If you have setup Organization and Administrator is part of it then you can use reset password option there to reset the Password.

If none of the above is true then we can check with R&D for changes in Database (Only for Postgresql DB) (not preferred as PTC does not support changes to the Database directly).

A

ankigupta

Answer

5-Regular Member

Hi Kedar,

If you have any other Administrator user then you can reset the Password using that user.

If you have setup Organization and Administrator is part of it then you can use reset password option there to reset the Password.

If none of the above is true then we can check with R&D for changes in Database (Only for Postgresql DB) (not preferred as PTC does not support changes to the Database directly).

P

posipova

20-Turquoise

In addition to Ankit's questions -- do you have an administrator appkey set up?

K

kborkar

Author

1-Visitor

yes we have setup one app key with administrator user and used that to connect to it with java

can we do anything with java code to update password?

is there any methods to update thingworx admin password with java...?

P

posipova

20-Turquoise

You can do a REST API call using your admin appkey and change your Adminsitrator password.

K

katte

5-Regular Member

For Administrator password only with Thingworx Postgresql - Yes there is a way to reset.

Though this is not officially recommended by ThingWorx, this should work (like a hack) in resetting the password. Follow the below steps:

Step-1: In a temporary postgresql server, deploy thingworx database using the thingworx Install scripts (provided in the distribution package). This would create a database with default user-passwords. Now, you can take a backup of user_model table (pgadmin would be easy for a specific table backup). Modify the backup sql file - if needed you can delete the COPY commands for 'System' and 'SuperUser' rows. Save the file.

Step-2: If you have access to the actual Postgresql database server, you can navigate through 'thingworx' database -> user_model table and delete a row with name as 'administrator' (make sure to use a sql query to delete the row). And now import/restore the sql file obtained in step-1. This would add a row in 'user_model' table with default Administrator user and password.

Let me know if that works.

-Giri