[influxdb] Re: Influxdb not running

2017-07-07 Thread patrick . hemmer
I've never used the graphite input, but version 0.8 of InfluxDB is really old, over 2 and a half years. I'd highly recommend using a more recent version, such as 1.2.4 (I do not recommend 1.3.0 due to a number of very significant bugs, but they should be fixed in 1.3.1). -Patrick On Tuesday, J

[influxdb] Re: Telegraf TAG

2017-05-06 Thread patrick . hemmer
You mean add the static value `slot=1` to all emitted points? Use the `tags` config property. See https://docs.influxdata.com/telegraf/v1.2/administration/configuration/#input-config-tags -Patrick On Friday, April 28, 2017 at 2:06:32 PM UTC-4, Paulo Henrique Peres wrote: > Hi, > > > I have the

[influxdb] Re: sum of per data count in time serious

2017-03-09 Thread patrick . hemmer
On Monday, March 6, 2017 at 2:32:28 PM UTC-5, prash@gmail.com wrote: > Hi, > >I am trying to plot a influxDB data into graph using below query > > SELECT count("scur") As "Confluence Current User Session" FROM "haproxy" > WHERE "sv" = 'FRONTEND' AND "proxy" = 'https-confluence' AND $time

[influxdb] Re: [telegraf] exec input plugin permissions issue

2017-03-09 Thread patrick . hemmer
On Monday, March 6, 2017 at 3:46:02 AM UTC-5, gplu...@gmail.com wrote: > Using the exec plugin in Telegraf, I am trying to run a python script > script.py located in "/etc/telegraf/" directory, it runs perfectly as root. > But Telegraf daemon is running as telegraf user and is spitting the follow

[influxdb] Re: Kapacitor cpu alert don't work

2017-03-02 Thread patrick . hemmer
On Monday, February 27, 2017 at 2:50:43 PM UTC-5, Alexander Petrovsky wrote: > Hello! > > > > > [analyzers]# influxd version > InfluxDB v1.1.1 (git: master e47cf1f2e83a02443d7115c54f838be8ee959644) > [analyzers]# telegraf version > Telegraf v1.2.1 (git: release-1.2 3b6ffb344e5c03c1595d862282a68

[influxdb] Re: telegraph, SNMP, and related tables

2017-02-19 Thread patrick . hemmer
On Tuesday, February 14, 2017 at 5:31:32 PM UTC-5, Daniel Rich wrote: > I am trying to collect data from a Cisco switch where some of the data is in > IF-MIB::ifTable and some in IF-MIB::ifXTable but both share the same index. > Is there a way to relate these tables with the new snmp plugin in th

[influxdb] Re: SNMP Plugin - Restricting Interfaces and Data Fields

2017-02-10 Thread patrick . hemmer
On Friday, February 10, 2017 at 9:50:52 AM UTC-5, David Rawling wrote: > On Friday, 10 February 2017 00:48:34 UTC+11, patrick...@gmail.com wrote: > > >    > I'm not sure what documentation you're looking at, but your > configuration is rather off. For example the errors your'e getting are > bec

[influxdb] Re: SNMP input limit to some table oid's

2017-02-09 Thread patrick . hemmer
On Thursday, February 9, 2017 at 12:52:17 PM UTC-5, Willem D'Haese wrote: > Hello, > > > At the moment the SNMP input of Telegraf works fine.  > > > > > [[inputs.snmp]] >   interval = "15s" >   agents = [ "10.10.10.22" ] >   version = 2 >   community = "public" >   [[inputs.snmp.field]] >    

[influxdb] Re: Telegraf SNMP not outputting Data on all OIDS

2017-02-09 Thread patrick . hemmer
On Tuesday, February 7, 2017 at 12:53:18 PM UTC-5, command...@gmail.com wrote: > Hello > > I'm having an issue where Telegraf SNMP plugin isnt outputting data from all > OIDs, im using telegraf version 1.2.1 > > To start im trying to just get the Cisco CPU output with the following OID > > SNMP

[influxdb] Re: SNMP Plugin - Restricting Interfaces and Data Fields

2017-02-09 Thread patrick . hemmer
On Wednesday, February 8, 2017 at 6:42:12 AM UTC-5, David Rawling wrote: > I've been trying for a couple of days now to capture a small subset of the > SNMP data published by a Cisco router. I'm trying to work out a way to > capture the data by interface name (e.g. Et0) rather than SNMP OIDs - th

[influxdb] Re: different field schemes in one measurement

2017-02-08 Thread patrick . hemmer
On Friday, February 3, 2017 at 3:02:42 PM UTC-5, patrick...@gmail.com wrote: > On Friday, February 3, 2017 at 2:59:11 PM UTC-5, patrick...@gmail.com wrote: > > > So that when you do a query like `select * from foo` you get: > > > > name: foo > > time aaa bbb ccc

[influxdb] Re: different field schemes in one measurement

