API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 1st, 2016
77
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.15 KB | None | 0 0
raw download clone embed print report
  1. MySQL [(none)]> show variables like '%ssl%';
  2. +---------------+--------------------------------+
  3. | Variable_name | Value |
  4. +---------------+--------------------------------+
  5. | have_openssl | YES |
  6. | have_ssl | YES |
  7. | ssl_ca | /etc/mysql/ssl/ca-cert.pem |
  8. | ssl_capath | |
  9. | ssl_cert | /etc/mysql/ssl/server-cert.pem |
  10. | ssl_cipher | |
  11. | ssl_key | /etc/mysql/ssl/server-key.pem |
  12. +---------------+--------------------------------+
  13.  
  14. $ perl -e '
  15. use DBI;
  16. DBI->trace("15|CON");
  17. my $dbh = DBI->connect("DBI:mysql:host=my_dbhost;database=test;", "test", "test",
  18. {
  19. PrintError => 1,
  20. RaiseError => 1,
  21. mysql_ssl => 0,
  22. mysql_skip_secure_auth => 1
  23. });
  24. $dbh->disconnect();'
  25.  
  26. DBI 1.634-ithread default trace level set to 0x200/15 (pid 11328 pi ee1010) at -e line 1
  27. -> DBI->connect(DBI:mysql:host=my_dbhost;database=test;, test, ****, HASH(0xee3f30))
  28. -> DBI->install_driver(mysql) for linux perl=5.022001 pid=11328 ruid=10000 euid=10000
  29. install_driver: DBD::mysql version 4.033 loaded from /usr/lib/x86_64-linux-gnu/perl5/5.22/DBD/mysql.pm
  30. New 'DBI::dr' (for DBD::mysql::dr, parent='', id=undef)
  31. dbih_setup_handle(DBI::dr=HASH(0x11e6848)=>DBI::dr=HASH(0xf184e8), DBD::mysql::dr, 0, Null!)
  32. dbih_make_com(Null!, 0, DBD::mysql::dr, 152, 0) thr#ee1010
  33. dbih_setup_attrib(DBI::dr=HASH(0xf184e8), Err, Null!) SCALAR(0x1016f28) (already defined)
  34. dbih_setup_attrib(DBI::dr=HASH(0xf184e8), State, Null!) SCALAR(0x10db678) (already defined)
  35. dbih_setup_attrib(DBI::dr=HASH(0xf184e8), Errstr, Null!) SCALAR(0x103c648) (already defined)
  36. dbih_setup_attrib(DBI::dr=HASH(0xf184e8), TraceLevel, Null!) 0 (already defined)
  37. dbih_setup_attrib(DBI::dr=HASH(0xf184e8), FetchHashKeyName, Null!) 'NAME' (already defined)
  38. install_method DBI::db::mysql_fd
  39. install_method DBI::db::mysql_async_result
  40. install_method DBI::db::mysql_async_ready
  41. install_method DBI::st::mysql_async_result
  42. install_method DBI::st::mysql_async_ready
  43. <- install_driver= DBI::dr=HASH(0x11e6848)
  44. >> connect DISPATCH (DBI::dr=HASH(0x11e6848) rc2/3 @5 g2 ima8001 pid#11328) at /usr/lib/x86_64-linux-gnu/perl5/5.22/DBI.pm line 683
  45. !! The warn '0' was CLEARED by call to connect method
  46. -> connect for DBD::mysql::dr (DBI::dr=HASH(0x11e6848)~0xf184e8 'host=my_dbhost;database=test;' 'test' **** HASH(0x106d978)) thr#ee1010
  47. New 'DBI::db' (for DBD::mysql::db, parent=DBI::dr=HASH(0xf184e8), id=HASH(0x12164b8))
  48. dbih_setup_handle(DBI::db=HASH(0x1216338)=>DBI::db=HASH(0x121ce50), DBD::mysql::db, 10db930, HASH(0x12164b8))
  49. dbih_make_com(DBI::dr=HASH(0xf184e8), f0fd90, DBD::mysql::db, 192, 121cd78) thr#ee1010
  50. dbih_setup_attrib(DBI::db=HASH(0x121ce50), Err, DBI::dr=HASH(0xf184e8)) SCALAR(0x10f2d70) (already defined)
  51. dbih_setup_attrib(DBI::db=HASH(0x121ce50), State, DBI::dr=HASH(0xf184e8)) SCALAR(0x10f2dd0) (already defined)
  52. dbih_setup_attrib(DBI::db=HASH(0x121ce50), Errstr, DBI::dr=HASH(0xf184e8)) SCALAR(0x10f2da0) (already defined)
  53. dbih_setup_attrib(DBI::db=HASH(0x121ce50), TraceLevel, DBI::dr=HASH(0xf184e8)) 0 (already defined)
  54. dbih_setup_attrib(DBI::db=HASH(0x121ce50), FetchHashKeyName, DBI::dr=HASH(0xf184e8)) 'NAME' (already defined)
  55. dbih_setup_attrib(DBI::db=HASH(0x121ce50), HandleSetErr, DBI::dr=HASH(0xf184e8)) undef (not defined)
  56. dbih_setup_attrib(DBI::db=HASH(0x121ce50), HandleError, DBI::dr=HASH(0xf184e8)) undef (not defined)
  57. dbih_setup_attrib(DBI::db=HASH(0x121ce50), ReadOnly, DBI::dr=HASH(0xf184e8)) undef (not defined)
  58. dbih_setup_attrib(DBI::db=HASH(0x121ce50), Profile, DBI::dr=HASH(0xf184e8)) undef (not defined)
  59. imp_dbh->connect: dsn = host=my_dbhost;database=test;, uid = test, pwd = test
  60. imp_dbh->my_login : dbname = test, uid = test, pwd = test,host = my_dbhost, port = NULL
  61. imp_dbh->mysql_dr_connect: host = |my_dbhost|, port = 0, uid = test, pwd = test
  62. imp_dbh->mysql_dr_connect: Skipping secure auth
  63. imp_dbh->bind_type_guessing: 0
  64. imp_dbh->use_server_side_prepare: 0
  65. imp_dbh->mysql_dr_connect: client_flags = 2
  66. imp_dbh->mysql_dr_connect: <- --> do_error
  67. SSL connection error: protocol version mismatch error 2026 recorded: SSL connection error: protocol version mismatch
  68. <-- do_error
  69. >> DESTROY DISPATCH (DBI::db=HASH(0x1216338) rc1/1 @1 g2 ima10004 pid#11328) at /usr/lib/x86_64-linux-gnu/perl5/5.22/DBD/mysql.pm line 163 via at -e line 1
  70. <> DESTROY(DBI::db=HASH(0x1216338)) ignored for outer handle (inner DBI::db=HASH(0x121ce50) has ref cnt 2)
  71. >> DESTROY DISPATCH (DBI::db=HASH(0x121ce50) rc1/1 @1 g2 ima10004 pid#11328) at /usr/lib/x86_64-linux-gnu/perl5/5.22/DBI.pm line 683 via at -e line 1
  72. -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x121ce50)~INNER) thr#ee1010
  73. DESTROY for DBI::db=HASH(0x121ce50) ignored - handle not initialised
  74. ERROR: 2026 'SSL connection error: protocol version mismatch' (err#0)
  75. <- DESTROY= ( undef ) [1 items] at /usr/lib/x86_64-linux-gnu/perl5/5.22/DBI.pm line 683 via at -e line 1
  76. DESTROY (dbih_clearcom) (dbh 0x121ce50, com 0x123c3b0, imp DBD::mysql::db):
  77. FLAGS 0x100211: COMSET Warn PrintWarn AutoCommit
  78. ERR 2026
  79. ERRSTR 'SSL connection error: protocol version mismatch'
  80. PARENT DBI::dr=HASH(0xf184e8)
  81. KIDS 0 (0 Active)
  82. IMP_DATA HASH(0x12164b8)
  83. dbih_clearcom 0x121ce50 (com 0x123c3b0, type 2) done.
  84.  
  85. !! ERROR: 2026 'SSL connection error: protocol version mismatch' (err#0)
  86. <- connect= ( undef ) [1 items] at /usr/lib/x86_64-linux-gnu/perl5/5.22/DBI.pm line 683
  87. -> $DBI::errstr (&) FETCH from lasth=HASH
  88. >> DBD::mysql::dr::errstr
  89. <- $DBI::errstr= 'SSL connection error: protocol version mismatch'
  90. DBI connect('host=my_dbhost;database=test;','test',...) failed: SSL connection error: protocol version mismatch
  91. DBI connect('host=my_dbhost;database=test;','test',...) failed: SSL connection error: protocol version mismatch at -e line 1.
  92. -- DBI::END ($@: , $!: )
  93. >> disconnect_all DISPATCH (DBI::dr=HASH(0x11e6848) rc1/3 @1 g2 ima801 pid#11328) at /usr/lib/x86_64-linux-gnu/perl5/5.22/DBI.pm line 762 via at /usr/share/perl/5.22/Carp.pm line 166
  94. !! The ERROR '2026' was CLEARED by call to disconnect_all method
  95. -> disconnect_all for DBD::mysql::dr (DBI::dr=HASH(0x11e6848)~0xf184e8) thr#ee1010
  96. <- disconnect_all= ( ) [0 items] (not implemented) at /usr/lib/x86_64-linux-gnu/perl5/5.22/DBI.pm line 762 via at /usr/share/perl/5.22/Carp.pm line 166
  97. ! >> DESTROY DISPATCH (DBI::dr=HASH(0xf184e8) rc1/1 @1 g2 ima10004 pid#11328) during global destruction
  98. ! -> DESTROY in DBD::_::common for DBD::mysql::dr (DBI::dr=HASH(0xf184e8)~INNER) thr#ee1010
  99. ! <- DESTROY= ( undef ) [1 items] during global destruction
  100. DESTROY (dbih_clearcom) (drh 0x11e6848, com 0xf0fd90, imp global destruction):
  101. FLAGS 0x100215: COMSET Active Warn PrintWarn AutoCommit
  102. PARENT undef
  103. KIDS 0 (0 Active)
  104. dbih_clearcom 0x11e6848 (com 0xf0fd90, type 1) done.
  105.  
  106. ! >> DESTROY DISPATCH (DBI::dr=HASH(0x11e6848) rc1/1 @1 g2 ima10004 pid#11328) during global destruction
  107. ! <> DESTROY for DBI::dr=HASH(0x11e6848) ignored (inner handle gone)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!