URL: https://www.opennet.me/cgi-bin/openforum/vsluhboard.cgi
Форум: vsluhforumID1
Нить номер: 88829
[ Назад ]

Исходное сообщение
"ProFTPd и mysql проблема "

Отправлено imriot , 27-Апр-10 22:17 
Приветствую всех вас, и заранее очень благодарен
Чисто в целях самообразования установил Ubuntu Server 9.04
Поднял на нем proftpd, да вот проблема, авторизацию пользователи в системе проходят нормально а вот из mysql на прочь не хочет брать пользователей
Действовал по МАН.у отсюда http://forum.ubuntu.ru/index.php?topic=37507.0
Посмотрел я модули proftpd (командой proftpd -l)
результат:
  mod_core.c
  mod_xfer.c
  mod_auth_unix.c
  mod_auth_file.c
  mod_auth.c
  mod_ls.c
  mod_log.c
  mod_site.c
  mod_delay.c
  mod_dso.c
  mod_auth_pam.c
  mod_readme.c
  mod_cap.c
  mod_ctrls.c
  mod_lang.c
Не вижу я здесь mod_sql.c


#
# /etc/proftpd/proftpd.conf -- This is a basic ProFTPD configuration file.
# To really apply changes reload proftpd after modifications.
#

# Includes DSO modules
Include /etc/proftpd/modules.conf

# Set off to disable IPv6 support which is annoying on IPv4 only boxes.
UseIPv6                off
# If set on you can experience a longer connection delay in many cases.
IdentLookups            off

ServerName            "DFORGE FTP Server"
ServerType            standalone
DeferWelcome            off

MultilineRFC2228        on
DefaultServer            on
ShowSymlinks            on

TimeoutNoTransfer        600
TimeoutStalled            600
TimeoutIdle            1200

DisplayLogin                    welcome.msg
DisplayChdir                   .message true
ListOptions                    "-l"

DenyFilter            \*.*/

# Use this to jail all users in their homes
# DefaultRoot            ~

# Users require a valid shell listed in /etc/shells to login.
# Use this directive to release that constrain.
RequireValidShell        off

# Port 21 is the standard FTP port.
Port                21

# In some cases you have to specify passive ports range to by-pass
# firewall limitations. Ephemeral ports can be used for that, but
# feel free to use a more narrow range.
# PassivePorts                  49152 65534

# If your host was NATted, this option is useful in order to
# allow passive tranfers to work. You have to use your public
# address and opening the passive ports used on your firewall as well.
# MasqueradeAddress        1.2.3.4

# This is useful for masquerading address with dynamic IPs:
# refresh any configured MasqueradeAddress directives every 8 hours
<IfModule mod_dynmasq.c>
# DynMasqRefresh 28800
</IfModule>

# 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 that the server normally runs at.
User                proftpd
Group                nogroup

# Umask 022 is a good standard umask to prevent new files and dirs
# (second parm) from being group and world writable.
Umask                022  022
# Normally, we want files to be overwriteable.
AllowOverwrite            on

# Uncomment this if you are using NIS or LDAP via NSS to retrieve passwords:
# PersistentPasswd        off

# This is required to use both PAM-based authentication and local passwords
# AuthOrder            mod_auth_pam.c* mod_auth_unix.c
AuthOrder                       mod_sql.c

# Be warned: use of this directive impacts CPU average load!
# Uncomment this if you like to see progress and transfer rate with ftpwho
# in downloads. That is not needed for uploads rates.
#
# UseSendFile            off

TransferLog /var/log/proftpd/xferlog
SystemLog   /var/log/proftpd/proftpd.log

<IfModule mod_quotatab.c>
QuotaEngine off
</IfModule>

<IfModule mod_ratio.c>
Ratios off
</IfModule>


# Delay engine reduces impact of the so-called Timing Attack described in
# http://security.lss.hr/index.php?page=details&ID=LSS-2004-10-02
# It is on by default.
<IfModule mod_delay.c>
DelayEngine on
</IfModule>

<IfModule mod_ctrls.c>
ControlsEngine        off
ControlsMaxClients    2
ControlsLog           /var/log/proftpd/controls.log
ControlsInterval      5
ControlsSocket        /var/run/proftpd/proftpd.sock
</IfModule>

<IfModule mod_ctrls_admin.c>
AdminControlsEngine off
</IfModule>

#
# Alternative authentication frameworks
#
#Include /etc/proftpd/ldap.conf
Include /etc/proftpd/mysql.conf

#
# This is used for FTPS connections
#
#Include /etc/proftpd/tls.conf

