Skip Menu |
 

This queue is for tickets about the DBD-mysql CPAN distribution.

Report information
The Basics
Id: 120091
Status: resolved
Priority: 0/
Queue: DBD-mysql

People
Owner: Nobody in particular
Requestors: xiangyu.hu [...] outlook.com
Cc: pali [...] cpan.org
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



X-MS-Exchange-Crosstenant-Fromentityheader: Internet
Spamdiagnosticmetadata: NSPM
MIME-Version: 1.0
X-Incomingtopheadermarker: OriginalChecksum:A240AAED2AFEBDCFB4289A20E087C74E8DD86F64B0B14CBA1A345376932DDACD;UpperCasedChecksum:4F0D68B19E17622772072FF0DEE4DC07DC7FDCB1C38CD1074544EBFA58C34261;SizeAsReceived:7661;Count:37
Spamdiagnosticoutput: 1:99
X-Cpan.org: This message routed through the cpan.org mail forwarding service. Please use PAUSE pause.perl.org to configure your delivery settings.
X-Spam-Flag: NO
Content-Type: multipart/alternative; boundary="_000_PS1PR03MB189704790DBE2EFD5F9CE1DC9A4E0PS1PR03MB1897apcp_"
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Spam-Score: 1.367
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 9EC7D2401B2 for <cpan-bug+DBD-mysql [...] hipster.bestpractical.com>; Sat, 4 Feb 2017 02:26:37 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id iuzDMhMvPNg6 for <cpan-bug+DBD-mysql [...] hipster.bestpractical.com>; Sat, 4 Feb 2017 02:26:36 -0500 (EST)
Received: from xx1.develooper.com (xx1.develooper.com [207.171.7.115]) by hipster.bestpractical.com (Postfix) with ESMTPS id 23E442400EB for <bug-DBD-mysql [...] rt.cpan.org>; Sat, 4 Feb 2017 02:26:36 -0500 (EST)
Received: from localhost (xx1.develooper.com [127.0.0.1]) by localhost (Postfix) with ESMTP id A4DDD11D400 for <bug-DBD-mysql [...] rt.cpan.org>; Fri, 3 Feb 2017 23:26:34 -0800 (PST)
Received: from xx1.develooper.com (xx1.develooper.com [127.0.0.1]) by localhost (Postfix) with SMTP id 53CD311D87A for <bug-DBD-mysql [...] rt.cpan.org>; Fri, 3 Feb 2017 23:26:32 -0800 (PST)
Received: from COL004-OMC2S14.hotmail.com (col004-omc2s14.hotmail.com [65.55.34.88]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) by xx1.develooper.com (Postfix) with ESMTPS id C4B8411D400 for <bug-DBD-mysql [...] rt.cpan.org>; Fri, 3 Feb 2017 23:26:27 -0800 (PST)
Received: from APC01-PU1-obe.outbound.protection.outlook.com ([65.55.34.73]) by COL004-OMC2S14.hotmail.com over TLS secured channel with Microsoft SMTPSVC(7.5.7601.23008); Fri, 3 Feb 2017 23:26:25 -0800
Received: from SG2APC01FT059.eop-APC01.prod.protection.outlook.com (10.152.250.58) by SG2APC01HT105.eop-APC01.prod.protection.outlook.com (10.152.251.91) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.874.2; Sat, 4 Feb 2017 07:26:22 +0000
Received: from PS1PR03MB1897.apcprd03.prod.outlook.com (10.152.250.54) by SG2APC01FT059.mail.protection.outlook.com (10.152.251.134) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.874.2 via Frontend Transport; Sat, 4 Feb 2017 07:26:22 +0000
Received: from PS1PR03MB1897.apcprd03.prod.outlook.com ([10.167.49.155]) by PS1PR03MB1897.apcprd03.prod.outlook.com ([10.167.49.155]) with mapi id 15.01.0888.021; Sat, 4 Feb 2017 07:26:21 +0000
Authentication-Results: hipster.bestpractical.com (amavisd-new); dkim=pass header.i= [...] outlook.com
Authentication-Results: rt.cpan.org; dkim=none (message not signed) header.d=none;rt.cpan.org; dmarc=none action=none header.from=outlook.com;
Delivered-To: cpan-bug+DBD-mysql [...] hipster.bestpractical.com
Subject: DBD-MySQL does not support MySQL Authentication Switch method.
Thread-Index: AQHSfrf7acH6dVHVgkyM4cMkloUyNg==
Dkim-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=Y3hLr41feVQLiSmhnBTXTOOUORjJv1P/Tih1pCpgHQU=; b=X3Kk+wTNmS9EAS/WXnfz+SbAkRaV9buKV0nzU2WFUhJ/nu8bq4VxVnNPKiRGmHFY/8j0FLjRI/HkwRRDIrcNAYwPDGSU9m+Tkh0HwD4mo7H+Se+m3aQksUN1And6aP/XXY7ZTc2FfdaUWZ+2hRcvXWpLRJgBPP887Sn/4mKO/BV/XD8FNsyugdT9a49smatNX3NACENd7WcjHTGSsGolYLviaIiyM40NdYaiQdnWmg9qfNaFpomXtPgdP/YZiKOySIURhcpce0U1ZIpwR8PuJVRqSY2XnRkYQs/4LXz0ZMcJQ8JIUOOFVx6tsfB2mJzWe9ooIRD7no/RHaIMVl8OuA==
X-Incomingheadercount: 37
X-PMX-Spam: Gauge=IIIIIIII, Probability=8%, Report=' HTML_70_90 0.1, SUPERLONG_LINE 0.05, BODYTEXTH_SIZE_10000_LESS 0, BODYTEXTP_SIZE_3000_LESS 0, BODY_SIZE_3000_3999 0, BODY_SIZE_5000_LESS 0, BODY_SIZE_7000_LESS 0, DKIM_SIGNATURE 0, SPF_PASS 0, URI_ENDS_IN_HTML 0, WEBMAIL_SOURCE 0, __ANY_URI 0, __CP_URI_IN_BODY 0, __CT 0, __CTYPE_HAS_BOUNDARY 0, __CTYPE_MULTIPART 0, __CTYPE_MULTIPART_ALT 0, __DQ_NEG_HEUR 0, __DQ_NEG_IP 0, __FRAUD_WEBMAIL 0, __FRAUD_WEBMAIL_FROM 0, __HAS_FROM 0, __HAS_HTML 0, __HAS_MSGID 0, __HAS_XOAT 0, __HELO_HOTMAIL 0, __HTML_AHREF_TAG 0, __HTML_FONT_BLUE 0, __HTML_TAG_DIV 0, __HTTPS_URI 0, __MIME_HTML 0, __MIME_TEXT_H 0, __MIME_TEXT_H1 0, __MIME_TEXT_H2 0, __MIME_TEXT_P 0, __MIME_TEXT_P1 0, __MIME_TEXT_P2 0, __MIME_VERSION 0, __MULTIPLE_URI_TEXT 0, __RDNS_HOTMAIL 0, __RECEIVED_FROM_MSN_LIVE 0, __SANE_MSGID 0, __STYLE_RATWARE_NEG 0, __STYLE_TAG 0, __TAG_EXISTS_HTML 0, __TO_MALFORMED_2 0, __TO_NAME 0, __URI_IN_BODY 0, __URI_NO_MAILTO 0, __URI_NO_WWW 0, __URI_NS , __URI_WITH_PATH 0, __blackholes.mail-abuse.org_TIMEOUT , __zen.spamhaus.org_ERROR '
Date: Sat, 4 Feb 2017 07:26:21 +0000
X-Originatororg: outlook.com
X-MS-Office365-Filtering-Correlation-ID: f692e1a0-3987-45f6-4913-08d44ccf1e65
X-Spam-Level: *
X-PMX-Version: 5.6.1.2065439, Antispam-Engine: 2.7.2.376379, Antispam-Data: 2017.2.4.71815
X-MS-Exchange-Crosstenant-ID: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
To: " bug-DBD-mysql [...] rt.cpan.org" <bug-DBD-mysql [...] rt.cpan.org>
X-Exchange-Antispam-Report-Cfa-Test: BCL:0;PCL:0;RULEID:(444111334)(432015086)(82015046);SRVR:SG2APC01HT105;BCL:0;PCL:0;RULEID:;SRVR:SG2APC01HT105;
X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001)(5061506426)(5061507331)(1603103135)(1601125107)(1603101373)(1701031045);SRVR:SG2APC01HT105;
X-Forefront-Antispam-Report: EFV:NLI;SFV:NSPM;SFS:(10019020)(98900005);DIR:OUT;SFP:1102;SCL:1;SRVR:SG2APC01HT105;H:PS1PR03MB1897.apcprd03.prod.outlook.com;FPR:;SPF:None;LANG:en;
X-Originalarrivaltime: 04 Feb 2017 07:26:25.0355 (UTC) FILETIME=[FE0D11B0:01D27EB7]
X-Spam-Status: No, score=1.367 tagged_above=-99.9 required=10 tests=[BAYES_50=0.8, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, SPF_SOFTFAIL=0.665] autolearn=no
X-Microsoft-Exchange-Diagnostics: 1;SG2APC01HT105;5:DJAXGuZPqtrJIs+s/Z67seytST1kAW5kugLqvE4RU1rtgDuFELSWIMMLLYIfH8Axh9alyoKYARZbYWLY9ooaP8ejDTUEkcV04DIc83YXFr2nCvBR8H8QnXegvWyJ9BRbqDPiQA6wjNaZUb3Yqshz9g==;24:iv/6UaRbHDk4hhk27/GBYGXqifTSKcsfNSMmdpebPYw/BXbswNYq/2OOcB3T15nyceGmIewDHlzNvHsZX81A5J6zuBoaO3dm5YXYEzsPsB0=;7:grJsTlMhfjxz6Bz28F8j0WMk9vNnkSOHpPqPc+JUP37gS32nkQMhbOHII+dCYo6KcCCBfhZW9adhbcn0/yeYfvz+gyIicHF9h4SE1k2H8GRZtuP6wVK4s6tWZOkTT+JX7B3ZtN2znT1UuuLGEpokwXFF1NFZcrKfQbfIAJRZYt10I1FTMO2P7p8rHEf0iwN+Pb8hSu5Zy6auQXMLLKVb9sewO/npD9zfT3gBFGTZ7G7lKNGB7/Reh4AOPGsnMfRMZW/kcrfaEDjzMVpEqhJQaqCb5izbI0F/NSbURtr2OJbSgzmcsQkplc8C9WXyeHzmrdK8IsxzXneR68sydJ7qHbs1Gk09HXa0c0dQVVSwOsbe44HkRD5E6wU/gheTyPXOhrP8Nif1NTKMAl8KYHRm9Qc5xaRa2ndXfiIojry0939mBqRMULk8Eu8spDvtgHu6GqyqrqJBdXv25p/UGuaySgKiMICn5wbNwnPbs/okIXyUwb7njMMMzqWqmFTSJ9yTqDVeTPQUxBtFqQWLNjBqUA==
Content-Language: en-US
X-Eopattributedmessage: 0
Message-ID: <PS1PR03MB189704790DBE2EFD5F9CE1DC9A4E0 [...] PS1PR03MB1897.apcprd03.prod.outlook.com>
X-MS-Tnef-Correlator:
Return-Path: <xiangyu.hu [...] outlook.com>
X-MS-Exchange-Crosstenant-Originalarrivaltime: 04 Feb 2017 07:26:21.6757 (UTC)
X-Original-To: cpan-bug+DBD-mysql [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbd-mysql
X-Forefront-PRVS: 020877E0CB
Thread-Topic: DBD-MySQL does not support MySQL Authentication Switch method.
X-MS-Has-Attach:
X-TMN: [L2KDrRukV0hZgu0tftmJpyJ5DWb3jPKB]
Accept-Language: en-US
X-MS-Exchange-Messagesentrepresentingtype: 1
X-MS-Exchange-Transport-Crosstenantheadersstamped: SG2APC01HT105
From: xiangyu hu <xiangyu.hu [...] outlook.com>
X-RT-Interface: Email
Content-Length: 0
content-type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64
X-RT-Original-Encoding: utf-8
Content-Length: 378
Download (untitled) / with headers
text/plain 378b
Hey Team, Greetings. I am using DBD-MySQL and we are relying a MySQL protocol spec of Authentication Switch (https://dev.mysql.com/doc/internals/en/determining-authentication-method.html) . It appears DBD-MySQL does not fully support that. Please verify and take a look. Thanks, Xiangyu Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: base64
Content-ID: <370479EE17EDF648BEEA0C70DD1CC7E4 [...] sct-15-1-789-5-msonline-outlook-22262.templateTenant>
X-RT-Original-Encoding: utf-8
Content-Length: 2031
MIME-Version: 1.0
In-Reply-To: <PS1PR03MB189704790DBE2EFD5F9CE1DC9A4E0 [...] PS1PR03MB1897.apcprd03.prod.outlook.com>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <PS1PR03MB189704790DBE2EFD5F9CE1DC9A4E0 [...] PS1PR03MB1897.apcprd03.prod.outlook.com>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-16453-1488656964-1698.120091-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 1299
Download (untitled) / with headers
text/plain 1.2k
On Sob Feb 04 02:26:39 2017, xiangyu.hu@outlook.com wrote: Show quoted text
> Hey Team, > > Greetings. I am using DBD-MySQL and we are relying a MySQL protocol > spec of Authentication Switch > (https://dev.mysql.com/doc/internals/en/determining-authentication- > method.html) . It appears DBD-MySQL does not fully support that. > Please verify and take a look. > > Thanks, > Xiangyu > > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for > Windows 10 >
Hi! What are you using for connecting to your server? Just standard mysql client binary with --default-auth= and --plugin-dir= options? https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html#option_mysql_default-auth https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html#option_mysql_plugin-dir Or do you have those settings already in your my.cnf? DBD::mysql does not support specifing MYSQL_DEFAULT_AUTH or MYSQL_PLUGIN_DIR to libmysqlclient yet. https://dev.mysql.com/doc/refman/5.7/en/mysql-options.html But you can use DBD::mysql mysql_read_default_file and mysql_read_default_group options to specify your own my.cnf file https://metacpan.org/pod/DBD::mysql#mysql_read_default_file Note that unline mysql client executable, DBD::mysql does not read any default my.cnf. So you need to specify it for DBI.
X-MS-Exchange-Crosstenant-Fromentityheader: Internet
Spamdiagnosticmetadata: NSPM
X-Incomingtopheadermarker: OriginalChecksum:99CEF6A863DEFA059023EE7429B0849BCC7D84D6591A96A5E03D7C2C393A7F45;UpperCasedChecksum:3A94576930F18E61C41AAEE8CEBED69D6E475A846FC170BBE0ADB447C7203E55;SizeAsReceived:7974;Count:39
MIME-Version: 1.0
Spamdiagnosticoutput: 1:99
X-Cpan.org: This message routed through the cpan.org mail forwarding service. Please use PAUSE pause.perl.org to configure your delivery settings.
X-Spam-Flag: NO
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Content-Type: multipart/alternative; boundary="_000_SIXPR0301MB133962E9D7F1FAFF16E313C39A2C0SIXPR0301MB1339_"
X-Spam-Score: -1.983
Authentication-Results: hipster.bestpractical.com (amavisd-new); dkim=pass header.i= [...] outlook.com
Authentication-Results: rt.cpan.org; dkim=none (message not signed) header.d=none;rt.cpan.org; dmarc=none action=none header.from=outlook.com;
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 566592401D5 for <cpan-bug+DBD-mysql [...] hipster.bestpractical.com>; Sun, 5 Mar 2017 23:23:06 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id BMDht5Fn1bsl for <cpan-bug+DBD-mysql [...] hipster.bestpractical.com>; Sun, 5 Mar 2017 23:23:04 -0500 (EST)
Received: from xx1.develooper.com (xx1.develooper.com [207.171.7.115]) by hipster.bestpractical.com (Postfix) with ESMTPS id ECE71240022 for <bug-DBD-mysql [...] rt.cpan.org>; Sun, 5 Mar 2017 23:23:03 -0500 (EST)
Received: from localhost (xx1.develooper.com [127.0.0.1]) by localhost (Postfix) with ESMTP id C114411D9D8 for <bug-DBD-mysql [...] rt.cpan.org>; Sun, 5 Mar 2017 20:23:02 -0800 (PST)
Received: from xx1.develooper.com (xx1.develooper.com [127.0.0.1]) by localhost (Postfix) with SMTP id 036D511DA03 for <bug-DBD-mysql [...] rt.cpan.org>; Sun, 5 Mar 2017 20:23:00 -0800 (PST)
Received: from SNT004-OMC1S5.hotmail.com (snt004-omc1s5.hotmail.com [65.55.90.16]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) by xx1.develooper.com (Postfix) with ESMTPS id C39DE11D9D8 for <bug-DBD-mysql [...] rt.cpan.org>; Sun, 5 Mar 2017 20:22:57 -0800 (PST)
Received: from APC01-PU1-obe.outbound.protection.outlook.com ([65.55.90.8]) by SNT004-OMC1S5.hotmail.com over TLS secured channel with Microsoft SMTPSVC(7.5.7601.23008); Sun, 5 Mar 2017 20:22:57 -0800
Received: from PU1APC01FT036.eop-APC01.prod.protection.outlook.com (10.152.252.59) by PU1APC01HT059.eop-APC01.prod.protection.outlook.com (10.152.253.126) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.933.11; Mon, 6 Mar 2017 04:22:54 +0000
Received: from SIXPR0301MB1339.apcprd03.prod.outlook.com (10.152.252.58) by PU1APC01FT036.mail.protection.outlook.com (10.152.252.207) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.933.11 via Frontend Transport; Mon, 6 Mar 2017 04:22:53 +0000
Received: from SIXPR0301MB1339.apcprd03.prod.outlook.com ([10.162.179.27]) by SIXPR0301MB1339.apcprd03.prod.outlook.com ([10.162.179.27]) with mapi id 15.01.0947.018; Mon, 6 Mar 2017 04:22:53 +0000
Delivered-To: cpan-bug+DBD-mysql [...] hipster.bestpractical.com
Subject: RE: [rt.cpan.org #120091] DBD-MySQL does not support MySQL Authentication Switch method.
Dkim-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=BdPYGSuQWLsLLfPqtzQH8sO1nGcSrudy2733WCYgGlU=; b=RHDD/cCDku0BuIu7mJMhQnaVdJBqu7ZgVvZTHzHg5+j57/MQIfluvegm1L5PM+q/u3t5IL53UQuQiAsL5hSM5bpt7xAZxp3oj7zoe+8q3xzIRE5S/uuyvg8lsf8zwrJdlWIlBLbeEfB27AXUmco+WYekwndyg0/LFYYGxIWnsbPczsHs0oQHwRgHz2K0F8OCuMUUFEJvQdhyqDBaMnyBu+ngzUoNZu8axQxfu0mkUAhWvoBFWA7HrDouVz9ySnEX2m2bFIu6V/aYfStij+ekW9lNxmLDQlQLUa4ZDoBVlSScbz1MSzDvajWlbDJiLd/JsQSBXXbM1l9jk9RPwsL45A==
Thread-Index: AQHSfrf7acH6dVHVgkyM4cMkloUyNqGFQ2sAgAIhxj4=
X-Incomingheadercount: 39
Date: Mon, 6 Mar 2017 04:22:52 +0000
X-PMX-Spam: Gauge=IIIIIIII, Probability=8%, Report=' HTML_50_70 0.1, BODYTEXTH_SIZE_10000_LESS 0, BODYTEXTH_SIZE_3000_MORE 0, DKIM_SIGNATURE 0, IN_REP_TO 0, LEGITIMATE_SIGNS 0, MSG_THREAD 0, SPF_PASS 0, URI_ENDS_IN_HTML 0, WEBMAIL_SOURCE 0, __ANY_URI 0, __BOUNCE_CHALLENGE_SUBJ 0, __BOUNCE_NDR_SUBJ_EXEMPT 0, __CP_URI_IN_BODY 0, __CT 0, __CTYPE_HAS_BOUNDARY 0, __CTYPE_MULTIPART 0, __CTYPE_MULTIPART_ALT 0, __DQ_NEG_HEUR 0, __DQ_NEG_IP 0, __FORWARDED_MSG 0, __FRAUD_BODY_WEBMAIL 0, __FRAUD_WEBMAIL 0, __FRAUD_WEBMAIL_FROM 0, __HAS_FROM 0, __HAS_HTML 0, __HAS_MSGID 0, __HAS_XOAT 0, __HELO_HOTMAIL 0, __HTML_AHREF_TAG 0, __HTML_FONT_BLUE 0, __HTML_TAG_DIV 0, __HTTPS_URI 0, __IN_REP_TO 0, __MIME_HTML 0, __MIME_TEXT_H 0, __MIME_TEXT_H1 0, __MIME_TEXT_H2 0, __MIME_TEXT_P 0, __MIME_TEXT_P1 0, __MIME_TEXT_P2 0, __MIME_VERSION 0, __MULTIPLE_URI_HTML 0, __MULTIPLE_URI_TEXT 0, __RDNS_HOTMAIL 0, __RECEIVED_FROM_MSN_LIVE 0, __SANE_MSGID 0, __STYLE_RATWARE_NEG 0, __STYLE_TAG 0, __SUBJ_ALPHA_NEGATE 0, __TAG_EXISTS_HTML 0, __TO_MALFORMED_2 0, __TO_NAME 0, __TO_NAME_DIFF_FROM_ACC 0, __TO_REAL_NAMES 0, __URI_IN_BODY 0, __URI_NO_WWW 0, __URI_NS , __URI_WITH_PATH 0, __blackholes.mail-abuse.org_ERROR , __zen.spamhaus.org_ERROR '
X-Originatororg: outlook.com
X-Spam-Level:
X-MS-Office365-Filtering-Correlation-ID: d2ff8e2b-697b-4b97-c946-08d46448751d
X-PMX-Version: 5.6.1.2065439, Antispam-Engine: 2.7.2.376379, Antispam-Data: 2017.3.6.41217
X-MS-Exchange-Crosstenant-ID: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
To: Pali via RT <bug-DBD-mysql [...] rt.cpan.org>
X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001)(201702061074)(5061506573)(5061507331)(1603103135)(1601125254)(1603101448)(1701031045);SRVR:PU1APC01HT059;
X-Exchange-Antispam-Report-Cfa-Test: BCL:0;PCL:0;RULEID:(432015087)(444000031);SRVR:PU1APC01HT059;BCL:0;PCL:0;RULEID:;SRVR:PU1APC01HT059;
X-Forefront-Antispam-Report: EFV:NLI;SFV:NSPM;SFS:(10019020)(98900016);DIR:OUT;SFP:1102;SCL:1;SRVR:PU1APC01HT059;H:SIXPR0301MB1339.apcprd03.prod.outlook.com;FPR:;SPF:None;LANG:en;
X-Originalarrivaltime: 06 Mar 2017 04:22:57.0719 (UTC) FILETIME=[55619C70:01D29631]
In-Reply-To: <rt-4.0.18-16453-1488656965-148.120091-6-0 [...] rt.cpan.org>
X-Spam-Status: No, score=-1.983 tagged_above=-99.9 required=10 tests=[AWL=3.350, BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_FROM=0.001, FROM_OUR_RT=-4, HTML_MESSAGE=0.001, SPF_SOFTFAIL=0.665] autolearn=ham
X-Microsoft-Exchange-Diagnostics: 1;PU1APC01HT059;5:qE/Th27G2h1ZH07Vk2Qpwtn+Un4OLrlD338Vo3Ue2hWpV7583kvJ5RKmzSG1avvMiD4pMcN7PdTRliaOYQs5rENCUZHX7idCwTDOjCV20gNoY1HiAlR35dW1crDXXSzgv1sgqOi+cnbibf1QxZyNRg==;24:VX2Jalb8RxXL0jO4KV4Ro1xaoE6IgiGW0uq2I5cRmEy4ydE7IIlsNcvsVvKGqu6jXc2V6ksGnQssNDs01xvH4QPzTRStKmnCWbUD5FK6UJY=;7:vdgaD61cAwFD9g0AzprxcmCRbQ39J1RQUDd11GyPAVkTNsP1zFbqTzqjJmI/VnFj/ZuSHf6bk1LiORYzWO28sWe8OFVF3hQaHtvhkAog1s+7UaW6gmTiW6/e9MoRErYQtgIzj98vCwA4ygDIbbSgQclTNxUuP2RwK0yiB/yq/ajEHImTPjTbgc+ytmcBoB1DM7DmcWFwkuTLWJ+n/rdltAzMaxBhQGEt9V1jOgPNoh+/QnbTzMMkPan1zg3w00FB/srKQoQu6dI+aIE33R3r/GYRhE5LAOf/qlwdDVOCO/nlZCpsUu25J96Z/UC13Xmj
X-RT-Interface: API
X-Eopattributedmessage: 0
Content-Language: en-US
References: <RT-Ticket-120091 [...] rt.cpan.org> <PS1PR03MB189704790DBE2EFD5F9CE1DC9A4E0 [...] PS1PR03MB1897.apcprd03.prod.outlook.com>,<rt-4.0.18-16453-1488656965-148.120091-6-0 [...] rt.cpan.org>
Message-ID: <SIXPR0301MB133962E9D7F1FAFF16E313C39A2C0 [...] SIXPR0301MB1339.apcprd03.prod.outlook.com>
X-MS-Tnef-Correlator:
Return-Path: <xiangyu.hu [...] outlook.com>
X-RT-Mail-Extension: dbd-mysql
X-Original-To: cpan-bug+DBD-mysql [...] hipster.bestpractical.com
X-MS-Exchange-Crosstenant-Originalarrivaltime: 06 Mar 2017 04:22:52.9985 (UTC)
X-Forefront-PRVS: 0238AEEDB0
X-MS-Has-Attach:
Thread-Topic: [rt.cpan.org #120091] DBD-MySQL does not support MySQL Authentication Switch method.
X-TMN: [OHSbfq7uXe660uHIn9G21WbhOrx0zGW/]
Accept-Language: en-US
X-MS-Exchange-Messagesentrepresentingtype: 1
From: xiangyu hu <xiangyu.hu [...] outlook.com>
X-MS-Exchange-Transport-Crosstenantheadersstamped: PU1APC01HT059
RT-Message-ID: <rt-4.0.18-15594-1488774187-1451.120091-0-0 [...] rt.cpan.org>
Content-Length: 0
content-type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: utf-8
Content-Length: 2926
Download (untitled) / with headers
text/plain 2.8k
Hi Pali, Thank you for your reply. I am actually talking about “Authentication Method switch packet” that is part of MySQL handshake protocol and yet not recognized by DBD::MySQL. The process is described in the uri I said before – When including authentication reply in the Handshake Response Packet<https://dev.mysql.com/doc/internals/en/connection-phase-packets.html#packet-Protocol::HandshakeResponse>, client is not obliged to use the same authentication method that was indicated by server in the Initial Handshake Packet<https://dev.mysql.com/doc/internals/en/connection-phase-packets.html#packet-Protocol::Handshake>. The name of the authentication method used by client is stored in the packet. If the guessed authentication method used either by the client or the server in the initial handshake was not correct, server informs client which authentication method should be used using Authentication Method Switch Request Packet<https://dev.mysql.com/doc/internals/en/connection-phase-packets.html#packet-Protocol::AuthSwitchRequest> (see Section 14.2.3, “Authentication Method Mismatch”<https://dev.mysql.com/doc/internals/en/authentication-method-mismatch.html>). Thank you Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 From: Pali via RT<mailto:bug-DBD-mysql@rt.cpan.org> Sent: Sunday, March 5, 2017 3:49 AM To: xiangyu.hu@outlook.com<mailto:xiangyu.hu@outlook.com> Cc: pali@cpan.org<mailto:pali@cpan.org> Subject: [rt.cpan.org #120091] DBD-MySQL does not support MySQL Authentication Switch method. <URL: https://rt.cpan.org/Ticket/Display.html?id=120091 > On Sob Feb 04 02:26:39 2017, xiangyu.hu@outlook.com wrote: Show quoted text
> Hey Team, > > Greetings. I am using DBD-MySQL and we are relying a MySQL protocol > spec of Authentication Switch > (https://dev.mysql.com/doc/internals/en/determining-authentication- > method.html) . It appears DBD-MySQL does not fully support that. > Please verify and take a look. > > Thanks, > Xiangyu > > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for > Windows 10 >
Hi! What are you using for connecting to your server? Just standard mysql client binary with --default-auth= and --plugin-dir= options? https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html#option_mysql_default-auth https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html#option_mysql_plugin-dir Or do you have those settings already in your my.cnf? DBD::mysql does not support specifing MYSQL_DEFAULT_AUTH or MYSQL_PLUGIN_DIR to libmysqlclient yet. https://dev.mysql.com/doc/refman/5.7/en/mysql-options.html But you can use DBD::mysql mysql_read_default_file and mysql_read_default_group options to specify your own my.cnf file https://metacpan.org/pod/DBD::mysql#mysql_read_default_file Note that unline mysql client executable, DBD::mysql does not read any default my.cnf. So you need to specify it for DBI.
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: utf-8
Content-Length: 5819
MIME-Version: 1.0
In-Reply-To: <rt-4.0.18-15594-1488774187-1451.120091-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <RT-Ticket-120091 [...] rt.cpan.org> <PS1PR03MB189704790DBE2EFD5F9CE1DC9A4E0 [...] PS1PR03MB1897.apcprd03.prod.outlook.com>,<rt-4.0.18-16453-1488656965-148.120091-6-0 [...] rt.cpan.org> <SIXPR0301MB133962E9D7F1FAFF16E313C39A2C0 [...] SIXPR0301MB1339.apcprd03.prod.outlook.com> <rt-4.0.18-15594-1488774187-1451.120091-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-26796-1488789022-1396.120091-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 755
Download (untitled) / with headers
text/plain 755b
On Sun Mar 05 23:23:07 2017, xiangyu.hu@outlook.com wrote: Show quoted text
> I am actually talking about “Authentication Method switch packet” that > is part of MySQL handshake protocol and yet not recognized by > DBD::MySQL. The process is described in the uri I said before –
DBD::mysql does not process any MySQL protocol packets nor MySQL handshake. All is done by underlying MySQL or MariaDB client library libmysqlclient.so And IIRC "Authentication Method switch packet" is already handled by libmysqlclient.so and plugin for that method automatically loaded from --plugin-dir= options. So are you able to connect to your MySQL server via mysql executable? If yes, then you should be able also via DBD::mysql by options which I described in previous email.
X-RT-Interface: REST
MIME-Version: 1.0
X-Mailer: MIME-tools 5.504 (Entity 5.504)
RT-Message-ID: <rt-4.0.18-26088-1510732643-624.120091-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Content-Disposition: inline
Content-Transfer-Encoding: binary
Content-Length: 78


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.