I am very new to influx DB. I am using the windows version 1.1.1.Attached my config file.
Can anyone tell me how to load data to Influxdb from file.? file content: treasures,captain_id=dread_pirate_roberts value=801 1439856000 treasures,captain_id=flint value=29 1439856000 treasures,captain_id=sparrow value=38 1439856000 treasures,captain_id=tetra value=47 1439856000 treasures,captain_id=crunch value=109 1439858880 2) also localhost:8086 url is not working Output of the config given. D:\Prev_Machine\Pranab\Daimler\Xtech\software\influxdb-1.1.1_windows_amd64\influ xdb-1.1.1-1>influxd -config influxdb.conf 8888888 .d888 888 8888888b. 888888b. 888 d88P" 888 888 "Y88b 888 "88b 888 888 888 888 888 888 .88P 888 88888b. 888888 888 888 888 888 888 888 888 8888888K. 888 888 "88b 888 888 888 888 Y8bd8P' 888 888 888 "Y88b 888 888 888 888 888 888 888 X88K 888 888 888 888 888 888 888 888 888 Y88b 888 .d8""8b. 888 .d88P 888 d88P 8888888 888 888 888 888 "Y88888 888 888 8888888P" 8888888P" [run] 2017/01/06 07:00:01 InfluxDB starting, version 1.1.1, branch master, commi t e47cf1f2e83a02443d7115c54f838be8ee959644 [run] 2017/01/06 07:00:01 Go version go1.7.4, GOMAXPROCS set to 4 [run] 2017/01/06 07:00:01 Using configuration at: influxdb.conf [store] 2017/01/06 07:00:01 Using data dir: D:\Prev_Machine\Pranab\Daimler\Xtech \software\influxdb-1.1.1_windows_amd64\influxdb-1.1.1-1 [store] 2017/01/06 07:00:01 Skipping database dir: .gitconfig. Not a directory [store] 2017/01/06 07:00:01 Skipping database dir: .influx_history. Not a direct ory [store] 2017/01/06 07:00:01 Skipping database dir: datarrr.txt. Not a directory [store] 2017/01/06 07:00:01 Skipping database dir: influx.exe. Not a directory [store] 2017/01/06 07:00:01 Skipping database dir: influx_inspect.exe. Not a dir ectory [store] 2017/01/06 07:00:01 Skipping database dir: influx_stress.exe. Not a dire ctory [store] 2017/01/06 07:00:01 Skipping database dir: influx_tsm.exe. Not a directo ry [store] 2017/01/06 07:00:01 Skipping database dir: influxd.exe. Not a directory [store] 2017/01/06 07:00:01 Skipping database dir: influxdb.conf. Not a director y [store] 2017/01/06 07:00:01 Skipping database dir: influxdb_bkp.conf. Not a dire ctory [store] 2017/01/06 07:00:01 Skipping database dir: meta.db. Not a directory [cacheloader] 2017/01/06 07:00:01 reading file \var\lib\influxdb\wal\_internal\m onitor\1\_00001.wal, size 387280 [cacheloader] 2017/01/06 07:00:01 reading file \var\lib\influxdb\wal\_internal\m onitor\2\_00001.wal, size 26816 [cacheloader] 2017/01/06 07:00:01 reading file \var\lib\influxdb\wal\_internal\m onitor\2\_00003.wal, size 0 [shard] 2017/01/06 07:00:01 D:\Prev_Machine\Pranab\Daimler\Xtech\software\influx db-1.1.1_windows_amd64\influxdb-1.1.1-1\_internal\monitor\2 database index loade d in 3.0002ms [store] 2017/01/06 07:00:01 D:\Prev_Machine\Pranab\Daimler\Xtech\software\influx db-1.1.1_windows_amd64\influxdb-1.1.1-1\_internal\monitor\2 opened in 25.0015ms [cacheloader] 2017/01/06 07:00:01 reading file \var\lib\influxdb\wal\_internal\m onitor\1\_00002.wal, size 2781197 [cacheloader] 2017/01/06 07:00:02 reading file \var\lib\influxdb\wal\_internal\m onitor\1\_00003.wal, size 663847 [cacheloader] 2017/01/06 07:00:02 reading file \var\lib\influxdb\wal\_internal\m onitor\1\_00004.wal, size 427155 [cacheloader] 2017/01/06 07:00:02 reading file \var\lib\influxdb\wal\_internal\m onitor\1\_00005.wal, size 111307 [cacheloader] 2017/01/06 07:00:02 reading file \var\lib\influxdb\wal\_internal\m onitor\1\_00006.wal, size 287225 [cacheloader] 2017/01/06 07:00:02 reading file \var\lib\influxdb\wal\_internal\m onitor\1\_00009.wal, size 0 [shard] 2017/01/06 07:00:02 D:\Prev_Machine\Pranab\Daimler\Xtech\software\influx db-1.1.1_windows_amd64\influxdb-1.1.1-1\_internal\monitor\1 database index loade d in 1ms [store] 2017/01/06 07:00:02 D:\Prev_Machine\Pranab\Daimler\Xtech\software\influx db-1.1.1_windows_amd64\influxdb-1.1.1-1\_internal\monitor\1 opened in 238.0136ms [subscriber] 2017/01/06 07:00:02 opened service [monitor] 2017/01/06 07:00:02 Starting monitor system [monitor] 2017/01/06 07:00:02 'build' registered for diagnostics monitoring [monitor] 2017/01/06 07:00:02 'runtime' registered for diagnostics monitoring [monitor] 2017/01/06 07:00:02 'network' registered for diagnostics monitoring [monitor] 2017/01/06 07:00:02 'system' registered for diagnostics monitoring [shard-precreation] 2017/01/06 07:00:02 Starting precreation service with check interval of 10m0s, advance period of 30m0s [snapshot] 2017/01/06 07:00:02 Starting snapshot service [continuous_querier] 2017/01/06 07:00:02 Starting continuous query service [monitor] 2017/01/06 07:00:02 Storing statistics in database '_internal' retenti on policy 'monitor', at interval 10s [httpd] 2017/01/06 07:00:02 Starting HTTP service [httpd] 2017/01/06 07:00:02 Authentication enabled: false [httpd] 2017/01/06 07:00:02 Listening on HTTP: [::]:8086 [retention] 2017/01/06 07:00:02 Starting retention policy enforcement service wi th check interval of 30m0s [run] 2017/01/06 07:00:02 Listening for signals 2017/01/06 07:00:02 Sending usage statistics to usage.influxdata.com [run] 2017/01/06 07:00:52 Signal received, initializing clean shutdown... [run] 2017/01/06 07:00:52 Waiting for clean shutdown... [monitor] 2017/01/06 07:00:52 shutting down monitor system [snapshot] 2017/01/06 07:00:52 snapshot listener closed [monitor] 2017/01/06 07:00:52 terminating storage of statistics [shard-precreation] 2017/01/06 07:00:52 Precreation service terminating [continuous_querier] 2017/01/06 07:00:52 continuous query service terminating [retention] 2017/01/06 07:00:52 retention policy enforcement terminating [subscriber] 2017/01/06 07:00:54 closed service [run] 2017/01/06 07:00:54 server shutdown completed -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/5caa06c2-0387-4510-8641-84859978016c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
### Welcome to the InfluxDB configuration file. # The values in this file override the default values used by the system if # a config option is not specified. The commented out lines are the the configuration # field and the default value used. Uncommentting a line and changing the value # will change the value used at runtime when the process is restarted. # Once every 24 hours InfluxDB will report usage data to usage.influxdata.com # The data includes a random ID, os, arch, version, the number of series and other # usage data. No data from user databases is ever transmitted. # Change this option to true to disable reporting. # reporting-disabled = false # we'll try to get the hostname automatically, but if it the os returns something # that isn't resolvable by other servers in the cluster, use this option to # manually set the hostname # hostname = "localhost" ### ### [meta] ### ### Controls the parameters for the Raft consensus group that stores metadata ### about the InfluxDB cluster. ### [meta] # Where the metadata/raft database is stored #dir = "/var/lib/influxdb/meta" dir ="D:\\Prev_Machine\\Pranab\\Daimler\\Xtech\\software\\influxdb-1.1.1_windows_amd64\\influxdb-1.1.1-1" # Automatically create a default retention policy when creating a database. # retention-autocreate = true # If log messages are printed for the meta service # logging-enabled = true ### ### [data] ### ### Controls where the actual shard data for InfluxDB lives and how it is ### flushed from the WAL. "dir" may need to be changed to a suitable place ### for your system, but the WAL settings are an advanced configuration. The ### defaults should work for most systems. ### [data] # The directory where the TSM storage engine stores TSM files. #dir = "/var/lib/influxdb/data" dir ="D:\\Prev_Machine\\Pranab\\Daimler\\Xtech\\software\\influxdb-1.1.1_windows_amd64\\influxdb-1.1.1-1" # The directory where the TSM storage engine stores WAL files. wal-dir = "/var/lib/influxdb/wal" # Trace logging provides more verbose output around the tsm engine. Turning # this on can provide more useful output for debugging tsm engine issues. # trace-logging-enabled = false # Whether queries should be logged before execution. Very useful for troubleshooting, but will # log any sensitive data contained within a query. # query-log-enabled = true # Settings for the TSM engine # CacheMaxMemorySize is the maximum size a shard's cache can # reach before it starts rejecting writes. # cache-max-memory-size = 1048576000 # CacheSnapshotMemorySize is the size at which the engine will # snapshot the cache and write it to a TSM file, freeing up memory # cache-snapshot-memory-size = 26214400 # CacheSnapshotWriteColdDuration is the length of time at # which the engine will snapshot the cache and write it to # a new TSM file if the shard hasn't received writes or deletes # cache-snapshot-write-cold-duration = "10m" # CompactFullWriteColdDuration is the duration at which the engine # will compact all TSM files in a shard if it hasn't received a # write or delete # compact-full-write-cold-duration = "4h" # The maximum series allowed per database before writes are dropped. This limit can prevent # high cardinality issues at the database level. This limit can be disabled by setting it to # 0. # max-series-per-database = 1000000 # The maximum number of tag values per tag that are allowed before writes are dropped. This limit # can prevent high cardinality tag values from being written to a measurement. This limit can be # disabled by setting it to 0. # max-values-per-tag = 100000 ### ### [coordinator] ### ### Controls the clustering service configuration. ### # [coordinator] # The default time a write request will wait until a "timeout" error is returned to the caller. # write-timeout = "10s" # The maximum number of concurrent queries allowed to be executing at one time. If a query is # executed and exceeds this limit, an error is returned to the caller. This limit can be disabled # by setting it to 0. # max-concurrent-queries = 0 # The maximum time a query will is allowed to execute before being killed by the system. This limit # can help prevent run away queries. Setting the value to 0 disables the limit. # query-timeout = "0s" # The the time threshold when a query will be logged as a slow query. This limit can be set to help # discover slow or resource intensive queries. Setting the value to 0 disables the slow query logging. # log-queries-after = "0s" # The maximum number of points a SELECT can process. A value of 0 will make the maximum # point count unlimited. # max-select-point = 0 # The maximum number of series a SELECT can run. A value of 0 will make the maximum series # count unlimited. # The maximum number of series a SELECT can run. A value of zero will make the maximum series # count unlimited. # max-select-series = 0 # The maxium number of group by time bucket a SELECt can create. A value of zero will max the maximum # number of buckets unlimited. # max-select-buckets = 0 ### ### [retention] ### ### Controls the enforcement of retention policies for evicting old data. ### # [retention] # Determines whether retention policy enforcment enabled. # enabled = true # The interval of time when retention policy enforcement checks run. # check-interval = "30m" ### ### [shard-precreation] ### ### Controls the precreation of shards, so they are available before data arrives. ### Only shards that, after creation, will have both a start- and end-time in the ### future, will ever be created. Shards are never precreated that would be wholly ### or partially in the past. # [shard-precreation] # Determines whether shard pre-creation service is enabled. # enabled = true # The interval of time when the check to pre-create new shards runs. # check-interval = "10m" # The default period ahead of the endtime of a shard group that its successor # group is created. # advance-period = "30m" ### ### Controls the system self-monitoring, statistics and diagnostics. ### ### The internal database for monitoring data is created automatically if ### if it does not already exist. The target retention within this database ### is called 'monitor' and is also created with a retention period of 7 days ### and a replication factor of 1, if it does not exist. In all cases the ### this retention policy is configured as the default for the database. # [monitor] # Whether to record statistics internally. # store-enabled = true # The destination database for recorded statistics # store-database = "_internal" # The interval at which to record statistics # store-interval = "10s" ### ### [admin] ### ### Controls the availability of the built-in, web-based admin interface. If HTTPS is ### enabled for the admin interface, HTTPS must also be enabled on the [http] service. ### ### NOTE: This interface is deprecated as of 1.1.0 and will be removed in a future release. # [admin] # Determines whether the admin service is enabled. # enabled = false # The default bind address used by the admin service. # bind-address = ":8083" # Whether the admin service should use HTTPS. # https-enabled = false # The SSL certificate used when HTTPS is enabled. # https-certificate = "/etc/ssl/influxdb.pem" ### ### [http] ### ### Controls how the HTTP endpoints are configured. These are the primary ### mechanism for getting data into and out of InfluxDB. ### # [http] # Determines whether HTTP endpoint is enabled. enabled = true # The bind address used by the HTTP service. bind-address = "localhost:8086" # Determines whether HTTP authentication is enabled. auth-enabled = true # The default realm sent back when issuing a basic auth challenge. realm = "InfluxDB" # Determines whether HTTP request logging is enable.d log-enabled = true # Determines whether detailed write logging is enabled. write-tracing = false # Determines whether the pprof endpoint is enabled. This endpoint is used for # troubleshooting and monitoring. pprof-enabled = true # Determines whether HTTPS is enabled. https-enabled = false # The SSL certificate to use when HTTPS is enabled. https-certificate = "/etc/ssl/influxdb.pem" # Use a separate private key location. https-private-key = "" # The JWT auth shared secret to validate requests using JSON web tokens. # shared-sercret = "" # The default chunk size for result sets that should be chunked. # max-row-limit = 10000 # The maximum number of HTTP connections that may be open at once. New connections that # would exceed this limit are dropped. Setting this value to 0 disables the limit. # max-connection-limit = 0 # Enable http service over unix domain socket # unix-socket-enabled = false # The path of the unix domain socket. # bind-socket = "/var/run/influxdb.sock" ### ### [subscriber] ### ### Controls the subscriptions, which can be used to fork a copy of all data ### received by the InfluxDB host. ### # [subscriber] # Determines whether the subscriber service is enabled. # enabled = true # The default timeout for HTTP writes to subscribers. # http-timeout = "30s" # Allows insecure HTTPS connections to subscribers. This is useful when testing with self- # signed certificates. # insecure-skip-verify = false # The path to the PEM encoded CA certs file. If the empty string, the default system certs will be used # ca-certs = "" # The number of writer goroutines processing the write channel. # write-concurrency = 40 # The number of in-flight writes buffered in the write channel. # write-buffer-size = 1000 ### ### [[graphite]] ### ### Controls one or many listeners for Graphite data. ### # [[graphite]] # Determines whether the graphite endpoint is enabled. # enabled = false # database = "graphite" # retention-policy = "" # bind-address = ":2003" # protocol = "tcp" # consistency-level = "one" # These next lines control how batching works. You should have this enabled # otherwise you could get dropped metrics or poor performance. Batching # will buffer points in memory if you have many coming in. # Flush if this many points get buffered # batch-size = 5000 # number of batches that may be pending in memory # batch-pending = 10 # Flush at least this often even if we haven't hit buffer limit # batch-timeout = "1s" # UDP Read buffer size, 0 means OS default. UDP listener will fail if set above OS max. # udp-read-buffer = 0 ### This string joins multiple matching 'measurement' values providing more control over the final measurement name. # separator = "." ### Default tags that will be added to all metrics. These can be overridden at the template level ### or by tags extracted from metric # tags = ["region=us-east", "zone=1c"] ### Each template line requires a template pattern. It can have an optional ### filter before the template and separated by spaces. It can also have optional extra ### tags following the template. Multiple tags should be separated by commas and no spaces ### similar to the line protocol format. There can be only one default template. # templates = [ # "*.app env.service.resource.measurement", # # Default template # "server.*", # ] ### ### [collectd] ### ### Controls one or many listeners for collectd data. ### # [[collectd]] # enabled = false # bind-address = ":25826" # database = "collectd" # retention-policy = "" # typesdb = "/usr/share/collectd/types.db" # These next lines control how batching works. You should have this enabled # otherwise you could get dropped metrics or poor performance. Batching # will buffer points in memory if you have many coming in. # Flush if this many points get buffered # batch-size = 5000 # Number of batches that may be pending in memory # batch-pending = 10 # Flush at least this often even if we haven't hit buffer limit # batch-timeout = "10s" # UDP Read buffer size, 0 means OS default. UDP listener will fail if set above OS max. # read-buffer = 0 ### ### [opentsdb] ### ### Controls one or many listeners for OpenTSDB data. ### # [[opentsdb]] # enabled = false # bind-address = ":4242" # database = "opentsdb" # retention-policy = "" # consistency-level = "one" # tls-enabled = false # certificate= "/etc/ssl/influxdb.pem" # Log an error for every malformed point. # log-point-errors = true # These next lines control how batching works. You should have this enabled # otherwise you could get dropped metrics or poor performance. Only points # metrics received over the telnet protocol undergo batching. # Flush if this many points get buffered # batch-size = 1000 # Number of batches that may be pending in memory # batch-pending = 5 # Flush at least this often even if we haven't hit buffer limit # batch-timeout = "1s" ### ### [[udp]] ### ### Controls the listeners for InfluxDB line protocol data via UDP. ### # [[udp]] # enabled = false # bind-address = ":8089" # database = "udp" # retention-policy = "" # These next lines control how batching works. You should have this enabled # otherwise you could get dropped metrics or poor performance. Batching # will buffer points in memory if you have many coming in. # Flush if this many points get buffered # batch-size = 5000 # Number of batches that may be pending in memory # batch-pending = 10 # Will flush at least this often even if we haven't hit buffer limit # batch-timeout = "1s" # UDP Read buffer size, 0 means OS default. UDP listener will fail if set above OS max. # read-buffer = 0 ### ### [continuous_queries] ### ### Controls how continuous queries are run within InfluxDB. ### # [continuous_queries] # Determiens whether the continuous query service is enabled. # enabled = true # Controls whether queries are logged when executed by the CQ service. # log-enabled = true # interval for how often continuous queries will be checked if they need to run # run-interval = "1s"
