Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #21  
Old 26th December 2010, 16:43
macross macross is offline
Junior Member
 
Join Date: Dec 2010
Posts: 24
Thanks: 2
Thanked 0 Times in 0 Posts
Smile

First thanks so much it runs great and your support was invaluable. I will be supporting the site and coming back much more often thanks to this experience.


Last thing for my mail server. My fuzzyclean mysql process runs at 100% I have verified the correct settings are in /usr/sbin/fuzzy-cleanmysql. Any ideas what could be causing the cpu usage. Have you seen this before? How long does the process usually run?
Reply With Quote
Sponsored Links
  #22  
Old 4th March 2011, 00:08
atran atran is offline
Junior Member
 
Join Date: Feb 2011
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i just did a clean install and my "/usr/sbin/fuzzy-cleanmysql" job also run at near 100% CPU.
i already checked the username/pass.
could you please help me with this?

btw. very nice howto, everything works at first attempt except the fuzzy-clean stuff.
Reply With Quote
  #23  
Old 4th March 2011, 02:40
Rocky Rocky is offline
Senior Member
 
Join Date: Oct 2005
Posts: 553
Thanks: 14
Thanked 49 Times in 48 Posts
Default

Hey,

When did you do the actual installation? I recently updated the fuzzy clean script, so you might want to give it another shot.

Let me know how it works out.

Thanks

Rocky
__________________
Home of the SpamSnake
Reply With Quote
  #24  
Old 4th March 2011, 10:52
atran atran is offline
Junior Member
 
Join Date: Feb 2011
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hey Rocky,

i just copied your new code from the howto and changed the username/password variables.

started the script with --verbose but it still hangs at 100% cpu. simultaneously doing "show processlist;" in mysql doesn't show the fuzzyocr user connecting.

manually connection with the username/pwd to mysql seems to be OK:
mysql -ufuzzyocr -p*password*

maybe a perl-DBI problem? how can i simply debug this.
Reply With Quote
  #25  
Old 18th May 2011, 16:35
atran atran is offline
Junior Member
 
Join Date: Feb 2011
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default fixed

found this post on the howto:

Quote:
fuzzy-cleanmysql bug?
Submitted by John M (not registered) on Wed, 2011-04-06 19:40.

The /usr/sbin/fuzzy-cleanmysql didn't work for my until I changed the following line
while () {
to
while(<CONFIG>) {
A nasty infinite loop occurs otherwise.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Exim Gateway with mailwatch (Unable to receive emails) siul0_0 HOWTO-Related Questions 10 9th May 2009 00:00
Loads of mysql connections to dbispconfig StrikerNL General 2 5th March 2009 15:31
Perfect SpamSnake - Emails Stuck in MailScanner Incomming queue teixeira HOWTO-Related Questions 2 4th December 2008 03:49
Ubuntu 8.04 Spamsnake - all SA scores 0.00 Thomas_Powers HOWTO-Related Questions 23 24th June 2008 18:37
Xen doesn't start: Kernel panic - not syncing: Attempted to kill init! stormrider Kernel Questions 2 23rd October 2007 21:52


All times are GMT +2. The time now is 14:43.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.