3 Replies Latest reply on Nov 8, 2017 5:13 AM by ssubramanian-2 RSS
    lzhou Apprentice

    forget administrator password

    I forgot my Thingworx administrator password, How can I do? I don't want to rebuild my database.

      • Re: forget administrator password
        anna Communicator

        ling zhou,

        Are you running PostgreSQL ThingWorx? For PostgreSQL you could try with:

        1. Using pgAdmin III or psql, connect to the ThingWorx database with the ThingWorx DB user password .If necessary, the database username and password can be retrieved from the platform-settings.json file located in the /ThingworxPlatform directory on the ThingWorx server.

        2. Run the following SQL statement:

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

         

        In my example, the password will be "admin"

        But this is just for some urgent case and you have no other choice. Directly changing database is not advised.

         

        Br,

        Anna

        • Re: forget administrator password
          polinao Ninja

          Do you have an application key associated with the Administrator?

          How to reset Password for users using Administrator Appkey