API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 6th, 2017
158
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.75 KB | None | 0 0
raw download clone embed print report
  1. 17:09 $ docker logs 9c1f459b503e
  2. + MYSQL_ARGS=
  3. + MAIN_ARGS=
  4. + for i in '"$@"'
  5. + case $i in
  6. + MAIN_ARGS=' -a'
  7. + for i in '"$@"'
  8. + case $i in
  9. + MAIN_ARGS=' -a agent'
  10. + for i in '"$@"'
  11. + case $i in
  12. + MAIN_ARGS=' -a agent -p'
  13. + for i in '"$@"'
  14. + case $i in
  15. + MAIN_ARGS=' -a agent -p mysql'
  16. + for i in '"$@"'
  17. + case $i in
  18. + MAIN_ARGS=' -a agent -p mysql -u'
  19. + for i in '"$@"'
  20. + case $i in
  21. + MAIN_ARGS=' -a agent -p mysql -u https://172.17.0.1:18443/'
  22. + for i in '"$@"'
  23. + case $i in
  24. + MAIN_ARGS=' -a agent -p mysql -u https://172.17.0.1:18443/ -c'
  25. + set -- -a agent -p mysql -u https://172.17.0.1:18443/ -c
  26. ++ hostname
  27. ++ md5sum
  28. + HOSTHASH='2296362c90a55fd2da4c60f8874921da -'
  29. + UUID=2296362c-90a5-5fd2-da4c-60f8874921da
  30. + AGENT_HOME=/home/mysql/agent
  31. + AGENT_UTIL=/home/mysql/agent/bin/agent.sh
  32. + AGENT_USER=agent
  33. + AGENT_PASSWORD=mysql
  34. + MEM_URL=https://localhost:8443
  35. + LAUNCH_SHELL=0
  36. + SKIP_MONITOR_MYSQL=0
  37. + SKIP_CREATE_EXTRA_USERS=0
  38. + XMULT=0
  39. + getopts sa:cmu:p:x:d:e:f:g:h:i:j:n: opt
  40. + case $opt in
  41. + AGENT_USER=agent
  42. + getopts sa:cmu:p:x:d:e:f:g:h:i:j:n: opt
  43. + case $opt in
  44. + AGENT_PASSWORD=mysql
  45. + getopts sa:cmu:p:x:d:e:f:g:h:i:j:n: opt
  46. + case $opt in
  47. + MEM_URL=https://172.17.0.1:18443/
  48. + getopts sa:cmu:p:x:d:e:f:g:h:i:j:n: opt
  49. + case $opt in
  50. + SKIP_CREATE_EXTRA_USERS=1
  51. + getopts sa:cmu:p:x:d:e:f:g:h:i:j:n: opt
  52. + '[' -f /home/mysql/mysql-entry.sh ']'
  53. + /home/mysql/mysql-entry.sh echo MySQL init complete
  54. + '[' '!' -f /etc/mysql/conf.d/server_id.cnf ']'
  55. + echo '[mysqld]'
  56. ++ od -vAn -N4 -tu4
  57. + echo server_id = 4168713729
  58. + cd /etc/mysql
  59. + openssl genrsa 4096
  60. Generating RSA private key, 4096 bit long modulus
  61. ....................................++
  62. ...........................................................................................++
  63. e is 65537 (0x10001)
  64. + openssl req -new -x509 -nodes -days 90 -key ca-key.pem -out ca-cert.pem -subj '/C=US/ST=CA/L=Redwood City/O=Oracle Corporation/OU=MySQL Enterprise/CN=localhost'
  65. + openssl req -newkey rsa:4096 -days 90 -nodes -keyout server-key.pem -out server-req.pem -subj '/C=US/ST=CA/L=Redwood City/O=Oracle Corporation/OU=MySQL Enterprise/CN=localhost'
  66. Generating a 4096 bit RSA private key
  67. .............................++
  68. ....................................++
  69. writing new private key to 'server-key.pem'
  70. -----
  71. + openssl rsa -in server-key.pem -out server-key.pem
  72. writing RSA key
  73. + openssl x509 -req -in server-req.pem -days 90 -CA ca-cert.pem -CAkey ca-key.pem -set_serial 01 -out server-cert.pem
  74. Signature ok
  75. subject=/C=US/ST=CA/L=Redwood City/O=Oracle Corporation/OU=MySQL Enterprise/CN=localhost
  76. Getting CA Private Key
  77. + openssl req -newkey rsa:4096 -days 90 -nodes -keyout client-key.pem -out client-req.pem -subj '/C=US/ST=CA/L=Redwood City/O=Oracle Corporation/OU=MySQL Enterprise/CN=localhost'
  78. Generating a 4096 bit RSA private key
  79. ...................................................................................................................................................................................................................................++
  80. .....++
  81. writing new private key to 'client-key.pem'
  82. -----
  83. + openssl rsa -in client-key.pem -out client-key.pem
  84. writing RSA key
  85. + openssl x509 -req -in client-req.pem -days 90 -CA ca-cert.pem -CAkey ca-key.pem -set_serial 01 -out client-cert.pem
  86. Signature ok
  87. subject=/C=US/ST=CA/L=Redwood City/O=Oracle Corporation/OU=MySQL Enterprise/CN=localhost
  88. Getting CA Private Key
  89. + cd /
  90. + mkdir /tmp/corefiles
  91. + chmod 777 /tmp/corefiles
  92. + MAIN_ARGS=
  93. + echo '[mysqld]'
  94. + for i in '"$@"'
  95. + case $i in
  96. + MAIN_ARGS=' echo'
  97. + for i in '"$@"'
  98. + case $i in
  99. + MAIN_ARGS=' echo MySQL'
  100. + for i in '"$@"'
  101. + case $i in
  102. + MAIN_ARGS=' echo MySQL init'
  103. + for i in '"$@"'
  104. + case $i in
  105. + MAIN_ARGS=' echo MySQL init complete'
  106. + [[ -d /mysql/data ]]
  107. + ulimit -c unlimited
  108. + rm -rf '/var/run/mysqld/*'
  109. + wait_for_mysql
  110. + mysqld_safe
  111. + for i in '{1..30}'
  112. + mysql -e 'STOP SLAVE'
  113. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
  114. WARNING: no verification of server certificate will be done. Use --ssl-mode=VERIFY_CA or VERIFY_IDENTITY.
  115. + [[ 1 == \0 ]]
  116. + sleep 1
  117. 2017-09-06T22:08:24.371907Z mysqld_safe Logging to '/var/log/mysql/error.log'.
  118. 2017-09-06T22:08:24.379651Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  119. + for i in '{1..30}'
  120. + mysql -e 'STOP SLAVE'
  121. WARNING: no verification of server certificate will be done. Use --ssl-mode=VERIFY_CA or VERIFY_IDENTITY.
  122. + [[ 0 == \0 ]]
  123. + break
  124. + CA_CERT='-----BEGIN CERTIFICATE-----
  125. MIIFzTCCA7WgAwIBAgIJAPmZXiDQmAZ3MA0GCSqGSIb3DQEBCwUAMH0xCzAJBgNV
  126. BAYTAlVTMQswCQYDVQQIDAJDQTEVMBMGA1UEBwwMUmVkd29vZCBDaXR5MRswGQYD
  127. VQQKDBJPcmFjbGUgQ29ycG9yYXRpb24xGTAXBgNVBAsMEE15U1FMIEVudGVycHJp
  128. c2UxEjAQBgNVBAMMCWxvY2FsaG9zdDAeFw0xNzA5MDYyMjA4MjJaFw0xNzEyMDUy
  129. MjA4MjJaMH0xCzAJBgNVBAYTAlVTMQswCQYDVQQIDAJDQTEVMBMGA1UEBwwMUmVk
  130. d29vZCBDaXR5MRswGQYDVQQKDBJPcmFjbGUgQ29ycG9yYXRpb24xGTAXBgNVBAsM
  131. EE15U1FMIEVudGVycHJpc2UxEjAQBgNVBAMMCWxvY2FsaG9zdDCCAiIwDQYJKoZI
  132. hvcNAQEBBQADggIPADCCAgoCggIBALXYDjdsbb1xdEeriQ6NLIQ+zU77PZ/IDpRB
  133. Ph+VGvAkfYO7PzWwcCTLOIYLkSqNI4krBY/kxh8hkqiNUvS+MNmYMYMk3wBTccbd
  134. uFFbI3EV6enZT1S5nwNl8Bt8iehyrQ1OKUgC0NoX1BMvu2eCMNmI2urYhuT7uAso
  135. BqzTTnCBA4FJe2Rmj/ruqhYxbglmnHmHOXDlmpDj8jwBzkvlfe7d+D8mnUHyfp+B
  136. Jaa8YtKyNCzaVhXBfHLukPJ+wCCwDy/kdQfLym5sT+8bl5XfR40y3BZnHFLMUuZM
  137. aCjL0upLE0zdVv8yVBMkncDs15N+CZiZRttKVc1s4FY5R45ytdKrBDKzsc84SwHS
  138. uxfrNhGMmAcKCqm+fp0i2tIkOHMprNlsDlVIiz2petThZyRrmznatBXnXTYRAz5m
  139. ecXutSNeQegvybHKhL2LzDM8hvHG7v+q8v4u1Uy/+tZRaufq2uUL+mSdrklZeExN
  140. HkU4URCNEAbDmgfs2TneMDnVBfEVpqEwIIVT5c8lCgBn4IEBxvkh9eRSX2mKlVa6
  141. BDu5kYjtHzTEgLzo/yi12GNroYkkqBBSXi1QU3Cr5NI5a93qeaUCNiyoaplrfYfq
  142. pcA6cO9xXoHRK++Lu552/WGwb6FZsX48Qcx0yQnFUXF2vAaF94p2XBGGlKhpOD3w
  143. g4q4mONfAgMBAAGjUDBOMB0GA1UdDgQWBBQYzj8ZwLO5AyEmR9WAn4QzfofDGzAf
  144. BgNVHSMEGDAWgBQYzj8ZwLO5AyEmR9WAn4QzfofDGzAMBgNVHRMEBTADAQH/MA0G
  145. CSqGSIb3DQEBCwUAA4ICAQCJxiHaGZTgbu3jG/fhE6Wh0r/RPgAIAFqr9xkvLJiW
  146. 1ClnwAzs15alm8bcDFFAFbwm27T4HiKbmTLVmQ5aGWCbe+P7gY+6Xzx3qiDJcVxH
  147. Uebg54+1VRjCShKlgemqHNkZInE3EkGcigMlPCbuX7tGvojR5LofyMZFY7lMQ0t/
  148. hFXE1/CMLTvnhE6C4FC/QFTgkoPcHbUYo7ve/a7uWlYaf9xmJj4dcABAPapnFIgf
  149. Id3aF7U2ElwT2UWkpxtSQehqromPWPS6uIbRrgwYgqmagm7zbKrW0eJAz1nS9RAR
  150. P8Bg8J2SgPMvmSugkrAxV8e/voQqnMSfkJKN9dxoJ3q5hO7A93QJ9x2d5Tu5eGsu
  151. Zsg1sAQrKorA8/QqELo0qJ8upkmoTSH6uzG9wNohnb+QoOt2OVnqPmxVRqFhmlGX
  152. uN2ccchloxrWfN0WirJD7It/nlNZdYs6cKz49eo42kW+0OXEfmbsfSoLZ6pR1NRs
  153. MzIpsLflHphFIJmEfnfCX6hAVm3dsCkgjEYO6CcJjhpdgSNznpEaWL/biAtah6Z4
  154. oXt7+EDvlCnzlQmwtr44dNsOHRBVxrjYD6wus8M7x2uWmihRHbDQUbDz8oySKhAe
  155. HAs5AOY94IhPhItYb5WZya43m38UyYE5RIWaFZy38EDjvVYAdnA1gGeftaLdAFln
  156. Wg==
  157. -----END CERTIFICATE-----'
  158. + mysql -e ' SET SQL_LOG_BIN = 0; INSERT INTO mysql.inventory VALUES('\''ca-cert.pem'\'', '\''-----BEGIN CERTIFICATE-----
  159. MIIFzTCCA7WgAwIBAgIJAPmZXiDQmAZ3MA0GCSqGSIb3DQEBCwUAMH0xCzAJBgNV
  160. BAYTAlVTMQswCQYDVQQIDAJDQTEVMBMGA1UEBwwMUmVkd29vZCBDaXR5MRswGQYD
  161. VQQKDBJPcmFjbGUgQ29ycG9yYXRpb24xGTAXBgNVBAsMEE15U1FMIEVudGVycHJp
  162. c2UxEjAQBgNVBAMMCWxvY2FsaG9zdDAeFw0xNzA5MDYyMjA4MjJaFw0xNzEyMDUy
  163. MjA4MjJaMH0xCzAJBgNVBAYTAlVTMQswCQYDVQQIDAJDQTEVMBMGA1UEBwwMUmVk
  164. d29vZCBDaXR5MRswGQYDVQQKDBJPcmFjbGUgQ29ycG9yYXRpb24xGTAXBgNVBAsM
  165. EE15U1FMIEVudGVycHJpc2UxEjAQBgNVBAMMCWxvY2FsaG9zdDCCAiIwDQYJKoZI
  166. hvcNAQEBBQADggIPADCCAgoCggIBALXYDjdsbb1xdEeriQ6NLIQ+zU77PZ/IDpRB
  167. Ph+VGvAkfYO7PzWwcCTLOIYLkSqNI4krBY/kxh8hkqiNUvS+MNmYMYMk3wBTccbd
  168. uFFbI3EV6enZT1S5nwNl8Bt8iehyrQ1OKUgC0NoX1BMvu2eCMNmI2urYhuT7uAso
  169. BqzTTnCBA4FJe2Rmj/ruqhYxbglmnHmHOXDlmpDj8jwBzkvlfe7d+D8mnUHyfp+B
  170. Jaa8YtKyNCzaVhXBfHLukPJ+wCCwDy/kdQfLym5sT+8bl5XfR40y3BZnHFLMUuZM
  171. aCjL0upLE0zdVv8yVBMkncDs15N+CZiZRttKVc1s4FY5R45ytdKrBDKzsc84SwHS
  172. uxfrNhGMmAcKCqm+fp0i2tIkOHMprNlsDlVIiz2petThZyRrmznatBXnXTYRAz5m
  173. ecXutSNeQegvybHKhL2LzDM8hvHG7v+q8v4u1Uy/+tZRaufq2uUL+mSdrklZeExN
  174. HkU4URCNEAbDmgfs2TneMDnVBfEVpqEwIIVT5c8lCgBn4IEBxvkh9eRSX2mKlVa6
  175. BDu5kYjtHzTEgLzo/yi12GNroYkkqBBSXi1QU3Cr5NI5a93qeaUCNiyoaplrfYfq
  176. pcA6cO9xXoHRK++Lu552/WGwb6FZsX48Qcx0yQnFUXF2vAaF94p2XBGGlKhpOD3w
  177. g4q4mONfAgMBAAGjUDBOMB0GA1UdDgQWBBQYzj8ZwLO5AyEmR9WAn4QzfofDGzAf
  178. BgNVHSMEGDAWgBQYzj8ZwLO5AyEmR9WAn4QzfofDGzAMBgNVHRMEBTADAQH/MA0G
  179. CSqGSIb3DQEBCwUAA4ICAQCJxiHaGZTgbu3jG/fhE6Wh0r/RPgAIAFqr9xkvLJiW
  180. 1ClnwAzs15alm8bcDFFAFbwm27T4HiKbmTLVmQ5aGWCbe+P7gY+6Xzx3qiDJcVxH
  181. Uebg54+1VRjCShKlgemqHNkZInE3EkGcigMlPCbuX7tGvojR5LofyMZFY7lMQ0t/
  182. hFXE1/CMLTvnhE6C4FC/QFTgkoPcHbUYo7ve/a7uWlYaf9xmJj4dcABAPapnFIgf
  183. Id3aF7U2ElwT2UWkpxtSQehqromPWPS6uIbRrgwYgqmagm7zbKrW0eJAz1nS9RAR
  184. P8Bg8J2SgPMvmSugkrAxV8e/voQqnMSfkJKN9dxoJ3q5hO7A93QJ9x2d5Tu5eGsu
  185. Zsg1sAQrKorA8/QqELo0qJ8upkmoTSH6uzG9wNohnb+QoOt2OVnqPmxVRqFhmlGX
  186. uN2ccchloxrWfN0WirJD7It/nlNZdYs6cKz49eo42kW+0OXEfmbsfSoLZ6pR1NRs
  187. MzIpsLflHphFIJmEfnfCX6hAVm3dsCkgjEYO6CcJjhpdgSNznpEaWL/biAtah6Z4
  188. oXt7+EDvlCnzlQmwtr44dNsOHRBVxrjYD6wus8M7x2uWmihRHbDQUbDz8oySKhAe
  189. HAs5AOY94IhPhItYb5WZya43m38UyYE5RIWaFZy38EDjvVYAdnA1gGeftaLdAFln
  190. Wg==
  191. -----END CERTIFICATE-----'\'') ON DUPLICATE KEY UPDATE value=VALUES(value); SET SQL_LOG_BIN = 1;'
  192. ERROR 1146 (42S02) at line 1: Table 'mysql.inventory' doesn't exist
  193. WARNING: no verification of server certificate will be done. Use --ssl-mode=VERIFY_CA or VERIFY_IDENTITY.
  194. + /bin/sh -c ' echo MySQL init complete'
  195. MySQL init complete
  196. + [[ echo MySQL init complete == '' ]]
  197. + '[' 1 == 0 ']'
  198. + '[' '!' -f /home/mysql/agent/etc/bootstrap.properties ']'
  199. + echo agent-host-id=g3n1
  200. + echo http-connect-timeout-ms=30000
  201. + echo http-socket-timeout-ms=60000
  202. + echo mysql
  203. + sudo -u mysql -E /home/mysql/agent/bin/agent.sh --uuid=2296362c-90a5-5fd2-da4c-60f8874921da --agent-user=agent --url=https://172.17.0.1:18443/ -f
  204. Agent user password: Agent configuration updated
  205. + '[' 0 == 0 ']'
  206. + echo -e 'mysql\nmysql\nmysql\n'
  207. + sudo -u mysql -E /home/mysql/agent/bin/agent.sh --create-connection --admin-user=root --host=localhost --port=3306 --mysql-identity-source=host_plus_datadir
  208. [1130] null, message from server: "Host '127.0.0.1' is not allowed to connect to this MySQL server"
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!