作者： admin

网络测试-NAT-

Posted on by admin

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,

===============================
http://ip.taobao.com/outGetIpInfo?ip=43.2.1.3&accessKey=alibaba-inc

===============================
Debian开启和关闭Ipv6的方法

检查系统是否有加载ipv6内核

lsmod | grep ipv6

返回类似下面的数据，则表示加载了ipv6内核

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

检查是否有ipv6地址

1
2
3
ifconfig 
ip address list
netstat -anptl

临时关闭ipv6的命令

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

临时开启ipv6命令

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

永久关闭系统ipv6

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

永久开启系统的ipv6，把上面代码的1改为0即可。。。

查看系统ipv6状态命令

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

返回0表示启用，1则表示禁用ipv6

研究地球,learn_earth

Posted on by admin
Google Earth Pro 7.3.2 离线安装包
用于 Windows（32 位）的 7.3.2 版 https://dl.google.com/dl/earth/client/advanced/current/googleearthprowin-7.3.2.exe
用于 Windows（64 位）的 7.3.2 版 https://dl.google.com/dl/earth/client/advanced/current/googleearthprowin-7.3.2-x64.exe
用于 Mac 的 7.3.2 版 https://dl.google.com/dl/earth/client/advanced/current/googleearthpromac-intel-7.3.2.dmg
用于 Linux（Debian/Ubuntu 64 位）的 7.3.2 版 https://dl.google.com/dl/linux/direct/google-earth-pro-stable_7.3.2_amd64.deb
用于 Linux（Fedora/openSUSE 64 位）的 7.3.2 版 https://dl.google.com/dl/linux/direct/google-earth-pro-stable-7.3.2.x86_64.rpm
Google Earth Web 网页版
https://earth.google.com/web/

cesium
https://cesium.com/platform/cesiumjs/
http://cesium.xin/

https://lbs.amap.com/demo/javascript-api/example/3d/map3d
https://leafletjs.com/
https://docs.mapbox.com/mapbox-gl-js/example/add-terrain/
https://openlayers.org/

数据库SQL-MySQL-SQLServer-Oracle-PGSQL-在Linux中安装SQLServer

Posted on by admin

==============================================
MySQL
https://downloads.mysql.com/archives/installer/
官方工具集 https://downloads.mysql.com/archives/
==============================================
忘记MySQL 密码
先关闭mysql服务,再带参数启动
./mysqld_safe –skip-grant-tables
进mysql命令行
mysql -uroot -p
执行更新
update mysql.user SET Password=PASSWORD(‘password123′) where USER=’root’;
update mysql.user set authentication_string=password(‘password123′) where user=’root’;
update mysql.user set grant_priv=’Y’ where user=’root’ and host=’%’;
grant all privileges on *.* to root@”%” identified by “Password123”;
grant all privileges on *.* to root@”127.0.0.1″ identified by “Password123” WITH GRANT OPTION;
select host,user,password,authentication_string from mysql.user;
flush privileges;
退出重启MySQL,密码已变更为password123
==============================================
PQSQL
https://www.postgresql.org/download/

==============================================
Microsoft® SQL Server® 2017 Express
https://www.microsoft.com/zh-CN/download/details.aspx?id=55994
官方管理工具 SQL Server Management Studio
https://docs.microsoft.com/zh-CN/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017

Yes, SQL Server 2008 R2 Express with Tools and SQL Server 2008 R2 Express with Advanced Services will allow 10GB databases as well.
SQL Server 2008 R2 Express is still limited to 1 CPU and 1 GB or RAM.
免费版有内存使用和数据库大小的限制， 10G数据库，1G内存，1CPU，
作为测试，要用那么多资源干啥？？

==============================================
# 在Linux中安装SQLServer
https://learn.microsoft.com/zh-cn/sql/linux/quickstart-install-connect-docker
sql-server-management-studio
https://learn.microsoft.com/zh-cn/ssms/download-sql-server-management-studio-ssms#download-ssms
https://aka.ms/ssmsfullsetup

==============================================

Oracle Database XE , Free Oracle Database for Everyone
https://www.oracle.com/database/technologies/appdev/xe.html
Oracle SQL Developer
https://www.oracle.com/cn/tools/downloads/oracle-sql-developer-download.html

序号版本数据限制内存限制处理器限制
 1 XE 18c 12GB 2GB 2*CPU
 2 XE 11gR2 11GB 1GB 1*CPU
 3 XE 10g 4GB 1GB 1*CPU

一台机器上只能安装一个 XE 实例, 最大数据库大小为 12 GB,可使用的最大内存是 2G
==============================================

管理工具
heidisql
https://www.heidisql.com/download.php

快速导出数据库结构
SmartSQL
https://gitee.com/izhaofu/SmartSQL

错误提示：ERROR 1273 (HY000): Unknown collation: ‘utf8mb4_0900_ai_ci’
是因为linux下MySQL版本不兼容导致的
我们需要做的是打开我们导出的的sql文件

• 把文件中的所有的utf8mb4_0900_ai_ci替换为utf8_general_ci
• 以及utf8mb4替换为utf8

最后再重新导入成功。

ALTER USER ‘sqluser’@’%’ IDENTIFIED WITH mysql_native_password BY ‘sqluser’;
FLUSH PRIVILEGES;

vscode

Posted on by admin

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几次