HOWTO: PureFTPD with MySQL Auth + MyPhpAdmin

ikaro · Advocate Joined: 14 Jul 2003 Posts: 2527 Location: Denmark

just make the accounts, and then use its UID/GID
doesnt have to be those I wrote, it can be whatever.
_________________
linux: #232767

cpu · Posted: Wed Oct 20, 2004 6:36 am Post subject:

ikaro · Advocate Joined: 14 Jul 2003 Posts: 2527 Location: Denmark

go startover, this time read everything carefully and slow.
_________________
linux: #232767

JeffBlair · Posted: Wed Jun 29, 2005 5:35 pm Post subject:

I know that this is going to be an easy question, but I want to make sure I am thinking right. In the database, where you put in the value for DIR, that is the directory that the FTP points to right?
i.e.

DIR

/var/www/jeffhome.us/jeff/ftp/

Would this send all files to that dir? Thanks.

Also, I know webmin has a way of editing the users. I don't know if this would work for MYSQL users?

ikaro · Advocate Joined: 14 Jul 2003 Posts: 2527 Location: Denmark

yes.
_________________
linux: #232767

COiN3D · Posted: Mon Aug 29, 2005 2:50 pm Post subject:

Do I need Quota-Support in the Kernel to make use of the FTP-Quota-Feature?
_________________
e17 documentation | Be free and use Jabber as your IM! | Combine IRC and IM

ikaro · Advocate Joined: 14 Jul 2003 Posts: 2527 Location: Denmark

nope.
_________________
linux: #232767

T|TaN · n00b Joined: 07 Apr 2004 Posts: 22

wow this is a great idea I have been looking for something like this.

My question is, has anyone implemented this into a website? I already have a Postnuke website which stores information in mysql including username and passwords. I run an ftp site as well, and ideally I would like to synchronize the web users and ftp users. Currently this is done manually, and well it gets to be a pain or I just don't do it. Through the postnuke website the users can reset their passwords and/or if they forget their password they can have it emailed to a registered address. This would be a seamless system and would help prevent password inconsistency.

If someone has setup such a concept I would really like to hear the details.
If someone has ideas on the constructs of how I could apply the solution outlined in this original post to my application, I would love to hear them as well.

Take Care!

nuss · n00b Joined: 04 Dec 2005 Posts: 1

i need your help, i try conect to my ftp with my User and pass...but i can't becouse say me "Login failed error 530"

y followed this guide..

I use this command to Startup My PureFTPD server:

Aikidoka69 · n00b Joined: 03 Jun 2004 Posts: 42 Location: Baltimore, MD

I also am getting the
[09:59:56] PASS (hidden)
[09:59:56] 530 Login authentication failed
messages.

Yes mysql is running. Pure-ftp is connecting to the db. If I change the password in the pureftpd-mysql.conf it will spit an error in the logs so it appears to connect when the password is right. The individual queries work when copied to the mysql command line. But no go on the log in. Linux ftp uid and gid are both 21. User's status is set to 1 with a Uid and Gid of 21. User's home dir is set to the ftp user home dir.

MySQL is version 5.0.22.
Pure-ftpd is version 1.0.12.

The problem turns out to be a difference between the Wiki version and forum version. The Wiki uses MYSQLCrypt md5 while the top of the forum lists cleartext. Being that the Wiki does not mention putting the password in as an md5 hash, most people will end up with a non working setup after following the wiki step by step. If you are getting authentication errors try setting your MYSQLCrypt setting to cleartext and restarting pureftpd.

Of course, you can also just MD5 encrypt your password. If you are doing manual inserts, just put MD5(<password>) into your statement for your password. If you are using phpmyadmin, select md5 from the function list for that field.

vladoportos · n00b Joined: 02 May 2006 Posts: 22

Hmm for my its working only with cleartext which is apsolutely insecure... when i use any ecryption e.g. md5 it cant log in... it will not recognize password... any idea ?

And yes i put md5 hashed pass in mysql...

Aikidoka69 · n00b Joined: 03 Jun 2004 Posts: 42 Location: Baltimore, MD

vladoportos · n00b Joined: 02 May 2006 Posts: 22

I found out that it vas permission problem in mysql its working fine now...

lotherk · n00b Joined: 03 Aug 2006 Posts: 1

... modify the /etc/init.d/pure-ftpd script, since it seems that the values in the /etc/conf.d/pure-ftpd are not taken from this script. Don't know why.

So i wrote a little C programm:

ikaro · Advocate Joined: 14 Jul 2003 Posts: 2527 Location: Denmark

ive since droped this method of using phpmyadmin and moved over some other web user administration,
the latest being this one:
http://linux.softpedia.com/progScreenshots/User-manager-for-PureFTPd-Screenshot-5446.html

works pretty well.
easy to install.
_________________
linux: #232767

Jumento · n00b Joined: 08 Apr 2006 Posts: 27

Hello,

I got a question. I was also following this guide to setup my ftpserver.

And am also using the following user manager as front-end: http://machiel.generaal.net/index.php?subject=user_manager_pureftpd

Only a question.

Is it possible to set a maximum of logins per userid?

Don't know of this is the right spot to ask this.

ikaro · Advocate Joined: 14 Jul 2003 Posts: 2527 Location: Denmark

hi,
you set that in /etc/conf.d/pure-ftpd
_________________
linux: #232767

Jumento · n00b Joined: 08 Apr 2006 Posts: 27

ikaro · Advocate Joined: 14 Jul 2003 Posts: 2527 Location: Denmark

oh im sorry,

I read it as userip not user ID. :roll:

You can do that using the text mode "pure-pw" and use the "-y" switch.

You can code that feature in php and send a patch to the author of the puremanager.

example for 1 login only:

Jumento · n00b Joined: 08 Apr 2006 Posts: 27

thnx.. that was the option i was looking for.