王某某的笔记

git clone https://github.com/xxx/xxx.git

git config --local http.proxy 'socks5://127.0.0.1:1080'

git config --local https.proxy 'socks5://127.0.0.1:1080'

git config --local https.proxy http://127.0.0.1:8080

git config --local https.proxy https://127.0.0.1:8080

git config --list

git config --global --list

cat ~/.gitconfig

pwd
/d/code/xxx/xxx/.git

MINGW64 /d/code/xxx/xxx/.git (GIT_DIR!)

$ cat config

git config --local --unset http.proxy

git config --local --unset https.proxy

vi ~/.gitconfig

git clone https://github.com/xxx/xxx.git
Cloning into 'xxxx'...
fatal: unable to access 'https://github.com/xxx/xxx.git/': Failed to connect to 127.0.0.1 port 1080: Connection refused

git clone git@github.com:xxx/xxx.git

$ git remote -v
origin  git@github.com:xxx/xxx.git (fetch)
origin  git@github.com:xxx/xxx.git (push)

git remote remove origin

git remote add origin https://github.com/xxx/xxx.git

git branch --set-upstream-to=origin/<branch> master

git config --local user.name "wwh"
git config --local user.email "wangwen135@gmail.com"

openfile("..", false)

iptables -t nat -A PREROUTING -p tcp --dport 8888 -j DNAT --to-destination 192.168.1.1:80
iptables -t nat -A POSTROUTING -p tcp -d 192.168.1.1 --dport 80 -j SNAT --to-source 192.168.1.100

iptables -t nat -A PREROUTING -p tcp --dport 8888 -j REDIRECT --to-port 80

# 唯一标识 不要和 canal 的 slaveId 重复
server-id=1

# binlog文件名
log-bin=mysql-binlog

# 选择 ROW 模式
binlog-format=ROW 

# 要忽略的数据库
binlog-ignore-db=mysql

SHOW MASTER STATUS;

"File"	"Position"	"Binlog_Do_DB"	"Binlog_Ignore_DB"	"Executed_Gtid_Set"
"mysql-binlog.000001"	"154"	""	"mysql"	""

CREATE USER canal IDENTIFIED BY 'canal';

GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'canal'@'%';

FLUSH PRIVILEGES;

# 服务端口配置
canal.port = 11111

# 客户端连接账号配置(目前未设置)
# canal.user = canal
# canal.passwd = E3619321C1A937C46A0D8BD1DAC39F93B27D4458
# 客户端连接端点名
canal.destinations = example

## canal伪装的slaveId(只要和已有的节点ID不冲突即可)
canal.instance.mysql.slaveId=99

# 数据库连接配置
canal.instance.master.address=127.0.0.1:3306
canal.instance.dbUsername=canal
canal.instance.dbPassword=canal
canal.instance.connectionCharset = UTF-8

# 监听对象(数据库/数据表) 逗号分隔
#canal.instance.filter.regex=test.table1,test.table2
canal.instance.filter.regex=.*\\..*

# 监听黑名单(当需要监听很多表, 只有少量表不需要监听时配置)
canal.instance.filter.black.regex=

ch.qos.logback.core.LogbackException: Unexpected filename extension of file [file:/D:/dev/canal/canal.deployer-1.1.4/conf/]. Should be either .groovy or .xml

@rem set logback_configurationFile=%conf_dir%\logback.xml

去掉 @rem

或者去掉

-Dlogback.configurationFile="%logback_configurationFile%" 

......
start the canal server[10.10.20.112(10.10.20.112):11111]
Start prometheus HTTPServer on port 11112.
 ## the canal server is running now ......

RegisterSlaveCommandPacket[reportHost=127.0.0.1,reportPort=59599,reportUser=canal,reportPasswd=canal,serverId=99,command=21]
position:BinlogDumpCommandPacket[binlogPosition=973,slaveServerId=99,binlogFileName=mysql-binlog.000001,command=18]

server:
  port: 8089
spring:
  jackson:
    date-format: yyyy-MM-dd HH:mm:ss
    time-zone: GMT+8

spring.datasource:
  address: 127.0.0.1:3306
  database: canal_manager
  username: canal
  password: canal
  driver-class-name: com.mysql.jdbc.Driver
  url: jdbc:mysql://${spring.datasource.address}/${spring.datasource.database}?useUnicode=true&characterEncoding=UTF-8&useSSL=false
  hikari:
    maximum-pool-size: 30
    minimum-idle: 1

