Am liebsten hätte ich alleine schon wegen Deiner elendigen und zusammenhangslosen Schreibe ohne Punkt
und Komma diesen Thread ignoriert.
Danke das du es trotzdem machst
.
Also, ich hab es jetzt geschafft ProFTPD 1.3.0a zu installieren. Ich habe für das kompilieren ausgeführt:
./configure \
./configure \
--with-modules=mod_sql:mod_sql_mysql \
--with-includes=/usr/include/mysql \
--with-libraries=/usr/lib \
\
--prefix=/usr/local/proftpd \
--sysconfdir=/etc --localstatedir=/var/run --mandir=/usr/local/man
make
make install
/usr/include/mysql und /usr/lib sind die richtigen Verzeichnisse, nur mal so nebenbei.
Es hat auch mit der Installation alles geklappt.
Naja, ich habe nun in die /etc/proftpd.conf die SQL Abfragen reingeschrieben. Wenn das aber drin steht verbindet er nicht.
Hab hier den proftpd-sql.log
Mar 09 20:08:23 mod_sql/4.2.1[2414]: defaulting to 'mysql' backend
Mar 09 20:08:23 mod_sql/4.2.1[2414]: backend module 'mod_sql_mysql/4.05'
Mar 09 20:08:23 mod_sql/4.2.1[2414]: backend api 'mod_sql_api_v2'
Mar 09 20:08:23 mod_sql/4.2.1[2414]: >>> sql_sess_init
Mar 09 20:08:23 mod_sql/4.2.1[2414]: entering mysql cmd_defineconnection
Mar 09 20:08:23 mod_sql/4.2.1[2414]: name: 'default'
Mar 09 20:08:23 mod_sql/4.2.1[2414]: user: 'syscp'
Mar 09 20:08:23 mod_sql/4.2.1[2414]: host: 'localhost'
Mar 09 20:08:23 mod_sql/4.2.1[2414]: db: 'syscp'
Mar 09 20:08:23 mod_sql/4.2.1[2414]: port: '3306'
Mar 09 20:08:23 mod_sql/4.2.1[2414]: ttl: '0'
Mar 09 20:08:23 mod_sql/4.2.1[2414]: exiting mysql cmd_defineconnection
Mar 09 20:08:23 mod_sql/4.2.1[2414]: entering mysql cmd_open
Mar 09 20:08:23 mod_sql/4.2.1[2414]: exiting mysql cmd_open
Mar 09 20:08:23 mod_sql/4.2.1[2414]: unrecoverable backend error
Mar 09 20:08:23 mod_sql/4.2.1[2414]: error: '1251'
Mar 09 20:08:23 mod_sql/4.2.1[2414]: message: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client'
und die proftpd.conf
# 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 "illidan.dyndns.org Server"
ServerType standalone
DefaultServer on
# 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
# To cause every FTP user to be "jailed" (chrooted) into their home
# directory, uncomment this line.
#DefaultRoot ~
# Normally, we want files to be overwriteable.
AllowOverwrite on
# Bar use of SITE CHMOD by default
<Limit SITE_CHMOD>
DenyAll
</Limit>
# A basic anonymous configuration, no upload directories. If you do not
# want anonymous users, simply delete this entire <Anonymous> section.
<Anonymous ~ftp>
User ftp
Group ftp
# We want clients to be able to login with "anonymous" as well as "ftp"
UserAlias anonymous ftp
# Limit the maximum number of anonymous logins
MaxClients 10
# We want 'welcome.msg' displayed at login, and '.message' displayed
# in each newly chdired directory.
DisplayLogin welcome.msg
DisplayFirstChdir .message
# Limit WRITE everywhere in the anonymous chroot
<Limit WRITE>
DenyAll
</Limit>
</Anonymous>
DefaultRoot ~
RequireValidShell off
AuthOrder mod_sql.c
SQLAuthTypes Crypt Plaintext
SQLAuthenticate users* groups*
SQLConnectInfo syscp@localhost syscp passwort
SQLUserInfo ftp_users username password uid gid homedir shell
SQLGroupInfo ftp_groups groupname gid members
SQLUserWhereClause "login_enabled = 'y'"
SQLLog PASS login
SQLNamedQuery login UPDATE "last_login=now(), login_count=login_count+1 WHERE username='%u'" ftp_users
SQLLog RETR download
SQLNamedQuery download UPDATE "down_count=down_count+1, down_bytes=down_bytes+%b WHERE username='%u'" ftp_users
SQLLog STOR upload
SQLNamedQuery upload UPDATE "up_count=up_count+1, up_bytes=up_bytes+%b WHERE username='%u'" ftp_users
SQLLogFile /var/log/proftpd-sql.log
Ich habe MySQL so installiert:
apt-get install mysql-server mysql-client php5-mysql
Somit sollte, stand zumindenst auf den Seiten mit dem Befehl, MySQL 5 installiert werden.
Ich frag mich jetzt woran es liegt das
Mar 09 20:08:23 mod_sql/4.2.1[2414]: error: '1251'
Mar 09 20:08:23 mod_sql/4.2.1[2414]: message: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client'
diese Fehlermeldung wieder kommt. Genau wegen diesem Problem hab ich proftpd nicht per apt-get installiert.
Und nun hab ich das selbe Problem wieder ... .
Ich werd da einfach nicht schlau.
Ich hoffe diesmal, kann man mein Text lesen.
MFG
Illidan
Beitrag auf Wunsch geändert - VolGas
