| View previous topic :: View next topic |
| Author |
Message |
Dikkiedik
Guru
Joined: 04 Oct 2004
Posts: 406
Location: Netherlands
|
 Posted: Thu Oct 27, 2005 9:41 am Post subject: PROftpd |
 |
|
Hi, I used the following howto to install proftpd with mysql support,
but it won't work.
http://gentoo-wiki.com/HOWTO_ProFTPD
I've enabled mysql support, set up the ftp database, and as far as I know configured proftpd.conf
the right way, but it just won't work!
Some info:
Section of proftpd.conf
| Code: |
# Password type
SQLAuthTypes Plaintext
# Authentication type
SQLAuthenticate users
# Use only SQL when authenticating, and not the system's /etc/passwd
# If the user's information is not in SQL, they're not a user to use
# this server.
AuthOrder mod_sql.c
# DB connect info. Format: database_name@server_address database_username database_password
SQLConnectInfo mysql@172.16.16.62 proftpd aardolie
# Default UID/GID. Change to suit needs.
SQLDefaultUID 5000
SQLDefaultGID 5000
# Mininum UID/GID. Change to suit needs.
SQLMinUserUID 1000
SQLMinUserGID 1000
# Database query. Format: ** defined below **
SQLUserInfo ftp username password uid gid ftpdir homedir
# Jail users in ftpdir
DefaultRoot ~
|
The table 'ftp' is located in the 'mysql' database (database named mysql in mysql on 172.16.16.62 local),
I'm unsure about the following. It's the ftp table in mysql, but it's weird when I try to add something so I think I must be doing something wrong.
| Code: |
user_id username password uid gid ftpdir homedir
1 107 *19433E1788D23D9489BE29167EB193C1E0C2AED1 5000 5000 47 /home/kevin
|
Help is welcome |
|
| Back to top |
|
 |
Quincy
Apprentice
Joined: 02 Jun 2005
Posts: 201
Location: Germany
|
| Posted: Fri Oct 28, 2005 2:59 am Post subject: |
|
|
Your passwords don't match!
You configured: | Code: | | SQLAuthTypes Plaintext |
but you set it to an MySQL encrypted password.
Read the proftpd doc: http://proftpd.org/docs/directives/linked/config_ref_SQLAuthTypes.html
And chose the apporiate pair of encryption and SQLAuthType.
With your currently with MySQL PASSWORD() encrypted password you can try SQLAuthType Backend.
It works surely with SQLAuthType Crypt and the MySQL ENCRYPT() function. |
|
| Back to top |
|
|
adelante
Tux's lil' helper
Joined: 19 Apr 2003
Posts: 133
Location: South Africa - Johannesburg
|
| Posted: Tue Nov 01, 2005 1:36 pm Post subject: |
|
|
Now imagine there was a way to convert the mysql4.0 Password() values to the new mysql4.1 Password() values.
Because when using mysql4.1 your proftpd wont work work mysql if you use the old mysql4.0 password hash.
This is would be find is you doing a new install, but my problem is that I have around 1000 ftp username/password in the database, i have no way to convert the passwords, is there anyway to tell proftpd to use old_password() instead of password() ? |
|
| Back to top |
|
|
Quincy
Apprentice
Joined: 02 Jun 2005
Posts: 201
Location: Germany
|
| Posted: Thu Nov 03, 2005 1:11 am Post subject: |
|
|
Doesn't MySQL recognized that itself? You are able to use old and new passwords side by side when connecting to mysql, but don't know how it is implemented into proftpd.
Perhaps asks on the proftpd mailing list (after searching it)...
I know why i'm using crypt...  |
|
| Back to top |
|
|
adelante
Tux's lil' helper
Joined: 19 Apr 2003
Posts: 133
Location: South Africa - Johannesburg
|
| Posted: Thu Nov 03, 2005 6:29 am Post subject: |
|
|
Well from what I understand, proftpd takes the password that you enter when you ftp, does the MySQL PASSWORD() function on it, then compares it's output to whatever is in the database.
What they actually need to do is in the mod_sql for proftpd, and build in a feature to allow you to use the OLD_PASSWORD() function and call it like Backend_Old or something. |
|
| Back to top |
|
|
|
Other Things Gentoo
