Type:
Bug
Priority:
Major
Resolution:
Not a Bug
Affects Version/s:
None
Environment:
Linux 4.9.0-8-amd64 #1 SMP Debian 4.9.110-3+deb9u6 (2018-10-08) x86_64 GNU/Linux
MariaDB Version 10.1.26-MariaDB-0+deb9u1
Steps to reproduce:
1. Install a fresh MariaDB system (or use an existing)
2. Import the dump (or the binary file) I have provided in the attachment. Actually, you only need the "user" table. Everything else can stay unchanged.
3. Run flush privileges
4. Try to login as "affiliflex@localhost"
Expected result: (happens to all other non-existing users)
mysqli_real_connect(): (HY000/1045): Access denied for user 'affiliflex'@'localhost' (using password: YES)
Actual result: (happens only for the non-existing user "affiliflex")
mysqli_real_connect(): (HY000/1275): Server is running in --secure-auth mode, but 'affiliflex'@'localhost' has a password in the old format; please change the password to the new format
Notes:
1. The message comes from the mysql_native_password plugin.
2. It only works with this exact data and with this non-existing user "affiliflex". (Any other user will result in the normal "access denied" message) If you add or remove any single row in the users table, the bug disappears. If you change the length of any other username in the table, the bug disappears too. If you change the password of the user "1234567890" to a secure password, the bug disappears too. I think there is some kind of hash conflict, since it only works with this specific data.
3. I could reproduce this bug on three completely different Debian 9 systems. One of these systems was completely installed from scratch, with only MariaDB installed, and nothing else.
4. The root password is "hello", just in case you need it
{"report":{"fcp":883.9000000953674,"ttfb":149,"pageVisibility":"visible","entityId":70988,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"2ac7ddc7-e0b0-4f78-8d6c-814181eceb70","navigationType":0,"readyForUser":951.6000001430511,"redirectCount":0,"resourceLoadedEnd":620.1000001430511,"resourceLoadedStart":155.10000014305115,"resourceTiming":[{"duration":220.79999995231628,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":155.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":155.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":375.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":220.59999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":155.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":155.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":376,"responseStart":0,"secureConnectionStart":0},{"duration":244.70000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":155.40000009536743,"connectEnd":155.40000009536743,"connectStart":155.40000009536743,"domainLookupEnd":155.40000009536743,"domainLookupStart":155.40000009536743,"fetchStart":155.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":155.40000009536743,"responseEnd":400.10000014305115,"responseStart":400.10000014305115,"secureConnectionStart":155.40000009536743},{"duration":272,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":155.5,"connectEnd":155.5,"connectStart":155.5,"domainLookupEnd":155.5,"domainLookupStart":155.5,"fetchStart":155.5,"redirectEnd":0,"redirectStart":0,"requestStart":155.5,"responseEnd":427.5,"responseStart":427.40000009536743,"secureConnectionStart":155.5},{"duration":275.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":155.70000004768372,"connectEnd":155.70000004768372,"connectStart":155.70000004768372,"domainLookupEnd":155.70000004768372,"domainLookupStart":155.70000004768372,"fetchStart":155.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":155.70000004768372,"responseEnd":431.2999999523163,"responseStart":431.2999999523163,"secureConnectionStart":155.70000004768372},{"duration":276.2999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":155.70000004768372,"connectEnd":155.70000004768372,"connectStart":155.70000004768372,"domainLookupEnd":155.70000004768372,"domainLookupStart":155.70000004768372,"fetchStart":155.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":155.70000004768372,"responseEnd":432,"responseStart":432,"secureConnectionStart":155.70000004768372},{"duration":276.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":155.79999995231628,"connectEnd":155.79999995231628,"connectStart":155.79999995231628,"domainLookupEnd":155.79999995231628,"domainLookupStart":155.79999995231628,"fetchStart":155.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":155.79999995231628,"responseEnd":432.7000000476837,"responseStart":432.7000000476837,"secureConnectionStart":155.79999995231628},{"duration":277.7000000476837,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":156,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":156,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":433.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":278.39999985694885,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":156.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":156.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":434.5,"responseStart":0,"secureConnectionStart":0},{"duration":277.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":156.10000014305115,"connectEnd":156.10000014305115,"connectStart":156.10000014305115,"domainLookupEnd":156.10000014305115,"domainLookupStart":156.10000014305115,"fetchStart":156.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":156.10000014305115,"responseEnd":433.2999999523163,"responseStart":433.2999999523163,"secureConnectionStart":156.10000014305115},{"duration":277.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":156.29999995231628,"connectEnd":156.29999995231628,"connectStart":156.29999995231628,"domainLookupEnd":156.29999995231628,"domainLookupStart":156.29999995231628,"fetchStart":156.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":156.29999995231628,"responseEnd":434,"responseStart":434,"secureConnectionStart":156.29999995231628},{"duration":363.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":157,"connectEnd":157,"connectStart":157,"domainLookupEnd":157,"domainLookupStart":157,"fetchStart":157,"redirectEnd":0,"redirectStart":0,"requestStart":157,"responseEnd":520.2000000476837,"responseStart":520.2000000476837,"secureConnectionStart":157},{"duration":463,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":157.10000014305115,"connectEnd":157.10000014305115,"connectStart":157.10000014305115,"domainLookupEnd":157.10000014305115,"domainLookupStart":157.10000014305115,"fetchStart":157.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":157.10000014305115,"responseEnd":620.1000001430511,"responseStart":620.1000001430511,"secureConnectionStart":157.10000014305115},{"duration":345.7999999523163,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":671.5,"connectEnd":671.5,"connectStart":671.5,"domainLookupEnd":671.5,"domainLookupStart":671.5,"fetchStart":671.5,"redirectEnd":0,"redirectStart":0,"requestStart":671.5,"responseEnd":1017.2999999523163,"responseStart":1017.2999999523163,"secureConnectionStart":671.5}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":34,"responseStart":149,"responseEnd":151,"domLoading":153,"domInteractive":1010,"domContentLoadedEventStart":1011,"domContentLoadedEventEnd":1054,"domComplete":1909,"loadEventStart":1909,"loadEventEnd":1911,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":990},{"name":"bigPipe.sidebar-id.end","time":991.1000001430511},{"name":"bigPipe.activity-panel-pipe-id.start","time":991.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":993.9000000953674},{"name":"activityTabFullyLoaded","time":1071.1000001430511}],"measures":[],"correlationId":"57e9f36fc75a11","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":66,"dbReadsTimeInMs":8,"dbConnsTimeInMs":14,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}