| View previous topic :: View next topic |
| Author |
Message |
PrimeEvil
New User
Joined: 02 Nov 2007
Posts: 9
|
 Posted: Tue Apr 29, 2008 8:43 am Post subject: netflow.stats database full? |
 |
|
I've been running a CactiEZ (v0.1 I think) server for a couple of years now on a 10GB hard drive. I've had a few issues in the past where and mysql database corrupted and the cacti.log file fills all the remaining space on my hard drive. I ran out of HD space yesterday and so I check the cacti.log file and mysql databases. I've now got a couple of hundred megs of free space to tid me over for a short while. But when I ran my database check I got an error which is troubling me.
| Code: | mysql.user OK
netflow.stats
warning : Table is marked as crashed and last repair failed
warning : Datafile is almost full, 3921254372 of 4294967294 used
error : Record-count is not ok; is 21739122 Should be: 0
warning : Found 1328692940 deleted space. Should be 0
warning : Found 11179593 deleted blocks Should be: 0
warning : Found 32918730 parts Should be: 0 parts
error : Corrupt
syslog.syslog OK |
Is there some way to clean up the netflow.stats database?
*Update* - it appears this database is corrupt. But when I try to repair it I end up filling my hard drive. How do I rebuild this file?
|
|
| Back to top |
|
 |
jimmy
Site Admin
Joined: 11 Nov 2004
Posts: 1533
|
| Posted: Wed Apr 30, 2008 9:14 pm Post subject: |
|
|
| That error is from ntop, if you aren't using it, just remove it and you should be fine.
|
|
| Back to top |
|
|
PrimeEvil
New User
Joined: 02 Nov 2007
Posts: 9
|
| Posted: Wed Apr 30, 2008 9:18 pm Post subject: |
|
|
| Forgive me for being stupid. Remove ntop, the file, or both? This server was setup by somebody else. He's no longer with my company and I have inherited it. I think he was capturing netflows from our main router at some point. I still see the netflow commands on the router. I'm not sure what else he may have connected. How do I disable ntop?
|
|
| Back to top |
|
|
jimmy
Site Admin
Joined: 11 Nov 2004
Posts: 1533
|
| Posted: Wed Apr 30, 2008 9:21 pm Post subject: |
|
|
| PrimeEvil wrote: | | Forgive me for being stupid. Remove ntop, the file, or both? This server was setup by somebody else. He's no longer with my company and I have inherited it. I think he was capturing netflows from our main router at some point. I still see the netflow commands on the router. I'm not sure what else he may have connected. How do I disable ntop? |
service ntop stop
chkconfig ntop off
Then just delete the database. You can then just start it again, and it will recreate the database, or leave it off and it will not start up again if you reboot the server.
|
|
| Back to top |
|
|
PrimeEvil
New User
Joined: 02 Nov 2007
Posts: 9
|
| Posted: Thu May 01, 2008 7:30 am Post subject: |
|
|
| That's funny, NTOP isn't even running. It's only programmed to run under run level 5 which I'm not using.
|
|
| Back to top |
|
|
jimmy
Site Admin
Joined: 11 Nov 2004
Posts: 1533
|
| Posted: Thu May 01, 2008 11:00 pm Post subject: |
|
|
He must of installed something of his own on there then, as nothing else on there keeps a mysql database for netflow. Now that I think about it (I haven't ran ntop with netflow in years) Ntop actually uses a sqlite database not a mysql, so it can't be that either. You might just want to google the database name and see what pops up.
From the few searches I have done, he might have been running cflowd.
|
|
| Back to top |
|
|
|
FAQ
Search
Register
Profile
Log in
