Advertisement
Guest User

Untitled

a guest
Apr 4th, 2017
642
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.88 KB | None | 0 0
  1. mysql> SHOW SLAVE STATUSG;
  2. *************************** 1. row ***************************
  3. Slave_IO_State: Connecting to master
  4. Master_Host: 123.456.78.90
  5. Master_User: replication
  6. Master_Port: 3306
  7. Connect_Retry: 60
  8. Master_Log_File: binary-log.000006
  9. Read_Master_Log_Pos: 225898044
  10. Relay_Log_File: mysqld-relay-bin.000018
  11. Relay_Log_Pos: 4
  12. Relay_Master_Log_File: binary-log.000006
  13. Slave_IO_Running: Connecting
  14. Slave_SQL_Running: Yes
  15. Replicate_Do_DB:
  16. Replicate_Ignore_DB:
  17. Replicate_Do_Table:
  18. Replicate_Ignore_Table:
  19. Replicate_Wild_Do_Table:
  20. Replicate_Wild_Ignore_Table: mysql.%
  21. Last_Errno: 0
  22. Last_Error:
  23. Skip_Counter: 0
  24. Exec_Master_Log_Pos: 225898044
  25. Relay_Log_Space: 107
  26. Until_Condition: None
  27. Until_Log_File:
  28. Until_Log_Pos: 0
  29. Master_SSL_Allowed: Yes
  30. Master_SSL_CA_File: /var/lib/mysql/ssl/ca-cert.pem
  31. Master_SSL_CA_Path:
  32. Master_SSL_Cert: /var/lib/mysql/ssl/client-cert.pem
  33. Master_SSL_Cipher:
  34. Master_SSL_Key: /var/lib/mysql/ssl/client-key.pem
  35. Seconds_Behind_Master: NULL
  36. Master_SSL_Verify_Server_Cert: No
  37. Last_IO_Errno: 2026
  38. Last_IO_Error: error connecting to master 'replication@134.213.65.178:3306' - retry-time: 60 retries: 86400
  39. Last_SQL_Errno: 0
  40. Last_SQL_Error:
  41. Replicate_Ignore_Server_Ids:
  42. Master_Server_Id: 0
  43. 1 row in set (0.00 sec)
  44.  
  45. ERROR:
  46. No query specified
  47.  
  48. mysql> SHOW GRANTS;
  49. +-------------------------------------------------------------------------------------------------------------------------------------+
  50. | Grants for replication@123.456.78.90 |
  51. +-------------------------------------------------------------------------------------------------------------------------------------+
  52. | GRANT REPLICATION SLAVE ON *.* TO 'replication'@'123.456.78.90' IDENTIFIED BY PASSWORD '*E2F700F7365XXXXXXXXXX9F3A4C5C17C' |
  53. +-------------------------------------------------------------------------------------------------------------------------------------+
  54. 1 row in set (0.01 sec)
  55.  
  56. 150709 20:59:00 [ERROR] Slave I/O: error connecting to master 'replication@123.456.78.90:3306' - retry-time: 60 retries: 86400, Error_code: 2026
  57.  
  58. Updating:
  59. mysql55w x86_64 5.5.44-1.w6
  60. mysql55w-libs x86_64 5.5.44-1.w6
  61. mysql55w-server x86_64 5.5.44-1.w6
  62.  
  63. Error: 2026 (CR_SSL_CONNECTION_ERROR)
  64. Message: SSL connection error: %s
  65.  
  66. [user@host ~]# mysql --ssl-ca=/var/lib/mysql/ssl/ca-cert.pem --ssl-cert=/var/lib/mysql/ssl/client-cert.pem --ssl-key=/var/lib/mysql/ssl/client-key.pem -u replication -p -h 123.456.78.90
  67. Enter password:
  68. ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1)
  69.  
  70. [root@server newrscerts2]$ mysql -u rs -p'lamepassword'
  71. --ssl-ca=/etc/mysql/newrscerts/ca.pem --ssl
  72. ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1)
  73.  
  74. [root@server ~]$ mysql -u rs -p'lamepassword'
  75. --ssl-ca=/etc/mysql/newrscerts2/ca-cert.pem
  76. --ssl-cipher=AES128-SHA
  77.  
  78. Welcome to the MySQL monitor.
  79. Commands end with ; or g.
  80. Your MySQL connection id is 10057
  81. Server version: 5.5.43-log Distributed by The IUS Community Project
  82. Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
  83. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
  84.  
  85. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
  86.  
  87. mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement