[GUACAMOLE-1390] some field of guacamole_user are set to null after TOTP enrollment

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.3.0
• Component/s: guacamole-auth-jdbc-mysql, guacamole-auth-totp
• Environment: RockyLinux 8.4 ; java-11-openjdk ; guacamole-1.3.0.war ; mysql-connector-java-8.0.25.jar ; guacamole-auth-totp-1.3.0.jar
• Assignee: Unassigned
• Reporter: lolovn
• Created: 29/Jul/21 02:16
• Updated: 29/Jul/21 04:48
• Resolved: 29/Jul/21 04:48

Description

Hi,

After enrollment of TOTP, some informations (such as full_name,organization ,organizational_role) stored in guacamole_user table are reset to null.

 

Way to reproduce error:

1. check table content

select user_id,full_name,organization ,organizational_role from guacamole_db.guacamole_user where user_id =28;

– user_id|full_name |organization |organizational_role|
– ------+------------------------+------------------
– 28|upd 29/7 7h35|upd 29/7 7h35|upd 29/7 7h35 |

 

select * from guacamole_user_attribute where user_id =28;

– user_id|attribute_name |attribute_value |
– ------+------------------------------------------------------
– 28|guac-totp-key-confirmed|true |
– 28|guac-totp-key-secret |MSPT6ZH7EAXXMUKSL3R5KJ655TI7737O|

 

2. reset enroll for user

update guacamole_user_attribute set attribute_value='false' where user_id =28 and attribute_name='guac-totp-key-confirmed';
 select * from guacamole_user_attribute where user_id =28;

– user_id|attribute_name |attribute_value |
– ------+------------------------------------------------------
– 28|guac-totp-key-confirmed|false |
– 28|guac-totp-key-secret |MSPT6ZH7EAXXMUKSL3R5KJ655TI7737O|

 

3. enroll user 28 again

4. check table content again

select user_id,full_name,organization ,organizational_role from guacamole_db.guacamole_user where user_id =28;

– user_id|full_name|organization|organizational_role|
– ------+-------------------+------------------
– 28| | | |

Issue Links

• duplicates: GUACAMOLE-1199 User Profile Information Lost after user logon