分类： 便签

https://tomchen.github.io/symmetric-nat-test/
查看当前的网络类型

===============================
https://ipw.cn/
https://ip.taobao.com/ipSearch

查看是否支持IPv6
https://www.test-ipv6.com/index.html.zh_CN
https://test-ipv6.com/
https://ipv6test.wcode.net/

IPV4
https://myip.ipip.net,
https://ddns.oray.com/checkip,
https://ip.3322.net,
https://v4.yinghualuo.cn/bejson”,

IPV6
https://speed.neu6.edu.cn/getIP.php,
https://v6.ident.me,
https://6.ipw.cn,
https://v6.yinghualuo.cn/bejson,

1
2
3
4
5
6

nf_reject_ipv6         16384  1 ip6t_REJECT
nf_log_ipv6            16384  5
nf_conntrack_ipv6      20480  8
nf_defrag_ipv6         16384  1 nf_conntrack_ipv6
nf_log_common          16384  2 nf_log_ipv6,nf_log_ipv4
nf_conntrack          114688  8 nf_conntrack_ipv6,nf_conntrack_ftp,nf_conntrack_ipv4,nf_conntrack_broadcast,nf_nat_ftp,nf_conntrack_netbios_ns,xt_conntrack,nf_nat

1
2
3

ifconfig 
ip address list
netstat -anptl

1
2

sysctl -w net.ipv6.conf.all.disable_ipv6=1
sysctl -w net.ipv6.conf.default.disable_ipv6=1

1
2

sysctl -w net.ipv6.conf.all.disable_ipv6=0
sysctl -w net.ipv6.conf.default.disable_ipv6=0

1
2
3
4
5
6
7
8

echo " ">>/etc/sysctl.conf
echo "# made for disabled IPv6 in $(date +%F)">>/etc/sysctl.conf
echo 'net.ipv6.conf.all.disable_ipv6 = 1'>>/etc/sysctl.conf
echo 'net.ipv6.conf.default.disable_ipv6 = 1'>>/etc/sysctl.conf
echo 'net.ipv6.conf.lo.disable_ipv6 = 1'>>/etc/sysctl.conf
tail -5 /etc/sysctl.conf
sysctl -p
netstat -anptl

1
2
3
4

vi /etc/sysctl.conf  //编辑系统内核文件，添加以下代码
net.ipv6.conf.all.disable_ipv6 = 1
net.ipv6.conf.default.disable_ipv6 = 1
net.ipv6.conf.lo.disable_ipv6 = 1

1
2

cat /proc/sys/net/ipv6/conf/all/disable_ipv6
cat /proc/sys/net/ipv6/conf/default/disable_ipv6

VSCode, 升级插件后运行java 提示要11版本之上,
But,作为老人, 咱只需要用java-8即可, 不想升级11, 咋整,
打开主站, 这里找插件
https://marketplace.visualstudio.com/
查找JAVA,
https://marketplace.visualstudio.com/items?itemName=redhat.java
找到Changelog,
https://marketplace.visualstudio.com/items/redhat.java/changelog
0.65.0 (July 22nd, 2020)
enhancement – Require Java 11 to run the extension. See #1524.
0.65.0 后即提示需要java-11了, 所以,找之前的版本,
找到下载连接,更高版本号
https://marketplace.visualstudio.com/_apis/public/gallery/publishers/redhat/vsextensions/java/0.64.1/vspackage
下载后为文件
redhat.java-0.64.1.vsix
复制到 VSCode 安装目录下, 运行CMD , Code.exe –install-extension redhat.java-0.64.1.vsix

插件扩展, 右上角选 install from vsix, 选择刚下载的文件,
视安装情况, 会要求reload几次

推荐发行版本
alpine , https://www.alpinelinux.org/
好用，体积小，常放docker 内使用，如果使用非系统自带的服务，得考虑兼容性，

debian, https://www.debian.org/

slitaz,
https://www.slitaz.org/

manjaro
https://manjaro.org/

以下发行版本不适合新手使用
gentoo
https://www.gentoo.org/

arch
https://archlinux.org/

参考友链
https://linux.zone/
https://manjaro.org.cn/

ESP8266

开发工具
https://esp8266.ru/esplorer/
https://github.com/4refr0nt/ESPlorer
https://gitee.com/apnode/ESPlorer
https://www.espressif.com/zh-hans/support/download/other-tools

1. 买板子，
2. 看文档，参考，https://nodemcu.readthedocs.io/en/release/getting-started/#cloud-builder
3. 烧固件，参考， https://blog.csdn.net/zz531987464/article/details/83447583
4. helloworld

1. 查询所有表行数及内容占用空间大小，

   SELECT 
       t.NAME AS TableName,
       p.rows AS RowCounts,
       SUM(a.total_pages) * 8 AS TotalSpaceKB,
       SUM(a.used_pages) * 8 AS UsedSpaceKB,
       (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB
   FROM 
       sys.tables AS t
   INNER JOIN      
       sys.indexes AS i ON t.OBJECT_ID = i.object_id
   INNER JOIN 
       sys.partitions AS p ON i.object_id = p.object_id AND i.index_id = p.index_id
   INNER JOIN 
       sys.allocation_units AS a ON p.partition_id = a.container_id
   WHERE 
       t.is_ms_shipped = 0 AND i.index_id IN (0, 1)
   GROUP BY 
       t.Name, p.Rows
   ORDER BY 
       TotalSpaceKB DESC;
   

2.  与时俱进，在Linux下运行 SQLServer,

   
   # 参考 
   # https://github.com/microsoft/mssql-docker 
   # https://learn.microsoft.com/zh-cn/sql/linux/quickstart-install-connect-docker?view=sql-server-ver16&tabs=cli&pivots=cs1-bash
   # 
   # @SQLServer2019 是密码，记得改
   docker pull mcr.microsoft.com/mssql/server:2019-latest
   docker run  -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=@SQLServer2019" -p 1433:1433 -v /mnt:/mnt   --memory 3072M --name sql2019 -d mcr.microsoft.com/mssql/server:2019-latest
   
   

    

3. 常用语句

#1. 创建数据库 kingdee
CREATE DATABASE kingdee;

#2. 创建登录用户 kingdee
CREATE LOGIN kingdee WITH PASSWORD = 'kingdee', CHECK_POLICY = OFF;
CREATE LOGIN king_reader WITH PASSWORD = 'king_reader', CHECK_POLICY = OFF;;

#3. 将登录用户 kingdee 映射到数据库 kingdee 并设置为 dbo
USE kingdee;
CREATE USER kingdee FOR LOGIN kingdee;
EXEC sp_addrolemember 'db_owner', 'kingdee';

#4. 验证设置
USE kingdee;
SELECT name, type_desc, default_schema_name 
FROM sys.database_principals 
WHERE name = 'kingdee';