Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 28th February 2008, 07:50
templas templas is offline
Junior Member
 
Join Date: Feb 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default migrating from shadow passwords to mysql database

Maybe someone has already done such migrations and could share the knowlege how to do this. I want to migrate old mail server with shadow passwords to a new one with mysql database. How should the scripts look for reading and parsing users with passwords to the database?
Reply With Quote
Sponsored Links
  #2  
Old 29th February 2008, 13:33
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

The passwords are the problem because they are saved in encrypted form (crypt or md5) in /etc/shadow. This means you can't convert them into any other format, but would have to store them in the MySQL database as they are. Then your mail server would have to authenticate against these passwords.
__________________
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 5th February 2013, 00:01
koukouviou koukouviou is offline
Junior Member
 
Join Date: Feb 2013
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sorry for asking the same question a few years later!! I have the same issue here and I didn't want to open a new thread for it.

Just to be sure here, I didn't understand if you are saying that the migration of the encrypted passwords is NOT possible in mysql databases, or if I can copy the encrypted password of a user to the password field in my database and then the user can login with his/her unencrypted password after authentication??

I'm sorry if my question is trivial, I just have to study so I don't mess up my clients' accounts!
Reply With Quote
  #4  
Old 5th February 2013, 20:13
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
 
Default

What I tried to say is that you cannot undo the encryption. You cannot convert encrypted passwords to unencrypted ones.
__________________
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
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
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
LAMP System Fedora Core 6 MySQL start error gavino HOWTO-Related Questions 13 21st November 2007 19:13
mysql clustering problem : cannot create table in database prince.fer Server Operation 2 16th April 2007 17:03
virtual mail boxes setup satimis Server Operation 3 25th January 2007 18:32
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 02:45.


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