# A basic anonymous configuration, no upload directories.

# <Anonymous ~ftp>
#   User                ftp
#   Group                nogroup
#   # We want clients to be able to login with "anonymous" as well as "ftp"
#   UserAlias            anonymous ftp
#   # Cosmetic changes, all files belongs to ftp user
#   DirFakeUser    on ftp
#   DirFakeGroup on ftp
#
#   RequireValidShell        off
#
#   # 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
#   DisplayChdir        .message
#
#   # Limit WRITE everywhere in the anonymous chroot
#   <Directory *>
#     <Limit WRITE>
#       DenyAll
#     </Limit>
#   </Directory>
#
#   # Uncomment this if you're brave.
#   # <Directory incoming>
#   #   # Umask 022 is a good standard umask to prevent new files and dirs
#   #   # (second parm) from being group and world writable.
#   #   Umask                022  022
#   #            <Limit READ WRITE>
#   #            DenyAll
#   #            </Limit>
#   #            <Limit STOR>
#   #            AllowAll
#   #            </Limit>
#   # </Directory>
#
# </Anonymous>


mysql.conf

###############MY CONFIG##################

# Update count every time user logs in
SQLLog PASS updatecount
SQLNamedQuery updatecount UPDATE "count=count+1, accessed=now() WHERE userid='%$

# Update modified everytime user uploads or deletes a file
SQLLog  STOR,DELE modified
SQLNamedQuery modified UPDATE "modified=now() WHERE userid='%u'" ftpuser
SQLBackend              mysql

# The passwords in MySQL are encrypted using CRYPT
SQLAuthTypes            Plaintext Crypt
SQLAuthenticate         users groups

# used to connect to the database
# databasename@host database_user user_password
SQLConnectInfo  ftp@localhost root *пароль :) *

# Here we tell ProFTPd the names of the database columns in the "usertable"
# we want it to interact with. Match the names with those in the db
SQLUserInfo     ftpuser userid passwd uid gid homedir shell

# Here we tell ProFTPd the names of the database columns in the "grouptable"
# we want it to interact with. Again the names match with those in the db
SQLGroupInfo    ftpgroup groupname gid members



Содержание

Сообщения в этом обсуждении
"ProFTPd и mysql проблема "
Отправлено Koba LTD , 28-Апр-10 17:40 
>[оверквотинг удален]
>in the db
>SQLUserInfo     ftpuser userid passwd uid gid homedir shell
>
>
># Here we tell ProFTPd the names of the database columns in
>the "grouptable"
># we want it to interact with. Again the names match with
>those in the db
>SQLGroupInfo    ftpgroup groupname gid members
>

apt-get install proftpd-mod-mysql  proftpd-mysql


"ProFTPd и mysql проблема "
Отправлено imriot , 29-Апр-10 17:16 
>[оверквотинг удален]
>>
>>
>># Here we tell ProFTPd the names of the database columns in
>>the "grouptable"
>># we want it to interact with. Again the names match with
>>those in the db
>>SQLGroupInfo    ftpgroup groupname gid members
>>
>
>apt-get install proftpd-mod-mysql  proftpd-mysql

Делал уже это :(
и щя мне просто тупо сообщается


Reading package lists... Done
Building dependency tree
Reading state information... Done
proftpd-mod-mysql is already the newest version.
Package proftpd-mysql is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
E: Package proftpd-mysql has no installation candidate

логины и пароли в mysql прокатывают, а вот директории не видит
говорит что не найден каталог, а браузерах тупо молчание
в клиентах "хост закрыл подключения" т.е грубо говоря proftpd не видит директории


"ProFTPd и mysql проблема "
Отправлено imriot , 01-Май-10 01:18 
Парни ну помогите прошу :)
Все перерыл, уверен что проблема банально, но не как не могу решить

"ProFTPd и mysql проблема "
Отправлено imriot , 02-Май-10 13:42 
Всем спасибо, все заработало

"ProFTPd и mysql проблема "
Отправлено Kronas , 08-Июн-10 00:44 
>Всем спасибо, все заработало

каким образом решил проблему?


"ProFTPd и mysql проблема "
Отправлено imriot , 20-Авг-10 02:10 
>>Всем спасибо, все заработало
>
>каким образом решил проблему?

Ответить никогда не поздно )
Решил проблему, благодаря тому что убрал поля uid gid и закомментировал sqlgroupinfo


ЗЫ Ощущение того что с группами pftpd не работает


"ProFTPd и mysql проблема "
Отправлено imriot , 20-Авг-10 02:10 
Но скорее всего моя невнимательность