#关闭SELINUX（建议关闭）
#1.修改 selinux 配置文件
vi /etc/selinux/config

#SELINUX=enforcing 
#SELINUXTYPE=targeted 
SELINUX=disabled 

#2.保存修改
:wq! 

#3.使修改立即生效
setenforce 0


=========================================== 安装Mysql5.7 ===========================================
#1.查看已安装的版本 
rpm -qa | grep mysql

#卸载 rpm 安装的 Mysql，使用命令rpm -e 加包名
yum remove mysql mysql-server mysql-libs compat-mysql51
yum -y remove mysql-community-client-5.6.38-2.el7.x86_64

#卸载不掉用下面命令
rpm -ev mysql-community-client-5.6.38-2.el7.x86_64

#删除配置文件
rm /etc/my.cnf

#3.下载安装包
mkdir /home/upload/
cd /home/upload/
wget http://71mis.cn/downlist/tools/mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz 
wget http://71mis.com/lingdang.zip
wget https://weixin-1255564871.cos.ap-shanghai.myqcloud.com/downlist/products/%E7%81%B5%E5%BD%93CRMV8.6.0.0_linux_20230712.zip


#4.解压
tar zxf mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz 

#5.将文件件剪切到 /usr/local/ 目录下重命名为 mysql
mv mysql-5.7.30-linux-glibc2.12-x86_64  /usr/local/mysql



#6.创建mysql用户、用户组，创建数据库文件安装路径并授权
groupadd mysql
useradd -g mysql -M mysql 

chown -R mysql.mysql /usr/local/mysql

mkdir -p /home/mysql/data
chown -R mysql.mysql /home/mysql/data


#7.安装 mysql 注意记录提示的临时密码
/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/home/mysql/data



出错：[ERROR] failed to set datadir 
chown -R mysql.mysql /usr/local/mysql
/usr/local/mysql/bin/mysqld --initialize --user=mysql --console 


/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/home/mysql/data




#安装SSL
/usr/local/mysql/bin/mysql_ssl_rsa_setup --datadir=/home/mysql/data


#遇到错误： Could not find OpenSSL on the system
yum install openssl openssl-devel 


#遇到错误./mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory
#执行以下命令后重新初始化
yum -y install numactl.x86_64


#8.添加系统服务并设置开机自动启动
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
chkconfig --add mysql
chkconfig mysql on


#上传配置文件 my.cnf 到安装目录 /usr/local/mysql/
cd /home/upload/lingdang
cp -r my.cnf /usr/local/mysql/

#启动mysql
service mysql start


#9.添加远程访问用户
#添加软连接
ln -s /usr/local/mysql/bin/mysql /usr/bin
ln -s /usr/local/mysql/bin/mysqldump /usr/bin

#连接数据库
mysql -uroot -p

#输入上面安装后显示的临时密码
#更改密码
ALTER USER USER() IDENTIFIED BY 'lingdang##';

#添加远程访问用户
use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'lingdang'@'%' IDENTIFIED BY 'lingdang_123.CRM' WITH GRANT OPTION;
FLUSH PRIVILEGES;



=========================================== 安装Nginx+php7.2 ===========================================
#1.安装PHP72
rpm -ivh http://mirrors.wlnmp.com/centos/wlnmp-release-centos.noarch.rpm
yum -y remove php* wphp*
yum clean all

yum install wphp72 
chkconfig --add /etc/init.d/php-fpm72

#启动服务
service php-fpm72 restart



#2.安装Nginx
#先查看是否安装了 Nginx
yum list installed | grep nginx
yum -y remove nginx*  wnginx*


yum install wnginx
chkconfig --add /etc/init.d/nginx

#启动服务
service nginx restart


#3.上传配置文件中的 beast.so  lingdang.so 到 extensions 目录 /usr/local/php/lib/php/extensions/no-debug-non-zts-20170718/
cd /home/upload/lingdang
cp -r beast.so /usr/local/php/lib/php/extensions/no-debug-non-zts-20170718/
cp -r lingdang.so /usr/local/php/lib/php/extensions/no-debug-non-zts-20170718/

#4.上传配置文件中的 demo.conf 到目录 /usr/local/nginx/conf/vhost/
cp -r demo.conf /usr/local/nginx/conf/vhost/

#5.上传配置文件中的 php.ini 到目录 /usr/local/php/etc/ 
cp -r php.ini /usr/local/php/etc/

#上传缓存黑名单
cp -r php_opcache_blacklist.txt /usr/local/php/etc/


#6.创建虚拟目录、日志目录及文件（需要与配置文件一致）
mkdir -p /home/www/
mkdir -p /home/logs/
mkdir -p /home/logs/nginx/
mkdir -p /home/logs/debug/
mkdir /home/opcachefile/
chmod -Rf 777 /home/opcachefile/
touch /home/logs/php_errors.log


#上传Nginx日志分割脚本 cut_nginxlog.sh 到目录 /home/logs/
cp -r cut_nginxlog.sh /home/logs/
chmod -Rf 755 /home/logs/cut_nginxlog.sh

#添加计划任务每天0点执行日志分割脚本
crontab -e
0 0 * * * /home/logs/cut_nginxlog.sh

#上传测试文件 1.php 到虚拟目录 /home/www/
cp -r 1.php /home/www/

#7.重启服务
service php-fpm72 restart
service nginx restart

#访问 127.0.0.1/1.php 测试





#最后，下载linux程序包，并copy其中crm程序到虚拟目录，创建数据库并修改程序目录 config.inc.php 文件中的数据库和路径配置

cd /home/upload/
unzip "灵当CRMV8.6.0.0_linux_20230712.zip"
rm -Rf "灵当CRMV8.6.0.0_linux_20230712.zip"

mv "灵当CRMV8.6.0.0_linux_20230712" crm
cd crm 
mv crm /home/www/
cd /home/upload/lingdang
cp -r config.inc.php /home/www/crm/
chmod -Rf 777 /home/www/crm/



#在 linux 连接数据库
mysql -uroot -p

#输入密码按回车登录数据库


#创建 ldcrm 数据库
CREATE DATABASE IF NOT EXISTS ldcrm DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

#使用ldcrm数据库
use ldcrm

#恢复数据库
source /home/upload/crm/data_V8600.sql

#恢复存储过程、视图、触发器
source /home/upload/crm/proc_V8600.sql




rm -Rf /home/upload/crm/
rm -Rf /home/upload/lingdang/
rm -Rf /home/upload/lingdang.zip




#设置数据库自动备份
mkdir -p /home/dbbackup/
cd /home/upload/lingdang
cp auto_backup_crmdb.sh /home/dbbackup/
chmod -Rf 755 /home/dbbackup/auto_backup_crmdb.sh



#添加计划任务每天1点执行自动备份
crontab -e
01 00 * * * /home/dbbackup/auto_backup_crmdb.sh


#启动 nginx  php  mysql 服务
service nginx start
service php-fpm72 start
service mysql start

#启动 openoffice
/opt/openoffice4/program/soffice -headless -accept="socket,host=127.0.0.1,port=8100;urp;" -nofirststartwizard &