Connectionerror client 8086

InfluxDB 2 Dashboards
,
1

Maybe I am missing something here. I can connect from a remote system to the admin 8083 port but when I go to connect to the API port for 8086 from curl or python I get connectionerror!!!

I can not find anywhere in log files to tell me what is going on. I can connect just fine on 8086 if I am localhost but coming from the same subnet to the box with influxdb I can hit 8083 and 8086 with web browser. One would think if you can see 8083 and do queries on 8083 & 8086 with chrome then you should be able to also do queries on API port 8086 with curl or python too from that same IP Number!

Use python / curl for API 8086 I get Permission denied if it is not localhost. Why would this be? What configuration do I need to change to allow the connection??

Has anyone else run into this issue? I am on 1.2 version

2

@RobHouston you mention a subnet in the post. Are you running on AWS? Have you checked your security groups?

3

Private self hosted network of many different kinds of systems. No cloud outsourcing.

4

@RobHouston Can you share the python code you are using to connect to the database?

5

sure… python 2.7 error same as python 3.6 error. Here is my test code for 2.7. NOTE this is coming from 192.168.1.249 not 95 and it dose not care what IP it is! The code work no problems if localhost or 192.168.1.95 on the local system but not remote connection!!! I do not understand what is going on or why it will not connect…

IP: 192.168.1.249
Traceback (most recent call last):
  File "pyt.py", line 16, in <module>
    main()
  File "pyt.py", line 12, in main
    df = pd.DataFrame(client.query(q, chunked=True, chunk_size=10000).get_points(),columns = ['time', 'Sell'])
  File "/usr/local/lib/python2.7/site-packages/influxdb/client.py", line 381, in query
    expected_response_code=expected_response_code
  File "/usr/local/lib/python2.7/site-packages/influxdb/client.py", line 256, in request
    raise requests.exceptions.ConnectionError

here is error for 3.6

IP: 192.168.1.249
Traceback (most recent call last):
  File "pyt.py", line 16, in <module>
    main()
  File "pyt.py", line 12, in main
    df = pd.DataFrame(client.query(q, chunked=True, chunk_size=10000).get_points(),columns = ['time', 'Sell'])
  File "/usr/local/lib/python3.6/site-packages/influxdb/client.py", line 381, in query
    expected_response_code=expected_response_code
  File "/usr/local/lib/python3.6/site-packages/influxdb/client.py", line 256, in request
    raise requests.exceptions.ConnectionError
requests.exceptions.ConnectionError

The python test code is:

import sys
import influxdb
import pandas as pd


def main():
    client = influxdb.InfluxDBClient(host='192.168.1.95', port=8086, username='fx', password='testme', database='ticks')
    client.switch_database('ticks')

    q = "SELECT * FROM tick fill(none)"

    df = pd.DataFrame(client.query(q, chunked=True, chunk_size=10000).get_points(),columns = ['time', 'Sell'])
    print(df)

if __name__ == '__main__':
    main()