canal:
  adminUser: admin
  adminPasswd: admin

GRANT SELECT, INSERT, UPDATE, DELETE ON `canal_manager`.* TO 'canal'@'%';

FLUSH PRIVILEGES;

mysql -h127.0.0.1 -uroot -p

# 导入初始化SQL
> source conf/canal_manager.sql

sh bin/startup.sh

vi logs/admin.log

# register ip
canal.register.ip =

# canal admin config
canal.admin.manager = 127.0.0.1:8089
canal.admin.port = 11110
canal.admin.user = admin
canal.admin.passwd = 4ACFE3202A5FF5CF467898FC58AAB1D615029441
# admin auto register
canal.admin.register.auto = true
canal.admin.register.cluster =

# tcp bind ip
canal.ip =
# register ip to zookeeper
canal.register.ip =
canal.port = 11111
canal.metrics.pull.port = 11112
# canal instance user/passwd
# canal.user = canal
# canal.passwd = E3619321C1A937C46A0D8BD1DAC39F93B27D4458

canal.instance.mysql.slaveId=99

canal.instance.dbUsername=canal
canal.instance.dbPassword=canal
canal.instance.connectionCharset = UTF-8
canal.instance.filter.regex=.*\\..*
canal.instance.filter.black.regex=

<dependency>
    <groupId>com.alibaba.otter</groupId>
    <artifactId>canal.client</artifactId>
    <version>1.1.0</version>
</dependency>

package com.wwh.canal.test;

import java.net.InetSocketAddress;
import java.util.List;

import com.alibaba.otter.canal.client.CanalConnectors;
import com.alibaba.otter.canal.client.CanalConnector;
import com.alibaba.otter.canal.common.utils.AddressUtils;
import com.alibaba.otter.canal.protocol.Message;
import com.alibaba.otter.canal.protocol.CanalEntry.Column;
import com.alibaba.otter.canal.protocol.CanalEntry.Entry;
import com.alibaba.otter.canal.protocol.CanalEntry.EntryType;
import com.alibaba.otter.canal.protocol.CanalEntry.EventType;
import com.alibaba.otter.canal.protocol.CanalEntry.RowChange;
import com.alibaba.otter.canal.protocol.CanalEntry.RowData;

public class CanalTest {

    public static void main(String args[]) {
        System.out.println(AddressUtils.getHostIp());

        // 创建链接
        CanalConnector connector = CanalConnectors
                .newSingleConnector(new InetSocketAddress(AddressUtils.getHostIp(), 11111), "demo", "", "");
        // destination 配置为 example 或者 demo
        
        int batchSize = 1000;
        int emptyCount = 0;
        try {
            connector.connect();
            connector.subscribe(".*\\..*");
            connector.rollback();
            int totalEmptyCount = 120;
            while (emptyCount < totalEmptyCount) {
                Message message = connector.getWithoutAck(batchSize); // 获取指定数量的数据
                long batchId = message.getId();
                int size = message.getEntries().size();
                if (batchId == -1 || size == 0) {
                    emptyCount++;
                    System.out.println("empty count : " + emptyCount);
                    try {
                        Thread.sleep(1000);
                    } catch (InterruptedException e) {
                    }
                } else {
                    emptyCount = 0;
                    // System.out.printf("message[batchId=%s,size=%s] \n", batchId, size);
                    printEntry(message.getEntries());
                }

                connector.ack(batchId); // 提交确认
                // connector.rollback(batchId); // 处理失败, 回滚数据
            }

            System.out.println("empty too many times, exit");
        } finally {
            connector.disconnect();
        }
    }

    private static void printEntry(List<Entry> entrys) {
        for (Entry entry : entrys) {
            if (entry.getEntryType() == EntryType.TRANSACTIONBEGIN
                    || entry.getEntryType() == EntryType.TRANSACTIONEND) {
                continue;
            }

            RowChange rowChage = null;
            try {
                rowChage = RowChange.parseFrom(entry.getStoreValue());
            } catch (Exception e) {
                throw new RuntimeException("ERROR ## parser of eromanga-event has an error , data:" + entry.toString(),
                        e);
            }

            EventType eventType = rowChage.getEventType();
            System.out.println(String.format("================&gt; binlog[%s:%s] , name[%s,%s] , eventType : %s",
                    entry.getHeader().getLogfileName(), entry.getHeader().getLogfileOffset(),
                    entry.getHeader().getSchemaName(), entry.getHeader().getTableName(), eventType));

            for (RowData rowData : rowChage.getRowDatasList()) {
                if (eventType == EventType.DELETE) {
                    printColumn(rowData.getBeforeColumnsList());
                } else if (eventType == EventType.INSERT) {
                    printColumn(rowData.getAfterColumnsList());
                } else {
                    System.out.println("-------&gt; before");
                    printColumn(rowData.getBeforeColumnsList());
                    System.out.println("-------&gt; after");
                    printColumn(rowData.getAfterColumnsList());
                }
            }
        }
    }

