Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MySQL 8.0.3 Release Candidate removes MYSQL_SECURE_AUTH #891

Closed
yahonda opened this issue Sep 21, 2017 · 1 comment
Closed

MySQL 8.0.3 Release Candidate removes MYSQL_SECURE_AUTH #891

yahonda opened this issue Sep 21, 2017 · 1 comment
Milestone

Comments

@yahonda
Copy link
Contributor

yahonda commented Sep 21, 2017

MySQL 8.0.3 Release Candidate has been released which removes MYSQL_SECURE_AUTH.

https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-3.html#mysqld-8-0-3-capi

The deprecated secure_auth system variable and --secure-auth client option have been removed. The MYSQL_SECURE_AUTH option for the mysql_options() C API function was removed.

According to MySQL 5.7 document MYSQL_SECURE_AUTH has been enabled by default in 5.7
https://dev.mysql.com/doc/refman/5.7/en/mysql-options.html

MYSQL_SECURE_AUTH (argument type: my_bool *)
Whether to connect to a server that does not support the password hashing used in MySQL 4.1.1 and later. This option is enabled by default.

Steps to reproduce

  • Installed MySQL 8.0.3 Release Candidate
$ rpm -qa |grep -i mysql-community
mysql-community-common-8.0.3-0.1.rc.fc26.x86_64
mysql-community-libs-compat-8.0.3-0.1.rc.fc26.x86_64
mysql-community-client-8.0.3-0.1.rc.fc26.x86_64
mysql-community-server-8.0.3-0.1.rc.fc26.x86_64
mysql-community-devel-8.0.3-0.1.rc.fc26.x86_64
mysql-community-libs-8.0.3-0.1.rc.fc26.x86_64
$
  • Remove mysql gem from Gemfile

  • bundle exec rake spec

$ bundle exec rake spec
cd tmp/x86_64-linux/mysql2/2.4.2
/usr/bin/gmake
compiling ../../../../ext/mysql2/client.c
../../../../ext/mysql2/client.c: In function ‘_mysql_client_options’:
../../../../ext/mysql2/client.c:886:10: error: ‘MYSQL_SECURE_AUTH’ undeclared (first use in this function); did you mean ‘MYSQL_DEFAULT_AUTH’?
     case MYSQL_SECURE_AUTH:
          ^~~~~~~~~~~~~~~~~
          MYSQL_DEFAULT_AUTH
../../../../ext/mysql2/client.c:886:10: note: each undeclared identifier is reported only once for each function it appears in
../../../../ext/mysql2/client.c: In function ‘set_secure_auth’:
../../../../ext/mysql2/client.c:1315:38: error: ‘MYSQL_SECURE_AUTH’ undeclared (first use in this function); did you mean ‘MYSQL_DEFAULT_AUTH’?
   return _mysql_client_options(self, MYSQL_SECURE_AUTH, value);
                                      ^~~~~~~~~~~~~~~~~
                                      MYSQL_DEFAULT_AUTH
../../../../ext/mysql2/client.c:1316:1: warning: control reaches end of non-void function [-Wreturn-type]
 }
 ^
../../../../ext/mysql2/client.c: At top level:
cc1: warning: unrecognized command line option -Wno-used-but-marked-unused’
cc1: warning: unrecognized command line option -Wno-static-in-inline’
cc1: warning: unrecognized command line option -Wno-reserved-id-macro’
cc1: warning: unrecognized command line option -Wno-missing-variable-declarations’
cc1: warning: unrecognized command line option -Wno-documentation-unknown-command’
cc1: warning: unrecognized command line option -Wno-disabled-macro-expansion’
cc1: warning: unrecognized command line option -Wno-covered-switch-default’
cc1: warning: unrecognized command line option -Wno-conditional-uninitialized’
cc1: warning: unrecognized command line option -Wno-self-assign’
cc1: warning: unrecognized command line option -Wno-constant-logical-operand’
cc1: warning: unrecognized command line option -Wno-parentheses-equality’
gmake: *** [Makefile:242: client.o] Error 1
rake aborted!
Command failed with status (2): [/usr/bin/gmake...]
/home/yahonda/.rbenv/versions/2.4.2/bin/bundle:23:in `load'
/home/yahonda/.rbenv/versions/2.4.2/bin/bundle:23:in `<main>'
Tasks: TOP => spec => compile => compile:x86_64-linux => compile:mysql2:x86_64-linux => copy:mysql2:x86_64-linux:2.4.2 => tmp/x86_64-linux/mysql2/2.4.2/mysql2.so
(See full trace by running task with --trace)
$
  • Environment
$ more /etc/redhat-release
Fedora release 26 (Twenty Six)
$ ruby -v
ruby 2.4.2p198 (2017-09-14 revision 59899) [x86_64-linux]
@sodabrew sodabrew added this to the 0.5.0 milestone Sep 22, 2017
@yahonda yahonda changed the title MySQL 8.0.3 DMR removes MYSQL_SECURE_AUTH MySQL 8.0.3 Release Candidate removes MYSQL_SECURE_AUTH Sep 22, 2017
@yahonda
Copy link
Contributor Author

yahonda commented Nov 11, 2017

Fixed by #892

@yahonda yahonda closed this as completed Nov 11, 2017
VitaliyAdamkov added a commit to VitaliyAdamkov/mysql2 that referenced this issue Jun 12, 2021
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-3.html#mysqld-8-0-3-capi

    The deprecated secure_auth system variable and --secure-auth client option have been removed.
    The MYSQL_SECURE_AUTH option for the mysql_options() C API function was removed.

This pull request addresses brianmario#891
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants