Downloading and Installing Influx DB1.x
 |
It is responsibility of whomever installs Influx database to read and understand all security related documentation provided for InfluxDB. PTC strongly recommends installing and configuring InfluxDB using secure configurations including the use of a username and strong password.
|
|
|
This process assumes ThingWorx is installed. See Installing ThingWorx.
|
|
|
If InfluxDB and ThingWorx are on machines with different timezones, there may be issues with fetching data. To avoid these issues, either of the following deployment options are recommended:
• Deploy InfluxDB and ThingWorx on the same host/machine.
• If InfluxDB and ThingWorx are deployed on different hosts/machines, the InfluxDB server timezone should be aligned with the -Duser.timezone Tomcat parameter with clocks synced to avoid issues related to query results.
|
1. Download and install Influx DB.
|
|
InfluxDB is not supported in Windows. The steps below use UNIX OS.
|
◦ InfluxDB Open Source (single node): Reference Install InfluxDB
Download links:
◦ InfluxDB Enterprise (high availability): Reference Install an InfluxDB Enterprise cluster in your own environment
Download links-Data node
Download links-Meta node:
2. Create a database inside InfluxDB. Obtain and run the thingworxInfluxDBSetup.sh script to create the database in InfluxDB. The InfluxDB command line interface must be available from the location the script is run from. See Launchinflux for more information.
|
|
The thingworxInfluxDBSetup.sh script is available on the PTC Support Portal in the install folder of the software download package.
|
The following example command creates a database with the default retention policies:
CREATE DATABASE thingworx with DURATION 365d REPLICATION 1 SHARD DURATION 30d NAME autogen
|
|
InfluxDB data provider currently supports a retention policy with name autogen only. While creating the database to use with data provider, you can specify the policy name and other policies such as replication factor.
|
3. Create a InfluxDB user from the InfluxDB command line interface. The following example command creates a user:
CREATE USER twadmin WITH PASSWORD 'password' WITH ALL PRIVILEGES