MySQL Forums
Forum List  »  Connector/Node.js

Re: Cannot use caching_sha2_password using XDevAPI, unless using mysqlsh first
Posted by: Geert Vanderkelen
Date: March 16, 2022 04:31AM

Hi Rui,

Thanks for your help. And indeed, I posted to the wrong forum. I think 'document store' scared me off :)

Yes, I do what you describe. PLAIN is used while using TLS, and looping over MYSQL41 and SHA256_MEMORY.

However, though PLAIN works, I can never use SHA256_MEMORY (user has authentication plugin set to 'caching_sha2_password'), whether TLS or not TLS.

But when I first use 'mysqlsh' with that user, and then use my code: all works as expected, that is, I can use SHA256_MEMORY over no-TLS connection.

I am actually checking the X Plugin source in the mysql-server source to see when it gets cached.

Maybe I'll find out why, and if not, revive the discussion in the other forum.

Cheers,
Geert

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.