search

unissoft-bj / ihostsvc

system services & data services on ihost
0 stars 0 forks source link

汽安展 在ihost上部署 #61

Open unissoft-bj opened 9 years ago

unissoft-bj commented 9 years ago

参考：https://github.com/unissoft-bj/ihostsvc/blob/auto_show_2015/java-proj/wms/etc/setup_wms_ubuntu.txt

!!!注意!!!

进入编辑页面模式，再复制命令运行

1，下载文件 mkdir /opt/wms

scp -P 2708 wlsp@mtxwifi.com:~/wms/auto_show/wms-0.1.1.war /opt/wms/

scp -P 2708 wlsp@mtxwifi.com:~/wms/wms-0.1.2.war /opt/wms/

scp -P 2708 wlsp@mtxwifi.com:~/wms/auto_show/wms-0.1.3.war /opt/wms/

scp -P 2708 wlsp@mtxwifi.com:~/wms/0.1.4/wms-0.1.4.war.new /opt/wms/wms-0.1.4.war

scp -P 2708 wlsp@mtxwifi.com:~/wms/auto_show/wyun_svc.sh /opt/wms/ scp -P 2708 wlsp@mtxwifi.com:~/wms/auto_show/ihostsvc/java-proj/wms/etc/*.sql /opt/wms/

scp -P 2708 wlsp@mtxwifi.com:~/wms/ihostsvc/java-proj/wms/etc/*.sql /opt/wms/

2，配置service启动

adduser --system --no-create-home --disabled-password --disabled-login --group sboot

system user `sboot' (UID 107) ...

#Adding new group`sboot' (GID 112) ...

Adding new user sboot' (UID 107) with groupsboot' ...

Not creating home directory `/home/sboot'.

echo "sboot ALL=(ALL) NOPASSWD: ALL" >> /etc/sudoers

chmod +x /opt/wms/wyun_svc.sh sudo ln -sf /opt/wms/wyun_svc.sh /etc/init.d/wyun_svc update-rc.d wyun_svc defaults

3，授权使用chilli_query sudo usermod -a -G chilli sboot sudo chown root:chilli /usr/sbin/chilli_query sudo chmod u+s /usr/sbin/chilli_query

4，创建数据库 用户和表

MYSQL_WYUN_DB, shell script set up a mysql database and its user

MYSQL_ROOT_PW=0ffs4t? MYSQL_WYUN_DB=wms MYSQL_WYUN_USER=wms MYSQL_WYUN_PW=wms mysql -uroot -p$MYSQL_ROOT_PW -e "CREATE DATABASE $MYSQL_WYUN_DB" mysql -uroot -p$MYSQL_ROOT_PW -e "GRANT ALL PRIVILEGES ON $MYSQL_WYUN_DB.* TO '$MYSQL_WYUN_USER'@'localhost' IDENTIFIED BY '$MYSQL_WYUN_PW';" mysql -uroot -p$MYSQL_ROOT_PW -e "GRANT ALL PRIVILEGES ON $MYSQL_WYUN_DB.* TO '$MYSQL_WYUN_USER'@'%' IDENTIFIED BY '$MYSQL_WYUN_PW';" mysql -uroot -p$MYSQL_ROOT_PW -e "GRANT ALL PRIVILEGES ON $MYSQL_WYUN_DB.* TO '$MYSQL_WYUN_USER'@'0.0.0.0' IDENTIFIED BY '$MYSQL_WYUN_PW';" mysql -uroot -p$MYSQL_ROOT_PW -e "GRANT ALL PRIVILEGES ON $MYSQL_WYUN_DB.* TO '$MYSQL_WYUN_USER'@'127.0.0.1' IDENTIFIED BY '$MYSQL_WYUN_PW';"

mysql -uwms -pwms wms < /opt/wms/wms.sql mysql -uwms -pwms wms < /opt/wms/wms_util_procedure.sql mysql -uwms -pwms wms < /opt/wms/wms_init.sql mysql -uwms -pwms wms < /opt/wms/auto_q_2015.sql

5，link wms.war ln -sf /opt/wms/wms-0.1.3.war /opt/wms/wms.war

ln -sf /opt/wms/wms-0.1.4.war /opt/wms/wms.war

chown -R sboot:sboot /opt/wms

6、创建 audio 文件 mkdir /wms/audio chown -R sboot:sboot /wms/audio

7，修改推送网页，重启 sed -i 's|HS_UAMFORMAT=http://\$HS_UAMLISTEN:\$HS_UAMUIPORT/www/ihome.html|HS_UAMFORMAT=http://mtxwifi.net:8080|g' /etc/chilli/defaults

sed -i 's|HS_UAMFORMAT=http://\$HS_UAMLISTEN:\$HS_UAMUIPORT/www/ihome.html|HS_UAMFORMAT=http://mtxwifi.net:8080/\#/login2|g' /etc/chilli/defaults

reboot

8，检查service启动情况；注意service启动要1分钟 tail -f /opt/wms/logs/spring.log ps aux | grep java

9，测试答卷；测试管理员界面

系统内置一个管理员上网码 : 2015168 ；使用一次后失效

echo "select * from token;" | mysql -uwms -pwms wms

10，测试结束后，用step 4重建数据库；删除sql语句 rm /opt/wms/*.sql

更新war包(注意wms.new.war不要跟wms_0.1.1.war重名，否则会覆盖)

cp wms-new.war /opt/wms ln -sf /opt/wms/wms.new.war /opt/wms/wms.war chown -R sboot:sboot /opt/wms

DD 系统镜像 nohup dd if=/dev/sda of=ihost.u.0408.img bs=512 count=15466320

重复使用内置上网码

echo "/10 * * * \ sudo echo 'update token set create_t=now(),used=0 where id=1' | mysql -uwms -pwms wms " >> /var/spool/cron/crontabs/root touch /var/spool/cron/crontabs/root