FileMaker Server 17の新機能と改善点

FileMaker Server 17ͷ ৽‫ػ‬ೳͱվળ఺ 2018/06/14 INTER-Mediatorษ‫ڧ‬ձ2018-#4 দඌಞʢ‫ࣜג‬ձࣾΤϛοΫʣ

Agenda • FileMaker ServerͱINTER-Mediator • FileMaker Server 17ͷ৽‫ػ‬ೳͱվળ఺ • FileMaker Server 17ͷมߋ఺

FileMaker Serverͱ INTER-Mediator

FileMaker Server

FileMaker Server • FileMakerϕʔεͷΧελϜ AppͰσʔλ Λ‫ڞ‬༗͢ΔͨΊʹ࢖༻͞ΕΔαʔόʔ ιϑτ΢ΣΞ • όοΫΞοϓ‫ػ‬ೳΛඪ४౥ࡌ • SSL/TLSʹରԠɺOAuthɺOpen Directory ͓ΑͼActive DirectoryΛ࢖༻ͨ͠ೝূ ΍Webެ։‫ػ‬ೳ౳΋ར༻Մೳ

͞·͟·ͳ‫ڞ‬༗ํ๏ • FileMaker ProʗFileMaker GoͰ઀ଓ • Webϒϥ΢βʔͰ઀ଓ • ODBCʗJDBC‫ܦ‬༝Ͱ

INTER-Mediator • INTER-Mediator͸‫ࡏݱ‬FileMaker Serverͷ CWPʢΧελϜWebެ։ʣΛ࢖༻ • FileMaker Server 17Ͱ΋CWP͸Ҿ͖ଓ ͖ར༻Մೳ • CWP͸fmsadminίϚϯυͰ༗ޮԽ

ΧελϜWebͷ༗ޮԽ • fmsadmin enable wpe • fmsadmin start wpe • fmsadmin set cwpconfig enablephp=true • fmsadmin set cwpconfig enablexml=true • fmsadmin restart httpserver -y

mbstringͷ༗ޮԽ • Windows ServerͰ͸php.iniΛฤू‫ʹޙ‬IIS Λ࠶‫ى‬ಈ • ʦมߋલʧ;extension=php_mbstring.dll • ʦมߋ‫ޙ‬ʧextension=php_mbstring.dll • http://inter-mediator.info/ja/for-developers/ db.html

• http://inter-mediator.info/ja/for-developers/db.html

FileMaker Server 17 ͷ৽‫ػ‬ೳͱվળ఺

࡮৽͞ΕͨAdmin Console

FileMaker Data API͕ਖ਼ࣜ൛ʹ • FileMaker Server 16Ͱ͸τϥΠΞϧ൛Ͱ ͋ͬͨFileMaker Data API͕ਖ਼ࣜ൛ʹ • 1ϥΠηϯε͋ͨΓ೥ؒ24GBόϯυϧ • ྫɿ5ϢʔβϥΠηϯεͷ৔߹͸೥ؒ 120GB·Ͱར༻Մೳʢ௥ՃߪೖՄʣ

FileMaker Data APIͷ‫ػ‬ೳ‫ڧ‬Խ • ΦϒδΣΫτϑΟʔϧυ΁ͷϑΝΠϧͷ ΞοϓϩʔυΛαϙʔτ • FileMakerεΫϦϓτͷ࣮ߦΛαϙʔτ • layout.responseҾ਺Λ࢖༻ͯ݁͠ՌϨΠ Ξ΢τΛࢦఆͰ͖ΔΑ͏ʹ

όοΫΞοϓΦϓγϣϯͷ௥Ճ • Admin ConsoleͰʦࠓ͙͢όοΫΞο ϓʧ΋͘͠͸ʦόοΫΞοϓΛอଘʧ ΛΫϦοΫ͢ΔͱอଘࡁΈόοΫΞο ϓʹ • อଘࡁΈόοΫΞοϓ͸ࣗಈతʹ࡟ আ͞Εͳ͍

όοΫΞοϓΦϓγϣϯͷ௥Ճ

