We have migrated the memSQL database from memSQL to singleStore. End-user permissions are entact but application can not connect. I have very limited knowladge of memSQL, any thoughts or trouble shooting will would help. These are the erros we recived in the application log.
Failed to establish MemSql connection { Error: ER_ACCESS_DENIED_ERROR: Access denied for user ‘web_session_api’@‘10.10.128.54’ (using password: YES)
at Handshake.Sequence._packetToError (/opt/code/node_modules/mysql/lib/protocol/sequences/Sequence.js:52:14)
at Handshake.ErrorPacket (/opt/code/node_modules/mysql/lib/protocol/sequences/Handshake.js:103:18)
at Protocol._parsePacket (/opt/code/node_modules/mysql/lib/protocol/Protocol.js:280:23)
at Parser.write (/opt/code/node_modules/mysql/lib/protocol/Parser.js:75:12)
at Protocol.write (/opt/code/node_modules/mysql/lib/protocol/Protocol.js:39:16)
at Socket. (/opt/code/node_modules/mysql/lib/Connection.js:103:28)
at emitOne (events.js:116:13)
at Socket.emit (events.js:211:7)
at addChunk (_stream_readable.js:263:12)
at readableAddChunk (_stream_readable.js:250:11)
--------------------
at Protocol._enqueue (/opt/code/node_modules/mysql/lib/protocol/Protocol.js:141:48)
at Protocol.handshake (/opt/code/node_modules/mysql/lib/protocol/Protocol.js:52:41)
at PoolConnection.connect (/opt/code/node_modules/mysql/lib/Connection.js:130:18)
at Pool.getConnection (/opt/code/node_modules/mysql/lib/Pool.js:48:16)
at Object. (/opt/code/v2/app/data_access/SessionDataAccess.js:52:6)
at Module._compile (module.js:653:30)
at Object.Module._extensions…js (module.js:664:10)
at Module.load (module.js:566:32)
at tryModuleLoad (module.js:506:12)
at Function.Module._load (module.js:498:3)
code: ‘ER_ACCESS_DENIED_ERROR’,
errno: 1045,
sqlState: ‘28000’,
fatal: true }
Fri Sep 16 2022 12:39:54 GMT-0500 (CDT): {“level”:5,“application”:“SessionAPI”,“environment”:“DEV”,“machine”:“a26d482acafb”,“namespace”:“SessionService”,“data”:{“Location”:“process”,“MethodName”:“event:uncaughtException”},“text”:“A fatal exception was encountered. { Error: ER_ACCESS_DENIED_ERROR: Access denied for user ‘web_session_api’@‘10.10.128.54’ (using password: YES)\n at Handshake.Sequence._packetToError (/opt/code/node_modules/mysql/lib/protocol/sequences/Sequence.js:52:14)\n at Handshake.ErrorPacket (/opt/code/node_modules/mysql/lib/protocol/sequences/Handshake.js:103:18)\n at Protocol._parsePacket (/opt/code/node_modules/mysql/lib/protocol/Protocol.js:280:23)\n at Parser.write (/opt/code/node_modules/mysql/lib/protocol/Parser.js:75:12)\n at Protocol.write (/opt/code/node_modules/mysql/lib/protocol/Protocol.js:39:16)\n at Socket. (/opt/code/node_modules/mysql/lib/Connection.js:103:28)\n at emitOne (events.js:116:13)\n at Socket.emit (events.js:211:7)\n at addChunk (_stream_readable.js:263:12)\n at readableAddChunk (_stream_readable.js:250:11)\n --------------------\n at Protocol._enqueue (/opt/code/node_modules/mysql/lib/protocol/Protocol.js:141:48)\n at Protocol.handshake (/opt/code/node_modules/mysql/lib/protocol/Protocol.js:52:41)\n at PoolConnection.connect (/opt/code/node_modules/mysql/lib/Connection.js:130:18)\n at Pool.getConnection (/opt/code/node_modules/mysql/lib/Pool.js:48:16)\n at Object. (/opt/code/v2/app/data_access/SessionDataAccess.js:52:6)\n at Module._compile (module.js:653:30)\n at Object.Module._extensions…js (module.js:664:10)\n at Module.load (module.js:566:32)\n at tryModuleLoad (module.js:506:12)\n at Function.Module._load (module.js:498:3)\n code: ‘ER_ACCESS_DENIED_ERROR’,\n errno: 1045,\n sqlState: ‘28000’,\n fatal: true }”}
Sorry to hear that you are receiving all these errors.