setting up in Docker for Windows

[eelton]

Docker newbie here...

I'm trying to set up vuegraf using Docker in Windows 11. I have influxDB 2 set up, and vuegraf is running in Docker without any error messages. When I open influxDB, the energy dashboard is there, but it says "no data," and shows that I have no queries.

I suspect it may be that I don't have the command to run vuegraf correct, or that I have an error in my configuration file. This is the command I'm using (vuegraf.json is in C:\Users\eelto\vuegraf):

docker run --name vuegraf -d -v c/Users/eelto/vuegraf:/opt/vuegraf/conf jertel/vuegraf

I've tried variations of this, using double slashes, backslashes, putting the Windows file location in quotes, etc.

My configuration file is below, with redactions. The Emporia Vue credentials are correct--that is, they work to log in on the app or website. I would appreciate any advice!

{
    "influxDb": {
        "version": 2,
        "url": "http://localhost:8086",
        "org": "vuegraf",
        "bucket": "vuegraf",
        "token": "CtDtooPaSY9IUS-80wupY9vSmh5Ummb41hIWl1ykGfGC9XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
        "reset": false
    },
    "accounts": [
        {
            "name": "Primary Residence",
            "email": "XXXXX@XXX.com",
            "password": "XXXXXXX",
            "devices": [
                {
                    "name": "utility panel",
                    "channels": [
                        "1st fl air hand mezz",
                        "2nd fl air hand laundry",
                        "heat pump 1",
                        "",
                        "Tesla charger",
                        "oven",
                        "dishwasher",
                        "1st fl Zehnder",
                        "2nd fl Zehnder",
                        "dryer",
                        "water filter",
                        "heat pump 2",
                        "solar 1",
                        "solar 2"
                    ]
                },
                {
                    "name": "generator panel",
                    "channels": [
                        "media rm outlets",
                        "2nd floor lights A",
                        "2nd floor lights B",
                        "2nd floor lights C",
                        "toilet outlets",
                        "hot tub",
                        "washing machine",
                        "cooktop", 
                        "1st floor lights A", 
                        "1st floor lights B",
                        "1st floor lights C",
                        "boiler",
                        "freezer",
                        "refrigerator",
                        "well pump",
                        "sewer pump"
                         
                    ]
                }
            ]
        }
    ]
}

[jertel]

Run docker logs vuegraf to see what's happening with Vuegraf. This is what a healthy Vuegraf log looks like:

2023-02-05 14:23:43.850401 | INFO  | Using InfluxDB version 2
2023-02-05 14:23:43.879676 | INFO  | Settings -> updateIntervalSecs: 60, detailedEnabled: True, detailedIntervalSecs: 3600
2023-02-05 14:23:46.902752 | INFO  | Login completed
2023-02-05 14:23:47.119096 | INFO  | Discovered new channel: Right Panel (1,2,3)
2023-02-05 14:23:47.230236 | INFO  | Discovered new channel: Main A/C (1)
2023-02-05 14:23:47.230273 | INFO  | Discovered new channel: 2nd Furnace (2)
2023-02-05 14:23:47.230286 | INFO  | Discovered new channel: Water Heater (3)
2023-02-05 14:23:47.230298 | INFO  | Discovered new channel: Barn Left (4)
2023-02-05 14:23:47.230309 | INFO  | Discovered new channel: Pool Vacuum (5)
2023-02-05 14:23:47.230322 | INFO  | Discovered new channel: Pool Filter (6)
2023-02-05 14:23:47.230333 | INFO  | Discovered new channel: Refrigerator (7)
2023-02-05 14:23:47.230342 | INFO  | Discovered new channel: Oven (8)
2023-02-05 14:23:47.347797 | INFO  | Discovered new channel: Left Panel (1,2,3)
2023-02-05 14:23:47.473952 | INFO  | Discovered new channel: Dryer (1)
2023-02-05 14:23:47.473990 | INFO  | Discovered new channel: Washer (2)
2023-02-05 14:23:47.474001 | INFO  | Discovered new channel: Theater (3)
2023-02-05 14:23:47.474010 | INFO  | Discovered new channel: 2nd A/C (4)
2023-02-05 14:23:47.474020 | INFO  | Discovered new channel: Main Furnace (5)
2023-02-05 14:23:47.474030 | INFO  | Discovered new channel: Freezer (6)
2023-02-05 14:23:47.474039 | INFO  | Discovered new channel: Garage (7)
2023-02-05 14:23:47.474049 | INFO  | Discovered new channel: Sprinklers (8)
2023-02-05 14:23:47.596553 | INFO  | Submitting datapoints to database; account="Jason Ertel"; points=20
2023-02-05 14:24:47.798219 | INFO  | Submitting datapoints to database; account="Jason Ertel"; points=20

