| Author |
Message |
Internat
Joined: 17 Aug 2004
Posts: 178
Location: Brisbane, Australia
|
| Posted: Sun Mar 20, 2005 3:59 am Post subject: FTP and mysql |
|
|
Is there some ftp (hopefully proftpd cause thats what im already using) or some other secure and common ftp server, that i can make authenicate via mysql and work ou what directory they have access to from that?
Cheers
NF |
|
| Back to top |
|
pclissold
Joined: 24 Oct 2003
Posts: 481
Location: Netherlands
|
| Posted: Sun Mar 20, 2005 6:26 am Post subject: |
|
|
| This ProFTPD plug-in looks like it might suit your needs |
|
| Back to top |
|
dacoffey
Joined: 18 Feb 2005
Posts: 5
Location: Morgantown, WV
|
| Posted: Wed Mar 23, 2005 12:24 am Post subject: |
|
|
I use sftp via openssh on my box.
I host a number of sites for friends, and the admin work is starting to get annoying ... so it's time to automate my virtual hosting.
I think I am going to install pam-mysql so that all PAM aware apps can use my master user table.
If ProFTPD utilizes PAM, that may be another option. |
|
| Back to top |
|
Internat
Joined: 17 Aug 2004
Posts: 178
Location: Brisbane, Australia
|
| Posted: Sun May 08, 2005 11:35 pm Post subject: proftpd-mysql |
|
|
that mod looks rad, the only things about it is im not sure how the userid/groupid work in it, because wont i have to give them valid ids for the machine? which i thought was the point of NOT having proper accounts and having eveyrthing done via mysql, so that i didnt have to have them having group/user ids on the machine.. unless im missing something completley here
any help would be appreciated
cheers
Nathan |
|
| Back to top |
|
NeonNero
Joined: 04 Jan 2005
Posts: 121
Location: Ålesund, Norway
|
| Posted: Mon May 09, 2005 2:43 am Post subject: |
|
|
Actually, my co-worker has made a tutorial for this over at the Gentoo Forums:
Proftpd 1.2.10 with mysql authentication, software qouta, traffic shaper and SSL |
|
| Back to top |
|
Internat
Joined: 17 Aug 2004
Posts: 178
Location: Brisbane, Australia
|
| Posted: Thu May 12, 2005 4:45 am Post subject: |
|
|
thats rad, thanks for that.
im still not quite sure how the groups would work inside of it tho? do i just alocate a section of group ids to put asside for ftp group users or..?
cheers
Nathan |
|
| Back to top |
|
Internat
Joined: 17 Aug 2004
Posts: 178
Location: Brisbane, Australia
|
| Posted: Thu May 12, 2005 4:46 am Post subject: |
|
|
| also on that note, do i have to put normal system users into the mysql table as well or will proftpd already deal with them? |
|
| Back to top |
|
Internat
Joined: 17 Aug 2004
Posts: 178
Location: Brisbane, Australia
|
| Posted: Fri Jun 24, 2005 12:55 am Post subject: |
|
|
anyone know if it is possible to make an easy way of enabling/disabling accounts with this setup, like just adding an extra field to the database and making postfix send a quiery with AND field is true or something like that?
is that even feesable?
cheers
Nathan "Internat" Frankish |
|
| Back to top |
|
Sipherx
Joined: 21 Apr 2005
Posts: 43
Location: Florida
|
| Posted: Fri Jun 24, 2005 8:27 am Post subject: |
|
|
| You could use something like vsftpd and then chroot all local users to their virtual home directories. |
|
| Back to top |
|
Internat
Joined: 17 Aug 2004
Posts: 178
Location: Brisbane, Australia
|
| Posted: Fri Jun 24, 2005 8:40 am Post subject: |
|
|
| well i have postfix working with mysql for authentication and everything is rad, cept taht quotas arent working..stupid pos not sure whats oging on there.. something just seems slightly fubar.. going to redo it all from scratch.. and then document everyhrting i did so that i can do it again.. umm yeah.. i was thinking about how to make it so that peopls accounts are enabled/disabled and i think i can just add to the login thing where accountstatusfield=1 kinda thing cause then obviously its going to not return if there account is disabled. |
|
| Back to top |
|
| |
