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 1st March 2011, 10:30
emo0boy emo0boy is offline
Junior Member
 
Join Date: Mar 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (MD5?)

Hi!

First sorry for my english

I've made a mail server exactly like in this tutorial:
http://www.howtoforge.com/virtual-us...l-ubuntu-10.10

Everything works great. My next task is to import into database from another database over 200 accounts. I can write a script to do that, problem is that passwords in old database are md5 crypted and in new database (from tutorial) passwords are crypted with Unix crypt.

My question is: is there any solution how to change configuration from tutorial to use md5 crypted passwords from database?

Thanks for any help.

EDIT

So I have a user with MD5 crypted password. I force SMTP to use MD5 crypted password by changing /etc/pam.d/smtp

from:
Code:
auth    required   pam_mysql.so user=mail_admin passwd=mail_admin_password host=127.0.0.1 db=mail table=users usercolumn=email passwdcolumn=password crypt=1
account sufficient pam_mysql.so user=mail_admin passwd=mail_admin_password host=127.0.0.1 db=mail table=users usercolumn=email passwdcolumn=password crypt=1
to:
Code:
auth    required   pam_mysql.so user=mail_admin passwd=mail_admin_password host=127.0.0.1 db=mail table=users usercolumn=email passwdcolumn=password crypt=3
account sufficient pam_mysql.so user=mail_admin passwd=mail_admin_password host=127.0.0.1 db=mail table=users usercolumn=email passwdcolumn=password crypt=3
and sending mail works OK, but then I can't get any mail because POP3 auth error. I tried paste the same code to /etc/pam.d/pop3 but no effect still POP3 auth error.

So the question is now: how to force POP3 to use MD5 crypted passwords form MySQL database?

Last edited by emo0boy; 1st March 2011 at 13:19.
Reply With Quote
Sponsored Links
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
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail gu35t HOWTO-Related Questions 5 3rd February 2011 21:25
Update for Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail de Freitas HOWTO-Related Questions 6 7th July 2010 23:49
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 9.10) keyslapper HOWTO-Related Questions 4 20th April 2010 16:46
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 9.04) Master One HOWTO-Related Questions 4 1st July 2009 16:38
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.10) VTCop HOWTO-Related Questions 9 9th April 2009 17:17


All times are GMT +2. The time now is 22:28.


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