    private static void printColumn(List<Column> columns) {
        for (Column column : columns) {
            System.out.println(column.getName() + " : " + column.getValue() + "    update=" + column.getUpdated());
        }
    }

}

telnet 192.168.1.1

#用户名
admin

#密码
TeleCom_1234


# 再切换到超级用户

su telecomadmin

#密码
TeleCom_xxxxxx

#添加规则
iptables -I ftp_account 1 -i br0 -p tcp --dport 21 -j ACCEPT 

#查看
iptables -L ftp_account -n -v

#删除规则
iptables -D ftp_account 1 

//开
iptables -I inacc 1 -i br0 -p tcp --dport 22 -j ACCEPT
//查看
iptables -L inacc -n -v --line-numbers
//关
iptables -D inacc 1 


# SSH用户名密码就是电信的超级密码
# SSH 算法协议较老 需要增加额外的弱密码算法 ssh

telecomadmin@192.168.1.1 -oKexAlgorithms=+diffie-hellman-group1-sha1 -oCiphers=+3des-cbc

error_log log_file log_level ;

error_log /var/log/nginx/error.log;

http {
       ...
       ...
       error_log  /var/log/nginx/error_log;
	   ...
       server {
                listen 80;
                server_name example1.com;
                error_log  /var/log/nginx/example1.error_log  warn;
                ...
       }
       server {
                listen 80;
                server_name example2.com;
                error_log  /var/log/nginx/example2.error_log  debug;
                ...
   }
}

access_log log_file log_format ;

