Ubuntu-fr

devphp

Difficulté avec proftpd 1.3.3a

Bonjour,

J'essaye d'installer mon serveur sous Debian 6. Je souhaite mettre en place des espaces FTP limité en stockage et géré par MySQL.
J'ai installé ProFtpd, en tant que "user SSH" aucun problème, par contre en tant que "user SQL (j'entend bien une clé dans la DB ;-) )" ça ne fonctionne pas.

Comme d'hab, quand ça coince, go les logs et voila mon erreur:

Oct 27 23:18:46 vks10529 proftpd[12317]: mod_facl/0.4: error registering 'facl' FS: Operation not permitted
Oct 27 23:18:46 vks10529 proftpd[12317]: mod_dso/0.5: module 'mod_facl.c' failed to initialize
Oct 27 23:18:46 vks10529 proftpd[12317]: Fatal: LoadModule: error loading module 'mod_facl.c': Operation not permitted on line 89 of '/etc/proftpd/modules.conf'

Voici la configuration:

proftpd.conf

#
# /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			"Debian"
ServerType			standalone
DeferWelcome			off

MultilineRFC2228		on
DefaultServer			on
ShowSymlinks			off

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

# 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 on
</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/sql.conf

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

#
# Useful to keep VirtualHost/VirtualRoot directives separated
#
#Include /etc/proftpd/virtuals.con

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

AllowStoreRestart On
AllowRetrieveRestart On

<IfModule mod_sql.c>
 SQLBackend            mysql
</IfModule>

sql.conf

#
# Proftpd sample configuration for SQL-based authentication.
#
# (This is not to be used if you prefer a PAM-based SQL authentication)
#

<IfModule mod_sql.c>
#
# Choose a SQL backend among MySQL or PostgreSQL.
# Both modules are loaded in default configuration, so you have to specify the backend 
# or comment out the unused module in /etc/proftpd/modules.conf.
# Use 'mysql' or 'postgres' as possible values.
#
SQLBackend	mysql
#
SQLEngine on
#SQLAuthenticate on
#
# Use both a crypted or plaintext password 
#SQLAuthTypes Crypt Plaintext
#
# Use a backend-crypted or a crypted password
#SQLAuthTypes Backend Crypt 
#
# Connection 
#SQLConnectInfo proftpd@sql.example.com proftpd_user proftpd_password
#
# Describes both users/groups tables
#
#SQLUserInfo users userid passwd uid gid homedir shell
#SQLGroupInfo groups groupname gid members
#
</IfModule>


AuthOrder mod_sql.c
<IfModule mod_auth_pam.c>
  AuthPAM off
</IfModule>

# MySQL
## Configuration générale
SQLAuthenticate users groups
SQLAuthTypes Crypt

# Modifiez cette ligne selon l'utilisateur et le mot de passe definit plutot
SQLConnectInfo proftpd@localhost proftpd passw0rd

SQLGroupInfo groups groupname gid members
SQLUserInfo users userid passwd uid gid homedir shell
SQLUserWhereClause "enabled = '1'"
 
## Met à jour les compteurs à chaque connection d'un utilisateur
SQLLog PASS updatecount
SQLNamedQuery updatecount UPDATE "count=count+1, accessed=now() WHERE userid='%u'" users

AuthOrder mod_sql.c
<IfModule mod_auth_pam.c>
  AuthPAM off
</IfModule>

modules.conf

#
# This file is used to manage DSO modules and features.
#

# This is the directory where DSO modules reside

ModulePath /usr/lib/proftpd

# Allow only user root to load and unload modules, but allow everyone
# to see which modules have been loaded

ModuleControlsACLs insmod,rmmod allow user root
ModuleControlsACLs lsmod allow user *

LoadModule mod_ctrls_admin.c
LoadModule mod_tls.c

# Install one of proftpd-mod-mysql, proftpd-mod-pgsql or any other
# SQL backend engine to use this module and the required backend.
# This module must be mandatory loaded before anyone of
# the existent SQL backeds.
LoadModule mod_sql.c

# Install proftpd-mod-ldap to use this
#LoadModule mod_ldap.c

#
# 'SQLBackend mysql' or 'SQLBackend postgres' (or any other valid backend) directives 
# are required to have SQL authorization working. You can also comment out the
# unused module here, in alternative.
#

# Install proftpd-mod-mysql and decomment the previous
# mod_sql.c module to use this.

LoadModule mod_sql_mysql.c

# Install proftpd-mod-pgsql and decomment the previous 
# mod_sql.c module to use this.
#LoadModule mod_sql_postgres.c

# Install proftpd-mod-sqlite and decomment the previous
# mod_sql.c module to use this
#LoadModule mod_sql_sqlite.c

# Install proftpd-mod-odbc and decomment the previous
# mod_sql.c module to use this
#LoadModule mod_sql_odbc.c

# Install one of the previous SQL backends and decomment 
# the previous mod_sql.c module to use this
#LoadModule mod_sql_passwd.c

LoadModule mod_radius.c
LoadModule mod_quotatab.c
LoadModule mod_quotatab_file.c

# Install proftpd-mod-ldap to use this
#LoadModule mod_quotatab_ldap.c

# Install one of the previous SQL backends and decomment 
# the previous mod_sql.c module to use this
#LoadModule mod_quotatab_sql.c
LoadModule mod_quotatab_radius.c
LoadModule mod_wrap.c
LoadModule mod_rewrite.c
LoadModule mod_load.c
LoadModule mod_ban.c
LoadModule mod_wrap2.c
LoadModule mod_wrap2_file.c
# Install one of the previous SQL backends and decomment 
# the previous mod_sql.c module to use this
#LoadModule mod_wrap2_sql.c
LoadModule mod_dynmasq.c
LoadModule mod_vroot.c
LoadModule mod_exec.c
LoadModule mod_shaper.c
LoadModule mod_ratio.c
LoadModule mod_site_misc.c

