View Issue Details

IDProjectCategoryView StatusLast Update
0022841mantisbtauthenticationpublic2019-12-09 05:08
Reporterdregad Assigned Todregad  
PrioritynormalSeverityminorReproducibilityhave not tried
Status assignedResolutionopen 
Target Version2.24.0 
Summary0022841: Don't truncate password when it exceeds db field size
Description

Following up on discussion in PR 1048.

auth_process_plain_password() silently truncates the processed password to the size of the underlying database field.

This can cause problems when the password field's size is increased, as it will cause users to no longer be able to login, forcing them to reset their password.

TagsNo tags attached.

Activities

dregad

dregad

2017-05-06 18:14

developer   ~0056786

PR https://github.com/mantisbt/mantisbt/pull/1048

thE_iNviNciblE

thE_iNviNciblE

2019-04-28 09:22

reporter   ~0062010

FYI:

"New lengths vary depending on the database management system:

MariaDB version 10.0 and higher - 80 characters
PostgreSQL version 7.3 and higher - 61 characters
PostgreSQL versions lower than 7.3 - 31 characters
Microsoft SQL (all versions) - 128 characters
MySQL version 5.7.8 and higher - 32 characters
Percona version 5.7 and higher - 32 characters
Other database management systems - 16 characters"

dregad

dregad

2019-04-28 11:27

developer   ~0062011

@thE_iNviNciblE Your post is confusing. Where do you get this information from ? The size of password field is set to 64 chars by MantisBT at installation time, and that does not depend on RDBMS.

Or maybe you meant something else, in that case please clarify...

thE_iNviNciblE

thE_iNviNciblE

2019-06-14 02:44

reporter   ~0062254

@dregad:

i've seen information here: https://docs.plesk.com/release-notes/onyx/change-log/#179-preview13

dregad

dregad

2019-06-14 03:44

developer   ~0062257

That's the changelog for Plesk, I don't see how it is related to MantisBT.

Issue History

Date Modified Username Field Change
2017-05-06 17:50 dregad New Issue
2017-05-06 17:50 dregad Status new => assigned
2017-05-06 17:50 dregad Assigned To => dregad
2017-05-06 18:14 dregad Note Added: 0056786
2017-06-04 16:19 atrol Target Version 2.5.0 => 2.6.0
2017-09-03 18:50 vboctor Target Version 2.6.0 => 2.7.0
2017-10-08 23:55 vboctor Target Version 2.7.0 => 2.8.0
2017-10-28 19:14 vboctor Target Version 2.8.0 => 2.9.0
2017-12-04 02:25 vboctor Target Version 2.9.0 => 2.10.0
2017-12-30 18:39 vboctor Target Version 2.10.0 => 2.11.0
2018-02-06 21:22 vboctor Target Version 2.11.0 => 2.12.0
2018-03-04 00:41 vboctor Target Version 2.12.0 => 2.13.0
2018-03-31 20:06 vboctor Target Version 2.13.0 => 2.14.0
2018-04-29 19:27 vboctor Target Version 2.14.0 => 2.15.0
2018-06-06 00:43 vboctor Target Version 2.15.0 => 2.16.0
2018-07-30 05:32 atrol Target Version 2.16.0 => 2.17.0
2018-09-04 01:27 vboctor Target Version 2.17.0 => 2.18.0
2018-10-16 23:45 vboctor Target Version 2.18.0 => 2.19.0
2019-01-02 17:32 vboctor Target Version 2.19.0 => 2.20.0
2019-03-16 20:33 vboctor Target Version 2.20.0 => 2.21.0
2019-04-21 05:25 atrol Target Version 2.21.0 => 2.22.0
2019-04-28 09:22 thE_iNviNciblE Note Added: 0062010
2019-04-28 11:27 dregad Note Added: 0062011
2019-06-14 02:44 thE_iNviNciblE Note Added: 0062254
2019-06-14 03:44 dregad Note Added: 0062257
2019-08-25 13:02 vboctor Target Version 2.22.0 => 2.23.0
2019-12-09 05:08 dregad Target Version 2.23.0 => 2.24.0