vanohaker
31-07-2011, 01:32
Здравствуйте все. Сегодня сталкнулся с проблемой. Установил на ком pure-ftpd, в конфигах всё прописал вроде правельно, добавил строку в rc.conf а автостарта сервера так и не получается. Серв стартует только когда напишеш в консоли команду pure-ftpd. И ещё почемуто не роботает связка сервера с mysql. На серв могу зайти только под анонимусом и попадаю в домашнюю папку пользователя ftp. Посмотрите пожалуйста логи и конфиг, может до меня чтото не доходит.
rc.conf
hostname="localhost"
ifconfig_nfe0="inet 192.168.1.10 netmask 255.255.255.0"
defaultrouter="192.168.1.1"
keymap="ru.koi8-r"
sshd_enable="YES"
mysql_enable="YES"
apache22_enable="YES"
pureftpd_enable="YES"
pure-ftpd.conf
ChrootEveryone yes
# TrustedGID 100
BrokenClientsCompatibility no
MaxClientsNumber 50
Daemonize yes
MaxClientsPerIP 8
VerboseLog no
DisplayDotFiles no
AnonymousOnly no
NoAnonymous yes
SyslogFacility ftp
# FortunesFile /usr/share/fortune/zippy
DontResolve yes
MaxIdleTime 10
# LDAPConfigFile /etc/pureftpd-ldap.conf
MySQLConfigFile /usr/local/etc/pureftpd-mysql.conf
# PGSQLConfigFile /etc/pureftpd-pgsql.conf
# PureDB /etc/pureftpd.pdb
# ExtAuth /var/run/ftpd.sock
# PAMAuthentication yes
UnixAuthentication yes
LimitRecursion 2000 8
AnonymousCanCreateDirs yes
MaxLoad 4
# PassivePortRange 30000 50000
# ForcePassiveIP 192.168.1.1
# AnonymousRatio 1 10
# UserRatio 1 10
AntiWarez no
# Bind 127.0.0.1,21
# AnonymousBandwidth 8
# UserBandwidth 8
Umask 133:022
MinUID 100
AllowUserFXP no
AllowAnonymousFXP no
ProhibitDotFilesWrite yes
ProhibitDotFilesRead yes
AutoRename no
AnonymousCantUpload yes
#TrustedIP 10.1.1.1
#LogPID yes
# AltLog clf:/var/log/pureftpd.log
# AltLog stats:/var/log/pureftpd.log
# AltLog w3c:/var/log/pureftpd.log
NoChmod no
KeepAllFiles no
#CreateHomeDir yes
#Quota 1000:10
#PIDFile /var/run/pure-ftpd.pid
#CallUploadScript yes
MaxDiskUsage 99
#NoRename yes
CustomerProof yes
# PerUserLimits 3:20
# NoTruncate yes
# TLS 1
IPV4Only yes
# IPV6Only yes
FileSystemCharset koi8-r
ClientCharset cp1251
pureftpd-mysql.conf
# MYSQLServer 127.0.0.1
# MYSQLPort 3306
MYSQLSocket /tmp/mysql.sock
MYSQLUser root
MYSQLPassword ************
MYSQLDatabase pureftpd
MYSQLCrypt cleartext
MYSQLGetPW SELECT Password FROM users WHERE User="\L" AND active ="1"
MYSQLGetUID SELECT uid FROM users WHERE User="\L"
#MYSQLDefaultUID 1000
MYSQLGetGID SELECT gid FROM users WHERE User="\L"
#MYSQLDefaultGID 1000
MYSQLGetDir SELECT home FROM users WHERE User="\L"
MySQLGetQTAFS SELECT QuotaFiles FROM users WHERE User="\L"
MySQLGetQTASZ SELECT QuotaSize FROM users WHERE User="\L"
MySQLGetRatioUL SELECT ULRatio FROM users WHERE User="\L"
MySQLGetRatioDL SELECT DLRatio FROM users WHERE User="\L"
MySQLGetBandwidthUL SELECT ULBandwidth FROM users WHERE User="\L"
MySQLGetBandwidthDL SELECT DLBandwidth FROM users WHERE User="\L"
# MySQLForceTildeExpansion 1
# MySQLTransactions On
в логах xferlog
Jul 30 16:05:36 localhost newsyslog[609]: logfile first created
vanohaker
31-07-2011, 13:06
debug.log
Jul 28 09:25:33 localhost newsyslog[607]: logfile first created
А файл /usr/local/etc/rc.d/pure-ftpd присутствует?
Не знаю, что и сказать.
Я пускаю pure-ftpd через inetd и без конфига, но с параметрами командной строки. Все ключи очень хорошо документированы.
Использую виртуальных пользователей, mysql не пробовал.
grep pure-ftpd /etc/inetd.conf
# pure-ftpd
ftp stream tcp nowait root /usr/local/sbin/pure-ftpd pureftpd -4 -A -c6 -C2 -d -E -F/usr/local/etc/ftp-banner -H -I10 -k95 -K -lpuredb:/usr/local/etc/pureftpd.pdb -p40000:40500 -R -s -T512:512 -u100 -X -Z
grep -i pure-ftpd /etc/hosts.allow
# Pure-ftpd server
pure-ftpd : ALL : allow
vanohaker
01-08-2011, 14:14
кароч я всё сделал. и pure-ftp запускается и mysql, да ещё и web интерфейс прикрутил к этому чуду.
кароч вот мои настройки если ктонить захочет себе поставить :)
pure-ftpd.conf
############################################################
# #
# Configuration file for pure-ftpd wrappers #
# #
############################################################
# If you want to run Pure-FTPd with this configuration
# instead of command-line options, please run the
# following command :
#
# /usr/local/sbin/pure-config.pl /usr/local/etc/pure-ftpd.conf
#
# Please don't forget to have a look at documentation at
# http://www.pureftpd.org/documentation.shtml for a complete list of
# options.
# Cage in every user in his home directory
ChrootEveryone yes
# If the previous option is set to "no", members of the following group
# won't be caged. Others will be. If you don't want chroot()ing anyone,
# just comment out ChrootEveryone and TrustedGID.
# TrustedGID 100
# Turn on compatibility hacks for broken clients
BrokenClientsCompatibility no
# Maximum number of simultaneous users
MaxClientsNumber 50
# Fork in background
Daemonize yes
# Maximum number of sim clients with the same IP address
MaxClientsPerIP 8
# If you want to log all client commands, set this to "yes".
# This directive can be duplicated to also log server responses.
VerboseLog no
# List dot-files even when the client doesn't send "-a".
DisplayDotFiles yes
# Don't allow authenticated users - have a public anonymous FTP only.
AnonymousOnly no
# Disallow anonymous connections. Only allow authenticated users.
NoAnonymous Yes
# Syslog facility (auth, authpriv, daemon, ftp, security, user, local*)
# The default facility is "ftp". "none" disables logging.
SyslogFacility ftp
# Display fortune cookies
# FortunesFile /usr/share/fortune/zippy
# Don't resolve host names in log files. Logs are less verbose, but
# it uses less bandwidth. Set this to "yes" on very busy servers or
# if you don't have a working DNS.
DontResolve yes
# Maximum idle time in minutes (default = 15 minutes)
MaxIdleTime 15
# LDAP configuration file (see README.LDAP)
# LDAPConfigFile /etc/pureftpd-ldap.conf
# MySQL configuration file (see README.MySQL)
MySQLConfigFile /usr/local/etc/pureftpd-mysql.conf
# Postgres configuration file (see README.PGSQL)
# PGSQLConfigFile /etc/pureftpd-pgsql.conf
# PureDB user database (see README.Virtual-Users)
# PureDB /etc/pureftpd.pdb
# Path to pure-authd socket (see README.Authentication-Modules)
# ExtAuth /var/run/ftpd.sock
# If you want to enable PAM authentication, uncomment the following line
# PAMAuthentication yes
# If you want simple Unix (/etc/passwd) authentication, uncomment this
# UnixAuthentication yes
# Please note that LDAPConfigFile, MySQLConfigFile, PAMAuthentication and
# UnixAuthentication can be used only once, but they can be combined
# together. For instance, if you use MySQLConfigFile, then UnixAuthentication,
# the SQL server will be asked. If the SQL authentication fails because the
# user wasn't found, another try # will be done with /etc/passwd and
# /etc/shadow. If the SQL authentication fails because the password was wrong,
# the authentication chain stops here. Authentication methods are chained in
# the order they are given.
# 'ls' recursion limits. The first argument is the maximum number of
# files to be displayed. The second one is the max subdirectories depth
LimitRecursion 10000 50
# Are anonymous users allowed to create new directories ?
AnonymousCanCreateDirs no
# If the system is more loaded than the following value,
# anonymous users aren't allowed to download.
MaxLoad 4
# Port range for passive connections replies. - for firewalling.
# PassivePortRange 30000 50000
# Force an IP address in PASV/EPSV/SPSV replies. - for NAT.
# Symbolic host names are also accepted for gateways with dynamic IP
# addresses.
# ForcePassiveIP 192.168.0.1
# Upload/download ratio for anonymous users.
# AnonymousRatio 1 10
# Upload/download ratio for all users.
# This directive superscedes the previous one.
# UserRatio 1 10
# Disallow downloading of files owned by "ftp", ie.
# files that were uploaded but not validated by a local admin.
AntiWarez yes
# IP address/port to listen to (default=all IP and port 21).
# Bind 127.0.0.1,21
# Maximum bandwidth for anonymous users in KB/s
# AnonymousBandwidth 8
# Maximum bandwidth for *all* users (including anonymous) in KB/s
# Use AnonymousBandwidth *or* UserBandwidth, both makes no sense.
# UserBandwidth 8
# File creation mask. <umask for files>:<umask for dirs> .
# 177:077 if you feel paranoid.
Umask 133:022
# Minimum UID for an authenticated user to log in.
MinUID 80
# Allow FXP transfers for authenticated users.
AllowUserFXP no
# Allow anonymous FXP for anonymous and non-anonymous users.
AllowAnonymousFXP no
# Users can't delete/write files beginning with a dot ('.')
# even if they own them. If TrustedGID is enabled, this group
# will have access to dot-files, though.
ProhibitDotFilesWrite no
# Prohibit *reading* of files beginning with a dot (.history, .ssh...)
ProhibitDotFilesRead no
# Never overwrite files. When a file whoose name already exist is uploaded,
# it get automatically renamed to file.1, file.2, file.3, ...
AutoRename no
# Disallow anonymous users to upload new files (no = upload is allowed)
AnonymousCantUpload yes
# Only connections to this specific IP address are allowed to be
# non-anonymous. You can use this directive to open several public IPs for
# anonymous FTP, and keep a private firewalled IP for remote administration.
# You can also only allow a non-routable local IP (like 10.x.x.x) to
# authenticate, and keep a public anon-only FTP server on another IP.
#TrustedIP 10.1.1.1
# If you want to add the PID to every logged line, uncomment the following
# line.
#LogPID yes
# Create an additional log file with transfers logged in a Apache-like format :
# fw.c9x.org - jedi [13/Dec/1975:19:36:39] "GET /ftp/linux.tar.bz2" 200 21809338
# This log file can then be processed by www traffic analyzers.
# AltLog clf:/var/log/pureftpd.log
# Create an additional log file with transfers logged in a format optimized
# for statistic reports.
# AltLog stats:/var/log/pureftpd.log
# Create an additional log file with transfers logged in the standard W3C
# format (compatible with most commercial log analyzers)
# AltLog w3c:/var/log/pureftpd.log
# Disallow the CHMOD command. Users can't change perms of their files.
NoChmod yes
# Allow users to resume and upload files, but *NOT* to delete them.
#KeepAllFiles yes
# Automatically create home directories if they are missing
#CreateHomeDir yes
# Enable virtual quotas. The first number is the max number of files.
# The second number is the max size of megabytes.
# So 1000:10 limits every user to 1000 files and 10 Mb.
#Quota 1000:10
# If your pure-ftpd has been compiled with standalone support, you can change
# the location of the pid file. The default is /var/run/pure-ftpd.pid
#PIDFile /var/run/pure-ftpd.pid
# If your pure-ftpd has been compiled with pure-uploadscript support,
# this will make pure-ftpd write info about new uploads to
# /var/run/pure-ftpd.upload.pipe so pure-uploadscript can read it and
# spawn a script to handle the upload.
#CallUploadScript yes
# This option is useful with servers where anonymous upload is
# allowed. As /var/ftp is in /var, it save some space and protect
# the log files. When the partition is more that X percent full,
# new uploads are disallowed.
MaxDiskUsage 1000
# Set to 'yes' if you don't want your users to rename files.
#NoRename yes
# Be 'customer proof' : workaround against common customer mistakes like
# 'chmod 0 public_html', that are valid, but that could cause ignorant
# customers to lock their files, and then keep your technical support busy
# with silly issues. If you're sure all your users have some basic Unix
# knowledge, this feature is useless. If you're a hosting service, enable it.
CustomerProof yes
# Per-user concurrency limits. It will only work if the FTP server has
# been compiled with --with-peruserlimits (and this is the case on
# most binary distributions) .
# The format is : <max sessions per user>:<max anonymous sessions>
# For instance, 3:20 means that the same authenticated user can have 3 active
# sessions max. And there are 20 anonymous sessions max.
# PerUserLimits 3:20
# When a file is uploaded and there is already a previous version of the file
# with the same name, the old file will neither get removed nor truncated.
# Upload will take place in a temporary file and once the upload is complete,
# the switch to the new version will be atomic. For instance, when a large PHP
# script is being uploaded, the web server will still serve the old version and
# immediatly switch to the new one as soon as the full file will have been
# transfered. This option is incompatible with virtual quotas.
# NoTruncate yes
# This option can accept three values :
# 0 : disable SSL/TLS encryption layer (default).
# 1 : accept both traditional and encrypted sessions.
# 2 : refuse connections that don't use SSL/TLS security mechanisms,
# including anonymous sessions.
# Do _not_ uncomment this blindly. Be sure that :
# 1) Your server has been compiled with SSL/TLS support (--with-tls),
# 2) A valid certificate is in place,
# 3) Only compatible clients will log in.
# TLS 1
# Listen only to IPv4 addresses in standalone mode (ie. disable IPv6)
# By default, both IPv4 and IPv6 are enabled.
IPV4Only yes
# Listen only to IPv6 addresses in standalone mode (ie. disable IPv4)
# By default, both IPv4 and IPv6 are enabled.
# IPV6Only yes
# UTF-8 support for file names (RFC 2640)
# Define charset of the server filesystem and optionnally the default charset
# for remote clients if they don't use UTF-8.
# Works only if pure-ftpd has been compiled with --with-rfc2640
# FileSystemCharset koi8-r
# ClientCharset cp1251
pureftpd-mysql.conf (этот файл используется у меня на машине. в процессе установки будет сгенерирован код для вашего сервера)
############################################################################
# #
# PureFTPd MySQL configuration file. #
# Generated by the installation wizard for the 'User manager for PureFTPd' #
# See http://machiel.generaal.net for more info #
# or read the README.MySQL for explanations of the syntax. #
# #
############################################################################
# Optional : MySQL server name or IP. Don't define this for unix sockets.
MYSQLServer localhost
# Optional : MySQL port. Don't define this if a local unix socket is used.
MYSQLPort 3306
# Optional : define the location of mysql.sock if the server runs on this host.
# MYSQLSocket /tmp/mysql.sock
# Mandatory : user to bind the server as.
MYSQLUser root
# Mandatory : user password. You must have a password.
MYSQLPassword пароль
# Mandatory : database to open.
MYSQLDatabase ftpusers
# Mandatory : how passwords are stored
# Valid values are : "cleartext", "crypt", "md5" and "password"
# ("password" = MySQL password() function)
# You can also use "any" to try "crypt", "md5" *and* "password"
MYSQLCrypt md5
# In the following directives, parts of the strings are replaced at
# run-time before performing queries :
#
# \L is replaced by the login of the user trying to authenticate.
# \I is replaced by the IP address the user connected to.
# \P is replaced by the port number the user connected to.
# \R is replaced by the IP address the user connected from.
# \D is replaced by the remote IP address, as a long decimal number.
#
# Very complex queries can be performed using these substitution strings,
# especially for virtual hosting.
# Query to execute in order to fetch the password
MYSQLGetPW SELECT Password FROM users WHERE User="\L" AND Status="1" AND (Ipaddress = "*" OR Ipaddress LIKE "\R")
# Query to execute in order to fetch the system user name or uid
MYSQLGetUID SELECT Uid FROM users WHERE User="\L" AND Status="1" AND (Ipaddress = "*" OR Ipaddress LIKE "\R")
# Optional : default UID - if set this overrides MYSQLGetUID
#MYSQLDefaultUID 1000
# Query to execute in order to fetch the system user group or gid
MYSQLGetGID SELECT Gid FROM users WHERE User="\L" AND Status="1" AND (Ipaddress = "*" OR Ipaddress LIKE "\R")
# Optional : default GID - if set this overrides MYSQLGetGID
#MYSQLDefaultGID 1000
# Query to execute in order to fetch the home directory
MYSQLGetDir SELECT Dir FROM users WHERE User="\L" AND Status="1" AND (Ipaddress = "*" OR Ipaddress LIKE "\R")
# Optional : query to get the maximal number of files
# Pure-FTPd must have been compiled with virtual quotas support.
# MySQLGetQTAFS SELECT QuotaFiles FROM users WHERE User="\L"
# Optional : query to get the maximal disk usage (virtual quotas)
# The number should be in Megabytes.
# Pure-FTPd must have been compiled with virtual quotas support.
# MySQLGetQTASZ SELECT QuotaSize FROM users WHERE User="\L"
# Optional : ratios. The server has to be compiled with ratio support.
# MySQLGetRatioUL SELECT ULRatio FROM users WHERE User="\L"
# MySQLGetRatioDL SELECT DLRatio FROM users WHERE User="\L"
# Optional : bandwidth throttling.
# The server has to be compiled with throttling support.
# Values are in KB/s .
MySQLGetBandwidthUL SELECT ULBandwidth FROM users WHERE User="\L" AND Status="1" AND (Ipaddress = "*" OR Ipaddress LIKE "\R")
MySQLGetBandwidthDL SELECT DLBandwidth FROM users WHERE User="\L" AND Status="1" AND (Ipaddress = "*" OR Ipaddress LIKE "\R")
# Enable ~ expansion. NEVER ENABLE THIS BLINDLY UNLESS :
# 1) You know what you are doing.
# 2) Real and virtual users match.
# MySQLForceTildeExpansion 1
# If you upgraded your tables to transactionnal tables (Gemini,
# BerkeleyDB, Innobase...), you can enable SQL transactions to
# avoid races. Leave this commented if you are using the
# traditionnal MyIsam databases or old (< 3.23.x) MySQL versions.
# MySQLTransactions On
Для администрирования пользователей я использовал UserManager. Его можно установить из портов. Для этого заходим в терминале под rootом и командуем:)
# cd /usr/ports/www/usermanager
# make install clean
потом переносим папку usermanager в папку вашего web сервера или в его конфигах созлаём алайс на папку или простьо виртуал хост.
mv /usr/local/www/data/UserManager/ /usr/local/www/
затем открываем в браузере
http://ip_вашего_сервера/patch_до_админки/install.php
установка UserManager почемуто не зароботала до конца и остановилась на втором шаге. Скрипт не мог создать в базе данных две таблици: admin и users.
чтобы не мучатся я завалил базу ftpusers (которая создалась в процессе роботы скрипта) и переделал эту часть руками.
чтобы установка пошла дальше надо выполнить несколько запросов к бд. для выполнения я исполььзовал phpmyadmin.
в первом запросе я создаю бд ftpusers, юзера ftp с паролем ftp_pass и даю ему права.
запрос №1
CREATE DATABASE ftpusers;
GRANT USAGE ON *.* TO 'ftp'@'localhost' IDENTIFIED BY 'ftp_pass'
WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
GRANT ALL PRIVILEGES ON `ftpusers`.* TO 'ftp'@'localhost' WITH GRANT OPTION;
во втором запросе я добавляю две таблици admin и users
запрос №2
USE ftpusers;
CREATE TABLE admin (
Username varchar(35) NOT NULL default '',
Password char(32) binary NOT NULL default '') ENGINE=MyISAM;
INSERT INTO admin VALUES ('Administrator',MD5('tmppasswd'));
CREATE TABLE `users` (
`User` varchar(16) NOT NULL default '',
`Password` varchar(32) binary NOT NULL default '',
`Uid` int(11) NOT NULL default '14',
`Gid` int(11) NOT NULL default '5',
`Dir` varchar(128) NOT NULL default '',
`QuotaFiles` int(10) NOT NULL default '500',
`QuotaSize` int(10) NOT NULL default '30',
`ULBandwidth` int(10) NOT NULL default '80',
`DLBandwidth` int(10) NOT NULL default '80',
`Ipaddress` varchar(15) NOT NULL default '*',
`Comment` tinytext,
`Status` enum('0','1') NOT NULL default '1',
`ULRatio` smallint(5) NOT NULL default '1',
`DLRatio` smallint(5) NOT NULL default '1',
PRIMARY KEY (`User`),
UNIQUE KEY `User` (`User`)
) ENGINE=MyISAM;
INSERT INTO ftpusers.users VALUES ('ftpuser_1',MD5('tmppasswd'),65534, 31, '/usr', 100, 50, 75, 75, '*', 'Ftp user (for example)', '1', 0, 0);
После всего этого колдовства скрипт устаноки продолжил роботу. Серв завёлся и всё заработало.
Стандартные данные для входа в админку:
Пользователь: Administrator
Пароль: tmppasswd
Эти данные можно изменить или добавить ещё одного пользователя в процессе установки.
Самое главное что нужно помнить всегда!!!
Постоянно проверяйте есть ли у вас права на запуск, чтение и изменение файла и в какой группе и какому пользователю принадлежит папка или файл.
Простым языком.
Предположим что у вас есть реальный unix пользователь ftp с номером UID:1002 и состоящий в группе Gid:14.
Вы через админку сервера создаёте пользователя user, задаёте ему пароль и права от пользователя ftp н адоступ в папку /usr/www/htdoc/www/user_www_dir
Админка выглядит так:
http://img26.imageshack.us/img26/7412/useradmin.jpg
При заходе на ftp невозможно создать или изменить файлы или папки в папке user_www_dir
Дело в следующем что папка user_www_dir создовалась под root или под другим пользователем.
(ниже вид от другого пользователя)
http://img24.imageshack.us/img24/2349/userftproot.jpg
(команда ls -l)
localhost# ls -l
total 10
drwxr-xr-x 7 ftp ftp 512 Jul 31 11:41 UserManager
-rw-r--r-- 1 ftp ftp 18 Aug 1 07:37 index.php
drwxr-xr-x 10 ftp ftp 3072 Jul 30 09:17 phpmyadmin
drwxr-xr-x 2 root ftp 512 Aug 1 09:40 user_www_dir
Как вылечить.
Во Freebsd есть две команды: chown и chgrp
#chown -R username foldername = Сменить владельца на директорию и все её поддиректоии и файлы
#chgrp -R groupname folgername = Изменить группу
пишем
#chown -R ftp user_www_dir
#chgrp -R ftp user_www_dir
и получаем
http://img263.imageshack.us/img263/4481/userftpftp.jpg
или так
localhost# ls -l
total 10
drwxr-xr-x 7 ftp ftp 512 Jul 31 11:41 UserManager
-rw-r--r-- 1 ftp ftp 18 Aug 1 07:37 index.php
drwxr-xr-x 10 ftp ftp 3072 Jul 30 09:17 phpmyadmin
drwxr-xr-x 2 ftp ftp 512 Aug 1 10:02 user_www_dir
vBulletin v3.6.4, Copyright ©2000-2025, Jelsoft Enterprises Ltd.