这个实在是有点低级的错误,提醒自己配置iptables时务必小心,尤其是执行 iptables -F清空配置时 务必小心 需要先设置默认允许才可以( 先执行 iptables -P INPUT ACCEPT )。
有了之前挂载磁盘的经验 ,还是老套路 挂载磁盘后修改配置文件: /etc/iptables/rules.v4
重启 即可。
Tags: Oracle Cloud
这个实在是有点低级的错误,提醒自己配置iptables时务必小心,尤其是执行 iptables -F清空配置时 务必小心 需要先设置默认允许才可以( 先执行 iptables -P INPUT ACCEPT )。
有了之前挂载磁盘的经验 ,还是老套路 挂载磁盘后修改配置文件: /etc/iptables/rules.v4
重启 即可。
Tags: Oracle Cloud
还是Oracle Cloud的永久免费主机,去年918时申请的 中间被删除了 本来以为是因为是中国IP发起的申请所以删除了,后来收到邮件说是错误删除并且已经给恢复了,但是因为时间太长了 找不到登录用的key了 在web管理界面倒是可以看到主机,但是登录不进去也没用啊 。
后来就搜索了下,也有其他人类似的问题 ,比较有参考价值的文章为:https://blogs.oracle.com/cloud-infrastructure/recovering-opc-user-ssh-key-on-oracle-cloud-infrastructure
主要的原理无非就是新建一台同区域的主机,卸载旧的遗忘了key的主机的启动盘(引导卷 Boot Volume) ,在新主机上附加挂载附加卷(Attached Block Volumes) 也就是刚才那个旧机器的引导卷 ,挂载磁盘 ,修改 authorized_keys ,然后卸载磁盘,重新在旧机器挂载引导卷 。
参考官方文档基本没什么障碍。
值得感谢的是Oracle直接给的就是每个账号2个永久免费主机,真的是比较大方的。
Tags: Oracle Cloud
在Oracle Cloud 控制台创建主机时选择的使用ssh key 登录的模式,也是公认、默认的更安全的登录方式。
但是在windows电脑上使用SecureCRT、FileZilla时使用系统生成的key文件都报错说格式不符合,在linux系统下使用正常。
本困惑的主要原因是搜了下说因为key的格式不同 用 puttygen 或 openssl转换下 就可以了,但是实际用 puttygen 打开就提示说是不支持的格式 后来证实它的确是目前不支持打开pkcs8。
使用在线工具转换后 实际使用正常。
Tags: Oracle Cloud
Date 888domainsale High Bid $845 Sep 29, 2020 at 1:03 PM BlueRed $795 Sep 29, 2020 at 1:03 PM 888domainsale P $750 Sep 29, 2020 at 1:03 PM 888domainsale P $745 Sep 29, 2020 at 1:03 PM BlueRed $695 Sep 29, 2020 at 1:03 PM 888domainsale $645 Sep 29, 2020 at 1:02 PM jiuzhe $595 Sep 29, 2020 at 1:01 PM 888domainsale P $545 Sep 29, 2020 at 1:01 PM jiuzhe $509 Sep 29, 2020 at 1:01 PM 888domainsale $489 Sep 29, 2020 at 1:00 PM alias1 $469 Sep 29, 2020 at 12:59 PM BlueRed $449 Sep 29, 2020 at 12:59 PM 888domainsale P $440 Sep 29, 2020 at 12:59 PM 888domainsale $329 Sep 29, 2020 at 12:57 PM alias1 $309 Sep 29, 2020 at 12:56 PM BlueRed P $299 Sep 29, 2020 at 12:56 PM BlueRed P $289 Sep 29, 2020 at 12:56 PM alias1 $269 Sep 29, 2020 at 12:56 PM BlueRed P $249 Sep 29, 2020 at 12:56 PM alias1 $229 Sep 29, 2020 at 12:56 PM BlueRed P $209 Sep 29, 2020 at 12:56 PM alias1 $199 Sep 29, 2020 at 12:56 PM BlueRed $189 Sep 29, 2020 at 12:53 PM alias1 $179 Sep 29, 2020 at 12:53 PM 888domainsale $169 Sep 29, 2020 at 12:04 PM fractal $159 Sep 29, 2020 at 9:48 AM 888domainsale P $149 Sep 29, 2020 at 9:48 AM fractal $140 Sep 29, 2020 at 9:48 AM 888domainsale P $130 Sep 29, 2020 at 9:48 AM fractal $120 Sep 29, 2020 at 9:48 AM 888domainsale $74 Sep 28, 2020 at 11:24 PM hugolag $69 Sep 27, 2020 at 11:59 AM Phishing $64 Sep 26, 2020 at 1:28 PM rocmary $59 Sep 24, 2020 at 8:26 AM ehello $59 Sep 25, 2020 at 11:06 PM fractal $59 Sep 26, 2020 at 4:13 AM domainsjmd $59 Sep 26, 2020 at 7:02 AM random007 $59 Sep 26, 2020 at 8:45 AM
生产服务器的MySql默认是utf8_general_ci字符集,但是有部分表格的字段是utf8_unicode_ci字符集。
按此前的处理方法,转换下其中一个的字符集即可,参考语句:
ALTER TABLE tablename
CHANGE COLUMN colname
VARCHAR(45) CHARACTER SET ‘utf8’ COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT ‘备注colname
但是这次的2个表 都已经有其他业务逻辑在使用,贸然调整的话 会引发其他业务的异常,于是用上了sql语句中的字符集转换方法 这样对原始存储不做改变 不影响既有业务:
select * from table1 where table1.userid = CONVERT (table2.openid USING utf8) COLLATE utf8_general_ci
最好的当然是在业务规划设计时就明确确定好使用utf8_unicode_ci。
Tags: SQL
本站之前用Let’s Encrypt的证书 但是证书要更新、证书在中国大陆存在访问干扰等原因导致想要更换到cloudflare的免费通用 SSL 。
忘记什么时候点击了 【禁用通用 SSL】 ,导致在边缘证书中一直没办法看到证书 ,困惑了好久,今天再次看这个页面的时候 发现页面底部有一个【启用通用SSL】的按钮 点击后 就有了边缘证书了。
边缘证书配合Cloudflare 签名的免费 TLS 证书,再也不用操心证书的事情了,因为边缘证书是自动签发自动更新的,源证书是15年有效期。
Tags: SSL
BidAmountDatebrcalphakHigh Bid$1,251Sep 1, 2020 at 10:15 AMonemoreseeP$1,203Sep 1, 2020 at 10:15 AMonemoreseeP$1,201Sep 1, 2020 at 10:15 AMbrcalphak$1,151Sep 1, 2020 at 10:15 AMonemoresee$1,101Sep 1, 2020 at 7:35 AMbrcalphak$1,051Sep 1, 2020 at 7:10 AMonemoreseeP$1,001Sep 1, 2020 at 7:10 AMbrcalphak$1,000Sep 1, 2020 at 7:10 AMonemoreseeP$950Sep 1, 2020 at 7:09 AMbrcalphak$900Sep 1, 2020 at 7:09 AMonemoresee$850Sep 1, 2020 at 4:21 AMMarkKaplanP$800Sep 1, 2020 at 4:21 AMMarkKaplanP$750Sep 1, 2020 at 4:20 AMonemoresee$700Sep 1, 2020 at 4:20 AMMarkKaplanP$650Sep 1, 2020 at 4:20 AMonemoresee$600Sep 1, 2020 at 4:20 AMMarkKaplanP$550Sep 1, 2020 at 4:20 AMonemoresee$500Sep 1, 2020 at 4:20 AMMarkKaplanP$480Sep 1, 2020 at 4:20 AMonemoresee$460Sep 1, 2020 at 4:20 AMMarkKaplanP$440Sep 1, 2020 at 4:20 AMonemoresee$420Sep 1, 2020 at 4:20 AMMarkKaplan$400Sep 1, 2020 at 3:50 AMonemoresee$380Aug 31, 2020 at 7:25 PMdanny9$360Aug 31, 2020 at 4:42 PMAffiliate$340Aug 31, 2020 at 11:33 AMYUSUPBABAY$320Aug 31, 2020 at 7:46 AMonemoresee$300Aug 31, 2020 at 7:43 AMafurculita$280Aug 31, 2020 at 4:22 AMonemoresee$260Aug 31, 2020 at 2:46 AMiamsky$240Aug 30, 2020 at 7:32 PMafurculita$220Aug 30, 2020 at 11:53 AMsnapbackorderP$200Aug 30, 2020 at 11:00 AMAffiliate$194Aug 30, 2020 at 11:00 AMsnapbackorderP$184Aug 30, 2020 at 11:00 AMAffiliate$174Aug 30, 2020 at 11:00 AMsnapbackorderP$164Aug 30, 2020 at 11:00 AMAffiliate$154Aug 30, 2020 at 11:00 AMsnapbackorderP$144Aug 30, 2020 at 10:57 AMAffiliate$134Aug 30, 2020 at 10:57 AMsnapbackorderP$124Aug 30, 2020 at 7:21 AMTomson$114Aug 30, 2020 at 7:21 AMsnapbackorder$104Aug 30, 2020 at 1:54 AMTA6868P$99Aug 30, 2020 at 1:54 AMTA6868P$84Aug 30, 2020 at 1:52 AMsnapbackorder$79Aug 30, 2020 at 1:52 AMTA6868P$74Aug 29, 2020 at 2:48 PMdomainlover1981$69Aug 29, 2020 at 2:48 PMTA6868$64Aug 29, 2020 at 1:36 PMlinmicom$59Aug 28, 2020 at 1:56 PM
DatereasonreasonHigh Bid$6,816Aug 19, 2020 at 1:27 PMAlibackorders$6,766Aug 19, 2020 at 1:24 PMDefendOr6$6,716Aug 19, 2020 at 1:24 PMreasonreasonP$6,666Aug 19, 2020 at 1:23 PMDefendOr6$6,655Aug 19, 2020 at 1:23 PMreasonreasonP$6,605Aug 19, 2020 at 1:23 PMDefendOr6$6,555Aug 19, 2020 at 1:23 PMreasonreasonP$6,505Aug 19, 2020 at 1:23 PMDefendOr6$6,455Aug 19, 2020 at 1:23 PMreasonreasonP$6,405Aug 19, 2020 at 1:23 PMAlibackorders$6,355Aug 19, 2020 at 1:23 PMreasonreasonP$6,305Aug 19, 2020 at 1:22 PMAlibackorders$6,255Aug 19, 2020 at 1:22 PMreasonreasonP$6,205Aug 19, 2020 at 1:22 PMDefendOr6$6,155Aug 19, 2020 at 1:22 PMreasonreasonP$6,105Aug 19, 2020 at 1:21 PMDefendOr6$6,055Aug 19, 2020 at 1:21 PMreasonreasonP$6,005Aug 19, 2020 at 1:21 PMDefendOr6$5,955Aug 19, 2020 at 1:21 PMreasonreasonP$5,905Aug 19, 2020 at 1:21 PMAlibackorders$5,855Aug 19, 2020 at 1:21 PMreasonreasonP$5,805Aug 19, 2020 at 1:21 PMAlibackorders$5,755Aug 19, 2020 at 1:21 PMreasonreasonP$5,705Aug 19, 2020 at 1:19 PMAlibackorders$5,655Aug 19, 2020 at 1:19 PMreasonreasonP$5,605Aug 19, 2020 at 1:18 PMAlibackorders$5,555Aug 19, 2020 at 1:18 PMreasonreasonP$5,222Aug 19, 2020 at 1:18 PMDefendOr6$5,172Aug 19, 2020 at 1:18 PMreasonreason$5,122Aug 19, 2020 at 1:17 PMfirst1$5,072Aug 19, 2020 at 1:17 PMreasonreasonP$5,050Aug 19, 2020 at 1:17 PMreasonreasonP$5,022Aug 19, 2020 at 1:17 PMfirst1$4,972Aug 19, 2020 at 1:17 PMreasonreasonP$4,922Aug 19, 2020 at 1:16 PMAlibackorders$4,872Aug 19, 2020 at 1:16 PMreasonreason$4,822Aug 19, 2020 at 1:16 PMAlibackorders$4,772Aug 19, 2020 at 1:16 PMDefendOr6$4,722Aug 19, 2020 at 1:15 PMAlibackorders$4,672Aug 19, 2020 at 1:14 PMDefendOr6$4,622Aug 19, 2020 at 1:14 PMAlibackorders$4,572Aug 19, 2020 at 1:12 PMDefendOr6$4,522Aug 19, 2020 at 1:11 PMAlibackorders$4,472Aug 19, 2020 at 1:10 PMDefendOr6$4,422Aug 19, 2020 at 1:10 PMAlibackorders$4,372Aug 19, 2020 at 1:09 PMDefendOr6$4,322Aug 19, 2020 at 1:07 PMchinasoa$4,272Aug 19, 2020 at 1:07 PMAlibackorders$4,222Aug 19, 2020 at 1:07 PMfirst1$4,172Aug 19, 2020 at 1:06 PMDefendOr6$4,122Aug 19, 2020 at 1:06 PMfirst1$4,072Aug 19, 2020 at 1:05 PMAlibackordersP$4,022Aug 19, 2020 at 1:05 PMfirst1$4,022Aug 19, 2020 at 1:05 PMAlibackorders$3,972Aug 19, 2020 at 1:05 PMDefendOr6$3,922Aug 19, 2020 at 1:04 PMchinasoa$3,872Aug 19, 2020 at 1:04 PMAlibackorders$3,822Aug 19, 2020 at 1:04 PMreasonreason$3,772Aug 19, 2020 at 1:03 PMDefendOr6$3,722Aug 19, 2020 at 1:03 PMfirst1$3,672Aug 19, 2020 at 1:02 PMAlibackorders$3,622Aug 19, 2020 at 1:02 PMDefendOr6P$3,572Aug 19, 2020 at 1:01 PMAlibackorders$3,550Aug 19, 2020 at 1:01 PMDefendOr6P$3,500Aug 19, 2020 at 1:00 PMAlibackorders$3,450Aug 19, 2020 at 1:00 PMDefendOr6P$3,400Aug 19, 2020 at 1:00 PMAlibackorders$3,350Aug 19, 2020 at 1:00 PMDefendOr6$3,300Aug 19, 2020 at 12:59 PMAlibackorders$3,250Aug 19, 2020 at 12:58 PMDefendOr6$3,200Aug 19, 2020 at 12:57 PMAlibackorders$3,150Aug 19, 2020 at 12:57 PMchinasoa$3,100Aug 19, 2020 at 12:56 PMfirst1$3,050Aug 19, 2020 at 12:56 PMDefendOr6$3,000Aug 19, 2020 at 12:56 PMAlibackorders$2,950Aug 19, 2020 at 12:55 PMfirst1$2,900Aug 19, 2020 at 12:55 PMchinasoa$2,850Aug 19, 2020 at 12:54 PMAlibackorders$2,800Aug 19, 2020 at 12:54 PMchinasoa$2,750Aug 19, 2020 at 12:52 PMDefendOr6$2,700Aug 19, 2020 at 12:51 PMchinasoa$2,650Aug 19, 2020 at 12:37 PMAlibackorders$2,600Aug 19, 2020 at 12:02 PMchinasoa$2,550Aug 19, 2020 at 11:37 AMAlibackordersP$2,500Aug 19, 2020 at 11:26 AMchinasoa$2,500Aug 19, 2020 at 11:26 AMAlibackordersP$2,350Aug 19, 2020 at 11:25 AMchinasoa$2,300Aug 19, 2020 at 11:25 AMAlibackorders$2,250Aug 19, 2020 at 11:25 AMchinasoaP$2,200Aug 19, 2020 at 11:25 AMchinasoa$2,150Aug 19, 2020 at 11:24 AMAlibackorders$2,100Aug 19, 2020 at 11:23 AMchinasoaP$2,050Aug 19, 2020 at 11:22 AMwhatareyoudoing$2,002Aug 19, 2020 at 11:22 AMchinasoa$1,865Aug 19, 2020 at 11:10 AMAlibackorders$1,815Aug 19, 2020 at 11:05 AMCHONGQING$1,765Aug 19, 2020 at 11:01 AMDefendOr6P$1,715Aug 19, 2020 at 10:58 AMAlibackorders$1,674Aug 19, 2020 at 10:58 AMDefendOr6P$1,624Aug 19, 2020 at 10:48 AMggggggggg$1,574Aug 19, 2020 at 10:48 AMDefendOr6P$1,524Aug 19, 2020 at 10:48 AMggggggggg$1,474Aug 19, 2020 at 10:48 AMDefendOr6P$1,424Aug 19, 2020 at 10:48 AMggggggggg$1,374Aug 19, 2020 at 10:48 AMDefendOr6P$1,324Aug 19, 2020 at 10:47 AMggggggggg$1,274Aug 19, 2020 at 10:47 AMDefendOr6P$1,224Aug 19, 2020 at 10:47 AMggggggggg$1,174Aug 19, 2020 at 10:47 AMDefendOr6P$1,124Aug 19, 2020 at 10:46 AMggggggggg$1,074Aug 19, 2020 at 10:46 AMDefendOr6P$1,024Aug 19, 2020 at 10:39 AMAlibackorders$974Aug 19, 2020 at 10:39 AMDefendOr6P$924Aug 19, 2020 at 10:22 AMAlibackorders$874Aug 19, 2020 at 10:22 AMDefendOr6P$824Aug 19, 2020 at 9:48 AMhubaba$774Aug 19, 2020 at 9:48 AMDefendOr6P$724Aug 19, 2020 at 9:47 AMhubaba$674Aug 19, 2020 at 9:47 AMDefendOr6$624Aug 19, 2020 at 8:34 AMchinasoaP$600Aug 19, 2020 at 8:34 AMchinasoaP$444Aug 19, 2020 at 8:33 AMDefendOr6$424Aug 19, 2020 at 8:33 AMchinasoaP$264Aug 19, 2020 at 8:33 AMnameword$244Aug 19, 2020 at 8:33 AMchinasoa$224Aug 19, 2020 at 7:43 AMroborwn$204Aug 18, 2020 at 1:05 PMchinasoa$194Aug 18, 2020 at 8:14 AMEastRiver$184Aug 17, 2020 at 9:21 AMDefendOr6$174Aug 17, 2020 at 8:29 AMgggggggggP$164Aug 17, 2020 at 8:01 AMyuthegreat$154Aug 17, 2020 at 8:01 AMgggggggggP$144Aug 17, 2020 at 5:39 AMbanban67$134Aug 17, 2020 at 5:39 AMgggggggggP$124Aug 16, 2020 at 5:46 PMDefendOr6$114Aug 16, 2020 at 5:46 PMgggggggggP$104Aug 16, 2020 at 5:40 PMAlibackorders$99Aug 16, 2020 at 5:40 PMgggggggggP$94Aug 16, 2020 at 4:51 PMAlibackorders$89Aug 16, 2020 at 4:51 PMgggggggggP$84Aug 16, 2020 at 4:12 PMtvinvestor$79Aug 16, 2020 at 4:12 PMgggggggggP$74Aug 16, 2020 at 2:42 PMluxtea$69Aug 16, 2020 at 2:42 PMggggggggg$64Aug 16, 2020 at 1:06 PMAlibackorders$59Aug 13, 2020 at 12:43 AMszdomains$59Aug 14, 2020 at 3:46 AMwisely$59Aug 14, 2020 at 7:00 AMehello$59Aug 14, 2020 at 10:48 PMninjadomain$59Aug 15, 2020 at 8:15 AMbhaijan$59Aug 15, 2020 at 9:44 PMnameword$59Aug 16, 2020 at 8:36 AMylm365$59Aug 16, 2020 at 8:36 AMJokers$59Aug 16, 2020 at 9:07 AMchfiedler$59Aug 16, 2020 at 9:15 AMfirst1$59Aug 16, 2020 at 10:12 AMDefendOr6$59Aug 16, 2020 at 10:26 AMskippy$59Aug 16, 2020 at 11:40 AMItems per page:
BidAmountDatelawyer0247High BidP$334Aug 13, 2020 at 12:18 PMjiuzhe$328Aug 13, 2020 at 12:18 PMlawyer0247$308Aug 13, 2020 at 12:13 PMAlibackordersP$288Aug 13, 2020 at 12:13 PMAlibackordersP$234Aug 13, 2020 at 12:13 PMlawyer0247$214Aug 13, 2020 at 12:13 PMAlibackorders$104Aug 13, 2020 at 8:34 AMFinderP$101Aug 13, 2020 at 8:34 AMFinderP$99Aug 13, 2020 at 8:33 AMAlibackorders$94Aug 13, 2020 at 8:33 AMFinderP$89Aug 13, 2020 at 8:33 AMAlibackorders$84Aug 13, 2020 at 8:33 AMFinder$79Aug 11, 2020 at 6:45 PMbosskk$74Aug 11, 2020 at 10:52 AMyuthegreat$69Aug 11, 2020 at 10:43 AMluxtea$64Aug 10, 2020 at 1:06 PM100001$59Aug 7, 2020 at 5:01 AMAlibackorders$59Aug 7, 2020 at 8:34 AMehello$59Aug 7, 2020 at 7:25 PMPoiuytr$59Aug 8, 2020 at 2:18 AMninjadomain$59Aug 8, 2020 at 7:54 AMrandom007$59Aug 8, 2020 at 7:09 PMwnnrscrs$59Aug 10, 2020 at 2:08 AMBadReligion$59Aug 10, 2020 at 3:43 AMnameword$59Aug 10, 2020 at 8:36 AMDefendOr6$59Aug 10, 2020 at 9:26 AMfirst1$59Aug 10, 2020 at 10:11 AMlawyer0247$59Aug 10, 2020 at 10:40 AMskippy$59Aug 10, 2020 at 11:38 AM
Datebanban67High Bid$851Aug 1, 2020 at 1:14 PMjiuzhe$801Aug 1, 2020 at 1:14 PMbanban67$751Aug 1, 2020 at 1:13 PMjiuzhe$701Aug 1, 2020 at 1:12 PMbanban67$651Aug 1, 2020 at 1:11 PMjiuzheP$601Aug 1, 2020 at 1:11 PMbanban67$601Aug 1, 2020 at 1:11 PMjiuzhe$551Aug 1, 2020 at 1:09 PMbanban67$501Aug 1, 2020 at 1:08 PMjiuzheP$500Aug 1, 2020 at 1:08 PMjiuzhe$440Aug 1, 2020 at 1:08 PMbanban67$420Aug 1, 2020 at 1:05 PMjiuzheP$400Aug 1, 2020 at 1:00 PMAlibackorders$400Aug 1, 2020 at 1:00 PMjiuzhe$380Aug 1, 2020 at 12:59 PMAlibackorders$360Aug 1, 2020 at 12:58 PMjiuzhe$340Aug 1, 2020 at 12:57 PMAlibackorders$320Aug 1, 2020 at 12:57 PMjiuzheP$300Aug 1, 2020 at 12:56 PMAlibackorders$284Aug 1, 2020 at 12:56 PMjiuzhe$264Aug 1, 2020 at 12:54 PMbanban67$244Aug 1, 2020 at 12:53 PMfirst1$224Aug 1, 2020 at 12:50 PMbanban67P$204Aug 1, 2020 at 12:48 PMfirst1$204Aug 1, 2020 at 12:48 PMbanban67P$194Aug 1, 2020 at 12:48 PMfirst1$184Aug 1, 2020 at 12:48 PMbanban67P$174Aug 1, 2020 at 12:47 PMfirst1$164Aug 1, 2020 at 12:47 PMbanban67P$154Aug 1, 2020 at 12:47 PMfirst1$144Aug 1, 2020 at 12:47 PMbanban67$134Aug 1, 2020 at 9:55 AMyuthegreat$124Aug 1, 2020 at 9:41 AMbanban67$114Aug 1, 2020 at 9:35 AMyuthegreat$104Aug 1, 2020 at 9:34 AMbanban67$99Aug 1, 2020 at 9:34 AMyuthegreat$94Aug 1, 2020 at 9:33 AMbanban67$89Aug 1, 2020 at 9:12 AMfirst1$84Aug 1, 2020 at 5:37 AMbanban67$79Jul 31, 2020 at 9:29 AMhueshu$74Jul 30, 2020 at 6:55 PMyuthegreat$69Jul 30, 2020 at 4:08 AMluxtea$64Jul 29, 2020 at 12:44 PMjiuzhe$59Jul 25, 2020 at 8:19 PMwisely$59Jul 27, 2020 at 4:38 AMAlibackorders$59Jul 28, 2020 at 12:28 AMbhaijan$59Jul 28, 2020 at 11:21 PMnameword$59Jul 29, 2020 at 8:36 AMfirst1$59Jul 29, 2020 at 10:14 AM