Upgrade over 10 years php from 4.3 to 5.6

Transcript

1. ೥௒͑ΔαʔϏεͷ
   QIQόʔδϣϯΛ
   ͔Β࠷৽ʹ͢Δ࿩ !MJOZPXT
   
   1)1ΧϯϑΝϨϯε෱Ԭ
2. ΞδΣϯμ w ࣗݾ঺հ
   w ͋ΔαʔϏεͷ౰࣌ͷঢ়ଶ
   w ՝୊
   w ϩʔυϚοϓ
   w ֤ରԠʹ͍ͭͯ
   w ·ͱΊ
3. 5PNPIJTB
   0EB
   
   !MJOZPXT
5. (.0
   QFQBCP
   ٕज़ج൫νʔϜ
6. ೥Ҏ্ଓ͍͍ͯΔ
   ͋ΔαʔϏεͷ
   ౰࣌ͷঢ়ଶ
7. ։ൃ؀ڥɿ̍୆ΛαʔόΛෳ਺ਓͰ
8. ຊ൪ɿ͓ख੡ͷ̍୆
9. BQBDIF
   
   NPE@QIQ
10. QIQ
    Wʂ
11. '51ͰσϓϩΠʂʂ
12. ςετ͕ͳ͍
    
    ɹɹɹɹ͟Θ͟Θ
13. ౰࣌ͷঢ়ଶ w ։ൃ؀ڥ͸Ұ୆ͷαʔόΛෳ਺ਓͰ࢖༻
    w ຊ൪͸͓ख੡ͷ̍୆αʔό
    w BQBDIF
    
    NPE@QIQ
    w QIQͷόʔδϣϯ͸
    w '51ͰσϓϩΠ
    w ςετ͕ͳ͍
14. ՝୊ɿϨΨγʔ؀ڥΛ
    ͱ͜Ζ͔·Θͣվળ͢Δ
16. ৬ਓʹΑͬͯ
    ςετΛ͢Δ
17. ͦͯ͠
    ͪΐͬͱͣͭϦϦʔε
18. -# DVSSFOU OFX
19. -# DVSSFOU OFX OFX
20. -# DVSSFOU OFX OFX
21. LBHF΍EFMUB͸ʁ
22. ϩʔυϚοϓ w WBHSBOU؀ڥͷߏங
    w DBQJTUSBOPͰEFQMPZ
    w DIFGͰαʔόΛίʔυԽɺ৑௕ߏ੒Λͭ͘Δ
    w QIQͷόʔδϣϯΞοϓ
    w -#ʹ৽چ؀ڥΛϦϦʔε
    w چ؀ڥͷୀ໾
23. 7BHSBOU؀ڥΛͭ͘Δ IUUQEDPOG
    4FU&OW
    '00@&/7
    EFWFMPQNFOU
    
    
    JG
    FSFHJ l XXXGPPDPN z
    FYFD bIPTUOBNF \
    
    JG
    HFUFOW b'00@&/7`
    
    QSPEVDUJPO
    \
24. w ؀ڥґଘ෦෼͸ϑΝΠϧʹ·ͱΊΔ
    
    
    DPOpHFOWJSPONFOUTQSPEVDUJPOQIQ
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    EFWFMPQNFOUQIQ
    w ൿಗ৘ใ͸ҰͭͷϑΝΠϧʹ·ͱΊΔ
    DPOpHTFDSFUQIQ
25. $BQJTUSBOPͰσϓϩΠ w ຊ൪αʔόͱϦϙδτϦͷࠩҟΛνΣοΫ
    w DBQλεΫΛ࣮૷
    w DBQJTUSBOPXJUISTZOD
    w DBQJTUSBOPHJUIVCSFMFBTFT
    w DBQJTUSBOPJLBDIBO
    w όονΛόοναʔόʹҠઃ
26. $IFGͰXFCαʔόͭ͘Δ w DIFG
    W
    w LOJGFTPMP
    ͔Β
    LOJGF[FSP
    w QIQFOW
    w TFSWFSTQFD
    w ESPOFJP ࠷ॳ͸XFSDLFS࢖ͬͯͨ
    Ͱ
    DIFGͷ$*
27. ͞ɺ1)1ͷ͸ͳ͠
28. γϯλοΫεΤϥʔͷνΣοΫ
    GPS
    G
    JO
    ApOE
    
    UZQF
    G
    OBNF
     QIQA
    EP
    
    
    QIQ
    M
    G
    EPOF
    c
    HSFQ
    W
    /P
    TZOUBY
    FSSPST
29. TIBMMPX
    DPQZ
    ࡟আ
    
    
    
    
    
    GVODUJPO
    HFU*OTUBODF
    
    
    
    
    
    GVODUJPO
    HFU*OTUBODF
    
    
    
    
    
    UIJT@FSSPS
    
    &SSPSHFU*OTUBODF 
    
    
    
    
    
    UIJT@FSSPS
    
    &SSPSHFU*OTUBODF 
    
    
    
    
    
    GVODUJPO
    PQFO QBSTFS
    UBH
    BUUSJCVUFT \
    
    
    
    
    
    GVODUJPO
    PQFO QBSTFS
    UBH
    BUUSJCVUFT \
30. BSSBZ@NFSHF ͷҾ਺͕഑ྻҎ֎ͷ࣌ʹOVMMʹͳΔ
    
    BSSBZ@NFSHF GPP
    CBS 
    
    BSSBZ@NFSHF BSSBZ
    GPP
    BSSBZ
    CBS 
31. ݺͼग़͢ϝιουͷҾ਺͕ࢀর౉͠ͷ৔߹ɺ8BSOJOHͱͳΔ
    
    
    GVODUJPO
    GPP.FUIPE BSH
    BSH 
    
    DBMM@VTFS@GVOD bGPP.FUIPE`
    BSH
    BSH 
    
    
    TXJUDI
    NFUIPE
    \
    
    
    
    
    
    
    DBTF
    bGPP.FUIPE`
    
    
    
    
    
    
    
    
    
    
    GPP.FUIPE BSH
    BSH 
32. w JOܥؔ਺͕࡟আ
    JO@KB@KQ@IBOUP[FO
    Λ
    NC@DPOWFSU@LBOB
    ʹஔ͖׵͑
    w TFTTJPO@SFHJTUFS
    TFTTJPO@VOSFHJTUFS
    ͕࡟আ
    
    @4&44*0/୅ೖΛ࢖͍ɺVOTFU @4&44*0/ Λ࢖͏
33. .Z42-
    /BUJWF
    %SJWFSͩͱ
    NZTRMͷύεϫʔυ͸
    MPOH
    QBTTXPSEͰͳ͚Ε͹͍͚ͳ͍
34. 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 | +-------------------------------------------+
35. ＿人人人人人人人人人人人人人人人＿ ＞　突然のmysqlバージョンアップ　＜ ￣Y^Y^Y^Y^Y^Y^Y^Y^Y^Y^Y^Y^Y^Y￣
37. ͔͋ͨ΋஋͍࣋ͬͯ·͢งғؾ ͷม਺͕6OEFpOFE
    WBSJBCMF Λు͍͍ͯΔͷΛ໨ܸ͢Δ
38. SFHJTUFS@HMPCBMTͱͷઓ͍
39. w ม਺Λશ෦໨ࢹ֬ೝ͢Δͷ͸ແཧ
    w (&5΍1045Ͱ࢖͍ͬͯΔ΋ͷΛHSFQͯ͠ௐ΂ͨ
    
    QU
    a@(&5<
    c
    HSFQ
    a@(&5<<a>
    c
    TFE
    Ta @(&5<<a> <"[> <a>> a
    c
    TPSU
    c
    VOJR
    D
    c
    TPSU
    L
    
    OS
    c
    OM
40. QIQͰ࢖͍ͬͯͨͷ1&"3໰୊
    ϥΠϒϥϦ͸͢΂ͯϦϙδτϦʹಥͬࠐΜͰҰॹ ʹQIQରԠ
41. GTPDLFUPQFO΍pMF@HFU@DPOUFOUTͳͲͷετϦʔ Ϝܥͷؔ਺ͰTTM઀ଓ͢Δ৔߹ɺূ໌ॻΛਖ਼͘͠ݟ ΔΑ͏ʹͳ͍ͬͯΔ
    
    ূ໌ূΛങ͍·͠ΐ͏
42. - $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); + }
43. ·ͱΊ w ςετ͸ͪΌΜͱॻ͖·͠ΐ͏
    w ূ໌ॻ͸ങ͍·͠ΐ͏
    w ڊେϑϨʔϜϫʔΫ΍୔ࢁͷ֎෦ϥΠϒϥϦ࢖ͬͯͳ͔ͬ ͨͷ͕ٯʹྑ͔ͬͨͷ͔΋ʢQIQͳΜͰʜ
    w όʔδϣϯΞοϓ͸͜·Ίʹ΍Γ·͠ΐ͏
    w େ͖ͳվળ΋·ͨίετ͕͔͔ΔͷͰ೔ʑͷখ͞ͳश ׳͕େ੾
44. 
    
    
    
    એ఻ w ϖύϘͰ͸ΤϯδχΞΛืू͓ͯ͠Γ·͢ɻ
    w ڞʹαʔϏεΛੜΈग़͠ҭͯͯ͘ΕΔ৽͍͠஥ ؒΛ଴͍ͬͯ·͢ɻ
    w IUUQQFQBCPDPNSFDSVJUDBSFFS
45. ͓ΘΓ
    UXJUUFS
    !MJOZPXT