QMYND:MYSQL-UNSUPPORTED-AUTHENTICATION was signalled | Railway | Page 1

peak grail Mar 6, 2023, 8:56 PM

#

Project ID: af684ae5-8a4b-4930-9d59-6884623336d2
Getting this when trying to migrate my mysql db to postgres with pgloader. Searched around and saw people saying to change the mysql.conf or something like this, but since it's not possible, I didn't find any other solution

tawdry willowBOT Mar 6, 2023, 8:56 PM

#

Project ID: af684ae5-8a4b-4930-9d59-6884623336d2

#

It looks like the error ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client was signalled.

peak grail Mar 6, 2023, 9:30 PM

#

ended up using https://github.com/AnatolyUss/NMIG

GitHub

GitHub - AnatolyUss/nmig: NMIG is a database migration tool, writte...

NMIG is a database migration tool, written in Node.js and highly inspired by FromMySqlToPostgreSql. - GitHub - AnatolyUss/nmig: NMIG is a database migration tool, written in Node.js and highly in...

placid wedge Mar 14, 2023, 2:10 PM

#

peak grail ended up using https://github.com/AnatolyUss/NMIG

Hi! I'm trying to use this, but I'm getting MySQL connection error: {"errno":-3008,"code":"ENOTFOUND","syscall":"getaddrinfo","hostname":"MYSQL_URL","fatal":true} PostgreSQL connection error: {"errno":-3008,"code":"ENOTFOUND","syscall":"getaddrinfo","hostname":"DATABASE_URL"}
Do you have any idea what's going on? I don't see anything I'm doing wrong at the moment.

#

I copied the MYSQL_URL and DATABASE_URL from the Railway "Connect" variables here

#

Oh I put DATABASE_URL in "host" in config.json instead of PGHOST (and the same for MySQL)

#QMYND:MYSQL-UNSUPPORTED-AUTHENTICATION was signalled