User erhält nicht die Gruppenberechtigung?

[Jens]

Hi,

ich habe mehrere User erstellt, die auch in verschiedenen Gruppen drin sind.

Gebe ich in der proftpd.conf einem User Rechte, hat er diese auch, wenn er sich per FTP anmeldet.

Gebe ich einer Gruppe bestimmte Rechte, hat der User diese NICHT, wenn er sich per FTP anmeldet.

Verwaltung erfolgt unter Debian Woody mit MySQL und MyFTPAdmin.

Ich habe von einem Bug in dem Installationpaket gelesen, ist das der Bug?
Soweit ich das verstanden habe, würde der FTP Daemon sich beenden, was er bei mir ja nicht tut.

Gruß, Jens.

[stonki]

poste bitte mal ein genaues Beispiel... inkl. Debug Ausgabe

[Technobabel]

hab das gleiche problem und verzweifle mittlerweile etwas

kurze umfeldangabe:
proftp mit mod_sql, mysql 4.0.18 auf suse 9.1 dazu den MyFTPAdmin zur schöneren User/Gruppen Anlage und der allgemeinen Verwaltung.

lt. MyFTPAdmin sind die angelegten User auch in den einzellnen Gruppen (siehe auch sqllog)

Jul 20 18:04:08 mod_sql/4.10[20803]: backend module 'mod_sql_mysql/4.04'
Jul 20 18:04:08 mod_sql/4.10[20803]: backend api    'mod_sql_api_v1'
Jul 20 18:04:08 mod_sql/4.10[20803]: >>> sql_getconf
Jul 20 18:04:08 mod_sql/4.10[20803]: entering    mysql cmd_defineconnection
Jul 20 18:04:08 mod_sql/4.10[20803]:  name: 'default'
Jul 20 18:04:08 mod_sql/4.10[20803]:  user: 'root'
Jul 20 18:04:08 mod_sql/4.10[20803]:  host: 'localhost'
Jul 20 18:04:08 mod_sql/4.10[20803]:    db: 'ftp'
Jul 20 18:04:08 mod_sql/4.10[20803]:  port: '3306'
Jul 20 18:04:08 mod_sql/4.10[20803]:   ttl: '0'
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_defineconnection
Jul 20 18:04:08 mod_sql/4.10[20803]: entering    mysql cmd_open
Jul 20 18:04:08 mod_sql/4.10[20803]: connection 'default' opened
Jul 20 18:04:08 mod_sql/4.10[20803]: connection 'default' count is now 1
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_open
Jul 20 18:04:08 mod_sql/4.10[20803]: backend successfully connected.
Jul 20 18:04:08 mod_sql/4.10[20803]: mod_sql status     : on
Jul 20 18:04:08 mod_sql/4.10[20803]: negative_cache     : off
Jul 20 18:04:08 mod_sql/4.10[20803]: authenticate       : users* groups*
Jul 20 18:04:08 mod_sql/4.10[20803]: usertable          : users
Jul 20 18:04:08 mod_sql/4.10[20803]: userid field       : username
Jul 20 18:04:08 mod_sql/4.10[20803]: password field     : passwd
Jul 20 18:04:08 mod_sql/4.10[20803]: uid field          : NULL
Jul 20 18:04:08 mod_sql/4.10[20803]: gid field          : NULL
Jul 20 18:04:08 mod_sql/4.10[20803]: homedir field      : homedir
Jul 20 18:04:08 mod_sql/4.10[20803]: shell field        : NULL
Jul 20 18:04:08 mod_sql/4.10[20803]: homedirondemand    : false
Jul 20 18:04:08 mod_sql/4.10[20803]: group table        : groups
Jul 20 18:04:08 mod_sql/4.10[20803]: groupname field    : groupname
Jul 20 18:04:08 mod_sql/4.10[20803]: grp gid field      : id
Jul 20 18:04:08 mod_sql/4.10[20803]: grp members field  : username
Jul 20 18:04:08 mod_sql/4.10[20803]: SQLMinUserUID      : 999
Jul 20 18:04:08 mod_sql/4.10[20803]: SQLMinUserGID      : 999
Jul 20 18:04:08 mod_sql/4.10[20803]: SQLDefaultUID      : 500
Jul 20 18:04:08 mod_sql/4.10[20803]: SQLDefaultGID      : 100
Jul 20 18:04:08 mod_sql/4.10[20803]: <<< sql_getconf
Jul 20 18:04:08 mod_sql/4.10[20803]: >>> cmd_getgroups
Jul 20 18:04:08 mod_sql/4.10[20803]: entering    mysql cmd_escapestring
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_escapestring
Jul 20 18:04:08 mod_sql/4.10[20803]: cache miss for user 'ftpuser'
Jul 20 18:04:08 mod_sql/4.10[20803]: : entering    mysql cmd_select
Jul 20 18:04:08 mod_sql/4.10[20803]: entering    mysql cmd_open
Jul 20 18:04:08 mod_sql/4.10[20803]: connection 'default' count is now 2
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_open
Jul 20 18:04:08 mod_sql/4.10[20803]: query "SELECT username, passwd, homedir FROM users WHERE (username='ftpuser') and ((valid = 1)) LIMIT 1"
Jul 20 18:04:08 mod_sql/4.10[20803]: entering    mysql cmd_close
Jul 20 18:04:08 mod_sql/4.10[20803]: connection 'default' count is now 1
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_close
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_select
Jul 20 18:04:08 mod_sql/4.10[20803]: cache miss for user 'ftpuser'
Jul 20 18:04:08 mod_sql/4.10[20803]: user 'ftpuser' cached
Jul 20 18:04:08 mod_sql/4.10[20803]: + pwd.pw_name  : ftpuser
Jul 20 18:04:08 mod_sql/4.10[20803]: + pwd.pw_uid   : 500
Jul 20 18:04:08 mod_sql/4.10[20803]: + pwd.pw_gid   : 100
Jul 20 18:04:08 mod_sql/4.10[20803]: + pwd.pw_dir   : /ftpdaten
Jul 20 18:04:08 mod_sql/4.10[20803]: + pwd.pw_shell :
Jul 20 18:04:08 mod_sql/4.10[20803]: cache miss for gid '100'
Jul 20 18:04:08 mod_sql/4.10[20803]: : entering    mysql cmd_select
Jul 20 18:04:08 mod_sql/4.10[20803]: entering    mysql cmd_open
Jul 20 18:04:08 mod_sql/4.10[20803]: connection 'default' count is now 2
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_open
Jul 20 18:04:08 mod_sql/4.10[20803]: query "SELECT groupname FROM groups WHERE (id = 100) LIMIT 1"
Jul 20 18:04:08 mod_sql/4.10[20803]: entering    mysql cmd_close
Jul 20 18:04:08 mod_sql/4.10[20803]: connection 'default' count is now 1
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_close
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_select
Jul 20 18:04:08 mod_sql/4.10[20803]: : entering    mysql cmd_select
Jul 20 18:04:08 mod_sql/4.10[20803]: entering    mysql cmd_open
Jul 20 18:04:08 mod_sql/4.10[20803]: connection 'default' count is now 2
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_open
Jul 20 18:04:08 mod_sql/4.10[20803]: query "SELECT groupname, id, username FROM groups WHERE (username = 'ftpuser' OR username LIKE 'ftpuser,%' OR username LIKE '%,ftpuser' OR username LIKE '%,ftpuser,%')"
Jul 20 18:04:08 mod_sql/4.10[20803]: entering    mysql cmd_close
Jul 20 18:04:08 mod_sql/4.10[20803]: connection 'default' count is now 1
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_close
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_select
Jul 20 18:04:08 mod_sql/4.10[20803]: cache miss for group 'Kunden'
Jul 20 18:04:08 mod_sql/4.10[20803]: group 'Kunden' cached
Jul 20 18:04:08 mod_sql/4.10[20803]: + grp.gr_name : Kunden
Jul 20 18:04:08 mod_sql/4.10[20803]: + grp.gr_gid  : 70
Jul 20 18:04:08 mod_sql/4.10[20803]: + grp.gr_mem  : ftpuser
Jul 20 18:04:08 mod_sql/4.10[20803]: cache miss for group 'admin'
Jul 20 18:04:08 mod_sql/4.10[20803]: group 'admin' cached
Jul 20 18:04:08 mod_sql/4.10[20803]: + grp.gr_name : admin
Jul 20 18:04:08 mod_sql/4.10[20803]: + grp.gr_gid  : 69
Jul 20 18:04:08 mod_sql/4.10[20803]: + grp.gr_mem  : ftpuser
Jul 20 18:04:08 mod_sql/4.10[20803]: cache miss for group 'Public'
Jul 20 18:04:08 mod_sql/4.10[20803]: group 'Public' cached
Jul 20 18:04:08 mod_sql/4.10[20803]: + grp.gr_name : Public
Jul 20 18:04:08 mod_sql/4.10[20803]: + grp.gr_gid  : 71
Jul 20 18:04:08 mod_sql/4.10[20803]: + grp.gr_mem  : ftpuser
Jul 20 18:04:08 mod_sql/4.10[20803]: <<< cmd_getgroups
Jul 20 18:04:08 mod_sql/4.10[20803]: >>> cmd_getpwnam
Jul 20 18:04:08 mod_sql/4.10[20803]: cache hit for user 'ftpuser'
Jul 20 18:04:08 mod_sql/4.10[20803]: <<< cmd_getpwnam
Jul 20 18:04:08 mod_sql/4.10[20803]: >>> cmd_getpwnam
Jul 20 18:04:08 mod_sql/4.10[20803]: cache hit for user 'ftpuser'
Jul 20 18:04:08 mod_sql/4.10[20803]: <<< cmd_getpwnam
Jul 20 18:04:08 mod_sql/4.10[20803]: >>> cmd_getgrgid
Jul 20 18:04:08 mod_sql/4.10[20803]: cache miss for gid '100'
Jul 20 18:04:08 mod_sql/4.10[20803]: : entering    mysql cmd_select
Jul 20 18:04:08 mod_sql/4.10[20803]: entering    mysql cmd_open
Jul 20 18:04:08 mod_sql/4.10[20803]: connection 'default' count is now 2
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_open
Jul 20 18:04:08 mod_sql/4.10[20803]: query "SELECT groupname FROM groups WHERE (id = 100) LIMIT 1"
Jul 20 18:04:08 mod_sql/4.10[20803]: entering    mysql cmd_close
Jul 20 18:04:08 mod_sql/4.10[20803]: connection 'default' count is now 1
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_close
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_select
Jul 20 18:04:08 mod_sql/4.10[20803]: <<< cmd_getgrgid
Jul 20 18:04:08 mod_sql/4.10[20803]: >>> cmd_getpwnam
Jul 20 18:04:08 mod_sql/4.10[20803]: cache hit for user 'ftpuser'
Jul 20 18:04:08 mod_sql/4.10[20803]: <<< cmd_getpwnam
Jul 20 18:04:08 mod_sql/4.10[20803]: >>> cmd_gid2name
Jul 20 18:04:08 mod_sql/4.10[20803]: cache miss for gid '100'
Jul 20 18:04:08 mod_sql/4.10[20803]: : entering    mysql cmd_select
Jul 20 18:04:08 mod_sql/4.10[20803]: entering    mysql cmd_open
Jul 20 18:04:08 mod_sql/4.10[20803]: connection 'default' count is now 2
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_open
Jul 20 18:04:08 mod_sql/4.10[20803]: query "SELECT groupname FROM groups WHERE (id = 100) LIMIT 1"
Jul 20 18:04:08 mod_sql/4.10[20803]: entering    mysql cmd_close
Jul 20 18:04:08 mod_sql/4.10[20803]: connection 'default' count is now 1
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_close
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_select
Jul 20 18:04:08 mod_sql/4.10[20803]: <<< cmd_gid2name
Jul 20 18:04:08 mod_sql/4.10[20803]: >>> cmd_auth
Jul 20 18:04:08 mod_sql/4.10[20803]: entering    mysql cmd_escapestring
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_escapestring
Jul 20 18:04:08 mod_sql/4.10[20803]: cache hit for user 'ftpuser'
Jul 20 18:04:08 mod_sql/4.10[20803]: >>> cmd_check
Jul 20 18:04:08 mod_sql/4.10[20803]: checking auth_type Crypt
Jul 20 18:04:08 mod_sql/4.10[20803]: 'Crypt' auth handler reports success
Jul 20 18:04:08 mod_sql/4.10[20803]: cache hit for user 'ftpuser'
Jul 20 18:04:08 mod_sql/4.10[20803]: <<< cmd_check
Jul 20 18:04:08 mod_sql/4.10[20803]: <<< cmd_auth
Jul 20 18:04:08 mod_sql/4.10[20803]: >>> log_master
Jul 20 18:04:08 mod_sql/4.10[20803]: >>> _process_named_query
Jul 20 18:04:08 mod_sql/4.10[20803]: entering    mysql cmd_escapestring
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_escapestring
Jul 20 18:04:08 mod_sql/4.10[20803]: entering    mysql cmd_update
Jul 20 18:04:08 mod_sql/4.10[20803]: entering    mysql cmd_open
Jul 20 18:04:08 mod_sql/4.10[20803]: connection 'default' count is now 2
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_open
Jul 20 18:04:08 mod_sql/4.10[20803]: query "UPDATE users SET count=count+1, lastlogin=NOW() WHERE username = 'ftpuser'"
Jul 20 18:04:08 mod_sql/4.10[20803]: entering    mysql cmd_close
Jul 20 18:04:08 mod_sql/4.10[20803]: connection 'default' count is now 1
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_close
Jul 20 18:04:08 mod_sql/4.10[20803]: exiting    mysql cmd_update
Jul 20 18:04:08 mod_sql/4.10[20803]: <<< _process_named_query
Jul 20 18:04:08 mod_sql/4.10[20803]: <<< log_master
Jul 20 18:04:09 mod_sql/4.10[20803]: >>> cmd_gid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: cache miss for gid '0'
Jul 20 18:04:09 mod_sql/4.10[20803]: : entering    mysql cmd_select
Jul 20 18:04:09 mod_sql/4.10[20803]: entering    mysql cmd_open
Jul 20 18:04:09 mod_sql/4.10[20803]: connection 'default' count is now 2
Jul 20 18:04:09 mod_sql/4.10[20803]: exiting    mysql cmd_open
Jul 20 18:04:09 mod_sql/4.10[20803]: query "SELECT groupname FROM groups WHERE (id = 0) LIMIT 1"
Jul 20 18:04:09 mod_sql/4.10[20803]: entering    mysql cmd_close
Jul 20 18:04:09 mod_sql/4.10[20803]: connection 'default' count is now 1
Jul 20 18:04:09 mod_sql/4.10[20803]: exiting    mysql cmd_close
Jul 20 18:04:09 mod_sql/4.10[20803]: exiting    mysql cmd_select
Jul 20 18:04:09 mod_sql/4.10[20803]: <<< cmd_gid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: >>> cmd_uid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: cache miss for uid '0'
Jul 20 18:04:09 mod_sql/4.10[20803]: no user uid field configured, declining to lookup uid '0'
Jul 20 18:04:09 mod_sql/4.10[20803]: <<< cmd_uid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: >>> cmd_gid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: cache miss for gid '0'
Jul 20 18:04:09 mod_sql/4.10[20803]: : entering    mysql cmd_select
Jul 20 18:04:09 mod_sql/4.10[20803]: entering    mysql cmd_open
Jul 20 18:04:09 mod_sql/4.10[20803]: connection 'default' count is now 2
Jul 20 18:04:09 mod_sql/4.10[20803]: exiting    mysql cmd_open
Jul 20 18:04:09 mod_sql/4.10[20803]: query "SELECT groupname FROM groups WHERE (id = 0) LIMIT 1"
Jul 20 18:04:09 mod_sql/4.10[20803]: entering    mysql cmd_close
Jul 20 18:04:09 mod_sql/4.10[20803]: connection 'default' count is now 1
Jul 20 18:04:09 mod_sql/4.10[20803]: exiting    mysql cmd_close
Jul 20 18:04:09 mod_sql/4.10[20803]: exiting    mysql cmd_select
Jul 20 18:04:09 mod_sql/4.10[20803]: <<< cmd_gid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: >>> cmd_uid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: cache miss for uid '0'
Jul 20 18:04:09 mod_sql/4.10[20803]: no user uid field configured, declining to lookup uid '0'
Jul 20 18:04:09 mod_sql/4.10[20803]: <<< cmd_uid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: >>> cmd_gid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: cache miss for gid '100'
Jul 20 18:04:09 mod_sql/4.10[20803]: : entering    mysql cmd_select
Jul 20 18:04:09 mod_sql/4.10[20803]: entering    mysql cmd_open
Jul 20 18:04:09 mod_sql/4.10[20803]: connection 'default' count is now 2
Jul 20 18:04:09 mod_sql/4.10[20803]: exiting    mysql cmd_open
Jul 20 18:04:09 mod_sql/4.10[20803]: query "SELECT groupname FROM groups WHERE (id = 100) LIMIT 1"
Jul 20 18:04:09 mod_sql/4.10[20803]: entering    mysql cmd_close
Jul 20 18:04:09 mod_sql/4.10[20803]: connection 'default' count is now 1
Jul 20 18:04:09 mod_sql/4.10[20803]: exiting    mysql cmd_close
Jul 20 18:04:09 mod_sql/4.10[20803]: exiting    mysql cmd_select
Jul 20 18:04:09 mod_sql/4.10[20803]: <<< cmd_gid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: >>> cmd_uid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: matched current user
Jul 20 18:04:09 mod_sql/4.10[20803]: <<< cmd_uid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: >>> cmd_gid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: cache miss for gid '100'
Jul 20 18:04:09 mod_sql/4.10[20803]: : entering    mysql cmd_select
Jul 20 18:04:09 mod_sql/4.10[20803]: entering    mysql cmd_open
Jul 20 18:04:09 mod_sql/4.10[20803]: connection 'default' count is now 2
Jul 20 18:04:09 mod_sql/4.10[20803]: exiting    mysql cmd_open
Jul 20 18:04:09 mod_sql/4.10[20803]: query "SELECT groupname FROM groups WHERE (id = 100) LIMIT 1"
Jul 20 18:04:09 mod_sql/4.10[20803]: entering    mysql cmd_close
Jul 20 18:04:09 mod_sql/4.10[20803]: connection 'default' count is now 1
Jul 20 18:04:09 mod_sql/4.10[20803]: exiting    mysql cmd_close
Jul 20 18:04:09 mod_sql/4.10[20803]: exiting    mysql cmd_select
Jul 20 18:04:09 mod_sql/4.10[20803]: <<< cmd_gid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: >>> cmd_uid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: matched current user
Jul 20 18:04:09 mod_sql/4.10[20803]: <<< cmd_uid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: >>> cmd_gid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: cache miss for gid '0'
Jul 20 18:04:09 mod_sql/4.10[20803]: : entering    mysql cmd_select
Jul 20 18:04:09 mod_sql/4.10[20803]: entering    mysql cmd_open
Jul 20 18:04:09 mod_sql/4.10[20803]: connection 'default' count is now 2
Jul 20 18:04:09 mod_sql/4.10[20803]: exiting    mysql cmd_open
Jul 20 18:04:09 mod_sql/4.10[20803]: query "SELECT groupname FROM groups WHERE (id = 0) LIMIT 1"
Jul 20 18:04:09 mod_sql/4.10[20803]: entering    mysql cmd_close
Jul 20 18:04:09 mod_sql/4.10[20803]: connection 'default' count is now 1
Jul 20 18:04:09 mod_sql/4.10[20803]: exiting    mysql cmd_close
Jul 20 18:04:09 mod_sql/4.10[20803]: exiting    mysql cmd_select
Jul 20 18:04:09 mod_sql/4.10[20803]: <<< cmd_gid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: >>> cmd_uid2name
Jul 20 18:04:09 mod_sql/4.10[20803]: cache miss for uid '0'
Jul 20 18:04:09 mod_sql/4.10[20803]: no user uid field configured, declining to lookup uid '0'
Jul 20 18:04:09 mod_sql/4.10[20803]: <<< cmd_uid2name

