mysql embedding to ftp

[malesef]

Hi fellas,
new bee here,all the suggestions,ideas are more than welcome.
I have question about embedding existing mysql data to FTP.
let me tell you how the system works.
apache gets the user name and passwords records to the MYSQL and creates a folder per user in server.
however users can not access their created folder using FTP client software.

so how am I gonna merge the existing user/password data in MYSQL --->to the FTP user/password.
ps. vsftpd and proftpd installed already, so in whichever you feel more knowledgeable, I can go with that.

Thank you

[HROAdmin26]

If the user/pass info in the DB is hashed, you can't "export" it. The hash is not reversible and you don't know the algorithm used by the DB to create the hash.

To use existing account info, you'll have to use an FTP server that can authenticate using the DB.

[malesef]

what if it is not hashed?
how to merge existing userdata with ftp?
thank you

[HROAdmin26]

what if it is not hashed?
how to merge existing userdata with ftp?

Copy it or run it through the FTP's hash function.

[malesef]

since I am new bee,
could you please give me a brief explanation.
how to copy and run with ftp hash function.
I really appreciate.

[HROAdmin26]

You probably don't know the FTP's hash function.

Script:

For each account pulled from MySQL, feed it to "adduser" on the FTP server.

Result:

Accounts from MySQL added to FTP all with same username and password.

Downside:

Password changes on one are not reflected on the other (unless some other automated script checks for change in MySQL and runs "change password" on the FTP.

** Better: FTP authenticates user via MySQL (if possible.)