Welcome to Charger Point test Philip Durham [ d6gsNICFc5UQq4mxwpnV ] OpenEVSE ID: QWHzxHPUwG

CONNECTED

CP LOGS
>>[3,"5fb276e8-497c-40f8-8a71-424dce69c235",{"currentTime":"2019-05-24T09:00:02.498Z"}]
>>[3,"e20d1c82-4058-4de5-9130-71e84233583f",{}]
>>[3,"09323b4f-1809-487c-aa2a-0dab383f9ee8",{"status":"Accepted","currentTime":"2019-05-24T09:00:02.482Z","heartbeatInterval":14400}]
<<[2, "5fb276e8-497c-40f8-8a71-424dce69c235", "Heartbeat", {}]
<<[2, "e20d1c82-4058-4de5-9130-71e84233583f", "StatusNotification", {"errorCode": "NoError", "status": "Available", "vendorId": "com.ibeyonde.ev", "connectorId": 1, "info": "", "timestamp": "2019-05-24T09:00:02.474129", "vendorErrorCode": ""}]
<<[2, "09323b4f-1809-487c-aa2a-0dab383f9ee8", "BootNotification", {"chargePointSerialNumber": "openevse.c19023d3", "iccid": "c19023d3", "chargePointModel": "OpenEVSE", "meterType": "DBT NQC-ACDC", "chargeBoxSerialNumber": "openevse.c19023d3", "meterSerialNumber": "openevse.c19023d3", "imsi": "", "chargePointVendor": "Ibeyonde", "firmwareVersion": "1.0.0"}]
>>[3,"d7224def-d0f5-4a64-82eb-791996058c34",{"currentTime":"2019-05-24T08:00:02.185Z"}]
>>[3,"a3288602-1fd6-482a-bc30-a9ba1bc46612",{}]
>>[3,"d4d1a47f-33c3-4f51-865a-d2e90920e6b9",{"status":"Accepted","currentTime":"2019-05-24T08:00:02.170Z","heartbeatInterval":14400}]
<<[2, "d7224def-d0f5-4a64-82eb-791996058c34", "Heartbeat", {}]
<<[2, "a3288602-1fd6-482a-bc30-a9ba1bc46612", "StatusNotification", {"connectorId": 1, "errorCode": "NoError", "info": "", "status": "Available", "vendorId": "com.ibeyonde.ev", "timestamp": "2019-05-24T08:00:02.168769", "vendorErrorCode": ""}]
<<[2, "d4d1a47f-33c3-4f51-865a-d2e90920e6b9", "BootNotification", {"meterSerialNumber": "openevse.c19023d3", "firmwareVersion": "1.0.0", "meterType": "DBT NQC-ACDC", "chargeBoxSerialNumber": "openevse.c19023d3", "iccid": "c19023d3", "imsi": "", "chargePointModel": "OpenEVSE", "chargePointSerialNumber": "openevse.c19023d3", "chargePointVendor": "Ibeyonde"}]
>>[3,"0824a9e4-bc1a-4c49-b81d-91ab38b25858",{"currentTime":"2019-05-24T07:00:01.697Z"}]
>>[3,"eb66f477-c8d5-48f2-bc81-ff6cea4f43a1",{}]
>>[3,"6204f316-7e6c-44f0-8544-699fdf947e23",{"status":"Accepted","currentTime":"2019-05-24T07:00:01.683Z","heartbeatInterval":14400}]
<<[2, "0824a9e4-bc1a-4c49-b81d-91ab38b25858", "Heartbeat", {}]
<<[2, "eb66f477-c8d5-48f2-bc81-ff6cea4f43a1", "StatusNotification", {"errorCode": "NoError", "vendorId": "com.ibeyonde.ev", "vendorErrorCode": "", "status": "Available", "info": "", "connectorId": 1, "timestamp": "2019-05-24T07:00:01.681285"}]
<<[2, "6204f316-7e6c-44f0-8544-699fdf947e23", "BootNotification", {"iccid": "c19023d3", "firmwareVersion": "1.0.0", "meterType": "DBT NQC-ACDC", "imsi": "", "chargeBoxSerialNumber": "openevse.c19023d3", "meterSerialNumber": "openevse.c19023d3", "chargePointVendor": "Ibeyonde", "chargePointModel": "OpenEVSE", "chargePointSerialNumber": "openevse.c19023d3"}]
>>[3,"6f855f06-9fd4-4644-b694-ace5358957ae",{"currentTime":"2019-05-24T06:00:02.120Z"}]
>>[3,"50fe41c9-05bb-464b-8a10-6ee06f1f4a0f",{}]
>>[3,"ebd5d77a-b5ac-491c-a2b4-4ad4790b7b74",{"status":"Accepted","currentTime":"2019-05-24T06:00:02.102Z","heartbeatInterval":14400}]
<<[2, "6f855f06-9fd4-4644-b694-ace5358957ae", "Heartbeat", {}]
<<[2, "50fe41c9-05bb-464b-8a10-6ee06f1f4a0f", "StatusNotification", {"vendorId": "com.ibeyonde.ev", "connectorId": 1, "vendorErrorCode": "", "status": "Available", "errorCode": "NoError", "timestamp": "2019-05-24T06:00:02.098519", "info": ""}]
<<[2, "ebd5d77a-b5ac-491c-a2b4-4ad4790b7b74", "BootNotification", {"chargePointModel": "OpenEVSE", "imsi": "", "meterSerialNumber": "openevse.c19023d3", "iccid": "c19023d3", "chargeBoxSerialNumber": "openevse.c19023d3", "meterType": "DBT NQC-ACDC", "chargePointSerialNumber": "openevse.c19023d3", "firmwareVersion": "1.0.0", "chargePointVendor": "Ibeyonde"}]
>>[3,"3278b363-e01a-453f-a2f3-f30aad4b5266",{"currentTime":"2019-05-24T05:00:01.660Z"}]
>>[3,"0f889413-9728-4af7-9f8e-32be374be54d",{}]
>>[3,"c0e30242-be3a-4078-8594-bcb73697b89f",{"status":"Accepted","currentTime":"2019-05-24T05:00:01.644Z","heartbeatInterval":14400}]
<<[2, "3278b363-e01a-453f-a2f3-f30aad4b5266", "Heartbeat", {}]
<<[2, "0f889413-9728-4af7-9f8e-32be374be54d", "StatusNotification", {"connectorId": 1, "vendorId": "com.ibeyonde.ev", "timestamp": "2019-05-24T05:00:01.641277", "status": "Available", "vendorErrorCode": "", "errorCode": "NoError", "info": ""}]


