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
  #1  
Old 2nd December 2008, 00:56
Thomas_Powers Thomas_Powers is offline
Junior Member
 
Join Date: Jun 2008
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default Perfect SpamSnake User question

Hello....

We have had the perfect spam snake running for almost 6 months now and it's great!! Kudos to Rocky for Posting it!!

Anyway...our admin has now quit, and management says we need to change the passwords on the spamsnake.

We already have tried changed the ubuntu root password, but we are sure that has made some issues for us in the config.

We also want to use a different user for hitting the mailscanner site altogether (mailwatch is what we used before) let's say we change it to 'webmail' for the user. I'm sure there will be a mailscanner DB change as well as some config files to define that user to mailscanner, the db, etc. we just don't know all the places.

We took a shot at this on a cloned version and the mailscanner web page stopped working altogether, so we now post for help.

So if anyone could post the way to properly change the root password for ubuntu (which we have with sudo passwd root) and then the changes the spamsnake will need to take that new root password. We also want to change the 'mailwatch' user to 'webmail' user so all the db settings and conf file changes we'll have to make.

THanks
Tom P
Reply With Quote
Sponsored Links
  #2  
Old 2nd December 2008, 14:17
Rocky Rocky is offline
Senior Member
 
Join Date: Oct 2005
Posts: 553
Thanks: 14
Thanked 49 Times in 48 Posts
Default

Tom,

I'm happy to hear that you've been using the snake and it's been doing it's job for you. As for your problems.

Have you already changed the root password? If so, then that part is completed.

As for the snake, you can create a new user with administrator priviledges or you can just change the password for your existing user.

If you log into the mailwatch interface and go to tools/links, select user management. You'll then be taken into another window that lists all your created users. From there, you can add, delete or edit the user profiles accordingly. I would just change the password on the current user.

Hope this helps.

Rocky
__________________
Home of the SpamSnake
Reply With Quote
  #3  
Old 2nd December 2008, 22:29
Thomas_Powers Thomas_Powers is offline
Junior Member
 
Join Date: Jun 2008
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default One other quick question

THanks...the user changeout works.

How does one purge the old emails from the system? We have stuff that goes back 6 months and if I list all the messages, I get like 29000 pages. How does one dump everythin gin the DB and go fresh? We've noticed it's getting slower as this gets bigger. The messages themselves are gone, but I'm thinking they still show up in the database.

Tom P
Reply With Quote
  #4  
Old 2nd December 2008, 23:38
Thomas_Powers Thomas_Powers is offline
Junior Member
 
Join Date: Jun 2008
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default I was wrong

We thought things were ok after changing the passwords, but now we get this error on reboot of mailscanner

Warning: mysql_pconnect(): Access denied for user 'mailwatch'@'localhost' (using password: YES) in /var/www/mailscanner/functions.php on line 509 Could not connect to database: Access denied for user 'mailwatch'@'localhost' (using password: YES)


It's gotta be in a config file somewhere...but which one?

TP
Reply With Quote
  #5  
Old 3rd December 2008, 15:09
Rocky Rocky is offline
Senior Member
 
Join Date: Oct 2005
Posts: 553
Thanks: 14
Thanked 49 Times in 48 Posts
 
Default

Tom,

Did you change the password for your mailwatch db user? If so, you'll have to update the password accordingly:

Log into webmin and go to Server-->Mysql Database Server-->User Permissions
Select the mailwatch user and change the password as necessary.

Edit /var/www/mailscanner/conf.php and update the following with the password used in the above:
define(DB_USER, 'mailwatch');
define(DB_PASS, 'password');

If you did section 9.10, you'll need to update /etc/MailScanner/CustomFunctions/SQLBlackWhiteList.pm as well:
my($db_user) = 'mailwatch';
my($db_pass) = 'password';

Let me know how that goes.

Rocky
__________________
Home of the SpamSnake
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
The Perfect SpamSnake - Ubuntu 8.04 - troubles teixeira HOWTO-Related Questions 8 14th November 2008 19:38
Relay problems when testing the Perfect SpamSnake dboltz HOWTO-Related Questions 7 7th November 2008 03:35
Issue with Configuring Perfect spamsnake shedy77 HOWTO-Related Questions 2 4th September 2008 03:46
log files cruz Technical 3 15th May 2007 14:35
Perfect Ubuntu 5.10 question (MYSQL) Lord_Garfield HOWTO-Related Questions 3 1st September 2006 16:18


All times are GMT +2. The time now is 08:18.


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