主页 / user-118418

morleyc's questions

Martin Hope
morleyc
Asked: 2020-10-13 06:14:43 +0800 CST
  • 2

我正在为我的 DELL R730 使用存储空间和 SSD，我有一个 PCIe 到 SSD 适配器（并且不能使用 RAID 控制器，因为所有托架都已满）。

我的问题与 SSD 本身有关，我知道 RAID-5 NAS 驱动器等如果驱动器上的非 RAID/NAS 固件会丢失驱动器......这同样适用于使用商业 SSD 的驱动器镜像吗？

如果不是商业的，我可以配对的数据库级 M2 SSD 的任何建议，因为这将用于数据库。

dell-poweredge storage-spaces
Martin Hope
morleyc
Asked: 2020-05-23 09:15:35 +0800 CST
  • 0

我有一个使用代理服务（WAF 等）的服务器，它将数据包转发到我的服务器。

我可以从所有代理中看到已建立netstat -an的 SSL 连接，其余的则卡在 SYN_RECV 中：

tcp        0      0 192.168.102.11:443      185.93.230.20:64966     SYN_RECV
tcp        0      0 192.168.102.11:443      192.88.135.20:8306      SYN_RECV
tcp        0      0 192.168.102.11:443      66.248.202.20:10750     SYN_RECV
tcp        0      0 192.168.102.11:443      185.93.230.20:2213      SYN_RECV
tcp        0      0 192.168.102.11:443      66.248.202.20:7494      SYN_RECV
tcp        0      0 192.168.102.11:443      185.93.231.20:32752     ESTABLISHED
tcp        0      0 192.168.102.11:443      185.93.231.20:31910     ESTABLISHED

我可以看到流量tcpdump port 443 and '(tcp-syn|tcp-ack)!=0' -nn：

为了185.93.231.20.2139

20:36:35.263777 IP 192.168.102.11.443 > 185.93.231.20.2139: Flags [FP.], seq 203642186:203642217, ack 1968471817, win 258, options [nop,nop,TS val 32827456 ecr 876705214], length 31
20:36:36.901357 IP 192.168.102.11.443 > 185.93.231.20.2137: Flags [P.], seq 418165034:418165065, ack 2875697257, win 258, options [nop,nop,TS val 32829093 ecr 876704135], length 31

为了185.93.230.20

20:36:49.098560 IP 185.93.230.20.20721 > 192.168.102.11.443: Flags [S], seq 2855805773, win 29200, options [mss 1460,sackOK,TS val 882921029 ecr 0,nop,wscale 9], length 0
20:36:49.098638 IP 192.168.102.11.443 > 185.93.230.20.20721: Flags [S.], seq 268496949, ack 2855805774, win 28960, options [mss 1460,sackOK,TS val 32841290 ecr 882921029,nop,wscale 7], length 0

对于66.248.202.20：

20:37:02.042048 IP 66.248.202.20.49557 > 192.168.102.11.443: Flags [S], seq 3837436386, win 29200, options [mss 1460,sackOK,TS val 791596242 ecr 0,nop,wscale 9], length 0
20:37:02.042116 IP 192.168.102.11.443 > 66.248.202.20.49557: Flags [S.], seq 2339555392, ack 3837436387, win 28960, options [mss 1460,sackOK,TS val 32854234 ecr 791596242,nop,wscale 7], length 0

对于192.88.135.20：

20:36:39.595087 IP 185.93.228.20.23354 > 192.168.102.11.443: Flags [S], seq 1334433323, win 29200, options [mss 1460,sackOK,TS val 274977072 ecr 0,nop,wscale 9], length 0
20:36:39.595120 IP 192.168.102.11.443 > 185.93.228.20.23354: Flags [S.], seq 1203016390, ack 1334433324, win 28960, options [mss 1460,sackOK,TS val 32831787 ecr 274970056,nop,wscale 7], length

但只有来自185.93.231.20的流量才会登录到 domlogs：

185.93.231.20 - - [22/May/2020:19:55:37 +0400] "GET /blog/video-gallery/ HTTP/1.1" 200 12716 "https://www.example.com/blog/publications/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:76.0) Gecko/20100101 Firefox/76.0" 747893
185.93.231.20 - - [22/May/2020:19:55:39 +0400] "GET /wp-content/uploads/2020/02/Thumbnail72.jpg HTTP/1.1" 200 181941 "https://www.example.com/blog/video-gallery/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:76.0) Gecko/20100101 Firefox/76.0" 1283052
185.93.231.20 - - [22/May/2020:19:55:39 +0400] "GET /wp-content/uploads/2020/02/Thumbnail68.jpg HTTP/1.1" 200 180934 "https://www.example.com/blog/video-gallery/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:76.0) Gecko/20100101 Firefox/76.0" 952373

关于下一步检查什么的任何想法？我已禁用所有防火墙规则并确保 NAT 在 WAN 和主机（入站和出站）之间正常工作 - 没有发生任何配置更改，这只是停止工作。

tcpdump netstat apache2 linux-networking
Martin Hope
morleyc
Asked: 2018-06-25 00:10:19 +0800 CST
  • 0

我将本地服务器复制到远程服务器，一切都很好（远程服务器启用为副本服务器，带有 HTTPS 入站）。

如果我对远程服务器执行计划的故障转移，如何将更改复制回来，它们是通过出站本地到远程 HTTPS 连接还是通过其他方式？

我的本地服务器未启用为副本服务器，因此对启用入站 HTTP 没有任何说明。

感谢指针无法在谷歌上找到任何文档。

hyper-v
Martin Hope
morleyc
Asked: 2018-06-13 01:39:26 +0800 CST
  • 0

亲爱的，我遇到了许多邮件流问题，并从 powershell 检查队列Get-Queue我得到以下信息：

Identity       DeliveryType          Status MessageCount Velocity RiskLevel OutboundIPPool NextHopDomain
--------       ------------          ------ ------------ -------- --------- -------------- -------------
ex1\285        DnsConnectorDelivery  Retry  2            0        Normal    0              domain1.com
ex1\351        SmtpDeliveryToMailbox Ready  0            0        Normal    0              mailbox 1
ex1\352        DnsConnectorDelivery  Ready  0            0        Normal    0              domain2.com
ex1\452        DnsConnectorDelivery  Ready  0            0        Normal    0              domain3.com
ex1\578        DnsConnectorDelivery  Active 1            0        Normal    0              domain4.com
ex1\1818       DnsConnectorDelivery  Retry  1            0        Normal    0              domain5.com
ex1\1819       DnsConnectorDelivery  Retry  1            0        Normal    0              domain6.com
ex1\Submission Undefined             Ready  0            0        Normal    0              Submission

