阿里云centos下配置mqtt swoole clickhouse新建服务器流程

服务器初始化安装步骤：

1、阿里云服务器Alibaba Cloud Linux 3.2104 LTS 64位，设置好安全策略端口，安装宝塔Centos/OpenCloud/Alibaba稳定版9.0.0

url=https://download.bt.cn/install/install_lts.sh;if [ -f /usr/bin/curl ];then curl -sSO $url;else wget -O install_lts.sh $url;fi;bash install_lts.sh ed8484bec

2、安装PHP8然后安装扩展swoole5

查看是否安装，注意可能不同版本路径不一样，此为PHP8.0版本

/www/server/php/80/bin/php --ri swoole

cd到目录

cd /www/wwwroot/jwxt.cnfengwei.cn/haihui

不守护进程启动swoole_http

/www/server/php/80/bin/php swoole_http.php

nohup启动(重启服务器后需要运行次命令，启动swoole进程)

nohup /www/server/php/80/bin/php /www/wwwroot/jwxt.cnfengwei.cn/haihui/swoole_http.php > http_post_log.txt 2>&1 &

nohup /www/server/php/80/bin/php /www/wwwroot/haihui/swoole_http.php > http_post_log.txt 2>&1 &

网站安装，导入数据库，修改数据库账户密码

设置伪静态

<IfModule mod_rewrite.c>
Options +FollowSymlinks -Multiviews
RewriteEngine on
 
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^(.*)$ index.php?/$1 [QSA,PT,L]
</IfModule>

绑定public目录，不能有user.ini文件

阿里云linux安装clickhouse

cd /www/wwwroot/clickhouse

mk clickhouse

挨个下载

wget https://packages.clickhouse.com/tgz/stable/clickhouse-client-22.2.2.1.tgz \
wget https://packages.clickhouse.com/tgz/stable/clickhouse-common-static-22.2.2.1.tgz \
wget https://packages.clickhouse.com/tgz/stable/clickhouse-common-static-dbg-22.2.2.1.tgz \
wget https://packages.clickhouse.com/tgz/stable/clickhouse-server-22.2.2.1.tgz

挨个解压

tar -zxvf clickhouse-client-22.2.2.1.tgz -C /www/wwwroot/clickhouse
tar -zxvf clickhouse-common-static-22.2.2.1.tgz -C /www/wwwroot/clickhouse
tar -zxvf clickhouse-common-static-dbg-22.2.2.1.tgz -C /www/wwwroot/clickhouse
tar -zxvf clickhouse-server-22.2.2.1.tgz -C /www/wwwroot/clickhouse

执行
cd /www/wwwroot/clickhouse/clickhouse-client-22.2.2.1/install/
./doinst.sh
 
cd /www/wwwroot/clickhouse/clickhouse-common-static-22.2.2.1/install/
./doinst.sh
 
cd /www/wwwroot/clickhouse/clickhouse-common-static-dbg-22.2.2.1/install/
./doinst.sh
 
cd /www/wwwroot/clickhouse/clickhouse-server-22.2.2.1/install/
./doinst.sh

执行cd /www/wwwroot/clickhouse/clickhouse-server-22.2.2.1/install/
./doinst.sh 后输入密码 admin

#查看 clickhouse 命令 

clickhouse --help
#启动clickhouse服务

clickhouse start

1、启动Server服务

systemctl start clickhouse-server

2、重启server

systemctl restart clickhouse-server
3、停止server

systemctl stop clickhouse-server

4、client命令行连接-多命令行模式

clickhouse-client -m --password <密码>

5、client命令行远程连接

clickhouse-client --host 192.168.45.10 --port 9000 --database default --user default --password “”

6、client命令行执行sql文件

clickhouse-client --user default --password 密码 -d default --multiquery < /root/temp.sql

7、设置远程连接<listen_host>::</listen_host>注释打开

sudo vi /etc/clickhouse-server/config.xml

vi命令 :/listen_host 搜索到208行

光标指向的文字输入“X”删除

:wq! 保存退出即可

ubuntu clickhouse安装步骤

1、sudo apt-get install -y apt-transport-https ca-certificates dirmngr

2、sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 8919F6BD2B48D754

3、echo "deb https://packages.clickhouse.com/deb stable main" | sudo tee  /etc/apt/sources.list.d/clickhouse.list

4、sudo apt-get update

5、sudo apt-get install -y clickhouse-server clickhouse-client

输入密码 admin

6、sudo service clickhouse-server start

7、clickhouse-client --password admin
8、查看表创建命令 show create table default.wd

CREATE TABLE default.wd
(
    `IMEI` UInt64,
    `temperature` Float32,
    `humidity` Float32,
    `signal` UInt8,
    `voltage` UInt8,
    `collectTime` DateTime,
    `admin_id` UInt8
)
ENGINE = ReplacingMergeTree(IMEI)
PARTITION BY toYYYYMM(collectTime)
PRIMARY KEY IMEI
ORDER BY (IMEI, collectTime)
SETTINGS index_granularity = 8192

插入测试数据

http://8.152.162.88/ck.php?admin_id=1&sort=ID&order=desc&offset=0&limit=10&filter=%7B%22temperature%22%3A%221%2C33%22%2C%22collectTime%22%3A%222023-06-16+00%3A00%3A00+-+2023-07-15+23%3A59%3A59%22%7D&op=%7B%22temperature%22%3A%22BETWEEN%22%2C%22collectTime%22%3A%22RANGE%22%7D&_=1689429196088%20//$sqlall%20=%20%22SELECT%20*%20FROM%20`wd`%20WHERE%20%20(%20%20`temperature`%20BETWEEN%20%271%27%20AND%20%2727%27%20AND%20`collectTime`%20BETWEEN%201688659200%20AND%201689263999%20%20AND%20`admin_id`%20=%20%270%27%20)%20ORDER%20BY%20`collectTime`%20DESC%20LIMIT%200,10%22;

本服务器阿里云 centos 7系统,使用yum 一键安装:

yum install mosquitto -y

安装完成后,下面是一些操作Mosquitto服务命令

sudo systemctl start mosquitto     # 启动 Mosquitto 服务
sudo systemctl stop mosquitto      # 停止 Mosquitto 服务
sudo systemctl restart mosquitto   # 重新启动 Mosquitto 服务
sudo systemctl status mosquitto    #检查服务器状态

执行启动命令后,输入查看状态,我们可以看到服务已经运行成功了,本地安装成功了,Mosquitto 服务的本地1883端口,实现远程访问连接.

mqtt.fx 工具下载 https://www.softblade.de/download/

sudo mosquitto_passwd -c /etc/mosquitto/pwdfile admin
然后输入密码 两次

需要检查宝塔是否开放1883端口， 使用工具测试，发布

订阅

测试swoole注意服务器的php版本，默认的php命令版本不对需要加上路径，/www/server/php/80/bin/php swoole_http.php

先查看下系统默认php命令关联的PHP版本，在命令行输入

ls -l /usr/bin/php

修改为新版本php8.0

ln -sf /www/server/php/80/bin/php /usr/bin/php

composer安装MQTT库

composer require simps/mqtt

设置MySQL外联

授予root用户远程访问权限，并刷新权限使生效 
grant all privileges on *.* to 'root账号' @'%' identified by 'root密码'
让权限立即生效：
flush privileges