Hi! (It took some time.. ) :) Hmm, everything looks alright here, exept that i don't get any data into my database.. ;)
ntop runs fine and also logs that it speaks to the mysql server. "21/Oct/2001:07:41:04 updateDbHostsTraffic(device=0) 21/Oct/2001:07:41:24 Purging Idle Hosts... (ignoreIdleTime=0, actDevice=0) 21/Oct/2001:07:41:24 Purging completed (0 sec/0 hosts deleted)." The mysql server machine logs that it speaks with the ntop box.. "Oct 21 07:29:41 junior kernel: Packet log: input ACCEPT eth0 PROTO=17 213.141.65.114:33003 213.141.78.2:4000 L=121 S=0x00 I=0 F=0x4000 T=62 (#6)" the perlprograms seems to work.. When I change the user and passwords and so to wrong ones, it complains, so I change back and it dosn't say anything. But.. mysql.log says nothing and there's no data in the database. What could I be doing wrong.. I am running ntop like this: (could the -P have something to do with it ??? ) ntop -b 213.141.78.2:4000 -N -P /home/ntop/ the perlscript, well not much arguments on that one.. Could the perlscript be caching the data and store it in the db only once in a while, or.. ?!?!? What do you think ?? I'll keep on trying here, if I comes up with anything I'll tell you .. :) / Paul > -----Ursprungligt meddelande----- > Fran: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]For Dim Segebart > Skickat: den 8 oktober 2001 14:01 > Till: Paul Wisen > Amne: Re: [Ntop] NTOP & MySQL > > > And don't forget to edit mySQLserver.pl > > my $dbh = DBI->connect('DBI:mysql:ntop','ntop','passwd')... > > Monday, October 08, 2001, 1:55:14 PM, you wrote: > > PW> Looks like NTOP is working better and better! :) > > PW> It would be so nice if I also could store the information in > my mysql dB. > PW> I saw that should be possible, just can't figure out the > "http-like host > PW> format".. > > PW> Has somebody done it ? > PW> Is there some example out there of how to do that? ( I guess I need a > PW> howto.. :) ) > > PW> somebody ? > > PW> -b > PW> Exports ntop traffic information into a SQL database. > The flag > PW> specifies (in http-like host format) the > PW> address (IP:port) of a SQL client. The database/ > directory part of > PW> ntop contains a few clients. Please use one > PW> of those. > > PW> / Paul > > > > >> -----Ursprungligt meddelande----- > >> Fran: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]For Dim Segebart > >> Skickat: den 1 oktober 2001 20:44 > >> Till: [EMAIL PROTECTED] > >> Amne: [Ntop] NTOP & MySQL > >> > >> > >> Hello ntop, > >> Today, while building the daily NTOP snapshot, I have noticed what > >> NTOP has some links to lmysqlclient. I just wonder what it is used for > >> ? AFAIK all DB related stuff performed now by so-called DBHelpers (I > >> use mySQLsever.pl with no problems) Is it a new undocumented feature > >> which'll allow to connect NTOP with MySQL directly or it was just > >> by chance. > >> > >> With best regards. > >> -- > >> Dim Segebart mailto:[EMAIL PROTECTED] > >> > >> > >> _______________________________________________ > >> Ntop mailing list > >> [EMAIL PROTECTED] > >> http://listmanager.unipi.it/mailman/listinfo/ntop > >> > > PW> _______________________________________________ > PW> Ntop mailing list > PW> [EMAIL PROTECTED] > PW> http://listmanager.unipi.it/mailman/listinfo/ntop > > > > -- > Dim Segebart mailto:[EMAIL PROTECTED] > > > _______________________________________________ > Ntop mailing list > [EMAIL PROTECTED] > http://listmanager.unipi.it/mailman/listinfo/ntop > _______________________________________________ Ntop mailing list [EMAIL PROTECTED] http://listmanager.unipi.it/mailman/listinfo/ntop