我为 SMTP 连接器启用了详细日志记录，但是当我查看日志文件位置时，我无法找到有关该问题的任何进一步信息（我看到发送正常的消息，而没有关于失败消息或任何重试的消息）。

检查队列查看器它提供了更多详细信息，如下所示，远程主机关闭的套接字，它提供了更多信息。

任何想法队列查看器的相应日志将用于出站 SMTP，它会提供相同级别的详细信息并允许我使用 Powershell 进行搜索？

队列查看器

exchange
Martin Hope
morleyc
Asked: 2017-12-08 07:52:27 +0800 CST
  • 0

我有一个 Hyper-V 盒子，它具有以下连接的 IP 电话的通话录音：

  1. PBX 在接入端口（本地 vlan 42）上，插入交换机上的端口 22（它没有 VLAN 设置，因此我们设置本地接入 vlan，使其所有流量都在 VLAN 42 上）。
  2. 混合端口上的电话（本机 vlan 1 用于工作站，标记为 42 用于电话）
  3. Hyper-V 机器上用于来宾 VM 的专用 NIC
  4. Hyper-V 机器上的专用 NIC，用于监视交换机上的端口 21。
  5. 在 Hyper-V 上启用端口镜像

HP ProCurve 2610-24 交换机配置如下：

mirror-port 21
vlan 1
  name "DEFAULT"
  untagged 1-17,19-21,23-28
  no untagged 18,22
exit
vlan 42
  name "VOICE"
  untagged 22
  tagged 1-20,23,26
exit
interface 22
  monitor
exit

我在 Hyper-V 主机上启用了监控：

  1. 在 Hyper-V 主机上，创建一个名为 Monitor 的新虚拟交换机，它物理连接到专用的监控 NIC（也为一般流量创建一个单独的交换机）。
  2. 启用扩展 Microsoft NDIS Capture。
  3. $portFeature=Get-VMSystemSwitchExtensionPortFeature -FeatureName "Ethernet Switch Port Security Settings"
  4. $portFeature.SettingData.MonitorMode = 2
  5. Add-VMSwitchExtensionPortFeature -ExternalPort -SwitchName Monitor -VMSwitchExtensionFeature $portFeature
  6. 创建一个新的虚拟机，添加以下虚拟网络适配器：
    1. 用于连接到访客虚拟交换机的一般数据流量的 NIC
    2. 用于监控连接到监控虚拟交换机的流量的 NIC
  7. 在来宾虚拟机的监控虚拟网卡下，进入Advanced Features，将端口镜像模式设置为Destination。

当我在访客监控 VM 上运行 Wire-shark 时，我只看到从 PBX（源）到电话（目的地）的单向流量，而不是从电话到 PBX。

原则上，由于 PBX 可以发送/接收未标记的数据（在端口 22 上显示），这应该在端口监控端口上逐字显示为未标记的数据帧（对于本地 VLAN 42），否则我会叫错树?

我已经完成了相同的 Hyper-V 设置，但使用了 Cisco，并且没有任何问题可以正常工作。

不确定这是我做错了什么，是 Windows 的问题，还是 HP 的问题。非常感谢指针。

networking
Martin Hope
morleyc
Asked: 2017-10-15 04:06:10 +0800 CST
  • 2

我在 Cisco 交换机和 Fortinet 100E 防火墙之间设置了 2 个以太网中继。到目前为止，以下工作正常（我可以从 Cisco 192.168.1.2 ping 并从 Fortinet 192.168.1.1 获得回复）：

interface Port-channel1
 switchport trunk native vlan 1
 switchport trunk encapsulation dot1q
 switchport trunk allowed vlan 255
 switchport mode trunk
!
interface FastEthernet0/1
 switchport trunk native vlan 1
 switchport trunk encapsulation dot1q
 switchport trunk allowed vlan 255
 switchport mode trunk
 channel-group 1 mode active
!
interface FastEthernet0/2
 switchport trunk native vlan 1
 switchport trunk encapsulation dot1q
 switchport trunk allowed vlan 255
 switchport mode trunk
 channel-group 1 mode active
!
interface vlan255
 ip address 192.168.1.2 255.255.255.0

根据https://forum.fortinet.com/tm.aspx?m=106460 ，上面不是 LACP 中继（尽管它确实有效），而应该是：

int range gi 1/0/1-2
no shut
switchport
channel-group 1 mode active
channel-protocol lacp
load-interval 30
logging event link-status
logging event bundle-status
!

我有几个问题：

  1. 如果我所做的方式不是真正的 LACP，它如何与 Fortinet（为 802.3ad Aggregate 设置）一起工作？似乎channel-protocol lacp我的端口上的设置没有区别（默认情况下是 LACP）？

  2. 如果我想将我的本地 vlan 从 1 移动到 10，这会阻止中继工作（因为我看不到在 Fortinet 上定义本地 vlan 的位置，因为我了解 LACP 协商会通过本地 vlan）？

  3. 我在 Fortinet 上看到有添加 VLAN 的默认网络 - 我目前已将其设置为无 ip 0.0.0.0/0，但有没有办法完全删除它而只拥有 VLAN？还是应该将管理 IP 放在这个默认网络上？什么是最佳实践？

树干

cisco
Martin Hope
morleyc
Asked: 2017-05-27 13:57:23 +0800 CST
  • 0

我有以下措施来防止代理连接抖动（在标记为 OK 之前，它必须稳定 20 分钟）。

在更正Zabbix Trigger Hysteresis - Incorrect trigger expression的语法后，我有以下内容：

({TRIGGER.VALUE}=0 and {Template App Zabbix Agent:agent.ping.nodata(5m)}=1) or ({TRIGGER.VALUE}=1 and {Template App Zabbix Agent:agent.ping.min(20m)}=1)

虽然它最初在没有数据时触发，但它永远不会恢复。我目前正在使用 v3.0.9，所以现在尝试使用上述内容。

我在targets下查看了最新的agent数据，可以看到agent ping确实是120多分钟。

请问我做错了什么？

zabbix
Martin Hope
morleyc
Asked: 2017-05-27 11:59:45 +0800 CST
  • 2

我正在尝试使用以下表达式：

({TRIGGER.VALUE}=0&{Template App Zabbix Agent:agent.ping.nodata(5m)}=1) | ({TRIGGER.VALUE}=1&{Template App Zabbix Agent:agent.ping.min(20m)}=1)

但我收到以下错误：Incorrect trigger expression. Check expression part starting from "0&{Template App Zabbix Agent:agent.ping.nodata(5m)}=1)|({TRIGGER.VALUE}=1&{Template App Zabbix Agent:agent.ping.min(20m)}=1)".

知道我在做什么错吗？

