Jump to content
Sign in to follow this  
ciprian.savoiu

Connect to MySql server with "SQL Connector"

Recommended Posts

Hi everybody,
I'm struggling to make a controller to submit data from a controller USP-070-B10/B08 to a MySql Database that stays on Amanzon cloud.

I made a project using Unilogic v 1.19.83 same as the one in the controller. Did the connections and queries I wanted but nothing happens. it looks like it's not communicating at all with the database. I'm not even seeing a connection in my server manager. 

There is any tutorial, hints or something somewhere to guide me (I attached some screens as well)? 

Thanks  

plc2.png

plc3.png

Share this post


Link to post
Share on other sites

More updates . Not sure if the DNS is correct but now I know what error I'm getting :)

              "2003 can't connect to MySQL server on ip address  (101)"

Nevertheless, I can't manage to make it working. I also installed MySQL server locally and didn't work either. It must be something on PLC communications settings or it doesn't like MySQL. 
Does anyone has a project with a basic query for MySQL that works so i will modify only the communications and database server?


Thanks

Share this post


Link to post
Share on other sites
Quote

Does anyone has a project with a basic query for mysql that works so i will modify only the communications and database server?

In the link I already mentioned in the previous replies ( "SQL Query" function block usage) there is already a working "SQL Connector" configuration, just change the IP, Port, Username & Password.
 

Quote

I can't manage to make it working

Use the information in this link "Unitronics Technical support" on the SQL section. There is a guide written by  Unitronics Support that will help you troubleshot your issue,
 

UPDATE:
The issue resolve and ciprian.savoiu is able to query his DB (informed us by mail). 
 

Share this post


Link to post
Share on other sites

Indeed, everything works as it should now. Thanks everybody for your support.

It was the DNS who wasn't configured correctly. Now it communicates with a MySQL database which stays on Amazon Cloud RDS service. It also connects to an address not only on an IP which is great.

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...