[GUACAMOLE-163] Database schema no longer compatible with MySQL 5.5

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 0.9.11-incubating
• Fix Version/s: 0.9.11-incubating
• Component/s: guacamole-auth-jdbc-mysql
• Assignee: Mike Jumper
• Reporter: Mike Jumper
• Created: 21/Jan/17 19:52
• Updated: 22/Jan/17 23:14
• Resolved: 22/Jan/17 23:14

Description

Recent changes from GUACAMOLE-36 modify the MySQL schema, adding an additional password_date column to guacamole_user which records the time that the password was last set. This column defaults to the current date:

--
-- Add per-user password set date
--

ALTER TABLE guacamole_user
    ADD COLUMN password_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;

Unfortunately, the ability to specify DEFAULT CURRENT_TIMESTAMP for a DATETIME column was a new feature in MySQL 5.6, and cannot be used for any older version of MySQL:

http://dev.mysql.com/doc/refman/5.6/en/timestamp-initialization.html

The schema will need to be updated such that compatibility with previously-working versions of MySQL is not broken.

Issue Links

• relates to: GUACAMOLE-36 Add support for password policies
• links to: MySQL :: MySQL 5.6 Reference Manual :: 11.3.5 Automatic Initialization and Updating for TIMESTAMP and DATETIME