zabbix
Martin Hope
morleyc
Asked: 2017-03-23 01:53:11 +0800 CST
  • 1

突然间，我们的 Ubuntu php5.6-fpm 服务器停止处理 curl 请求。

这是我发现的：

从控制台运行时工作php test.php。

通过潮湿的工作console wget -qO- https://maps.google.com/maps/api/geocode/json?address=Brooklyn+NY+USA&key=AIzaSyBGgTVnShML1_WHJL0rOTEnt2XOrgVgnu4 | cat

使用 curl 从console ums-admin@svr1:/var/www/propertymonitor.ae/htdocs/v2$ curl https://maps.google.com/maps/api/geocode/json?address=Brooklyn+NY+USA&key=AIzaSyBGgTVnShML1_WHJL0rOTEnt2XOrgVgnu4

但是通过https://example.com/test.php上的 php-fpm 调用脚本它不起作用并抱怨 DNS 查找失败？！

重新启动 php5.6-fpm 并再次开始工作？！

下面的代码：

<?php
// create curl resource
$ch = curl_init();

// set url
curl_setopt($ch, CURLOPT_URL, "https://maps.google.com/maps/api/geocode/json?address=Brooklyn+NY+USA&key=AIzaSyBGgTVnShML1_WHJL0rOTEnt2XOrgVgnu4");

//return the transfer as a string
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

// $output contains the output string
$data = curl_exec($ch);

if ($data === false)
{
echo 'Curl error: ' . curl_error($ch);
} else {
echo 'Response: ' . $data;
}

// close curl resource to free up system resources
curl_close($ch);
?>

系统的其余部分检查：

cat /etc/resolv.conf
# Dynamic resolv.conf(5) file for glibc resolver(3) generated by resolvconf(8)
# DO NOT EDIT THIS FILE BY HAND -- YOUR CHANGES WILL BE OVERWRITTEN
nameserver 8.8.8.8
nameserver 8.8.4.4
search example.com

并且没有丢包：

64 bytes from 8.8.8.8: icmp_seq=3150 ttl=46 time=129 ms
64 bytes from 8.8.8.8: icmp_seq=3151 ttl=46 time=124 ms
64 bytes from 8.8.8.8: icmp_seq=3152 ttl=46 time=124 ms
64 bytes from 8.8.8.8: icmp_seq=3153 ttl=46 time=124 ms
^C
--- 8.8.8.8 ping statistics ---
3153 packets transmitted, 3153 received, 0% packet loss, time 3154312ms
rtt min/avg/max/mdev = 114.975/124.705/139.692/2.004 ms
ubuntu
Martin Hope
morleyc
Asked: 2017-03-09 12:04:49 +0800 CST
  • 0

根据https://oitibs.com/install-hyper-v-lis-on-debian-8/我需要编辑nano /etc/initramfs-tools/modules但是我注意到即使没有这个，也没有安装apt-get install hyperv-daemons，开箱即用以下模块会被加载：

root@svr1:/home/jason# lsmod | grep hv_*
hv_balloon             20874  0
hv_utils               17718  0
hv_storvsc             21296  3
scsi_mod              191405  4 sg,sd_mod,sr_mod,hv_storvsc
hv_netvsc              30494  0
hv_vmbus               65661  7 hv_balloon,hyperv_keyboard,hv_netvsc,hid_hyperv,hv_utils,hyperv_fb,hv_storvsc

这些完整的 Hyper-V 组件是否在首次安装时就已准备就绪？

如果是这样，我们运行时正在安装什么apt-get install hyperv-daemons？

debian hyper-v
Martin Hope
morleyc
Asked: 2016-03-25 15:27:58 +0800 CST
  • 2

我一直在使用 rackspace 电子邮件服务，并且我发现流氓电子邮件看似来自该用户[email protected]，[email protected]但实际上从未由该用户发送。

根据 rackspace，这封电子邮件是通过[email protected]使用他的凭据发送的。从电子邮件标题中，我无法判断这是在secureserver.net上运行的脚本正在执行此操作（使用他的凭据）还是发送欺骗性电子邮件（脚本在没有身份验证的情况下发送SMTP，只是将电子邮件设置为/从相应的字段）。

我的问题是：

  1. SMTP 服务器可以通过两种方式接收电子邮件：1) 来自其他 SMTP 服务器，2) 或来自通过它进行身份验证和中继的客户端。如果无法访问接收服务器日志，标头中指示客户端通过经过身份验证的用户名/密码进行中继的详细信息在哪里？

  2. 在添加了其他详细信息的地方，这些是来自发件人的欺骗还是真实的：X-Get-Message-Sender-Via: a2plcpnl0576.prod.iad2.secureserver.net: authenticated_id:[email protected]？

  3. 尽管我们的域的 SPF 记录仅包含网络服务器 IP 和include:emailsrvr.com标志-all，但 Rackspace 表示无法使用它来检查欺骗性电子邮件，或者这是因为它们已通过 SMTP 服务器的身份验证并在这种情况下中继?

标题如下：