SERVER LOGS [ Admin Console ]

[DEBUG] 2019-05-24 09:38:42,334 org.jooq.tools.LoggerListener (qtp977674685-20104) - Fetched row(s) : 6
[DEBUG] 2019-05-24 09:38:42,334 org.jooq.tools.LoggerListener (qtp977674685-20104) - : |...record(s) truncated...
[DEBUG] 2019-05-24 09:38:42,334 org.jooq.tools.LoggerListener (qtp977674685-20104) - : +-------------+-------------+------------+------------------------+---------+--------+
[DEBUG] 2019-05-24 09:38:42,334 org.jooq.tools.LoggerListener (qtp977674685-20104) - : | 4|QWHzxHPUwG | 1|2019-05-06T10:38:13.478Z|Available|NoError |
[DEBUG] 2019-05-24 09:38:42,334 org.jooq.tools.LoggerListener (qtp977674685-20104) - : | 3|bdv4HS2zsF | 1|2019-05-06T18:28:02.902Z|Available|NoError |
[DEBUG] 2019-05-24 09:38:42,334 org.jooq.tools.LoggerListener (qtp977674685-20104) - : | 2|fik7MPyL9g | 0|2019-05-08T05:48:00.475Z|Available|NoError |
[DEBUG] 2019-05-24 09:38:42,334 org.jooq.tools.LoggerListener (qtp977674685-20104) - : | 2|fik7MPyL9g | 1|2019-05-15T02:01:04.904Z|Available|NoError |
[DEBUG] 2019-05-24 09:38:42,334 org.jooq.tools.LoggerListener (qtp977674685-20104) - : | 1|c19023d3 | 1|2019-05-24T09:00:02.474Z|Available|NoError |
[DEBUG] 2019-05-24 09:38:42,334 org.jooq.tools.LoggerListener (qtp977674685-20104) - : +-------------+-------------+------------+------------------------+---------+--------+
[DEBUG] 2019-05-24 09:38:42,334 org.jooq.tools.LoggerListener (qtp977674685-20104) - : |charge_box_pk|charge_box_id|connector_id|t2_ts |t2_status|t2_error|
[DEBUG] 2019-05-24 09:38:42,334 org.jooq.tools.LoggerListener (qtp977674685-20104) - Fetched result : +-------------+-------------+------------+------------------------+---------+--------+
[DEBUG] 2019-05-24 09:38:42,331 org.jooq.tools.LoggerListener (qtp977674685-20104) - Executing query : select `stevedb`.`charge_box`.`charge_box_pk`, `stevedb`.`connector`.`charge_box_id`, `stevedb`.`connector`.`connector_id`, `t2`.`t2_ts`, `t2`.`t2_status`, `t2`.`t2_error` from (select distinct `stevedb`.`connector_status`.`connector_pk` as `t2_pk`, `stevedb`.`connector_status`.`status_timestamp` as `t2_ts`, `stevedb`.`connector_status`.`status` as `t2_status`, `stevedb`.`connector_status`.`error_code` as `t2_error` from `stevedb`.`connector_status` join (select `stevedb`.`connector_status`.`connector_pk` as `t1_pk`, max(`stevedb`.`connector_status`.`status_timestamp`) as `t1_ts_max` from `stevedb`.`connector_status` group by `stevedb`.`connector_status`.`connector_pk`) as `t1` on (`stevedb`.`connector_status`.`connector_pk` = `t1`.`t1_pk` and `stevedb`.`connector_status`.`status_timestamp` = `t1`.`t1_ts_max`)) as `t2` join `stevedb`.`connector` on `stevedb`.`connector`.`connector_pk` = `t2`.`t2_pk` join `stevedb`.`charge_box` on `stevedb`.`charge_box`.`charge_box_id` = `stevedb`.`connector`.`charge_box_id` where 1 = 1 order by `t2`.`t2_ts` desc
[DEBUG] 2019-05-24 09:38:42,330 org.jooq.tools.LoggerListener (qtp977674685-20104) - Fetched row(s) : 1
[DEBUG] 2019-05-24 09:38:42,330 org.jooq.tools.LoggerListener (qtp977674685-20104) - : +----------------+-------------+---------+----------------+----------------+----------------+--------------------+------------------+
[DEBUG] 2019-05-24 09:38:42,330 org.jooq.tools.LoggerListener (qtp977674685-20104) - : | 4| 20| 7| 0| 2| 1| 0| 3|
[DEBUG] 2019-05-24 09:38:42,330 org.jooq.tools.LoggerListener (qtp977674685-20104) - : +----------------+-------------+---------+----------------+----------------+----------------+--------------------+------------------+
[DEBUG] 2019-05-24 09:38:42,330 org.jooq.tools.LoggerListener (qtp977674685-20104) - : |num_charge_boxes|num_ocpp_tags|num_users|num_reservations|num_transactions|heartbeats_today|heartbeats_yesterday|heartbeats_earlier|
[DEBUG] 2019-05-24 09:38:42,330 org.jooq.tools.LoggerListener (qtp977674685-20104) - Fetched result : +----------------+-------------+---------+----------------+----------------+----------------+--------------------+------------------+
[DEBUG] 2019-05-24 09:38:42,327 org.jooq.tools.LoggerListener (qtp977674685-20104) - -> with bind values : select (select count(*) from `stevedb`.`charge_box`) as `num_charge_boxes`, (select count(*) from `stevedb`.`ocpp_tag`) as `num_ocpp_tags`, (select count(*) from `stevedb`.`user`) as `num_users`, (select count(*) from `stevedb`.`reservation` where (`stevedb`.`reservation`.`expiry_datetime` > {ts '2019-05-24 09:38:42.327'} and `stevedb`.`reservation`.`status` = 'ACCEPTED')) as `num_reservations`, (select count(*) from `stevedb`.`transaction` where `stevedb`.`transaction`.`stop_timestamp` is null) as `num_transactions`, (select count(*) from `stevedb`.`charge_box` where date(`stevedb`.`charge_box`.`last_heartbeat_timestamp`) = date({ts '2019-05-24 09:38:42.327'})) as `heartbeats_today`, (select count(*) from `stevedb`.`charge_box` where date(`stevedb`.`charge_box`.`last_heartbeat_timestamp`) = date({ts '2019-05-23 09:38:42.327'})) as `heartbeats_yesterday`, (select count(*) from `stevedb`.`charge_box` where date(`stevedb`.`charge_box`.`last_heartbeat_timestamp`) < date({ts '2019-05-23 09:38:42.327'})) as `heartbeats_earlier` from dual
[DEBUG] 2019-05-24 09:38:42,327 org.jooq.tools.LoggerListener (qtp977674685-20104) - Executing query : select (select count(*) from `stevedb`.`charge_box`) as `num_charge_boxes`, (select count(*) from `stevedb`.`ocpp_tag`) as `num_ocpp_tags`, (select count(*) from `stevedb`.`user`) as `num_users`, (select count(*) from `stevedb`.`reservation` where (`stevedb`.`reservation`.`expiry_datetime` > ? and `stevedb`.`reservation`.`status` = ?)) as `num_reservations`, (select count(*) from `stevedb`.`transaction` where `stevedb`.`transaction`.`stop_timestamp` is null) as `num_transactions`, (select count(*) from `stevedb`.`charge_box` where date(`stevedb`.`charge_box`.`last_heartbeat_timestamp`) = date(?)) as `heartbeats_today`, (select count(*) from `stevedb`.`charge_box` where date(`stevedb`.`charge_box`.`last_heartbeat_timestamp`) = date(?)) as `heartbeats_yesterday`, (select count(*) from `stevedb`.`charge_box` where date(`stevedb`.`charge_box`.`last_heartbeat_timestamp`) < date(?)) as `heartbeats_earlier` from dual
[DEBUG] 2019-05-24 09:30:02,481 org.jooq.tools.LoggerListener (qtp977674685-20095) - Affected row(s) : 1
[DEBUG] 2019-05-24 09:30:02,473 org.jooq.tools.LoggerListener (qtp977674685-20095) - -> with bind values : update `stevedb`.`charge_box` set `stevedb`.`charge_box`.`last_heartbeat_timestamp` = {ts '2019-05-24 09:30:02.473'} where `stevedb`.`charge_box`.`charge_box_id` = 'c19023d3'
[DEBUG] 2019-05-24 09:30:02,473 org.jooq.tools.LoggerListener (qtp977674685-20095) - Executing query : update `stevedb`.`charge_box` set `stevedb`.`charge_box`.`last_heartbeat_timestamp` = ? where `stevedb`.`charge_box`.`charge_box_id` = ?
[DEBUG] 2019-05-24 09:30:02,473 de.rwth.idsg.steve.ocpp.ws.WebSocketLogger (qtp977674685-20095) - [chargeBoxId=c19023d3, sessionId=3f8cbb0e] Received pong message
[DEBUG] 2019-05-24 09:30:02,472 de.rwth.idsg.steve.ocpp.ws.WebSocketLogger (SteVe-Executor-0) - [chargeBoxId=c19023d3, sessionId=3f8cbb0e] Sending ping message
[DEBUG] 2019-05-24 09:15:02,481 org.jooq.tools.LoggerListener (qtp977674685-20095) - Affected row(s) : 1
[DEBUG] 2019-05-24 09:15:02,473 org.jooq.tools.LoggerListener (qtp977674685-20095) - -> with bind values : update `stevedb`.`charge_box` set `stevedb`.`charge_box`.`last_heartbeat_timestamp` = {ts '2019-05-24 09:15:02.473'} where `stevedb`.`charge_box`.`charge_box_id` = 'c19023d3'
[DEBUG] 2019-05-24 09:15:02,473 org.jooq.tools.LoggerListener (qtp977674685-20095) - Executing query : update `stevedb`.`charge_box` set `stevedb`.`charge_box`.`last_heartbeat_timestamp` = ? where `stevedb`.`charge_box`.`charge_box_id` = ?
[DEBUG] 2019-05-24 09:15:02,473 de.rwth.idsg.steve.ocpp.ws.WebSocketLogger (qtp977674685-20095) - [chargeBoxId=c19023d3, sessionId=3f8cbb0e] Received pong message