www.ProFTPD.de
13. März 2007, 19:14:30 *
Willkommen Gast. Bitte einloggen oder registrieren.
Haben Sie Ihre Aktivierungs E-Mail übersehen?

Einloggen mit Benutzername, Passwort und Sitzungslänge
News: SMF - Neu installiert!
 
   Übersicht   Hilfe Suche Login Registrieren  
Seiten: [1]   Nach unten
  Drucken  
Autor Thema: proftpd-mysql ... login get nicht  (Gelesen 281 mal)
0 Mitglieder und 1 Gast betrachten dieses Thema.
garth
Gast
« am: 27. April 2005, 05:12:03 »

moin

ich hab nen debian sage system mit mysql 4.11 oder so und habe mir die debian packete installiert proftpd-common proftpd-mysql

ok nurmale user können sich auch einlogen
nur die die ich in der db angelegt habe nicht
das hier is der log aus der proftpd.mysql
Code:
Apr 27 04:30:01 mod_sql/4.11[27022]: backend module 'mod_sql_mysql/4.04'
Apr 27 04:30:01 mod_sql/4.11[27022]: backend api    'mod_sql_api_v1'
Apr 27 04:30:01 mod_sql/4.11[27022]: >>> sql_getconf
Apr 27 04:30:01 mod_sql/4.11[27022]: entering   mysql cmd_defineconnection
Apr 27 04:30:01 mod_sql/4.11[27022]:  name: 'default'
Apr 27 04:30:01 mod_sql/4.11[27022]:  user: 'proftpd'
Apr 27 04:30:01 mod_sql/4.11[27022]:  host: 'localhost'
Apr 27 04:30:01 mod_sql/4.11[27022]:    db: 'proftpd_admin'
Apr 27 04:30:01 mod_sql/4.11[27022]:  port: '3306'
Apr 27 04:30:01 mod_sql/4.11[27022]:   ttl: '0'
Apr 27 04:30:01 mod_sql/4.11[27022]: exiting    mysql cmd_defineconnection
Apr 27 04:30:01 mod_sql/4.11[27022]: entering   mysql cmd_open
Apr 27 04:30:01 mod_sql/4.11[27022]: connection 'default' opened
Apr 27 04:30:01 mod_sql/4.11[27022]: connection 'default' count is now 1
Apr 27 04:30:01 mod_sql/4.11[27022]: exiting    mysql cmd_open
Apr 27 04:30:01 mod_sql/4.11[27022]: backend successfully connected.
Apr 27 04:30:01 mod_sql/4.11[27022]: mod_sql status     : on
Apr 27 04:30:01 mod_sql/4.11[27022]: negative_cache     : off
Apr 27 04:30:01 mod_sql/4.11[27022]: authenticate       : users
Apr 27 04:30:01 mod_sql/4.11[27022]: usertable          : usertable
Apr 27 04:30:01 mod_sql/4.11[27022]: userid field       : userid
Apr 27 04:30:01 mod_sql/4.11[27022]: password field     : passwd
Apr 27 04:30:01 mod_sql/4.11[27022]: uid field          : uid
Apr 27 04:30:01 mod_sql/4.11[27022]: gid field          : gid
Apr 27 04:30:01 mod_sql/4.11[27022]: homedir field      : homedir
Apr 27 04:30:01 mod_sql/4.11[27022]: shell field        : shell
Apr 27 04:30:01 mod_sql/4.11[27022]: homedirondemand    : false
Apr 27 04:30:01 mod_sql/4.11[27022]: SQLMinUserUID      : 999
Apr 27 04:30:01 mod_sql/4.11[27022]: SQLMinUserGID      : 999
Apr 27 04:30:01 mod_sql/4.11[27022]: <<< sql_getconf
Apr 27 04:30:01 mod_sql/4.11[27022]: >>> cmd_getpwnam
Apr 27 04:30:01 mod_sql/4.11[27022]: entering   mysql cmd_escapestring
Apr 27 04:30:01 mod_sql/4.11[27022]: exiting    mysql cmd_escapestring
Apr 27 04:30:01 mod_sql/4.11[27022]: cache miss for user 'www'
Apr 27 04:30:01 mod_sql/4.11[27022]: : entering         mysql cmd_select
Apr 27 04:30:01 mod_sql/4.11[27022]: entering   mysql cmd_open
Apr 27 04:30:01 mod_sql/4.11[27022]: connection 'default' count is now 2
Apr 27 04:30:01 mod_sql/4.11[27022]: exiting    mysql cmd_open
Apr 27 04:30:01 mod_sql/4.11[27022]: query "SELECT userid, passwd, uid, gid, homedir, shell FROM usertable WHERE (userid='www') and ((disabled=0 and (NOW()<=expiration or expiration=-1))) LIMIT 1"
Apr 27 04:30:01 mod_sql/4.11[27022]: entering   mysql cmd_close
Apr 27 04:30:01 mod_sql/4.11[27022]: connection 'default' count is now 1
Apr 27 04:30:01 mod_sql/4.11[27022]: exiting    mysql cmd_close
Apr 27 04:30:01 mod_sql/4.11[27022]: exiting    mysql cmd_select
Apr 27 04:30:01 mod_sql/4.11[27022]: <<< cmd_getpwnam
Apr 27 04:30:02 mod_sql/4.11[27022]: entering   mysql cmd_close
Apr 27 04:30:02 mod_sql/4.11[27022]: connection 'default' closed
Apr 27 04:30:02 mod_sql/4.11[27022]: connection 'default' count is now 0
Apr 27 04:30:02 mod_sql/4.11[27022]: exiting    mysql cmd_close
Apr 27 04:30:02 mod_sql/4.11[27022]: running named query 'time_logout' at exit
Apr 27 04:30:02 mod_sql/4.11[27022]: >>> _process_named_query
Apr 27 04:30:02 mod_sql/4.11[27022]: entering   mysql cmd_escapestring