Delivered-To:   [email protected]
Return-Path:    <[email protected]>
Received:   from smtp48.gate.iad3a (smtp48.gate.iad3a.rsapps.net [172.27.146.93]) by store370a.mail.iad3a (SMTP Server) with ESMTP id 6B21338004D for <[email protected]>; Tue, 22 Mar 2016 18:51:50 -0400 (EDT)
X-Spam-Threshold:   95
X-Spam-Score:   0
X-Spam-Flag:    NO
X-Virus-Scanned:    OK
X-MessageSniffer-Scan-Result:   0
X-MessageSniffer-Rules: 0-0-0-5195-c
X-CMAE-Scan-Result: 0
X-CNFS-Analysis:    v=2.1 cv=Ksx0hwmN c=1 sm=0 tr=0 a=03oFrmF08fajSB7oc4goJw==:117 a=3DDquuGS2V5BkRhJnJP3ow==:17 a=L9H7d07YOLsA:10 a=9cW_t1CCXrUA:10 a=s5jvgZ67dGcA:10 a=AsRiV6KZ74iSbj+k8RJYJIAeGPg=:19 a=2L8f7PMcNrQA:10 a=7OsogOcEt9IA:10 a=KXl77lDgDEgIEtoqJYcA:9 a=_6GpL_ENAAAA:8 a=ZYf_q_66Zn7mdDxIrUkA:9 a=giY71Mj1q15_ivv6:21 a=NF3jo81ehh1LRULu:21 a=wPNLvfGTeEIA:10 a=xupg4knwUDYA:10 a=iDzWDAaf-0_1B4d3PKkA:9 a=AX674DPcPDPt-UkY:21 a=v5bIRgG1RGZFvm2Y:21 a=_W_S_7VecoQA:10
X-Orig-To:  [email protected]
X-Originating-Ip:   [198.71.225.37]
Received:   from [198.71.225.37] ([198.71.225.37:50277] helo=a2nlsmtp01-03.prod.iad2.secureserver.net) by smtp48.gate.iad3a.rsapps.net (envelope-from <[email protected]>) (ecelerity 2.2.3.49 r(42060/42061)) with ESMTPS (cipher=AES256-SHA) id B2/C7-21891-17EB1F65; Tue, 22 Mar 2016 18:51:50 -0400
Received:   from a2plcpnl0576.prod.iad2.secureserver.net ([198.71.236.72]) by : HOSTING RELAY : with SMTP id iUAOaPfNohy43iUAOaMLT4; Tue, 22 Mar 2016 14:48:44 -0700
Message-ID: <[email protected]>
Received:   from [77.234.42.143] (port=65110 helo=[100.100.48.14]) by a2plcpnl0576.prod.iad2.secureserver.net with esmtpsa (TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.85_1) (envelope-from <[email protected]>) id 1aiUAO-0010vj-5P for [email protected]; Tue, 22 Mar 2016 14:48:44 -0700
Content-Type:   multipart/alternative; boundary="===============0122389713=="
MIME-Version:   1.0
Subject:    Important
To: Recipients <[email protected]>
From:   "Harry" <[email protected]>
Date:   Tue, 22 Mar 2016 16:48:39 -0500
Reply-To:   [email protected]
X-Antivirus:    avast! (VPS 160322-0, 03/22/2016), Outbound message
X-Antivirus-Status: Clean
X-AntiAbuse:    This header was added to track abuse, please include it with any abuse report
X-AntiAbuse:    Primary Hostname - a2plcpnl0576.prod.iad2.secureserver.net
X-AntiAbuse:    Original Domain - mydomain.com
X-AntiAbuse:    Originator/Caller UID/GID - [47 12] / [47 12]
X-AntiAbuse:    Sender Address Domain - mydomain.com
X-Get-Message-Sender-Via:   a2plcpnl0576.prod.iad2.secureserver.net: authenticated_id: [email protected]
X-Source:   
X-Source-Args:  
X-Source-Dir:   
X-CMAE-Envelope:        MS4wfEPENpifHOCgRpfP6548FFaFh5aGvLkdZm1fLn1ObUi/GIxIvKJEpHzquISJMsZqy70pnMkKI97Q9A0DqQ32JQ78HW6S1tBah8JgoDrTNI9F4pp4EDOM HTkGtTYtUC9r9UUrKvESTtmSFszS6652/MgX84oIFe88If6ClU4eOj36h5+xgnUIKFWOr106/ju1qIlkFmQeQS7UynivyRiK6r8QHvsju7aabN+eUPHBb+4qI
smtp
Martin Hope
morleyc
Asked: 2016-02-07 11:34:06 +0800 CST
  • 1

我正在使用 Cloudflare 和 nginx geoip 指令：

geoip_country /usr/local/share/GeoIP/GeoIP.dat;
geoip_city /usr/local/share/GeoIP/GeoLiteCity.dat;

他们选择 IP 正常（pipaddress因为请求在标头中标记为已转发），但将国家/地区显示为 SG（cloudflare 代理位置）。

如果HTTP_X_FORWARDED_FOR设置了标题，是否有最终用户的国家？

<?php
    if (getenv(HTTP_X_FORWARDED_FOR))
    {
        $pipaddress = getenv(HTTP_X_FORWARDED_FOR);
        $ipaddress = getenv(REMOTE_ADDR);
        echo "Your IP address is : ".$pipaddress. " (via proxy $ipaddress) " ;
    }
    else
    {
        $ipaddress = getenv(REMOTE_ADDR);
        echo "Your IP address is : $ipaddress";
    }

    $country = getenv(GEOIP_COUNTRY_NAME);
    $country_code = getenv(GEOIP_COUNTRY_CODE);
    echo "<br/>Your country : $country ( $country_code ) ";
?>

并且/etc/nginx/fastcgi_params如下：

fastcgi_param  QUERY_STRING       $query_string;
fastcgi_param  REQUEST_METHOD     $request_method;
fastcgi_param  CONTENT_TYPE       $content_type;
fastcgi_param  CONTENT_LENGTH     $content_length;

fastcgi_param  SCRIPT_FILENAME    $request_filename;
fastcgi_param  SCRIPT_NAME        $fastcgi_script_name;
fastcgi_param  REQUEST_URI        $request_uri;
fastcgi_param  DOCUMENT_URI       $document_uri;
fastcgi_param  DOCUMENT_ROOT      $document_root;
fastcgi_param  SERVER_PROTOCOL    $server_protocol;
fastcgi_param  HTTPS              $https if_not_empty;

fastcgi_param  GATEWAY_INTERFACE  CGI/1.1;
fastcgi_param  SERVER_SOFTWARE    nginx/$nginx_version;

fastcgi_param  REMOTE_ADDR        $remote_addr;
fastcgi_param  REMOTE_PORT        $remote_port;
fastcgi_param  SERVER_ADDR        $server_addr;
fastcgi_param  SERVER_PORT        $server_port;
fastcgi_param  SERVER_NAME        $server_name;

# Set php-fpm geoip variables
fastcgi_param GEOIP_COUNTRY_CODE $geoip_country_code;
fastcgi_param GEOIP_COUNTRY_CODE3 $geoip_country_code3;
fastcgi_param GEOIP_COUNTRY_NAME $geoip_country_name;
fastcgi_param GEOIP_CITY_COUNTRY_CODE $geoip_city_country_code;
fastcgi_param GEOIP_CITY_COUNTRY_CODE3 $geoip_city_country_code3;
fastcgi_param GEOIP_CITY_COUNTRY_NAME $geoip_city_country_name;
fastcgi_param GEOIP_REGION $geoip_region;
fastcgi_param GEOIP_CITY $geoip_city;
fastcgi_param GEOIP_POSTAL_CODE $geoip_postal_code;
fastcgi_param GEOIP_CITY_CONTINENT_CODE $geoip_city_continent_code;
fastcgi_param GEOIP_LATITUDE $geoip_latitude;
fastcgi_param GEOIP_LONGITUDE $geoip_longitude;
nginx
Martin Hope
morleyc
Asked: 2016-02-07 11:02:46 +0800 CST
  • 0

我已经在 WordPress 中设置了带有缓存的 nginx。

我正在使用https://wordpress.org/plugins/nginx-helper/，但是登录页面似乎在不应该被缓存时被缓存（因此显示了登录栏）。

