Changes to how cxtracker.pl stores sessions in MySQL

gamelinux / cxtracker

Connection Tracker is a passive network connection tracker for profiling, history, auditing and network discovery.

http://www.gamelinux.org/

46 stars 24 forks source link

Changes to how cxtracker.pl stores sessions in MySQL #14

Open gamelinux opened 11 years ago

gamelinux commented 11 years ago

Change from using:

MERGE and MyISAM to VIEW and InnoDB

wmesser commented 11 years ago

See patchfile in Issue https://github.com/gamelinux/cxtracker/issues/13

wmesser commented 11 years ago

DBD::mysql::st execute failed: Column 'sid' in field list is ambiguous at bin/cxtracker2db.pl line 684, <FILE> line 1.

I think we only get this when having multiple tables. It's got to be something I did wrong in the way the VIEW is created.

Putting it here for easier tracking for the time being.

wmesser commented 11 years ago

This may be a stupid question, but where is that value of 'sid' even coming from? It's not in the stats files. We already have a session ID. Is sid just the hostname? If so, it is definitely not supposed to be numeric.

wmesser commented 11 years ago

I changed it to VARCHAR(255), and it's at least logging the hostname correctly, but it's still 'ambiguous' and bug persists.