kann mich auch ganz sauber einloggen
(siehe fptd log)

rz008:/ftpdaten # proftpd -n -d9
 - parsing '/etc/proftpd.conf' configuration
 - FS: using system open()
 - FS: using system read()
 - dispatching auth request "getpwnam" to module mod_sql
 - dispatching auth request "getpwnam" to module mod_auth_file
 - dispatching auth request "getpwnam" to module mod_auth_unix
 - dispatching auth request "getgrnam" to module mod_sql
 - dispatching auth request "getgrnam" to module mod_auth_file
 - dispatching auth request "getgrnam" to module mod_auth_unix
 - FS: using system read()
 - <Directory /ftpdaten>: adding section for resolved path '/ftpdaten'
 - <Directory /ftpdaten/Admin/>: adding section for resolved path '/ftpdaten/Admin'
 - FS: using system read()
 - FS: using system close()
* -
* - Config for - Welcome to FTP Server -:
* - /ftpdaten
* -  /ftpdaten/Admin
* -   Limit
* -    DenyAll
* -    AllowGroup
* -   Umask
* -   SQLAuthTypes
* -   SQLAuthenticate
* -   SQLConnectInfo
* -   SQLDefaultGID
* -   SQLDefaultUID
* -   SQLHomedirOnDemand
* -   RequireValidShell
* -   SQLLog_PASS
* -   SQLNamedQuery_updatelogin
* -   SQLLog_STOR
* -   SQLLog_RETR
* -   SQLLog_ERR_STOR
* -   SQLLog_ERR_RETR
* -   SQLNamedQuery_logtrafic
* -   SQLLog_ERR_*
* -   SQLNamedQuery_logevents
* -   RootLogin
* -   AllowRetrieveRestart
* -   AllowStoreRestart
* -   MaxClientsPerHost
* -   AllowOverwrite
* -  Limit
* -   DenyAll
* -  Umask
* -  SQLAuthTypes
* -  SQLAuthenticate
* -  SQLConnectInfo
* -  SQLDefaultGID
* -  SQLDefaultUID
* -  SQLHomedirOnDemand
* -  RequireValidShell
* -  SQLLog_PASS
* -  SQLNamedQuery_updatelogin
* -  SQLLog_STOR
* -  SQLLog_RETR
* -  SQLLog_ERR_STOR
* -  SQLLog_ERR_RETR
* -  SQLNamedQuery_logtrafic
* -  SQLLog_ERR_*
* -  SQLNamedQuery_logevents
* -  RootLogin
* -  AllowRetrieveRestart
* -  AllowStoreRestart
* -  MaxClientsPerHost
* -  AllowOverwrite
* - DefaultServer
* - Umask
* - UserID
* - UserName
* - GroupID
* - GroupName
* - SQLAuthTypes
* - SQLAuthenticate
* - SQLConnectInfo
* - SQLUserTable
* - SQLUsernameField
* - SQLPasswordField
* - SQLHomedirField
* - SQLGroupTable
* - SQLGroupnameField
* - SQLGroupGIDField
* - SQLGroupMembersField
* - SQLUserWhereClause
* - SQLDefaultGID
* - SQLDefaultUID
* - SQLHomedirOnDemand
* - RequireValidShell
* - SQLLog_PASS
* - SQLLogFile
* - SQLNamedQuery_updatelogin
* - SQLLog_STOR
* - SQLLog_RETR
* - SQLLog_ERR_STOR
* - SQLLog_ERR_RETR
* - SQLNamedQuery_logtrafic
* - SQLLog_ERR_*
* - SQLNamedQuery_logevents
* - RootLogin
* - Bind
* - AllowRetrieveRestart
* - AllowStoreRestart
* - MaxClientsPerHost
* - AllowOverwrite
* - DefaultRoot
* - dispatching auth request "getgroups" to module mod_sql
* - dispatching auth request "getgroups" to module mod_auth_file
* - dispatching auth request "getgroups" to module mod_auth_unix
* - SETUP PRIVS at main.c:2704
* - ROOT PRIVS at main.c:1956
* - RELINQUISH PRIVS at main.c:1962
* - ROOT PRIVS at main.c:2323
* - opening scoreboard '/var/run/proftpd/proftpd.scoreboard'
* - RELINQUISH PRIVS at main.c:2347
* - ROOT PRIVS at inet.c:452
* - RELINQUISH PRIVS at inet.c:510
* - ProFTPD 1.2.9 (stable) (built Thu Dec 11 19:40:19 CET 2003) standalone mode STARTUP
* - ROOT PRIVS at main.c:2171
* - RELINQUISH PRIVS at main.c:2177
* - FS: using system lstat()
* - ROOT PRIVS at main.c:1150
* - RELINQUISH PRIVS at main.c:1154
* - FS: using system lstat()
* - FS: using system lstat()
* - ROOT PRIVS at main.c:1150
* - RELINQUISH PRIVS at main.c:1154
* - FS: using system lstat()
* - FS: using system lstat()
* performing ident lookup
* ident connection failed: Connection refused
* ident lookup returned 'UNKNOWN'
* ROOT PRIVS at main.c:977
* SETUP PRIVS at main.c:982
* performing module session initializations
* ROOT PRIVS at mod_sql.c:3630
* RELINQUISH PRIVS at mod_sql.c:3632
* ROOT PRIVS at mod_auth.c:130
* opening scoreboard '/var/run/proftpd/proftpd.scoreboard'
* RELINQUISH PRIVS at mod_auth.c:150
* connected - local  : *.*.*.*:21
* connected - remote : *.*.*.*:5541
* FTP session opened.
* dispatching auth request "endpwent" to module mod_sql
* dispatching auth request "endgrent" to module mod_sql
* FTP session closed.
* - FS: using system lstat()
* - scrubbing scoreboard
* - ROOT PRIVS at mod_core.c:194
* - RELINQUISH PRIVS at mod_core.c:201
* - ROOT PRIVS at mod_core.c:223
* - RELINQUISH PRIVS at mod_core.c:251
* - FS: using system lstat()
* performing ident lookup
* scrubbing scoreboard
* ROOT PRIVS at mod_core.c:194
* RELINQUISH PRIVS at mod_core.c:201
* ROOT PRIVS at mod_core.c:223
* RELINQUISH PRIVS at mod_core.c:251
* ident connection failed: Connection refused
* ident lookup returned 'UNKNOWN'
* ROOT PRIVS at main.c:977
* SETUP PRIVS at main.c:982
* performing module session initializations
* ROOT PRIVS at mod_sql.c:3630
* RELINQUISH PRIVS at mod_sql.c:3632
* ROOT PRIVS at mod_auth.c:130
* opening scoreboard '/var/run/proftpd/proftpd.scoreboard'
* RELINQUISH PRIVS at mod_auth.c:150
* connected - local  : *.*.*.*:21
* connected - remote : *.*.*.*:5542
* FTP session opened.
* - FS: using system lstat()
* - scrubbing scoreboard
* - ROOT PRIVS at mod_core.c:194
* - RELINQUISH PRIVS at mod_core.c:201
* - ROOT PRIVS at mod_core.c:223
* - RELINQUISH PRIVS at mod_core.c:251
* - FS: using system lstat()
* dispatching PRE_CMD command 'USER ftpuser' to mod_time
* dispatching PRE_CMD command 'USER ftpuser' to mod_core
* dispatching PRE_CMD command 'USER ftpuser' to mod_core
* dispatching PRE_CMD command 'USER ftpuser' to mod_auth
* dispatching auth request "endpwent" to module mod_sql
* dispatching auth request "endgrent" to module mod_sql
* dispatching CMD command 'USER ftpuser' to mod_ratio
* dispatching CMD command 'USER ftpuser' to mod_auth
* dispatching auth request "getgroups" to module mod_sql
* dispatching POST_CMD command 'USER ftpuser' to mod_sql
* dispatching LOG_CMD command 'USER ftpuser' to mod_sql
* dispatching LOG_CMD command 'USER ftpuser' to mod_log
* dispatching PRE_CMD command 'PASS (hidden)' to mod_time
* dispatching PRE_CMD command 'PASS (hidden)' to mod_core
* dispatching PRE_CMD command 'PASS (hidden)' to mod_core
* dispatching PRE_CMD command 'PASS (hidden)' to mod_time
* dispatching auth request "getpwnam" to module mod_sql
* dispatching auth request "getpwnam" to module mod_sql
* dispatching auth request "getgrgid" to module mod_sql
* no such GID '100'
* dispatching auth request "setgrent" to module mod_sql
* dispatching auth request "getgrent" to module mod_sql
* mod_time/2.2: login allowed by configuration
* dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap
* dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
* dispatching auth request "endpwent" to module mod_sql
* dispatching auth request "endgrent" to module mod_sql
* dispatching CMD command 'PASS (hidden)' to mod_auth
* dispatching auth request "getpwnam" to module mod_sql
* dispatching auth request "gid_name" to module mod_sql
* dispatching auth request "auth" to module mod_sql
* dispatching auth request "check" to module mod_sql
* dispatching auth request "setgrent" to module mod_sql
* ROOT PRIVS at mod_auth.c:550
* RELINQUISH PRIVS at mod_auth.c:552
* USER PRIVS 500 at mod_auth.c:1103
* RELINQUISH PRIVS at mod_auth.c:1105
*
* Config for - Welcome to FTP Server -:
* /ftpdaten
*  /ftpdaten/Admin
*   Limit
*    DenyAll
*    AllowGroup
*   Umask
*   SQLAuthTypes
*   SQLAuthenticate
*   SQLConnectInfo
*   SQLDefaultGID
*   SQLDefaultUID
*   SQLHomedirOnDemand
*   RequireValidShell
*   SQLLog_PASS
*   SQLNamedQuery_updatelogin
*   SQLLog_STOR
*   SQLLog_RETR
*   SQLLog_ERR_STOR
*   SQLLog_ERR_RETR
*   SQLNamedQuery_logtrafic
*   SQLLog_ERR_*
*   SQLNamedQuery_logevents
*   RootLogin
*   AllowRetrieveRestart
*   AllowStoreRestart
*   MaxClientsPerHost
*   AllowOverwrite
*  Limit
*   DenyAll
*  Umask
*  SQLAuthTypes
*  SQLAuthenticate
*  SQLConnectInfo
*  SQLDefaultGID
*  SQLDefaultUID
*  SQLHomedirOnDemand
*  RequireValidShell
*  SQLLog_PASS
*  SQLNamedQuery_updatelogin
*  SQLLog_STOR
*  SQLLog_RETR
*  SQLLog_ERR_STOR
*  SQLLog_ERR_RETR
*  SQLNamedQuery_logtrafic
*  SQLLog_ERR_*
*  SQLNamedQuery_logevents
*  RootLogin
*  AllowRetrieveRestart
*  AllowStoreRestart
*  MaxClientsPerHost
*  AllowOverwrite
* DefaultServer
* Umask
* UserID
* UserName
* GroupID
* GroupName
* SQLAuthTypes
* SQLAuthenticate
* SQLConnectInfo
* SQLUserTable
* SQLUsernameField
* SQLPasswordField
* SQLHomedirField
* SQLGroupTable
* SQLGroupnameField
* SQLGroupGIDField
* SQLGroupMembersField
* SQLUserWhereClause
* SQLDefaultGID
* SQLDefaultUID
* SQLHomedirOnDemand
* RequireValidShell
* SQLLog_PASS
* SQLLogFile
* SQLNamedQuery_updatelogin
* SQLLog_STOR
* SQLLog_RETR
* SQLLog_ERR_STOR
* SQLLog_ERR_RETR
* SQLNamedQuery_logtrafic
* SQLLog_ERR_*
* SQLNamedQuery_logevents
* RootLogin
* Bind
* AllowRetrieveRestart
* AllowStoreRestart
* MaxClientsPerHost
* AllowOverwrite
* DefaultRoot
* CURRENT-CLIENTS
* USER
* USER ftpuser: Login successful.
* ROOT PRIVS at mod_auth.c:1174
* opening TransferLog '/var/log/xferlog'
* RELINQUISH PRIVS at mod_auth.c:1203
* USER PRIVS 500 at mod_auth.c:701
* RELINQUISH PRIVS at mod_auth.c:705
* dispatching auth request "setpwent" to module mod_sql
* dispatching auth request "setgrent" to module mod_sql
* dispatching auth request "getpwent" to module mod_sql
* dispatching auth request "getgrent" to module mod_sql
* Preparing to chroot() the environment, path = '/ftpdaten'
* ROOT PRIVS at mod_auth.c:62
* FS: using system chroot()
* RELINQUISH PRIVS at mod_auth.c:69
* Environment successfully chroot()ed.
* ROOT PRIVS at mod_auth.c:1246
* SETUP PRIVS at mod_auth.c:1253
* FS: using system chdir()
* in dir_check_full(): path = '/', fullpath = '/ftpdaten/'.
* FS: using system stat()
* FS: using system stat()
* FS: using system stat()
* FS: using system stat()
* dispatching POST_CMD command 'PASS (hidden)' to mod_sql
* dispatching POST_CMD command 'PASS (hidden)' to mod_cap
* mod_cap/1.0: capabilities '= cap_chown,cap_net_bind_service+ep'
* dispatching POST_CMD command 'PASS (hidden)' to mod_ratio
* dispatching POST_CMD command 'PASS (hidden)' to mod_wrap
* dispatching POST_CMD command 'PASS (hidden)' to mod_ifsession
* dispatching POST_CMD command 'PASS (hidden)' to mod_readme
* dispatching POST_CMD command 'PASS (hidden)' to mod_log
* dispatching POST_CMD command 'PASS (hidden)' to mod_ls
* dispatching POST_CMD command 'PASS (hidden)' to mod_auth
* ROOT PRIVS: ID switching disabled
* dispatching LOG_CMD command 'PASS (hidden)' to mod_sql
* dispatching LOG_CMD command 'PASS (hidden)' to mod_log
* dispatching LOG_CMD command 'PASS (hidden)' to mod_ratio
* dispatching PRE_CMD command 'PWD' to mod_time
* mod_time/2.2: PWD allowed by configuration
* dispatching PRE_CMD command 'PWD' to mod_core
* dispatching PRE_CMD command 'PWD' to mod_core
* dispatching CMD command 'PWD' to mod_core
* FS: using system stat()
* FS: using system stat()
* dispatching POST_CMD command 'PWD' to mod_sql
* dispatching LOG_CMD command 'PWD' to mod_sql
* dispatching LOG_CMD command 'PWD' to mod_log
* dispatching PRE_CMD command 'SYST' to mod_time
* mod_time/2.2: SYST allowed by configuration
* dispatching PRE_CMD command 'SYST' to mod_core
* dispatching PRE_CMD command 'SYST' to mod_core
* dispatching CMD command 'SYST' to mod_core
* dispatching POST_CMD command 'SYST' to mod_sql
* dispatching LOG_CMD command 'SYST' to mod_sql
* dispatching LOG_CMD command 'SYST' to mod_log
* dispatching PRE_CMD command 'PORT *,*,*,*,21,167' to mod_time
* mod_time/2.2: PORT allowed by configuration
* dispatching PRE_CMD command 'PORT *,*,*,*,21,167' to mod_core
* dispatching PRE_CMD command 'PORT *,*,*,*,21,167' to mod_core
* dispatching CMD command 'PORT *,*,*,*,21,167' to mod_core
* dispatching POST_CMD command 'PORT *,*,*,*,21,167' to mod_sql
* dispatching LOG_CMD command 'PORT *,*,*,*,21,167' to mod_sql
* dispatching LOG_CMD command 'PORT *,*,*,*,21,167' to mod_log
* dispatching PRE_CMD command 'LIST' to mod_time
* mod_time/2.2: LIST allowed by configuration
* dispatching PRE_CMD command 'LIST' to mod_core
* dispatching PRE_CMD command 'LIST' to mod_core
* dispatching PRE_CMD command 'LIST' to mod_ratio
* dispatching CMD command 'LIST' to mod_ls
* ROOT PRIVS: ID switching disabled
* ROOT PRIVS: ID switching disabled
* active data connection opened - local  : *.*.*.*:20
* active data connection opened - remote : *.*.*.*:5543
* FS: using system stat()
* FS: using system stat()
* FS: using system stat()
* FS: using system opendir()
* FS: using system readdir()
* FS: using system readdir()
* FS: using system readdir()
* FS: using system readdir()
* FS: using system readdir()
* FS: using system readdir()
* FS: using system readdir()
* FS: using system readdir()
* FS: using system readdir()
* FS: using system closedir()
* FS: using system lstat()
* FS: using system stat()
* FS: using system stat()
* FS: using system lstat()
* in dir_check_full(): path = '/Kunden', fullpath = '/ftpdaten/Kunden'.
* FS: using system stat()
* FS: using system stat()
* FS: using system stat()
* dispatching auth request "gid_name" to module mod_sql
* dispatching auth request "uid_name" to module mod_sql
* FS: using system lstat()
* FS: using system stat()
* FS: using system stat()
* dispatching auth request "gid_name" to module mod_sql
* dispatching auth request "uid_name" to module mod_sql
* FS: using system lstat()
* FS: using system stat()
* FS: using system stat()
* dispatching auth request "gid_name" to module mod_sql
* dispatching auth request "uid_name" to module mod_sql
* FS: using system lstat()
* FS: using system stat()
* dispatching auth request "gid_name" to module mod_sql
* dispatching auth request "uid_name" to module mod_sql
* FS: using system lstat()
* FS: using system stat()
* FS: using system stat()
* dispatching auth request "gid_name" to module mod_sql
* dispatching auth request "uid_name" to module mod_sql
* dispatching POST_CMD command 'LIST' to mod_sql
* dispatching POST_CMD command 'LIST' to mod_ratio
* dispatching LOG_CMD command 'LIST' to mod_sql
* dispatching LOG_CMD command 'LIST' to mod_log
* dispatching LOG_CMD command 'LIST' to mod_ls