一些未登录的访问者（也没有任何 cookie/浏览器缓存）正在查看登录栏（如果他们点击栏中的任何内容，则会将他们重定向到登录页面）。

在此处输入图像描述

此外，当我单击 WordPress 中的清除缓存按钮时，页面仍然提供并显示为XCache HIT......真正清除的唯一方法是通过rm -rf /dev/shm/nginx.

我确实安装了以下模块：

nginx version: nginx/1.8.0
built with OpenSSL 1.0.1f 6 Jan 2014
TLS SNI support enabled
configure arguments: --with-cc-opt='-g -O2 -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format-security -D_FORTIFY_SOURCE=2' 
--with-ld-opt='-Wl,-Bsymbolic-functions -Wl,-z,relro' --prefix=/usr/share/nginx --conf-path=/etc/nginx/nginx.conf --http-log-path=/var/log/nginx/access.log 
--error-log-path=/var/log/nginx/error.log --lock-path=/var/lock/nginx.lock --pid-path=/run/nginx.pid --http-client-body-temp-path=/var/lib/nginx/body 
--http-fastcgi-temp-path=/var/lib/nginx/fastcgi --http-proxy-temp-path=/var/lib/nginx/proxy --http-scgi-temp-path=/var/lib/nginx/scgi 
--http-uwsgi-temp-path=/var/lib/nginx/uwsgi
--with-debug --with-pcre-jit --with-ipv6 --with-http_ssl_module
--with-http_stub_status_module --with-http_realip_module 
--with-http_auth_request_module --with-http_addition_module
--with-http_geoip_module --with-http_gzip_static_module
--with-http_image_filter_module --with-http_spdy_module 
--with-http_sub_module --with-http_xslt_module
--add-module=/build/buildd/nginx-1.8.0/debian/modules/headers-more-nginx-module 
--add-module=/build/buildd/nginx-1.8.0/debian/modules/nginx-auth-pam
--add-module=/build/buildd/nginx-1.8.0/debian/modules/nginx-cache-purge 
--add-module=/build/buildd/nginx-1.8.0/debian/modules/nginx-echo
--add-module=/build/buildd/nginx-1.8.0/debian/modules/ngx-fancyindex 
--add-module=/build/buildd/nginx-1.8.0/debian/modules/nginx-lua
--add-module=/build/buildd/nginx-1.8.0/debian/modules/nginx-upload-progress 
--add-module=/build/buildd/nginx-1.8.0/debian/modules/nginx-upstream-fair
--add-module=/build/buildd/nginx-1.8.0/debian/modules/ngx_http_substitutions_filter_module 
--add-module=/build/buildd/nginx-1.8.0/debian/modules/ngx_pagespeed

知道我的配置有什么问题吗？

user www-data;
worker_processes 4;
pid /run/nginx.pid;

events {
        worker_connections 1024;
        multi_accept on;
}

http {
        geoip_country /usr/local/share/GeoIP/GeoIP.dat;
        geoip_city /usr/local/share/GeoIP/GeoLiteCity.dat;

        sendfile on;
        tcp_nopush on;
        tcp_nodelay on;
        keepalive_timeout 65;
        types_hash_max_size 2048;

        client_max_body_size 300m;
        proxy_send_timeout 300;
        proxy_read_timeout 300;

        include /etc/nginx/mime.types;
        default_type application/octet-stream;

        access_log /var/log/nginx/access.log;
        error_log /var/log/nginx/error.log;

        gzip on;
        gzip_disable "msie6";


        # Upstream to abstract backend connection(s) for PHP.
        upstream php {
               server 127.0.0.1:9000;
        }

        include /etc/nginx/conf.d/*.conf;

        fastcgi_cache_path /dev/shm/nginx levels=1:2 keys_zone=WPCACHE:384m max_size=3072m inactive=480m;
        fastcgi_cache_key "$scheme$request_method$host$request_uri";

        server {
            server_name mysite.com;
            root /home/mysite/public_html/;
            index index.php;

            access_log /home/mysite/logs/access.log;
            error_log  /home/mysite/logs/error.log;

            fastcgi_cache_use_stale error timeout invalid_header http_500;
            fastcgi_ignore_headers Cache-Control Expires Set-Cookie;

            # Rules to work out when cache should or should not be used
            set $skip_cache 0;
            # POST requests and urls with a query string should always go to PHP

            if ($request_method = POST) {
                set $skip_cache 1;
            }

            if ($query_string != "") {
                set $skip_cache 1;
            }

            # Don't cache uris containing the following segments
            if ($request_uri ~* "/wp-admin/|/xmlrpc.php|wp-.*.php|/feed/|index.php|sitemap(_index)?.xml") {
                set $skip_cache 1;
            }

            # Don't use the cache for logged in users or recent commenters
            if ($http_cookie ~* "comment_author|wordpress_[a-f0-9]+|wp-postpass|wordpress_no_cache|wordpress_logged_in") {
                set $skip_cache 1;
            }

            location = /favicon.ico {
                log_not_found off;
                access_log off;
            }

            location / {
                try_files $uri $uri/ /index.php?$args;
            }

            # Add trailing slash to */wp-admin requests.
            rewrite /wp-admin$ $scheme://$host$uri/ permanent;

            location ~ \.php$ {
                try_files $uri =404;
                fastcgi_split_path_info ^(.+\.php)(/.+)$;
                include fastcgi_params;
                fastcgi_index index.php;
                fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
                fastcgi_pass php;

                fastcgi_cache WPCACHE;
                fastcgi_cache_valid 200 480m;


                fastcgi_cache_methods GET HEAD;
                fastcgi_cache_bypass $skip_cache;
                fastcgi_no_cache $skip_cache;

                #more_clear_headers Server; more_clear_headers "Pragma";
                add_header Z_LOCATION "PHP MAIN"; add_header URI $uri; # DEBUG
                add_header X-Cache $upstream_cache_status;
            }

            location ~ /purge(/.*) {
                fastcgi_cache_purge WPCACHE "$scheme$request_method$host$1";
            }

            location ~* ^.+\.(ogg|ogv|svg|svgz|eot|otf|woff|mp4|ttf|css|rss|atom|js|jpg|jpeg|gif|png|ico|zip|tgz|gz|rar|bz2|doc|xls|exe|ppt|tar|mid|midi|wav|bmp|rtf)$ {
                access_log off;
                log_not_found off;
                expires max;
            }

            location = /robots.txt {
                access_log off;
                log_not_found off;
            }

            location ~ /\. {
                deny  all;
                access_log off;
                log_not_found off;
            }
        }   
}
nginx
Martin Hope
morleyc
Asked: 2016-02-06 21:44:38 +0800 CST
  • 0

我已经设置了一个指令来缓存到 nginx 中的 memdisk：

