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 --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-tables.username The username used for authentication -- @args informix-tables.password The password used for authentication -- -- Version 0.1 -- Created 27/07/2010 - v0.1 - created by Patrik Karlsson author = "Patrik Karlsson" license = "Same as Nmap--See https://nmap.org/book/man-legal.html" categories = {"intrusive", "auth"} dependencies = { "informix-brute" } portrule = shortport.port_or_service( { 1526, 9088, 9090, 9092 }, "informix", "tcp", "open") local function fail (err) return stdnse.format_output(false, err) end action = function( host, port ) local helper local status, data local result, output = {}, {} local user = stdnse.get_script_args(SCRIPT_NAME .. '.username') local pass = stdnse.get_script_args(SCRIPT_NAME .. '.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 fail("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 fail("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