und noch mein proftpd.conf

# 'proftpd.conf' for actual use.  It establishes a single server
# and a single anonymous login.  It assumes that you have a user/group
# "nobody" and "ftp" for normal operation and anon.

ServerName "- Welcome to FTP Server -"
ServerType   standalone   
DefaultServer on

Port 21
Umask 022
MaxInstances 30

User nobody
Group nogroup

SQLAuthTypes Crypt
SQLAuthenticate users* groups*
SQLConnectInfo ****@localhost **** ****
SQLUserInfo users username passwd NULL NULL homedir NULL
SQLGroupInfo groups groupname id username
SQLUserWhereClause "valid = 1"
SQLDefaultGID 100
SQLDefaultUID 500
SQLHomedirOnDemand off
RequireValidShell off
SQLLog PASS updatelogin
SQLLogFile /var/log/proftpd.sql.log
SQLNamedQuery updatelogin UPDATE "count=count+1, lastlogin=NOW() WHERE username = '%u'" users

### Log trafic (STOR, RETR commands)
SQLLog STOR,RETR,ERR_STOR,ERR_RETR logtrafic
SQLNamedQuery logtrafic FREEFORM "INSERT INTO history (username, filename, transfertype, transfersize, transferhost, transfertime, transferdate) VALUES('%u', '%F', '%m', %b, '%a', '%T', NOW())"

