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


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
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

Cloudron Forum

Apps | Demo | Docs | Install

Resetting 2FA for Guacamole

Scheduled Pinned Locked Moved Solved Guacamole
webterminal2fa
3 Posts 2 Posters 2.4k Views
    • 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
  • girishG Do not disturb
    girishG Do not disturb
    girish Staff
    replied to alexdimarco 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
  • A Offline
    A Offline
    alexdimarco
    replied to girish on last edited by
    #3

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

    1 Reply Last reply
    0

  • Login

  • Don't have an account? Register

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

  • Don't have an account? Register

  • Login or register to search.