Hi, I want use nprobe to export oracle sql information, such as sql query, src ip,dot ip,oracle response string.
Now i use this command: nprobe -T "%IPV4_SRC_ADDR %IPV4_DST_ADDR %IPV4_NEXT_HOP %INPUT_SNMP > %OUTPUT_SNMP %IN_PKTS %IN_BYTES %FIRST_SWITCHED %LAST_SWITCHED > %L4_SRC_PORT %L4_DST_PORT %TCP_FLAGS %PROTOCOL %SRC_TOS %ORACLE_USERNAME %ORACLE_QUERY %ORACLE_RSP_CODE %ORACLE_RSP_STRING %ORACLE_QUERY_DURATION" -b 1 -i /nprobe/tcp_1521.pcap -a -P /nprobe/ -D t -V 10 But the output is this, the oracle_rsp_string is "no data found" or "ORA-06512: at "LOTTERY_DLC.SP_SJ_CHANGEACTIVEEXPECT", line 65 ORA-06512: at line 1" The sql query i execute is this: select * from test_table; And the output is: test aaa bbb I want use nprobe to export "test aaa bbb" How can i did it?
_______________________________________________ Ntop-misc mailing list [email protected] http://listgateway.unipi.it/mailman/listinfo/ntop-misc
