Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 16th April 2008, 08:16
c4rdinal c4rdinal is offline
Member
 
Join Date: Mar 2008
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySQL user user@adomain.com not found: /dspam/

Hi,

I'm doing Debian Etch + Postfix + DSPAM + WebUI + MySQL auth.
My problem is I can’t pass thru the authorization window.

Root user can’t pass it either. Logs show:
/var/log/apache2/error.log
.
[Wed Apr 16 09:52:33 2008] [error] [client 192.168.1.222] MySQL user user@adomain.com not found: /dspam/

I added the /etc/dspam/admins

user@domain.com

Add the md5 method to functions.inc.php :

Code:
function pacrypt ($pw, $pw_db="")
{
   global $CONF;
   $password = "";
   $salt = "";

   if ($CONF['encrypt'] == 'md5')
   {
      $password = md5($pw);
   }

Under config.inc.php change the method used :

Code:
$CONF['encrypt'] = 'md5';
My Apache configuration:

/etc/apache2/sites-available/default :

Code:
                AuthName "DSPAM Authentication"
                AuthType Basic
                Require valid-user
                AuthUserFile /dev/null

                AuthBasicAuthoritative Off
                AuthMySQLAuthoritative on
                AuthMySQLHost 127.0.0.1
                AuthMySQLUser root
                AuthMySQLPassword pass
                AuthMySQLDB postfix
                AuthMySQLUserTable mailbox
                AuthMySQLNameField username
                AuthMySQLPasswordField password
                AuthMySQLPwEncryption md5
I can successfully log into Mysql using the following accounts but failed during web authentication.

Any thoughts?

TIA
Reply With Quote
Sponsored Links
  #2  
Old 17th April 2008, 00:12
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

What happens if you store the password manually in the DB using the MySQL MD5 function (e.g. with phpMyAdmin)? Does it work then?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 17th April 2008, 02:56
c4rdinal c4rdinal is offline
Member
 
Join Date: Mar 2008
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko
What happens if you store the password manually in the DB using the MySQL MD5 function (e.g. with phpMyAdmin)? Does it work then?
Thank you for your reply.

Yes, manually storing the password in MySQL MD5 function is working via phpMyAdmin.

I'm stuck.
Reply With Quote
  #4  
Old 17th April 2008, 21:34
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

Then it seems as if WebUI isn't storing the passwords correctly...
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 18th April 2008, 02:38
c4rdinal c4rdinal is offline
Member
 
Join Date: Mar 2008
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Any known fix? I'm stuck.
Reply With Quote
  #6  
Old 18th April 2008, 10:06
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

Please compare your configuration again with the one from the tutorial. Maybe you've made a typo somewhere?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 23rd April 2008, 11:35
c4rdinal c4rdinal is offline
Member
 
Join Date: Mar 2008
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by falko
Please compare your configuration again with the one from the tutorial. Maybe you've made a typo somewhere?
Hi falko,

Just got it finally!

Thank you so much

Last edited by c4rdinal; 23rd April 2008 at 12:01.
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
Statistic not working mzo Installation/Configuration 49 20th April 2011 13:19
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
pure-ftp woes d3th_n1gG4 Server Operation 4 24th January 2007 14:11
Network questions regarding Ubuntu Server lubod Installation/Configuration 7 3rd January 2007 19:53
help on /etc/rc0.d/K20dnsctl -> ../init.d/dnsctl zimele General 13 23rd August 2006 17:06


All times are GMT +2. The time now is 20:07.


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