笔记

onlinesit

92.63.194.72
location = / {
rewrite ^/(.*)$ http://$host/cas/$1;

}
10.0.8.35 10.0.8.36



create table `task_car_feedback` (

id bigint(20) not null comment '主键id',
brand varchar(32) default null comment '车辆品牌',
buy_time varchar(32) default null comment '购买时间',
mileage varchar(32) default null comment '行驶里程',
license_plate_number varchar(12) default null comment '车牌号',
remark varchar(1024) default null comment '其他说明',
primary key (id)
)ENGINE=NDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='资信调查车产信息反馈';
create database dzbh_sim;
grant all on dzbh_sim.* to dzbh_sim@'%' identified by 'dzbh_sim123';

hc_dzbh_dev
hc_dzbh_dev123
http://git.ihanchen.com/Frontend/zstweb.git
create database hc_dzbh_dev;
grant all on hc_dzbh_uat.* to hc_dzbh_uat@'%' identified by 'hc_dzbh_uat123';
10.1.2.111

create database jk2_uat;
create database jd_uat;
create database fdd_uat;
grant all on jk2_uat.* to jk2_uat@'%' identified by 'HHwElKyVMYvJ'
grant all on jd_uat.* to jd_uat@'%' identified by '7hoA1QX3pT2Z';
grant all on fdd_uat.* to fdd_uat@'%' identified by 'r1XElzPrlkT5';
grant all on jf_zst.* to jf_zst@'%' identified by 'IG38TIUb4WKX';
grant all on fdd_uat.* to fdd@'%' identified by 'r1XElzPrlkT5';

T6YJgVJJic3Gc5GE
proxy.ha
hanchen123
172.16.20.1-254,172.16.30.1-254,172.16.40.1-254,
congcong hanchen123
nameserver 202.101.224.68
10.1.2.33
deploy_dianzibaohan-DEV
O8HVzg2ytiduYQkG

create database hc_dzbh_trn;
grant all on hc_dzbh_trn.* to hc_dzbh_trn@'%' identified by 'hc_dzbh_trn123';

create database jd_trn;
grant all on jd_trn.* to jd_trn@'%' identified by '7hoA1QX3pT2Z';

create database jd_dev;
grant all on jd_dev.* to jd_dev@'%' identified by '7hoA1QX3pT2Z';

create database fdd_trn;
grant all on fdd_trn.* to fdd_trn@'%' identified by 'dMr7DAVezI7Yg46z';

create database dzbh_dev;
grant all on dzbh_dev.* to dzbh_dev@'%' identified by 'T6YJgVJJic3Gc5GE';

create database dzbh_trn;
grant all on dzbh_trn.* to dzbh_trn@'%' identified by 'T6YJgVJJic3Gc5GE';

http://git.ihanchen.com/Frontend/zstweb.git
grant all on hc_dzbh_dev.* to hc_dzbh_dev@'%' identified by 'hc_dzbh_dev123';
10.0.1.152

10.0.1.152
create database hc_dzbh;
grant all on hc_dzbh.* to hc_dzbh@'%' identified by 'PRoTnFI80jPdmaNb';

rabbitmqctl add_user hc_dzbh han2018chen
rabbitmqctl set_user_tags hc_dzbh administrator
rabbitmqctl set_permissions -p / hc_dzbh '.' '.' '.*'

filebeat.prospectors:

