೥௒͑ΔαʔϏεͷ QIQόʔδϣϯΛ ͔Β࠷৽ʹ͢Δ࿩ !MJOZPXT1)1ΧϯϑΝϨϯε෱Ԭ

ΞδΣϯμ w ࣗݾ঺հ w ͋ΔαʔϏεͷ౰࣌ͷঢ়ଶ w ՝୊ w ϩʔυϚοϓ w ֤ରԠʹ͍ͭͯ w ·ͱΊ

5PNPIJTB0EB!MJOZPXT

No content

(.0QFQBCPٕज़ج൫νʔϜ

೥Ҏ্ଓ͍͍ͯΔ ͋ΔαʔϏεͷ ౰࣌ͷঢ়ଶ

։ൃ؀ڥɿ̍୆ΛαʔόΛෳ਺ਓͰ

ຊ൪ɿ͓ख੡ͷ̍୆

BQBDIFNPE@QIQ

QIQWʂ

'51ͰσϓϩΠʂʂ

ςετ͕ͳ͍ ɹɹɹɹ͟Θ͟Θ

౰࣌ͷঢ়ଶ w ։ൃ؀ڥ͸Ұ୆ͷαʔόΛෳ਺ਓͰ࢖༻ w ຊ൪͸͓ख੡ͷ̍୆αʔό w BQBDIFNPE@QIQ w QIQͷόʔδϣϯ͸ w '51ͰσϓϩΠ w ςετ͕ͳ͍

՝୊ɿϨΨγʔ؀ڥΛ ͱ͜Ζ͔·Θͣվળ͢Δ

No content

৬ਓʹΑͬͯ ςετΛ͢Δ

ͦͯ͠ ͪΐͬͱͣͭϦϦʔε

-# DVSSFOU OFX

-# DVSSFOU OFX OFX

-# DVSSFOU OFX OFX

LBHF΍EFMUB͸ʁ

ϩʔυϚοϓ w WBHSBOU؀ڥͷߏங w DBQJTUSBOPͰEFQMPZ w DIFGͰαʔόΛίʔυԽɺ৑௕ߏ੒Λͭ͘Δ w QIQͷόʔδϣϯΞοϓ w -#ʹ৽چ؀ڥΛϦϦʔε w چ؀ڥͷୀ໾

7BHSBOU؀ڥΛͭ͘Δ IUUQEDPOG 4FU&OW'00@&/7EFWFMPQNFOU JG FSFHJ l XXXGPPDPN z FYFD bIPTUOBNF \ JG HFUFOW b'00@&/7` QSPEVDUJPO \

w ؀ڥґଘ෦෼͸ϑΝΠϧʹ·ͱΊΔ DPOpHFOWJSPONFOUTQSPEVDUJPOQIQ EFWFMPQNFOUQIQ w ൿಗ৘ใ͸ҰͭͷϑΝΠϧʹ·ͱΊΔ DPOpHTFDSFUQIQ

$BQJTUSBOPͰσϓϩΠ w ຊ൪αʔόͱϦϙδτϦͷࠩҟΛνΣοΫ w DBQλεΫΛ࣮૷ w DBQJTUSBOPXJUISTZOD w DBQJTUSBOPHJUIVCSFMFBTFT w DBQJTUSBOPJLBDIBO w όονΛόοναʔόʹҠઃ

$IFGͰXFCαʔόͭ͘Δ w DIFGW w LOJGFTPMP͔ΒLOJGF[FSP w QIQFOW w TFSWFSTQFD w ESPOFJP ࠷ॳ͸XFSDLFS࢖ͬͯͨ ͰDIFGͷ$*

͞ɺ1)1ͷ͸ͳ͠

γϯλοΫεΤϥʔͷνΣοΫ GPSGJOApOEUZQFGOBNFQIQAEP QIQMG EPOFcHSFQW/PTZOUBYFSSPST

TIBMMPXDPQZ࡟আ GVODUJPOHFU*OTUBODF GVODUJPOHFU*OTUBODF UIJT@FSSPS&SSPSHFU*OTUBODF UIJT@FSSPS&SSPSHFU*OTUBODF GVODUJPOPQFO QBSTFS UBH BUUSJCVUFT \ GVODUJPOPQFO QBSTFS UBH BUUSJCVUFT \

BSSBZ@NFSHF ͷҾ਺͕഑ྻҎ֎ͷ࣌ʹOVMMʹͳΔ BSSBZ@NFSHF GPP CBS BSSBZ@NFSHF BSSBZ GPP BSSBZ CBS

ݺͼग़͢ϝιουͷҾ਺͕ࢀর౉͠ͷ৔߹ɺ8BSOJOHͱͳΔ GVODUJPOGPP.FUIPE BSH BSH DBMM@VTFS@GVOD bGPP.FUIPE` BSH BSH TXJUDI NFUIPE \ DBTFbGPP.FUIPE` GPP.FUIPE BSH BSH

w JOܥؔ਺͕࡟আ JO@KB@KQ@IBOUP[FO ΛNC@DPOWFSU@LBOB ʹஔ͖׵͑ w TFTTJPO@SFHJTUFS TFTTJPO@VOSFHJTUFS ͕࡟আ @4&44*0/୅ೖΛ࢖͍ɺVOTFU @4&44*0/ Λ࢖͏

.Z42-/BUJWF%SJWFSͩͱ NZTRMͷύεϫʔυ͸ MPOHQBTTXPSEͰͳ͚Ε͹͍͚ͳ͍

mysql> SELECT PASSWORD('mypass'); +--------------------+ | PASSWORD('mypass') | +--------------------+ | 6f8c114b58f2ce9e | +——————————+ mysql> SET @@session.old_passwords = 0; Query OK, 0 rows affected (0.00 sec) mysql> SELECT PASSWORD('mypass'); +-------------------------------------------+ | PASSWORD('mypass') | +-------------------------------------------+ | *6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4 | +-------------------------------------------+

＿人人人人人人人人人人人人人人人＿ ＞　突然のmysqlバージョンアップ　＜ ￣Y^Y^Y^Y^Y^Y^Y^Y^Y^Y^Y^Y^Y^Y￣

No content

͔͋ͨ΋஋͍࣋ͬͯ·͢งғؾ ͷม਺͕6OEFpOFEWBSJBCMF Λు͍͍ͯΔͷΛ໨ܸ͢Δ

SFHJTUFS@HMPCBMTͱͷઓ͍

w ม਺Λશ෦໨ࢹ֬ೝ͢Δͷ͸ແཧ w (&5΍1045Ͱ࢖͍ͬͯΔ΋ͷΛHSFQͯ͠ௐ΂ͨ QUa@(&5<cHSFQa@(&5<cTFETa @(&5< <"[> >acTPSUcVOJRDc TPSULOScOM

QIQͰ࢖͍ͬͯͨͷ1&"3໰୊ ϥΠϒϥϦ͸͢΂ͯϦϙδτϦʹಥͬࠐΜͰҰॹ ʹQIQରԠ

GTPDLFUPQFO΍pMF@HFU@DPOUFOUTͳͲͷετϦʔ Ϝܥͷؔ਺ͰTTM઀ଓ͢Δ৔߹ɺূ໌ॻΛਖ਼͘͠ݟ ΔΑ͏ʹͳ͍ͬͯΔ ূ໌ূΛങ͍·͠ΐ͏

- $fp = @$openfunc($this->addr, $this->port, $errno, $errstr, $timeout); + if (in_array($this->port, array(443, 8443, 9443))) { + $context = stream_context_create(); + stream_context_set_option($context, 'ssl', 'verify_peer', false); + stream_context_set_option($context, 'ssl', 'verify_host', false); + stream_context_set_option($context, 'ssl', 'allow_self_signed', true); + $fp = stream_socket_client($this->addr . ':' . $this->port, + $errno, $errstr, $timeout, STREAM_CLIENT_CONNECT, $context); + } else { + $fp = @$openfunc($this->addr, $this->port, $errno, $errstr, $timeout); + }

·ͱΊ w ςετ͸ͪΌΜͱॻ͖·͠ΐ͏ w ূ໌ॻ͸ങ͍·͠ΐ͏ w ڊେϑϨʔϜϫʔΫ΍୔ࢁͷ֎෦ϥΠϒϥϦ࢖ͬͯͳ͔ͬ ͨͷ͕ٯʹྑ͔ͬͨͷ͔΋ʢQIQͳΜͰʜ w όʔδϣϯΞοϓ͸͜·Ίʹ΍Γ·͠ΐ͏ w େ͖ͳվળ΋·ͨίετ͕͔͔ΔͷͰ೔ʑͷখ͞ͳश ׳͕େ੾

એ఻ w ϖύϘͰ͸ΤϯδχΞΛืू͓ͯ͠Γ·͢ɻ w ڞʹαʔϏεΛੜΈग़͠ҭͯͯ͘ΕΔ৽͍͠஥ ؒΛ଴͍ͬͯ·͢ɻ w IUUQQFQBCPDPNSFDSVJUDBSFFS

͓ΘΓ UXJUUFS!MJOZPXT