http {
    log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
                      '$status $body_bytes_sent "$http_referer" '
                      '"$http_user_agent" "$http_x_forwarded_for"';

    access_log  /var/log/nginx/access.log  main;

...
...
    server {
        ...
        ...
    }

http {
      ...
      access_log  /var/log/nginx/access.log;
      ...
}

http {
      ...
      access_log  /var/log/nginx/access.log;
      ...
         server {
                  listen 80;
                  Server_name example.com
                  access_log  /var/log/nginx/example.access.log;
                  ...
                  ...
                }
}

log_format combined '$remote_addr - $remote_user [$time_local] '
                '"$request" $status $body_bytes_sent '
                '"$http_referer" "$http_user_agent"'; 

http {
            log_format custom '$remote_addr - $remote_user [$time_local] '
                           '"$request" $status $body_bytes_sent '
                           '"$http_referer" "$http_user_agent" "$gzip_ratio"';

            access_log /var/log/nginx/example.access.log custom;
......
}

sh -c "$(curl -kfsSl https://cdn.jsdelivr.net/gh/monlor/mbfiles/install.sh)" && source /etc/profile &> /dev/null

***********************************************
**                                           **
**            Welcome to MIXBOX !            **
**                                           **
***********************************************
【Tools】: 请按任意键安装工具箱(Ctrl + C 退出).

请在以下路径中选择一个合适的工具箱安装位置和一个用户文件目录：
小米路由器硬盘版推荐 工具箱安装位置：/etc，用户目录：/userdisk/data
小米路由器普通版推荐 工具箱安装位置：/etc，用户目录：/extdisks/sda*
如果未插入u盘，用户目录可与工具箱安装位置相同！
1./
2./dev
3./tmp
4./
5./extdisks
6./data
7./userdisk
8./userdisk/data
9./etc
...
...
请输入你的工具箱安装路径[可手动输入路径]：9
请输入你的用户文件目录[可手动输入路径]：8
【Tools】: 下载工具箱文件...
【Tools】: 解压工具箱文件
【Tools】: 初始化工具箱配置信息...
【Tools】: 执行工具箱初始化脚本...
【Tools】: 工具箱初始化脚本启动...
【Tools】: 检查环境变量配置
【Tools】: 检查定时任务配置
【Tools】: 检查工具箱开机启动配置
【Tools】: 执行工具箱监控脚本
【Tools】: 防火墙重启插件检查
【Tools】: 运行用户自定义脚本
【Tools】: 工具箱安装完成!
【Tools】: 运行mixbox命令即可配置工具箱
root@XiaoQiang:~# 

# mixbox
获取工具箱插件列表...
***************************************
     *****   MIXBOX 工具箱   *****     
***************************************
当前版本：[0.1.9.13]    最新版本：[0.1.9.13]
设备型号：[R2D]         核心温度：[68°C]
***************************************
00. 退出工具箱
01. 已安装插件
02. 未安装插件
03. 工具箱管理

请输入你的选择：

mixbox help

请输入vsftpd用户名：xxx
请输入vsftpd密码：xxx123456
请输入xxx访问目录：/userdisk/data/ftp

# mkdir /userdisk/data/ftp
# chmod 777 ftp

********* Aria2 ***********
[Linux下一款高效的下载工具]
启动aria2服务[1/0] [回车即1]：1
修改aria2端口号()？[1/0] 0
修改aria2配置(空, /userdisk/data/下载)？[1/0] /userdisk/data/aria2Download
请输入aria2外网访问配置[1/0][回车即1]：1
【Aria2】: 正在停止aria2服务... 
【Aria2】: 删除nat-start触发...
【Aria2】: 正在启动aria2服务... 
【Aria2】: 加载aria2配置...
【Aria2】: 更新bt-tracker
【Aria2】: 生成aria2本地web页面
【Aria2】: 添加nat-start触发事件...
【Aria2】: 启动aria2服务完成！
【Aria2】: 访问[http://192.168.31.1/backup/log/aria2]管理服务
【Aria2】: jsonrpc地址:http://192.168.31.1:6800/jsonrpc

********* FileBrowser ***********
[Web文件浏览器]
启动filebrowser服务[1/0] [回车即1]：1
修改filebrowser端口号(1086)？[1/0] 
修改filebrowser默认访问路径(/userdisk/data)？[1/0] 
请输入filebrowser外网访问配置[1/0][回车即1]：0
【FileBrowser】: 正在停止filebrowser服务... 
【FileBrowser】: 删除nat-start触发...
【FileBrowser】: 正在启动filebrowser服务... 
【FileBrowser】: 启动filebrowser服务完成！
【FileBrowser】: 请在浏览器中访问[http://192.168.31.1:1086]，默认用户名密码admin

./filebrowser -p 1086 -d /etc/mixbox/apps/filebrowser/bin/filebrowser.db 

daemon /etc/mixbox/apps/filebrowser/bin/filebrowser -a 0.0.0.0 -p 1086 -d /etc/mixbox/apps/filebrowser/bin/filebrowser.db

daemon /etc/mixbox/apps/filebrowser/bin/filebrowser -a 192.168.31.1 -p 1086 -d /etc/mixbox/apps/filebrowser/bin/filebrowser.db

daemon ${mbroot}/apps/${appname}/bin/${appname} -p ${port} -d ${mbroot}/apps/${appname}/config/${appname}.db -l ${mbroot}/var/log/${appname}.log -s $scope 

改成：

daemon ${mbroot}/apps/${appname}/bin/${appname} -a 0.0.0.0 -p ${port} -d ${mbroot}/apps/${appname}/bin/${appname}.db -l ${mbroot}/var/log/${appname}.log  

请输入你的选择：1
********* AliDDNS ***********
[动态将你的路由器IP绑定到域名]
启动aliddns服务[1/0] [回车即1]：1
修改aliddns配置？[1/0] 1
请输入aliddns访问ID[回车即xxxxxxxxxxxxxxxxxxxxxxxxx]：
请输入aliddns访问密钥[回车即xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx]：
请输入aliddns域名[例如@.mixbox.com或www.mixbox.com][回车即test.xxxxxxxxxxxxx.top]：@.xxxxxxxxxxxxxxxxx.top    
请输入aliddns检查分钟间隔(建议10)[回车即10]：
支持类型[0仅ipv4/1仅ipv6/2通吃][回车即0]：
重启aliddns服务[1/0][回车即1]：
【AliDDNS】: 正在停止aliddns服务... 
【AliDDNS】: 正在启动aliddns服务... 
【AliDDNS】: 启动aliddns服务完成！

# 查看
iptables -list

# 显示行号
iptables -nL --line-number | more

# 删除INPUT表的第3条

iptables -D INPUT 3

# 允许某个IP访问全部服务
iptables -I INPUT -s 123.240.202.217 -j ACCEPT