hallo
habe grade proftpd mit mysql als nutzerverzeichnis konfiguriert. alles funktioniert sehr gut. zum hinzufügen von benutzern habe ich die sql tools von sourceforge.net/projects/proftpd-doc-ger/ verwendet.
nun wollte ich versuchen, ob ich mysqls "PASSWORD()" zur verschluesselung der passwoerter nutzen kann.
also habe ich in meiner proftpd.conf "Backend" zu SQLAuthTypes hinzugefügt.
das ganze sieht jetz ungefähr so aus:
SQLAuthTypes Backend Plaintext Crypt OpenSSL
SQLAuthenticate users*
SQLConnectInfo proftpd@localhost proftpd ganzgeheim
SQLDefaultGID 65534
SQLDefaultUID 65534
SQLMinUserGID 100
SQLMinUserUID 500
SQLUserInfo ftp username password uid gid homedir shell
SQLNamedQuery getcount SELECT "count, uid from ftp where uid='%u'"
SQLNamedQuery updatecount UPDATE "count=count+1 WHERE uid='%u'" ftp
SQLShowInfo PASS "230" "You've logged on %{getcount} times, %u"
SQLLog PASS updatecount
SQLHomedirOnDemand on
SQLLOGFILE /var/log/proftpd.sql.log
so funktioniert das einlogen immer noch.
wenn ich jetzt aber das password feld fuer den entsprechenden user in der datenbank von "test" auf "22b0cd6c50b3c075" (was das ergebnis von PASSWORD('test') ist) umstelle, funktioniert es prompt nichmehr
woran kann sowas liegen?
ich post mal noch die relevanten log ausgaben:
Jan 04 21:45:38 mod_sql/4.11[29639]: backend module 'mod_sql_mysql/4.04'
Jan 04 21:45:38 mod_sql/4.11[29639]: backend api 'mod_sql_api_v1'
Jan 04 21:45:38 mod_sql/4.11[29639]: >>> sql_getconf
Jan 04 21:45:38 mod_sql/4.11[29639]: entering mysql cmd_defineconnection
Jan 04 21:45:38 mod_sql/4.11[29639]: name: 'default'
Jan 04 21:45:38 mod_sql/4.11[29639]: user: 'proftpd'
Jan 04 21:45:38 mod_sql/4.11[29639]: host: 'localhost'
Jan 04 21:45:38 mod_sql/4.11[29639]: db: 'proftpd'
Jan 04 21:45:38 mod_sql/4.11[29639]: port: '3306'
Jan 04 21:45:38 mod_sql/4.11[29639]: ttl: '0'
Jan 04 21:45:38 mod_sql/4.11[29639]: exiting mysql cmd_defineconnection
Jan 04 21:45:38 mod_sql/4.11[29639]: entering mysql cmd_open
Jan 04 21:45:38 mod_sql/4.11[29639]: connection 'default' opened
Jan 04 21:45:38 mod_sql/4.11[29639]: connection 'default' count is now 1
Jan 04 21:45:38 mod_sql/4.11[29639]: exiting mysql cmd_open
Jan 04 21:45:38 mod_sql/4.11[29639]: backend successfully connected.
Jan 04 21:45:38 mod_sql/4.11[29639]: mod_sql status : on
Jan 04 21:45:38 mod_sql/4.11[29639]: negative_cache : off
Jan 04 21:45:38 mod_sql/4.11[29639]: authenticate : users
Jan 04 21:45:38 mod_sql/4.11[29639]: usertable : ftp
Jan 04 21:45:38 mod_sql/4.11[29639]: userid field : username
Jan 04 21:45:38 mod_sql/4.11[29639]: password field : password
Jan 04 21:45:38 mod_sql/4.11[29639]: uid field : uid
Jan 04 21:45:38 mod_sql/4.11[29639]: gid field : gid
Jan 04 21:45:38 mod_sql/4.11[29639]: homedir field : homedir
Jan 04 21:45:38 mod_sql/4.11[29639]: shell field : shell
Jan 04 21:45:38 mod_sql/4.11[29639]: homedirondemand : true
Jan 04 21:45:38 mod_sql/4.11[29639]: SQLMinUserUID : 500
Jan 04 21:45:38 mod_sql/4.11[29639]: SQLMinUserGID : 100
Jan 04 21:45:38 mod_sql/4.11[29639]: <<< sql_getconf
Jan 04 21:45:42 mod_sql/4.11[29639]: >>> cmd_getpwnam
Jan 04 21:45:42 mod_sql/4.11[29639]: entering mysql cmd_escapestring
Jan 04 21:45:42 mod_sql/4.11[29639]: exiting mysql cmd_escapestring
Jan 04 21:45:42 mod_sql/4.11[29639]: cache miss for user 'stigi'
Jan 04 21:45:42 mod_sql/4.11[29639]: : entering mysql cmd_select
Jan 04 21:45:42 mod_sql/4.11[29639]: entering mysql cmd_open
Jan 04 21:45:42 mod_sql/4.11[29639]: connection 'default' count is now 2
Jan 04 21:45:42 mod_sql/4.11[29639]: exiting mysql cmd_open
Jan 04 21:45:42 mod_sql/4.11[29639]: query "SELECT username, password, uid, gid, homedir, shell FROM ftp WHERE (username='stigi') LIMIT 1"
Jan 04 21:45:42 mod_sql/4.11[29639]: entering mysql cmd_close
Jan 04 21:45:42 mod_sql/4.11[29639]: connection 'default' count is now 1
Jan 04 21:45:42 mod_sql/4.11[29639]: exiting mysql cmd_close
Jan 04 21:45:42 mod_sql/4.11[29639]: exiting mysql cmd_select
Jan 04 21:45:42 mod_sql/4.11[29639]: cache miss for user 'stigi'
Jan 04 21:45:42 mod_sql/4.11[29639]: user 'stigi' cached
Jan 04 21:45:42 mod_sql/4.11[29639]: + pwd.pw_name : stigi
Jan 04 21:45:42 mod_sql/4.11[29639]: + pwd.pw_uid : 1000
Jan 04 21:45:42 mod_sql/4.11[29639]: + pwd.pw_gid : 1000
Jan 04 21:45:42 mod_sql/4.11[29639]: + pwd.pw_dir : /home/stigi
Jan 04 21:45:42 mod_sql/4.11[29639]: + pwd.pw_shell : /bin/bash
Jan 04 21:45:42 mod_sql/4.11[29639]: <<< cmd_getpwnam
Jan 04 21:45:42 mod_sql/4.11[29639]: >>> cmd_auth
Jan 04 21:45:42 mod_sql/4.11[29639]: entering mysql cmd_escapestring
Jan 04 21:45:42 mod_sql/4.11[29639]: exiting mysql cmd_escapestring
Jan 04 21:45:42 mod_sql/4.11[29639]: cache hit for user 'stigi'
Jan 04 21:45:42 mod_sql/4.11[29639]: >>> cmd_check
Jan 04 21:45:42 mod_sql/4.11[29639]: checking auth_type Backend
Jan 04 21:45:42 mod_sql/4.11[29639]: entering mysql cmd_checkauth
Jan 04 21:45:42 mod_sql/4.11[29639]: exiting mysql cmd_checkauth
Jan 04 21:45:42 mod_sql/4.11[29639]: checking auth_type Plaintext
Jan 04 21:45:42 mod_sql/4.11[29639]: checking auth_type Crypt
Jan 04 21:45:42 mod_sql/4.11[29639]: checking auth_type OpenSSL
Jan 04 21:45:42 mod_sql/4.11[29639]: <<< cmd_check
Jan 04 21:45:42 mod_sql/4.11[29639]: <<< cmd_auth
Jan 04 21:45:44 mod_sql/4.11[29639]: >>> cmd_check
Jan 04 21:45:44 mod_sql/4.11[29639]: checking auth_type Backend
Jan 04 21:45:44 mod_sql/4.11[29639]: entering mysql cmd_checkauth
Jan 04 21:45:44 mod_sql/4.11[29639]: exiting mysql cmd_checkauth
Jan 04 21:45:44 mod_sql/4.11[29639]: checking auth_type Plaintext
Jan 04 21:45:44 mod_sql/4.11[29639]: checking auth_type Crypt
Jan 04 21:45:44 mod_sql/4.11[29639]: checking auth_type OpenSSL
Jan 04 21:45:44 mod_sql/4.11[29639]: <<< cmd_check
na hoffentlioch stehen jetz hier nirgends uebersehene relevante passwoerter drin
danke schonmal
