API tools faq
paste
Advertisement
zzdhxu

Untitled

zzdhxu
Jun 19th, 2018
387
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.57 KB | None | 0 0
raw download clone embed print report
  1. Checking API credentials.
  2. Enter the name of your Cloud project: Listing Cloud SQL instances.
  3. 1: device-supported-versions [MYSQL_5_7] (<instance name>)
  4. Please enter the number of the instance you want to use [1]: Please enter MySQL username [root]: Please enter MySQL password: Jun 19, 2018 3:35:08 PM com.google.cloud.sql.mysql.SocketFactory connect
  5. INFO: Connecting to Cloud SQL instance [<instance name>].
  6. Jun 19, 2018 3:35:08 PM com.google.cloud.sql.core.SslSocketFactory getInstance
  7. INFO: First Cloud SQL connection, generating RSA key pair.
  8. Jun 19, 2018 3:35:08 PM com.google.api.client.googleapis.auth.oauth2.OAuth2Utils runningOnComputeEngine
  9. WARNING: Failed to detect whether we are running on Google Compute Engine.
  10. java.net.SocketException: Network is unreachable: connect
  11. at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
  12. at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
  13. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  14. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  15. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  16. at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
  17. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  18. at java.net.Socket.connect(Socket.java:589)
  19. at sun.net.NetworkClient.doConnect(NetworkClient.java:175)
  20. at sun.net.www.http.HttpClient.openServer(HttpClient.java:463)
  21. at sun.net.www.http.HttpClient.openServer(HttpClient.java:558)
  22. at sun.net.www.http.HttpClient.<init>(HttpClient.java:242)
  23. at sun.net.www.http.HttpClient.New(HttpClient.java:339)
  24. at sun.net.www.http.HttpClient.New(HttpClient.java:357)
  25. at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:1220)
  26. at sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1156)
  27. at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:1050)
  28. at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:984)
  29. at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:104)
  30. at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:981)
  31. at com.google.api.client.googleapis.auth.oauth2.OAuth2Utils.runningOnComputeEngine(OAuth2Utils.java:86)
  32. at com.google.api.client.googleapis.auth.oauth2.DefaultCredentialProvider.detectEnvironment(DefaultCredentialProvider.java:183)
  33. at com.google.api.client.googleapis.auth.oauth2.DefaultCredentialProvider.getDefaultCredentialUnsynchronized(DefaultCredentialProvider.java:110)
  34. at com.google.api.client.googleapis.auth.oauth2.DefaultCredentialProvider.getDefaultCredential(DefaultCredentialProvider.java:91)
  35. at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.getApplicationDefault(GoogleCredential.java:213)
  36. at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.getApplicationDefault(GoogleCredential.java:191)
  37. at com.google.cloud.sql.core.SslSocketFactory$ApplicationDefaultCredentialFactory.create(SslSocketFactory.java:556)
  38. at com.google.cloud.sql.core.SslSocketFactory.getInstance(SslSocketFactory.java:144)
  39. at com.google.cloud.sql.mysql.SocketFactory.connect(SocketFactory.java:56)
  40. at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:298)
  41. at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
  42. at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2286)
  43. at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2085)
  44. at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795)
  45. at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
  46. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  47. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  48. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  49. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  50. at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
  51. at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
  52. at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327)
  53. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  54. at java.sql.DriverManager.getConnection(DriverManager.java:247)
  55. at GettingStarted2.askForDatabaseCredentials(GettingStarted2.java:183)
  56. at GettingStarted2.run(GettingStarted2.java:81)
  57. at GettingStarted2.main(GettingStarted2.java:398)
  58.  
  59. Jun 19, 2018 3:35:08 PM com.google.api.client.googleapis.auth.oauth2.OAuth2Utils runningOnComputeEngine
  60. WARNING: Failed to detect whether we are running on Google Compute Engine.
  61. java.net.SocketException: Network is unreachable: connect
  62. at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
  63. at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
  64. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  65. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  66. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  67. at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
  68. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  69. at java.net.Socket.connect(Socket.java:589)
  70. at sun.net.NetworkClient.doConnect(NetworkClient.java:175)
  71. at sun.net.www.http.HttpClient.openServer(HttpClient.java:463)
  72. at sun.net.www.http.HttpClient.openServer(HttpClient.java:558)
  73. at sun.net.www.http.HttpClient.<init>(HttpClient.java:242)
  74. at sun.net.www.http.HttpClient.New(HttpClient.java:339)
  75. at sun.net.www.http.HttpClient.New(HttpClient.java:357)
  76. at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:1220)
  77. at sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1156)
  78. at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:1050)
  79. at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:984)
  80. at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:104)
  81. at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:981)
  82. at com.google.api.client.googleapis.auth.oauth2.OAuth2Utils.runningOnComputeEngine(OAuth2Utils.java:86)
  83. at com.google.api.client.googleapis.auth.oauth2.DefaultCredentialProvider.detectEnvironment(DefaultCredentialProvider.java:183)
  84. at com.google.api.client.googleapis.auth.oauth2.DefaultCredentialProvider.getDefaultCredentialUnsynchronized(DefaultCredentialProvider.java:110)
  85. at com.google.api.client.googleapis.auth.oauth2.DefaultCredentialProvider.getDefaultCredential(DefaultCredentialProvider.java:91)
  86. at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.getApplicationDefault(GoogleCredential.java:213)
  87. at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.getApplicationDefault(GoogleCredential.java:191)
  88. at com.google.cloud.sql.core.SslSocketFactory$ApplicationDefaultCredentialFactory.create(SslSocketFactory.java:556)
  89. at com.google.cloud.sql.core.SslSocketFactory.getInstance(SslSocketFactory.java:144)
  90. at com.google.cloud.sql.mysql.SocketFactory.connect(SocketFactory.java:56)
  91. at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:298)
  92. at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
  93. at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2286)
  94. at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2085)
  95. at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795)
  96. at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
  97. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  98. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  99. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  100. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  101. at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
  102. at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
  103. at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327)
  104. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  105. at java.sql.DriverManager.getConnection(DriverManager.java:247)
  106. at GettingStarted2.askForDatabaseCredentials(GettingStarted2.java:183)
  107. at GettingStarted2.run(GettingStarted2.java:81)
  108. at GettingStarted2.main(GettingStarted2.java:398)
  109.  
  110. Jun 19, 2018 3:35:08 PM com.google.api.client.googleapis.auth.oauth2.OAuth2Utils runningOnComputeEngine
  111. WARNING: Failed to detect whether we are running on Google Compute Engine.
  112. java.net.SocketException: Network is unreachable: connect
  113. at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
  114. at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
  115. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  116. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  117. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  118. at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
  119. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  120. at java.net.Socket.connect(Socket.java:589)
  121. at sun.net.NetworkClient.doConnect(NetworkClient.java:175)
  122. at sun.net.www.http.HttpClient.openServer(HttpClient.java:463)
  123. at sun.net.www.http.HttpClient.openServer(HttpClient.java:558)
  124. at sun.net.www.http.HttpClient.<init>(HttpClient.java:242)
  125. at sun.net.www.http.HttpClient.New(HttpClient.java:339)
  126. at sun.net.www.http.HttpClient.New(HttpClient.java:357)
  127. at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:1220)
  128. at sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1156)
  129. at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:1050)
  130. at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:984)
  131. at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:104)
  132. at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:981)
  133. at com.google.api.client.googleapis.auth.oauth2.OAuth2Utils.runningOnComputeEngine(OAuth2Utils.java:86)
  134. at com.google.api.client.googleapis.auth.oauth2.DefaultCredentialProvider.detectEnvironment(DefaultCredentialProvider.java:183)
  135. at com.google.api.client.googleapis.auth.oauth2.DefaultCredentialProvider.getDefaultCredentialUnsynchronized(DefaultCredentialProvider.java:110)
  136. at com.google.api.client.googleapis.auth.oauth2.DefaultCredentialProvider.getDefaultCredential(DefaultCredentialProvider.java:91)
  137. at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.getApplicationDefault(GoogleCredential.java:213)
  138. at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.getApplicationDefault(GoogleCredential.java:191)
  139. at com.google.cloud.sql.core.SslSocketFactory$ApplicationDefaultCredentialFactory.create(SslSocketFactory.java:556)
  140. at com.google.cloud.sql.core.SslSocketFactory.getInstance(SslSocketFactory.java:144)
  141. at com.google.cloud.sql.mysql.SocketFactory.connect(SocketFactory.java:56)
  142. at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:298)
  143. at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
  144. at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2286)
  145. at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2085)
  146. at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795)
  147. at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
  148. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  149. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  150. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  151. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  152. at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
  153. at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
  154. at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327)
  155. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  156. at java.sql.DriverManager.getConnection(DriverManager.java:247)
  157. at GettingStarted2.askForDatabaseCredentials(GettingStarted2.java:183)
  158. at GettingStarted2.run(GettingStarted2.java:81)
  159. at GettingStarted2.main(GettingStarted2.java:398)
  160.  
  161. Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
  162. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  163. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  164. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  165. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  166. at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
  167. at com.mysql.jdbc.Util.getInstance(Util.java:387)
  168. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:917)
  169. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:896)
  170. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:885)
  171. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
  172. at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2332)
  173. at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2085)
  174. at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795)
  175. at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
  176. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  177. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  178. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  179. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  180. at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
  181. at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
  182. at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327)
  183. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  184. at java.sql.DriverManager.getConnection(DriverManager.java:247)
  185. at GettingStarted2.askForDatabaseCredentials(GettingStarted2.java:183)
  186. at GettingStarted2.run(GettingStarted2.java:81)
  187. at GettingStarted2.main(GettingStarted2.java:398)
  188. Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
  189. at com.google.cloud.sql.core.SslSocketFactory$ApplicationDefaultCredentialFactory.create(SslSocketFactory.java:558)
  190. at com.google.cloud.sql.core.SslSocketFactory.getInstance(SslSocketFactory.java:144)
  191. at com.google.cloud.sql.mysql.SocketFactory.connect(SocketFactory.java:56)
  192. at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:298)
  193. at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
  194. at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2286)
  195. ... 15 more
  196. Caused by: java.io.IOException: The Application Default Credentials are not available. They are available if running on Google App Engine, Google Compute Engine, or Google Cloud Shell. Otherwise, the environment variable GOOGLE_APPLICATION_CREDENTIALS must be defined pointing to a file defining the credentials. See https://developers.google.com/accounts/docs/application-default-credentials for more information.
  197. at com.google.api.client.googleapis.auth.oauth2.DefaultCredentialProvider.getDefaultCredential(DefaultCredentialProvider.java:98)
  198. at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.getApplicationDefault(GoogleCredential.java:213)
  199. at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.getApplicationDefault(GoogleCredential.java:191)
  200. at com.google.cloud.sql.core.SslSocketFactory$ApplicationDefaultCredentialFactory.create(SslSocketFactory.java:556)
  201. ... 20 more
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!