fastcgi_cache_path /dev/shm/nginx levels=1:2 keys_zone=WPCACHE:2048m inactive=480m;
fastcgi_cache_key "$scheme$request_method$host$request_uri";

server {
       #snip other locations...

       # Pass all .php files onto a php-fpm/php-fcgi server.
       location ~ \.php$ {
          try_files $uri =404;
          fastcgi_split_path_info ^(.+\.php)(/.+)$;
          include fastcgi_params;
          fastcgi_index index.php;
          fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
          fastcgi_pass php;

          fastcgi_cache WPCACHE;
          fastcgi_cache_valid 200 480m;
          add_header X-Cache $upstream_cache_status;

          fastcgi_cache_methods GET HEAD;
          fastcgi_cache_bypass $skip_cache;
          fastcgi_no_cache $skip_cache;

          #more_clear_headers Server; more_clear_headers "Pragma";
          add_header Z_LOCATION "PHP MAIN"; add_header URI $uri; # DEBUG
    }

}

我知道这应该将缓存大小限制为 2GB 480 分钟，但是现在它是 2.8GB，所以超过了这个限制 - 请知道我做错了什么吗？

root@www1:/dev/shm/nginx# du -sch *
182M    0
183M    1
177M    2
174M    3
177M    4
172M    5
172M    6
167M    7
174M    8
172M    9
168M    a
171M    b
174M    c
177M    d
172M    e
179M    f
2.8G    total
nginx
Martin Hope
morleyc
Asked: 2016-01-09 06:15:21 +0800 CST
  • 1

我正在使用 fpm php 5.5 运行 Ubuntu nginx 1.8，在一个站点上我能够使缓存正常工作（通过简单的时间输出）<?php echo time();?>显示：

Connection:keep-alive
Content-Encoding:gzip
Content-Type:text/html
Date:Fri, 08 Jan 2016 14:04:00 GMT
Fastcgi-Cache:HIT
Server:nginx/1.8.0
Transfer-Encoding:chunked
X-Powered-By:PHP/5.5.9-1ubuntu4.14

但是对于 WordPress 网站，标题始终显示（即使在注销和隐身时）：

Cache-Control:no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Connection:keep-alive
Content-Encoding:gzip
Content-Type:text/html; charset=UTF-8
Date:Fri, 08 Jan 2016 14:02:42 GMT
Expires:Thu, 19 Nov 1981 08:52:00 GMT
Fastcgi-Cache:BYPASS
Link:<http://mywpsite.com/wp-json/>; rel="https://api.w.org/"
Link:<http://mywpsite.com/>; rel=shortlink
Pragma:no-cache
Server:nginx/1.8.0
Transfer-Encoding:chunked
Vary:Accept-Encoding
X-Powered-By:PHP/5.5.9-1ubuntu4.14

从 wiki 我尝试了不同的设置并压缩到以下单个文件（tester.com 有效，而 mywpsite.com 没有 - 这些是我在我的主机文件中设置的别名，并且肯定命中了正确的服务器）https://codex .wordpress.org/Nginx。

猫 /etc/nginx/nginx.conf

user www-data;
worker_processes 4;
pid /run/nginx.pid;

events {
        worker_connections 1024;
        # multi_accept on;
}

http {
        fastcgi_cache_key "$scheme$request_method$host$request_uri";

        sendfile on;
        tcp_nopush on;
        tcp_nodelay on;
        keepalive_timeout 65;
        types_hash_max_size 2048;

        include /etc/nginx/mime.types;
        default_type application/octet-stream;

        gzip on;
        gzip_disable "msie6";

        application/xml+rss text/javascript;

        # Upstream to abstract backend connection(s) for PHP.
        upstream php {
                #this should match value of "listen" directive in php-fpm pool
                server unix:/var/run/php5-fpm.sock;
        }

        include /etc/nginx/conf.d/*.conf;
        include /etc/nginx/sites-enabled/*;

        add_header Fastcgi-Cache $upstream_cache_status;
}

猫 /etc/nginx/sites-available/tester.com

fastcgi_cache_path /home/tester.com/cache levels=1:2 keys_zone=MYAPP:100m inactive=60m;

server {
    listen   80;
    server_name tester.com;

    root /home/tester.com/public_html;
    index index.php index.html index.htm;

    location / {
        try_files $uri $uri/ /index.html;
    }

    location ~ \.php$ {
        try_files $uri =404;
        fastcgi_pass unix:/var/run/php5-fpm.sock;
        fastcgi_index index.php;
        include fastcgi_params;
        fastcgi_cache MYAPP;
        fastcgi_cache_valid 200 60m;
    }
}

猫 /etc/nginx/sites-available/mywpsite.com

fastcgi_cache_path /home/mywpsite.com/cache levels=1:2 keys_zone=MYWPSITE:100m inactive=60m;

server {
        server_name mywpsite.com;
        root /home/mywpsite.com/public_html;

        index index.php;

        location = /favicon.ico {
                log_not_found off;
                access_log off;
        }

        location = /robots.txt {
                allow all;
                log_not_found off;
                access_log off;
        }

        location ~ /\. {
                access_log off;
                log_not_found off;
                deny all;
        }

        location ~* /(?:uploads|files)/.*\.php$ {
                deny all;
        }

        location / {
                try_files $uri $uri/ /index.php?$args;
        }

        # Add trailing slash to */wp-admin requests.
        rewrite /wp-admin$ $scheme://$host$uri/ permanent;

        set $skip_cache 0;

        if ($request_method = POST) {
            set $skip_cache 1;
        }

        if ($query_string != "") {
            set $skip_cache 1;
        }

        if ($request_uri ~* "/wp-admin/|/xmlrpc.php|wp-.*.php|/feed/|index.php|sitemap(_index)?.xml") {
            set $skip_cache 1;
        }

        if ($http_cookie ~* "comment_author|wordpress_[a-f0-9]+|wp-postpass|wordpress_no_cache|wordpress_logged_in") {
            set $skip_cache 1;
        }

        location ~* ^.+\.(ogg|ogv|svg|svgz|eot|otf|woff|mp4|ttf|rss|atom|jpg|jpeg|gif|png|ico|zip|tgz|gz|rar|bz2|doc|xls|exe|ppt|tar|mid|midi|wav|bmp|rtf)$ {
               access_log off; log_not_found off; expires max;
        }

        fastcgi_cache_bypass $skip_cache;
        fastcgi_no_cache $skip_cache;
        fastcgi_cache MYWPSITE;
        fastcgi_cache_valid 60m;

        location ~ [^/]\.php(/|$) {
                fastcgi_split_path_info ^(.+?\.php)(/.*)$;
                if (!-f $document_root$fastcgi_script_name) {
                        return 404;
                }
                # This is a robust solution for path info security issue and works with "cgi.fix_pathinfo = 1" in /etc/php.ini (default)

                include fastcgi.conf;
                fastcgi_index index.php;
                #       fastcgi_intercept_errors on;
                fastcgi_pass php;

                fastcgi_cache_bypass $skip_cache;
                fastcgi_no_cache $skip_cache;

                fastcgi_cache MYWPSITE;
                fastcgi_cache_valid 200 60m;
        }

        location ~ /purge(/.*) {
                fastcgi_cache_purge MYWPSITE"$scheme$request_method$host$1";
        }
}