### Log user error events (ERR_* commands)
SQLLog ERR_* logevents
SQLNamedQuery logevents FREEFORM "INSERT INTO userevents (username, eventtype, description, eventdate) VALUES ('%u', '%m', '%r', NOW())"

RootLogin off
Bind *.*.*.*
<Global>
AllowOverwrite on
DefaultRoot /ftpdaten
</Global>
AllowRetrieveRestart on
AllowStoreRestart on
MaxClientsPerHost 8

<Directory /ftpdaten>
 <Limit WRITE>
    DenyAll
 </Limit>
</Directory>

<Directory /ftpdaten/Admin/>
<Limit ALL>
  DenyAll
  AllowGroup Admin
</Limit>
</Directory>

login funkt, auch die logs für transfer/upload/download (liegen ja auch in der mysql funktionieren).
das was nicht funktioniert ist die einschränkung auf dem ftp für gruppen
=> der user ist in der gruppe admin kann aber trotzdem nicht auf das verzeichnis Admin zugreifen (sieht es nicht einmal)
verwende ich statt "AllowGroup Admin" "Allowuser ftpuser" dann funktionieren das Folderrecht  

bin mittlerweile sehr, sehr verwirrt => scheint so als ob zwar die gruppenzugehörigkeiten aus der mysql ausgelesen werden aber halt dann nicht richtig interpretiert werden können.

noch was => hab natürlich das gesamte verzeichnis schon mit chmod 777 umgesetzt (also die reinen filerechte können´s auch nicht mehr sein)


hat hier jemand rat??

[stonki]

Bevor wir uns weiter vertiefen, bitte eine Sache beachten:
http://www.proftpd.de/index.php?id=28&language=&directive_name=SQLMinUserGID&module_id=&=OK

Jul 20 18:04:08 mod_sql/4.10[20803]: SQLMinUserUID      : 999
Jul 20 18:04:08 mod_sql/4.10[20803]: SQLMinUserGID      : 999
Jul 20 18:04:08 mod_sql/4.10[20803]: SQLDefaultUID      : 500
Jul 20 18:04:08 mod_sql/4.10[20803]: SQLDefaultGID      : 100

Der Defaultwert ist 999 !!!! Bitte setze das mal manuell und schaue dann noch mal.

cu
stonki

[Technobabel]

vorab mal danke für die prompte response :-)


