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

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?


plc5.thumb.png.08880e66d0ac14bf6723a3edacd6d999.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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×