Also, I suggest renaming your two devices to use proper casing, so that the dashboard works without any modification. Ex:

Utility Panel
Generator Panel

You will need to update these in the Emporia app, and in the vuegraf.json.

[eelton]

Thanks for the reply.

I didn't realize the panel names were case sensitive, so I made that change in the Emporia app and in vuegraf.json.

Here is the log file. It starts out as above, but then hits "failed to record new data usage data":

2023-02-05 14:34:50.936798 | INFO  | Settings -> updateIntervalSecs: 60, detailedEnabled: False, detailedIntervalSecs: 3600
2023-02-05 14:34:53.701073 | INFO  | Login completed
2023-02-05 14:34:55.048445 | INFO  | Discovered new channel: Utility Panel (1,2,3)
2023-02-05 14:34:55.501137 | INFO  | Discovered new channel: 1st fl air hand mezz (1)
2023-02-05 14:34:55.501211 | INFO  | Discovered new channel: 2nd flr air hand laundry (2)
2023-02-05 14:34:55.501226 | INFO  | Discovered new channel: 2nd floor air hand util (3)
2023-02-05 14:34:55.501236 | INFO  | Discovered new channel: heat pump 1 (4)
2023-02-05 14:34:55.501246 | INFO  | Discovered new channel:  (5)
2023-02-05 14:34:55.501256 | INFO  | Discovered new channel: Tesla charger (6)
2023-02-05 14:34:55.501263 | INFO  | Discovered new channel: oven (7)
2023-02-05 14:34:55.501271 | INFO  | Discovered new channel: dishwasher (8)
2023-02-05 14:34:55.501277 | INFO  | Discovered new channel: 1st FL Zehnder (9)
2023-02-05 14:34:55.501285 | INFO  | Discovered new channel: 2nd floor Zehnder (10)
2023-02-05 14:34:55.501292 | INFO  | Discovered new channel: dryer (11)
2023-02-05 14:34:55.501298 | INFO  | Discovered new channel: water filter (12)
2023-02-05 14:34:55.501305 | INFO  | Discovered new channel: heat pump 2 (13)
2023-02-05 14:34:55.501312 | INFO  | Discovered new channel: solar 1 (14)
2023-02-05 14:34:55.501319 | INFO  | Discovered new channel: solar 2 (15)
2023-02-05 14:34:55.501332 | INFO  | Discovered new channel: None (16)
2023-02-05 14:34:55.861083 | INFO  | Discovered new channel: Generator Panel (1,2,3)
2023-02-05 14:34:56.232552 | INFO  | Discovered new channel: media rm outlets (1)
2023-02-05 14:34:56.232624 | INFO  | Discovered new channel: 2nd floor lights A (2)
2023-02-05 14:34:56.232638 | INFO  | Discovered new channel: 2nd floor lights B (3)
2023-02-05 14:34:56.232647 | INFO  | Discovered new channel: 2nd floor lights C (4)
2023-02-05 14:34:56.232654 | INFO  | Discovered new channel: toilet outlets (5)
2023-02-05 14:34:56.232661 | INFO  | Discovered new channel: hot tub (6)
2023-02-05 14:34:56.232668 | INFO  | Discovered new channel: washing machine (7)
2023-02-05 14:34:56.232675 | INFO  | Discovered new channel: cooktop (8)
2023-02-05 14:34:56.232681 | INFO  | Discovered new channel: 1st floor lights A (9)
2023-02-05 14:34:56.232688 | INFO  | Discovered new channel: 1st floor lights B (10)
2023-02-05 14:34:56.232695 | INFO  | Discovered new channel: 1st floor lights C (11)
2023-02-05 14:34:56.232702 | INFO  | Discovered new channel: boiler  (12)
2023-02-05 14:34:56.232709 | INFO  | Discovered new channel: freezer (13)
2023-02-05 14:34:56.232715 | INFO  | Discovered new channel: refrigerator (14)
2023-02-05 14:34:56.232722 | INFO  | Discovered new channel: well pump (15)
2023-02-05 14:34:56.232730 | INFO  | Discovered new channel: sewer pump (16)
2023-02-05 14:34:56.799916 | INFO  | Submitting datapoints to database; account="Primary Residence"; points=35
2023-02-05 14:34:56.802444 | ERROR | Failed to record new usage data: (<class 'urllib3.exceptions.NewConnectionError'>, NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7f686852f950>: Failed to establish a new connection: [Errno 111] Connection refused'), <traceback object at 0x7f68684c8800>)
Traceback (most recent call last):
  File "/usr/local/lib/python3.11/site-packages/urllib3/connection.py", line 174, in _new_conn
    conn = connection.create_connection(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/urllib3/util/connection.py", line 95, in create_connection
    raise err
  File "/usr/local/lib/python3.11/site-packages/urllib3/util/connection.py", line 85, in create_connection
    sock.connect(sa)
ConnectionRefusedError: [Errno 111] Connection refused

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/opt/vuegraf/vuegraf.py", line 282, in <module>
    write_api.write(bucket=bucket, record=usageDataPoints)
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/client/write_api.py", line 374, in write
    results = list(map(write_payload, payloads.items()))
              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/client/write_api.py", line 372, in write_payload
    return self._post_write(_async_req, bucket, org, final_string, payload[0])
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/client/write_api.py", line 483, in _post_write
    return self._write_service.post_write(org=org, bucket=bucket, body=body, precision=precision,
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/service/write_service.py", line 60, in post_write
    (data) = self.post_write_with_http_info(org, bucket, body, **kwargs)  # noqa: E501
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/service/write_service.py", line 90, in post_write_with_http_info
    return self.api_client.call_api(
           ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/_sync/api_client.py", line 343, in call_api
    return self.__call_api(resource_path, method,
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/_sync/api_client.py", line 173, in __call_api
    response_data = self.request(
                    ^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/_sync/api_client.py", line 388, in request
    return self.rest_client.POST(url,
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/_sync/rest.py", line 311, in POST
    return self.request("POST", url,
           ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/_sync/rest.py", line 220, in request
    r = self.pool_manager.request(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/urllib3/request.py", line 78, in request
    return self.request_encode_body(
           ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/urllib3/request.py", line 170, in request_encode_body
    return self.urlopen(method, url, **extra_kw)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/urllib3/poolmanager.py", line 376, in urlopen
    response = conn.urlopen(method, u.request_uri, **kw)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/urllib3/connectionpool.py", line 787, in urlopen
    retries = retries.increment(
              ^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/urllib3/util/retry.py", line 525, in increment
    raise six.reraise(type(error), error, _stacktrace)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/urllib3/packages/six.py", line 770, in reraise
    raise value
  File "/usr/local/lib/python3.11/site-packages/urllib3/connectionpool.py", line 703, in urlopen
    httplib_response = self._make_request(
                       ^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/urllib3/connectionpool.py", line 398, in _make_request
    conn.request(method, url, **httplib_request_kw)
  File "/usr/local/lib/python3.11/site-packages/urllib3/connection.py", line 239, in request
    super(HTTPConnection, self).request(method, url, body=body, headers=headers)
  File "/usr/local/lib/python3.11/http/client.py", line 1282, in request
    self._send_request(method, url, body, headers, encode_chunked)
  File "/usr/local/lib/python3.11/http/client.py", line 1328, in _send_request
    self.endheaders(body, encode_chunked=encode_chunked)
  File "/usr/local/lib/python3.11/http/client.py", line 1277, in endheaders
    self._send_output(message_body, encode_chunked=encode_chunked)
  File "/usr/local/lib/python3.11/http/client.py", line 1037, in _send_output
    self.send(msg)
  File "/usr/local/lib/python3.11/http/client.py", line 975, in send
    self.connect()
  File "/usr/local/lib/python3.11/site-packages/urllib3/connection.py", line 205, in connect
    conn = self._new_conn()
           ^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/urllib3/connection.py", line 186, in _new_conn
    raise NewConnectionError(
urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPConnection object at 0x7f686852f950>: Failed to establish a new connection: [Errno 111] Connection refused
2023-02-05 14:35:57.386218 | INFO  | Submitting datapoints to database; account="Primary Residence"; points=35
2023-02-05 14:35:57.387971 | ERROR | Failed to record new usage data: (<class 'urllib3.exceptions.NewConnectionError'>, NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7f68683c2810>: Failed to establish a new connection: [Errno 111] Connection refused'), <traceback object at 0x7f686852e880>)
Traceback (most recent call last):
  File "/usr/local/lib/python3.11/site-packages/urllib3/connection.py", line 174, in _new_conn
    conn = connection.create_connection(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/urllib3/util/connection.py", line 95, in create_connection
    raise err
  File "/usr/local/lib/python3.11/site-packages/urllib3/util/connection.py", line 85, in create_connection
    sock.connect(sa)
ConnectionRefusedError: [Errno 111] Connection refused

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/opt/vuegraf/vuegraf.py", line 282, in <module>
    write_api.write(bucket=bucket, record=usageDataPoints)
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/client/write_api.py", line 374, in write
    results = list(map(write_payload, payloads.items()))
              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/client/write_api.py", line 372, in write_payload
    return self._post_write(_async_req, bucket, org, final_string, payload[0])
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/client/write_api.py", line 483, in _post_write
    return self._write_service.post_write(org=org, bucket=bucket, body=body, precision=precision,
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/service/write_service.py", line 60, in post_write
    (data) = self.post_write_with_http_info(org, bucket, body, **kwargs)  # noqa: E501
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/service/write_service.py", line 90, in post_write_with_http_info
    return self.api_client.call_api(
           ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/_sync/api_client.py", line 343, in call_api
    return self.__call_api(resource_path, method,
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/_sync/api_client.py", line 173, in __call_api
    response_data = self.request(
                    ^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/_sync/api_client.py", line 388, in request
    return self.rest_client.POST(url,
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/_sync/rest.py", line 311, in POST
    return self.request("POST", url,
           ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/influxdb_client/_sync/rest.py", line 220, in request
    r = self.pool_manager.request(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/urllib3/request.py", line 78, in request
    return self.request_encode_body(
           ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/urllib3/request.py", line 170, in request_encode_body
    return self.urlopen(method, url, **extra_kw)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/urllib3/poolmanager.py", line 376, in urlopen
    response = conn.urlopen(method, u.request_uri, **kw)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/urllib3/connectionpool.py", line 787, in urlopen
    retries = retries.increment(
              ^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/urllib3/util/retry.py", line 525, in increment
    raise six.reraise(type(error), error, _stacktrace)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/urllib3/packages/six.py", line 770, in reraise
    raise value
  File "/usr/local/lib/python3.11/site-packages/urllib3/connectionpool.py", line 703, in urlopen
    httplib_response = self._make_request(
                       ^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/urllib3/connectionpool.py", line 398, in _make_request
    conn.request(method, url, **httplib_request_kw)
  File "/usr/local/lib/python3.11/site-packages/urllib3/connection.py", line 239, in request
    super(HTTPConnection, self).request(method, url, body=body, headers=headers)
  File "/usr/local/lib/python3.11/http/client.py", line 1282, in request
    self._send_request(method, url, body, headers, encode_chunked)
  File "/usr/local/lib/python3.11/http/client.py", line 1328, in _send_request
    self.endheaders(body, encode_chunked=encode_chunked)
  File "/usr/local/lib/python3.11/http/client.py", line 1277, in endheaders
    self._send_output(message_body, encode_chunked=encode_chunked)
  File "/usr/local/lib/python3.11/http/client.py", line 1037, in _send_output
    self.send(msg)
  File "/usr/local/lib/python3.11/http/client.py", line 975, in send
    self.connect()
  File "/usr/local/lib/python3.11/site-packages/urllib3/connection.py", line 205, in connect
    conn = self._new_conn()
           ^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/urllib3/connection.py", line 186, in _new_conn
    raise NewConnectionError(
urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPConnection object at 0x7f68683c2810>: Failed to establish a new connection: [Errno 111] Connection refused```

[jertel]

Try changing your influxdb URL in the vuegraf.json file to be your host machine's LAN IP instead of localhost.

[eelton]

That was it--it's now working!

Thanks so much!!