- Prepare for upgrading ThingsBoard (CentOS, Ubuntu)
- Upgrading to 3.4.3PE
- Upgrading to 3.4.2PE
- Upgrading to 3.4.1PE
- Upgrading to 3.4PE
- Upgrading to 3.3.4.1PE
- Upgrading to 3.3.4PE
- Upgrading to 3.3.3PE
- Upgrading to 3.3.2PE
- Upgrading to 3.3.1PE
- Upgrading to 3.3PE
- Upgrading to 3.2.2PE
- Upgrading to 3.2.1PE
- Upgrading to 3.2PE
- Upgrading to 3.1.1PE
- Upgrading to 3.1PE
- Upgrading to 3.0.1PE
- Upgrading to 3.0PE
- Upgrading to 2.5.6PE
- Upgrading to 2.5.5PE
- Upgrading to 2.5.4PE
- Upgrading to 2.5.3PE
- Upgrading to 2.5.2PE
- Upgrading to 2.5.1PE
- Upgrading to 2.5PE
- Upgrading to 2.4.3PE
- Upgrading to 2.4.2.1PE
- Upgrading to 2.4.1PE
Prepare for upgrading ThingsBoard (CentOS, Ubuntu)
Stop ThingsBoard Check if ThingsBoard and database services are running Initially ThingsBoard, check status to ensure it is stopped and then databases.
1
sudo systemctl stop thingsboard
1
sudo systemctl status thingsboard
Backup Database
Make a backup of the database before upgrading.
PostgreSQL
Check PostgreSQL status. It is unnecessary to stop PostgreSQL for the backup.
1
sudo systemctl status postgresql
Make sure you have enough space to place a backup of the database
Check database size
1
sudo -u postgres psql -c "SELECT pg_size_pretty( pg_database_size('thingsboard') );"
Check free space
1
df -h /
If there is enough free space - make a backup.
1
sudo -Hiu postgres pg_dump thingsboard > thingsboard.sql.bak
Check backup file being created.
Cassandra
Check Cassandra status. It is necessary to stop Cassandra for the backup.
1
sudo systemctl status cassandra
Flush all memtables from the node to SSTables on disk.
1
nodetool drain
Stop Cassandra.
1
sudo systemctl stop cassandra
And you have to check the status again to ensure they are surely stopped.
1
sudo systemctl status cassandra
Make sure you have enough space to place a backup of the database
Check database size.
1
du -h /var/lib/cassandra/ | tail -1
Check free space.
1
df -h /
Make a backup of Cassandra database.
1
2
mkdir backup
sudo tar -cvf backup/cassandra.tar /var/lib/cassandra
Check archive being created
Start Database
Cassandra
1
sudo systemctl start cassandra
PostgreSQL Do nothing, postgresql is already running.
Upgrading to 3.4.3PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 3.4.2PE. In order to upgrade to 3.4.3PE you need to upgrade to 3.4.2PE first.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer may ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Start the service
1
$ sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 3.4.2PE. In order to upgrade to 3.4.3PE you need to upgrade to 3.4.2PE first.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-3.4.3pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-3.4.3pe.exe.
- Compare and merge your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
Start the service
1
net start thingsboard
Upgrading to 3.4.2PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 3.4.1PE. In order to upgrade to 3.4.2PE you need to upgrade to 3.4.1PE first.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer may ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Execute regular upgrade script:
1
2
# Execute regular upgrade script
$ sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=3.4.1
Start the service
1
$ sudo service thingsboard start
Update the JWT signing key if you use the default one “thingsboardDefaultSigningKey” on production environments. See JWT security settings for details.
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 3.4.1PE. In order to upgrade to 3.4.2PE you need to upgrade to 3.4.1PE first.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-3.4.2pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-3.4.2pe.exe.
-
Compare and merge your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
Execute regular upgrade script:
1
C:\thingsboard>upgrade.bat --fromVersion=3.4.1
Start the service
1
net start thingsboard
Update the JWT signing key if you use the default one “thingsboardDefaultSigningKey” on production environments. See JWT security settings for details.
Upgrading to 3.4.1PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 3.4PE. In order to upgrade to 3.4.1PE you need to upgrade to 3.4PE first.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer may ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Execute regular upgrade script:
1
2
# Execute regular upgrade script
$ sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=3.4.0
Start the service
1
$ sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 3.4PE. In order to upgrade to 3.4.1PE you need to upgrade to 3.4PE first.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-3.4.1pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-3.4.1pe.exe.
-
Compare and merge your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
Execute regular upgrade script:
1
C:\thingsboard>upgrade.bat --fromVersion=3.4.0
Start the service
1
net start thingsboard
Upgrading to 3.4PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 3.3.4.1PE. In order to upgrade to 3.4PE you need to upgrade to 3.3.4.1PE first.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer may ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Execute regular upgrade script:
1
2
# Execute regular upgrade script
$ sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=3.3.4
Start the service
1
$ sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 3.3.4.1PE. In order to upgrade to 3.4PE you need to upgrade to 3.3.4.1PE first.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-3.4pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-3.4pe.exe.
-
Compare and merge your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
Execute regular upgrade script:
1
C:\thingsboard>upgrade.bat --fromVersion=3.3.4
Start the service
1
net start thingsboard
Upgrading to 3.3.4.1PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 3.3.4PE. In order to upgrade to 3.3.4.1PE you need to upgrade to 3.3.4PE first.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer may ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Start the service
1
$ sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 3.3.4PE. In order to upgrade to 3.3.4.1PE you need to upgrade to 3.3.4PE first.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-3.3.4.1pe.zip.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Unzip installation archive to ThingsBoard install dir.
- Compare and merge your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
Start the service
1
net start thingsboard
Upgrading to 3.3.4PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 3.3.3PE. In order to upgrade to 3.3.4PE you need to upgrade to 3.3.3PE first.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer may ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Execute regular upgrade script:
1
2
# Execute regular upgrade script
$ sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=3.3.3
Start the service
1
$ sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 3.3.3PE. In order to upgrade to 3.3.4PE you need to upgrade to 3.3.3PE first.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-3.3.4pe.zip.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Unzip installation archive to ThingsBoard install dir.
-
Compare and merge your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
Execute regular upgrade script:
1
C:\thingsboard>upgrade.bat --fromVersion=3.3.3
Start the service
1
net start thingsboard
Upgrading to 3.3.3PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 3.3.2PE. In order to upgrade to 3.3.3PE you need to upgrade to 3.3.2PE first.
Important note before upgrading to ThingsBoard 3.3.3
ThingsBoard UI was migrated to Angular 12. You need to re-build your custom widgets and rule nodes (which use UI) on Angular 12.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer may ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Execute regular upgrade script:
1
2
# Execute regular upgrade script
$ sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=3.3.2
Start the service
1
$ sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 3.3.2PE. In order to upgrade to 3.3.3PE you need to upgrade to 3.3.2PE first.
Important note before upgrading to ThingsBoard 3.3.3
ThingsBoard UI was migrated to Angular 12. You need to re-build your custom widgets and rule nodes (which use UI) on Angular 12.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-3.3.3pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-3.3.3pe.exe.
-
Compare and merge your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
Execute regular upgrade script:
1
C:\thingsboard>upgrade.bat --fromVersion=3.3.2
Start the service
1
net start thingsboard
Upgrading to 3.3.2PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 3.3.1PE. In order to upgrade to 3.3.2PE you need to upgrade to 3.3.1PE first.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer may ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten. Please make sure that you set database.ts.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
Execute regular upgrade script:
1
2
# Execute regular upgrade script
$ sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=3.3.1
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
$ sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 3.3.1PE. In order to upgrade to 3.3.2PE you need to upgrade to 3.3.1PE first.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-3.3.2pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-3.3.1pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Please make sure that you set database.ts.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
- Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
Execute regular upgrade script:
1
C:\thingsboard>upgrade.bat --fromVersion=3.3.1
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 3.3.1PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 3.3.0PE. In order to upgrade to 3.3.1PE you need to upgrade to 3.3.0PE first.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer may ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten. Please make sure that you set database.ts.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
Execute regular upgrade script:
1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=3.3.0
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 3.3.0PE. In order to upgrade to 3.3.1PE you need to upgrade to 3.3.0PE first.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-3.3.1pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-3.3.1pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Please make sure that you set database.ts.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
- Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
Execute regular upgrade script:
1
C:\thingsboard>upgrade.bat --fromVersion=3.3.0
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 3.3PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 3.2.2PE. In order to upgrade to 3.3PE you need to upgrade to 3.2.2PE first.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten. Please make sure that you set database.ts.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
NOTE: If you were using MQTT over SSL instead of default MQTT, please make sure you have a proper configuration (thingsboard.conf and/or thingsboard.yml) of ports/addresses:
/etc/thingsboard/conf/thingsboard.conf
1
2
3
4
5
6
export MQTT_SSL_ENABLED=true
export MQTT_SSL_BIND_ADDRESS=0.0.0.0
export MQTT_SSL_BIND_PORT=8883
export MQTT_BIND_ADDRESS=0.0.0.0
export MQTT_BIND_PORT=1883
/etc/thingsboard/conf/thingsboard.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
transport:
. . .
# Local MQTT transport parameters
mqtt:
# Enable/disable mqtt transport protocol.
enabled: "${MQTT_ENABLED:true}"
bind_address: "${MQTT_BIND_ADDRESS:0.0.0.0}"
bind_port: "${MQTT_BIND_PORT:1883}"
. . .
ssl:
# Enable/disable SSL support
enabled: "${MQTT_SSL_ENABLED:true}"
# MQTT SSL bind address
bind_address: "${MQTT_SSL_BIND_ADDRESS:0.0.0.0}"
# MQTT SSL bind port
bind_port: "${MQTT_SSL_BIND_PORT:8883}"
Execute regular upgrade script:
1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=3.2.2
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 3.2.2PE. In order to upgrade to 3.3PE you need to upgrade to 3.2.2PE first.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-3.3pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-3.3pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Please make sure that you set database.ts.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
- If you were using MQTT over SSL instead of default MQTT, please make sure you have a proper configuration (thingsboard.yml) of ports/addresses:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
transport:
. . .
# Local MQTT transport parameters
mqtt:
# Enable/disable mqtt transport protocol.
enabled: "${MQTT_ENABLED:true}"
bind_address: "${MQTT_BIND_ADDRESS:0.0.0.0}"
bind_port: "${MQTT_BIND_PORT:1883}"
. . .
ssl:
# Enable/disable SSL support
enabled: "${MQTT_SSL_ENABLED:true}"
# MQTT SSL bind address
bind_address: "${MQTT_SSL_BIND_ADDRESS:0.0.0.0}"
# MQTT SSL bind port
bind_port: "${MQTT_SSL_BIND_PORT:8883}"
- Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
Execute regular upgrade script:
1
C:\thingsboard>upgrade.bat --fromVersion=3.2.2
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 3.2.2PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 3.2.1PE. In order to upgrade to 3.2.2PE you need to upgrade to 3.2.1PE first.
NOTE: Since ThingsBoard version 3.2.2PE Java 11 is used
- Please install Java 11 before proceeding upgrade procedure using the following guide:
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.ts.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
Execute regular upgrade script:
1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=3.2.1
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 3.2.1PE. In order to upgrade to 3.2.2PE you need to upgrade to 3.2.1PE first.
NOTE: Since ThingsBoard version 3.2.2PE Java 11 is used
- Please install Java 11 before proceeding upgrade procedure using the following guide:
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-3.2.2pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-3.2.2pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Please make sure that you set database.ts.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
- Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
Execute regular upgrade script:
1
C:\thingsboard>upgrade.bat --fromVersion=3.2.1
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 3.2.1PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 3.2PE. In order to upgrade to 3.2.1PE you need to upgrade to 3.2PE first.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.ts.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
Execute regular upgrade script:
1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=3.2.0
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 3.2PE. In order to upgrade to 3.2.1PE you need to upgrade to 3.2PE first.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-3.2.1pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-3.2.1pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Please make sure that you set database.ts.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
- Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
Execute regular upgrade script:
1
C:\thingsboard>upgrade.bat --fromVersion=3.2.0
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 3.2PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 3.1.1PE. In order to upgrade to 3.2PE you need to upgrade to 3.1.1PE first.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.ts.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
Execute regular upgrade script:
1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=3.1.1
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 3.1.1PE. In order to upgrade to 3.2PE you need to upgrade to 3.1.1PE first.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-3.2pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-3.2pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Please make sure that you set database.ts.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
- Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
Execute regular upgrade script:
1
C:\thingsboard>upgrade.bat --fromVersion=3.1.1
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 3.1.1PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 3.1PE. In order to upgrade to 3.1.1PE you need to upgrade to 3.1PE first.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.ts.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
Execute regular upgrade script:
1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=3.1.0
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 3.1PE. In order to upgrade to 3.1.1PE you need to upgrade to 3.1PE first.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-3.1.1pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-3.1.1pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Please make sure that you set database.ts.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
- Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
Execute regular upgrade script:
1
C:\thingsboard>upgrade.bat --fromVersion=3.1.0
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 3.1PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 3.0.1PE. In order to upgrade to 3.1PE you need to upgrade to 3.0.1PE first.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.ts.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
NOTE: Cassandra database does not support advanced filters. If you were using Cassandra database for timeseries data please make sure that database.ts_latest.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) is “sql”:
1
2
3
4
database:
...
ts_latest:
type: "${DATABASE_TS_LATEST_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
and execute the following migration script:
1
2
# Execute script to migrate latest timeseries data from Cassandra to PostgreSQL
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=3.0.1-cassandra
Execute regular upgrade script:
1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=3.0.1
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 3.0.1PE. In order to upgrade to 3.1PE you need to upgrade to 3.0.1PE first.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-3.1pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-3.1pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Please make sure that you set database.ts.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
- Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
NOTE: If you were using Cassandra database for entities data execute the following migration script:
1
C:\thingsboard>upgrade.bat --fromVersion=3.0.1-cassandra
Execute regular upgrade script:
1
C:\thingsboard>upgrade.bat --fromVersion=3.0.1
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 3.0.1PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 3.0PE. In order to upgrade to 3.0.1PE you need to upgrade to 3.0PE first.
Important note before upgrading to ThingsBoard 3.0
- ThingsBoard UI was rewritten from AngularJS 1.5.8 to use Angular 9.
- What does it mean?
- Generally speaking, it means: state of the art application, easier development of front-end elements, performance improvements and more flexibility with UI customizations.
- How to upgrade?
- You are safe to upgrade if you do NOT use custom widgets or custom actions in the dashboards.
- New JS framework may not support your current code — custom widgets and custom actions, so they need to be refactored a bit. Thus we encourage you to test your customizations using our cloud environments or your dev instances.
- What does it mean?
- Migration from pure Cassandra to Hybrid DB Approach
- We still support Cassandra for storing telemetry data but not the entities like devices, customers, tenants, etc.
- What does it mean?
- This will simplify maintenance and future improvements that will enable advanced search capabilities in v3.1.
- How to upgrade?
- If you are using pure PostgreSQL setup or PostgreSQL (for entities) + Cassandra (for telemetry), you are not affected.
- If you are using pure Cassandra - the upgrade procedure is automatic but takes some time. The downtime depends on the number of devices, attributes, alarms and relations. If you have less than 10 million of those entities the upgrade should take a few minutes and depends on the database performance.
Since ThingsBoard 3.0PE only PostgreSQL database is supported for entities data
- If you are using Cassandra database for entities data please install PostgreSQL database before proceeding upgrade procedure using the following guide:
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.ts.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
NOTE: If you were using Cassandra database for entities data execute the following migration script:
1
2
# Execute migration script from Cassandra to PostgreSQL
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.5.0PE-cassandra
Otherwise execute regular upgrade script:
1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.5.0
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 3.0PE. In order to upgrade to 3.0.1PE you need to upgrade to 3.0PE first.
Important note before upgrading to ThingsBoard 3.0
- ThingsBoard UI was rewritten from AngularJS 1.5.8 to use Angular 9.
- What does it mean?
- Generally speaking, it means: state of the art application, easier development of front-end elements, performance improvements and more flexibility with UI customizations.
- How to upgrade?
- You are safe to upgrade if you do NOT use custom widgets or custom actions in the dashboards.
- New JS framework may not support your current code — custom widgets and custom actions, so they need to be refactored a bit. Thus we encourage you to test your customizations using our cloud environments or your dev instances.
- What does it mean?
- Migration from pure Cassandra to Hybrid DB Approach
- We still support Cassandra for storing telemetry data but not the entities like devices, customers, tenants, etc.
- What does it mean?
- This will simplify maintenance and future improvements that will enable advanced search capabilities in v3.1.
- How to upgrade?
- If you are using pure PostgreSQL setup or PostgreSQL (for entities) + Cassandra (for telemetry), you are not affected.
- If you are using pure Cassandra - the upgrade procedure is automatic but takes some time. The downtime depends on the number of devices, attributes, alarms and relations. If you have less than 10 million of those entities the upgrade should take a few minutes and depends on the database performance.
Since ThingsBoard 3.0PE only PostgreSQL database is supported for entities data
- If you are using Cassandra database for entities data please install PostgreSQL database before proceeding upgrade procedure using the following guide:
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-3.0.1pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-3.0.1pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Please make sure that you set database.ts.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
- Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
NOTE: If you were using Cassandra database for entities data execute the following migration script:
1
C:\thingsboard>upgrade.bat --fromVersion=2.5.0PE-cassandra
Otherwise execute regular upgrade script:
1
C:\thingsboard>upgrade.bat --fromVersion=2.5.0
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 3.0PE
NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.6PE. In order to upgrade to 3.0PE you need to upgrade to 2.5.6PE first.
Ubuntu/CentOS
Important note before upgrading to ThingsBoard 3.0
- ThingsBoard UI was rewritten from AngularJS 1.5.8 to use Angular 9.
- What does it mean?
- Generally speaking, it means: state of the art application, easier development of front-end elements, performance improvements and more flexibility with UI customizations.
- How to upgrade?
- You are safe to upgrade if you do NOT use custom widgets or custom actions in the dashboards.
- New JS framework may not support your current code — custom widgets and custom actions, so they need to be refactored a bit. Thus we encourage you to test your customizations using our cloud environments or your dev instances.
- What does it mean?
- Migration from pure Cassandra to Hybrid DB Approach
- We still support Cassandra for storing telemetry data but not the entities like devices, customers, tenants, etc.
- What does it mean?
- This will simplify maintenance and future improvements that will enable advanced search capabilities in v3.1.
- How to upgrade?
- If you are using pure PostgreSQL setup or PostgreSQL (for entities) + Cassandra (for telemetry), you are not affected.
- If you are using pure Cassandra - the upgrade procedure is automatic but takes some time. The downtime depends on the number of devices, attributes, alarms and relations. If you have less than 10 million of those entities the upgrade should take a few minutes and depends on the database performance.
Since ThingsBoard 3.0PE only PostgreSQL database is supported for entities data
- If you are using Cassandra database for entities data please install PostgreSQL database before proceeding upgrade procedure using the following guide:
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.ts.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
NOTE: If you were using Cassandra database for entities data execute the following migration script:
1
2
# Execute migration script from Cassandra to PostgreSQL
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.5.0PE-cassandra
Otherwise execute regular upgrade script:
1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.5.0
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.6PE. In order to upgrade to 3.0PE you need to upgrade to 2.5.6PE first.
Important note before upgrading to ThingsBoard 3.0
- ThingsBoard UI was rewritten from AngularJS 1.5.8 to use Angular 9.
- What does it mean?
- Generally speaking, it means: state of the art application, easier development of front-end elements, performance improvements and more flexibility with UI customizations.
- How to upgrade?
- You are safe to upgrade if you do NOT use custom widgets or custom actions in the dashboards.
- New JS framework may not support your current code — custom widgets and custom actions, so they need to be refactored a bit. Thus we encourage you to test your customizations using our cloud environments or your dev instances.
- What does it mean?
- Migration from pure Cassandra to Hybrid DB Approach
- We still support Cassandra for storing telemetry data but not the entities like devices, customers, tenants, etc.
- What does it mean?
- This will simplify maintenance and future improvements that will enable advanced search capabilities in v3.1.
- How to upgrade?
- If you are using pure PostgreSQL setup or PostgreSQL (for entities) + Cassandra (for telemetry), you are not affected.
- If you are using pure Cassandra - the upgrade procedure is automatic but takes some time. The downtime depends on the number of devices, attributes, alarms and relations. If you have less than 10 million of those entities the upgrade should take a few minutes and depends on the database performance.
Since ThingsBoard 3.0PE only PostgreSQL database is supported for entities data
- If you are using Cassandra database for entities data please install PostgreSQL database before proceeding upgrade procedure using the following guide:
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-3.0pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-3.0pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Please make sure that you set database.ts.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:
1
2
3
4
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
- Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
NOTE: If you were using Cassandra database for entities data execute the following migration script:
1
C:\thingsboard>upgrade.bat --fromVersion=2.5.0PE-cassandra
Otherwise execute regular upgrade script:
1
C:\thingsboard>upgrade.bat --fromVersion=2.5.0
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 2.5.6PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.5PE. In order to upgrade to 2.5.6PE you need to upgrade to 2.5.5PE first.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.5PE. In order to upgrade to 2.5.6PE you need to upgrade to 2.5.5PE first.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-2.5.6pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-2.5.6pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 2.5.5PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.4PE. In order to upgrade to 2.5.5PE you need to upgrade to 2.5.4PE first.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.4PE. In order to upgrade to 2.5.5PE you need to upgrade to 2.5.4PE first.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-2.5.5pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-2.5.5pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 2.5.4PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.3PE. In order to upgrade to 2.5.4PE you need to upgrade to 2.5.3PE first.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.3PE. In order to upgrade to 2.5.4PE you need to upgrade to 2.5.3PE first.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-2.5.4pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-2.5.4pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 2.5.3PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.2PE. In order to upgrade to 2.5.3PE you need to upgrade to 2.5.2PE first.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.2PE. In order to upgrade to 2.5.3PE you need to upgrade to 2.5.2PE first.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-2.5.3pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-2.5.3pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 2.5.2PE
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.1PE. In order to upgrade to 2.5.2PE you need to upgrade to 2.5.1PE first.
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Upgrading ThingsBoard to 2.5.2 version in case of using PostgreSQL database require to upgrade the PostgreSQL service to 11.x version.
Please refer to the guides below that will describe how to upgrade your PostgreSQL service on:
NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.1PE. In order to upgrade to 2.5.2PE you need to upgrade to 2.5.1PE first.
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-2.5.2pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-2.5.2pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
-
Please note that upgrading ThingsBoard PE from 2.4.3 to 2.5.1 version in case of using PostgreSQL database require to upgrade the PostgreSQL service to 11.x version.
- Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
1
C:\thingsboard>upgrade.bat --fromVersion=2.4.3
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 2.5.1PE
These steps are applicable for 2.4.3PE ThingsBoard Professional Edition version.
Ubuntu/CentOS
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Upgrading ThingsBoard PE from 2.4.3 to 2.5.1 version in case of using PostgreSQL database require to upgrade the PostgreSQL service to 11.x version.
Please refer to the guides below that will describe how to upgrade your PostgreSQL service on:
NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Finally, execute upgrade script:
1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.4.3
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-2.5.1pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-2.5.1pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
-
Please note that upgrading ThingsBoard PE from 2.4.3 to 2.5.1 version in case of using PostgreSQL database require to upgrade the PostgreSQL service to 11.x version.
- Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
1
C:\thingsboard>upgrade.bat --fromVersion=2.4.3
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 2.5PE
These steps are applicable for 2.4.3PE ThingsBoard Professional Edition version.
Ubuntu/CentOS
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Upgrading ThingsBoard PE from 2.4.3 to 2.5 version in case of using PostgreSQL database require to upgrade the PostgreSQL service to 11.x version.
Please refer to the guides below that will describe how to upgrade your PostgreSQL service on:
NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.entities.type and database.ts.type parameters values (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
3
4
5
6
7
8
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
entities:
type: "${DATABASE_ENTITIES_TYPE:sql}" # cassandra OR sql
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
# note: timescale works only with postgreSQL database for DATABASE_ENTITIES_TYPE.
NOTE: If you are using PostgreSql(Sql) for time-series data storage before executing the upgrade script, go to the PostgreSQL terminal(psql) and follow the instructions below:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
# Connect to thingsboard database:
\c thingsboard
# Execute the next commands:
# Update ts_kv table constraints:
ALTER TABLE ts_kv DROP CONSTRAINT IF EXISTS ts_kv_unq_key;
ALTER TABLE ts_kv DROP CONSTRAINT IF EXISTS ts_kv_pkey;
ALTER TABLE ts_kv ADD CONSTRAINT ts_kv_pkey PRIMARY KEY (entity_type, entity_id, key, ts);
# Update ts_kv_latest table constraints:
ALTER TABLE ts_kv_latest DROP CONSTRAINT IF EXISTS ts_kv_latest_unq_key;
ALTER TABLE ts_kv_latest DROP CONSTRAINT IF EXISTS ts_kv_latest_pkey;
ALTER TABLE ts_kv_latest ADD CONSTRAINT ts_kv_latest_pkey PRIMARY KEY (entity_type, entity_id, key);
# exit psql terminal
\q
Finally, execute upgrade script:
1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.4.3
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-2.5pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-2.5pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Please note that upgrading ThingsBoard PE from 2.4.3 to 2.5 version in case of using PostgreSQL database require to upgrade the PostgreSQL service to 11.x version.
- Please make sure that you set database.entities.type and database.ts.type parameters values (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
3
4
5
6
7
8
database:
ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
entities:
type: "${DATABASE_ENTITIES_TYPE:sql}" # cassandra OR sql
ts:
type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
# note: timescale works only with postgreSQL database for DATABASE_ENTITIES_TYPE.
NOTE: If you are using PostgreSql(Sql) for time-series data storage before executing the upgrade script, you need to access the psql terminal. Once you will be logged to the psql terminal, please follow the instructions below:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
# Connect to thingsboard database:
\c thingsboard
# Execute the next commands:
# Update ts_kv table constraints:
ALTER TABLE ts_kv DROP CONSTRAINT IF EXISTS ts_kv_unq_key;
ALTER TABLE ts_kv DROP CONSTRAINT IF EXISTS ts_kv_pkey;
ALTER TABLE ts_kv ADD CONSTRAINT ts_kv_pkey PRIMARY KEY (entity_type, entity_id, key, ts);
# Update ts_kv_latest table constraints:
ALTER TABLE ts_kv_latest DROP CONSTRAINT IF EXISTS ts_kv_latest_unq_key;
ALTER TABLE ts_kv_latest DROP CONSTRAINT IF EXISTS ts_kv_latest_pkey;
ALTER TABLE ts_kv_latest ADD CONSTRAINT ts_kv_latest_pkey PRIMARY KEY (entity_type, entity_id, key);
# exit psql terminal
\q
- Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
1
C:\thingsboard>upgrade.bat --fromVersion=2.4.3
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 2.4.3PE
These steps are applicable for 2.4.2PE and 2.4.2.1PE ThingsBoard Professional Edition versions.
Ubuntu/CentOS
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.entities.type and database.ts.type parameters values (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
3
4
5
database:
entities:
type: "${DATABASE_ENTITIES_TYPE:cassandra}" # cassandra OR sql
ts:
type: "${DATABASE_TS_TYPE:cassandra}" # cassandra OR sql (for hybrid mode, only this value should be cassandra)
Execute upgrade script:
1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.4.2
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-2.4.3pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-2.4.3pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Please make sure that you set database.entities.type and database.ts.type parameters values (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
3
4
5
database:
entities:
type: "${DATABASE_ENTITIES_TYPE:cassandra}" # cassandra OR sql
ts:
type: "${DATABASE_TS_TYPE:cassandra}" # cassandra OR sql (for hybrid mode, only this value should be cassandra)
- Run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
1
C:\thingsboard>upgrade.bat --fromVersion=2.4.2
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 2.4.2.1PE
These steps are applicable for 2.4.1PE and 2.4.2PE ThingsBoard Professional Edition versions.
Ubuntu/CentOS
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.entities.type and database.ts.type parameters values (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
3
4
5
database:
entities:
type: "${DATABASE_ENTITIES_TYPE:cassandra}" # cassandra OR sql
ts:
type: "${DATABASE_TS_TYPE:cassandra}" # cassandra OR sql (for hybrid mode, only this value should be cassandra)
Execute upgrade script:
1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.4.1
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-2.4.2.1pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-2.4.2.1pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Please make sure that you set database.entities.type and database.ts.type parameters values (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
3
4
5
database:
entities:
type: "${DATABASE_ENTITIES_TYPE:cassandra}" # cassandra OR sql
ts:
type: "${DATABASE_TS_TYPE:cassandra}" # cassandra OR sql (for hybrid mode, only this value should be cassandra)
- Run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
1
C:\thingsboard>upgrade.bat --fromVersion=2.4.1
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Upgrading to 2.4.1PE
These steps are applicable for 2.4.0PE ThingsBoard Professional Edition version.
Ubuntu/CentOS
ThingsBoard PE package download
|
|
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
sudo service thingsboard stop
- Install Thingsboard Web Report component as described here.
NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.entities.type and database.ts.type parameters values (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
3
4
5
database:
entities:
type: "${DATABASE_ENTITIES_TYPE:cassandra}" # cassandra OR sql
ts:
type: "${DATABASE_TS_TYPE:cassandra}" # cassandra OR sql (for hybrid mode, only this value should be cassandra)
Execute upgrade script:
1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.4.0
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
sudo service thingsboard start
Windows
ThingsBoard PE package download
Download ThingsBoard PE installation package for Windows: thingsboard-windows-setup-2.4.1pe.exe.
ThingsBoard PE service upgrade
- Stop ThingsBoard service if it is running.
1
net stop thingsboard
- Make a backup of previous ThingsBoard PE configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Run installation package thingsboard-windows-setup-2.4.1pe.exe.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Please make sure that you set database.entities.type and database.ts.type parameters values (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
3
4
5
database:
entities:
type: "${DATABASE_ENTITIES_TYPE:cassandra}" # cassandra OR sql
ts:
type: "${DATABASE_TS_TYPE:cassandra}" # cassandra OR sql (for hybrid mode, only this value should be cassandra)
- Run upgrade.bat script to upgrade ThingsBoard to the new version.
NOTE Scripts listed above should be executed using Administrator Role.
1
C:\thingsboard>upgrade.bat --fromVersion=2.4.0
Start the service
If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.
Connect to your Redis instance (or container/pod, depending on your setup) and run the command:
redis-cli flushall
Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.
redis-cli
select 0
flushdb
1
net start thingsboard
Next steps
-
入门指南 - 快速学习ThingsBoard相关功能。
-
连接设备 - 学习如何根据你的连接方式或解决方案连接设备。
-
可 视 化 - 学习如何配置复杂的ThingsBoard仪表板说明。
-
数据处理 - 学习如何使用ThingsBoard规则引擎。
-
数据分析 - 学习如何使用规则引擎执行基本的分析任务。
-
硬件样品 - 学习如何将各种硬件平台连接到ThingsBoard。
-
高级功能 - 学习高级ThingsBoard功能。
-
开发指南 - 学习ThingsBoard中的贡献和开发。
