-
Notifications
You must be signed in to change notification settings - Fork 1
/
informix-tables.nse
120 lines (105 loc) · 4.68 KB
/
informix-tables.nse
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
local informix = require "informix"
local nmap = require "nmap"
local shortport = require "shortport"
local stdnse = require "stdnse"
local table = require "table"
description = [[
Retrieves a list of tables and column definitions for each database on an Informix server.
]]
---
-- @usage
-- nmap -p 9088 <host> --script informix-tables --script-args informix-tables.username=informix,informix-tables.password=informix
--
-- @output
-- PORT STATE SERVICE REASON
-- 9088/tcp open unknown syn-ack
-- | informix-tables:
-- | Information
-- | User: informix
-- | Database: stores_demo
-- | Results
-- | table column rows
-- | call_type call_code 5
-- | call_type code_descr 5
-- | catalog cat_advert 74
-- | catalog cat_descr 74
-- | catalog cat_picture 74
-- | catalog catalog_num 74
-- | catalog manu_code 74
-- | catalog stock_num 74
-- | classes class 4
-- | classes classid 4
-- | classes subject 4
-- | cust_calls call_code 7
-- | cust_calls call_descr 7
-- | cust_calls call_dtime 7
-- | cust_calls customer_num 7
-- | cust_calls res_descr 7
-- | cust_calls res_dtime 7
-- | cust_calls user_id 7
-- | warehouses warehouse_id 4
-- | warehouses warehouse_name 4
-- |_ warehouses warehouse_spec 4
--
-- @args informix-query.username The username used for authentication
-- @args informix-query.password The password used for authentication
--
-- Version 0.1
-- Created 27/07/2010 - v0.1 - created by Patrik Karlsson <[email protected]>
author = "Patrik Karlsson"
license = "Same as Nmap--See http://nmap.org/book/man-legal.html"
categories = {"intrusive", "auth"}
dependencies = { "informix-brute" }
portrule = shortport.port_or_service( { 1526, 9088, 9090, 9092 }, "informix", "tcp", "open")
action = function( host, port )
local helper
local status, data
local result, output = {}, {}
local user = stdnse.get_script_args('informix-tables.username')
local pass = stdnse.get_script_args('informix-tables.password') or ""
local query= [[
SELECT cast(tabname as char(20)) table, cast(colname as char(20)) column, cast( cast(nrows as int) as char(20)) rows
FROM "informix".systables st, "informix".syscolumns sc
WHERE sc.tabid = st.tabid and st.tabid > 99 and st.tabtype='T'
ORDER BY table, column]]
local excluded_dbs = { ["sysmaster"] = true, ["sysutils"] = true, ["sysuser"] = true, ["sysadmin"] = true }
-- If no user was specified lookup the first user in the registry saved by
-- the informix-brute script
if ( not(user) ) then
if ( nmap.registry['informix-brute'] and nmap.registry['informix-brute'][1]["username"] ) then
user = nmap.registry['informix-brute'][1]["username"]
pass = nmap.registry['informix-brute'][1]["password"]
else
return " \n ERROR: No credentials specified (see informix-table.username and informix-table.password)"
end
end
helper = informix.Helper:new( host, port )
status, data = helper:Connect()
if ( not(status) ) then
return stdnse.format_output(status, data)
end
status, data = helper:Login(user, pass)
if ( not(status) ) then return stdnse.format_output(status, data) end
local databases
status, databases = helper:GetDatabases()
if ( not(status) ) then
return " \n ERROR: Failed to retrieve a list of databases"
end
for _, db in ipairs(databases) do
if ( not( excluded_dbs[db] ) ) then
status, data = helper:OpenDatabase(db)
if ( not(status) ) then return stdnse.format_output(status, data) end
status, data = helper:Query( query )
if ( not(status) ) then return stdnse.format_output(status, data) end
if ( status ) then
data = informix.Util.formatTable( data[1] )
data.name = "Results"
table.insert( result, { "User: " .. user, "Database: " .. db, name="Information" } )
table.insert(result, data )
end
break
end
end
helper:Close()
return stdnse.format_output( true, result )
end