Last Write Query into Test Database:
| Apartment | Counter | Device | Channel | Status | Date and Time |
|---|---|---|---|---|---|
| 1 | 8933.0 | 1 | 0 | 0 | 2021-06-17 01:20:17 |
| 2 | 4931.0 | 1 | 1 | 0 | 2021-06-17 01:20:17 |
| 3 | 67474.0 | 1 | 2 | 0 | 2021-06-17 01:20:18 |
| 4 | 0.0 | 1 | 3 | 0 | 2021-06-17 01:20:18 |
| 5 | 1016.0 | 1 | 4 | 0 | 2021-06-17 01:20:18 |
| 5 | 1017.0 | 1 | 5 | 0 | 2021-06-17 01:20:18 |
| 5 | 1018.0 | 1 | 6 | 0 | 2021-06-17 01:20:18 |
| 6 | 58.0 | 1 | 7 | 0 | 2021-06-17 01:20:19 |
| 0 | 214804480.0 | 4 | 0 | 0 | 2021-06-17 01:20:19 |
| 0 | 0.0 | 4 | 1 | 0 | 2021-06-17 01:20:20 |
| 0 | 0.0 | 4 | 2 | 0 | 2021-06-17 01:20:20 |
| 0 | 0.0 | 4 | 3 | 0 | 2021-06-17 01:20:20 |
| 0 | 0.0 | 4 | 4 | 0 | 2021-06-17 01:20:21 |
| 0 | 0.0 | 4 | 5 | 0 | 2021-06-17 01:20:21 |
| 0 | 0.0 | 4 | 6 | 0 | 2021-06-17 01:20:21 |
| 0 | 0.0 | 4 | 7 | 0 | 2021-06-17 01:20:21 |
This is log last write request into MySQL database. Every 5 minutes server send request for ModBus network for check all devices and receive all parameters including: reader status, current count, device Id, channels, quantity of impulses and more.... Status - can provide full information about Reader, any Errors if they appear on the Net will be stored into database log.
Photo
Using industrial network over RS485 level protocol, for connect devices each other and Smart RS485<>LAN converter for connect main server.
Write changes into Database
| Apartment | Counter |
|---|---|
New value will be accepted next five minutes (during next database request cycle).