Are you using a Retention Policy?
If so, then you must specify it in the query. For example, if you wrote
into database weewxdb, measurement weemeasure with an RP named '30d', then
you need:
select * from "weewxdb"."30d".weemeasure
This can be simplified a bit WITH the "use" command:
use weewxdb
select * from "30d".weemeasure
Oh, and it must be double quotes ("), not single quotes (').
If you're not using an RP, then I have no idea what's happening. :-)
-tk
On Mon, Oct 16, 2017 at 4:50 PM, Selby Dotter <selbydot...@gmail.com> wrote:
> My weewx installation has been running very well for some time. I'd like
> to bring the data into Grafana so I started with installing InfluxDB and
> the weewx-influx extension. I'm confident data is being written to the
> InfluxDB because of these lines in my weewx log:
>
> Oct 16 16:20:17 selby001 weewx[2101]: restx: Influx: Published record 2017
> -10-16 16:20:00 PDT (1508196000)
>
>
>
>
> As well as the following entries from InfluxDB:
>
>
> Oct 16 16:15:29 selby001 influxd: [httpd] ::1 - - [16/Oct/2017:16:15:29 -
> 0700] "POST /write?db=weewxdb HTTP/1.1" 204 0 "-" "weewx/3.7.1" e6778548-
> b2c7-11e7-8153-000000000000 927
> Oct 16 16:17:48 selby001 influxd: [I] 2017-10-16T23:17:48Z retention
> policy shard deletion check commencing service=retention
> Oct 16 16:20:17 selby001 influxd: [httpd] ::1 - - [16/Oct/2017:16:20:17 -
> 0700] "POST /write?db=weewxdb HTTP/1.1" 204 0 "-" "weewx/3.7.1" 927a6b24-
> b2c8-11e7-8154-000000000000 1556
> Oct 16 16:25:24 selby001 influxd: [httpd] ::1 - - [16/Oct/2017:16:25:24 -
> 0700] "POST /write?db=weewxdb HTTP/1.1" 204 0 "-" "weewx/3.7.1" 4939d9a7-
> b2c9-11e7-8155-000000000000 1124
>
>
> However when I go to the influx CLI I don't see any recognizable data
> written:
>
> # influx -precision rfc3339 -database weewxdb
> Connected to http://localhost:8086 version 1.3.6
> InfluxDB shell version: 1.3.6
> > select * from /.*/
>
> [ ... ]
>
> 2017-10-16T23:20:00Z 29.9975388202 79.5113756123 30.0024403675
> 11331.6904027 <(331)%20690-4027> 1508196000 0 34.4258955614
> <(425)%20895-5614> 83.9333333333 0 83.9333333333 90.32 5
> 17 0 83.9333333333 29.919783335 0
> 0 0 0.3302 3 100 0
> 2440 1 90 90 2.67886214224 2.
> 19474698799 <(947)%20469-8799> 83.9333333333 11.4382221275
> <(438)%20222-1275>
> 2017-10-16T23:25:00Z 29.9975388202 79.4792067931 <(479)%20206-7931>
> 30.0024708277 11292.7108612 1508196300 0 34.6390722107 83.975
> 0 83.975 90.32 5 17.125 0
> 83.975 29.919783335 0 0
> 0 0.3302 3 100 0 2440 1
> 94.8759886405 2.67886214224 2.2930828787 83.975
> 11.6211177098
>
>
> And in grafana all I see is the query builder https://imgur.com/a/3Ezrs
> See the 2nd screenshot indicates the connection is good. Is this what I
> should see in Grafana? If so I will need some sort of reference to the data
> structures like field_key and table names right? I've went through the
> "data exploration" doc for InfluxDB but none of this has proven useful.
>
> Thank you!
>
