CODESYS - the IEC 61131-3 automation software

Welcome to the official CODESYS Forum
Deutsche Version English version russian version 
It is currently Thu Nov 23, 2017 10:31 am

All times are UTC+01:00




Post new topic  Reply to topic  [ 5 posts ] 
Author Message
PostPosted: Tue Sep 19, 2017 5:02 am 
Offline

Joined: Mon Jul 10, 2017 8:34 am
Posts: 3
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


Top
   
PostPosted: Wed Sep 20, 2017 6:31 am 
Offline

Joined: Tue Jul 18, 2017 6:19 am
Posts: 20
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.


Top
   
PostPosted: Wed Sep 20, 2017 6:11 pm 
Offline

Joined: Mon Jun 27, 2016 7:38 pm
Posts: 1
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


Top
   
PostPosted: Thu Sep 21, 2017 2:12 am 
Offline

Joined: Mon Jul 10, 2017 8:34 am
Posts: 3
Thank you Scheapper and Tomas. I think this solve the matter for me now. 8)


Top
   
PostPosted: Mon Sep 25, 2017 1:47 pm 
Offline
User avatar

Joined: Tue Jun 28, 2016 2:45 pm
Posts: 37
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


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 5 posts ] 

All times are UTC+01:00


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited