Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Upgrade over 10 years php from 4.3 to 5.6

linyows
June 27, 2015

Upgrade over 10 years php from 4.3 to 5.6

linyows

June 27, 2015
Tweet

More Decks by linyows

Other Decks in Technology

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. View Slide

  10. QIQWʂ

    View Slide

  11. '51ͰσϓϩΠʂʂ

    View Slide

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

    View Slide

  13. ౰࣌ͷঢ়ଶ
    w ։ൃ؀ڥ͸Ұ୆ͷαʔόΛෳ਺ਓͰ࢖༻
    w ຊ൪͸͓ख੡ͷ̍୆αʔό
    w [email protected]
    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'[email protected]&/7EFWFMPQNFOU
    JG FSFHJ l XXXGPPDPN
    z FYFD bIPTUOBNF


    \
    JG HFUFOW b'[email protected]&/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

    [email protected]&SSPSHFU*OTUBODF

    [email protected]&SSPSHFU*OTUBODF

    GVODUJPOPQFO QBSTFS UBH BUUSJCVUFT
    \
    GVODUJPOPQFO QBSTFS UBH BUUSJCVUFT
    \

    View Slide

  30. [email protected]
    ͷҾ਺͕഑ྻҎ֎ͷ࣌ʹOVMMʹͳΔ
    [email protected] GPP CBS

    [email protected] BSSBZ
    GPP BSSBZ
    CBS

    View Slide

  31. ݺͼग़͢ϝιουͷҾ਺͕ࢀর౉͠ͷ৔߹ɺ8BSOJOHͱͳΔ
    GVODUJPOGPP.FUIPE BSH BSH

    [email protected]@GVOD bGPP.FUIPE` BSH BSH

    TXJUDI NFUIPE
    \
    DBTFbGPP.FUIPE`
    GPP.FUIPE BSH BSH

    View Slide

  32. w JOܥؔ਺͕࡟আ
    [email protected]@[email protected][FO
    Λ[email protected]@LBOB
    ʹஔ͖׵͑
    w [email protected]
    [email protected]
    ͕࡟আ

    @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. View Slide

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

    View Slide

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

    View Slide

  41. GTPDLFUPQFO΍[email protected]@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