Skip to Content

SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

SiePortalDeutsch

Search

Home
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menu temporary not available
- Menue temporary not available
- {{item.title}}

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

wishlist: tiny sql client for logging data

Created by: Marko Bursic at: 12/13/2011 1:13 PM (56 Replies)

Rating (9)

Thanks 25

Result pages:: |; 1 | 2 | 3 | 4 | 5 |...; |

57 Entries

Entries per page: 10 | 20 | 50 | all

12/13/2011 1:13 PM	Rate (2)
Marko Bursic Platinum Member Joined: 9/8/2009 Last visit: 7/17/2023 Posts: 1410 Rating: (154)	Dear experts and programming gurus, I would like if there is a possibility that S7-1200 could connect over TCP IP to a sql server ( MS SQL or MySQL) and perform only some basic SQL commands like INSERT INTO. The main goal is to archive production data directly without use of SCADA, there are some projects for microcontrollers that are capable of this, so it is not impossible.

Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users AutoGen_3966713

12/13/2011 4:01 PM	Rate (1)
0_Einstein Diamond Member Joined: 7/7/2010 Last visit: 3/10/2025 Posts: 15721 Rating: (2487)	With TCON, TSEND, you can connect to a client of your design, send data in whatever form works for your application. I can imagine a client that simply takes incoming data, converts and massages, validates origin and authentication, then passes on commands to a SQL server and handles the sql server user authentication and related permissions. I can imagine a PLC program that stacks up data records (your production data), built around a DB structure for a decent packet size (maybe 1KB), and sends to an ip address ata specific port. To make it work without the client would probably be what you are asking about. If you have a protocol specification for an existing sql connection, you might be able to craft it in the PLC programming. In my experience with such things, the PLC should be the server, and the remote computer should pull or poll for data. In this way, you can have a DB with the right info stored, and simply ask for the data from that PLC.
	science guy
Suggestion To thank Quote Answer

12/13/2011 4:47 PM	Rate (0)
Marko Bursic Platinum Member Joined: 9/8/2009 Last visit: 7/17/2023 Posts: 1410 Rating: (154)	Yes, I agree that there are other possibilties, to implement a custom server-client protocol for bridging to SQL server, with also many different server protocols like oracle, mysql, mssql,.. You still need a knowledge to make such server-client application on both sides S7 and PC and I am not the one. It would be easier to have a sql client on PLC, just simple one, capableto write data in table and let other people from IT to use this data. This is absolutely impossible for engineer like me to write such piece of program, but I saw that there are people that can write even a communication protocols like modbus in ladder, so its possible if you have knowledge. Overview of MySQL protocol: http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol
	Last edited by: Marko Bursic at: 12/13/2011 4:49 PM
Suggestion To thank Quote Answer

12/19/2011 11:46 PM	Rate (0)
Marko Bursic Platinum Member Joined: 9/8/2009 Last visit: 7/17/2023 Posts: 1410 Rating: (154)	Hi, all I have been studing MySQL client written in C++ and now I made first steps. The first problem is enycription of password and this is done with SHA1 function, I have been watching many SHA1 algorithms and now I made a small version of it. The purpose is to authenticate a login to the server, so it is limited to 40 characters, only just what is needed for MySQL authentication. The server when detects a connection, sends a greeting message to client, which has a random pattern of characters. Both client and server encrypts this pattern with known password. Client sends this encrypted pattern to the server which compares with its result and then if they match youre logged in. After logon is much simpler, sql statements are sent to the server in string form, so implementing an tiny client is close. Is anybody interested to join? I am not expert from converting C++ programs into S7, and help would be appreciated. I have attached SCL source Step7 for function SHA1 Attachment 00000003.zip (2389 Downloads)

Suggestion To thank Quote Answer

7/19/2012 12:40 PM	Rate (0)
karesz Posts: 4 Rating: (0)	Hello! I am also interesting in about s7-1200 mysql connection. If you have any info please share. Do you have a working c /or c++ program? Bye.
karesz Posts: 4 Rating: (0)
Suggestion To thank Quote Answer

12/12/2012 1:11 AM	Rate (0)
natenut Posts: 33 Rating: (7)	I'm interested in helping out on this project too. let me know if your still actively working on it. Thanks!
natenut Posts: 33 Rating: (7)
Suggestion To thank Quote Answer

12/14/2012 5:00 PM	Rate (0)
Marko Bursic Platinum Member Joined: 9/8/2009 Last visit: 7/17/2023 Posts: 1410 Rating: (154)	If you didn't see other post, this is what was done. I have tested this with plcsim, it has never run on real plc, but is very probable that is working. If somebody wants to try, it is welcome to do. I can also change something if it will not work. Basicaly the decryption of login greeting message was compared with real mysql client (Wireshark) and has a 100% match, so only the sequence of connecting and disconnecting are to be tested other will work. Attachment MySQL_v3 -- MySQL_v1_SIMATIC 30.pdf (3729 Downloads)

Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users Vishaljp

12/14/2012 6:02 PM	Rate (0)
Marko Bursic Platinum Member Joined: 9/8/2009 Last visit: 7/17/2023 Posts: 1410 Rating: (154)	I will put the last source and pdf I have made near year ago. Attachment 0000000c.zip (2291 Downloads)

Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users Vishaljp

12/14/2012 6:03 PM	Rate (0)
Marko Bursic Platinum Member Joined: 9/8/2009 Last visit: 7/17/2023 Posts: 1410 Rating: (154)	pdf Attachment MySQL_v5 -- MySQL_v1_SIMATIC 30.pdf (2908 Downloads)

Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users Vishaljp

6/14/2013 9:54 PM	Rate (0)
vinceducat Posts: 7 Rating: (0)	i'm very interresting by this projet, i have real S7-400 with ethernet, and i search sample of program to send data directlyt from PLC to SQL server
vinceducat Posts: 7 Rating: (0)
Suggestion To thank Quote Answer

Result pages:: |; 1 | 2 | 3 | 4 | 5 |...; |

57 Entries

Entries per page: 10 | 20 | 50 | all

|

Share this page:

Share this page on...

Related topics by keywords:

Follow us on