• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 251
  • Last Modified:

Sendmail and Proftpd mysql help

Hi everyone. I need help to use a mysql DB to store the user and pass of the mail and ftp account.

Im using RedHat 7.3

Thanks
0
Sabian
Asked:
Sabian
  • 8
  • 5
  • 3
  • +1
2 Solutions
 
majorwooCommented:
you just want to make a databse with their name/password so that you can retrieve them in case they lose it or something?
0
 
SabianAuthor Commented:
yes
to create an admin panel to add some mail and ftp account
0
 
majorwooCommented:
what do you know about databases? all you have to do is make the table and insert the data..  I am not sure what to describe here, what do you want help with?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
SabianAuthor Commented:
I want to store, the /etc/passwd into a MySQL DB with the passwd password. I`ll have an admin panel in php to create some mail account and ftp account.
0
 
majorwooCommented:
http://www.mysql.com/documentation/mysql/bychapter/index.html

you can get the rpm from www.rpmfind.net

if you want specific help with a certain part let me know
0
 
SabianAuthor Commented:
humm its the mysql how to... i dont think i`ll find how to put the passwd into a mysql db..
0
 
SabianAuthor Commented:
humm its the mysql how to... i dont think i`ll find how to put the passwd into a mysql db..
0
 
majorwooCommented:
do you know how to make a database?
you can store the passwd file in there..

do you want a script to insert it or what?

The password file is encrypted, so if you store it and they lose thier password you cant give it back to them..
0
 
SabianAuthor Commented:
yes i know how to creat a DB. I just dont know how to store the pass and user into the DB.

in which file the password is encrypted?
0
 
majorwooCommented:
there is no way on a *nix system to get the users password from a file.

in /etc/password the password is stored as encrypted.

If you wanted to save each users name/pass when you add them (which is a horrible idea security wise, instead of storing them if they lose it reset their password)

but assuming you did you could write a scritpt to do it, is this the plan?
0
 
SabianAuthor Commented:
ok tx i`ll see.
0
 
mbarbosCommented:
Ok, both for ftp and mail you need to use something that can use db for user authentication. For ftp one choice is proftpd. See the proftpd documentation.
For mail, you can try courier imap + postfix (see http://kirb.insanegenius.net/postfix.html).
0
 
mbarbosCommented:
Oh, the ideea is that ftp and mail users should have (almost) nothing to do with the system accounts.
0
 
SabianAuthor Commented:
ftp and mail use actualy the same account. Depend if i creat pop account only. The user list is on /etc/passwd. I want to put all the user and pass into mysql
0
 
mbarbosCommented:
It's a little bit difficult to use a db instead of /etc/passwd. You can use db for ftp and mail accounts though, if that's what you want.

Actaully what do you want to do ?
0
 
SabianAuthor Commented:
yes i want to create an admin panel for my client that can add mail account itself
0
 
CleanupPingCommented:
Sabian:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 8
  • 5
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now