[
https://issues.apache.org/jira/browse/GUACAMOLE-395?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael Jumper reassigned GUACAMOLE-395:
----------------------------------------
Assignee: Michael Jumper
> User "expired" column not actually queried for MySQL
> ----------------------------------------------------
>
> Key: GUACAMOLE-395
> URL: https://issues.apache.org/jira/browse/GUACAMOLE-395
> Project: Guacamole
> Issue Type: Bug
> Components: guacamole-auth-jdbc-mysql
> Reporter: Michael Jumper
> Assignee: Michael Jumper
> Priority: Critical
>
> Though the {{expired}} column of the {{guacamole_user}} table is [correctly
> mapped for
> PostgreSQL|https://github.com/apache/incubator-guacamole-client/blob/b90a98946359c9b0b7e4af8571034961d47322fa/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-postgresql/src/main/resources/org/apache/guacamole/auth/jdbc/user/UserMapper.xml#L33-L35]:
> {code:xml}
> <!-- Result mapper for user objects -->
> <resultMap id="UserResultMap"
> type="org.apache.guacamole.auth.jdbc.user.UserModel" >
> ...
> <result column="disabled" property="disabled"
> jdbcType="BOOLEAN"/>
> <result column="expired" property="expired"
> jdbcType="BOOLEAN"/>
> <result column="access_window_start" property="accessWindowStart"
> jdbcType="TIME"/>
> ...
> </resultMap>
> {code}
> it is [not mapped at all for
> MySQL|https://github.com/apache/incubator-guacamole-client/blob/b90a98946359c9b0b7e4af8571034961d47322fa/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-mysql/src/main/resources/org/apache/guacamole/auth/jdbc/user/UserMapper.xml#L33-L34]:
> {code:xml}
> <!-- Result mapper for user objects -->
> <resultMap id="UserResultMap"
> type="org.apache.guacamole.auth.jdbc.user.UserModel" >
> ...
> <result column="disabled" property="disabled"
> jdbcType="BOOLEAN"/>
> <result column="access_window_start" property="accessWindowStart"
> jdbcType="TIME"/>
> ...
> </resultMap>
> {code}
> This column [controls manual password
> expiration|https://github.com/apache/incubator-guacamole-client/blob/728d9b937c80bbf61ac79dd563dc1775203b34e6/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-base/src/main/java/org/apache/guacamole/auth/jdbc/JDBCAuthenticationProviderService.java#L106-L108],
> which is thus broken for MySQL and MariaDB databases.
> See also:
> http://guacamole.incubator.apache.org/doc/gug/jdbc-auth.html#jdbc-auth-schema-users
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