2017-02-03 Thread patrick . hemmer
On Friday, February 3, 2017 at 2:59:11 PM UTC-5, patrick...@gmail.com wrote: > So that when you do a query like `select * from foo` you get: > > name: foo > time aaa bbb ccc ddd eee fff mytag > --- --- --- --- --- --- - >

[influxdb] different field schemes in one measurement

2017-02-03 Thread patrick . hemmer
So something I keep stumbling across in various places is other people/applications/whatever writing points with different field schemes to one measurement. For example: foo,bartag=barval aaa=111i,bbb=222i,ccc=333i foo,baztag=bazval ddd=444i,eee=555i,fff=666i So that when you do a query

[influxdb] Kapacitor: trouble creating alert when field in certain state for too long

2016-11-11 Thread patrick . hemmer
I'm trying to create an alert when a specific field has been in a certain state for too long. Currently my tick script looks like this: var data = batch | query('select active from telegraf.autogen.postgresql_replication_slots') .period(4h) .every(10s) .groupBy('host','slot

Re: [influxdb] unknown subscriber

2016-10-06 Thread patrick . hemmer
That works for the `pointsWritten` value, but not the `writeFailures` value: > select sum(writeFailures) from subscriber where "database" != '' and time > > '2016-10-06T04:24:00.0Z' and time < '2016-10-06T04:25:00.0Z' name: subscriber timesum 147572784

[influxdb] unknown subscriber

2016-10-05 Thread patrick . hemmer
I was looking at the _internal..subscriber measurement to generate a report when there are write errors when I ran across this which has me confused: > select * from _internal..subscriber where "database"='' and time > now() - 1m name: subscriber timedatabase

[influxdb] Re: Kapacitor: alert on age of last data

2016-09-14 Thread patrick . hemmer
Finally came up with a solution for this: var interval = 5s var threshold_warn = 65s var threshold_crit = 305s // Note: the alert will come in between (threshold + interval) and (threshold + interval * 2). // This should be improved by https://github.com/influxdata/kapacitor/

Re: [influxdb] Kapacitor: alert on age of last data

2016-09-13 Thread patrick . hemmer
Unfortunately not. Deadman operates on volume of data, not age of data. While related, they cannot be handled the same way. On Monday, September 12, 2016 at 5:46:06 PM UTC-4, Sean Beckett wrote: > The deadman documentation gives the actual TICKscript implementation. I > believe you can simply ad

[influxdb] Kapacitor: alert on age of last data

2016-09-12 Thread patrick . hemmer
I'm trying to detect when nodes stop reporting data to telegraf. However I don't want to use something like `deadman` as I want to have multiple alert levels, such as warn and critical. Warn would be if no data has been received for >60s, and critical would be >300s (or similar). The only way I

[influxdb] Why toml?

2016-08-07 Thread patrick . hemmer
Just curious, as the influx apps (influxdb, telegraf, kapacitor, ...) are the first apps I've worked with which use TOML, but why was TOML chosen as the config language? Working with the syntax is a PITA, both from a developer standpoint, and an end-user standpoint. Surely there must have been s

[influxdb] Re: kapacitor: Trouble using join with multiple alerts

2016-07-25 Thread patrick . hemmer
On Monday, July 25, 2016 at 4:12:49 PM UTC-4, nath...@influxdb.com wrote: > I wrote a test for this locally and I am seeing a similar issue. It seems so > far to be related to the tolerance value as well. Can you create a new issue > on Github  with the details from this post? Thanks. Issue crea

[influxdb] Re: kapacitor: Trouble using join with multiple alerts

2016-07-25 Thread patrick . hemmer
Oh, and this is with influxdb 1.0beta3 and kapacitor 1.0beta2 I upgraded to kapacitor 1.0beta3 and the problem got worse. log() now shows 4 lines instead of 2: Jul 25 13:03:04 fll2aixd01stg kapacitord[6421]: [disk_free:log5] 2016/07/25 13:03:04 I! {disk host=fll2aixd01stg,path=/tmp/m

[influxdb] kapacitor: Trouble using join with multiple alerts

2016-07-25 Thread patrick . hemmer
I'm trying to add the ability to put hosts into a "maintenance mode" which will prevent kapacitor from sending out alerts. In order to do this, I've created a "maintlock" measurement, which tracks a counter on the host. When the "count" field in this measurement is 0, kapacitor is free to send a

[influxdb] Re: Getting Telegraf SNMP tables working with F5 BigIP

2016-06-14 Thread patrick . hemmer
Finally figured this out, and it had nothing to do with include_instances. include_instances is optional. Leaving it out results in all OIDs being used. The problem was there was no snmptranslate_file specified. I was under the mistaken impression that the plugin would use the `name` parameter f

[influxdb] Re: Getting Telegraf SNMP tables working with F5 BigIP

2016-06-14 Thread patrick . hemmer
> Hi Patrick, > > I understand that you are aiming to combine data from multiple OID's in the > form of tags and fields for the same measurement. While that would be nice, I'd settle for getting this working at all. > > This functionality has not yet been implemented for the SNMP input plugin.