|
Titel: User erhält nicht die Gruppenberechtigung? Beitrag von: Jens am 17. Juli 2004, 18:35:28 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. Titel: Re: User erhält nicht die Gruppenberechtigung? Beitrag von: stonki am 20. Juli 2004, 10:26:11 poste bitte mal ein genaues Beispiel... inkl. Debug Ausgabe
Titel: User erhält nicht die Gruppenberechtigung Beitrag von: Technobabel am 20. Juli 2004, 16:25:42 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) Zitat 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) Zitat 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 Zitat # '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?? Titel: Re: User erhält nicht die Gruppenberechtigung Beitrag von: stonki am 20. Juli 2004, 16:41:22 Bevor wir uns weiter vertiefen, bitte eine Sache beachten:
http://www.proftpd.de/index.php?id=28&language=&directive_name=SQLMinUserGID&module_id=&=OK Zitat von: "Technobabel" 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 Titel: User erhält nicht die Gruppenberechtigung? Beitrag von: Technobabel am 20. Juli 2004, 17:03:53 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 Zitat 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 Zitat 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" Zitat 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? Titel: User erhält nicht die Gruppenberechtigung? Beitrag von: stonki am 20. Juli 2004, 17:08:22 Deine MinGid ist 500, die Gruppen sind aber 68,69 ?
Titel: User erhält nicht die Gruppenberechtigung? Beitrag von: Technobabel am 20. Juli 2004, 17:15:52 Zitat von: "stonki" 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? Titel: User erhält nicht die Gruppenberechtigung? Beitrag von: stonki am 20. Juli 2004, 17:20:38 Zitat von: "Technobabel" 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 Titel: User erhält nicht die Gruppenberechtigung? Beitrag von: Technobabel am 20. Juli 2004, 17:33:05 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: Zitat 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 Zitat 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 Titel: User erhält nicht die Gruppenberechtigung? Beitrag von: Technobabel am 21. Juli 2004, 10:49:00 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 Zitat 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 Zitat 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 :?: |