hi Stonki,

wollte dich im chat treffen wegen root - bin allerdings nicht auf irc.efnet.org gekommen.

hier folgende logs:

das debugigng log:

mail - Config for ProFTPD:
mail - SQLAuthenticate
mail - SQLAuthTypes
mail - SQLGroupTable
mail - SQLGroupnameField
mail - SQLGroupGIDField
mail - SQLGroupMembersField
mail - SQLUserTable
mail - SQLUsernameField
mail - SQLPasswordField
mail - SQLUidField
mail - SQLGidField
mail - SQLHomedirField
mail - SQLShellField
mail - SQLConnectInfo
mail - SQLLogFile
mail - ProFTPD 1.2.9 (stable) (built Tue Jan 20 14:17:53 CET 2004) standalone mode STARTUP
mail (client[10.21.10.147]) - connected - local  : 10.21.10.245:21
mail (client-01[10.21.10.147]) - connected - remote : 10.21.10.147:37691
mail (client-01[10.21.10.147]) - FTP session opened.
mail (client-01[10.21.10.147]) - dispatching PRE_CMD command 'USER admin' to mod_tls
mail (client-01[10.21.10.147]) - dispatching PRE_CMD command 'USER admin' to mod_core
mail (client-01[10.21.10.147]) - dispatching PRE_CMD command 'USER admin' to mod_core
mail (client-01[10.21.10.147]) - dispatching PRE_CMD command 'USER admin' to mod_auth
mail (client-01[10.21.10.147]) - dispatching CMD command 'USER admin' to mod_auth
mail (client-01[10.21.10.147]) - ProFTPD terminating (signal 11)
mail (client-01[10.21.10.147]) - FTP session closed.

und hier das SQL Log:

Jan 21 09:24:39 mod_sql/4.10[27504]: backend module 'mod_sql_mysql/4.04'
Jan 21 09:24:39 mod_sql/4.10[27504]: backend api    'mod_sql_api_v1'
Jan 21 09:24:39 mod_sql/4.10[27504]: >>> sql_getconf
Jan 21 09:24:39 mod_sql/4.10[27504]: entering   mysql cmd_defineconnection
Jan 21 09:24:39 mod_sql/4.10[27504]:  name: 'default'
Jan 21 09:24:39 mod_sql/4.10[27504]:  user: 'proftpd'
Jan 21 09:24:39 mod_sql/4.10[27504]:  host: 'localhost'
Jan 21 09:24:39 mod_sql/4.10[27504]:    db: 'ftpauth'
Jan 21 09:24:39 mod_sql/4.10[27504]:  port: '3306'
Jan 21 09:24:39 mod_sql/4.10[27504]:   ttl: '0'
Jan 21 09:24:39 mod_sql/4.10[27504]: exiting    mysql cmd_defineconnection
Jan 21 09:24:39 mod_sql/4.10[27504]: backend will not be checked until first use.
Jan 21 09:24:39 mod_sql/4.10[27504]: mod_sql status     : on
Jan 21 09:24:39 mod_sql/4.10[27504]: negative_cache     : off
Jan 21 09:24:39 mod_sql/4.10[27504]: authenticate       : users groups userset groupset
Jan 21 09:24:39 mod_sql/4.10[27504]: usertable          : ftp
Jan 21 09:24:39 mod_sql/4.10[27504]: userid field       : username
Jan 21 09:24:39 mod_sql/4.10[27504]: password field     : password
Jan 21 09:24:39 mod_sql/4.10[27504]: uid field          : uid
Jan 21 09:24:39 mod_sql/4.10[27504]: gid field          : gid
Jan 21 09:24:39 mod_sql/4.10[27504]: homedir field      : homedir
Jan 21 09:24:39 mod_sql/4.10[27504]: shell field        : shell
Jan 21 09:24:39 mod_sql/4.10[27504]: homedirondemand    : false
Jan 21 09:24:39 mod_sql/4.10[27504]: group table        : groups
Jan 21 09:24:39 mod_sql/4.10[27504]: groupname field    : groupname
Jan 21 09:24:39 mod_sql/4.10[27504]: grp gid field      : gid
Jan 21 09:24:39 mod_sql/4.10[27504]: grp members field  : members
Jan 21 09:24:39 mod_sql/4.10[27504]: SQLMinUserUID      : 999
Jan 21 09:24:39 mod_sql/4.10[27504]: SQLMinUserGID      : 999
Jan 21 09:24:39 mod_sql/4.10[27504]: SQLDefaultUID      : 65533
Jan 21 09:24:39 mod_sql/4.10[27504]: SQLDefaultGID      : 65533
Jan 21 09:24:39 mod_sql/4.10[27504]: <<< sql_getconf
Jan 21 09:24:39 mod_sql/4.10[27504]: >>> cmd_endpwent
Jan 21 09:24:39 mod_sql/4.10[27504]: <<< cmd_endpwent
Jan 21 09:24:39 mod_sql/4.10[27504]: >>> cmd_endgrent
Jan 21 09:24:39 mod_sql/4.10[27504]: <<< cmd_endgrent
Jan 21 09:24:39 mod_sql/4.10[27504]: >>> cmd_getgroups
Jan 21 09:24:39 mod_sql/4.10[27504]: entering   mysql cmd_escapestring

