分类： 技术

https://docs.gitlab.com/omnibus/settings/nginx.html#vhost-server-blocknginx报502可能原因是sock文件没有访问权限

---

将www-data用户添加进gitlab-www组 usermod -aG gitlab-www www-data
注意nginx需要restart，只是reload依然不能访问 https://stackoverflow.com/questions/35327882/what-permissions-does-nginx-need-for-the-gitlab-workhorse-socket

CREATE TABLE newtableName LIKE oldTableName;
INSERT newtableName SELECT * FROM oldTableName;

全局配置 ### nginx.conf
        limit_req_zone $binary_remote_addr zone=global_req_limit:10m rate=20r/s;         limit_req zone=global_req_limit burst=100 nodelay;
        limit_conn_zone $binary_remote_addr zone=global_conn_limit:10m;         limit_conn global_conn_limit 500;

        limit_conn_zone $binary_remote_addr zone=my_conn_limit:10m;

---

单个服务配置
看情况限制最大并发数, 比如websock长链接
### xxx.com.conf         
location /faye {             limit_conn my_conn_limit 12;  }

---

在 /etc/nginx/nginx.conf 文件中
http 模块中
加入 deny 123.12.34.123;

每天凌晨4点12分更新
12 4 * * * goaccess /var/log/nginx/access.log.1 -o /var/www/html/report.html

---

每分钟
/1 * * * * root tail

grep -r -i “pentaq.ltd” –color file ./

mysql一次导出单个库下的多张表的命令

mysqldump -u admin -p -h 127.0.0.1 database_name table_name1 table_name2 table_name3 > dump.sql

查看某个人的权限 show grants for ‘zhengwenlong’@’%’;

—————-
移除用户权限
revoke select on *.* from ‘zhengwenlong’@’%’;

用户至少会拥有usage权限，并且无法移出。但其实基本上为0权限，他只可以连接数据库，查看information_schema以及修改密码。
如果用户确认不再使用，可以考虑直接删除用户。
—————-
创建用户 create user ‘zhengwenlong’@’%’ identified by ‘abcd1234888’;

$ vi ~/.bash_profile export

CLICOLOR=1

react

React is a JavaScript library for building user interfaces.

官网地址: https://reactjs.org/

GitHub仓库: https://github.com/facebook/react

中文版文档: https://www.reactjscn.com/

react-router

Declarative routing for React

官网地址: https://reacttraining.com/react-router/

GitHub仓库: https://github.com/ReactTraining/react-router

中文版文档: http://react-guide.github.io/react-router-cn/

redux

Predictable state container for JavaScript apps

官网地址: https://redux.js.org/

GitHub仓库: https://github.com/reduxjs/redux

中文版文档: https://www.redux.org.cn/

react-redux

Official React bindings for Redux

官网地址: https://react-redux.js.org/

GitHub仓库: https://github.com/reduxjs/react-redux

create-react-app

Create React apps with no build configuration.

官网地址: https://create-react-app.dev/

GItHub仓库: https://github.com/facebook/create-react-app