In order to update to new ThingsBoard releases, please follow these CE and PE instructions
Upgrading to 1.0.3
These steps are applicable for 1.0, 1.0.1 and 1.0.2 ThingsBoard versions.
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v1.0.3/thingsboard-1.0.3.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v1.0.3/thingsboard-1.0.3.rpm
|
|
ThingsBoard service upgrade
1
| sudo dpkg -i thingsboard-1.0.3.deb
|
|
1
| sudo rpm -Uvh thingsboard-1.0.3.rpm
|
|
Database upgrade
This step is required only if you are upgrading from 1.0 or 1.0.1 versions.
Please use following instruction to update your single node instance:
Download upgrade scripts:
1
2
| wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.0.3/upgrade_1.0_1.0.2.sh
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.0.3/system_widgets_1.0_1.0.2.cql
|
Launch main script:
1
2
| chmod +x upgrade_1.0_1.0.2.sh
./upgrade_1.0_1.0.2.sh
|
Start the service
1
| sudo service thingsboard start
|
Upgrading to 1.1.0
These steps are applicable for 1.0.3 ThingsBoard version.
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v1.1/thingsboard-1.1.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v1.1/thingsboard-1.1.rpm
|
|
ThingsBoard service upgrade
1
| sudo dpkg -i thingsboard-1.1.deb
|
|
1
| sudo rpm -Uvh thingsboard-1.1.rpm
|
|
Database upgrade
Please use the following instruction to update your single node instance:
Download upgrade scripts:
1
2
| wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.1.0/upgrade_1.0.3_1.1.0.sh
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.1.0/system_widgets_1.0.3_1.1.0.cql
|
Launch main script:
1
2
| chmod +x upgrade_1.0.3_1.1.0.sh
./upgrade_1.0.3_1.1.0.sh
|
Start the service
1
| $ sudo service thingsboard start
|
Upgrading to 1.2.0
These steps are applicable for 1.1.0 ThingsBoard version.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v1.2/thingsboard-1.2.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v1.2/thingsboard-1.2.rpm
|
|
ThingsBoard service upgrade
1
| sudo dpkg -i thingsboard-1.2.deb
|
|
1
| sudo rpm -Uvh thingsboard-1.2.rpm
|
|
Database upgrade
Download upgrade scripts:
1
2
| wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.0/upgrade_1.1.0_1.2.0.sh
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.0/system_widgets.cql
|
Launch main script:
1
2
| chmod +x upgrade_1.1.0_1.2.0.sh
./upgrade_1.1.0_1.2.0.sh
|
Start the service
1
| sudo service thingsboard start
|
Windows
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-1.2.zip.
ThingsBoard service upgrade
- Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Uninstall the previous version of ThingsBoard service by running uninstall.bat located in ThingsBoard install dir.
NOTE Scripts listed above should be executed using Administrator Role.
1
| C:\thingsboard>uninstall.bat
|
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Run install.bat script to install the new version of ThingsBoard as a Windows service.
1
| C:\thingsboard>install.bat
|
Database upgrade
- Download upgrade scripts to some folder:
- Execute upgrade_1.1.0_1.2.0.bat (NOTE This script should be executed using Administrative Role)
1
| upgrade_1.1.0_1.2.0.bat
|
Start the service
Upgrading to 1.2.1
These steps are applicable for 1.2.0 ThingsBoard version.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v1.2.1/thingsboard-1.2.1.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v1.2.1/thingsboard-1.2.1.rpm
|
|
ThingsBoard service upgrade
1
| sudo dpkg -i thingsboard-1.2.1.deb
|
|
1
| sudo rpm -Uvh thingsboard-1.2.1.rpm
|
|
Database upgrade
Download upgrade scripts:
1
2
3
| wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.1/upgrade_1.2.0_1.2.1.sh
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.1/schema_update.cql
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.1/system_widgets.cql
|
Launch main script:
1
2
| chmod +x upgrade_1.2.0_1.2.mqtt-js-telemetry-data-as-object.sh
./upgrade_1.2.0_1.2.mqtt-js-telemetry-data-as-object.sh
|
Start the service
1
| sudo service thingsboard start
|
Windows
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-1.2.1.zip.
ThingsBoard service upgrade
- Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Uninstall the previous version of ThingsBoard service by running uninstall.bat located in ThingsBoard install dir.
NOTE Scripts listed above should be executed using Administrator Role.
1
| C:\thingsboard>uninstall.bat
|
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Run install.bat script to install the new version of ThingsBoard as a Windows service.
1
| C:\thingsboard>install.bat
|
Database upgrade
- Download upgrade scripts to some folder:
- Execute upgrade_1.2.0_1.2.1.bat (NOTE This script should be executed using Administrative Role)
1
| upgrade_1.2.0_1.2.1.bat
|
Start the service
Upgrading to 1.2.2
These steps are applicable for 1.2.1 ThingsBoard version.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v1.2.2/thingsboard-1.2.2.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v1.2.2/thingsboard-1.2.2.rpm
|
|
ThingsBoard service upgrade
1
| sudo dpkg -i thingsboard-1.2.2.deb
|
|
1
| sudo rpm -Uvh thingsboard-1.2.2.rpm
|
|
Database upgrade
Download upgrade scripts:
1
2
| wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.2/upgrade_1.2.1_1.2.2.sh
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.2/system_widgets.cql
|
Launch main script:
1
2
| chmod +x upgrade_1.2.1_1.2.2.sh
./upgrade_1.2.1_1.2.2.sh
|
Start the service
1
| sudo service thingsboard start
|
Windows
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-1.2.2.zip.
ThingsBoard service upgrade
- Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Uninstall the previous version of ThingsBoard service by running uninstall.bat located in ThingsBoard install dir.
NOTE Scripts listed above should be executed using Administrator Role.
1
| C:\thingsboard>uninstall.bat
|
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Run install.bat script to install the new version of ThingsBoard as a Windows service.
1
| C:\thingsboard>install.bat
|
Database upgrade
- Download upgrade scripts to some folder:
- Execute upgrade_1.2.1_1.2.2.bat (NOTE This script should be executed using Administrative Role)
1
| upgrade_1.2.1_1.2.2.bat
|
Start the service
Upgrading to 1.2.3
These steps are applicable for 1.2.2 ThingsBoard version.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v1.2.3/thingsboard-1.2.3.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v1.2.3/thingsboard-1.2.3.rpm
|
|
ThingsBoard service upgrade
1
| sudo dpkg -i thingsboard-1.2.3.deb
|
|
1
| sudo rpm -Uvh thingsboard-1.2.3.rpm
|
|
Database upgrade
Download upgrade scripts:
1
2
3
| wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.3/upgrade_1.2.2_1.2.3.sh
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.3/schema_update.cql
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.3/system_widgets.cql
|
Launch main script:
1
2
| chmod +x upgrade_1.2.2_1.2.3.sh
./upgrade_1.2.2_1.2.3.sh
|
Start the service
1
| sudo service thingsboard start
|
Windows
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-1.2.3.zip.
ThingsBoard service upgrade
- Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Uninstall the previous version of ThingsBoard service by running uninstall.bat located in ThingsBoard install dir.
NOTE Scripts listed above should be executed using Administrator Role.
1
| C:\thingsboard>uninstall.bat
|
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Run install.bat script to install the new version of ThingsBoard as a Windows service.
1
| C:\thingsboard>install.bat
|
Database upgrade
- Download upgrade scripts to some folder:
- Execute upgrade_1.2.2_1.2.3.bat (NOTE This script should be executed using Administrative Role)
1
| upgrade_1.2.2_1.2.3.bat
|
Start the service
Upgrading to 1.3.0
These steps are applicable for 1.2.3 ThingsBoard version.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v1.3/thingsboard-1.3.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v1.3/thingsboard-1.3.rpm
|
|
ThingsBoard service upgrade
1
| sudo dpkg -i thingsboard-1.3.deb
|
|
1
| sudo rpm -Uvh thingsboard-1.3.rpm
|
|
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.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
| database:
type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
|
Execute upgrade script:
1
| sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=1.2.3
|
Start the service
1
| sudo service thingsboard start
|
Windows
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-1.3.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
- Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- 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.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
| database:
type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
|
- 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=1.2.3
|
Start the service
Upgrading to 1.3.1
These steps are applicable for 1.3.0 ThingsBoard version.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v1.3.1/thingsboard-1.3.1.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v1.3.1/thingsboard-1.3.1.rpm
|
|
ThingsBoard service upgrade
1
| sudo dpkg -i thingsboard-1.3.1.deb
|
|
1
| sudo rpm -Uvh thingsboard-1.3.1.rpm
|
|
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.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
| database:
type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
|
Execute upgrade script:
1
| sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=1.3.0
|
Start the service
1
| sudo service thingsboard start
|
Windows
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-1.3.1.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
- Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- 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.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
| database:
type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
|
- 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=1.3.0
|
Start the service
Upgrading to 1.4.0
These steps are applicable for 1.3.1 ThingsBoard version.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v1.4/thingsboard-1.4.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v1.4/thingsboard-1.4.rpm
|
|
ThingsBoard service upgrade
1
| sudo dpkg -i thingsboard-1.4.deb
|
|
1
| sudo rpm -Uvh thingsboard-1.4.rpm
|
|
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.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
| database:
type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
|
Execute upgrade script:
1
| sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=1.3.1
|
Start the service
1
| sudo service thingsboard start
|
Windows
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-1.4.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
- Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- 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.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
| database:
type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
|
- 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=1.3.1
|
Start the service
Upgrading to 2.0.0
These steps are applicable for 1.4.0 ThingsBoard version.
Ubuntu/CentOS
|
Important note
Please note that during upgrade procedure old rules and plugins will be completely removed from your ThingsBoard instance.
Old rules and plugins functionality is replaced by new rule engine components (rule chains and rule nodes).
If you have configured rules or plugins you need to backup them using export function before performing upgrade.
After upgrade you will need to configure new rule chains in order to restore your application logic performed by old rules/plugins.
Please refer to new rule engine documentation for details.
|
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.0/thingsboard-2.0.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.0/thingsboard-2.0.rpm
|
|
ThingsBoard service upgrade
1
| sudo dpkg -i thingsboard-2.0.deb
|
|
1
| sudo rpm -Uvh thingsboard-2.0.rpm
|
|
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.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
| database:
type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
|
Execute upgrade script:
1
| sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=1.4.0
|
Start the service
1
| sudo service thingsboard start
|
Windows
|
Important note
Please note that during upgrade procedure old rules and plugins will be completely removed from your ThingsBoard instance.
Old rules and plugins functionality is replaced by new rule engine components (rule chains and rule nodes).
If you have configured rules or plugins you need to backup them using export function before performing upgrade.
After upgrade you will need to configure new rule chains in order to restore your application logic performed by old rules/plugins.
Please refer to new rule engine documentation for details.
|
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-2.0.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
- Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- 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.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
| database:
type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
|
- 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=1.4.0
|
Start the service
Upgrading to 2.0.1
These steps are applicable for 2.0.0 ThingsBoard version.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.0.1/thingsboard-2.0.1.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.0.1/thingsboard-2.0.1.rpm
|
|
ThingsBoard service upgrade
1
| sudo dpkg -i thingsboard-2.0.1.deb
|
|
1
| sudo rpm -Uvh thingsboard-2.0.1.rpm
|
|
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.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
| database:
type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
|
Start the service
1
| sudo service thingsboard start
|
Windows
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-2.0.1.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
- Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- 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.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
| database:
type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
|
Start the service
Upgrading to 2.0.2
These steps are applicable for 2.0.1 ThingsBoard version.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.0.2/thingsboard-2.0.2.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.0.2/thingsboard-2.0.2.rpm
|
|
ThingsBoard service upgrade
1
| sudo dpkg -i thingsboard-2.0.2.deb
|
|
1
| sudo rpm -Uvh thingsboard-2.0.2.rpm
|
|
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.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
| database:
type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
|
Start the service
1
| sudo service thingsboard start
|
Windows
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-2.0.2.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
- Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- 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.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
| database:
type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
|
Start the service
Upgrading to 2.0.3
These steps are applicable for 2.0.2 ThingsBoard version.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.0.3/thingsboard-2.0.3.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.0.3/thingsboard-2.0.3.rpm
|
|
ThingsBoard service upgrade
1
| sudo dpkg -i thingsboard-2.0.3.deb
|
|
1
| sudo rpm -Uvh thingsboard-2.0.3.rpm
|
|
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.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
| database:
type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
|
Start the service
1
| sudo service thingsboard start
|
Windows
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-2.0.3.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
- Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- 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.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
| database:
type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
|
Start the service
Upgrading to 2.1.0
These steps are applicable for 2.0.3 ThingsBoard version.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.1/thingsboard-2.1.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.1/thingsboard-2.1.rpm
|
|
ThingsBoard service upgrade
1
| sudo dpkg -i thingsboard-2.1.deb
|
|
1
| sudo rpm -Uvh thingsboard-2.1.rpm
|
|
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.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
| database:
type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
|
Start the service
1
| sudo service thingsboard start
|
Windows
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-2.1.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
- Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- 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.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
| database:
type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
|
Start the service
Upgrading to 2.2.0
These steps are applicable for 2.1.0, 2.1.1, 2.1.2 and 2.1.3 ThingsBoard versions.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.2/thingsboard-2.2.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.2/thingsboard-2.2.rpm
|
|
ThingsBoard service upgrade
1
| sudo dpkg -i thingsboard-2.2.deb
|
|
1
| sudo rpm -Uvh thingsboard-2.2.rpm
|
|
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.0.0
|
Start the service
1
| sudo service thingsboard start
|
Windows
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-2.2.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
- Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- 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.0.0
|
Start the service
Upgrading to 2.3.0
These steps are applicable for 2.2.0 ThingsBoard version.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.3/thingsboard-2.3.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.3/thingsboard-2.3.rpm
|
|
ThingsBoard service upgrade
1
| sudo dpkg -i thingsboard-2.3.deb
|
|
1
| sudo rpm -Uvh thingsboard-2.3.rpm
|
|
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.2.0
|
Start the service
1
| sudo service thingsboard start
|
Windows
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-2.3.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
- Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- 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.2.0
|
Start the service
Upgrading to 2.4.0
These steps are applicable for 2.3.1 ThingsBoard version.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.4/thingsboard-2.4.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.4/thingsboard-2.4.rpm
|
|
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
1
| $ sudo service thingsboard stop
|
1
| sudo dpkg -i thingsboard-2.4.deb
|
|
1
| sudo rpm -Uvh thingsboard-2.4.rpm
|
|
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.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
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-2.4.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
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.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
Upgrading to 2.4.1
These steps are applicable for 2.4.0 ThingsBoard version.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.4.1/thingsboard-2.4.1.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.4.1/thingsboard-2.4.1.rpm
|
|
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
1
| $ sudo service thingsboard stop
|
1
| sudo dpkg -i thingsboard-2.4.1.deb
|
|
1
| sudo rpm -Uvh thingsboard-2.4.1.rpm
|
|
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 package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-2.4.1.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
- Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- 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
Upgrading to 2.4.2.1
These steps are applicable for 2.4.1 and 2.4.2 ThingsBoard versions.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.4.2.1/thingsboard-2.4.2.1.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.4.2.1/thingsboard-2.4.2.1.rpm
|
|
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
1
| $ sudo service thingsboard stop
|
1
| sudo dpkg -i thingsboard-2.4.2.1.deb
|
|
1
| sudo rpm -Uvh thingsboard-2.4.2.1.rpm
|
|
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 package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-2.4.2.1.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
- Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- 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
Upgrading to 2.4.3
These steps are applicable for 2.4.2 and 2.4.2.1 ThingsBoard versions.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.4.3/thingsboard-2.4.3.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.4.3/thingsboard-2.4.3.rpm
|
|
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
1
| $ sudo service thingsboard stop
|
1
| sudo dpkg -i thingsboard-2.4.3.deb
|
|
1
| sudo rpm -Uvh thingsboard-2.4.3.rpm
|
|
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 package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-2.4.3.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
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
Upgrading to 2.5
These steps are applicable for 2.4.3 ThingsBoard version.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.5/thingsboard-2.5.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.5/thingsboard-2.5.rpm
|
|
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
1
| $ sudo service thingsboard stop
|
1
| sudo dpkg -i thingsboard-2.5.deb
|
|
1
| sudo rpm -Uvh thingsboard-2.5.rpm
|
|
NOTE: Upgrading ThingsBoard 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 package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-2.5.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
- Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
- Please note that upgrading ThingsBoard 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
Upgrading to 2.5.1
These steps are applicable for 2.4.3+ ThingsBoard version.
Ubuntu/CentOS
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.1/thingsboard-2.5.1.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.1/thingsboard-2.5.1.rpm
|
|
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
1
| $ sudo service thingsboard stop
|
1
| sudo dpkg -i thingsboard-2.5.1.deb
|
|
1
| sudo rpm -Uvh thingsboard-2.5.1.rpm
|
|
NOTE: Upgrading ThingsBoard 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 and specify your previous ThingsBoard version:
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 package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-2.5.1.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
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
Upgrading to 2.5.2
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.1. In order to upgrade to 2.5.2 you need to upgrade to 2.5.1 first.
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.2/thingsboard-2.5.2.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.2/thingsboard-2.5.2.rpm
|
|
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
1
| $ sudo service thingsboard stop
|
1
| sudo dpkg -i thingsboard-2.5.2.deb
|
|
1
| sudo rpm -Uvh thingsboard-2.5.2.rpm
|
|
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.1. In order to upgrade to 2.5.2 you need to upgrade to 2.5.1 first.
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-2.5.2.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
-
Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
-
Please note that upgrading ThingsBoard from 2.4.3 to 2.5 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
Upgrading to 2.5.3
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.2. In order to upgrade to 2.5.3 you need to upgrade to 2.5.2 first.
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.3/thingsboard-2.5.3.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.3/thingsboard-2.5.3.rpm
|
|
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
1
| $ sudo service thingsboard stop
|
1
| sudo dpkg -i thingsboard-2.5.3.deb
|
|
1
| sudo rpm -Uvh thingsboard-2.5.3.rpm
|
|
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.2. In order to upgrade to 2.5.3 you need to upgrade to 2.5.2 first.
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-2.5.3.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
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
Upgrading to 2.5.4
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.3. In order to upgrade to 2.5.4 you need to upgrade to 2.5.3 first.
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.4/thingsboard-2.5.4.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.4/thingsboard-2.5.4.rpm
|
|
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
1
| $ sudo service thingsboard stop
|
1
| sudo dpkg -i thingsboard-2.5.4.deb
|
|
1
| sudo rpm -Uvh thingsboard-2.5.4.rpm
|
|
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.3. In order to upgrade to 2.5.4 you need to upgrade to 2.5.3 first.
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-2.5.4.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
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
Upgrading to 2.5.5
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.4. In order to upgrade to 2.5.5 you need to upgrade to 2.5.4 first.
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.5/thingsboard-2.5.5.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.5/thingsboard-2.5.5.rpm
|
|
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
1
| $ sudo service thingsboard stop
|
1
| sudo dpkg -i thingsboard-2.5.5.deb
|
|
1
| sudo rpm -Uvh thingsboard-2.5.5.rpm
|
|
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.4. In order to upgrade to 2.5.5 you need to upgrade to 2.5.4 first.
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-2.5.5.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
- Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
- Remove ThingsBoard install dir.
- Unzip installation archive to ThingsBoard install dir.
- 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
Upgrading to 2.5.6
Ubuntu/CentOS
NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.5. In order to upgrade to 2.5.6 you need to upgrade to 2.5.5 first.
ThingsBoard package download
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.6/thingsboard-2.5.6.deb
|
|
1
| wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.6/thingsboard-2.5.6.rpm
|
|
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
1
| $ sudo service thingsboard stop
|
1
| sudo dpkg -i thingsboard-2.5.6.deb
|
|
1
| sudo rpm -Uvh thingsboard-2.5.6.rpm
|
|
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.5. In order to upgrade to 2.5.6 you need to upgrade to 2.5.5 first.
ThingsBoard package download
Download ThingsBoard installation archive for Windows: thingsboard-windows-2.5.6.zip.
ThingsBoard service upgrade
- Stop ThingsBoard service if it is running.
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
Next steps