https://forums.aws.amazon.com/thread.jspa?threadID=307496
1.通过get-relational-database-parameters查询可用参数
|
1 |
aws lightsail get-relational-database-parameters --relational-database-name DatabaseName |
2.通过update-relational-database-parameters更新参数
|
1 |
aws lightsail update-relational-database-parameters --relational-database-name xxxx --parameters "parameterName=time_zone,applyMethod=pending-reboot,parameterValue=Asia/Shanghai" |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
#!/bin/sh if [ true != "$INIT_D_SCRIPT_SOURCED" ] ; then fi ### BEGIN INIT INFO # Provides: svnserve # Required-Start: $remote_fs $syslog # Required-Stop: $remote_fs $syslog # Default-Start: 2 3 4 5 # Default-Stop: 0 1 6 # Short-Description: svnserve init script # Description: bare minimum svn init script ### END INIT INFO DESC="subversion server" DAEMON=/usr/bin/svnserve DAEMON_ARGS="-d -r /data/svn --log-file /var/log/svn.log" |
|
1 2 3 4 |
sudo chmod 755 /etc/init.d/svnserve sudo update-rc.d svnserve defaults sudo systemctl enable svnserve sudo systemctl daemon-reload |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName VARCHAR(256) -- filename for backup DECLARE @fileDate VARCHAR(20) -- used for file name -- specify database backup directory SET @path = 'C:\Backup\' -- specify filename format SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112) DECLARE db_cursor CURSOR READ_ONLY FOR SELECT name FROM master.dbo.sysdatabases WHERE name NOT IN ('master','model','msdb','tempdb') -- exclude these databases OPEN db_cursor FETCH NEXT FROM db_cursor INTO @name WHILE @@FETCH_STATUS = 0 BEGIN SET @fileName = @path + @name + '_' + @fileDate + '.BAK' BACKUP DATABASE @name TO DISK = @fileName FETCH NEXT FROM db_cursor INTO @name END CLOSE db_cursor DEALLOCATE db_cursor |
patch_awvs md5: d2a234cbdb477c8dcfff8914266f908b
docker pull mcr.microsoft.com/mssql/server:2017-latest
sudo docker run -e ‘ACCEPT_EULA=Y’ -e ‘SA_PASSWORD=password’ \ -p 1433:1433 –name sql1 \ -d mcr.microsoft.com/mssql/server:2017-latest
服务端
https://github.com/hwdsl2/setup-ipsec-vpn
客户端
https://github.com/usualwyy/l2pt-vpn-client
https://unix.stackexchange.com/questions/249654/message-at-shutdown-watchdog-did-not-stop
1) Edit the file at /etc/default/grub and edit the GRUB_CMDLINE_LINUX line to look like this:GRUB_CMDLINE_LINUX="reboot=bios"
2) run: update-grub
By default, Cloudflare acts as a reverse proxy. As such, all connections to your origin web server come from Cloudflare IP addresses, and there are some issues that you need to aware of:
However, Cloudflare follows industry standards and includes the visitor’s IP address in the X-Forwarded-For header. We also add a CF-Connecting-IP header that may be used as well. You can use these headers to either restore the originating IP of your visitor for your web application or to be include it in your logs.
Restoring the original visitor IP for your web application
Please use the following Nginx module and the following configuration parameters:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
set_real_ip_from 103.21.244.0/22; set_real_ip_from 103.22.200.0/22; set_real_ip_from 103.31.4.0/22; set_real_ip_from 104.16.0.0/12; set_real_ip_from 108.162.192.0/18; set_real_ip_from 131.0.72.0/22; set_real_ip_from 141.101.64.0/18; set_real_ip_from 162.158.0.0/15; set_real_ip_from 172.64.0.0/13; set_real_ip_from 173.245.48.0/20; set_real_ip_from 188.114.96.0/20; set_real_ip_from 190.93.240.0/20; set_real_ip_from 197.234.240.0/22; set_real_ip_from 198.41.128.0/17; set_real_ip_from 2400:cb00::/32; set_real_ip_from 2606:4700::/32; set_real_ip_from 2803:f800::/32; set_real_ip_from 2405:b500::/32; set_real_ip_from 2405:8100::/32; set_real_ip_from 2c0f:f248::/32; set_real_ip_from 2a06:98c0::/29; # use any of the following two real_ip_header CF-Connecting-IP; #real_ip_header X-Forwarded-For; |
That list of prefixes needs to be updated regularly, and we publish the full list in Cloudflare IP addresses.
Including the original visitor IP in your logs
You can include the variables $http_cf_connecting_ip and $http_x_forwarded_for in the log_format directive.
Also see: Cloudflare and Nginx