Welcome to our new forum
All users of the legacy CODESYS Forums, please create a new account at account.codesys.com. But make sure to use the same E-Mail address as in the old Forum. Then your posts will be matched.
Close
Hi everybody
In 'MySQL' or 'MsSQL' libraries the database target must be an IP address + port.
when your database is located on a cloud it seems to be different (on the cloud side..): you are authorizing specific IP holder to access from within the cloud DB instant see: https://cloud.google.com/sql/docs/mysql ... ppaccessIP
my question is: Is there a way to work this out?
Will appreciate any reply..
Joseph Livne
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
As far as I can see they talk about the IP Address which is connecting to the cloud. You need to give them the permissions to connect.
Your client still connects to the cloud via IP Address.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
if you will setup correctly IP address of PLC, gateway and DNS PLC running on CODESYS V3.5 is able to resolve hostname given by your cloud provider such as Google, Amazon or Microsoft Azure.
IP address for this authorization is your outsider IP before WAN.
Thank you Scheapper and Tomas. I think this solve the matter for me now.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2017-09-25
Originally created by: KevinR
Hello J_Livne,
The MySQL library also resolves the domain name. You can use the Domain address or the IP-address on "sHost" Input (MySQL_Open FB).
It autodetects the address type, if Hostname is detected it automatically resolves the address.
Please let me know if you need further information.
BR,
KevinR
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi everybody
In 'MySQL' or 'MsSQL' libraries the database target must be an IP address + port.
when your database is located on a cloud it seems to be different (on the cloud side..): you are authorizing specific IP holder to access from within the cloud DB instant see: https://cloud.google.com/sql/docs/mysql ... ppaccessIP
my question is: Is there a way to work this out?
Will appreciate any reply..
Joseph Livne
As far as I can see they talk about the IP Address which is connecting to the cloud. You need to give them the permissions to connect.
Your client still connects to the cloud via IP Address.
Hi,
if you will setup correctly IP address of PLC, gateway and DNS PLC running on CODESYS V3.5 is able to resolve hostname given by your cloud provider such as Google, Amazon or Microsoft Azure.
IP address for this authorization is your outsider IP before WAN.
This library has function for resolving hostname to ip addresss.
https://store.codesys.com/mssql-library.html
Thank you Scheapper and Tomas. I think this solve the matter for me now.
Originally created by: KevinR
Hello J_Livne,
The MySQL library also resolves the domain name. You can use the Domain address or the IP-address on "sHost" Input (MySQL_Open FB).
It autodetects the address type, if Hostname is detected it automatically resolves the address.
Please let me know if you need further information.
BR,
KevinR