search

pedrolbacelar / Digital_Twin

6 stars 0 forks source link

Database running, but can not write to it #12

Closed alexlona closed 1 year ago

alexlona commented 1 year ago

code 

from influx import InfluxDB
#-- connect to database
db = InfluxDB('http://192.168.50:8086',precision='ms')

NOME_DATABASE = "lego"
# db.write(NOME_DATABASE,'machine_state', fields={"event": "h", "th": 100})
db.write(NOME_DATABASE,'machine_state', fields={"th": 10}, tags={"activity":6})
db.write(NOME_DATABASE,'machine_state', fields={"th": 10, "event": "evento"}, tags={"activity":6})

temp = db.select_recent(NOME_DATABASE, 'machine_state')
print(temp)

error

Traceback (most recent call last):
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\urllib3\connection.py", line 174, in _new_conn
    conn = connection.create_connection(
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\urllib3\util\connection.py", line 72, in create_connection    
    for res in socket.getaddrinfo(host, port, family, socket.SOCK_STREAM):
  File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.10_3.10.2032.0_x64__qbz5n2kfra8p0\lib\socket.py", line 955, in getaddrinfo
    for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
socket.gaierror: [Errno 11001] getaddrinfo failed

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\urllib3\connectionpool.py", line 703, in urlopen
    httplib_response = self._make_request(
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\urllib3\connectionpool.py", line 398, in _make_request        
    conn.request(method, url, **httplib_request_kw)
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\urllib3\connection.py", line 239, in request
    super(HTTPConnection, self).request(method, url, body=body, headers=headers)
  File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.10_3.10.2032.0_x64__qbz5n2kfra8p0\lib\http\client.py", line 1282, in request
    self._send_request(method, url, body, headers, encode_chunked)
  File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.10_3.10.2032.0_x64__qbz5n2kfra8p0\lib\http\client.py", line 1328, in _send_request
    self.endheaders(body, encode_chunked=encode_chunked)
  File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.10_3.10.2032.0_x64__qbz5n2kfra8p0\lib\http\client.py", line 1277, in endheaders
    self._send_output(message_body, encode_chunked=encode_chunked)
  File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.10_3.10.2032.0_x64__qbz5n2kfra8p0\lib\http\client.py", line 1037, in _send_output
    self.send(msg)
  File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.10_3.10.2032.0_x64__qbz5n2kfra8p0\lib\http\client.py", line 975, in send
    self.connect()
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\urllib3\connection.py", line 205, in connect
    conn = self._new_conn()
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\urllib3\connection.py", line 186, in _new_conn
    raise NewConnectionError(
urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPConnection object at 0x0000025BE4196440>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\requests\adapters.py", line 489, in send
    resp = conn.urlopen(
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\urllib3\connectionpool.py", line 787, in urlopen
    retries = retries.increment(
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\urllib3\util\retry.py", line 592, in increment
    raise MaxRetryError(_pool, url, error or ResponseError(cause))
urllib3.exceptions.MaxRetryError: HTTPConnectionPool(host='192.168.50', port=8086): Max retries exceeded with url: /write?db=lego&precision=ms (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x0000025BE4196440>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "d:\POLIMI\Digital twins\Digital_Twin\influx_tests.py", line 8, in <module>
    db.write(NOME_DATABASE,'machine_state', fields={"th": 10}, tags={"activity":6})
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\influx\__init__.py", line 149, in write
    resp = self._safe_request(IQL_WRITE, database=database, lines=lines)
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\influx\__init__.py", line 429, in _safe_request
    resp = self._make_request(*args, **kwargs)
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\influx\__init__.py", line 511, in _make_request
    return self.session.request(method, url, params=params, data=data,
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\requests\sessions.py", line 587, in request
    resp = self.send(prep, **send_kwargs)
    r = adapter.send(request, **kwargs)
    raise ConnectionError(e, request=request)
requests.exceptions.ConnectionError: HTTPConnectionPool(host='192.168.50', port=8086): Max retries exceeded with url: /write?db=ablish a new connection: [Errno 11001] getaddrinfo failed'))
Twin/influx_tests.py"
Twin/influx_tests.py"
'hi
PS D:\POLIMI\Digital twins\dtenv> & C:/Users/HP/.virtualenvs/dtenv-W_8IhJJT/Scripts/python.exe "d:/POLIMI/Digital twins/Digital_Twin/influx_tests.py"
PS D:\POLIMI\Digital twins\dtenv> & C:/Users/HP/.virtualenvs/dtenv-W_8IhJJT/Scripts/python.exe "d:/POLIMI/Digital twins/Digital_Twin/influx_tests.py"
PS D:\POLIMI\Digital twins\dtenv> & C:/Users/HP/.virtualenvs/dtenv-W_8IhJJT/Scripts/python.exe "d:/POLIMI/Digital twins/Digital_Twin/influx_tests.py"
Traceback (most recent call last):
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\urllib3\connection.py", line 174, in _new_conn
    conn = connection.create_connection(
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\urllib3\util\connection.py", line 72, in create_connection    
    for res in socket.getaddrinfo(host, port, family, socket.SOCK_STREAM):
  File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.10_3.10.2032.0_x64__qbz5n2kfra8p0\lib\socket.py", line 955, in getaddrinfo
    for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
socket.gaierror: [Errno 11001] getaddrinfo failed

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\urllib3\connectionpool.py", line 703, in urlopen
    httplib_response = self._make_request(
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\urllib3\connectionpool.py", line 398, in _make_request        
    conn.request(method, url, **httplib_request_kw)
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\urllib3\connection.py", line 239, in request
    super(HTTPConnection, self).request(method, url, body=body, headers=headers)
  File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.10_3.10.2032.0_x64__qbz5n2kfra8p0\lib\http\client.py", line 1282, in request
    self._send_request(method, url, body, headers, encode_chunked)
  File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.10_3.10.2032.0_x64__qbz5n2kfra8p0\lib\http\client.py", line 1328, in _send_request
    self.endheaders(body, encode_chunked=encode_chunked)
  File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.10_3.10.2032.0_x64__qbz5n2kfra8p0\lib\http\client.py", line 1277, in endheaders
    self._send_output(message_body, encode_chunked=encode_chunked)
  File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.10_3.10.2032.0_x64__qbz5n2kfra8p0\lib\http\client.py", line 1037, in _send_output
    self.send(msg)
  File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.10_3.10.2032.0_x64__qbz5n2kfra8p0\lib\http\client.py", line 975, in send
    self.connect()
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\urllib3\connection.py", line 205, in connect
    conn = self._new_conn()
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\urllib3\connection.py", line 186, in _new_conn
    raise NewConnectionError(
urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPConnection object at 0x0000027515A96440>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\requests\adapters.py", line 489, in send
    resp = conn.urlopen(
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\urllib3\connectionpool.py", line 787, in urlopen
    retries = retries.increment(
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\urllib3\util\retry.py", line 592, in increment
    raise MaxRetryError(_pool, url, error or ResponseError(cause))
urllib3.exceptions.MaxRetryError: HTTPConnectionPool(host='192.168.50', port=8086): Max retries exceeded with url: /write?db=lego&precision=ms (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x0000027515A96440>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "d:\POLIMI\Digital twins\Digital_Twin\influx_tests.py", line 7, in <module>
    db.write(NOME_DATABASE,'machine_state', fields={"th": 10}, tags={"activity":6})
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\influx\__init__.py", line 149, in write
    resp = self._safe_request(IQL_WRITE, database=database, lines=lines)
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\influx\__init__.py", line 429, in _safe_request
    resp = self._make_request(*args, **kwargs)
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\influx\__init__.py", line 511, in _make_request
    return self.session.request(method, url, params=params, data=data,
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\requests\sessions.py", line 587, in request
    resp = self.send(prep, **send_kwargs)
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\requests\sessions.py", line 701, in send
    r = adapter.send(request, **kwargs)
  File "C:\Users\HP\.virtualenvs\dtenv-W_8IhJJT\lib\site-packages\requests\adapters.py", line 565, in send
    raise ConnectionError(e, request=request)
requests.exceptions.ConnectionError: HTTPConnectionPool(host='192.168.50', port=8086): Max retries exceeded with url: /write?db=lego&precision=ms (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x0000027515A96440>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))
alexlona commented 1 year ago

The IP was wrong . Correct IP:

http://192.168.50:8086