www.ProFTPD.de

ProFTPD => ProFTPD - Deutsch => Thema gestartet von: Zipferl am 28. Juni 2005, 14:48:01



Titel: proftpd + mysql, nur 1 user funktioniert! -.-
Beitrag von: Zipferl am 28. Juni 2005, 14:48:01
hallo

hier meine proftpd.conf:


ServerName                      "xxxxxxxxxxxxxxxxxx"
ServerType                      standalone
DefaultServer                   on
Port                            21
Umask                           022
RequireValidShell               off
DefaultRoot ~

<Global>

  SQLConnectInfo                  proftpd@localhost:3389 xxxx xxxxxxxx
  SQLAuthenticate                 users   groups
  SQLAuthTypes                    Crypt   Backend Plaintext
  SQLUserInfo                     users userid passwd uid gid homedir shell
  SQLGroupInfo                    groups groupid gid members

  SQLLog                          PASS logincount
  SQLNamedQuery                   logincount UPDATE "login_count=login_count+1 WHERE userid='%u'" users
  SQLLog                          PASS lastlogin
  SQLNamedQuery                   lastlogin UPDATE "last_login=now() WHERE userid='%u'" users
  SQLLog RETR                     dlbytescount
  SQLNamedQuery                   dlbytescount UPDATE "dl_bytes=dl_bytes+%b WHERE userid='%u'" users
  SQLLog RETR                     dlcount
  SQLNamedQuery                   dlcount UPDATE "dl_count=dl_count+1 WHERE userid='%u'" users
  SQLLog STOR                     ulbytescount
  SQLNamedQuery                   ulbytescount UPDATE "ul_bytes=ul_bytes+%b WHERE userid='%u'" users
  SQLLog STOR                     ulcount
  SQLNamedQuery                   ulcount UPDATE "ul_count=ul_count+1 WHERE userid='%u'" users
  SQLUserWhereClause              "disabled!=1"
  SQLLOGFILE                      /var/log/proftpd.sql
</Global>


MaxInstances                    30
User                            nobody
Group                           nogroup

<Directory />
  AllowOverwrite                on
</Directory>



problem ist: ich komm nur mit EINEM einzigen user drauf
(welcher auch systemuser ist)
wenn ich das pw von ihm änder, das es nicht mehr mit dem systemuser übereinstimmt, hab ich keinen zugriff mehr

 :look) hab ich benutzt, nach mehreren stunden suchen hab ichs aufgegeben


Titel: proftpd + mysql, nur 1 user funktioniert! -.-
Beitrag von: Zipferl am 30. Juni 2005, 08:17:04
weiss keiner warum?


Titel: proftpd + mysql, nur 1 user funktioniert! -.-
Beitrag von: stonki am 30. Juni 2005, 10:23:55
Zitat von: "Zipferl"
weiss keiner warum?


a) SqlLogFile /var/log/proftpd.log
b) Proftpd -n -d5 starten
c) Einloggen
d) Logs anschauen ggf. hier posten

NIMM aber einen SQL user, der NICHT am System angemeldet ist !


Titel: proftpd + mysql, nur 1 user funktioniert! -.-
Beitrag von: Zipferl am 30. Juni 2005, 11:22:03
danke schon mal für die hilfe!

hier das consolenfenster:

Code:

 - parsing '/usr/local/etc/proftpd.conf' configuration
 - <Directory />: adding section for resolved path '/'
