Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the 'Does not work' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Does not work
Authored by: BahamutZERO on Dec 15, '02 12:28:25AM

I did as the article said, however I created my database so that the two tables and their fields match the default ones for the SQL addon.

Still, I cannot get the server to work. When I try to log in with a user contained in the database, I get the following error:

530 Login incorrect.
ftp: Login failed.

I have installed MySQL from the package at http://www.entropy.ch. I have also installed phpMyAdmin in order to easily edit my SQL databases.

My machine is running behind an AirPort station, has a static internal IP, and I am running Mac OS X 10.2.3 6G19 ATM.

Here is my ProFTPd configuration:

ServerName "My FTP Server"
ServerType inetd
ServerAdmin foo@bar.zoop

#DefaultServer on

# Port 21 is the standard FTP port.
Port 21

# NAT fix
MasqueradeAddress foo.dyndns.org

# Use the IANA registered ephemeral port range
PassivePorts 49152 65534

# Umask 022 is a good standard umask to prevent new dirs and files
# from being group and world writable.
Umask 022

# Set the user and group that the server normally runs at.
User root
Group wheel

DefaultRoot ~

# MySQL authentification
SQLAuthTypes Backend Crypt

SQLAuthenticate users

# dbase connect information
SQLConnectInfo ftpauth@127.0.0.1 proftpd password

# To prevent DoS attacks, set the maximum number of child processes
# to 30. If you need to allow more than 30 concurrent connections
# at once, simply increase this value. Note that this ONLY works
# in standalone mode, in inetd mode you should use an inetd server
# that allows you to limit maximum number of processes per service
# (such as xinetd)
MaxInstances 30

# Set the maximum number of seconds a data connection is allowed
# to "stall" before being aborted.
TimeoutStalled 300

# We want 'welcome.msg' displayed at login, and '.message' displayed
# in each newly chdired directory.
DisplayLogin welcome.msg
DisplayFirstChdir .message

# Our "basic" anonymous configuration, including a single
# upload directory ("uploads")
<Anonymous ~ftp>

# Allow logins if they are disabled above.
<Limit LOGIN>
AllowAll
</Limit>

# Maximum clients with message
MaxClients 5 "Sorry, max %m users -- try again later"

User ftp
Group ftp
# We want clients to be able to login with "anonymous" as well as "ftp"
UserAlias anonymous ftp

# Limit WRITE everywhere in the anonymous chroot
<Limit WRITE>
DenyAll
</Limit>

# An upload directory that allows storing files
<Directory Upload/>
#<Limit STOR CWD XCWD>
<Limit WRITE>
AllowAll
</Limit>
</Directory>

</Anonymous>

Any help would be greatly appreciated.



[ Reply to This | # ]
Does not work
Authored by: Shadowcharly on Dec 15, '02 10:54:36PM

I am a newbie myself, but maybe my ideas guide someone to the real solution :)

Have you tried with:
# MySQL authentification
SQLAuthTypes Backend

It works for me.

Another thing, i noticed that the only way i can introduce the passwords when i create a new account is by doing it through the mysql command line, i've tried YourSQL to manage the databases and have had no succes in getting the passwords encrypted. And when i tried creating the accounts and latter modify the passwd field through the CLI, the login failed.

To see if you have the same problem with the passwd encryption, create a new account with the mysql comand shown in the article (midifying only the gui, id and passwd) and try to logon with this new user. If this new user can logon, delete the other rows of the database and create the account anew from CLI.

Hope it makes sense :)



[ Reply to This | # ]