www.ProFTPD.de

ProFTPD => ProFTPD - Deutsch => Thema gestartet von: Anonymous am 04. März 2004, 10:30:45



Titel: Mysql Login funktioniert nicht!
Beitrag von: Anonymous am 04. März 2004, 10:30:45
Ich habe laut dem HOWTO auf proftpd.de die mysql Unterstützung kompiliert was auch alles funktioniert.

Leider kann ich mich nicht per Ftp einloggen.Ich benutze das Tool Proma
Hier ein Auszug aus der FTPCONF (Testsystem):
Code:

# This is a basic ProFTPD configuration file. It establishes a single
# server and a single anonymous login. It assumes that you have a
# user/group "nobody"/"nogroup" for normal operation and anon.

#    !!! PLEASE read the documentation of proftpd !!!
#
# You can find the documentation in /usr/doc/packages/proftpd/,
# http://www.proftpd.org/ and don't forget to read carefully
# and _follow_ hints on http://www.proftpd.net/security.html.


#
# geaendert: 03.11.2001 für ProFTP 1.2.4 und mod_sql 4.x
#

#
# Basic
#
ServerName "Stonki"
serverType inetd
ServerAdmin support@stonki.de

#
# Debug Level
# emerg, alert, crit (empfohlen), error, warn. notice, info, debug
#
#SyslogLevel emerg
#SystemLog /var/log/proftpd.system.log

#
# uncomment, if you want to hide the servers name:
#
ServerIdent on "Stonki's Server"
DeferWelcome on
DefaultServer on

#
# Display
#
DisplayLogin /messages/ftp.motd
DisplayConnect /net/messages/ftp.pre
DisplayFirstChdir index.txt

HiddenStor off
DirFakeUser on stonki
DirFakeGroup on stonki
DirFakeMode 0000



# Enable PAM for authentication...
#
AuthPAM on

# Setting this directive to on will cause authentication to fail
# if PAM authentication fails. The default setting, off, allows
# other modules and directives such as AuthUserFile and friends
# to authenticate users.
#
# AuthPAMAuthoritative on

# This directive allows you to specify the PAM service name used
# in authentication (default is "proftpd" on SuSE Linux).
# You have to setup the service in the /etc/pam.d/<other_name>.
#
#AuthPAMConfig <other_name>

# Port 21 is the standard FTP port.
Port 21

#------------------------mysql Modul: 4.x
#
# Zugangskontrolle
#
################################################
   ############### mysql Modul: 4.x ###############
   ################################################
   SQLConnectInfo        proftp@127.0.0.1 heribert heribert
SQLAuthenticate       users
SQLAuthTypes          backend
SQLDefaultHomedir     /srv/www/htdocs
SQLUserInfo           users userid passwd uid gid homedir shell
SQLGroupInfo          groups groupname gid members
SQLLog                PASS updatecount
SQLNamedQuery         updatecount UPDATE "count=count+1 WHERE userid='%u'" users


#------------------------mysql

# Port 21 is the standard FTP port.
Port                            21

# disable listen on 0.0.0.0:21 - the port (and IP) should
# be specified explicitly in each VirtualHost definition
#
#Port                           0

# listen for each (additional) address explicitly that is
# specified (via Bind and Port) in a VirtualHost definition
#
#SocketBindTight on

#
# FXP Unterstuetzung
#
AllowForeignAddress on


# Umask 022 is a good standard umask to prevent new dirs
# and files from being group and world writable.
Umask 022

# Set the user and group that the server normally runs at.
User nobody
Group nogroup

# Maximal Werte setzen
MaxClientsPerHost 3 "Nicht mehr als %m  Verbindungen"
MaxClients 5 "Leider sind schon %m Clients verbunden"

# RateReadBPS             5000
# RateReadFreeBytes       5000
# RateReadHardBPS         on

Classes on
Class default           limit 5
Class internet          limit 2
Class local             limit 3
Class internet          ip 0.0.0.0/0
Class internet ip 192.168.99.99/24
Class local             ip 127.0.0.1/24
Class local             ip 192.168.0.0/24

#
# Restart erlauben
#
AllowStoreRestart on
AllowRetrieveRestart on

# Normally, we want files to be overwriteable.
<Global>

MaxLoginAttempts 3
DefaultRoot ~ ftp
RootLogin off
AllowOverwrite on
AllowStoreRestart off
MaxClients 10
MaxClientsPerHost 10
</Global>
tcpNoDelay on





# It is a very good idea to allow only filenames containing normal
# alphanumeric characters for uploads (and not shell code...)
#PathAllowFilter "^[a-zA-Z0-9_.-]()'+$"
#PathAllowFilter "^[a-zA-Z0-9 _.-]()'+$"

# We don't want .ftpaccess or .htaccess files to be uploaded
#PathDenyFilter "(\.ftp)|(\.ht)[a-z]+$"
#PathDenyFilter "\.ftp[a-z]+$"

# Do not allow to pass printf-Formats (security! see documentation!):
#AllowFilter "^[a-zA-Z0-9@~ /,_.-]*$"
#DenyFilter  "%"

# 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

# Performance: skip DNS resolution when we process the logs...
UseReverseDNS       on

# Turn off Ident lookups
IdentLookups         on

# Set the maximum number of seconds a data connection is allowed
# to "stall" before being aborted.
TimeoutStalled                  300

# Where do we put the pid files?
ScoreboardFile /usr/local/var/proftp

#
# Logging options
#
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

#
# Do a chroot for web-users (i.e. public or www group), but
# do not change root if the user is also in the users group...
#
DefaultRoot  ~ !users

#
# Limit login attempts
#
MaxLoginAttempts                3

#
# Users needs a valid shell
#
RequireValidShell               off




Vielleicht kann mir ja jemand helfen?
grüsse Drucko


Titel: Mysql Login funktioniert nicht!
Beitrag von: drucko am 04. März 2004, 10:34:12
ach ja meine sql-db:

Code:


CREATE TABLE `users` (
  `userid` varchar(255) NOT NULL default '',
  `name` varchar(255) default NULL,
  `mail` varchar(255) default NULL,
  `uid` int(11) default '65534',
  `gid` int(11) default '65534',
  `passwd` varchar(255) NOT NULL default '',
  `shell` varchar(255) NOT NULL default '/bin/nonexistent',
  `homedir` varchar(255) NOT NULL default '/srv/www/htdocs',
  `note` text,
  `count` int(11) NOT NULL default '0',
  `admin` int(1) NOT NULL default '0',
  `closed` int(1) NOT NULL default '0',
  UNIQUE KEY `userid` (`userid`)
) TYPE=MyISAM;


Titel: Mysql Login funktioniert nicht!
Beitrag von: BeTZe am 08. April 2004, 13:21:55
moin moin,
sagmal hast du das inzwischen hinbekommen?? habe nämlich genau das gleiche problem und komme da überhaupt nicht weiter.

für hilfe, danke im voraus
BeTZe