配置ThingsBoard数据库
PostgreSQL安装
# Update your system
sudo yum update
# Install the repository RPM:
sudo yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
# Install packages
sudo yum install postgresql10-server postgresql10-contrib
# Initialize your PostgreSQL DB
sudo /usr/pgsql-10/bin/postgresql-10-setup initdb
sudo systemctl start postgresql-10
# Optional: Configure PostgreSQL to start on boot
sudo systemctl enable postgresql-10
安装好会自动创建了一个PostgreSQL用户postgres
配置密码:
sudo su - postgres
psql
\password
123456
\q
这里的123456是我设置的密码。
然后,按“ Ctrl + D”返回主用户控制台。
编辑pg_hba.conf以对postgres用户使用MD5认证。
编辑pg_hba.conf文件:
vim /var/lib/pgsql/10/data/pg_hba.conf
把这一行的ident改成md5
修改为:
重新启动PostgreSQL服务以初始化新配置:
sudo systemctl restart postgresql-10.service
连接到数据库以创建Thingsboard DB:
psql -U postgres -d postgres -h 127.0.0.1 -W
CREATE DATABASE thingsboard;
\q
2.4 Cassandra安装
# Add cassandra repository
sudo touch /etc/yum.repos.d/datastax.repo
echo '[datastax]' | sudo tee --append /etc/yum.repos.d/datastax.repo > /dev/null
echo 'name = DataStax Repo for Apache Cassandra' | sudo tee --append /etc/yum.repos.d/datastax.repo > /dev/null
echo 'baseurl = http://rpm.datastax.com/community' | sudo tee --append /etc/yum.repos.d/datastax.repo > /dev/null
echo 'enabled = 1' | sudo tee --append /etc/yum.repos.d/datastax.repo > /dev/null
echo 'gpgcheck = 0' | sudo tee --append /etc/yum.repos.d/datastax.repo > /dev/null
# Cassandra installation
sudo yum install dsc30
# Tools installation
sudo yum install cassandra30-tools
# Start Cassandra
sudo service cassandra start
# Configure the database to start automatically when OS starts.
sudo chkconfig cassandra on