道歉，因为我确信这是一些愚蠢的事情，但经过几个深夜后，我会很感激一些新鲜的眼睛来看待这个问题。

nginx
Martin Hope
morleyc
Asked: 2015-07-04 06:56:48 +0800 CST
  • 5

我们有一个HP ProCurve 2530-24-PoE (J9773A)交换机，最近我有一个用户将 Apple 无线硬件设备插入网络 - 每当连接它时，我都会收到来自交换机的大量广播警告，间歇性丢包和交换机 CPU 使用率飙升.

我移除了他的设备，一切都很好......鉴于整个办公室都关闭了，并且每次插入时都无法工作，除了与 Apple 硬件配置有关之外，我无法找到根本原因。我只能假设他已设置为连接到 WiFi 的客户端桥接器并通过 Apple 以太网端口导致环回！

我在 HP ProCurve 上启用了生成树，但这并没有阻止网络中断。

我正在考虑再次阻止这种情况发生（并进一步锁定用户将他们自己的未经授权的接入点/交换机连接到网络），并在https://cs.uwaterloo.ca/cscf看到以下推荐的命令来加强循环/reports/CNAG/2009/ProCurve%20Best%20Practices.pdf：

loop-protect 1-24
spanning-tree 1-24 root-guard
spanning-tree 1-24 bpdu-protection
spanning-tree 1-24 admin-edge-port
loop-protect 1-24

问题 1 - 使用这些命令或任何我应该注意的上述命令可以在晚上轻松入睡吗？

问题 2 - 上述命令会阻止人们弄乱网络并连接他们自己的硬件，还是需要任何其他命令？

问题 3 - 如果我们有自己的授权无线设备，是否会bpdu-protection停止无线接入点上客户端的桥接，我们是否应该在连接到我们的无线接入点的端口上关闭此功能？

问题 4 - 我们有一个语音 VLAN 设置并指定为语音：

vlan 69
   name "DATA_VLAN"
   untagged 1-24
   no ip address
   exit
vlan 70
   name "VOICE_VLAN"
   tagged 1-24
   no ip address
   qos dscp 101110
   voice
   exit

电话插在交换机上，电脑插在电话后面。与问题 3 类似，这将如何bpdu-protection影响我在每部电话后面都有一台 PC 的事实（因此每个端口基本上有 2 个 MAC 地址）。语音 vlan 70 中指定的事实是否voice允许并处理此问题？

switch
Martin Hope
morleyc
Asked: 2014-11-24 11:34:28 +0800 CST
  • 2

我们的业务部门已被外部实体收购。

我们正在运行 2008 R2 AD，他们正在运行 2012 AD，域未加入或信任。

他们在总部数据中心（域 A）中拥有包括域控制器在内的服务器。

我们这里有一个域控制器（域 B）。我们现在被认为是总部（域A）的海外。

两个站点都通过 VPN 链接，所有服务器都可以相互联系，事实上，他们构建了一个 DC 来在我们网络中的办公室运行（但目前不与域 B 的 DC 通信，它同步到它的主域 A通过 VPN 的 DC）。

问题 - 我们需要做什么（在工作站和服务器上）来：

  1. 允许域 A 总部的用户使用其正常的域 A 凭据登录到其新海外办事处（加入域 B 的工作站）的工作站

  2. 仍然允许现有的域 B 用户照常登录和使用他们的工作站（现有的域 B 活动目录帐户可以像以前一样使用域 B 工作站）？

如果使用信任，这需要是单向的还是双向的？是否只是添加信任的情况，仅此而已，还是需要在工作站或组策略上配置任何内容？

windows-server-2008-r2
Martin Hope
morleyc
Asked: 2014-08-14 23:27:50 +0800 CST
  • 0

我在 Centos 6.5 上运行 MySQL 5.6.17（2.6.32-042stab090.5 #1 SMP Sat Jun 21 00:15:09 MSK 2014 x86_64 x86_64 x86_64 GNU/Linux）。

MySQL 每隔几周就会停止运行，日志不会显示任何表明原因的内容。

磁盘空间很好（使用了 50%），内存使用也很好。

我还可以采取哪些其他步骤来诊断此问题？