Config for xxxxxxxxxxxxxx:
/
AllowOverwrite
Umask
SQLConnectInfo
SQLAuthTypes
RequireValidShell
SQLAuthenticate
DefaultServer
Umask
UserID
UserName
GroupID
GroupName
SQLConnectInfo
SQLAuthTypes
SQLUserTable
SQLUsernameField
SQLPasswordField
SQLUidField
SQLGidField
SQLHomedirField
RequireValidShell
SQLGroupTable
SQLGroupnameField
SQLGroupGIDField
SQLGroupMembersField
SQLAuthenticate
SQLLogFile
Bind
deleting existing scoreboard '/usr/local/var/proftpd/proftpd.scoreboard'
ProFTPD 1.2.10 (stable) (built Thu Jun 30 09:29:05 CEST 2005) standalone mode STARTUP
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - FTP session requested from unknown class
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - connected - local  : 212.126.64.77:21
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - connected - remote : 85.124.4.14:3261
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - FTP session opened.
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching PRE_CMD command 'USER test' to mod_core
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching PRE_CMD command 'USER test' to mod_core
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching PRE_CMD command 'USER test' to mod_auth
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching CMD command 'USER test' to mod_auth
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - no supplemental groups found for user 'test'
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching POST_CMD command 'USER test' to mod_sql
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching LOG_CMD command 'USER test' to mod_sql
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching LOG_CMD command 'USER test' to mod_log
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching CMD command 'PASS (hidden)' to mod_auth
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - no supplemental groups found for user 'test'
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - USER test (Login failed): Incorrect password.
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_sql
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_sql
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth
(85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - FTP session closed.


und hier das log:

Code:

Jun 30 11:26:28 mod_sql/4.11[5222]: backend module 'mod_sql_mysql/4.04'
Jun 30 11:26:28 mod_sql/4.11[5222]: backend api    'mod_sql_api_v1'
Jun 30 11:26:28 mod_sql/4.11[5222]: >>> sql_getconf
Jun 30 11:26:28 mod_sql/4.11[5222]: entering    mysql cmd_defineconnection
Jun 30 11:26:28 mod_sql/4.11[5222]:  name: 'default'
Jun 30 11:26:28 mod_sql/4.11[5222]:  user: 'root'
Jun 30 11:26:28 mod_sql/4.11[5222]:  host: 'localhost'
Jun 30 11:26:28 mod_sql/4.11[5222]:    db: 'proftpd'
Jun 30 11:26:28 mod_sql/4.11[5222]:  port: '3389'
Jun 30 11:26:28 mod_sql/4.11[5222]:   ttl: '0'
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_defineconnection
Jun 30 11:26:28 mod_sql/4.11[5222]: entering    mysql cmd_open
Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' opened
Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 1
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_open
Jun 30 11:26:28 mod_sql/4.11[5222]: backend successfully connected.
Jun 30 11:26:28 mod_sql/4.11[5222]: mod_sql status     : on
Jun 30 11:26:28 mod_sql/4.11[5222]: negative_cache     : off
Jun 30 11:26:28 mod_sql/4.11[5222]: authenticate       : users groups
Jun 30 11:26:28 mod_sql/4.11[5222]: usertable          : users
Jun 30 11:26:28 mod_sql/4.11[5222]: userid field       : userid
Jun 30 11:26:28 mod_sql/4.11[5222]: password field     : passwd
Jun 30 11:26:28 mod_sql/4.11[5222]: uid field          : uid
Jun 30 11:26:28 mod_sql/4.11[5222]: gid field          : gid
Jun 30 11:26:28 mod_sql/4.11[5222]: homedir field      : homedir
Jun 30 11:26:28 mod_sql/4.11[5222]: shell field        : NULL
Jun 30 11:26:28 mod_sql/4.11[5222]: homedirondemand    : false
Jun 30 11:26:28 mod_sql/4.11[5222]: group table        : groups
Jun 30 11:26:28 mod_sql/4.11[5222]: groupname field    : groupid
Jun 30 11:26:28 mod_sql/4.11[5222]: grp gid field      : gid
Jun 30 11:26:28 mod_sql/4.11[5222]: grp members field  : members
Jun 30 11:26:28 mod_sql/4.11[5222]: SQLMinUserUID      : 999
Jun 30 11:26:28 mod_sql/4.11[5222]: SQLMinUserGID      : 999
Jun 30 11:26:28 mod_sql/4.11[5222]: SQLDefaultUID      : 65533
Jun 30 11:26:28 mod_sql/4.11[5222]: SQLDefaultGID      : 65533
Jun 30 11:26:28 mod_sql/4.11[5222]: <<< sql_getconf
Jun 30 11:26:28 mod_sql/4.11[5222]: >>> cmd_getgroups
Jun 30 11:26:28 mod_sql/4.11[5222]: entering    mysql cmd_escapestring
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_escapestring
Jun 30 11:26:28 mod_sql/4.11[5222]: cache miss for user 'test'
Jun 30 11:26:28 mod_sql/4.11[5222]: : entering  mysql cmd_select
Jun 30 11:26:28 mod_sql/4.11[5222]: entering    mysql cmd_open
Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 2
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_open
Jun 30 11:26:28 mod_sql/4.11[5222]: query "SELECT userid, passwd, uid, gid, homedir FROM users WHERE (userid='test') LIMIT 1"
Jun 30 11:26:28 mod_sql/4.11[5222]: entering    mysql cmd_close
Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 1
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_close
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_select
Jun 30 11:26:28 mod_sql/4.11[5222]: cache miss for user 'test'
Jun 30 11:26:28 mod_sql/4.11[5222]: user 'test' cached
Jun 30 11:26:28 mod_sql/4.11[5222]: + pwd.pw_name  : test
Jun 30 11:26:28 mod_sql/4.11[5222]: + pwd.pw_uid   : 10000
Jun 30 11:26:28 mod_sql/4.11[5222]: + pwd.pw_gid   : 65534
Jun 30 11:26:28 mod_sql/4.11[5222]: + pwd.pw_dir   : /home
Jun 30 11:26:28 mod_sql/4.11[5222]: + pwd.pw_shell :
Jun 30 11:26:28 mod_sql/4.11[5222]: cache miss for gid '65534'
Jun 30 11:26:28 mod_sql/4.11[5222]: : entering  mysql cmd_select
Jun 30 11:26:28 mod_sql/4.11[5222]: entering    mysql cmd_open
Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 2
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_open
Jun 30 11:26:28 mod_sql/4.11[5222]: query "SELECT groupid FROM groups WHERE (gid = 65534) LIMIT 1"
Jun 30 11:26:28 mod_sql/4.11[5222]: entering    mysql cmd_close
Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 1
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_close
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_select
Jun 30 11:26:28 mod_sql/4.11[5222]: : entering  mysql cmd_select
Jun 30 11:26:28 mod_sql/4.11[5222]: entering    mysql cmd_open
Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 2
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_open
Jun 30 11:26:28 mod_sql/4.11[5222]: query "SELECT groupid, gid, members FROM groups WHERE (groupid = 'nogroup')"
Jun 30 11:26:28 mod_sql/4.11[5222]: entering    mysql cmd_close
Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 1
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_close
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_select
Jun 30 11:26:28 mod_sql/4.11[5222]: cache miss for group 'nogroup'
Jun 30 11:26:28 mod_sql/4.11[5222]: group 'nogroup' cached
Jun 30 11:26:28 mod_sql/4.11[5222]: + grp.gr_name : nogroup
Jun 30 11:26:28 mod_sql/4.11[5222]: + grp.gr_gid  : 65534
Jun 30 11:26:28 mod_sql/4.11[5222]: + grp.gr_mem  :
Jun 30 11:26:28 mod_sql/4.11[5222]: : entering  mysql cmd_select
Jun 30 11:26:28 mod_sql/4.11[5222]: entering    mysql cmd_open
Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 2
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_open
Jun 30 11:26:28 mod_sql/4.11[5222]: query "SELECT groupid, gid, members FROM groups WHERE (members = 'test' OR members LIKE 'test,%' OR members LIKE '%,test' OR members LIKE '%,test,%')"
Jun 30 11:26:28 mod_sql/4.11[5222]: entering    mysql cmd_close
Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 1
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_close
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_select
Jun 30 11:26:28 mod_sql/4.11[5222]: <<< cmd_getgroups
Jun 30 11:26:28 mod_sql/4.11[5222]: >>> cmd_getgroups
Jun 30 11:26:28 mod_sql/4.11[5222]: cache hit for user 'test'
Jun 30 11:26:28 mod_sql/4.11[5222]: cache hit for group nogroup
Jun 30 11:26:28 mod_sql/4.11[5222]: : entering  mysql cmd_select
Jun 30 11:26:28 mod_sql/4.11[5222]: entering    mysql cmd_open
Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 2
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_open
Jun 30 11:26:28 mod_sql/4.11[5222]: query "SELECT groupid, gid, members FROM groups WHERE (members = 'test' OR members LIKE 'test,%' OR members LIKE '%,test' OR members LIKE '%,test,%')"
Jun 30 11:26:28 mod_sql/4.11[5222]: entering    mysql cmd_close
Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 1
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_close
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_select
Jun 30 11:26:28 mod_sql/4.11[5222]: <<< cmd_getgroups
Jun 30 11:26:28 mod_sql/4.11[5222]: >>> cmd_getpwnam
Jun 30 11:26:28 mod_sql/4.11[5222]: cache hit for user 'test'
Jun 30 11:26:28 mod_sql/4.11[5222]: <<< cmd_getpwnam
Jun 30 11:26:28 mod_sql/4.11[5222]: >>> cmd_gid2name
Jun 30 11:26:28 mod_sql/4.11[5222]: cache hit for group nogroup
Jun 30 11:26:28 mod_sql/4.11[5222]: <<< cmd_gid2name
Jun 30 11:26:28 mod_sql/4.11[5222]: >>> cmd_auth
Jun 30 11:26:28 mod_sql/4.11[5222]: entering    mysql cmd_escapestring
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_escapestring
Jun 30 11:26:28 mod_sql/4.11[5222]: cache hit for user 'test'
Jun 30 11:26:28 mod_sql/4.11[5222]: >>> cmd_check
Jun 30 11:26:28 mod_sql/4.11[5222]: checking auth_type Backend
Jun 30 11:26:28 mod_sql/4.11[5222]: entering    mysql cmd_checkauth
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_checkauth
Jun 30 11:26:28 mod_sql/4.11[5222]: checking auth_type Plaintext
Jun 30 11:26:28 mod_sql/4.11[5222]: <<< cmd_check
Jun 30 11:26:28 mod_sql/4.11[5222]: <<< cmd_auth
Jun 30 11:26:28 mod_sql/4.11[5222]: >>> cmd_check
Jun 30 11:26:28 mod_sql/4.11[5222]: checking auth_type Backend
Jun 30 11:26:28 mod_sql/4.11[5222]: entering    mysql cmd_checkauth
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_checkauth
Jun 30 11:26:28 mod_sql/4.11[5222]: checking auth_type Plaintext
Jun 30 11:26:28 mod_sql/4.11[5222]: <<< cmd_check
Jun 30 11:26:28 mod_sql/4.11[5222]: entering    mysql cmd_close
Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' closed
Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 0
Jun 30 11:26:28 mod_sql/4.11[5222]: exiting     mysql cmd_close


mir sagt das leider nicht viel, was hier steht  :?


Titel: proftpd + mysql, nur 1 user funktioniert! -.-
Beitrag von: stonki am 30. Juni 2005, 13:45:33
logge Dich mal mysql ein, und mache die Abfrage:

SELECT userid, passwd, uid, gid, homedir FROM users WHERE (userid='test');

poste mal das ergebnis hier:


Titel: proftpd + mysql, nur 1 user funktioniert! -.-
Beitrag von: Zipferl am 30. Juni 2005, 13:55:47
Code:

+--------+-------------------------------------------+-------+-------+---------+
| userid | passwd                                    | uid   | gid   | homedir |
+--------+-------------------------------------------+-------+-------+---------+
| test   | *E0EA3C55BFA00FCA9982220481B3602D89E0C8C8 | 10000 | 65534 | /home   |
+--------+-------------------------------------------+-------+-------+---------+
1 row in set (0.00 sec)


was ich mittlerweile auch mitbekommen habe ist, das die mysqlversion 4.1.12 passwörter irgendwie anders verschlüsselt oder so, allerdings wenn es daran liegt frag ich mich, warum ich mich mit einem account am ftp einloggen kann


Titel: proftpd + mysql, nur 1 user funktioniert! -.-
Beitrag von: stonki am 30. Juni 2005, 15:36:33
Zitat von: "Zipferl"
Code:

+--------+-------------------------------------------+-------+-------+---------+
| userid | passwd                                    | uid   | gid   | homedir |
+--------+-------------------------------------------+-------+-------+---------+
| test   | *E0EA3C55BFA00FCA9982220481B3602D89E0C8C8 | 10000 | 65534 | /home   |
+--------+-------------------------------------------+-------+-------+---------+
1 row in set (0.00 sec)


was ich mittlerweile auch mitbekommen habe ist, das die mysqlversion 4.1.12 passwörter irgendwie anders verschlüsselt oder so, allerdings wenn es daran liegt frag ich mich, warum ich mich mit einem account am ftp einloggen kann


existiert der andere account im System ? Wenn ja, dann wird das Password ggf. genommen. Also ich würde als password mal "test" eintragen und dann nochmal probieren. Ich denke, das liegt daran.

cu
stonki


Titel: proftpd + mysql, nur 1 user funktioniert! -.-
Beitrag von: Zipferl am 30. Juni 2005, 16:07:37
sobald ich das passwort änder komm ich gar nicht mehr rein


Titel: proftpd + mysql, nur 1 user funktioniert! -.-
Beitrag von: stonki am 30. Juni 2005, 18:17:50
Zitat von: "Zipferl"
sobald ich das passwort änder komm ich gar nicht mehr rein


darf denn der User ueberhaupt ins verzeichnis "/home/" von den Rechten ? Schau Dir IMMER das SQL und Debug Log an