Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Speaker Deck
PRO
Sign in
Sign up for free
Upgrade over 10 years php from 4.3 to 5.6
linyows
June 27, 2015
Technology
4
940
Upgrade over 10 years php from 4.3 to 5.6
linyows
June 27, 2015
Tweet
Share
More Decks by linyows
See All by linyows
Denoの仕組み / How deno works as TypeScript runtime
linyows
1
270
透過型SMTPプロキシによるメール送信集約とキュー輻輳回避の検討 / A Study on Aggregation of Email Transfer and Avoidance of QueueCongestion using a Transparent SMTP Proxy
linyows
0
1.1k
Goでつくる透過型SMTPプロキシ / Transparent SMTP proxy in Go
linyows
1
350
Goでサーバの健全性を確保する / Keeping servers healthy with Go
linyows
0
1.1k
なぜNotionを使うのか / Why use notion as our workspace
linyows
4
820
みんなのIMAPを可視化する / Visualize IMAP Everybody
linyows
2
300
CockroachDBって何 / What is CockroachDB
linyows
1
280
TypeScript v3.7のおさらい / Learning TypeScript v3.7
linyows
0
130
Edge Computing with Rust and WebAssembly / RustとWebAssemblyでEdge Computing
linyows
0
490
Other Decks in Technology
See All in Technology
2022年度新卒技術研修「良いコードの書き方」講義
excitejp
PRO
0
230
オンラインでのサーバー切替事例紹介/ColoplTech-05-01
colopl
0
160
JFrog 最新情報 - JFrog DevOps プラットフォームの今までとこれから / jfrog-update-for-devopskaigi-2022
tsuyo
0
140
要約 "Add Live Text interaction to your app"
ushisantoasobu
0
130
1人目SETとして入社して2ヶ月の間におこなったこと
tarappo
3
400
誰が正解を知っているのか / Who knows the right answer
takaking22
1
220
複数のスクラムチームをサポートするエンジニアリングマネジメントの話
okeicalm
0
940
CADDi AI LabにおけるマネージドなMLOps
vaaaaanquish
2
1.4k
組織の崩壊と再生、その中で何を考え、感じたのか。 そして本当に必要だったもの
kosako
0
960
スクラムのスケールとチームトポロジー / Scaled Scrum and Team Topologies
daiksy
1
400
インタラクティブなメディアの地図投影法: WebメルカトルからAdaptive Projectionsへ / MIERUNE 社内勉強会 #033
sorami
2
210
UWBを使ってみた
norioikedo
0
380
Featured
See All Featured
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
4
500
Designing the Hi-DPI Web
ddemaree
272
32k
Raft: Consensus for Rubyists
vanstee
126
5.4k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
19
1.4k
The Pragmatic Product Professional
lauravandoore
19
2.9k
KATA
mclloyd
7
8.7k
It's Worth the Effort
3n
172
25k
The Invisible Side of Design
smashingmag
290
48k
Statistics for Hackers
jakevdp
781
210k
The World Runs on Bad Software
bkeepers
PRO
57
5.3k
Designing with Data
zakiwarfel
91
3.9k
Optimizing for Happiness
mojombo
365
63k
Transcript
͑ΔαʔϏεͷ QIQόʔδϣϯΛ ͔Β࠷৽ʹ͢Δ !MJOZPXT1)1ΧϯϑΝϨϯεԬ
ΞδΣϯμ w ࣗݾհ w ͋ΔαʔϏεͷ࣌ͷঢ়ଶ w ՝ w ϩʔυϚοϓ w
֤ରԠʹ͍ͭͯ w ·ͱΊ
5PNPIJTB0EB!MJOZPXT
None
(.0QFQBCPٕज़ج൫νʔϜ
Ҏ্ଓ͍͍ͯΔ ͋ΔαʔϏεͷ ࣌ͷঢ়ଶ
։ൃڥɿ̍ΛαʔόΛෳਓͰ
ຊ൪ɿ͓खͷ̍
BQBDIF NPE@QIQ
QIQWʂ
'51ͰσϓϩΠʂʂ
ςετ͕ͳ͍ ɹɹɹɹ͟Θ͟Θ
࣌ͷঢ়ଶ w ։ൃڥҰͷαʔόΛෳਓͰ༻ w ຊ൪͓खͷ̍αʔό w BQBDIF NPE@QIQ w QIQͷόʔδϣϯ
w '51ͰσϓϩΠ w ςετ͕ͳ͍
՝ɿϨΨγʔڥΛ ͱ͜Ζ͔·Θͣվળ͢Δ
None
৬ਓʹΑͬͯ ςετΛ͢Δ
ͦͯ͠ ͪΐͬͱͣͭϦϦʔε
-# DVSSFOU OFX
-# DVSSFOU OFX OFX
-# DVSSFOU OFX OFX
LBHFEFMUBʁ
ϩʔυϚοϓ 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ͷͳ͠
γϯλοΫεΤϥʔͷνΣοΫ GPSGJOApOEUZQFGOBNF QIQAEP 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 ̄
None
͔͍͋ͨ࣋ͬͯ·͢งғؾ ͷม͕6OEFpOFEWBSJBCMF Λు͍͍ͯΔͷΛܸ͢Δ
SFHJTUFS@HMPCBMTͱͷઓ͍
w มΛશ෦ࢹ֬ೝ͢Δͷແཧ w (&51045Ͱ͍ͬͯΔͷΛHSFQͯ͠ௐͨ QUa@(&5<cHSFQa@(&5<<a>cTFETa @(&5<<a> <"[> <a>> acTPSUcVOJRDc TPSULOScOM
QIQͰ͍ͬͯͨͷ1&"3 ϥΠϒϥϦͯ͢ϦϙδτϦʹಥͬࠐΜͰҰॹ ʹQIQରԠ
GTPDLFUPQFOpMF@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