Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Guacamole
  3. Resetting 2FA for Guacamole

Resetting 2FA for Guacamole

Scheduled Pinned Locked Moved Solved Guacamole
webterminal2fa
3 Posts 2 Posters 4.9k Views 2 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A Offline
      A Offline
      alexdimarco
      wrote on last edited by girish
      #1

      Ran into an issue with resetting 2FA for a user... the instructions for Guacamole seem to be editing the database as follows but I am having difficulty translating this to the Cloudron install... would someone be able to provide instructions that would work for this?

      mysql -u root -p
      use guacamoldb;
      SELECT user_id FROM guacamole_user INNER JOIN guacamole_entity ON guacamole_entity.entity_id = guacamole_user.entity_id WHERE guacamole_entity.name = 'guacadmin';

      Now you get the userid of the user guacadmin which should be #1.
      Reset totp for user with id #1.

      UPDATE guacamole_user_attribute SET attribute_value='false' WHERE attribute_name = 'guac-totp-key-confirmed' and user_id = '1';
      quit;

      girishG 1 Reply Last reply
      0
      • A alexdimarco

        Ran into an issue with resetting 2FA for a user... the instructions for Guacamole seem to be editing the database as follows but I am having difficulty translating this to the Cloudron install... would someone be able to provide instructions that would work for this?

        mysql -u root -p
        use guacamoldb;
        SELECT user_id FROM guacamole_user INNER JOIN guacamole_entity ON guacamole_entity.entity_id = guacamole_user.entity_id WHERE guacamole_entity.name = 'guacadmin';

        Now you get the userid of the user guacadmin which should be #1.
        Reset totp for user with id #1.

        UPDATE guacamole_user_attribute SET attribute_value='false' WHERE attribute_name = 'guac-totp-key-confirmed' and user_id = '1';
        quit;

        girishG Offline
        girishG Offline
        girish
        Staff
        wrote on last edited by
        #2

        @alexdimarco sure, open the app's web terminal. Then on the top, you see the MySQL button. If you click it, it will paste the CLI command to access mysql. Just press enter and it will give you the mysql prompt. After that, you can try the SELECT and UPDATE commands.

        A 1 Reply Last reply
        0
        • girishG girish

          @alexdimarco sure, open the app's web terminal. Then on the top, you see the MySQL button. If you click it, it will paste the CLI command to access mysql. Just press enter and it will give you the mysql prompt. After that, you can try the SELECT and UPDATE commands.

          A Offline
          A Offline
          alexdimarco
          wrote on last edited by
          #3

          @girish Thanks! - should have figured that out - didn't see the button 😊

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


            • Login

            • Don't have an account? Register

            • Login or register to search.
            • First post
              Last post
            0
            • Categories
            • Recent
            • Tags
            • Popular
            • Bookmarks
            • Search