在本指南中,您将在Neokylin服务器上部署MyEMS。
本指南介绍如何在NeoKylin-Server7.0上安装MyEMS。硬件需求取决于所选数据库和连接到系统的设备数量。要在一台机器上运行MyEMS和MySQL,您至少需要8GB的RAM。
更新系统并安装工具:
sudo yum update -ysudo yum install -y git升级python版本到python3.10升级OpenSSL版本到openssl-1.1.1w参见本文末“软件安装之升级python到3.10”克隆源代码:
cd ~git clone https://gitee.com/myems/myems数据库
为MyEMS安装数据库架构和脚本。
参见本文末:软件安装之MySQL 8.0安装部署
在MySQL命令行中执行以下脚本,或在其他MySQL客户端工具中执行,如MySQL Workbench、Navicat、DBaver、phpMyAdmin等。
cd ~/myems/database/installmysql -u root -p < myems_billing_db.sqlmysql -u root -p < myems_carbon_db.sqlmysql -u root -p < myems_energy_baseline_db.sqlmysql -u root -p < myems_energy_db.sqlmysql -u root -p < myems_energy_model_db.sqlmysql -u root -p < myems_energy_plan_db.sqlmysql -u root -p < myems_energy_prediction_db.sqlmysql -u root -p < myems_fdd_db.sqlmysql -u root -p < myems_historical_db.sqlmysql -u root -p < myems_production_db.sqlmysql -u root -p < myems_reporting_db.sqlmysql -u root -p < myems_system_db.sqlmysql -u root -p < myems_user_db.sql演示数据是可选的。要插入演示数据,请执行以下脚本:
cd ~/myems/database/demo-cnmysql -u root -p < myems_system_db.sql如何修复MySQL错误“用户拒绝访问”
添加远程访问用户
sudo mysql -u root -pmysql>
CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '!MyEMS1';mysql>
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';mysql>
FLUSH PRIVILEGES;mysql>
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '!MyEMS1';如何更改MySQL服务器8.0版之前的COLLATE
sudo vi /etc/my.cnf[client]default-character-set = utf8mb4[mysql]default-character-set = utf8mb4[mysqld]character-set-client-handshake = FALSEcharacter-set-server = utf8mb4collation-server = utf8mb4_unicode_ci如何修复MySQL错误“一个大于'max_allowed_packet'字节的数据包”
更改mysqld部分下的my.cnf或my.ini文件(通常在/etc/mysql/中找到),并设置:
max_allowed_packet=100Mor you could run these commands in a MySQL console connected to that same server:
set global net_buffer_length=1000000;set global max_allowed_packet=1000000000;警告
不要在生产环境将数据库安装到的Docker容器中
sudo cp -r ~/myems/myems-api /myems-apicd /myems-apipip install -r requirements.txt根据example.env创建.env文件,并根据需要编辑.env:
sudo cp /myems-api/example.env /myems-api/.envsudo vi /myems-api/.env将端口添加到防火墙:
sudo firewall-cmd --zone=public --add-port=8000/tcp --permanentsudo firewall-cmd --reload安装 systemd 配置文件:
vi /myems-api/myems-api.serviceExecStart=/usr/local/python3/bin/gunicorn -b 0.0.0.0:8000 --pid /run/myems-api/pid --timeout 600 --workers=4 app:apisudo cp /myems-api/myems-api.service /lib/systemd/system/sudo cp /myems-api/myems-api.socket /lib/systemd/system/sudo cp /myems-api/myems-api.conf /usr/lib/tmpfiles.d/接下来启用这些服务,以便它们在启动时自动启动:
sudo systemctl enable myems-api.socketsudo systemctl enable myems-api.service启动服务:
sudo systemctl start myems-api.socketsudo systemctl start myems-api.serviceyum install -y nginx启用nginx服务:
sudo systemctl start nginx.servicesudo vi /etc/nginx/nginx.confIn the 'http' section, add some directives:
http { client_header_timeout 600; client_max_body_size 512M; gzip on; gzip_min_length 512; gzip_proxied any; gzip_types *; gzip_vary on; proxy_buffering off; ...}在目录 /etc/nginx/conf.d/ 下新建一个文件:
sudo vi /etc/nginx/conf.d/myems-admin.conf编写如下指令, 如果myems-api服务运行在其它服务器上则用实际的地址替换 myems-api 默认地址 http://127.0.0.1:8000/
server { listen 8001; server_name myems-admin; location / { root /var/www/myems-admin; index index.html index.htm; } ## To avoid CORS issue, use Nginx to proxy myems-api to path /api ## Add another location /api in 'server' ## Replace the default myems-api url http://127.0.0.1:8000/ with actual url if the myems-api servcie hosted on different server location /api { proxy_pass http://127.0.0.1:8000/; proxy_connect_timeout 75; proxy_read_timeout 600; send_timeout 600; }}sudo mkdir /var/wwwsudo cp -r ~/myems/myems-admin /var/www/myems-adminsudo chmod 0755 -R /var/www/myems-admin检查配置文件,必要时进行更改:
sudo vi /var/www/myems-admin/app/api.js警告
“upload”文件夹用于用户上传的文件。升级myems-admin时,请勿删除/移动/覆盖“upload”文件夹。
/var/www/myems-admin/upload将端口添加到防火墙:
sudo semanage port -a -t http_port_t -p tcp 8001sudo firewall-cmd --zone=public --add-port=8001/tcp --permanentsudo firewall-cmd --reload重启nginx服务:
sudo systemctl restart nginx.service提示
如果您遇到“403 Forbidden”nginx错误,可以通过使用命令“sudo setforce 0”更改SELinx模式来修复它
在此步骤中,您将安装myems-modbus-tcp服务。
sudo cp -r ~/myems/myems-modbus-tcp /myems-modbus-tcpcd /myems-modbus-tcpsudo pip install -r requirements.txt将exmaple.ev文件复制到.env并修改.env文件:
sudo cp /myems-modbus-tcp/example.env /myems-modbus-tcp/.envsudo vi /myems-modbus-tcp/.env安装 systemd 服务:
sudo cp myems-modbus-tcp.service /lib/systemd/system/启用服务:
sudo systemctl enable myems-modbus-tcp.service启动服务:
sudo systemctl start myems-modbus-tcp.service监控服务:
sudo systemctl status myems-modbus-tcp.service查看日志:
cat /myems-modbus-tcp.log在此步骤中,您将安装myems-cleaning服务。
sudo cp -r ~/myems/myems-cleaning /myems-cleaningcd /myems-cleaningsudo pip install -r requirements.txt将exmaple.ev文件复制到.env并修改.env文件:
sudo cp /myems-cleaning/example.env /myems-cleaning/.envsudo nano /myems-cleaning/.env安装systemd服务:
sudo cp /myems-cleaning/myems-cleaning.service /lib/systemd/system/启用服务:
sudo systemctl enable myems-cleaning.service启动服务:
sudo systemctl start myems-cleaning.service监控服务:
sudo systemctl status myems-cleaning.service查看日志:
cat /myems-cleaning.log在此步骤中,您将安装myems-normalization服务。
sudo cp -r ~/myems/myems-normalization /myems-normalizationcd /myems-normalizationsudo pip install -r requirements.txt将exmaple.ev文件复制到.env并修改.env文件:
sudo cp /myems-normalization/example.env /myems-normalization/.envsudo nano /myems-normalization/.env安装systemd服务
sudo cp /myems-normalization/myems-normalization.service /lib/systemd/system/启用服务:
sudo systemctl enable myems-normalization.service启动服务:
sudo systemctl start myems-normalization.service监控服务:
sudo systemctl status myems-normalization.service查看日志:
cat /myems-normalization.log在此步骤中,您将安装myems-aggregation服务。
sudo cp -r ~/myems/myems-aggregation /myems-aggregationcd /myems-aggregationsudo pip install -r requirements.txt将exmaple.ev文件复制到.env并修改.env文件:
sudo cp /myems-aggregation/example.env /myems-aggregation/.envsudo nano /myems-aggregation/.env安装systemd服务
sudo cp /myems-aggregation/myems-aggregation.service /lib/systemd/system/启用服务:
sudo systemctl enable myems-aggregation.service启动服务:
sudo systemctl start myems-aggregation.service监控服务:
sudo systemctl status myems-aggregation.service查看日志:
cat /myems-aggregation.log在此步骤中,您将安装myems-web服务。
sudo rm /etc/nginx/sites-enabled/defaultsudo rm /etc/nginx/conf.d/default.conf在目录 /etc/nginx/conf.d/ 下添加一个新文件
sudo vi /etc/nginx/conf.d/myems-web.conf使用如下指令编写,如果myems-api服务托管在不同的服务器上,则使用实际的地址替换默认的myems-api地址http://127.0.0.1:8000/
server { listen 80; server_name myems-web; location / { root /var/www/myems-web; index index.html index.htm; # add try_files directive to avoid 404 error while refreshing pages try_files $uri /index.html; } ## To avoid CORS issue, use Nginx to proxy myems-api to path /api ## Add another location /api in 'server' ## replace the default myems-api url http://127.0.0.1:8000/ with actual url if the myems-api servcie hosted on different server location /api { proxy_pass http://127.0.0.1:8000/; proxy_connect_timeout 75; proxy_read_timeout 600; send_timeout 600; }}安装NodeJS:
参见:软件安装之Node.js 17 安装修改配置文件:
备注
从 https://mapbox.com 获取 mapboxToken 然后设置 showOnlineMap 为 true. 如果要关闭在线地图功能,设置 showOnlineMap 为 false
cd ~/myems/myems-websudo nano src/config.js编译:
sudo npm i --unsafe-perm=true --allow-root --legacy-peer-depssudo npm run build安装: 注意,以下路径应该与nginx.conf中配置的路径相同。
sudo rm -r /var/www/myems-websudo mv build /var/www/myems-web将端口添加到防火墙:
sudo semanage port -a -t http_port_t -p tcp 80sudo firewall-cmd --zone=public --add-port=80/tcp --permanentsudo firewall-cmd --reload重启 NGINX
sudo systemctl restart nginx提示
如果您遇到“500内部服务器错误”nginx错误,可以通过使用命令“sudo setforce 0”更改SELinx模式来修复它
祝贺您现在可以登录MyEMS Admin UI和Web UI。
MyEMS Web UI: 80
MyEMS API: 8000
MyEMS Admin UI: 8001
假设服务器地址是 192.168.1.8 (替换为服务器真实地址) 访问MyEMS Web UI地址是 http://192.168.1.8 (80可以忽略) 访问MyEMS Admin UI地址是 http://192.168.1.8:8001
MyEMS Admin UI
用户名:
administrator密码:
!MyEMS1MyEMS Web UI
用户名:
administrator@myems.io密码:
!MyEMS1在NeoKylin 7(国产麒麟系统)中升级Python到3.10.x版本需要特别注意系统兼容性。以下是详细步骤:
bash
# 安装编译工具和依赖sudo yum install -y gcc openssl-devel bzip2-devel libffi-devel zlib-devel readline-devel sqlite-devel wget makesudo yum install -y epel-releasesudo yum install -y gcc gcc-c++ make autoconf automake libtoolsudo yum install -y zlib-devel bzip2-devel openssl-devel ncurses-devel \ sqlite-devel readline-devel tk-devel gdbm-devel db4-devel \ libpcap-devel xz-devel libffi-devel# 下载 OpenSSL 1.1.1wcd /usr/localsudo wget https://www.openssl.org/source/openssl-1.1.1w.tar.gzsudo tar -zxvf openssl-1.1.1w.tar.gzcd openssl-1.1.1w# 编译安装sudo ./config --prefix=/usr/local/openssl --openssldir=/usr/local/openssl shared zlibsudo make -j4sudo make install# 配置系统库路径echo "/usr/local/openssl/lib" | sudo tee /etc/ld.so.conf.d/openssl-1.1.1.confsudo ldconfig# 创建软链接(可选,不影响原有 openssl)sudo ln -sf /usr/local/openssl/bin/openssl /usr/local/bin/opensslbash
# 创建源码目录mkdir ~/python3cd ~/python3# 下载Python 3.10(以3.10.13为例)wget https://www.python.org/ftp/python/3.10.13/Python-3.10.13.tgz# 解压tar -xzf Python-3.10.13.tgzcd Python-3.10.13bash
# 配置编译选项./configure --prefix=/usr/local/python3 \ --with-openssl=/usr/local/openssl \ --with-openssl-rpath=auto \ --enable-shared# 编译(使用4个核心加速)make -j4# 安装sudo make installbash
# 备份原有python命令(如果需要)sudo mv /usr/bin/python /usr/bin/python2.7.backupsudo mv /usr/bin/pip /usr/bin/pip.backup# 创建新的软链接sudo ln -s /usr/local/python3/bin/python3 /usr/bin/python3sudo ln -s /usr/local/python3/bin/pip3 /usr/bin/pipbash
# 测试 SSL 模块/usr/local/python3/bin/python3 -c "import ssl; print(ssl.OPENSSL_VERSION)"# 检查版本python --versionpip --version# 检查yum是否正常(需要Python2)yum --version麒麟系统的yum等工具依赖Python 2.7,需要确保:
python3命令而不是覆盖python命令# 进入 /usr/local 目录cd /usr/local# 下载 Node.js 17.9.1(最后一个17.x版本)sudo wget https://nodejs.org/dist/v17.9.1/node-v17.9.1-linux-x64.tar.xz# 解压sudo tar -xf node-v17.9.1-linux-x64.tar.xz# 重命名目录sudo mv node-v17.9.1-linux-x64 nodejsbash
# 创建 node 和 npm 命令的软链接sudo ln -sf /usr/local/nodejs/bin/node /usr/local/bin/nodesudo ln -sf /usr/local/nodejs/bin/npm /usr/local/bin/npmsudo ln -sf /usr/local/nodejs/bin/npx /usr/local/bin/npx# 或者添加到 PATH(如果不想创建软链接)echo 'export PATH=/usr/local/nodejs/bin:$PATH' >> ~/.bashrcsource ~/.bashrcbash
# 检查版本node --versionnpm --version# 测试node -e "console.log('Node.js 17 installed successfully')"在NeoKylin Server 7上安装MySQL 8.0 (64bit)的步骤。
检查系统环境
# 查看系统版本cat /etc/redhat-release# 检查是否已安装MySQLrpm -qa | grep mysqlrpm -qa | grep mariadb# 如果存在mariadb,先卸载rpm -e --nodeps mariadb-libs-*# 下载MySQL YUM仓库包wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm# 如果wget未安装,先安装wgetyum install -y wget# 安装MySQL仓库rpm -ivh mysql80-community-release-el7-3.noarch.rpm# 导入MySQL GPG密钥rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022# 清除yum缓存yum clean all# 安装MySQL 8.0yum install -y mysql-community-server# 如果遇到GPG密钥问题,可以临时使用yum install -y mysql-community-server --nogpgcheck# 启动MySQL服务systemctl start mysqld# 设置开机自启systemctl enable mysqld# 查看服务状态systemctl status mysqld# 查看MySQL生成的临时密码grep 'temporary password' /var/log/mysqld.log# 运行安全配置脚本mysql_secure_installation按提示操作:
# 登录MySQLmysql -u root -p# 查看版本SELECT VERSION();# 查看数据库SHOW DATABASES;编辑配置文件:
vi /etc/my.cnf添加以下内容:
[client]default-character-set=utf8mb4[mysql]default-character-set=utf8mb4[mysqld]character-set-server=utf8mb4collation-server=utf8mb4_unicode_ciinit-connect='SET NAMES utf8mb4'# 降低密码策略要求设置密码策略validate_password.policy = LOWvalidate_password.length = 6validate_password.mixed_case_count = 0validate_password.number_count = 0validate_password.special_char_count = 0重启服务:
systemctl restart mysqld# 开启3306端口firewall-cmd --permanent --add-port=3306/tcpfirewall-cmd --reload# 或关闭防火墙(不推荐)# systemctl stop firewalld-- 登录MySQLmysql -u root -p-- 创建远程访问用户CREATEUSER'root'@'%'IDENTIFIEDBY'YourPassword';-- 修改root用户密码ALTERUSER'root'@'localhost'IDENTIFIEDBY'!MyEMS1';-- 授予权限GRANT ALL PRIVILEGESON *.* TO'root'@'%'WITHGRANTOPTION;-- 刷新权限FLUSHPRIVILEGES;如果服务器内存较小,可以限制MySQL内存使用:
vi /etc/my.cnf# 添加以下配置innodb_buffer_pool_size = 256Minnodb_log_buffer_size = 16Mmax_connections = 100# 查看错误日志tail -f /var/log/mysqld.log# 查看端口占用netstat -tlnp | grep 3306-- 查看当前密码策略SHOWVARIABLESLIKE'validate_password%';-- 修改密码策略(如果需要简单密码)SETGLOBAL validate_password.policy = LOW;SETGLOBAL validate_password.length = 6;# 检查MySQL服务ps aux | grep mysql# 检查端口netstat -tlnp | grep 3306# 检查MySQL版本mysql --version这样就完成了MySQL 8.0在NeoKylin Server 7上的安装。如果遇到具体问题,可以提供错误信息,我来帮您解决。
# 添加 NGINX 官方仓库(RHEL/CentOS 7)sudo rpm -Uvh http://nginx.org/packages/centos/7/noarch/RPMS/nginx-release-centos-7-0.el7.ngx.noarch.rpm# 安装 NGINXsudo yum install -y nginx# 启动并设置开机自启sudo systemctl start nginxsudo systemctl enable nginx# 编辑主配置文件sudo vi /etc/nginx/nginx.conf在 http 段添加以下指令:
http {client_header_timeout600;client_max_body_size512M;gzipon;gzip_min_length512;gzip_proxied any;gzip_types *;gzip_varyon;proxy_bufferingoff; ...}