meine tabellenstruktur sieht wie folgt aus:

mysql> use ftpauth;
Database changed
mysql> show tables;
+-------------------+
| Tables_in_ftpauth |
+-------------------+
| ftp               |
| groups            |
| xfer_stat         |
+-------------------+
3 rows in set (0.00 sec)

mysql> select * from ftp;
+----------+-------+------+----------+---------+-------+----+------------+---------------------+--------+
| username | uid   | gid  | password | homedir | count | ui | shell      | letzter_zugriff     | zugang |
+----------+-------+------+----------+---------+-------+----+------------+---------------------+--------+
| admin    | 25000 | 1950 | wwwan    | /tmp/   |  NULL |  1 | /bin/false | 2004-01-20 12:58:07 | NULL   |
+----------+-------+------+----------+---------+-------+----+------------+---------------------+--------+
1 row in set (0.00 sec)

mysql> select * from groups;
+-----------+------+---------+
| groupname | gid  | members |
+-----------+------+---------+
| BigBoss   | 1950 | admin   |
+-----------+------+---------+
1 row in set (0.00 sec)

hilft dir das nen bischen weiter??

Danke!

MfG

Peter

hi, ich nochmal

so, ich habe mich ein wenig gespielt, und alle befehle laut anleitung neu zusammengeschrieben und angepasst, funzt aber immer noch nicht ;(

das SQL Log sagt folgendes:

Jan 20 19:36:04 mod_sql/4.10[22108]: backend module 'mod_sql_mysql/4.04'
Jan 20 19:36:04 mod_sql/4.10[22108]: backend api    'mod_sql_api_v1'
Jan 20 19:36:04 mod_sql/4.10[22108]: >>> sql_getconf
Jan 20 19:36:04 mod_sql/4.10[22108]: entering   mysql cmd_defineconnection
Jan 20 19:36:04 mod_sql/4.10[22108]:  name: 'default'
Jan 20 19:36:04 mod_sql/4.10[22108]:  user: 'proftpd'
Jan 20 19:36:04 mod_sql/4.10[22108]:  host: 'localhost'
Jan 20 19:36:04 mod_sql/4.10[22108]:    db: 'ftpauth'
Jan 20 19:36:04 mod_sql/4.10[22108]:  port: '3306'
Jan 20 19:36:04 mod_sql/4.10[22108]:   ttl: '0'
Jan 20 19:36:04 mod_sql/4.10[22108]: exiting    mysql cmd_defineconnection
Jan 20 19:36:04 mod_sql/4.10[22108]: backend will not be checked until first use.
Jan 20 19:36:04 mod_sql/4.10[22108]: mod_sql status     : on
Jan 20 19:36:04 mod_sql/4.10[22108]: negative_cache     : off
Jan 20 19:36:04 mod_sql/4.10[22108]: authenticate       : users groups userset groupset
Jan 20 19:36:04 mod_sql/4.10[22108]: usertable          : ftp
Jan 20 19:36:04 mod_sql/4.10[22108]: userid field       : username
Jan 20 19:36:04 mod_sql/4.10[22108]: password field     : password
Jan 20 19:36:04 mod_sql/4.10[22108]: uid field          : uid
Jan 20 19:36:04 mod_sql/4.10[22108]: gid field          : gid
Jan 20 19:36:04 mod_sql/4.10[22108]: homedir field      : homedir
Jan 20 19:36:04 mod_sql/4.10[22108]: shell field        : shell
Jan 20 19:36:04 mod_sql/4.10[22108]: homedirondemand    : false
Jan 20 19:36:04 mod_sql/4.10[22108]: group table        : groups
Jan 20 19:36:04 mod_sql/4.10[22108]: groupname field    : groupname
Jan 20 19:36:04 mod_sql/4.10[22108]: grp gid field      : gid
Jan 20 19:36:04 mod_sql/4.10[22108]: grp members field  : members
Jan 20 19:36:04 mod_sql/4.10[22108]: SQLMinUserUID      : 999
Jan 20 19:36:04 mod_sql/4.10[22108]: SQLMinUserGID      : 999
Jan 20 19:36:04 mod_sql/4.10[22108]: SQLDefaultUID      : 65533
Jan 20 19:36:04 mod_sql/4.10[22108]: SQLDefaultGID      : 65533
Jan 20 19:36:04 mod_sql/4.10[22108]: <<< sql_getconf
Jan 20 19:36:04 mod_sql/4.10[22108]: >>> cmd_endpwent
Jan 20 19:36:04 mod_sql/4.10[22108]: <<< cmd_endpwent
Jan 20 19:36:04 mod_sql/4.10[22108]: >>> cmd_endgrent
Jan 20 19:36:04 mod_sql/4.10[22108]: <<< cmd_endgrent
Jan 20 19:36:04 mod_sql/4.10[22108]: >>> cmd_getgroups
Jan 20 19:36:04 mod_sql/4.10[22108]: entering   mysql cmd_escapestring

das Verbose folgendes:

mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - performing ident lookup
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - ident connection failed: Connection refused
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - ident lookup returned 'UNKNOWN'
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - performing module session initializations
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - ROOT PRIVS at mod_sql.c:3630
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - RELINQUISH PRIVS at mod_sql.c:3632
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - ROOT PRIVS at mod_auth.c:130
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - opening scoreboard '/usr/local/var/proftpd/proftpd.scoreboard'
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - RELINQUISH PRIVS at mod_auth.c:150
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - connected - local  : 62.245.169.245:21
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - connected - remote : 217.233.30.16:4038
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - FTP session opened.
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - dispatching PRE_CMD command 'USER admin' to mod_tls
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - dispatching PRE_CMD command 'USER admin' to mod_core
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - dispatching PRE_CMD command 'USER admin' to mod_core
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - dispatching PRE_CMD command 'USER admin' to mod_auth
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - dispatching auth request "endpwent" to module mod_sql
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - dispatching auth request "endpwent" to module mod_auth_file
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - dispatching auth request "endpwent" to module mod_auth_unix
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - dispatching auth request "endgrent" to module mod_sql
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - dispatching auth request "endgrent" to module mod_auth_file
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - dispatching auth request "endgrent" to module mod_auth_unix
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - dispatching CMD command 'USER admin' to mod_auth
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - dispatching auth request "getgroups" to module mod_sql
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - ProFTPD terminating (signal 11)
mail (pD9E91E10.dip.t-dialin.net[217.233.30.16]) - FTP session closed.

das kommt beim einloggen:

Connected to mail Port 21
220 ProFTPD 1.2.9 Server (ProFTPD) [mail]
USER admin
Connection failed (Connection lost)

Jez ne idee?
vom "haircutter" schon zurück?

MFG

Peter

Hi,

also, ohne sql mit unix authentifizierung kann ich mich problemlos anmelden.
läuft alles.

nur seit dem ich sql einsetzen will, streikt er.

wenn ich alles ausser SQL rausnehme, kommt das selbe in blau - nein, eigentlich genau das selbe ;(


bin ratlos ;(

Mfg

Peter