Proftpd + mod_sql error & question

MrEase · 08-28-2005, 01:24 PM

Hi,

I have the following error with proftpd mysql: sometimes when a client connects to the ftp server the server does not respond and the connection fails after it times out. Other times it does respond immediatly and the user connects with no delays.
If I check the logs I see the connected msg but there is no response on the client side. The sql log also show no errors on the connection.
Here is my proftpd.conf:

Code:

ServerName			"My FTP Server"
ServerType			standalone
DefaultServer			on

# don't give the server banner until _after_ authentication
DeferWelcome                    on

# Port 21 is the standard FTP port.
Port				21

UseReverseDNS			off

AllowOverwrite                   yes

MaxInstances			40
MaxClientsPerUser		5
PersistentPasswd   		off

# general server log
# levels  emerg|alert|crit|error|warn|notice|info|debug

SyslogLevel debug
ServerLog /var/log/proftpd/proftpd.log
SystemLog /var/log/proftpd/proftpd.system.log


<Global>


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

# defaults
TimeoutLogin         		120
TimeoutIdle          		600
TimeoutNoTransfer    		900
TimeoutStalled      		3600

IdentLookups			off

<IfModule mod_auth_pam.c>
    AuthPAM off
  </IfModule>



# Set the user and group under which the server will run.
User				nobody
Group				nobody

# disable root login
RootLogin off

# To cause every FTP user to be "jailed" (chrooted) into their home
# directory, uncomment this line.
DefaultRoot ~

# Bar use of SITE CHMOD by default
<Limit SITE_CHMOD>
  DenyAll
</Limit>

# do not allow any other users
AuthOrder mod_sql.c

# Set auth type to mysql plain text  [OpenSSL]] [ [Crypt]] [ [Backend]] [ [Plaintext]] [ [Empty]
SQLAuthenticate  users* groups* usersetfast groupsetfast
SQLAuthTypes OpenSSL
SQLConnectInfo MyDBName@localhost:3306 MyDBUser MyDBPass

# Set Minimum user / group IDs
SQLMinUserUID 999
SQLMinUserGID 999

SQLLogFile /var/log/proftpd/proftpd-sql.log

# speed up
SQLNegativeCache On

AllowOverwrite                   yes

  # Turn off Ident lookups
  IdentLookups         off

  # Logging file/dir access
  ExtendedLog           /var/log/proftpd/access.log WRITE,READ

  # Record all logins
  ExtendedLog           /var/log/proftpd/auth.log AUTH

  # Paranoia logging level....
  ExtendedLog           /var/log/proftpd/paranoid.log ALL

  #Transfer Log
  TransferLog           /var/log/proftpd/xfer.log

</Global>

Question:
I have a proftpd 1.2.10 with mod_sql and mod_sql_mysql support installed. The authentication using mysql works fine if there is only 1 user with 1 gid. If I create more users with the same gid proftpd wont let them login... There is a field called members in the group table which I did write down the names of all members (separated by , as specified by docs) but it will not let the members login...
If I cant use the same gid for different users whats the point in having groups altogether??

Any help is appreciated...

Thanks!!