moin
ich hab nen debian sage system mit mysql 4.11 oder so und habe mir die debian packete installiert proftpd-common proftpd-mysql
ok nurmale user können sich auch einlogen
nur die die ich in der db angelegt habe nicht
das hier is der log aus der proftpd.mysql
Apr 27 04:30:01 mod_sql/4.11[27022]: backend module 'mod_sql_mysql/4.04'
Apr 27 04:30:01 mod_sql/4.11[27022]: backend api 'mod_sql_api_v1'
Apr 27 04:30:01 mod_sql/4.11[27022]: >>> sql_getconf
Apr 27 04:30:01 mod_sql/4.11[27022]: entering mysql cmd_defineconnection
Apr 27 04:30:01 mod_sql/4.11[27022]: name: 'default'
Apr 27 04:30:01 mod_sql/4.11[27022]: user: 'proftpd'
Apr 27 04:30:01 mod_sql/4.11[27022]: host: 'localhost'
Apr 27 04:30:01 mod_sql/4.11[27022]: db: 'proftpd_admin'
Apr 27 04:30:01 mod_sql/4.11[27022]: port: '3306'
Apr 27 04:30:01 mod_sql/4.11[27022]: ttl: '0'
Apr 27 04:30:01 mod_sql/4.11[27022]: exiting mysql cmd_defineconnection
Apr 27 04:30:01 mod_sql/4.11[27022]: entering mysql cmd_open
Apr 27 04:30:01 mod_sql/4.11[27022]: connection 'default' opened
Apr 27 04:30:01 mod_sql/4.11[27022]: connection 'default' count is now 1
Apr 27 04:30:01 mod_sql/4.11[27022]: exiting mysql cmd_open
Apr 27 04:30:01 mod_sql/4.11[27022]: backend successfully connected.
Apr 27 04:30:01 mod_sql/4.11[27022]: mod_sql status : on
Apr 27 04:30:01 mod_sql/4.11[27022]: negative_cache : off
Apr 27 04:30:01 mod_sql/4.11[27022]: authenticate : users
Apr 27 04:30:01 mod_sql/4.11[27022]: usertable : usertable
Apr 27 04:30:01 mod_sql/4.11[27022]: userid field : userid
Apr 27 04:30:01 mod_sql/4.11[27022]: password field : passwd
Apr 27 04:30:01 mod_sql/4.11[27022]: uid field : uid
Apr 27 04:30:01 mod_sql/4.11[27022]: gid field : gid
Apr 27 04:30:01 mod_sql/4.11[27022]: homedir field : homedir
Apr 27 04:30:01 mod_sql/4.11[27022]: shell field : shell
Apr 27 04:30:01 mod_sql/4.11[27022]: homedirondemand : false
Apr 27 04:30:01 mod_sql/4.11[27022]: SQLMinUserUID : 999
Apr 27 04:30:01 mod_sql/4.11[27022]: SQLMinUserGID : 999
Apr 27 04:30:01 mod_sql/4.11[27022]: <<< sql_getconf
Apr 27 04:30:01 mod_sql/4.11[27022]: >>> cmd_getpwnam
Apr 27 04:30:01 mod_sql/4.11[27022]: entering mysql cmd_escapestring
Apr 27 04:30:01 mod_sql/4.11[27022]: exiting mysql cmd_escapestring
Apr 27 04:30:01 mod_sql/4.11[27022]: cache miss for user 'www'
Apr 27 04:30:01 mod_sql/4.11[27022]: : entering mysql cmd_select
Apr 27 04:30:01 mod_sql/4.11[27022]: entering mysql cmd_open
Apr 27 04:30:01 mod_sql/4.11[27022]: connection 'default' count is now 2
Apr 27 04:30:01 mod_sql/4.11[27022]: exiting mysql cmd_open
Apr 27 04:30:01 mod_sql/4.11[27022]: query "SELECT userid, passwd, uid, gid, homedir, shell FROM usertable WHERE (userid='www') and ((disabled=0 and (NOW()<=expiration or expiration=-1))) LIMIT 1"
Apr 27 04:30:01 mod_sql/4.11[27022]: entering mysql cmd_close
Apr 27 04:30:01 mod_sql/4.11[27022]: connection 'default' count is now 1
Apr 27 04:30:01 mod_sql/4.11[27022]: exiting mysql cmd_close
Apr 27 04:30:01 mod_sql/4.11[27022]: exiting mysql cmd_select
Apr 27 04:30:01 mod_sql/4.11[27022]: <<< cmd_getpwnam
Apr 27 04:30:02 mod_sql/4.11[27022]: entering mysql cmd_close
Apr 27 04:30:02 mod_sql/4.11[27022]: connection 'default' closed
Apr 27 04:30:02 mod_sql/4.11[27022]: connection 'default' count is now 0
Apr 27 04:30:02 mod_sql/4.11[27022]: exiting mysql cmd_close
Apr 27 04:30:02 mod_sql/4.11[27022]: running named query 'time_logout' at exit
Apr 27 04:30:02 mod_sql/4.11[27022]: >>> _process_named_query
Apr 27 04:30:02 mod_sql/4.11[27022]: entering mysql cmd_escapestring
aja beim installieren habe ich auch gleich das opensource admin teil installiert und mit dem admin ding hab ich auch die user angelegt
also ka wo da der fehler is :?:
aja hier nochmal meine proftpd.conf (zumindest der sql teil davon)
ExtendedLog /var/log/proftpd.access_log WRITE,READ write
ExtendedLog /var/log/proftpd.auth_log AUTH auth
ExtendedLog /var/log/proftpd.paranoid_log ALL default
SQLLogFile /var/log/proftpd.mysql
SQLAuthTypes Plaintext Backend Empty
SQLAuthenticate users*
SQLConnectInfo proftpd_admin@localhost proftpd *********
SQLUserInfo usertable userid passwd uid gid homedir shell
SQLGroupInfo grouptable groupname gid members
SQLUserWhereClause "disabled=0 and (NOW()<=expiration or expiration=-1)"
# Log the user logging in
SQLLog PASS counter
SQLNamedQuery counter UPDATE "lastlogin=now(), count=count+1 WHERE userid='%u'" usertable
# logout log
SQLLog EXIT time_logout
SQLNamedQuery time_logout UPDATE "lastlogout=now() WHERE userid='%u'" usertable
# display last login time when PASS command is given
SQLNamedQuery login_time SELECT "lastlogin from usertable where userid='%u'"
SQLShowInfo PASS "230" "Last login was: %{login_time}"
# xfer Log in mysql
SQLLog RETR,STOR transfer1
SQLNamedQuery transfer1 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'c', NULL"
xfer_stat
SQLLOG ERR_RETR,ERR_STOR transfer2
SQLNamedQuery transfer2 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'i', NULL"
SQLNamedQuery transfer2 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'i', NULL"
xfer_stat
AllowStoreRestart on
AllowRetrieveRestart on
RequireValidShell off
PathDenyFilter "(\.ftp)|(\.ht)[a-z]+$"
DefaultRoot ~
DenyFilter \*.*/
<Directory /ftp/*>
AllowOverwrite off
HideNoAccess on
<Limit READ>
AllowAll
</Limit>
<Limit WRITE>
DenyGroup !admins
</Limit>
</Directory>
<Directory /ftp/incoming/*>
AllowOverwrite on
HideNoAccess on
<Limit READ>
DenyGroup !admins
</Limit>
