Hallo,
bei mir klappt der Login über ein Custom Login leider nicht, die Abfrage an sich scheint zu klappen, aber danach gehts nicht weiter, wäre nett wenn einer was dazu weiß, ich verzweifel schon, hab schon das halbe Forum gelesen (*übertreib*) und eine Nacht durchproviert :roll:
SQL Log:
Jul 30 19:56:28 mod_sql/4.10[19937]: backend module 'mod_sql_mysql/4.04'
Jul 30 19:56:28 mod_sql/4.10[19937]: backend api 'mod_sql_api_v1'
Jul 30 19:56:28 mod_sql/4.10[19937]: >>> sql_getconf
Jul 30 19:56:28 mod_sql/4.10[19937]: entering mysql cmd_defineconnection
Jul 30 19:56:28 mod_sql/4.10[19937]: name: 'default'
Jul 30 19:56:28 mod_sql/4.10[19937]: user: 'root'
Jul 30 19:56:28 mod_sql/4.10[19937]: host: 'localhost'
Jul 30 19:56:28 mod_sql/4.10[19937]: db: 'webspace'
Jul 30 19:56:28 mod_sql/4.10[19937]: port: '3306'
Jul 30 19:56:28 mod_sql/4.10[19937]: ttl: '0'
Jul 30 19:56:28 mod_sql/4.10[19937]: exiting mysql cmd_defineconnection
Jul 30 19:56:28 mod_sql/4.10[19937]: entering mysql cmd_open
Jul 30 19:56:28 mod_sql/4.10[19937]: connection 'default' opened
Jul 30 19:56:28 mod_sql/4.10[19937]: connection 'default' count is now 1
Jul 30 19:56:28 mod_sql/4.10[19937]: exiting mysql cmd_open
Jul 30 19:56:28 mod_sql/4.10[19937]: backend successfully connected.
Jul 30 19:56:28 mod_sql/4.10[19937]: mod_sql status : on
Jul 30 19:56:28 mod_sql/4.10[19937]: negative_cache : off
Jul 30 19:56:28 mod_sql/4.10[19937]: authenticate : users
Jul 30 19:56:28 mod_sql/4.10[19937]: usertable : users
Jul 30 19:56:28 mod_sql/4.10[19937]: userid field : userid
Jul 30 19:56:28 mod_sql/4.10[19937]: password field : passwd
Jul 30 19:56:28 mod_sql/4.10[19937]: uid field : uid
Jul 30 19:56:28 mod_sql/4.10[19937]: gid field : gid
Jul 30 19:56:28 mod_sql/4.10[19937]: homedir field : homedir
Jul 30 19:56:28 mod_sql/4.10[19937]: shell field : shell
Jul 30 19:56:28 mod_sql/4.10[19937]: homedirondemand : false
Jul 30 19:56:28 mod_sql/4.10[19937]: SQLMinUserUID : 500
Jul 30 19:56:28 mod_sql/4.10[19937]: SQLMinUserGID : 100
Jul 30 19:56:28 mod_sql/4.10[19937]: <<< sql_getconf
Jul 30 19:56:28 mod_sql/4.10[19937]: >>> cmd_getpwnam
Jul 30 19:56:28 mod_sql/4.10[19937]: entering mysql cmd_escapestring
Jul 30 19:56:28 mod_sql/4.10[19937]: exiting mysql cmd_escapestring
Jul 30 19:56:28 mod_sql/4.10[19937]: cache miss for user 'demo2'
Jul 30 19:56:28 mod_sql/4.10[19937]: >>> sql_lookup
Jul 30 19:56:28 mod_sql/4.10[19937]: >>> _process_named_query
Jul 30 19:56:28 mod_sql/4.10[19937]: entering mysql cmd_escapestring
Jul 30 19:56:28 mod_sql/4.10[19937]: exiting mysql cmd_escapestring
Jul 30 19:56:28 mod_sql/4.10[19937]: entering mysql cmd_query
Jul 30 19:56:28 mod_sql/4.10[19937]: entering mysql cmd_open
Jul 30 19:56:28 mod_sql/4.10[19937]: connection 'default' count is now 2
Jul 30 19:56:28 mod_sql/4.10[19937]: exiting mysql cmd_open
Jul 30 19:56:28 mod_sql/4.10[19937]: query "SELECT kunden.username, kunden.password as passwd, kunden.uid, kunden.gid, kunden.homedir, kunden.shell FROM kunden left join traffic on traffic.user = kunden.id WHERE kunden.username = 'demo2' and traffic <= (traffic_limit*(1024*1024)) and kunden.online = 1 and kunden.ftp = 1"
Jul 30 19:56:28 mod_sql/4.10[19937]: entering mysql cmd_close
Jul 30 19:56:28 mod_sql/4.10[19937]: connection 'default' count is now 1
Jul 30 19:56:28 mod_sql/4.10[19937]: exiting mysql cmd_close
Jul 30 19:56:28 mod_sql/4.10[19937]: exiting mysql cmd_query
Jul 30 19:56:28 mod_sql/4.10[19937]: <<< _process_named_query
Jul 30 19:56:28 mod_sql/4.10[19937]: <<< sql_lookup
Jul 30 19:56:28 mod_sql/4.10[19937]: cache miss for user 'demo2'
Jul 30 19:56:28 mod_sql/4.10[19937]: user 'demo2' cached
Jul 30 19:56:28 mod_sql/4.10[19937]: + pwd.pw_name : demo2
Jul 30 19:56:28 mod_sql/4.10[19937]: + pwd.pw_uid : 65534
Jul 30 19:56:28 mod_sql/4.10[19937]: + pwd.pw_gid : 65534
Jul 30 19:56:28 mod_sql/4.10[19937]: + pwd.pw_dir : /srv/www/htdocs/demo2
Jul 30 19:56:28 mod_sql/4.10[19937]: + pwd.pw_shell : /bin/false
Jul 30 19:56:28 mod_sql/4.10[19937]: <<< cmd_getpwnam
Jul 30 19:56:28 mod_sql/4.10[19937]: >>> cmd_auth
Jul 30 19:56:28 mod_sql/4.10[19937]: entering mysql cmd_escapestring
Jul 30 19:56:28 mod_sql/4.10[19937]: exiting mysql cmd_escapestring
Jul 30 19:56:28 mod_sql/4.10[19937]: cache hit for user 'demo2'
Jul 30 19:56:28 mod_sql/4.10[19937]: >>> cmd_check
Jul 30 19:56:28 mod_sql/4.10[19937]: checking auth_type Plaintext
Jul 30 19:56:28 mod_sql/4.10[19937]: 'Plaintext' auth handler reports success
Jul 30 19:56:28 mod_sql/4.10[19937]: cache hit for user 'demo2'
Jul 30 19:56:28 mod_sql/4.10[19937]: <<< cmd_check
Jul 30 19:56:28 mod_sql/4.10[19937]: <<< cmd_auth
Jul 30 19:56:28 mod_sql/4.10[19937]: >>> cmd_getpwnam
Jul 30 19:56:28 mod_sql/4.10[19937]: cache hit for user 'demo2'
Jul 30 19:56:28 mod_sql/4.10[19937]: <<< cmd_getpwnam
Config:
# This is a basic ProFTPD configuration file (rename it to
# '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 "Proftpd FTP Server"
ServerType standalone
DefaultServer on
RequireValidShell off
#AuthPAM off
#AuthPAMConfig ftp
SystemLog /var/log/proftpd
#SyslogLevel debug
# Port 21 is the standard FTP port.
Port 21
# Umask 022 is a good standard umask to prevent new dirs and files
# from being group and world writable.
Umask 022
# To prevent DoS attacks, set the maximum number of child processes
# to 30. If you need to allow more than 30 concurrent connections
# at once, simply increase this value. Note that this ONLY works
# in standalone mode, in inetd mode you should use an inetd server
# that allows you to limit maximum number of processes per service
# (such as xinetd).
MaxInstances 30
# Set the user and group under which the server will run.
User nobody
Group nogroup
RootLogin Off
# Normally, we want files to be overwriteable.
<Directory />
AllowOverwrite on
</Directory>
# A basic anonymous configuration, no upload directories.
<Global>
DefaultRoot /
</Global>
TransferLog /var/log/proftpd.xferlog
# Some logging formats
LogFormat default "%h %l %u %t \"%r\" %s %b"
LogFormat auth "%v [%P] %h %t \"%r\" %s"
LogFormat write "%h %l %u %t \"%r\" %s %b"
# Log file/dir access
ExtendedLog /var/log/proftpd.access_log WRITE,READ write
# Record all logins
ExtendedLog /var/log/proftpd.auth_log AUTH auth
# Paranoia logging level....
ExtendedLog /var/log/proftpd.paranoid_log ALL default
SQLLogFile /var/log/proftpd.sql.log
SQLAuthenticate users
SQLUserInfo custom:/login
SQLAuthTypes Plaintext
SQLConnectInfo webspace@localhost root xxxxx
SQLMinUserGID 100
SQLMinUserUID 500
SQLDefaultUserGID 65534
SQLDefaultUserUID 65534
SQLNamedQuery login FREEFORM "SELECT kunden.username, kunden.password as passwd, kunden.uid, kunden.gid, kunden.homedir, kunden.shell FROM kunden left join traffic on traffic.user = kunden.id WHERE kunden.username = '%U' and traffic <= (traffic_limit*(1024*1024)) and kunden.online = 1 and kunden.ftp = 1"
DefaultRoot ~
Da er ja zB das Home Dir richtig ausliest denke ich mal dass dieser Teil ja soweit klappen muß, er bricht halt hier nur einfach ab
also er bleibt genau da hängen wo ich im Log aufgehört habe.
Gruß,
Christopher
