Hi!


Im running Debian Etch (upgraded from Sarge) and after upgrading ProFTP
isnt working anymore.

If I try to run it frum inedt (as it was) i run into two problems:


First, proftpd.conf should be in /etc/ but it is in /etc/proftpd.
I solved this by copying in /etc.

I tried to configure inetd.conf
ftp stream tcp nowait root /usr/sbin/proftpd proftpd -c
/etc/proftpd/proftpd.conf

but dont know, if thats working.

The next thing, is proftpd doesnt auth through mysql. it uses postgres
instead. do you know, how to change the authmethod? here the SQLerrorlog:

Apr 10 08:36:03 mod_sql/4.2.1[12858]: defaulting to 'postgres' backend
Apr 10 08:36:03 mod_sql/4.2.1[12858]: backend module 'mod_sql_postgres/4.02'
Apr 10 08:36:03 mod_sql/4.2.1[12858]: backend api 'mod_sql_api_v2'
Apr 10 08:36:03 mod_sql/4.2.1[12858]: >>> sql_sess_init
Apr 10 08:36:03 mod_sql/4.2.1[12858]: entering postgres
cmd_defineconnection
Apr 10 08:36:03 mod_sql/4.2.1[12858]: name: 'default'
Apr 10 08:36:03 mod_sql/4.2.1[12858]: user: 'proftp-user'
Apr 10 08:36:03 mod_sql/4.2.1[12858]: host: 'localhost'
Apr 10 08:36:03 mod_sql/4.2.1[12858]: db: 'ftp-database'
Apr 10 08:36:03 mod_sql/4.2.1[12858]: port: '5432'
Apr 10 08:36:03 mod_sql/4.2.1[12858]: ttl: '0'
Apr 10 08:36:03 mod_sql/4.2.1[12858]: exiting postgres cmd_defineconnection
Apr 10 08:36:03 mod_sql/4.2.1[12858]: entering postgres cmd_open
Apr 10 08:36:03 mod_sql/4.2.1[12858]: exiting postgres cmd_open
Apr 10 08:36:03 mod_sql/4.2.1[12858]: unrecoverable backend error
Apr 10 08:36:03 mod_sql/4.2.1[12858]: error: 'mod_sql_postgres/4.02'
Apr 10 08:36:03 mod_sql/4.2.1[12858]: message: 'could not connect to
server: Connection refused
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?


and here my proftpd.conf:

-------

#
# Includes required DSO modules. This is mandatory in proftpd 1.3
#
Include /etc/proftpd/modules.conf


ServerName "FTP-Service"
ServerType standalone

DeferWelcome off

MultilineRFC2228 on
DefaultServer on
ShowSymlinks off

TimeoutNoTransfer 600
TimeoutStalled 600
TimeoutIdle 1200

DisplayLogin welcome.msg
DisplayFirstChdir .message
ListOptions "-l"

DenyFilter \*.*/

MaxClientsPerHost 5 "Nicht mehr als %m Verbindungen"
MaxClients 10 "Leider sind schon %m Clients verbunden"
MaxLoginAttempts 5
MaxInstances 30

AllowStoreRestart on

# Uncomment this if you are using NIS or LDAP to retrieve passwords:
#PersistentPasswd off

# Uncomment this if you would use TLS module:
#TLSEngine on

# Uncomment this if you would use quota module:
#Quotas on

# Uncomment this if you would use ratio module:
#Ratios on

# Port 21 is the standard FTP port.
Port 21


SQLConnectInfo ftp-database@localhost proftp-user GetItNow100
SQLDefaultHomedir /home/ftp/
SQLUserInfo users username password uid gid homedir shell

SQLAuthenticate users*
SQLAuthTypes Plaintext

#UID und GID des users bzw Gruppe bobody/Nogroup
SQLDefaultGID 65534
SQLDefaultUID 65534
SQLMinUserGID 500
SQLMinUserUID 500
SQLLogFile /var/log/proftpd.sql.log
RequireValidShell off

#SQLLog RETR,STOR transfer1
SQLLog PASS updatecount
SQLNamedQuery updatecount UPDATE "letzter_zugriff=now(), count=count+1
WHERE username='%u'" users


MaxInstances 30

# Set the user and group that the server normally runs at.
User nobody
Group nogroup

# Umask 022 is a good standard umask to prevent new files and dirs
# (second parm) from being group and world writable.
Umask 022 022
# Normally, we want files to be overwriteable.
AllowOverwrite on



# TLS

TLSEngine on
TLSLog /var/log/proftpd_tls.log
TLSProtocol TLSv1
TLSRequired off
TLSVerifyClient off
TLSRSACertificateFile /etc/ftpcert/ftphost.cert
TLSRSACertificateKeyFile /etc/ftpcert/ftphost.key





RootLogin off
Umask 022 022
#DefaultChdir /home/ftp
#DefaultRoot /home/ftp


DefaultChdir ~
DefaultRoot ~

#

DenyAll



AllowAll





Any hints for me?

TIA!


Martin


-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757...un.com/javaone
_______________________________________________
ProFTPD Users List
Unsubscribe problems?
http://www.proftpd.org/list-unsub.html