LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 06-15-2010, 01:18 PM   #1
sickdude
LQ Newbie
 
Registered: Mar 2005
Distribution: red hat *, fedora core *, gentoo, slackware, ubuntu
Posts: 27

Rep: Reputation: 15
Export unix users to mysql


Hi all,

I am in a sticky situation at the office and i hope you guys can help me out a bit, you have in the past :-).

Anyway i have a very old Mandrake server where a previous owner hosted mailboxes on. This server is getting very slow and does alot of e-mail related tasks like:
  • pop
  • smtp
  • mx

It runs on sendmail (which is also very outdated...) and it doesnt seem to respond to its config files. And the whole smtp and mx thing leaves us with some really weird mail problems...

So i want to implement it in our current mail setup in which i have it all on seperate servers:
  • 2 smtp server (dns roundrobbing) (postfix)
  • 4 mx servers (1 etrn) (postfix)
  • 1 webmail server (v-webmail) (just apache and connects to the pop/imap server)
  • And 1 pop/imap server (postfix, dovecot)

I also want to implement smtp authentication because of all the mobile clients i have to host... This is where it gets tricky.

I want to export the unix user table of the old mandrake server and import that into a mysql database. This database will be used to authenticate the smtp users.

I also want the export of the unix users to import it to the other pop/imap server so users can logon to that server instead of the crappy Mandrake server.

I would expect that the export from unux users to mysql (including passwords) is the hardest part. I googled it, but some of the stuff i found didnt seem to be very reliable, so thats where you guys kick in :-). So is this possible? If so, how can i do it?

I know i should go with some kind of ldap situation but that seems a way bigger hassle then this setup. And if all of this works i can, in the future, implement the whole ldap thing.

Thanks for the help and sorry for the long text.

PS. The newer servers are all CentOS 5.X
 
Old 06-15-2010, 01:46 PM   #2
rweaver
Senior Member
 
Registered: Dec 2008
Location: Louisville, OH
Distribution: Debian, CentOS, Slackware, RHEL, Gentoo
Posts: 1,833

Rep: Reputation: 167Reputation: 167
You should look at some centralized authentication (mysql? ldap?) at the minimum. The hard part here is of course getting the passwords, as unix encrypts them. You can run a password cracker on them and get a lot of them (but of course, if it gets them... they really need changed because they're insecure and brute force-able.)

Getting most of the information is very easy, everything but passwords really... getting into sql is even easy.

Quite honestly my suggestion is set a password policy and force everyone across the board to change passwords or set new passwords you deliver to them before hand prior to the mail change over.
 
  


Reply



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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Where shall i put an export for all the users? permalac Linux - Server 7 05-20-2009 02:43 AM
Export DISPLAY works from linux boxes but not from unix. yoder Solaris / OpenSolaris 3 04-28-2005 06:58 AM
Export DISPLAY works from linux boxes but not from unix yoder Red Hat 3 04-27-2005 08:26 AM
How is the UNIX ownership of FTP Export assigned? skeetermouse AIX 5 04-20-2005 03:23 PM
Why did you experienced users of Unix change to unix over Windows? Laptop2250 Linux - General 11 10-28-2003 11:51 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 05:26 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration