user82037: I have some arduino code where I am trying to pull information from four different locations.  Three are working great and the fourth I am not getting any response.
These two strings work perfect in a browser and I get the proper data response.
http ://10.196.1.163:8086/query?db=Garden&q=SELECT * FROM "Station" WHERE station = 61 ORDER BY DESC LIMIT 1
Or
http://10.197.1.57:8086/query?db=Garden&q=SELECT%20*%20FROM%20%22Station%22%20WHERE%20station%20=%2091%20ORDER%20BY%20DESC%20LIMIT%201

{"results":[{"statement_id":0,"series":[{"name":"Station","columns":["time","altitude","humid","moist","press","rainfall","soiltemp","station","temp","type","vbat","winddir","windspeed"],"values":[["2022-01-08T21:13:58Z",1269,29.2,0,28.5,0,0,91,73.4,9,4.32,0,0]]}]}]}

The code below is what I am trying to use.  It appears to make the connection but brings nothing back.
What I see in the console is:
  19:55:42.024 -> Starting connection to server: 10.196.1.163 InfluxDB Garden DB...
  19:55:42.024 -> connected to server
  19:55:42.024 ->

The next line is starting to connect to the next server which brings back the JSON data fine.
I have been assuming that I was having issues because of the alternate port 8086 I was connecting to, but I am not sure.  I have been looking and finding examples similar to what I am doing.
I must be just missing something, but I am not sure what. I have been working off and on for this issue for a couple of months.
void getLocalDataQuery2() {
  Serial.println("\nStarting connection to server: 10.196.1.163 InfluxDB Garden DB...");
  if (client.connect(server2, 8086)) {
    Serial.println("connected to server");
    client.print("GET /query?");
    client.print("db=Garden");
    client.println("&q=SELECT%20*%20FROM%20%22Station%22%20WHERE%20station%20=%2091%20ORDER%20BY%20DESC%20LIMIT%201");
    client.println("Host: 10.196.1.163");
    client.println("Connection: close");
    client.println();
  } else {
    Serial.println("unable to connect");
    while (WiFi.begin(ssid, pass) != WL_CONNECTED) {
      // unsuccessful, retry in 4 seconds
      Serial.print("failed ... ");
      delay(4000);
      Serial.print("retrying ... ");
    }
  }
  String line = "";

  while(client.available())
  {
    line = client.readStringUntil('\n');

    Serial.print("Line : ");
    Serial.println(line);
  }
}


user82037: My solution to this was to setup a webserver running php code in a Docker container. The php code ran the influxdb query and sends the results

82037: <p>I have some arduino code where I am trying to pull information from four different locations.  Three are working great and the fourth I am not getting any response.</p>
<p>These two strings work perfect in a browser and I get the proper data response.
http ://10.196.1.163:8086/query?db=Garden&amp;q=SELECT * FROM &quot;Station&quot; WHERE station = 61 ORDER BY DESC LIMIT 1
Or
<a href="http://10.197.1.57:8086/query?db=Garden&amp;q=SELECT%20*%20FROM%20%22Station%22%20WHERE%20station%20=%2091%20ORDER%20BY%20DESC%20LIMIT%201" rel="nofollow noreferrer">http://10.197.1.57:8086/query?db=Garden&amp;q=SELECT%20*%20FROM%20%22Station%22%20WHERE%20station%20=%2091%20ORDER%20BY%20DESC%20LIMIT%201</a></p>
<blockquote>
<p>{&quot;results&quot;:[{&quot;statement_id&quot;:0,&quot;series&quot;:[{&quot;name&quot;:&quot;Station&quot;,&quot;columns&quot;:[&quot;time&quot;,&quot;altitude&quot;,&quot;humid&quot;,&quot;moist&quot;,&quot;press&quot;,&quot;rainfall&quot;,&quot;soiltemp&quot;,&quot;station&quot;,&quot;temp&quot;,&quot;type&quot;,&quot;vbat&quot;,&quot;winddir&quot;,&quot;windspeed&quot;],&quot;values&quot;:[[&quot;2022-01-08T21:13:58Z&quot;,1269,29.2,0,28.5,0,0,91,73.4,9,4.32,0,0]]}]}]}</p>
</blockquote>
<p>The code below is what I am trying to use.  It appears to make the connection but brings nothing back.</p>
<p>What I see in the console is:</p>
<pre><code>  19:55:42.024 -&gt; Starting connection to server: 10.196.1.163 InfluxDB Garden DB...
  19:55:42.024 -&gt; connected to server
  19:55:42.024 -&gt;
</code></pre>
<p>The next line is starting to connect to the next server which brings back the JSON data fine.
I have been assuming that I was having issues because of the alternate port 8086 I was connecting to, but I am not sure.  I have been looking and finding examples similar to what I am doing.</p>
<p>I must be just missing something, but I am not sure what. I have been working off and on for this issue for a couple of months.</p>
<pre><code>void getLocalDataQuery2() {
  Serial.println(&quot;\nStarting connection to server: 10.196.1.163 InfluxDB Garden DB...&quot;);
  if (client.connect(server2, 8086)) {
    Serial.println(&quot;connected to server&quot;);
    client.print(&quot;GET /query?&quot;);
    client.print(&quot;db=Garden&quot;);
    client.println(&quot;&amp;q=SELECT%20*%20FROM%20%22Station%22%20WHERE%20station%20=%2091%20ORDER%20BY%20DESC%20LIMIT%201&quot;);
    client.println(&quot;Host: 10.196.1.163&quot;);
    client.println(&quot;Connection: close&quot;);
    client.println();
  } else {
    Serial.println(&quot;unable to connect&quot;);
    while (WiFi.begin(ssid, pass) != WL_CONNECTED) {
      // unsuccessful, retry in 4 seconds
      Serial.print(&quot;failed ... &quot;);
      delay(4000);
      Serial.print(&quot;retrying ... &quot;);
    }
  }
  String line = &quot;&quot;;

  while(client.available())
  {
    line = client.readStringUntil('\n');

    Serial.print(&quot;Line : &quot;);
    Serial.println(line);
  }
}
</code></pre>
 82037: <p>My solution to this was to setup a webserver running php code in a Docker container. The php code ran the influxdb query and sends the results</p>