2014-08-13 17:55:18 26960 [Note] InnoDB: 128 rollback segment(s) are active.
2014-08-13 17:55:18 26960 [Note] InnoDB: Waiting for purge to start
2014-08-13 17:55:18 26960 [Note] InnoDB: 5.6.17 started; log sequence number 1307884677
2014-08-13 17:55:18 26960 [Note] Server hostname (bind-address): '*'; port: 3306
2014-08-13 17:55:18 26960 [Note] IPv6 is available.
2014-08-13 17:55:18 26960 [Note]   - '::' resolves to '::';
2014-08-13 17:55:18 26960 [Note] Server socket created on IP: '::'.
2014-08-13 17:55:19 26960 [Note] Event Scheduler: Loaded 0 events
2014-08-13 17:55:19 26960 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.17'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
140813 17:57:10 mysqld_safe Number of processes running now: 0
140813 17:57:10 mysqld_safe mysqld restarted
2014-08-13 17:57:12 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-08-13 17:57:13 27945 [Note] Plugin 'FEDERATED' is disabled.
2014-08-13 17:57:13 27945 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-08-13 17:57:13 27945 [Note] InnoDB: The InnoDB memory heap is disabled
2014-08-13 17:57:13 27945 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-08-13 17:57:13 27945 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-08-13 17:57:13 27945 [Note] InnoDB: Using Linux native AIO
2014-08-13 17:57:13 27945 [Note] InnoDB: Using CPU crc32 instructions
2014-08-13 17:57:13 27945 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-08-13 17:57:13 27945 [Note] InnoDB: Completed initialization of buffer pool
2014-08-13 17:57:13 27945 [Note] InnoDB: Highest supported file format is Barracuda.
2014-08-13 17:57:13 27945 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1307884687
2014-08-13 17:57:13 27945 [Note] InnoDB: Database was not shutdown normally!
2014-08-13 17:57:13 27945 [Note] InnoDB: Starting crash recovery.
2014-08-13 17:57:13 27945 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-08-13 17:57:13 27945 [Note] InnoDB: Restoring possible half-written data pages
2014-08-13 17:57:13 27945 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1307954236
2014-08-13 17:57:13 27945 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 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 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
2014-08-13 17:57:14 27945 [Note] InnoDB: 128 rollback segment(s) are active.
2014-08-13 17:57:14 27945 [Note] InnoDB: Waiting for purge to start
2014-08-13 17:57:14 27945 [Note] InnoDB: 5.6.17 started; log sequence number 1307954236
2014-08-13 17:57:14 27945 [Note] Server hostname (bind-address): '*'; port: 3306
2014-08-13 17:57:14 27945 [Note] IPv6 is available.
2014-08-13 17:57:14 27945 [Note]   - '::' resolves to '::';
2014-08-13 17:57:14 27945 [Note] Server socket created on IP: '::'.
2014-08-13 17:57:14 27945 [Note] Event Scheduler: Loaded 0 events
2014-08-13 17:57:14 27945 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.17'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
140813 17:57:21 mysqld_safe Number of processes running now: 0
140813 17:57:21 mysqld_safe mysqld restarted
2014-08-13 17:57:21 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-08-13 17:57:21 28100 [Note] Plugin 'FEDERATED' is disabled.
2014-08-13 17:57:21 28100 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-08-13 17:57:21 28100 [Note] InnoDB: The InnoDB memory heap is disabled
2014-08-13 17:57:21 28100 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-08-13 17:57:21 28100 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-08-13 17:57:21 28100 [Note] InnoDB: Using Linux native AIO
2014-08-13 17:57:21 28100 [Note] InnoDB: Using CPU crc32 instructions
2014-08-13 17:57:21 28100 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-08-13 17:57:21 28100 [Note] InnoDB: Completed initialization of buffer pool
2014-08-13 17:57:21 28100 [Note] InnoDB: Highest supported file format is Barracuda.
2014-08-13 17:57:21 28100 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1307954246
2014-08-13 17:57:21 28100 [Note] InnoDB: Database was not shutdown normally!
2014-08-13 17:57:21 28100 [Note] InnoDB: Starting crash recovery.
2014-08-13 17:57:21 28100 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-08-13 17:57:21 28100 [Note] InnoDB: Restoring possible half-written data pages
2014-08-13 17:57:21 28100 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1307959447
2014-08-13 17:57:21 28100 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
2014-08-13 17:57:22 28100 [Note] InnoDB: 128 rollback segment(s) are active.
2014-08-13 17:57:22 28100 [Note] InnoDB: Waiting for purge to start
2014-08-13 17:57:22 28100 [Note] InnoDB: 5.6.17 started; log sequence number 1307959447
2014-08-13 17:57:22 28100 [Note] Server hostname (bind-address): '*'; port: 3306
2014-08-13 17:57:22 28100 [Note] IPv6 is available.
2014-08-13 17:57:22 28100 [Note]   - '::' resolves to '::';
2014-08-13 17:57:22 28100 [Note] Server socket created on IP: '::'.
2014-08-13 17:57:22 28100 [Note] Event Scheduler: Loaded 0 events
2014-08-13 17:57:22 28100 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.17'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
140813 17:57:23 mysqld_safe Number of processes running now: 0
140813 17:57:23 mysqld_safe mysqld restarted
2014-08-13 17:57:24 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-08-13 17:57:24 28175 [Note] Plugin 'FEDERATED' is disabled.
2014-08-13 17:57:24 28175 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-08-13 17:57:24 28175 [Note] InnoDB: The InnoDB memory heap is disabled
2014-08-13 17:57:24 28175 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-08-13 17:57:24 28175 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-08-13 17:57:24 28175 [Note] InnoDB: Using Linux native AIO
2014-08-13 17:57:24 28175 [Note] InnoDB: Using CPU crc32 instructions
2014-08-13 17:57:24 28175 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-08-13 17:57:24 28175 [Note] InnoDB: Completed initialization of buffer pool
2014-08-13 17:57:24 28175 [Note] InnoDB: Highest supported file format is Barracuda.
2014-08-13 17:57:24 28175 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1307954246
2014-08-13 17:57:24 28175 [Note] InnoDB: Database was not shutdown normally!
2014-08-13 17:57:24 28175 [Note] InnoDB: Starting crash recovery.
2014-08-13 17:57:24 28175 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-08-13 17:57:24 28175 [Note] InnoDB: Restoring possible half-written data pages
2014-08-13 17:57:24 28175 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1307974563
140813 17:57:24 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.local.pid ended
140814 09:25:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2014-08-14 09:25:43 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-08-14 09:25:43 22422 [Note] Plugin 'FEDERATED' is disabled.
2014-08-14 09:25:43 22422 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-08-14 09:25:43 22422 [Note] InnoDB: The InnoDB memory heap is disabled
2014-08-14 09:25:43 22422 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-08-14 09:25:43 22422 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-08-14 09:25:43 22422 [Note] InnoDB: Using Linux native AIO
2014-08-14 09:25:43 22422 [Note] InnoDB: Using CPU crc32 instructions
2014-08-14 09:25:43 22422 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-08-14 09:25:43 22422 [Note] InnoDB: Completed initialization of buffer pool
2014-08-14 09:25:43 22422 [Note] InnoDB: Highest supported file format is Barracuda.
2014-08-14 09:25:43 22422 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1307954246
2014-08-14 09:25:43 22422 [Note] InnoDB: Database was not shutdown normally!
2014-08-14 09:25:43 22422 [Note] InnoDB: Starting crash recovery.
2014-08-14 09:25:43 22422 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-08-14 09:25:50 22422 [Note] InnoDB: Restoring possible half-written data pages
2014-08-14 09:25:50 22422 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1307974563
2014-08-14 09:25:51 22422 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 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 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
2014-08-14 09:25:52 22422 [Note] InnoDB: 128 rollback segment(s) are active.
2014-08-14 09:25:52 22422 [Note] InnoDB: Waiting for purge to start
2014-08-14 09:25:52 22422 [Note] InnoDB: 5.6.17 started; log sequence number 1307974563
2014-08-14 09:25:52 22422 [Note] Server hostname (bind-address): '*'; port: 3306
2014-08-14 09:25:52 22422 [Note] IPv6 is available.
2014-08-14 09:25:52 22422 [Note]   - '::' resolves to '::';
2014-08-14 09:25:52 22422 [Note] Server socket created on IP: '::'.
2014-08-14 09:25:53 22422 [Note] Event Scheduler: Loaded 0 events
2014-08-14 09:25:53 22422 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.17'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
mysql