aja beim installieren habe ich auch gleich das opensource admin teil installiert und mit dem admin ding hab ich auch die user angelegt

also ka wo da der fehler is  :?:

aja hier nochmal meine proftpd.conf (zumindest der sql teil davon)
Code:
ExtendedLog                     /var/log/proftpd.access_log    WRITE,READ write
ExtendedLog                     /var/log/proftpd.auth_log      AUTH auth
ExtendedLog                     /var/log/proftpd.paranoid_log  ALL default
SQLLogFile                      /var/log/proftpd.mysql

SQLAuthTypes                    Plaintext Backend Empty
SQLAuthenticate                 users*
SQLConnectInfo                  proftpd_admin@localhost proftpd *********
SQLUserInfo                     usertable userid passwd uid gid homedir shell
SQLGroupInfo                    grouptable groupname gid members
SQLUserWhereClause              "disabled=0 and (NOW()<=expiration or expiration=-1)"

# Log the user logging in
SQLLog PASS counter
SQLNamedQuery counter UPDATE "lastlogin=now(), count=count+1 WHERE userid='%u'" usertable

# logout log
SQLLog EXIT time_logout
SQLNamedQuery time_logout UPDATE "lastlogout=now() WHERE userid='%u'" usertable

# display last login time when PASS command is given
SQLNamedQuery login_time SELECT "lastlogin from usertable where userid='%u'"
SQLShowInfo PASS "230" "Last login was: %{login_time}"

# xfer Log in mysql
SQLLog RETR,STOR transfer1
SQLNamedQuery  transfer1 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'c', NULL"
xfer_stat
SQLLOG ERR_RETR,ERR_STOR transfer2
SQLNamedQuery  transfer2 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'i', NULL"
SQLNamedQuery  transfer2 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'i', NULL"
xfer_stat

AllowStoreRestart                       on
AllowRetrieveRestart                    on
RequireValidShell                       off
PathDenyFilter                          "(\.ftp)|(\.ht)[a-z]+$"
DefaultRoot                             ~
DenyFilter                              \*.*/


<Directory /ftp/*>
        AllowOverwrite                  off
        HideNoAccess                    on
        <Limit READ>
                AllowAll
        </Limit>

        <Limit WRITE>
                DenyGroup               !admins
        </Limit>
</Directory>

<Directory /ftp/incoming/*>
        AllowOverwrite                  on
        HideNoAccess                    on

        <Limit READ>
                DenyGroup               !admins
        </Limit>
Gespeichert
stonki
Administrator
ProFTPD
*****
Offline Offline

Beiträge: 1853


15318939
Profil anzeigen WWW E-Mail
« Antwort #1 am: 27. April 2005, 08:15:28 »

poste noch mal die Ausgabe von SQL Log. Das wird durch "SQLLOGFILE  /bla/blub/datei" erzeugt.

cu
stonki
Gespeichert

www.stonki.de:    the more I see, the more I know.......
www.proftpd.de:   Deutsche ProFTPD Dokumentation
www.krename.net:  Der Batch Renamer für KDE
www.kbarcode.net: Die Barcode Solution für KDE
garth
Gast
« Antwort #2 am: 27. April 2005, 15:32:53 »

hab ich doch oben das is bei mir die proftpd.mysql datei
Gespeichert
stonki
Administrator
ProFTPD
*****
Offline Offline

Beiträge: 1853


15318939
Profil anzeigen WWW E-Mail
« Antwort #3 am: 28. April 2005, 11:38:14 »

Zitat von: "garth"
hab ich doch oben das is bei mir die proftpd.mysql datei


was kommt denn bei der Abfrage raus, wenn Du die direkt in Mysql eingibst ?

SELECT userid, passwd, uid, gid, homedir, shell FROM usertable WHERE (userid='www') and ((disabled=0 and (NOW()<=expiration or expiration=-1))) LIMIT 1
Gespeichert

www.stonki.de:    the more I see, the more I know.......
www.proftpd.de:   Deutsche ProFTPD Dokumentation
www.krename.net:  Der Batch Renamer für KDE
www.kbarcode.net: Die Barcode Solution für KDE
Seiten: [1]   Nach oben
  Drucken  
 
Gehe zu:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC Prüfe XHTML 1.0 Prüfe CSS
Seite erstellt in 0.192 Sekunden mit 19 Zugriffen.