hab mich da an die beispiel-konfig (http://www.proftpd.de/MySQL_und_Quota.25.0.html) gehalten

=> hab jetzt auf

SQLAuthTypes Crypt
SQLAuthenticate users* groups*
SQLConnectInfo ftp@localhost root db1234$
SQLUserInfo users username passwd NULL NULL homedir NULL
SQLGroupInfo groups groupname id username
SQLUserWhereClause "valid = 1"
SQLDefaultGID 999
SQLDefaultUID 500
SQLHomedirOnDemand off
RequireValidShell off
SQLLog PASS updatelogin
SQLLogFile /var/log/proftpd.sql.log
SQLNamedQuery updatelogin UPDATE "count=count+1, lastlogin=NOW() WHERE username = '%u'" users

geändert

siehe log

Jul 20 18:57:25 mod_sql/4.10[20961]: backend module 'mod_sql_mysql/4.04'
Jul 20 18:57:25 mod_sql/4.10[20961]: backend api    'mod_sql_api_v1'
Jul 20 18:57:25 mod_sql/4.10[20961]: >>> sql_getconf
Jul 20 18:57:25 mod_sql/4.10[20961]: entering    mysql cmd_defineconnection
Jul 20 18:57:25 mod_sql/4.10[20961]:  name: 'default'
Jul 20 18:57:25 mod_sql/4.10[20961]:  user: 'root'
Jul 20 18:57:25 mod_sql/4.10[20961]:  host: 'localhost'
Jul 20 18:57:25 mod_sql/4.10[20961]:    db: 'ftp'
Jul 20 18:57:25 mod_sql/4.10[20961]:  port: '3306'
Jul 20 18:57:25 mod_sql/4.10[20961]:   ttl: '0'
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_defineconnection
Jul 20 18:57:25 mod_sql/4.10[20961]: entering    mysql cmd_open
Jul 20 18:57:25 mod_sql/4.10[20961]: connection 'default' opened
Jul 20 18:57:25 mod_sql/4.10[20961]: connection 'default' count is now 1
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_open
Jul 20 18:57:25 mod_sql/4.10[20961]: backend successfully connected.
Jul 20 18:57:25 mod_sql/4.10[20961]: mod_sql status     : on
Jul 20 18:57:25 mod_sql/4.10[20961]: negative_cache     : off
Jul 20 18:57:25 mod_sql/4.10[20961]: authenticate       : users* groups*
Jul 20 18:57:25 mod_sql/4.10[20961]: usertable          : users
Jul 20 18:57:25 mod_sql/4.10[20961]: userid field       : username
Jul 20 18:57:25 mod_sql/4.10[20961]: password field     : passwd
Jul 20 18:57:25 mod_sql/4.10[20961]: uid field          : NULL
Jul 20 18:57:25 mod_sql/4.10[20961]: gid field          : NULL
Jul 20 18:57:25 mod_sql/4.10[20961]: homedir field      : homedir
Jul 20 18:57:25 mod_sql/4.10[20961]: shell field        : NULL
Jul 20 18:57:25 mod_sql/4.10[20961]: homedirondemand    : false
Jul 20 18:57:25 mod_sql/4.10[20961]: group table        : groups
Jul 20 18:57:25 mod_sql/4.10[20961]: groupname field    : groupname
Jul 20 18:57:25 mod_sql/4.10[20961]: grp gid field      : id
Jul 20 18:57:25 mod_sql/4.10[20961]: grp members field  : username
Jul 20 18:57:25 mod_sql/4.10[20961]: SQLMinUserUID      : 999
Jul 20 18:57:25 mod_sql/4.10[20961]: SQLMinUserGID      : 999
Jul 20 18:57:25 mod_sql/4.10[20961]: SQLDefaultUID      : 500
Jul 20 18:57:25 mod_sql/4.10[20961]: SQLDefaultGID      : 999
Jul 20 18:57:25 mod_sql/4.10[20961]: <<< sql_getconf
Jul 20 18:57:25 mod_sql/4.10[20961]: >>> cmd_getgroups
Jul 20 18:57:25 mod_sql/4.10[20961]: entering    mysql cmd_escapestring
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_escapestring
Jul 20 18:57:25 mod_sql/4.10[20961]: cache miss for user 'ftpuser'
Jul 20 18:57:25 mod_sql/4.10[20961]: : entering    mysql cmd_select
Jul 20 18:57:25 mod_sql/4.10[20961]: entering    mysql cmd_open
Jul 20 18:57:25 mod_sql/4.10[20961]: connection 'default' count is now 2
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_open
Jul 20 18:57:25 mod_sql/4.10[20961]: query "SELECT username, passwd, homedir FROM users WHERE (username='ftpuser') and ((valid = 1)) LIMIT 1"
Jul 20 18:57:25 mod_sql/4.10[20961]: entering    mysql cmd_close
Jul 20 18:57:25 mod_sql/4.10[20961]: connection 'default' count is now 1
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_close
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_select
Jul 20 18:57:25 mod_sql/4.10[20961]: cache miss for user 'ftpuser'
Jul 20 18:57:25 mod_sql/4.10[20961]: user 'ftpuser' cached
Jul 20 18:57:25 mod_sql/4.10[20961]: + pwd.pw_name  : ftpuser
Jul 20 18:57:25 mod_sql/4.10[20961]: + pwd.pw_uid   : 500
Jul 20 18:57:25 mod_sql/4.10[20961]: + pwd.pw_gid   : 999
Jul 20 18:57:25 mod_sql/4.10[20961]: + pwd.pw_dir   : /ftpdaten
Jul 20 18:57:25 mod_sql/4.10[20961]: + pwd.pw_shell :
Jul 20 18:57:25 mod_sql/4.10[20961]: cache miss for gid '999'
Jul 20 18:57:25 mod_sql/4.10[20961]: : entering    mysql cmd_select
Jul 20 18:57:25 mod_sql/4.10[20961]: entering    mysql cmd_open
Jul 20 18:57:25 mod_sql/4.10[20961]: connection 'default' count is now 2
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_open
Jul 20 18:57:25 mod_sql/4.10[20961]: query "SELECT groupname FROM groups WHERE (id = 999) LIMIT 1"
Jul 20 18:57:25 mod_sql/4.10[20961]: entering    mysql cmd_close
Jul 20 18:57:25 mod_sql/4.10[20961]: connection 'default' count is now 1
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_close
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_select
Jul 20 18:57:25 mod_sql/4.10[20961]: : entering    mysql cmd_select
Jul 20 18:57:25 mod_sql/4.10[20961]: entering    mysql cmd_open
Jul 20 18:57:25 mod_sql/4.10[20961]: connection 'default' count is now 2
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_open
Jul 20 18:57:25 mod_sql/4.10[20961]: query "SELECT groupname, id, username FROM groups WHERE (username = 'ftpuser' OR username LIKE 'ftpuser,%' OR username LIKE '%,ftpuser' OR username LIKE '%,ftpuser,%')"
Jul 20 18:57:25 mod_sql/4.10[20961]: entering    mysql cmd_close
Jul 20 18:57:25 mod_sql/4.10[20961]: connection 'default' count is now 1
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_close
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_select
Jul 20 18:57:25 mod_sql/4.10[20961]: cache miss for group 'Public'
Jul 20 18:57:25 mod_sql/4.10[20961]: group 'Public' cached
Jul 20 18:57:25 mod_sql/4.10[20961]: + grp.gr_name : Public
Jul 20 18:57:25 mod_sql/4.10[20961]: + grp.gr_gid  : 78
Jul 20 18:57:25 mod_sql/4.10[20961]: + grp.gr_mem  : ftpuser
Jul 20 18:57:25 mod_sql/4.10[20961]: cache miss for group 'Kunden'
Jul 20 18:57:25 mod_sql/4.10[20961]: group 'Kunden' cached
Jul 20 18:57:25 mod_sql/4.10[20961]: + grp.gr_name : Kunden
Jul 20 18:57:25 mod_sql/4.10[20961]: + grp.gr_gid  : 77
Jul 20 18:57:25 mod_sql/4.10[20961]: + grp.gr_mem  : ftpuser
Jul 20 18:57:25 mod_sql/4.10[20961]: cache miss for group 'admin'
Jul 20 18:57:25 mod_sql/4.10[20961]: group 'admin' cached
Jul 20 18:57:25 mod_sql/4.10[20961]: + grp.gr_name : admin
Jul 20 18:57:25 mod_sql/4.10[20961]: + grp.gr_gid  : 76
Jul 20 18:57:25 mod_sql/4.10[20961]: + grp.gr_mem  : ftpuser
Jul 20 18:57:25 mod_sql/4.10[20961]: <<< cmd_getgroups
Jul 20 18:57:25 mod_sql/4.10[20961]: >>> cmd_getpwnam
Jul 20 18:57:25 mod_sql/4.10[20961]: cache hit for user 'ftpuser'
Jul 20 18:57:25 mod_sql/4.10[20961]: <<< cmd_getpwnam
Jul 20 18:57:25 mod_sql/4.10[20961]: >>> cmd_getpwnam
Jul 20 18:57:25 mod_sql/4.10[20961]: cache hit for user 'ftpuser'
Jul 20 18:57:25 mod_sql/4.10[20961]: <<< cmd_getpwnam
Jul 20 18:57:25 mod_sql/4.10[20961]: >>> cmd_getgrgid
Jul 20 18:57:25 mod_sql/4.10[20961]: cache miss for gid '999'
Jul 20 18:57:25 mod_sql/4.10[20961]: : entering    mysql cmd_select
Jul 20 18:57:25 mod_sql/4.10[20961]: entering    mysql cmd_open
Jul 20 18:57:25 mod_sql/4.10[20961]: connection 'default' count is now 2
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_open
Jul 20 18:57:25 mod_sql/4.10[20961]: query "SELECT groupname FROM groups WHERE (id = 999) LIMIT 1"
Jul 20 18:57:25 mod_sql/4.10[20961]: entering    mysql cmd_close
Jul 20 18:57:25 mod_sql/4.10[20961]: connection 'default' count is now 1
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_close
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_select
Jul 20 18:57:25 mod_sql/4.10[20961]: <<< cmd_getgrgid
Jul 20 18:57:25 mod_sql/4.10[20961]: >>> cmd_getpwnam
Jul 20 18:57:25 mod_sql/4.10[20961]: cache hit for user 'ftpuser'
Jul 20 18:57:25 mod_sql/4.10[20961]: <<< cmd_getpwnam
Jul 20 18:57:25 mod_sql/4.10[20961]: >>> cmd_gid2name
Jul 20 18:57:25 mod_sql/4.10[20961]: cache miss for gid '999'
Jul 20 18:57:25 mod_sql/4.10[20961]: : entering    mysql cmd_select
Jul 20 18:57:25 mod_sql/4.10[20961]: entering    mysql cmd_open
Jul 20 18:57:25 mod_sql/4.10[20961]: connection 'default' count is now 2
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_open
Jul 20 18:57:25 mod_sql/4.10[20961]: query "SELECT groupname FROM groups WHERE (id = 999) LIMIT 1"
Jul 20 18:57:25 mod_sql/4.10[20961]: entering    mysql cmd_close
Jul 20 18:57:25 mod_sql/4.10[20961]: connection 'default' count is now 1
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_close
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_select
Jul 20 18:57:25 mod_sql/4.10[20961]: <<< cmd_gid2name
Jul 20 18:57:25 mod_sql/4.10[20961]: >>> cmd_auth
Jul 20 18:57:25 mod_sql/4.10[20961]: entering    mysql cmd_escapestring
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_escapestring
Jul 20 18:57:25 mod_sql/4.10[20961]: cache hit for user 'ftpuser'
Jul 20 18:57:25 mod_sql/4.10[20961]: >>> cmd_check
Jul 20 18:57:25 mod_sql/4.10[20961]: checking auth_type Crypt
Jul 20 18:57:25 mod_sql/4.10[20961]: 'Crypt' auth handler reports success
Jul 20 18:57:25 mod_sql/4.10[20961]: cache hit for user 'ftpuser'
Jul 20 18:57:25 mod_sql/4.10[20961]: <<< cmd_check
Jul 20 18:57:25 mod_sql/4.10[20961]: <<< cmd_auth
Jul 20 18:57:25 mod_sql/4.10[20961]: >>> log_master
Jul 20 18:57:25 mod_sql/4.10[20961]: >>> _process_named_query
Jul 20 18:57:25 mod_sql/4.10[20961]: entering    mysql cmd_escapestring
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_escapestring
Jul 20 18:57:25 mod_sql/4.10[20961]: entering    mysql cmd_update
Jul 20 18:57:25 mod_sql/4.10[20961]: entering    mysql cmd_open
Jul 20 18:57:25 mod_sql/4.10[20961]: connection 'default' count is now 2
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_open
Jul 20 18:57:25 mod_sql/4.10[20961]: query "UPDATE users SET count=count+1, lastlogin=NOW() WHERE username = 'ftpuser'"
Jul 20 18:57:25 mod_sql/4.10[20961]: entering    mysql cmd_close
Jul 20 18:57:25 mod_sql/4.10[20961]: connection 'default' count is now 1
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_close
Jul 20 18:57:25 mod_sql/4.10[20961]: exiting    mysql cmd_update
Jul 20 18:57:25 mod_sql/4.10[20961]: <<< _process_named_query
Jul 20 18:57:25 mod_sql/4.10[20961]: <<< log_master
Jul 20 18:57:26 mod_sql/4.10[20961]: >>> cmd_gid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: cache miss for gid '0'
Jul 20 18:57:26 mod_sql/4.10[20961]: : entering    mysql cmd_select
Jul 20 18:57:26 mod_sql/4.10[20961]: entering    mysql cmd_open
Jul 20 18:57:26 mod_sql/4.10[20961]: connection 'default' count is now 2
Jul 20 18:57:26 mod_sql/4.10[20961]: exiting    mysql cmd_open
Jul 20 18:57:26 mod_sql/4.10[20961]: query "SELECT groupname FROM groups WHERE (id = 0) LIMIT 1"
Jul 20 18:57:26 mod_sql/4.10[20961]: entering    mysql cmd_close
Jul 20 18:57:26 mod_sql/4.10[20961]: connection 'default' count is now 1
Jul 20 18:57:26 mod_sql/4.10[20961]: exiting    mysql cmd_close
Jul 20 18:57:26 mod_sql/4.10[20961]: exiting    mysql cmd_select
Jul 20 18:57:26 mod_sql/4.10[20961]: <<< cmd_gid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: >>> cmd_uid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: cache miss for uid '0'
Jul 20 18:57:26 mod_sql/4.10[20961]: no user uid field configured, declining to lookup uid '0'
Jul 20 18:57:26 mod_sql/4.10[20961]: <<< cmd_uid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: >>> cmd_gid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: cache miss for gid '0'
Jul 20 18:57:26 mod_sql/4.10[20961]: : entering    mysql cmd_select
Jul 20 18:57:26 mod_sql/4.10[20961]: entering    mysql cmd_open
Jul 20 18:57:26 mod_sql/4.10[20961]: connection 'default' count is now 2
Jul 20 18:57:26 mod_sql/4.10[20961]: exiting    mysql cmd_open
Jul 20 18:57:26 mod_sql/4.10[20961]: query "SELECT groupname FROM groups WHERE (id = 0) LIMIT 1"
Jul 20 18:57:26 mod_sql/4.10[20961]: entering    mysql cmd_close
Jul 20 18:57:26 mod_sql/4.10[20961]: connection 'default' count is now 1
Jul 20 18:57:26 mod_sql/4.10[20961]: exiting    mysql cmd_close
Jul 20 18:57:26 mod_sql/4.10[20961]: exiting    mysql cmd_select
Jul 20 18:57:26 mod_sql/4.10[20961]: <<< cmd_gid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: >>> cmd_uid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: cache miss for uid '0'
Jul 20 18:57:26 mod_sql/4.10[20961]: no user uid field configured, declining to lookup uid '0'
Jul 20 18:57:26 mod_sql/4.10[20961]: <<< cmd_uid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: >>> cmd_gid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: cache miss for gid '100'
Jul 20 18:57:26 mod_sql/4.10[20961]: : entering    mysql cmd_select
Jul 20 18:57:26 mod_sql/4.10[20961]: entering    mysql cmd_open
Jul 20 18:57:26 mod_sql/4.10[20961]: connection 'default' count is now 2
Jul 20 18:57:26 mod_sql/4.10[20961]: exiting    mysql cmd_open
Jul 20 18:57:26 mod_sql/4.10[20961]: query "SELECT groupname FROM groups WHERE (id = 100) LIMIT 1"
Jul 20 18:57:26 mod_sql/4.10[20961]: entering    mysql cmd_close
Jul 20 18:57:26 mod_sql/4.10[20961]: connection 'default' count is now 1
Jul 20 18:57:26 mod_sql/4.10[20961]: exiting    mysql cmd_close
Jul 20 18:57:26 mod_sql/4.10[20961]: exiting    mysql cmd_select
Jul 20 18:57:26 mod_sql/4.10[20961]: <<< cmd_gid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: >>> cmd_uid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: matched current user
Jul 20 18:57:26 mod_sql/4.10[20961]: <<< cmd_uid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: >>> cmd_gid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: cache miss for gid '100'
Jul 20 18:57:26 mod_sql/4.10[20961]: : entering    mysql cmd_select
Jul 20 18:57:26 mod_sql/4.10[20961]: entering    mysql cmd_open
Jul 20 18:57:26 mod_sql/4.10[20961]: connection 'default' count is now 2
Jul 20 18:57:26 mod_sql/4.10[20961]: exiting    mysql cmd_open
Jul 20 18:57:26 mod_sql/4.10[20961]: query "SELECT groupname FROM groups WHERE (id = 100) LIMIT 1"
Jul 20 18:57:26 mod_sql/4.10[20961]: entering    mysql cmd_close
Jul 20 18:57:26 mod_sql/4.10[20961]: connection 'default' count is now 1
Jul 20 18:57:26 mod_sql/4.10[20961]: exiting    mysql cmd_close
Jul 20 18:57:26 mod_sql/4.10[20961]: exiting    mysql cmd_select
Jul 20 18:57:26 mod_sql/4.10[20961]: <<< cmd_gid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: >>> cmd_uid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: matched current user
Jul 20 18:57:26 mod_sql/4.10[20961]: <<< cmd_uid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: >>> cmd_gid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: cache miss for gid '0'
Jul 20 18:57:26 mod_sql/4.10[20961]: : entering    mysql cmd_select
Jul 20 18:57:26 mod_sql/4.10[20961]: entering    mysql cmd_open
Jul 20 18:57:26 mod_sql/4.10[20961]: connection 'default' count is now 2
Jul 20 18:57:26 mod_sql/4.10[20961]: exiting    mysql cmd_open
Jul 20 18:57:26 mod_sql/4.10[20961]: query "SELECT groupname FROM groups WHERE (id = 0) LIMIT 1"
Jul 20 18:57:26 mod_sql/4.10[20961]: entering    mysql cmd_close
Jul 20 18:57:26 mod_sql/4.10[20961]: connection 'default' count is now 1
Jul 20 18:57:26 mod_sql/4.10[20961]: exiting    mysql cmd_close
Jul 20 18:57:26 mod_sql/4.10[20961]: exiting    mysql cmd_select
Jul 20 18:57:26 mod_sql/4.10[20961]: <<< cmd_gid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: >>> cmd_uid2name
Jul 20 18:57:26 mod_sql/4.10[20961]: cache miss for uid '0'
Jul 20 18:57:26 mod_sql/4.10[20961]: no user uid field configured, declining to lookup uid '0'
Jul 20 18:57:26 mod_sql/4.10[20961]: <<< cmd_uid2name

hilft aber scheinbar auch nix. vorher hat er "zumindest lese ich das so"

Jul 20 18:04:08 mod_sql/4.10[20803]: cache miss for group 'Kunden'
Jul 20 18:04:08 mod_sql/4.10[20803]: group 'Kunden' cached
Jul 20 18:04:08 mod_sql/4.10[20803]: + grp.gr_name : Kunden
Jul 20 18:04:08 mod_sql/4.10[20803]: + grp.gr_gid : 70
Jul 20 18:04:08 mod_sql/4.10[20803]: + grp.gr_mem : ftpuser
Jul 20 18:04:08 mod_sql/4.10[20803]: cache miss for group 'admin'
Jul 20 18:04:08 mod_sql/4.10[20803]: group 'admin' cached
Jul 20 18:04:08 mod_sql/4.10[20803]: + grp.gr_name : admin
Jul 20 18:04:08 mod_sql/4.10[20803]: + grp.gr_gid : 69
Jul 20 18:04:08 mod_sql/4.10[20803]: + grp.gr_mem : ftpuser
Jul 20 18:04:08 mod_sql/4.10[20803]: cache miss for group 'Public'
Jul 20 18:04:08 mod_sql/4.10[20803]: group 'Public' cached
Jul 20 18:04:08 mod_sql/4.10[20803]: + grp.gr_name : Public
Jul 20 18:04:08 mod_sql/4.10[20803]: + grp.gr_gid : 71
Jul 20 18:04:08 mod_sql/4.10[20803]: + grp.gr_mem : ftpuser
Jul 20 18:04:08 mod_sql/4.10[20803]: <<< cmd_getgroups
Jul 20 18:04:08 mod_sql/4.10[20803]: >>> cmd_getpwnam
Jul 20 18:04:08 mod_sql/4.10[20803]: cache hit for user 'ftpuser'

meiner meinung nach die gruppenmitgliedschaft ausgelesen => jetzt schaft er gar nix mehr oder?

[stonki]

Deine MinGid ist 500, die Gruppen sind aber 68,69 ?

[Technobabel]

Deine MinGid ist 500, die Gruppen sind aber 68,69 ?

minigid ist lt. konfig 5000

die gruppen sind jetzt aber schon wieder anders wie´s scheint. wenn ich jetzt mit mysql-admin auf die table groups schau gibts zwar ein paar einträge für den groupname admin finde ich aber nur eine mit der id 76 mit dem usernamen ftpuser verknüpft.  :?:

war das das was du gemeint hast?

[stonki]

Jul 20 18:57:25 mod_sql/4.10[20961]: SQLMinUserGID      : 999
Jul 20 18:57:25 mod_sql/4.10[20961]: SQLDefaultGID      : 999
[...]
Jul 20 18:57:25 mod_sql/4.10[20961]: query "SELECT groupname, id, username FROM groups WHERE (username = 'ftpuser' OR username LIKE 'ftpuser,%' OR username LIKE '%,ftpuser' OR username LIKE '%,ftpuser,%')"

Jul 20 18:57:25 mod_sql/4.10[20961]: + grp.gr_name : Public
Jul 20 18:57:25 mod_sql/4.10[20961]: + grp.gr_gid  : 78

Jul 20 18:57:25 mod_sql/4.10[20961]: + grp.gr_name : Kunden
Jul 20 18:57:25 mod_sql/4.10[20961]: + grp.gr_gid  : 77

Jul 20 18:57:25 mod_sql/4.10[20961]: + grp.gr_name : admin
Jul 20 18:57:25 mod_sql/4.10[20961]: + grp.gr_gid  : 76

[Technobabel]

ok nochmal (hoffe ich hab dich jetzt richtig verstanden)

=> ja vorher war das der output von der sql - query
hab danach aber wie du gemeint hast
SQLDefaultGID 999
SQLDefaultUID 500
gesetzt

danach reload proftp

jetzt krieg ich allerdings in der sqlog wie folgt:

Jul 20 19:32:41 mod_sql/4.10[21517]: backend module 'mod_sql_mysql/4.04'
Jul 20 19:32:41 mod_sql/4.10[21517]: backend api    'mod_sql_api_v1'
Jul 20 19:32:41 mod_sql/4.10[21517]: >>> sql_getconf
Jul 20 19:32:41 mod_sql/4.10[21517]: entering    mysql cmd_defineconnection
Jul 20 19:32:41 mod_sql/4.10[21517]:  name: 'default'
Jul 20 19:32:41 mod_sql/4.10[21517]:  user: 'root'
Jul 20 19:32:41 mod_sql/4.10[21517]:  host: 'localhost'
Jul 20 19:32:41 mod_sql/4.10[21517]:    db: 'ftp'
Jul 20 19:32:41 mod_sql/4.10[21517]:  port: '3306'
Jul 20 19:32:41 mod_sql/4.10[21517]:   ttl: '0'
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_defineconnection
Jul 20 19:32:41 mod_sql/4.10[21517]: entering    mysql cmd_open
Jul 20 19:32:41 mod_sql/4.10[21517]: connection 'default' opened
Jul 20 19:32:41 mod_sql/4.10[21517]: connection 'default' count is now 1
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_open
Jul 20 19:32:41 mod_sql/4.10[21517]: backend successfully connected.
Jul 20 19:32:41 mod_sql/4.10[21517]: mod_sql status     : on
Jul 20 19:32:41 mod_sql/4.10[21517]: negative_cache     : off
Jul 20 19:32:41 mod_sql/4.10[21517]: authenticate       : users* groups*
Jul 20 19:32:41 mod_sql/4.10[21517]: usertable          : users
Jul 20 19:32:41 mod_sql/4.10[21517]: userid field       : username
Jul 20 19:32:41 mod_sql/4.10[21517]: password field     : passwd
Jul 20 19:32:41 mod_sql/4.10[21517]: uid field          : NULL
Jul 20 19:32:41 mod_sql/4.10[21517]: gid field          : NULL
Jul 20 19:32:41 mod_sql/4.10[21517]: homedir field      : homedir
Jul 20 19:32:41 mod_sql/4.10[21517]: shell field        : NULL
Jul 20 19:32:41 mod_sql/4.10[21517]: homedirondemand    : false
Jul 20 19:32:41 mod_sql/4.10[21517]: group table        : groups
Jul 20 19:32:41 mod_sql/4.10[21517]: groupname field    : groupname
Jul 20 19:32:41 mod_sql/4.10[21517]: grp gid field      : id
Jul 20 19:32:41 mod_sql/4.10[21517]: grp members field  : username
Jul 20 19:32:41 mod_sql/4.10[21517]: SQLMinUserUID      : 999
Jul 20 19:32:41 mod_sql/4.10[21517]: SQLMinUserGID      : 999
Jul 20 19:32:41 mod_sql/4.10[21517]: SQLDefaultUID      : 500
Jul 20 19:32:41 mod_sql/4.10[21517]: SQLDefaultGID      : 999
Jul 20 19:32:41 mod_sql/4.10[21517]: <<< sql_getconf
Jul 20 19:32:41 mod_sql/4.10[21517]: >>> cmd_getgroups
Jul 20 19:32:41 mod_sql/4.10[21517]: entering    mysql cmd_escapestring
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_escapestring
Jul 20 19:32:41 mod_sql/4.10[21517]: cache miss for user 'ftpuser'
Jul 20 19:32:41 mod_sql/4.10[21517]: : entering    mysql cmd_select
Jul 20 19:32:41 mod_sql/4.10[21517]: entering    mysql cmd_open
Jul 20 19:32:41 mod_sql/4.10[21517]: connection 'default' count is now 2
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_open
Jul 20 19:32:41 mod_sql/4.10[21517]: query "SELECT username, passwd, homedir FROM users WHERE (username='ftpuser') and ((valid = 1)) LIMIT 1"
Jul 20 19:32:41 mod_sql/4.10[21517]: entering    mysql cmd_close
Jul 20 19:32:41 mod_sql/4.10[21517]: connection 'default' count is now 1
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_close
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_select
Jul 20 19:32:41 mod_sql/4.10[21517]: cache miss for user 'ftpuser'
Jul 20 19:32:41 mod_sql/4.10[21517]: user 'ftpuser' cached
Jul 20 19:32:41 mod_sql/4.10[21517]: + pwd.pw_name  : ftpuser
Jul 20 19:32:41 mod_sql/4.10[21517]: + pwd.pw_uid   : 500
Jul 20 19:32:41 mod_sql/4.10[21517]: + pwd.pw_gid   : 999
Jul 20 19:32:41 mod_sql/4.10[21517]: + pwd.pw_dir   : /ftpdaten
Jul 20 19:32:41 mod_sql/4.10[21517]: + pwd.pw_shell :
Jul 20 19:32:41 mod_sql/4.10[21517]: cache miss for gid '999'
Jul 20 19:32:41 mod_sql/4.10[21517]: : entering    mysql cmd_select
Jul 20 19:32:41 mod_sql/4.10[21517]: entering    mysql cmd_open
Jul 20 19:32:41 mod_sql/4.10[21517]: connection 'default' count is now 2
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_open
Jul 20 19:32:41 mod_sql/4.10[21517]: query "SELECT groupname FROM groups WHERE (id = 999) LIMIT 1"
Jul 20 19:32:41 mod_sql/4.10[21517]: entering    mysql cmd_close
Jul 20 19:32:41 mod_sql/4.10[21517]: connection 'default' count is now 1
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_close
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_select
Jul 20 19:32:41 mod_sql/4.10[21517]: : entering    mysql cmd_select
Jul 20 19:32:41 mod_sql/4.10[21517]: entering    mysql cmd_open
Jul 20 19:32:41 mod_sql/4.10[21517]: connection 'default' count is now 2
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_open
Jul 20 19:32:41 mod_sql/4.10[21517]: query "SELECT groupname, id, username FROM groups WHERE (username = 'ftpuser' OR username LIKE 'ftpuser,%' OR username LIKE '%,ftpuser' OR username LIKE '%,ftpuser,%')"
Jul 20 19:32:41 mod_sql/4.10[21517]: entering    mysql cmd_close
Jul 20 19:32:41 mod_sql/4.10[21517]: connection 'default' count is now 1
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_close
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_select
Jul 20 19:32:41 mod_sql/4.10[21517]: cache miss for group 'Public'
Jul 20 19:32:41 mod_sql/4.10[21517]: group 'Public' cached
Jul 20 19:32:41 mod_sql/4.10[21517]: + grp.gr_name : Public
Jul 20 19:32:41 mod_sql/4.10[21517]: + grp.gr_gid  : 78
Jul 20 19:32:41 mod_sql/4.10[21517]: + grp.gr_mem  : ftpuser
Jul 20 19:32:41 mod_sql/4.10[21517]: cache miss for group 'Kunden'
Jul 20 19:32:41 mod_sql/4.10[21517]: group 'Kunden' cached
Jul 20 19:32:41 mod_sql/4.10[21517]: + grp.gr_name : Kunden
Jul 20 19:32:41 mod_sql/4.10[21517]: + grp.gr_gid  : 77
Jul 20 19:32:41 mod_sql/4.10[21517]: + grp.gr_mem  : ftpuser
Jul 20 19:32:41 mod_sql/4.10[21517]: cache miss for group 'admin'
Jul 20 19:32:41 mod_sql/4.10[21517]: group 'admin' cached
Jul 20 19:32:41 mod_sql/4.10[21517]: + grp.gr_name : admin
Jul 20 19:32:41 mod_sql/4.10[21517]: + grp.gr_gid  : 76
Jul 20 19:32:41 mod_sql/4.10[21517]: + grp.gr_mem  : ftpuser
Jul 20 19:32:41 mod_sql/4.10[21517]: <<< cmd_getgroups
Jul 20 19:32:41 mod_sql/4.10[21517]: >>> cmd_getpwnam
Jul 20 19:32:41 mod_sql/4.10[21517]: cache hit for user 'ftpuser'
Jul 20 19:32:41 mod_sql/4.10[21517]: <<< cmd_getpwnam
Jul 20 19:32:41 mod_sql/4.10[21517]: >>> cmd_getpwnam
Jul 20 19:32:41 mod_sql/4.10[21517]: cache hit for user 'ftpuser'
Jul 20 19:32:41 mod_sql/4.10[21517]: <<< cmd_getpwnam
Jul 20 19:32:41 mod_sql/4.10[21517]: >>> cmd_getgrgid
Jul 20 19:32:41 mod_sql/4.10[21517]: cache miss for gid '999'
Jul 20 19:32:41 mod_sql/4.10[21517]: : entering    mysql cmd_select
Jul 20 19:32:41 mod_sql/4.10[21517]: entering    mysql cmd_open
Jul 20 19:32:41 mod_sql/4.10[21517]: connection 'default' count is now 2
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_open
Jul 20 19:32:41 mod_sql/4.10[21517]: query "SELECT groupname FROM groups WHERE (id = 999) LIMIT 1"
Jul 20 19:32:41 mod_sql/4.10[21517]: entering    mysql cmd_close
Jul 20 19:32:41 mod_sql/4.10[21517]: connection 'default' count is now 1
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_close
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_select
Jul 20 19:32:41 mod_sql/4.10[21517]: <<< cmd_getgrgid
Jul 20 19:32:41 mod_sql/4.10[21517]: >>> cmd_getpwnam
Jul 20 19:32:41 mod_sql/4.10[21517]: cache hit for user 'ftpuser'
Jul 20 19:32:41 mod_sql/4.10[21517]: <<< cmd_getpwnam
Jul 20 19:32:41 mod_sql/4.10[21517]: >>> cmd_gid2name
Jul 20 19:32:41 mod_sql/4.10[21517]: cache miss for gid '999'
Jul 20 19:32:41 mod_sql/4.10[21517]: : entering    mysql cmd_select
Jul 20 19:32:41 mod_sql/4.10[21517]: entering    mysql cmd_open
Jul 20 19:32:41 mod_sql/4.10[21517]: connection 'default' count is now 2
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_open
Jul 20 19:32:41 mod_sql/4.10[21517]: query "SELECT groupname FROM groups WHERE (id = 999) LIMIT 1"
Jul 20 19:32:41 mod_sql/4.10[21517]: entering    mysql cmd_close
Jul 20 19:32:41 mod_sql/4.10[21517]: connection 'default' count is now 1
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_close
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_select
Jul 20 19:32:41 mod_sql/4.10[21517]: <<< cmd_gid2name
Jul 20 19:32:41 mod_sql/4.10[21517]: >>> cmd_auth
Jul 20 19:32:41 mod_sql/4.10[21517]: entering    mysql cmd_escapestring
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_escapestring
Jul 20 19:32:41 mod_sql/4.10[21517]: cache hit for user 'ftpuser'
Jul 20 19:32:41 mod_sql/4.10[21517]: >>> cmd_check
Jul 20 19:32:41 mod_sql/4.10[21517]: checking auth_type Crypt
Jul 20 19:32:41 mod_sql/4.10[21517]: 'Crypt' auth handler reports success
Jul 20 19:32:41 mod_sql/4.10[21517]: cache hit for user 'ftpuser'
Jul 20 19:32:41 mod_sql/4.10[21517]: <<< cmd_check
Jul 20 19:32:41 mod_sql/4.10[21517]: <<< cmd_auth
Jul 20 19:32:41 mod_sql/4.10[21517]: >>> log_master
Jul 20 19:32:41 mod_sql/4.10[21517]: >>> _process_named_query
Jul 20 19:32:41 mod_sql/4.10[21517]: entering    mysql cmd_escapestring
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_escapestring
Jul 20 19:32:41 mod_sql/4.10[21517]: entering    mysql cmd_update
Jul 20 19:32:41 mod_sql/4.10[21517]: entering    mysql cmd_open
Jul 20 19:32:41 mod_sql/4.10[21517]: connection 'default' count is now 2
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_open
Jul 20 19:32:41 mod_sql/4.10[21517]: query "UPDATE users SET count=count+1, lastlogin=NOW() WHERE username = 'ftpuser'"
Jul 20 19:32:41 mod_sql/4.10[21517]: entering    mysql cmd_close
Jul 20 19:32:41 mod_sql/4.10[21517]: connection 'default' count is now 1
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_close
Jul 20 19:32:41 mod_sql/4.10[21517]: exiting    mysql cmd_update
Jul 20 19:32:41 mod_sql/4.10[21517]: <<< _process_named_query
Jul 20 19:32:41 mod_sql/4.10[21517]: <<< log_master
Jul 20 19:32:42 mod_sql/4.10[21517]: >>> cmd_gid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: cache miss for gid '0'
Jul 20 19:32:42 mod_sql/4.10[21517]: : entering    mysql cmd_select
Jul 20 19:32:42 mod_sql/4.10[21517]: entering    mysql cmd_open
Jul 20 19:32:42 mod_sql/4.10[21517]: connection 'default' count is now 2
Jul 20 19:32:42 mod_sql/4.10[21517]: exiting    mysql cmd_open
Jul 20 19:32:42 mod_sql/4.10[21517]: query "SELECT groupname FROM groups WHERE (id = 0) LIMIT 1"
Jul 20 19:32:42 mod_sql/4.10[21517]: entering    mysql cmd_close
Jul 20 19:32:42 mod_sql/4.10[21517]: connection 'default' count is now 1
Jul 20 19:32:42 mod_sql/4.10[21517]: exiting    mysql cmd_close
Jul 20 19:32:42 mod_sql/4.10[21517]: exiting    mysql cmd_select
Jul 20 19:32:42 mod_sql/4.10[21517]: <<< cmd_gid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: >>> cmd_uid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: cache miss for uid '0'
Jul 20 19:32:42 mod_sql/4.10[21517]: no user uid field configured, declining to lookup uid '0'
Jul 20 19:32:42 mod_sql/4.10[21517]: <<< cmd_uid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: >>> cmd_gid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: cache miss for gid '0'
Jul 20 19:32:42 mod_sql/4.10[21517]: : entering    mysql cmd_select
Jul 20 19:32:42 mod_sql/4.10[21517]: entering    mysql cmd_open
Jul 20 19:32:42 mod_sql/4.10[21517]: connection 'default' count is now 2
Jul 20 19:32:42 mod_sql/4.10[21517]: exiting    mysql cmd_open
Jul 20 19:32:42 mod_sql/4.10[21517]: query "SELECT groupname FROM groups WHERE (id = 0) LIMIT 1"
Jul 20 19:32:42 mod_sql/4.10[21517]: entering    mysql cmd_close
Jul 20 19:32:42 mod_sql/4.10[21517]: connection 'default' count is now 1
Jul 20 19:32:42 mod_sql/4.10[21517]: exiting    mysql cmd_close
Jul 20 19:32:42 mod_sql/4.10[21517]: exiting    mysql cmd_select
Jul 20 19:32:42 mod_sql/4.10[21517]: <<< cmd_gid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: >>> cmd_uid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: cache miss for uid '0'
Jul 20 19:32:42 mod_sql/4.10[21517]: no user uid field configured, declining to lookup uid '0'
Jul 20 19:32:42 mod_sql/4.10[21517]: <<< cmd_uid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: >>> cmd_gid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: cache miss for gid '100'
Jul 20 19:32:42 mod_sql/4.10[21517]: : entering    mysql cmd_select
Jul 20 19:32:42 mod_sql/4.10[21517]: entering    mysql cmd_open
Jul 20 19:32:42 mod_sql/4.10[21517]: connection 'default' count is now 2
Jul 20 19:32:42 mod_sql/4.10[21517]: exiting    mysql cmd_open
Jul 20 19:32:42 mod_sql/4.10[21517]: query "SELECT groupname FROM groups WHERE (id = 100) LIMIT 1"
Jul 20 19:32:42 mod_sql/4.10[21517]: entering    mysql cmd_close
Jul 20 19:32:42 mod_sql/4.10[21517]: connection 'default' count is now 1
Jul 20 19:32:42 mod_sql/4.10[21517]: exiting    mysql cmd_close
Jul 20 19:32:42 mod_sql/4.10[21517]: exiting    mysql cmd_select
Jul 20 19:32:42 mod_sql/4.10[21517]: <<< cmd_gid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: >>> cmd_uid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: matched current user
Jul 20 19:32:42 mod_sql/4.10[21517]: <<< cmd_uid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: >>> cmd_gid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: cache miss for gid '100'
Jul 20 19:32:42 mod_sql/4.10[21517]: : entering    mysql cmd_select
Jul 20 19:32:42 mod_sql/4.10[21517]: entering    mysql cmd_open
Jul 20 19:32:42 mod_sql/4.10[21517]: connection 'default' count is now 2
Jul 20 19:32:42 mod_sql/4.10[21517]: exiting    mysql cmd_open
Jul 20 19:32:42 mod_sql/4.10[21517]: query "SELECT groupname FROM groups WHERE (id = 100) LIMIT 1"
Jul 20 19:32:42 mod_sql/4.10[21517]: entering    mysql cmd_close
Jul 20 19:32:42 mod_sql/4.10[21517]: connection 'default' count is now 1
Jul 20 19:32:42 mod_sql/4.10[21517]: exiting    mysql cmd_close
Jul 20 19:32:42 mod_sql/4.10[21517]: exiting    mysql cmd_select
Jul 20 19:32:42 mod_sql/4.10[21517]: <<< cmd_gid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: >>> cmd_uid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: matched current user
Jul 20 19:32:42 mod_sql/4.10[21517]: <<< cmd_uid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: >>> cmd_gid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: cache miss for gid '0'
Jul 20 19:32:42 mod_sql/4.10[21517]: : entering    mysql cmd_select
Jul 20 19:32:42 mod_sql/4.10[21517]: entering    mysql cmd_open
Jul 20 19:32:42 mod_sql/4.10[21517]: connection 'default' count is now 2
Jul 20 19:32:42 mod_sql/4.10[21517]: exiting    mysql cmd_open
Jul 20 19:32:42 mod_sql/4.10[21517]: query "SELECT groupname FROM groups WHERE (id = 0) LIMIT 1"
Jul 20 19:32:42 mod_sql/4.10[21517]: entering    mysql cmd_close
Jul 20 19:32:42 mod_sql/4.10[21517]: connection 'default' count is now 1
Jul 20 19:32:42 mod_sql/4.10[21517]: exiting    mysql cmd_close
Jul 20 19:32:42 mod_sql/4.10[21517]: exiting    mysql cmd_select
Jul 20 19:32:42 mod_sql/4.10[21517]: <<< cmd_gid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: >>> cmd_uid2name
Jul 20 19:32:42 mod_sql/4.10[21517]: cache miss for uid '0'
Jul 20 19:32:42 mod_sql/4.10[21517]: no user uid field configured, declining to lookup uid '0'
Jul 20 19:32:42 mod_sql/4.10[21517]: <<< cmd_uid2name

das stimmt auch mit der datenbank überein (wenn ich direkt auf den inhalt der table groups in der db losgehe erhalte ich ja das

 id groupname username
 78 Public ftpuser
 77 Kunden ftpuser
 80 Kunden stockp
 81 Public stockp
 79 admin stockp
 75 Public stelzlj
 74 Kunden stelzlj
 76 admin ftpuser

[Technobabel]

soweit ich das verstehe ändert sich die grupen.gid ja dynamisch (ein neues mitglied der gruppe z.b. admin erzeugt einen neuen eintrag in der table "groups" mit einer neuen group.id (halt der nächsten freien) und den zugehörigen members (also group.member %username%)

=> die abfrage in der mysql scheint ja auch noch zu funktionieren

das ding macht ja lt sql.log

Jul 21 12:38:01 mod_sql/4.10[23929]: cache miss for group 'admin'
Jul 21 12:38:01 mod_sql/4.10[23929]: group 'admin' cached
Jul 21 12:38:01 mod_sql/4.10[23929]: + grp.gr_name : admin
Jul 21 12:38:01 mod_sql/4.10[23929]: + grp.gr_gid  : 76
Jul 21 12:38:01 mod_sql/4.10[23929]: + grp.gr_mem  : ftpuser

=> das heißt doch er hat bei der abfrage zur groupmembership des users:ftpuser eine gruppe gefunden (nämlich die: admin mit der group-id 76) oder?

nur was bedeutet der rest danach

Jul 21 12:38:01 mod_sql/4.10[23929]: <<< cmd_getgroups
Jul 21 12:38:01 mod_sql/4.10[23929]: >>> cmd_getpwnam
Jul 21 12:38:01 mod_sql/4.10[23929]: cache hit for user 'ftpuser'
Jul 21 12:38:01 mod_sql/4.10[23929]: <<< cmd_getpwnam
Jul 21 12:38:01 mod_sql/4.10[23929]: >>> cmd_getpwnam
Jul 21 12:38:01 mod_sql/4.10[23929]: cache hit for user 'ftpuser'
Jul 21 12:38:01 mod_sql/4.10[23929]: <<< cmd_getpwnam
Jul 21 12:38:01 mod_sql/4.10[23929]: >>> cmd_getgrgid
Jul 21 12:38:01 mod_sql/4.10[23929]: cache miss for gid '1'
Jul 21 12:38:01 mod_sql/4.10[23929]: : entering    mysql cmd_select
Jul 21 12:38:01 mod_sql/4.10[23929]: entering    mysql cmd_open
Jul 21 12:38:01 mod_sql/4.10[23929]: connection 'default' count is now 2
Jul 21 12:38:01 mod_sql/4.10[23929]: exiting    mysql cmd_open
Jul 21 12:38:01 mod_sql/4.10[23929]: query "SELECT groupname FROM groups WHERE (id = 1) LIMIT 1"
Jul 21 12:38:01 mod_sql/4.10[23929]: entering    mysql cmd_close
Jul 21 12:38:01 mod_sql/4.10[23929]: connection 'default' count is now 1
Jul 21 12:38:01 mod_sql/4.10[23929]: exiting    mysql cmd_close
Jul 21 12:38:01 mod_sql/4.10[23929]: exiting    mysql cmd_select
Jul 21 12:38:01 mod_sql/4.10[23929]: <<< cmd_getgrgid
Jul 21 12:38:01 mod_sql/4.10[23929]: >>> cmd_getpwnam
Jul 21 12:38:01 mod_sql/4.10[23929]: cache hit for user 'ftpuser'
Jul 21 12:38:01 mod_sql/4.10[23929]: <<< cmd_getpwnam
Jul 21 12:38:01 mod_sql/4.10[23929]: >>> cmd_gid2name
Jul 21 12:38:01 mod_sql/4.10[23929]: cache miss for gid '1'
Jul 21 12:38:01 mod_sql/4.10[23929]: : entering    mysql cmd_select
Jul 21 12:38:01 mod_sql/4.10[23929]: entering    mysql cmd_open
Jul 21 12:38:01 mod_sql/4.10[23929]: connection 'default' count is now 2
Jul 21 12:38:01 mod_sql/4.10[23929]: exiting    mysql cmd_open
Jul 21 12:38:01 mod_sql/4.10[23929]: query "SELECT groupname FROM groups WHERE (id = 1) LIMIT 1"
Jul 21 12:38:01 mod_sql/4.10[23929]: entering    mysql cmd_close
Jul 21 12:38:01 mod_sql/4.10[23929]: connection 'default' count is now 1
Jul 21 12:38:01 mod_sql/4.10[23929]: exiting    mysql cmd_close
Jul 21 12:38:01 mod_sql/4.10[23929]: exiting    mysql cmd_select
Jul 21 12:38:01 mod_sql/4.10[23929]: <<< cmd_gid2name
Jul 21 12:38:01 mod_sql/4.10[23929]: >>> cmd_auth
Jul 21 12:38:01 mod_sql/4.10[23929]: entering    mysql cmd_escapestring
Jul 21 12:38:01 mod_sql/4.10[23929]: exiting    mysql cmd_escapestring
Jul 21 12:38:01 mod_sql/4.10[23929]: cache hit for user 'ftpuser'
Jul 21 12:38:01 mod_sql/4.10[23929]: >>> cmd_check
Jul 21 12:38:01 mod_sql/4.10[23929]: checking auth_type Crypt
Jul 21 12:38:01 mod_sql/4.10[23929]: 'Crypt' auth handler reports success
Jul 21 12:38:01 mod_sql/4.10[23929]: cache hit for user 'ftpuser'
Jul 21 12:38:01 mod_sql/4.10[23929]: <<< cmd_check
Jul 21 12:38:01 mod_sql/4.10[23929]: <<< cmd_auth
Jul 21 12:38:01 mod_sql/4.10[23929]: >>> log_master
Jul 21 12:38:01 mod_sql/4.10[23929]: >>> _process_named_query
Jul 21 12:38:01 mod_sql/4.10[23929]: entering    mysql cmd_escapestring
Jul 21 12:38:01 mod_sql/4.10[23929]: exiting    mysql cmd_escapestring
Jul 21 12:38:01 mod_sql/4.10[23929]: entering    mysql cmd_update
Jul 21 12:38:01 mod_sql/4.10[23929]: entering    mysql cmd_open
Jul 21 12:38:01 mod_sql/4.10[23929]: connection 'default' count is now 2
Jul 21 12:38:01 mod_sql/4.10[23929]: exiting    mysql cmd_open
Jul 21 12:38:01 mod_sql/4.10[23929]: query "UPDATE users SET count=count+1, lastlogin=NOW() WHERE username = 'ftpuser'"
Jul 21 12:38:01 mod_sql/4.10[23929]: entering    mysql cmd_close
Jul 21 12:38:01 mod_sql/4.10[23929]: connection 'default' count is now 1
Jul 21 12:38:01 mod_sql/4.10[23929]: exiting    mysql cmd_close
Jul 21 12:38:01 mod_sql/4.10[23929]: exiting    mysql cmd_update
Jul 21 12:38:01 mod_sql/4.10[23929]: <<< _process_named_query
Jul 21 12:38:01 mod_sql/4.10[23929]: <<< log_master
Jul 21 12:38:02 mod_sql/4.10[23929]: >>> cmd_gid2name
Jul 21 12:38:02 mod_sql/4.10[23929]: cache miss for gid '0'
Jul 21 12:38:02 mod_sql/4.10[23929]: : entering    mysql cmd_select
Jul 21 12:38:02 mod_sql/4.10[23929]: entering    mysql cmd_open
Jul 21 12:38:02 mod_sql/4.10[23929]: connection 'default' count is now 2
Jul 21 12:38:02 mod_sql/4.10[23929]: exiting    mysql cmd_open
Jul 21 12:38:02 mod_sql/4.10[23929]: query "SELECT groupname FROM groups WHERE (id = 0) LIMIT 1"
Jul 21 12:38:02 mod_sql/4.10[23929]: entering    mysql cmd_close
Jul 21 12:38:02 mod_sql/4.10[23929]: connection 'default' count is now 1
Jul 21 12:38:02 mod_sql/4.10[23929]: exiting    mysql cmd_close
Jul 21 12:38:02 mod_sql/4.10[23929]: exiting    mysql cmd_select
Jul 21 12:38:02 mod_sql/4.10[23929]: <<< cmd_gid2name
Jul 21 12:38:02 mod_sql/4.10[23929]: >>> cmd_uid2name
Jul 21 12:38:02 mod_sql/4.10[23929]: cache miss for uid '0'
Jul 21 12:38:02 mod_sql/4.10[23929]: no user uid field configured, declining to lookup uid '0'
Jul 21 12:38:02 mod_sql/4.10[23929]: <<< cmd_uid2name
Jul 21 12:38:02 mod_sql/4.10[23929]: >>> cmd_gid2name
Jul 21 12:38:02 mod_sql/4.10[23929]: cache miss for gid '0'
Jul 21 12:38:02 mod_sql/4.10[23929]: : entering    mysql cmd_select
Jul 21 12:38:02 mod_sql/4.10[23929]: entering    mysql cmd_open
Jul 21 12:38:02 mod_sql/4.10[23929]: connection 'default' count is now 2
Jul 21 12:38:02 mod_sql/4.10[23929]: exiting    mysql cmd_open
Jul 21 12:38:02 mod_sql/4.10[23929]: query "SELECT groupname FROM groups WHERE (id = 0) LIMIT 1"
Jul 21 12:38:02 mod_sql/4.10[23929]: entering    mysql cmd_close
Jul 21 12:38:02 mod_sql/4.10[23929]: connection 'default' count is now 1
Jul 21 12:38:02 mod_sql/4.10[23929]: exiting    mysql cmd_close
Jul 21 12:38:02 mod_sql/4.10[23929]: exiting    mysql cmd_select
Jul 21 12:38:02 mod_sql/4.10[23929]: <<< cmd_gid2name
Jul 21 12:38:02 mod_sql/4.10[23929]: >>> cmd_uid2name
Jul 21 12:38:02 mod_sql/4.10[23929]: cache miss for uid '0'
Jul 21 12:38:02 mod_sql/4.10[23929]: no user uid field configured, declining to lookup uid '0'
Jul 21 12:38:02 mod_sql/4.10[23929]: <<< cmd_uid2name
Jul 21 12:38:02 mod_sql/4.10[23929]: >>> cmd_gid2name
Jul 21 12:38:02 mod_sql/4.10[23929]: cache miss for gid '100'
Jul 21 12:38:02 mod_sql/4.10[23929]: : entering    mysql cmd_select
Jul 21 12:38:02 mod_sql/4.10[23929]: entering    mysql cmd_open
Jul 21 12:38:02 mod_sql/4.10[23929]: connection 'default' count is now 2
Jul 21 12:38:02 mod_sql/4.10[23929]: exiting    mysql cmd_open
Jul 21 12:38:02 mod_sql/4.10[23929]: query "SELECT groupname FROM groups WHERE (id = 100) LIMIT 1"
Jul 21 12:38:02 mod_sql/4.10[23929]: entering    mysql cmd_close
Jul 21 12:38:02 mod_sql/4.10[23929]: connection 'default' count is now 1
Jul 21 12:38:02 mod_sql/4.10[23929]: exiting    mysql cmd_close
Jul 21 12:38:02 mod_sql/4.10[23929]: exiting    mysql cmd_select
Jul 21 12:38:02 mod_sql/4.10[23929]: <<< cmd_gid2name
Jul 21 12:38:02 mod_sql/4.10[23929]: >>> cmd_uid2name
Jul 21 12:38:02 mod_sql/4.10[23929]: matched current user
Jul 21 12:38:02 mod_sql/4.10[23929]: <<< cmd_uid2name
Jul 21 12:38:02 mod_sql/4.10[23929]: >>> cmd_gid2name
Jul 21 12:38:02 mod_sql/4.10[23929]: cache miss for gid '0'
Jul 21 12:38:02 mod_sql/4.10[23929]: : entering    mysql cmd_select
Jul 21 12:38:02 mod_sql/4.10[23929]: entering    mysql cmd_open
Jul 21 12:38:02 mod_sql/4.10[23929]: connection 'default' count is now 2
Jul 21 12:38:02 mod_sql/4.10[23929]: exiting    mysql cmd_open
Jul 21 12:38:02 mod_sql/4.10[23929]: query "SELECT groupname FROM groups WHERE (id = 0) LIMIT 1"
Jul 21 12:38:02 mod_sql/4.10[23929]: entering    mysql cmd_close
Jul 21 12:38:02 mod_sql/4.10[23929]: connection 'default' count is now 1
Jul 21 12:38:02 mod_sql/4.10[23929]: exiting    mysql cmd_close
Jul 21 12:38:02 mod_sql/4.10[23929]: exiting    mysql cmd_select
Jul 21 12:38:02 mod_sql/4.10[23929]: <<< cmd_gid2name
Jul 21 12:38:02 mod_sql/4.10[23929]: >>> cmd_uid2name
Jul 21 12:38:02 mod_sql/4.10[23929]: cache miss for uid '0'
Jul 21 12:38:02 mod_sql/4.10[23929]: no user uid field configured, declining to lookup uid '0'

Jul 21 12:38:02 mod_sql/4.10[23929]: <<< cmd_uid2name

besonders das rot markierte irritiert mich schon sehr :shock:

das seltsame ist ja das das auslesen der user aus der db einwandfrei funktioniert (sonst könnte ich ja keine einschränkung auf userebene durchführen => nur halt die gruppenzugehörigkeit scheint er nicht zu fressen (bzw. aus der db rückzubekommen)

hat da keiner einen rat / hilfe für mich  :?: