1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
| mysql> CREATE DATABASE solaredge;
Query OK, 1 row affected (0.02 sec)
mysql> USE solaredge;
Database changed
mysql>
mysql> CREATE TABLE telemetry_optimizers (
-> op_id INT UNSIGNED NOT NULL,
-> timestamp INT UNSIGNED NOT NULL,
-> uptime SMALLINT UNSIGNED NOT NULL,
-> v_in SMALLINT UNSIGNED NOT NULL COMMENT '10bit steps of 0.125 V',
-> v_out SMALLINT UNSIGNED NOT NULL COMMENT '10bit steps of 0.125 V',
-> i_in SMALLINT UNSIGNED NOT NULL COMMENT '12bit steps of 0.00625 A',
-> e_day SMALLINT UNSIGNED NOT NULL COMMENT '16bit steps of 0.25 Wh',
-> temperature TINYINT NOT NULL COMMENT '8bit steps of 2 deg C',
-> PRIMARY KEY (timestamp, op_id),
-> INDEX (op_id, timestamp)
-> );
Query OK, 0 rows affected (0.13 sec)
mysql>
mysql> CREATE TABLE telemetry_inverter (
-> inv_id INT UNSIGNED NOT NULL,
-> timestamp INT UNSIGNED NOT NULL,
-> temperature FLOAT NOT NULL,
-> e_day FLOAT NOT NULL,
-> de_day FLOAT NOT NULL,
-> v_ac FLOAT NOT NULL,
-> i_ac FLOAT NOT NULL,
-> frequency FLOAT NOT NULL,
-> v_dc FLOAT NOT NULL COMMENT 'steps of 0.0625 V',
-> e_total INT UNSIGNED NOT NULL,
-> i_rcd FLOAT NOT NULL,
-> mode TINYINT UNSIGNED NOT NULL COMMENT '1 OFF, 2 SLEEPING, 3 STARTING, 4 MPPT, 5 THROTTLED, 6 SHUTTING_DOWN, 8 STANDBY',
-> p_active FLOAT NOT NULL,
-> p_apparent FLOAT NOT NULL,
-> p_reactive FLOAT NOT NULL,
-> PRIMARY KEY (timestamp, inv_id)
-> );
Query OK, 0 rows affected (0.83 sec)
mysql>
mysql> CREATE TABLE telemetry_inverter_3phase (
-> inv_id INT UNSIGNED NOT NULL,
-> timestamp INT UNSIGNED NOT NULL,
-> temperature FLOAT NOT NULL,
-> e_day FLOAT NOT NULL,
-> de_day FLOAT NOT NULL,
-> v_ac1 FLOAT NOT NULL,
-> v_ac2 FLOAT NOT NULL,
-> v_ac3 FLOAT NOT NULL,
-> i_ac1 FLOAT NOT NULL,
-> i_ac2 FLOAT NOT NULL,
-> i_ac3 FLOAT NOT NULL,
-> frequency1 FLOAT NOT NULL,
-> frequency2 FLOAT NOT NULL,
-> frequency3 FLOAT NOT NULL,
-> v_dc FLOAT NOT NULL COMMENT 'steps of 0.0625 V',
-> e_total INT UNSIGNED NOT NULL,
-> i_rcd FLOAT NOT NULL,
-> mode TINYINT UNSIGNED NOT NULL COMMENT '1 OFF, 2 SLEEPING, 3 STARTING, 4 MPPT, 5 THROTTLED, 6 SHUTTING_DOWN, 8 STANDBY',
-> v_1to2FLOAT NOT NULL,
-> v_2to3FLOAT NOT NULL,
-> v_3to1FLOAT NOT NULL,
-> p_active1 FLOAT NOT NULL,
-> p_active2 FLOAT NOT NULL,
-> p_active3 FLOAT NOT NULL,
-> p_apparent1 FLOAT NOT NULL,
-> p_apparent2 FLOAT NOT NULL,
-> p_apparent3 FLOAT NOT NULL,
-> p_reactive1 FLOAT NOT NULL,
-> p_reactive2 FLOAT NOT NULL,
-> p_reactive3 FLOAT NOT NULL,
-> PRIMARY KEY (timestamp, inv_id)
-> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL,
v_2to3FLOAT NOT NULL,
v_3to1FLOAT NOT NULL,
p_' at line 20
mysql>
mysql> CREATE TABLE live_update (
-> pvo_last_live INT UNSIGNED NOT NULL,
-> last_0503 BINARY(34) NOT NULL,
-> last_telemetry INT UNSIGNED NOT NULL
-> );
Query OK, 0 rows affected (0.04 sec)
mysql> INSERT INTO live_update (pvo_last_live, last_0503, last_telemetry) VALUES (0, "\0", 0);
Query OK, 1 row affected (0.02 sec)
mysql> |
:fill(white):strip_exif()/i/2002131643.jpeg?f=thumbmini)
:strip_icc():strip_exif()/u/81282/avatar.jpg?f=community){kind=avatar}
. Blijkt dat de USB-drive, waarop ik de pcap-files wegschreef, het heeft begeven. Door onduidelijke oorzaak is hierdoor de koppeling met het LAN verbroken. Vanaf het werk adres repareren ging wat lastig
.
:strip_icc():strip_exif()/u/553329/crop65f2e249c118d_cropped.jpg?f=community)
.
/u/286506/KiefAD.png?f=community)
:strip_icc():strip_exif()/u/177828/crop5db1af9701f4c_cropped.jpeg?f=community)
:strip_exif()/u/47567/3.gif?f=community)
)
heb de db weggegooid en opnieuw begonnen voor de zekerheid /u/541891/crop624d94cd4282f_cropped.png?f=community)
:strip_icc():strip_exif()/u/910389/crop5d60458514e81_cropped.jpeg?f=community)