#Our server can no longer query our database

25 messages · Page 1 of 1 (latest)

jovial cargo
#

MYSQL Workbench still allows us to connect and run Queries, but our server is unable to connect. The log is saying:

{

sqlMessage: "Plugin 'mysql_native_password' is not loaded",

sqlState: 'HY000',

fatal: true,

originalUrl: 'mainCronJob',

Error: ER_PLUGIN_IS_NOT_LOADED: Plugin 'mysql_native_password' is not loaded

at Handshake.ErrorPacket (/app/node_modules/mysql/lib/protocol/sequences/Handshake.js:123:18)

at Parser._parsePacket (/app/node_modules/mysql/lib/protocol/Parser.js:433:10)

at Parser.write (/app/node_modules/mysql/lib/protocol/Parser.js:43:10)

at Protocol.write (/app/node_modules/mysql/lib/protocol/Protocol.js:38:16)

at Socket.emit (node:events:517:28)

at Socket.emit (node:domain:489:12)

at Protocol._enqueue (/app/node_modules/mysql/lib/protocol/Protocol.js:144:48)

at PoolConnection.connect (/app/node_modules/mysql/lib/Connection.js:116:18)

at new Promise (<anonymous>)

at YourCustomTransport.<anonymous> (/app/dist/src/logger.js:102:61)

sqlMessage: "Plugin 'mysql_native_password' is not loaded",

ocean capeBOT
#

Project ID: 1fc9ac5f-29f8-4b23-ab28-1eebdaeb8c06

jovial cargo
#

1fc9ac5f-29f8-4b23-ab28-1eebdaeb8c06

#

We've tried to run: ALTER USER 'your_user'@'%' IDENTIFIED WITH mysql_native_password BY 'your_password';
FLUSH PRIVILEGES;

#

but it responds with: Error Code: 1524. Plugin 'mysql_native_password' is not loaded

#

Can anyone help us? This happened on both our production site and our development site at the same time, we've made no recent code changes.

After the initial error, we tried redeploying both databases, and this is where we currently are.

cold acorn
#

Can you send me a screenshot of your database deployments?

jovial cargo
cold acorn
#

Thank you, finally could you send me a screenshot of the image that the MySQL database is connected to?

jovial cargo
#

I'm sorry, I don't know what that means

cold acorn
#

Click on the Settings button

#

and then just send a screenshot of the top-most thing on the page

jovial cargo
cold acorn
#

oh perfect, has it always been pinned to version 8?

jovial cargo
#

I do not know

cold acorn
#

Let's hope it was, could you try appending --mysql-native-password=ON to your database start command?
You can find that on the same settings page if you scroll down a bit

jovial cargo
#

Ok, i'm trying...

#

It is working, thank you. What caused this issue? It is scary for us, as we sometimes have large events going on with a few hundred people on site; it is dangerous for our business to have outages; we want to bulletproof as much as possible.

cold acorn
#

Railway uses the mysql_native_password plugin for authentication (which is somewhat popular), although it seems MySQL databases on Railway doesn't load that plugin by default so when it redeploys then it has to manually enabled by adding that flag

jovial cargo
#

Ok, that could explain what caused the issue for the redployment, but why did it need to be redeployed? This has been working fine for 9 months

cold acorn
radiant bramble
#

your database was indeed on that host

#

we are sorry for the inconvenience here

jovial cargo
#

Ok, thank you Brody. I appreciate the honesty.

radiant bramble
#

and thank you fragly for getting them up and running so quickly