总结: 对10.191.1.2进行后端配置,这个配置主要目的是忽略大小写(lower_case_table_names=1)
遇到的问题:配置了一直不起作用
解决:因为配置文件权限没有修改成644
Xshell命令行:
- 重启mysql: systemctl restart mysql
- 列表: ls
- 动态显示日志:cd /opt/tomcat/logs && tail -f catalina.out
tail是显示日志的命令,-fn是动态显示日志,n后面加的2000是从两千行开始动态显示,catalina.out是文件名 - 重启tomcat: cd /opt/tomcat/bin && sh startup.sh
- 关闭tomcat: sh shutdown.sh
- 重启mysql: systemctl restart mysql
- 查看与Tomcat有关的进程,然后杀死重启: ps -ef |grep tomcat && kill 进程号
访问 http://10.191.1.2
徐哲说是让我重启一下,但是好像还是不起作用
SVN上查看
桌面右键-tortoiseSVN-repo-browser-
url: svn://172.16.30.11/CRJ900_WIFI
svn://172.16.30.11/CRJ900_WIFI/DWMSU-104/02_Develop/Software/Product/Web/wifi-cms3.01.01
安装说明.txt
1.导入数据库文件wifi_cms_table.sql wifi_cms_data.sql
2.修改数据库配置(若已修改,请跳过)
vi /etc/mysql/my.cnf
将以下添加到最后
[mysqld]
lower_case_table_names=1
3.重启mysql systemctl restart mysql
4.通过FTP工具连接wmsu服务器
5.将wifi-cms.war文件夹上传至/home/wmsu/
6.判断是否已经安装过,如已经安装请先删除,命令如下
sudo rm -rf /opt/tomcat/webapps/wifi-cms.war
再通过ssh工具将wifi-cms.war移至/opt/tomcat/webapps/ sudo mv /home/wmsu/wifi-cms.war /opt/tomcat/webapps/
7.将outerConfig.properties放到/home/wmsu/目录下 该文件模拟的是wmsu的设备号和飞机号
下载
连无线wmsu_client 密码09876543
首先把这两个sql文件下载到本地
发现sql文件已经上传,并且有数据。
打开Xshell连接到10.191.1.2,可以先ftp工具找到目录/etc/mysql/my.cnf
/etc/mysql/mysql.conf.d/
cat mysqld.cnf
wmsu@wmsu:~$ cd /etc/mysql
wmsu@wmsu:/etc/mysql$ ls
conf.d debian.cnf debian-start my.cnf my.cnf.fallback mysql.cnf mysql.conf.d
wmsu@wmsu:/etc/mysql$ cat my.cnf
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
#
# * IMPORTANT: Additional settings that can override t