ηΩϡΞσʔλϕʔεϑΥϧμ • ύεϫʔυͰอ‫߸҉͔ͭޢ‬Խ͞ΕͨϑΝ ΠϧͷΈΛϗετ͢ΔͨΊͷઐ༻ϑΥ ϧμ͕৽ઃ • ϑΥϧμ໊ɿSecure • ҉߸Խ͞Ε͍ͯͳ͍ϑΝΠϧΛΞοϓ ϩʔυͨ͠Γϗετ͢Δ͜ͱ͸ෆՄ

ΞΧ΢ϯτͷϩοΫΞ΢τ • ‫ڞ‬༗ϑΝΠϧ΁ͷαΠϯΠϯΛࢼߦ͠ ͯ਺෼Ҏ಺ʹෳ਺ճࣦഊ͢ΔͱҰ࣌త ʹΞΧ΢ϯτ͕ϩοΫ͞ΕΔ • ૯౰ͨΓ߈ܸ΍ࣙॻ߈ܸ͔ΒΧελ ϜAppΛอ‫ޢ‬

৽͍͠௨஌Φϓγϣϯ • Admin Console ௨஌ • ʦαΠϯΞ΢τʧͷࠨʹ͋ΔϘλϯ Ͱ֬ೝͰ͖Δ

৽͍͠௨஌Φϓγϣϯ • ϩʔΧϧ௨஌ • Admin ConsoleΛ࣮ߦ͍ͯ͠ΔϚγϯ ্Ͱදࣔ͞ΕΔ

fmsadminίϚϯυͷ ৽͍͠ίϚϯυ • fmsadmin get • fmsadmin get cwpconfig • fmsadmin get serverconfig • fmsadmin set

fmsadminίϚϯυͷ ৽͍͠Φϓγϣϯ • Stats.logؔ࿈ • fmsadmin enable serverstats • fmsadmin disable serverstats

FileMaker Admin API (Trial) • FileMaker ServerΛ؅ཧ͢ΔͨΊͷREST ϕʔεͷAPIΛτϥΠΞϧ൛ͱͯ͠ఏ‫ڙ‬ • τϥΠΞϧ‫ؒظ‬͸2019೥9݄27೔·Ͱ

FileMaker Server 17 ͷมߋ఺

ϘϦϡʔϜϥΠηϯε • ϘϦϡʔϜϥΠηϯε͸ҎԼͷ3छྨʹ • FileMaker ϢʔβϥΠηϯε • FileMaker ಉ࣌઀ଓϥΠηϯε • FileMaker αΠτϥΠηϯε

FileMaker ϢʔβϥΠηϯε • FileMaker ServerΛ3୆ΠϯετʔϧՄೳ • ೥ؒϥΠηϯεͰ͋Ε͹3୆ͷ͏ͪ1୆ ΛFileMaker CloudʹBYOLͱͯ࣋ͪ͠ ࠐΈՄೳ

γεςϜ৚݅ͷมߋ఺ • Windows Server 2008 R2 SP1 Standard Edition͓ΑͼEnterprise Edition͸αϙʔ τର৅֎ • OS X El Capitan v10.11͸αϙʔτର৅֎

ΫϥΠΞϯτͱͷ‫׵ޓ‬ੑ • FileMaker ProɺFileMaker Pro Advanced͓ ΑͼFileMaker Goͷόʔδϣϯ14͔Β FileMaker Server 17ʹ͸઀ଓෆՄ

ల։Ξγελϯτ͕ෆཁʹ • Πϯετʔϥʔͱల։Ξγελϯτ͕ ౷߹ • Admin ConsoleॳճϩάΠϯ࣌ʹSSLαʔ όʔূ໌ॻΛΠϯϙʔτ͢Δ͔SSLΛ࢖ ༻͠ͳ͍͔ͷ֬ೝϖʔδ͕දࣔ͞ΕΔ

ల։Ξγελϯτ͕ෆཁʹ

SSL/TLSؔ࿈ͷมߋ఺ • SSLར༻࣌ʹHSTSʢHTTP Strict Transport Securityʣ͕ৗʹ༗ޮʹ • ʦWeb ΫϥΠΞϯτʹ HSTS Λ࢖༻ ͢ΔʧΦϓγϣϯ͸ഇࢭ

