Hi,
I managed to start ntop with MySQL yesterday (after quite some
struggling, but it was on MySQL and Perl driver for MySQL side).
Now I get some errors from database/mySQLserver.pl
DBD::mysql::db do failed: parse error near ''20' at line 1 at
/home/on/cvsntop/ntop/database/mySQLserver.pl line 60.
DBD::mysql::db do failed: parse error near '' at line 1 at
/home/on/cvsntop/ntop/database/mySQLserver.pl line 60.
DBD::mysql::db do failed: parse error near '' at line 1 at
/home/on/cvsntop/ntop/database/mySQLserver.pl line 60.
DBD::mysql::db do failed: parse error near 'WHE' at line 1 at
/home/on/cvsntop/ntop/database/mySQLserver.pl line 60.
DBD::mysql::db do failed: parse error near '' at line 1 at
/home/on/cvsntop/ntop/database/mySQLserver.pl line 60.
DBD::mysql::db do failed: parse error near 'WHER' at line 1 at
/home/on/cvsntop/ntop/database/mySQLserver.pl line 60.
DBD::mysql::db do failed: parse error near '0, DataBroadcastSent = 0, LastSeen =
'2000-11-30 21:02:34' WHERE IPaddress = '64' at line 1 at
/home/on/cvsntop/ntop/database/mySQLserver.pl line 60.
DBD::mysql::db do failed: parse error near ' DataBroadcastSent = 0, LastSeen =
'2000-11-30 23:17:32' WHERE IPaddress = '207.' at line 1 at
/home/on/cvsntop/ntop/database/mySQLserver.pl line 60.
DBD::mysql::db do failed: parse error near ''208.191.209.49' at line 1 at
/home/on/cvsntop/ntop/database/mySQLserver.pl line 60.
DBD::mysql::db do failed: parse error near '' at line 1 at
/home/on/cvsntop/ntop/database/mySQLserver.pl line 60.
DBD::mysql::db do failed: parse error near '' at line 1 at
/home/on/cvsntop/ntop/database/mySQLserver.pl line 60.
and many more.
Other thing, in the casethe MySQL database is not located on the same
computer as ntop, I would rather run mySQLserver.pl on the ntop
machine after doing the following modification: on line DBI->connect
... DBI->connect('DBI:mysql:NTOP;host=your.host.with.mysql', 'databse_username',
'databe_password') od die ...
It allows TCP protocol between the 2 hosts while UDP traffic remains
local on ntop host (and could be something else than UDP actually).
Olivier
