All,

 

I am having a problem exporting flow data to a mysql database with flow export… When I run:

flow-export -d1 -f3 -m SRCADDR,DSTADDR -u "root:password:localhost:3306:Netflow_Data:8922" < ft-v05.2006-08-03.150000+0000

 

I get:

 flow-export: mysql_real_query(): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '8922(,srcaddr,dstaddr) VALUES ("10.136.49.13","170.116.17.31")'

field=,srcaddr,dstaddr

 val="162.48.101.91","64.236.24.20"

 query=INSERT INTO 8922(,srcaddr,dstaddr) VALUES ("162.48.101.91","64.236.24.20")

 

What’s up with the extra comma before srcaddr in the INSERT command? Is this why I can’t get the export to work? Has anyone run into this? Is there a work-around?

 

Thanks in advance!

 

_______________________________________________
Flow-tools mailing list
[EMAIL PROTECTED]
http://mailman.splintered.net/mailman/listinfo/flow-tools

Reply via email to