Jim, you need to send us a pcap with full packets for debugging the issue Luca
On 12/11/2013 04:25 AM, jim messi wrote: > 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
_______________________________________________ Ntop-misc mailing list [email protected] http://listgateway.unipi.it/mailman/listinfo/ntop-misc