• type: log
  enabled: true
  paths:
  • /var/xxx/*.log
  • /var/xxx/*.out
    multiline.pattern: ^[
    multiline.negate: true
    multiline.match: after
    setup.kibana:
    host: "localhost:5601"
    output.elasticsearch:
    hosts: ["localhost:9200"]

#!/bin/bash
set -xe
SERVERS="10.0.8.35 10.0.8.36"
SERVICE="client"
case $operation in
deploy)
echo "deploy"

npm config set registry https://registry.npm.taobao.org
npm install
npm run build

for SERVER in ${SERVERS}; do
rsync -a --delete-after  build/* hanchen@${SERVER}:/home/hanchen/deploy/${SERVICE}/
done
#tar zcf ${SERVICE}.tar.gz ./*
echo "done"
;;

rollback)
echo "rollback"
cp -rf ../../jobs/$/builds/$/archive/$.tar.gz .
tar zxf $.tar.gz && rm -f $.tar.gz
for SERVER in $; do
rsync -a --delete-after build/* hanchen@$:/home/hanchen/deploy/$/
done
echo "done"
;;
esac

grant all on onlineguaran.* to onlineguaran@'%' identified by 'SjVUHGZT8nuX2090';

cat /proc/net/netstat | awk '/TcpExt/ { print $21,$22 }'

git push -u origin master
git push -u origin master
http://10.0.1.194:8080/onlineguaran/;
hcjt_dzbh 10.0.1.152

location /api
{ access_log /home/hanchen/logs/nginx/lxdbapi.access.log;
error_log /home/hanchen/logs/nginx/lxdbapi.error.log;

        proxy_pass http://10.0.1.194:8080/onlineguaran/;
        client_max_body_size   200m;
}

onlineguaran
onlineguaran
172.16.30.131
acrkeGMzfP7Y
create database onlineguaran;
create database xd_trn;
grant all on xd_trn.* to xd_trn@'%' identified by 'han2018chen';
HHwElKyVMYvJ

hz_dzbh_dev
1sM3CoC27q0ZPOOB
grant all on hz_dzbh_dev.* to hz_dzbh_dev@'%' identified by '1sM3CoC27q0ZPOOB';
grant all on onlineguaran.* to onlineguaran@'%' identified by 'acrkeGMzfP7Y';
create database faceid;
grant all on ctscm_uat.* to ctscm_uat@'%' identified by 'han2018chen';

grant dev all on ctscm_sim.* to ctscm_sim@'%' identified by 'pYF2h6YJuTOmUpH2';

grant all on ctscm.* to ctscm@'%' identified by 'pYF2h6YJuTOmUpH2';

yum install postgresql10-contrib postgresql10-server -y
"D:\Program Files\mysql-5.6.42-winx64\bin\mysqldump" -u root -phan2018chen faceid > E:\backup_data\faceid.sql
grant all on faceid.* to faceid@'127.0.0.1' identified by 'HHwElKyVMYvJ';
create database jk2_trn;
grant all on jk2_trn.* to jk2_trn@'%' identified by 'HHwElKyVMYvJ';

grant all on fdd.* to fdd@'%' identified by 'GOZsirdasLVa';
grant all on jk2.* to jk2@'%' identified by 'zLHz5AamZkOK';
grant all on fdd_sim.* to fdd@'%' identified by 'GOZsirdasLVa';

grant all on signatureapi_uat.* to signatureapi_uat@'%' identified by 'acrkeGMzfP7Y';
grant all on signatureapi_sit.* to signatureapi_sit@'%' identified by 'acrkeGMzfP7Y';

grant TRIGGER on faceid_dev.blade_expert_arrange to faceid_dev@'%' identified by 'HHwElKyVMYvJ';
grant all on jk2.* to jk2@'%' identified by 'zLHz5AamZkOK';

grant TRIGGER on dbname.abcd_table to username@'%' identified by 'PASS';
grant select,update,delete,insert on faceid.blade_arr_expert to jidian@'%' identified by 'u80P4vBqVadukTxz';
grant select,update,delete,insert on faceid.blade_expert_info to jidian@'%' identified by 'u80P4vBqVadukTxz';
grant select,update,delete,insert on faceid.blade_expert_arrange to jidian@'%' identified by 'u80P4vBqVadukTxz';

grant select,update,delete,insert on faceid.blade_arr_expert to jidian@'192.168.0.12' identified by 'u80P4vBqVadukTxz';
grant select,update,delete,insert on faceid.blade_expert_info to jidian@'192.168.0.12' identified by 'u80P4vBqVadukTxz';
grant select,update,delete,insert on faceid.blade_expert_arrange to jidian@'192.168.0.12' identified by 'u80P4vBqVadukTxz';

grant select,update,delete,insert on faceid.blade_arr_expert to jidian@'127.0.0.1' identified by 'u80P4vBqVadukTxz';
grant select,update,delete,insert on faceid.blade_expert_info to jidian@'127.0.0.1' identified by 'u80P4vBqVadukTxz';
grant select,update,delete,insert on faceid.blade_expert_arrange to jidian@'127.0.0.1' identified by 'u80P4vBqVadukTxz';

grant all on signatureapi_sit.* to signatureapi_sit@'%' identified by 'acrkeGMzfP7Y';
grant select on faceid.* to check@'192.168.0.12' identified by 'JIvdlIXoqPD6mT6y';
grant select on faceid.* to chaxun@'%' identified by 'JIvdlIXoqPD6mT6y';

Platform.war
blade_arr_expert
blade_expert_arrange
blade_expert_infotelnet 10.0.1.130 20880
cnpm install -g yarn
chown -R hanchen.hanchen /youdai/jms
chown -R hanchen.hanchen /activemq-data

yum -y install fontconfig
show grants for jidian@%;
10.0.1.64
192.168.66.0/24
117.41.235.112
08540111 | 订单信息 | fpdProjectInfo | 法拍贷订单信息
export CESI_SETUP_PATH=/opt/
/usr/bin/python
source venv/bin/activate
/home/hanchen/upload
https://supervisor.ihanchen.com/
rsync -a --delete-after

https://oapi.dingtalk.com/robot/send?access_token=b6bebf800feec7258103c233d2accea8f65007d396f03d11e607fa15d0a4cc5f
crashmail

作者：慕森王
链接：https://www.imooc.com/article/40031
来源：慕课网

22926

[root@test /]#

cat /etc/supervisor/config.d/mail.conf

[eventlistener:crashmail-exited]
command=crashmail -a -s "/usr/bin/sendemail -f xxxxxx@163.com -t xxxxxx@qq.com -s smtp.163.com -u 'nginx' -xu xxxxxxx@163.com -xp xxxxxxxx -m" -m xxxxxxxx@qq.com
events=PROCESS_STATE_EXITED
redirect_stderr=false
作者：慕森王
链接：https://www.imooc.com/article/40031
来源：慕课网

/home/hanchen/deploy/jdgld
/home/hanchen/deploy/jdgld

/var/log/mysql/

rewrite ^{/(.*)$ http://$host/dubbo-admin/$1;
rewrite} /(.*)$ http://$host/dubbo-admin/$1;

wget http://caspian.dotconf.net/menu/Software/SendEmail/sendEmail-v1.56.tar.g

作者：慕森王
链接：https://www.imooc.com/article/40031
来源：慕课网
cat ihanchen.com.pem ihanchen.com.key |tee ha-ihanchen.com.pem

ssh mmears@$ "source /etc/profile && cwpid=`lsof -i :21121|grep LISTEN|awk '{print $2}'` && echo $cwpid && kill -9 $cwpid

ssh mmears@$ "source /etc/profile && cwpid=`lsof -i :21121|grep LISTEN|awk '{print $2}'` && echo $cwpid && kill -9 $cwpid && sleep 70 && supervisorctl restart $"