Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
Upgrade over 10 years php from 4.3 to 5.6
Search
Sponsored
·
SiteGround - Reliable hosting with speed, security, and support you can count on.
→
linyows
June 27, 2015
Technology
1.7k
4
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
Upgrade over 10 years php from 4.3 to 5.6
linyows
June 27, 2015
Transcript
45 slides
͑ΔαʔϏεͷ 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
More Decks by linyows
See All by linyows
GoとClickhouseで作るRAGアプリ / Building RAG Application with Go and Clickhouse
linyows
1
330
Kubernetesを使わない環境にもCloud Nativeなデプロイを実現する / Enabling Cloud Native deployments without the complexity of Kubernetes
linyows
3
980
Protocol Buffersの型を超えて拡張性を得る / Beyond Protocol Buffers Types Achieving Extensibility
linyows
0
330
研究開発と実装OSSと プロダクトの好循環 / A virtuous cycle of research and development implementation OSS and products
linyows
1
1k
コードジェネレーターで 効率的な開発をする / Efficient development with code generators
linyows
0
530
研究を支える拡張性の高い ワークフローツールの提案 / Proposal of highly expandable workflow tools to support research
linyows
0
780
非コンテナ環境において宣言的Deploymentを手軽に実現する / Declarative deployment in non-container environments
linyows
1
690
メール送信サーバの集約における透過型SMTP プロキシの定量評価 / Quantitative Evaluation of Transparent SMTP Proxy in Email Sending Server Aggregation
linyows
0
1.3k
透過型SMTPプロキシによる送信メールの可観測性向上: Update Edition / Improved observability of outgoing emails with transparent smtp proxy: Update edition
linyows
2
760
Other Decks in Technology
See All in Technology
3文字略語に騙されない! 世界一わかりやすい『EDR』超入門
kamadamakoto
1
190
Intro to Kiro (One agent, every surface) | Kiro: Zero to Hero 01
inariku
PRO
2
150
「任されビリティ」で引き受けて「よしなりてぃ」に頼らず任せる / Accept tasks with "makasarebility" and hand them over without relying on "yoshinarily"
pauli
1
700
【Oracle AI SPOTLIGHT ウェビナー】【特別開催:日本語で解説!】Oracle AI World 2026 最新情報フィードバック
oracle4engineer
PRO
1
240
Linuxネットワークスタック進化の軌跡: 過去10年の歩みと最新トレンド
orimanabu
4
730
農家は秘伝のタレを知らない - NOBODY KNOWS THE HIDDEN SOURCE - Kaggriculture 3rd Place Solution
masspeaks
1
410
OpenTelemetryで変わった 新時代のCloudWatchメトリクス監視
tsukuboshi
0
330
コピーオンライト型ファイルシステムと ランダム書き込み
sat
PRO
2
110
閉域網でのAPI公開の選択肢全部比較!
takano0131
2
340
並列度を下げたら速くなった — go build の重複コンパイルを実測で見る
tomoaki25
2
1.3k
Kiro CLI 入門 (ターミナルと CI で使う) | 目指せ Kiro マスター 03
inariku
PRO
2
160
DevOps Agentにあらゆるセキュリティインシデントのトリアージを任せた件
jirtosterone
1
170
Featured
See All Featured
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
38
3.1k
Intergalactic Javascript Robots from Outer Space
tanoku
273
28k
Tips & Tricks on How to Get Your First Job In Tech
honzajavorek
1
850
What Being in a Rock Band Can Teach Us About Real World SEO
427marketing
0
1.1k
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
46
3.1k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
333
23k
30 Presentation Tips
portentint
PRO
1
470
Tell your own story through comics
letsgokoyo
1
1.1k
Technical Leadership for Architectural Decision Making
baasie
4
650
Agile Leadership in an Agile Organization
kimpetersen
PRO
0
310
Gemini Prompt Engineering: Practical Techniques for Tangible AI Outcomes
mfonobong
2
640
We Are The Robots
honzajavorek
0
440