API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 25th, 2018
336
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 30.02 KB | None | 0 0
raw download clone embed print report
  1. +------------------+
  2. 4 rows in set (0.00 sec)
  3.  
  4. mysql> quit
  5. Bye
  6. (base) lols-MacBook-Pro:lottery socrates$ mysql -u root -p
  7. Enter password:
  8. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
  9. (base) lols-MacBook-Pro:lottery socrates$ sails lift
  10.  
  11. info: Starting app...
  12.  
  13. info: Initializing hook... (`api/hooks/custom`)
  14. info: Initializing `apianalytics` hook... (requests to monitored routes will be logged!)
  15. info: ·• Auto-migrating... (alter)
  16. info: Hold tight, this could take a moment.
  17. (node:90510) [DEP0095] DeprecationWarning: timers.enroll() is deprecated. Please use setTimeout instead.
  18. (node:90510) [DEP0096] DeprecationWarning: timers.unenroll() is deprecated. Please use clearTimeout instead.
  19.  
  20. When attempting to perform the `alter` auto-migration strategy on model `play`, Sails encountered an unexpected error when performing the `drop` step. This could have happened for a number of different reasons: be it because your database went offline, because of a db permission issue, because of some database-specific edge case, or (more rarely) it could even be due to some kind of bug in this adapter.
  21.  
  22. Error details:
  23. ```
  24. { error:
  25. { Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
  26. at Handshake.Sequence._packetToError (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/sequences/Sequence.js:52:14)
  27. at Handshake.ErrorPacket (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/sequences/Handshake.js:130:18)
  28. at Protocol._parsePacket (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Protocol.js:279:23)
  29. at Parser.write (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Parser.js:76:12)
  30. at Protocol.write (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Protocol.js:39:16)
  31. at Socket.<anonymous> (/Users/socrates/Projects/lottery/node_modules/mysql/lib/Connection.js:103:28)
  32. at Socket.emit (events.js:182:13)
  33. at Socket.EventEmitter.emit (domain.js:442:20)
  34. at addChunk (_stream_readable.js:283:12)
  35. at readableAddChunk (_stream_readable.js:264:11)
  36. at Socket.Readable.push (_stream_readable.js:219:10)
  37. at TCP.onread (net.js:639:20)
  38. --------------------
  39. at Protocol._enqueue (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Protocol.js:145:48)
  40. at Protocol.handshake (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Protocol.js:52:23)
  41. at PoolConnection.connect (/Users/socrates/Projects/lottery/node_modules/mysql/lib/Connection.js:130:18)
  42. at Pool.getConnection (/Users/socrates/Projects/lottery/node_modules/mysql/lib/Pool.js:48:16)
  43. at Object.getConnection (/Users/socrates/Projects/lottery/node_modules/machinepack-mysql/lib/get-connection.js:78:25)
  44. at wrapper (/Users/socrates/Projects/lottery/node_modules/@sailshq/lodash/lib/index.js:3275:19)
  45. at Deferred.parley.retry [as _handleExec] (/Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1076:19)
  46. at Deferred.exec (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:286:10)
  47. at Deferred.switch (/Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1469:16)
  48. at spawnConnection (/Users/socrates/Projects/lottery/node_modules/sails-mysql/helpers/private/connection/spawn-connection.js:29:10)
  49. at Object.spawnOrLeaseConnection (/Users/socrates/Projects/lottery/node_modules/sails-mysql/helpers/private/connection/spawn-or-lease-connection.js:23:3)
  50. at Object.drop (/Users/socrates/Projects/lottery/node_modules/sails-mysql/helpers/drop.js:71:24)
  51. at wrapper (/Users/socrates/Projects/lottery/node_modules/@sailshq/lodash/lib/index.js:3275:19)
  52. at Deferred.parley.retry [as _handleExec] (/Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1076:19)
  53. at Deferred.exec (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:286:10)
  54. at Deferred.switch (/Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1469:16)
  55. at Object.drop (/Users/socrates/Projects/lottery/node_modules/sails-mysql/lib/adapter.js:434:16)
  56. at findCallback (/Users/socrates/Projects/lottery/node_modules/waterline-utils/lib/auto-migrations/private/run-alter-strategy/index.js:132:17)
  57. at proceedToFinalAfterExecLC (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:1149:14)
  58. at proceedToInterceptsAndChecks (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:909:12)
  59. at proceedToAfterExecSpinlocks (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:841:10)
  60. at /Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:303:7
  61. at _afterFetchingRecords (/Users/socrates/Projects/lottery/node_modules/waterline/lib/waterline/methods/find.js:260:20)
  62. at _afterGettingPopulatedPhysicalRecords (/Users/socrates/Projects/lottery/node_modules/waterline/lib/waterline/utils/query/help-find.js:584:23)
  63. at /Users/socrates/Projects/lottery/node_modules/waterline/lib/waterline/utils/query/help-find.js:148:18
  64. at Object.error (/Users/socrates/Projects/lottery/node_modules/sails-mysql/lib/adapter.js:187:18)
  65. at /Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1505:43
  66. at proceedToFinalAfterExecLC (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:1149:14)
  67. code: 'ER_NOT_SUPPORTED_AUTH_MODE',
  68. errno: 1251,
  69. sqlMessage:
  70. 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',
  71. sqlState: '08004',
  72. fatal: true },
  73. meta:
  74. { host: 'localhost',
  75. port: 3306,
  76. schema: true,
  77. adapter: 'sails-mysql',
  78. url: 'mysql://root:0243570576@localhost:3306/ussd',
  79. identity: 'default' } }
  80. ```
  81.  
  82. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  83. Some development data was recovered (see `.tmp/automigration.play.9187.log`). Any existing `play` records were deleted, but your data from OTHER models (including any relationships tracked in foreign keys and join tables) might still be intact. If you care about recovering any of that data, be sure to back it up now before you continue.
  84.  
  85. The best way to proceed from here is to clear out all of your old development data and start fresh; allowing Sails to generate new tables/collections(s) to reflect your app's models. (In other words, to DELETE ALL EXISTING DATA stored in models.)
  86.  
  87. To do that, re-lift your app using the `drop` strategy:
  88. ```
  89. sails lift --drop
  90. ```
  91.  
  92. After doing that once, you should be able to go about your business as usual.
  93. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  94.  
  95. For more about auto-migrations, visit:
  96. https://sailsjs.com/docs/concepts/models-and-orm/model-settings#?migrate
  97.  
  98.  
  99. On Tue Dec 25 2018 09:13:07 GMT+0000 (Greenwich Mean Time), Sails attempted to auto-migrate
  100. using the `alter` strategy, but was unable to transform all of your
  101. existing development data automatically. This temporary file was created
  102. for your convenience, as a way of holding on to the unmigrated records that
  103. were originally stored in the `play` model.
  104. (Otherwise, this data would have been lost forever.)
  105.  
  106. ================================
  107. Recovered data (`play`):
  108. ================================
  109.  
  110. []
  111.  
  112.  
  113. --
  114. For help with auto-migrations, visit:
  115. http://sailsjs.com/docs/concepts/models-and-orm/model-settings#?migrate
  116.  
  117. For questions, additional resources, or to talk to a human, visit:
  118. http://sailsjs.com/support
  119.  
  120.  
  121.  
  122. When attempting to perform the `alter` auto-migration strategy on model `user`, Sails encountered an unexpected error when performing the `drop` step. This could have happened for a number of different reasons: be it because your database went offline, because of a db permission issue, because of some database-specific edge case, or (more rarely) it could even be due to some kind of bug in this adapter.
  123.  
  124. Error details:
  125. ```
  126. { error:
  127. { Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
  128. at Handshake.Sequence._packetToError (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/sequences/Sequence.js:52:14)
  129. at Handshake.ErrorPacket (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/sequences/Handshake.js:130:18)
  130. at Protocol._parsePacket (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Protocol.js:279:23)
  131. at Parser.write (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Parser.js:76:12)
  132. at Protocol.write (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Protocol.js:39:16)
  133. at Socket.<anonymous> (/Users/socrates/Projects/lottery/node_modules/mysql/lib/Connection.js:103:28)
  134. at Socket.emit (events.js:182:13)
  135. at Socket.EventEmitter.emit (domain.js:442:20)
  136. at addChunk (_stream_readable.js:283:12)
  137. at readableAddChunk (_stream_readable.js:264:11)
  138. at Socket.Readable.push (_stream_readable.js:219:10)
  139. at TCP.onread (net.js:639:20)
  140. --------------------
  141. at Protocol._enqueue (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Protocol.js:145:48)
  142. at Protocol.handshake (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Protocol.js:52:23)
  143. at PoolConnection.connect (/Users/socrates/Projects/lottery/node_modules/mysql/lib/Connection.js:130:18)
  144. at Pool.getConnection (/Users/socrates/Projects/lottery/node_modules/mysql/lib/Pool.js:48:16)
  145. at Object.getConnection (/Users/socrates/Projects/lottery/node_modules/machinepack-mysql/lib/get-connection.js:78:25)
  146. at wrapper (/Users/socrates/Projects/lottery/node_modules/@sailshq/lodash/lib/index.js:3275:19)
  147. at Deferred.parley.retry [as _handleExec] (/Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1076:19)
  148. at Deferred.exec (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:286:10)
  149. at Deferred.switch (/Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1469:16)
  150. at spawnConnection (/Users/socrates/Projects/lottery/node_modules/sails-mysql/helpers/private/connection/spawn-connection.js:29:10)
  151. at Object.spawnOrLeaseConnection (/Users/socrates/Projects/lottery/node_modules/sails-mysql/helpers/private/connection/spawn-or-lease-connection.js:23:3)
  152. at Object.drop (/Users/socrates/Projects/lottery/node_modules/sails-mysql/helpers/drop.js:71:24)
  153. at wrapper (/Users/socrates/Projects/lottery/node_modules/@sailshq/lodash/lib/index.js:3275:19)
  154. at Deferred.parley.retry [as _handleExec] (/Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1076:19)
  155. at Deferred.exec (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:286:10)
  156. at Deferred.switch (/Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1469:16)
  157. at Object.drop (/Users/socrates/Projects/lottery/node_modules/sails-mysql/lib/adapter.js:434:16)
  158. at findCallback (/Users/socrates/Projects/lottery/node_modules/waterline-utils/lib/auto-migrations/private/run-alter-strategy/index.js:132:17)
  159. at proceedToFinalAfterExecLC (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:1149:14)
  160. at proceedToInterceptsAndChecks (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:909:12)
  161. at proceedToAfterExecSpinlocks (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:841:10)
  162. at /Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:303:7
  163. at _afterFetchingRecords (/Users/socrates/Projects/lottery/node_modules/waterline/lib/waterline/methods/find.js:260:20)
  164. at _afterGettingPopulatedPhysicalRecords (/Users/socrates/Projects/lottery/node_modules/waterline/lib/waterline/utils/query/help-find.js:584:23)
  165. at /Users/socrates/Projects/lottery/node_modules/waterline/lib/waterline/utils/query/help-find.js:148:18
  166. at Object.error (/Users/socrates/Projects/lottery/node_modules/sails-mysql/lib/adapter.js:187:18)
  167. at /Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1505:43
  168. at proceedToFinalAfterExecLC (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:1149:14)
  169. code: 'ER_NOT_SUPPORTED_AUTH_MODE',
  170. errno: 1251,
  171. sqlMessage:
  172. 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',
  173. sqlState: '08004',
  174. fatal: true },
  175. meta:
  176. { host: 'localhost',
  177. port: 3306,
  178. schema: true,
  179. adapter: 'sails-mysql',
  180. url: 'mysql://root:0243570576@localhost:3306/ussd',
  181. identity: 'default' } }
  182. ```
  183.  
  184. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  185. Some development data was recovered (see `.tmp/automigration.user.9187.log`). Any existing `user` records were deleted, but your data from OTHER models (including any relationships tracked in foreign keys and join tables) might still be intact. If you care about recovering any of that data, be sure to back it up now before you continue.
  186.  
  187. The best way to proceed from here is to clear out all of your old development data and start fresh; allowing Sails to generate new tables/collections(s) to reflect your app's models. (In other words, to DELETE ALL EXISTING DATA stored in models.)
  188.  
  189. To do that, re-lift your app using the `drop` strategy:
  190. ```
  191. sails lift --drop
  192. ```
  193.  
  194. After doing that once, you should be able to go about your business as usual.
  195. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  196.  
  197. For more about auto-migrations, visit:
  198. https://sailsjs.com/docs/concepts/models-and-orm/model-settings#?migrate
  199.  
  200.  
  201. On Tue Dec 25 2018 09:13:07 GMT+0000 (Greenwich Mean Time), Sails attempted to auto-migrate
  202. using the `alter` strategy, but was unable to transform all of your
  203. existing development data automatically. This temporary file was created
  204. for your convenience, as a way of holding on to the unmigrated records that
  205. were originally stored in the `user` model.
  206. (Otherwise, this data would have been lost forever.)
  207.  
  208. ================================
  209. Recovered data (`user`):
  210. ================================
  211.  
  212. []
  213.  
  214.  
  215. --
  216. For help with auto-migrations, visit:
  217. http://sailsjs.com/docs/concepts/models-and-orm/model-settings#?migrate
  218.  
  219. For questions, additional resources, or to talk to a human, visit:
  220. http://sailsjs.com/support
  221.  
  222.  
  223.  
  224. When attempting to perform the `alter` auto-migration strategy on model `ussd_sessions`, Sails encountered an unexpected error when performing the `drop` step. This could have happened for a number of different reasons: be it because your database went offline, because of a db permission issue, because of some database-specific edge case, or (more rarely) it could even be due to some kind of bug in this adapter.
  225.  
  226. Error details:
  227. ```
  228. { error:
  229. { Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
  230. at Handshake.Sequence._packetToError (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/sequences/Sequence.js:52:14)
  231. at Handshake.ErrorPacket (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/sequences/Handshake.js:130:18)
  232. at Protocol._parsePacket (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Protocol.js:279:23)
  233. at Parser.write (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Parser.js:76:12)
  234. at Protocol.write (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Protocol.js:39:16)
  235. at Socket.<anonymous> (/Users/socrates/Projects/lottery/node_modules/mysql/lib/Connection.js:103:28)
  236. at Socket.emit (events.js:182:13)
  237. at Socket.EventEmitter.emit (domain.js:442:20)
  238. at addChunk (_stream_readable.js:283:12)
  239. at readableAddChunk (_stream_readable.js:264:11)
  240. at Socket.Readable.push (_stream_readable.js:219:10)
  241. at TCP.onread (net.js:639:20)
  242. --------------------
  243. at Protocol._enqueue (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Protocol.js:145:48)
  244. at Protocol.handshake (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Protocol.js:52:23)
  245. at PoolConnection.connect (/Users/socrates/Projects/lottery/node_modules/mysql/lib/Connection.js:130:18)
  246. at Pool.getConnection (/Users/socrates/Projects/lottery/node_modules/mysql/lib/Pool.js:48:16)
  247. at Object.getConnection (/Users/socrates/Projects/lottery/node_modules/machinepack-mysql/lib/get-connection.js:78:25)
  248. at wrapper (/Users/socrates/Projects/lottery/node_modules/@sailshq/lodash/lib/index.js:3275:19)
  249. at Deferred.parley.retry [as _handleExec] (/Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1076:19)
  250. at Deferred.exec (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:286:10)
  251. at Deferred.switch (/Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1469:16)
  252. at spawnConnection (/Users/socrates/Projects/lottery/node_modules/sails-mysql/helpers/private/connection/spawn-connection.js:29:10)
  253. at Object.spawnOrLeaseConnection (/Users/socrates/Projects/lottery/node_modules/sails-mysql/helpers/private/connection/spawn-or-lease-connection.js:23:3)
  254. at Object.drop (/Users/socrates/Projects/lottery/node_modules/sails-mysql/helpers/drop.js:71:24)
  255. at wrapper (/Users/socrates/Projects/lottery/node_modules/@sailshq/lodash/lib/index.js:3275:19)
  256. at Deferred.parley.retry [as _handleExec] (/Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1076:19)
  257. at Deferred.exec (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:286:10)
  258. at Deferred.switch (/Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1469:16)
  259. at Object.drop (/Users/socrates/Projects/lottery/node_modules/sails-mysql/lib/adapter.js:434:16)
  260. at findCallback (/Users/socrates/Projects/lottery/node_modules/waterline-utils/lib/auto-migrations/private/run-alter-strategy/index.js:132:17)
  261. at proceedToFinalAfterExecLC (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:1149:14)
  262. at proceedToInterceptsAndChecks (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:909:12)
  263. at proceedToAfterExecSpinlocks (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:841:10)
  264. at /Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:303:7
  265. at _afterFetchingRecords (/Users/socrates/Projects/lottery/node_modules/waterline/lib/waterline/methods/find.js:260:20)
  266. at _afterGettingPopulatedPhysicalRecords (/Users/socrates/Projects/lottery/node_modules/waterline/lib/waterline/utils/query/help-find.js:584:23)
  267. at /Users/socrates/Projects/lottery/node_modules/waterline/lib/waterline/utils/query/help-find.js:148:18
  268. at Object.error (/Users/socrates/Projects/lottery/node_modules/sails-mysql/lib/adapter.js:187:18)
  269. at /Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1505:43
  270. at proceedToFinalAfterExecLC (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:1149:14)
  271. code: 'ER_NOT_SUPPORTED_AUTH_MODE',
  272. errno: 1251,
  273. sqlMessage:
  274. 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',
  275. sqlState: '08004',
  276. fatal: true },
  277. meta:
  278. { host: 'localhost',
  279. port: 3306,
  280. schema: true,
  281. adapter: 'sails-mysql',
  282. url: 'mysql://root:0243570576@localhost:3306/ussd',
  283. identity: 'default' } }
  284. ```
  285.  
  286. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  287. Some development data was recovered (see `.tmp/automigration.ussd_sessions.9187.log`). Any existing `ussd_sessions` records were deleted, but your data from OTHER models (including any relationships tracked in foreign keys and join tables) might still be intact. If you care about recovering any of that data, be sure to back it up now before you continue.
  288.  
  289. The best way to proceed from here is to clear out all of your old development data and start fresh; allowing Sails to generate new tables/collections(s) to reflect your app's models. (In other words, to DELETE ALL EXISTING DATA stored in models.)
  290.  
  291. To do that, re-lift your app using the `drop` strategy:
  292. ```
  293. sails lift --drop
  294. ```
  295.  
  296. After doing that once, you should be able to go about your business as usual.
  297. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  298.  
  299. For more about auto-migrations, visit:
  300. https://sailsjs.com/docs/concepts/models-and-orm/model-settings#?migrate
  301.  
  302.  
  303. On Tue Dec 25 2018 09:13:07 GMT+0000 (Greenwich Mean Time), Sails attempted to auto-migrate
  304. using the `alter` strategy, but was unable to transform all of your
  305. existing development data automatically. This temporary file was created
  306. for your convenience, as a way of holding on to the unmigrated records that
  307. were originally stored in the `ussd_sessions` model.
  308. (Otherwise, this data would have been lost forever.)
  309.  
  310. ================================
  311. Recovered data (`ussd_sessions`):
  312. ================================
  313.  
  314. []
  315.  
  316.  
  317. --
  318. For help with auto-migrations, visit:
  319. http://sailsjs.com/docs/concepts/models-and-orm/model-settings#?migrate
  320.  
  321. For questions, additional resources, or to talk to a human, visit:
  322. http://sailsjs.com/support
  323.  
  324.  
  325.  
  326. When attempting to perform the `alter` auto-migration strategy on model `archive`, Sails encountered an unexpected error when performing the `drop` step. This could have happened for a number of different reasons: be it because your database went offline, because of a db permission issue, because of some database-specific edge case, or (more rarely) it could even be due to some kind of bug in this adapter.
  327.  
  328. Error details:
  329. ```
  330. { error:
  331. { Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
  332. at Handshake.Sequence._packetToError (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/sequences/Sequence.js:52:14)
  333. at Handshake.ErrorPacket (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/sequences/Handshake.js:130:18)
  334. at Protocol._parsePacket (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Protocol.js:279:23)
  335. at Parser.write (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Parser.js:76:12)
  336. at Protocol.write (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Protocol.js:39:16)
  337. at Socket.<anonymous> (/Users/socrates/Projects/lottery/node_modules/mysql/lib/Connection.js:103:28)
  338. at Socket.emit (events.js:182:13)
  339. at Socket.EventEmitter.emit (domain.js:442:20)
  340. at addChunk (_stream_readable.js:283:12)
  341. at readableAddChunk (_stream_readable.js:264:11)
  342. at Socket.Readable.push (_stream_readable.js:219:10)
  343. at TCP.onread (net.js:639:20)
  344. --------------------
  345. at Protocol._enqueue (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Protocol.js:145:48)
  346. at Protocol.handshake (/Users/socrates/Projects/lottery/node_modules/mysql/lib/protocol/Protocol.js:52:23)
  347. at PoolConnection.connect (/Users/socrates/Projects/lottery/node_modules/mysql/lib/Connection.js:130:18)
  348. at Pool.getConnection (/Users/socrates/Projects/lottery/node_modules/mysql/lib/Pool.js:48:16)
  349. at Object.getConnection (/Users/socrates/Projects/lottery/node_modules/machinepack-mysql/lib/get-connection.js:78:25)
  350. at wrapper (/Users/socrates/Projects/lottery/node_modules/@sailshq/lodash/lib/index.js:3275:19)
  351. at Deferred.parley.retry [as _handleExec] (/Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1076:19)
  352. at Deferred.exec (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:286:10)
  353. at Deferred.switch (/Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1469:16)
  354. at spawnConnection (/Users/socrates/Projects/lottery/node_modules/sails-mysql/helpers/private/connection/spawn-connection.js:29:10)
  355. at Object.spawnOrLeaseConnection (/Users/socrates/Projects/lottery/node_modules/sails-mysql/helpers/private/connection/spawn-or-lease-connection.js:23:3)
  356. at Object.drop (/Users/socrates/Projects/lottery/node_modules/sails-mysql/helpers/drop.js:71:24)
  357. at wrapper (/Users/socrates/Projects/lottery/node_modules/@sailshq/lodash/lib/index.js:3275:19)
  358. at Deferred.parley.retry [as _handleExec] (/Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1076:19)
  359. at Deferred.exec (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:286:10)
  360. at Deferred.switch (/Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1469:16)
  361. at Object.drop (/Users/socrates/Projects/lottery/node_modules/sails-mysql/lib/adapter.js:434:16)
  362. at findCallback (/Users/socrates/Projects/lottery/node_modules/waterline-utils/lib/auto-migrations/private/run-alter-strategy/index.js:132:17)
  363. at proceedToFinalAfterExecLC (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:1149:14)
  364. at proceedToInterceptsAndChecks (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:909:12)
  365. at proceedToAfterExecSpinlocks (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:841:10)
  366. at /Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:303:7
  367. at _afterFetchingRecords (/Users/socrates/Projects/lottery/node_modules/waterline/lib/waterline/methods/find.js:260:20)
  368. at _afterGettingPopulatedPhysicalRecords (/Users/socrates/Projects/lottery/node_modules/waterline/lib/waterline/utils/query/help-find.js:584:23)
  369. at /Users/socrates/Projects/lottery/node_modules/waterline/lib/waterline/utils/query/help-find.js:148:18
  370. at Object.error (/Users/socrates/Projects/lottery/node_modules/sails-mysql/lib/adapter.js:187:18)
  371. at /Users/socrates/Projects/lottery/node_modules/machine/lib/private/help-build-machine.js:1505:43
  372. at proceedToFinalAfterExecLC (/Users/socrates/Projects/lottery/node_modules/parley/lib/private/Deferred.js:1149:14)
  373. code: 'ER_NOT_SUPPORTED_AUTH_MODE',
  374. errno: 1251,
  375. sqlMessage:
  376. 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',
  377. sqlState: '08004',
  378. fatal: true },
  379. meta:
  380. { host: 'localhost',
  381. port: 3306,
  382. schema: true,
  383. adapter: 'sails-mysql',
  384. url: 'mysql://root:0243570576@localhost:3306/ussd',
  385. identity: 'default' } }
  386. ```
  387.  
  388. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  389. Some development data was recovered (see `.tmp/automigration.archive.9187.log`). Any existing `archive` records were deleted, but your data from OTHER models (including any relationships tracked in foreign keys and join tables) might still be intact. If you care about recovering any of that data, be sure to back it up now before you continue.
  390.  
  391. The best way to proceed from here is to clear out all of your old development data and start fresh; allowing Sails to generate new tables/collections(s) to reflect your app's models. (In other words, to DELETE ALL EXISTING DATA stored in models.)
  392.  
  393. To do that, re-lift your app using the `drop` strategy:
  394. ```
  395. sails lift --drop
  396. ```
  397.  
  398. After doing that once, you should be able to go about your business as usual.
  399. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  400.  
  401. For more about auto-migrations, visit:
  402. https://sailsjs.com/docs/concepts/models-and-orm/model-settings#?migrate
  403.  
  404.  
  405. On Tue Dec 25 2018 09:13:07 GMT+0000 (Greenwich Mean Time), Sails attempted to auto-migrate
  406. using the `alter` strategy, but was unable to transform all of your
  407. existing development data automatically. This temporary file was created
  408. for your convenience, as a way of holding on to the unmigrated records that
  409. were originally stored in the `archive` model.
  410. (Otherwise, this data would have been lost forever.)
  411.  
  412. ================================
  413. Recovered data (`archive`):
  414. ================================
  415.  
  416. []
  417.  
  418.  
  419. --
  420. For help with auto-migrations, visit:
  421. http://sailsjs.com/docs/concepts/models-and-orm/model-settings#?migrate
  422.  
  423. For questions, additional resources, or to talk to a human, visit:
  424. http://sailsjs.com/support
  425.  
  426.  
  427. error: A hook (`orm`) failed to load!
  428. error:
  429. error: Error: Automigrations failed. (See logs above for help, and a summary of what went wrong.)
  430. at Timeout._onTimeout (/Users/socrates/Projects/lottery/node_modules/waterline-utils/lib/auto-migrations/private/run-alter-strategy/private/inform-re-failed-alter-stratagem.js:213:55)
  431. at ontimeout (timers.js:424:11)
  432. at tryOnTimeout (timers.js:288:5)
  433. at listOnTimeout (timers.js:251:5)
  434. at Timer.processTimers (timers.js:211:10)
  435.  
  436. error: Could not load Sails app.
  437. error:
  438. error: Tips:
  439. error: • First, take a look at the error message above.
  440. error: • Make sure you've installed dependencies with `npm install`.
  441. error: • Check that this app was built for a compatible version of Sails.
  442. error: • Have a question or need help? (http://sailsjs.com/support)
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!