search

ChuckBell / MySQL_Connector_Arduino

Database connector library for using MySQL with your Arduino projects.
331 stars 132 forks source link

Azure Database for MySQL server #124

Closed hervema closed 2 years ago

hervema commented 4 years ago

Hello, I'm trying to use your great library with Azure Database for MySQL server. I know the hostname approach, but I can retrieve the IP. However, despite a lot of research and testing, I can't connect (the connection works very well with MySQL Workbench for example and I'm able to connect to a local MySQL server on a Rasberry).

So, before trying to go further in the research, I would like to know if your library is able to connect to this kind of resource on the Cloud?

Thanks in advance,

Regards

hervema commented 4 years ago

additional info : I get Error: 44 = tive_password .... !

ChuckBell commented 4 years ago

Aha. You need to turn on native password authentication. See https://dev.mysql.com/doc/refman/8.0/en/native-pluggable-authentication.html .

On Wed, Feb 12, 2020 at 16:36 hervema notifications@github.com wrote:

additional info : I get Error: 44 = tive_password .... !

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/124?email_source=notifications&email_token=AB6SHYGDTX6QLQFLO4OGDA3RCRTXVA5CNFSM4KT4PPKKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOELSPH5Y#issuecomment-585430007, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB6SHYAIZKYJ7ZEU2ACPWI3RCRTXVANCNFSM4KT4PPKA .

hervema commented 4 years ago

It seems the case for the user I use for (hervema)

PbAzureMySQL

I did test with different MYSQL version (5.6, 5.7 and 8.0) :-(

ChuckBell commented 4 years ago

Ok, can you tell me what version of MySQL you're trying to connect to in Azure? Can you connect to that server from the same WiFi (or Ethernet) subnet as your Raspberry Pi?

hervema commented 4 years ago

For Azure, I did tests with MySQL 5.6, 5.7 and 8.0. Same result for all versions.

Yes, It's the same Ethernet network to address that Azure server as my Rasberry Pi (for which I can access locally, with a direct local IP (192.168.0...) or thru a dyndns address, for all that's works fine).

ChuckBell commented 4 years ago

If you've used a variety of MySQL versions and still can't connect, then it is reasonable to start looking at your network connection or the security requirements of the cloud provider. For example, check to ensure you don't need a VPN or some other pre-connection procedure before connecting. Also, I'd try using the mysql client and enter the same connection information in your sketch (host IP, port, user, passwd) and if that works, we're back to some incompatibility with the MySQL version. If it doesn't work, try working out that issue and when fixed, try the connector again.

What about firewalls? Any in the way? All ports open? Are you using the correct port?

If none of that works, you may want to consider sending data via MQTT messages. Yes, you can do that in that cloud vendor (check it and see).

However, back to the version. I looked at the Azure MySQL product and I cannot determine which version it is. If you can connect to it, please execute this command and send/post the result:

SELECT @@VERSION;

I ask again because I'm reading that the product from Azure may not be a "standard" MySQL release. Best to check it, please. I would but I haven't an account.

ChuckBell commented 2 years ago

Closed due to inactivity.