Upgrade over 10 years php from 4.3 to 5.6

Transcript

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

   View Slide

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

   View Slide

3. 5PNPIJTB0EB!MJOZPXT
   

   View Slide

4. View Slide

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

   View Slide

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

   View Slide

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

   View Slide

8. ຊ൪ɿ͓ख੡ͷ̍୆
   

   View Slide

9. BQBDIFNPE@QIQ
   

   View Slide

10. QIQWʂ
    

    View Slide

11. '51ͰσϓϩΠʂʂ
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

15. View Slide

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

    View Slide

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

    View Slide

18. -#
    DVSSFOU OFX
    

    View Slide

19. -#
    DVSSFOU OFX OFX
    

    View Slide

20. -#
    DVSSFOU OFX OFX
    

    View Slide

21. LBHF΍EFMUB͸ʁ
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

27. ͞ɺ1)1ͷ͸ͳ͠
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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 |
    +-------------------------------------------+
    

    View Slide

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

    View Slide

36. View Slide

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

    View Slide

38. SFHJTUFS@HMPCBMTͱͷઓ͍
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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);
    + }
    

    View Slide

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

    View Slide

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

    View Slide

45. ͓ΘΓ
    UXJUUFS!MJOZPXT
    

    View Slide