LoadModule mod_sftp.c
LoadModule mod_sftp_pam.c
# Install one of the previous SQL backends and decomment 
# the previous mod_sql.c module to use this
#LoadModule mod_sftp_sql.c

LoadModule mod_facl.c
LoadModule mod_unique_id.c

# keep this module the last one
LoadModule mod_ifsession.c

Si quelqu'un a une idée, je suis preneur.

---

Ubuntu 12.04 (Xfce) 64bits
Intel® Core™ i5 CPU M 520 @ 2.40GHz × 4

Priorité à la prévention, faite des back-up fréquent.

Djerfy

Re : Difficulté avec proftpd 1.3.3a

Hello,

Est possible de lister les droits dans ton dossier de modules de ProFTPd ?

Tu va dans le dossier de modules et :

ls -lrht

---

Twitter: @djerfy
Site: xorhak.fr

devphp

Re : Difficulté avec proftpd 1.3.3a

Voila...

Il n'y a pas de dossier modules

.
├── [-rw-r--r-- root     root         1310700 Nov 13  2011]  blacklist.dat
├── [-rw-r--r-- root     root            7212 Nov 13  2011]  dhparams.pem
├── [-rw-r--r-- root     root             663 Oct 27 21:53]  ldap.conf
├── [-rw-r--r-- root     root            2524 Oct 27 23:17]  modules.conf
├── [-rw-r--r-- root     root            2521 Oct 28  3:22]  modules.conf.save
├── [-rw-r--r-- root     root            4954 Oct 27 23:14]  proftpd.conf
├── [-rw-r--r-- root     root            1542 Oct 27 23:30]  sql.conf
├── [-rw-r--r-- root     root            1924 Oct 27 21:53]  tls.conf
└── [-rw-r--r-- root     root             832 Oct 27 21:53]  virtuals.conf

Dernière modification par devphp (Le 29/10/2012, à 20:42)

---

Ubuntu 12.04 (Xfce) 64bits
Intel® Core™ i5 CPU M 520 @ 2.40GHz × 4

Priorité à la prévention, faite des back-up fréquent.

Djerfy

Re : Difficulté avec proftpd 1.3.3a

Oups pardon, c'est dans le dossier "/usr/lib/proftpd/"

---

Twitter: @djerfy
Site: xorhak.fr

devphp

Re : Difficulté avec proftpd 1.3.3a

Voila ..

.
├── [-rw-r--r-- root     root           36304 Nov 13  2011]  mod_ban.so
├── [-rw-r--r-- root     root           25592 Nov 13  2011]  mod_ctrls_admin.so
├── [-rw-r--r-- root     root            7744 Nov 13  2011]  mod_dynmasq.so
├── [-rw-r--r-- root     root           33264 Nov 13  2011]  mod_exec.so
├── [-rw-r--r-- root     root           13072 Nov 13  2011]  mod_facl.so
├── [-rw-r--r-- root     root           13136 Nov 13  2011]  mod_ifsession.so
├── [-rw-r--r-- root     root            8352 Nov 13  2011]  mod_load.so
├── [-rw-r--r-- root     root            8816 Nov 13  2011]  mod_quotatab_file.so
├── [-rw-r--r-- root     root            7120 Nov 13  2011]  mod_quotatab_radius.so
├── [-rw-r--r-- root     root           58384 Nov 13  2011]  mod_quotatab.so
├── [-rw-r--r-- root     root           12656 Nov 13  2011]  mod_quotatab_sql.so
├── [-rw-r--r-- root     root           45168 Nov 13  2011]  mod_radius.so
├── [-rw-r--r-- root     root           24416 Nov 13  2011]  mod_ratio.so
├── [-rw-r--r-- root     root           40400 Nov 13  2011]  mod_rewrite.so
├── [-rw-r--r-- root     root           17184 Nov 13  2011]  mod_sftp_pam.so
├── [-rw-r--r-- root     root          317288 Nov 13  2011]  mod_sftp.so
├── [-rw-r--r-- root     root           36496 Nov 13  2011]  mod_shaper.so
├── [-rw-r--r-- root     root           15360 Nov 13  2011]  mod_site_misc.so
├── [-rw-r--r-- root     root           24288 Nov 13  2011]  mod_sql_mysql.so
├── [-rw-r--r-- root     root           16144 Nov 13  2011]  mod_sql_passwd.so
├── [-rw-r--r-- root     root           78112 Nov 13  2011]  mod_sql.so
├── [-rw-r--r-- root     root          113808 Nov 13  2011]  mod_tls.so
├── [-rw-r--r-- root     root            8832 Nov 13  2011]  mod_unique_id.so
├── [-rw-r--r-- root     root           21104 Nov 13  2011]  mod_vroot.so
├── [-rw-r--r-- root     root            9104 Nov 13  2011]  mod_wrap2_file.so
├── [-rw-r--r-- root     root           28080 Nov 13  2011]  mod_wrap2.so
├── [-rw-r--r-- root     root            8976 Nov 13  2011]  mod_wrap2_sql.so
└── [-rw-r--r-- root     root           16848 Nov 13  2011]  mod_wrap.so

---

Ubuntu 12.04 (Xfce) 64bits
Intel® Core™ i5 CPU M 520 @ 2.40GHz × 4

Priorité à la prévention, faite des back-up fréquent.