wishlist: tiny sql client for logging data

Excellent project Marko. Started to play with your example, a littlebit tweaked, but I think that MySQL FB must be optimized - now this takes to much work memory to use with working system that collect also some data or is used for process.

I have also converted SHA1 library from oscat but this is working a litllebit strange and produce wrong hash. Must investigate more and I think with this we can spare some cycle time.

Thanks Marko for great sample with mysql and s7-1200

I have a problem with newest plc S7-1212DC/DC/RLY (firmware V4.1)

During connection to mysql error occurs

Temporary CPU error: Area length error in FB 1
affecting OB 1 execution
read access DB area
Incorrect address, operand replaced
 Processing will continue (no OB processing)

 PLC
Internal address details: Caddr=16#000009D3, area: DB 2 , addr: 1864

When I run the same program on S7-1214DC/DC/RLY (Firmware V3.1) everything is ok

No error occurs.

Test were made with the same database

Hello

I download project and change PLC 1214C . I load to PLC. But i can not write Mysql. Please check me.

Hello all,

nice prj  if I can say something to some strange behaviour of using S7-1200 firmw.4xx with error status disconnection, it probably depends of bugy Siemens communication bloks (look at versions in TIAv13). With new firmw.4 I've found strange uncorrect disconnection with my application server (created in C++ NET). In firmw.3 everything working ok. I got some advantage because I can create my own applications in C/C++. I'm using free SQLite system on PC with created open communication via socket between PLC and PC with SQLite DB file, but any implementation (with MS SQL Server) can be achieved perfectly. If I will have time and taste, will try some tests too.

Marko Bursic

hpant

 

Marko Bursic

As stated, the disconnection, error behaviour isn't 100%. But if you have time you can improve all that. Anyway, you're the first one that has sent some feedback information about this. I have never used it latter, I did just some piece of code because some of my clienet wanted some cheap variant to store data on SQL, that latter changed his mind.

There are some parts of program, that they don't need to be changed at all. SHA1 function, strictly you have nothing to change, because it is complicated and well optimized. Then handshaking, encoding,...its a huge work and it works, you are the whitness that has logged in.

From line 276 to 328 you can change as it suits your demand, you can even delete SQLExe command if you like to send data for logging on the server.

The lines I don't like are 1 to 85 and 365->

Also I have found that you can remove copy: array[0..19] of byte and rtu :int, this because a line

                 MOVE_BLK(IN:=#Pwd.Bytes[0],COUNT:=#Pwd.Len,OUT=>#copy[0]);
                            #rtu:=#Pwd.Len;

does nothing (it does: consumes plc time), it is a residual from earlier versions.

 Dear Marko,

I downloaded the project and tested in my plc. I have some problems, and I would appreciate if you could help me. 

1). I had to change the device from s7-1200 cpu 1515 to mine: s7-1200, cpu 1212 ac/dc/relay, with firmware 3.1,  here is my first problem, I got the message as in the following photo 1

2). After that, during to the compalization, I got the following, photo 2

3). When I try to run the project, I always get the Busy Error: photo 3

4). About the aythentication I have: photo 4

5). Finally, I get the error that the remote port is CLOSED. photo 5

photo 2:

Compilation Error

photo 3,

Busy Error

photo 4,

the status...

photo 5,

PORT is closed