fmsadminίϚϯυΛ࢖༻ ʢAdmin Console͔ΒऔΓআ͔Εͨઃఆɾ‫ػ‬ೳʣ • ΧελϜWebެ։‫ػ‬ೳͷ༗ޮɾແޮԽ • fmsadmin set cwpconfig

fmsadminίϚϯυΛ࢖༻ ʢAdmin Console͔ΒऔΓআ͔Εͨઃఆɾ‫ػ‬ೳʣ • ύεϫʔυͰอ‫͞ޢ‬Εͨσʔλϕʔε ͷΈϗετ • ϩάϑΝΠϧͷαΠζ੍‫ݶ‬ • αʔόʔͷ࢖༻ঢ়‫گ‬ϩάϑΝΠϧ ʢStats.logʣͷอଘ

fmsadminίϚϯυΛ࢖༻ ʢAdmin Console͔ΒऔΓআ͔Εͨઃఆɾ‫ػ‬ೳʣ • FileMaker ProΫϥΠΞϯτ઀ଓͷ࠷େ਺ • εΫϦϓτಉ࣌ηογϣϯ࠷େ਺ • CSRͷ࡞੒ʢSSLαʔόʔূ໌ॻͷൃߦ खଓ͖ʹඞཁʣ

fmsadminίϚϯυΛ࢖༻ ʢAdmin Console͔ΒऔΓআ͔Εͨઃఆɾ‫ػ‬ೳʣ • ࢖༻ঢ়‫گ‬ͷऩूִؒ • σʔλϕʔεΩϟογϡʹ༧໿͞Ε͍ͯ ΔRAM • ϓϩάϨογϒόοΫΞοϓͷอଘؒ ִ

ഇࢭ͞Εͨ‫ػ‬ೳ • ελϯόΠαʔόʔ • ؅ཧऀάϧʔϓʢAdmin Consoleʣ • ୅ସϙʔτ൪߸ͷࢦఆ

ഇࢭ͞Εͨ‫ػ‬ೳ • ϥϯλΠϜιϦϡʔγϣϯ༻ϑΝΠϧ ֦ுࢠͷࢦఆʢAdmin Consoleʣ • ςΫϊϩδʔςετϖʔδ

fmsadminίϚϯυͰ࡟আ͞Εͨ ίϚϯυͱΦϓγϣϯ • fmsadmin standby • -j (--hint) • fmsadmin resetpwͷΦϓγϣϯ

ͦͷଞͷมߋ఺ • ৄࡉ͸FileMaker φϨοδϕʔεΛࢀর FileMaker 17 ϓϥοτϑΥʔϜͷͦͷଞ ͷมߋ <https://support.filemaker.com/s/ answerview?language=ja&anum=000026010>

• https://support.filemaker.com/s/answerview?language=ja&amp;anum=000026010

·ͱΊ

ؔ࿈URL • FileMaker Server 17 ϔϧϓ https://fmhelp.filemaker.com/help/17/fms/ja/

• https://fmhelp.filemaker.com/help/17/fms/ja/

ؔ࿈URL • FileMaker ϓϩμΫτ υΩϡϝϯςʔγϣϯ https://www.filemaker.com/jp/support/product/ documentation.html • FileMaker φϨοδϕʔε https://support.filemaker.com/s/?language=ja

• https://www.filemaker.com/jp/support/product/documentation.html
• https://support.filemaker.com/s/?language=ja

ؔ࿈URL • ϑΝΠϧϝʔΧʔࣾYouTubeެࣜνϟϯωϧ https://www.youtube.com/user/filemakerjapan

• https://www.youtube.com/user/filemakerjapan

·ͱΊ • FileMaker Server 17Ͱ΋ΧελϜWeb ެ։‫ػ‬ೳ͸Ҿ͖ଓ͖ར༻Մೳ • INTER-Mediator͸FileMaker Server 17Λ αϙʔτʢCWPΛ࢖༻ʣ • INTER-Mediator͸কདྷͷόʔδϣϯͰ ਖ਼ࣜ൛ͷFileMaker Data APIʹରԠ༧ఆ