ciprian.savoiu Posted January 8, 2018 Report Share Posted January 8, 2018 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 Quote Link to comment Share on other sites More sharing options...
NoamM Posted January 8, 2018 Report Share Posted January 8, 2018 Hi, Some info about the "SQL Connector" can be found in this answer "SQL Query" function block usage. What is the status in your query struct ("Create_SQL_Table") after using "SQL Query" Ladder function? Quote Link to comment Share on other sites More sharing options...
ciprian.savoiu Posted January 8, 2018 Author Report Share Posted January 8, 2018 The status looks similar as in the answer from the link. I have looked into that one as well. It might be any firewall or something like this that can block the communication with the server? Quote Link to comment Share on other sites More sharing options...
ciprian.savoiu Posted January 8, 2018 Author Report Share Posted January 8, 2018 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 Quote Link to comment Share on other sites More sharing options...
NoamM Posted January 10, 2018 Report Share Posted January 10, 2018 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). Quote Link to comment Share on other sites More sharing options...
ciprian.savoiu Posted January 12, 2018 Author Report Share Posted January 12, 2018 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.