October 2023 – yyspark

registry.hub.docker.com/r/akaiot/oracle_11g

docker run -d --name oracle_11g -p 1521:1521 --privileged=true --restart=always -e TZ=Asia/Shanghai -v /opt/oracle/ggs:/opt/oracle/ggs -v /opt/oracle/oradata:/home/oracle/app/oracle/oradata -v /opt/oracle/flash_recovery_area/helowin:/home/oracle/app/oracle/flash_recovery_area/helowin akaiot/oracle_11g:latest oracle镜像来自registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g 账户：root/helowin docker exec -it oracle_11g /bin/bash source /home/oracle/.bash_profile su root #password：helowin…

MSSQL-SQLServer数据库data source

数据源表示数据库所在设备的ip地址或名称，基本上有以下几种写方法 data source = (local) data source = "127.0.0.1" data source = . data source = “服务器设备的ip” data source = “服务器设备的名称” 如果要连接的是本地的数据库（可以简单理解为向数据库发起连接请求的程序和数据库在同一台设备上面），上面的方法都是适用的，但如果请求连接的不是本地的数据库那么就只有最后两个方法可以使用（部分情况下还要进行其他操作）。

SqlServer查询表空间占用情况

SELECT obj.name "表名", pt.rows "行数", SUM(acu.used_pages)*8/1024 "大小（MB）" FROM sys.objects obj JOIN sys.indexes idx on obj.object_id = idx.object_id JOIN sys.partitions pt on obj.object_id = pt.object_id JOIN sys.allocation_units acu on acu.container_id =…

查看Docker宿主机的IP和容器的IP

ip addr route -n Last login: Fri Oct 20 21:41:53 2023 from localhost [root@centos ~]# ip addr 1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default link/loopback 00:00:00:00:00:00…

Nginx-反向代理-http-https二合一

server { listen 80; listen 443 ssl http2; server_name www.yyspark.com; #域名 #server_name www.yyspark.com yyspark.com; #域名 #SSL-START SSL相关配置 #########不带www的网址跳转到带www if ( $host !~ ^www ) { return $scheme://www.$host$request_uri; } #########不带www的网址跳转到带www #########HTTP_TO_HTTPS_START…

IIS Rewrite-http_toHttps-Add_WWW

<?xml version="1.0" ?> <rules> <clear/> <rule name="Add_WWW" stopProcessing="true"> <match url="^(.*)$"/> <conditions> <add input="{HTTP_HOST}" pattern="^(?!www.)(.*)$"/> </conditions> <action type="Redirect" url="http://www.{C:0}{PATH_INFO}" redirectType="Permanent"/> </rule> <rule name="http_toHttps" stopProcessing="true"> <match url="(.*)"/> <conditions> <add input="{HTTPS}" pattern="off" ignoreCase="true"/>…

完美DSM-CentOS

修改默认的webstation端口为8080和8443，并启动容器 cd /usr/syno/share/nginx sed -i "s/80/8080/g" server.mustache sed -i "s/80/8080/g" DSM.mustache sed -i "s/80/8080/g" WWWService.mustache sed -i "s/443/8443/g" server.mustache sed -i "s/443/8443/g" DSM.mustache sed -i "s/443/8443/g" WWWService.mustache docker run -itd…

群晖释放端口80、443，并修改默认5000、5001

一、释放80、443端口占用 #ssh登陆nas sudo -i #切换至root用户 #检查端口占用情况 netstat -anp |grep 80 netstat -anp |grep 443 #能确定端口被nginx占用 cd /usr/syno/share/nginx #文件备份，也可以不备份 cp server.mustache server.mustache_`date +%Y%m%d` cp DSM.mustache DSM.mustache_`date +%Y%m%d` cp WWWService.mustache WWWService.mustache_`date…

DSM-Tokyo-yiyilearning.com

http://yiyilearning.com:8080/https://yiyilearning.com:8443/

在群晖Docker里安装centos并安装nginx、ssh

先SSH到DSM sudo -i 输入密码切换到root 在已经安装好docker的情况下输入 docker run -itd -p 9999:999 --name centos-vm --hostname centos --privileged=true centos:centos7 /usr/sbin/init 输入以下命令进入到容器centos-vm docker exec -it centos-vm /bin/bash 更新下centos包 yum update yum upgrade 安装常用的包和ssh yum…

Month: October 2023