Proftpd

[Francisco Calero <pcm@inproda.es>]

Acabo de comprobar si el mysql.log refleja algo cuando intento conectar
al ftp pero no dice nada de nada.

¿Aguna sujerencia?
¿instalo otro servidor diferente?


El jue, 04-12-2008 a las 19:34 +0100, Francisco Calero escribió:
> Hola a todos, llevo un tiempo intentando hacer funcionar el proftpd
con
> los usuarios virtuales manejados desde mysql. He seguido numerosos
> manuales que me presta google y no consigo hacerlo funcionar. Mas
abajo
> os dejo mi configuración a ver si alguien puede ayudarme.
> 
> /etc/proftpd/proftpd.conf
> 
> Include /etc/proftpd/modules.conf
> UseIPv6                         off
> # Use pam to authenticate (default) and be authoritative
> #AuthPAMConfig                  proftpd
> #AuthOrder                      mod_auth_pam.c* mod_auth_unix.c
> # SQL authentication Dynamic Shared Object (DSO) loading
> # See README.DSO and howto/DSO.html for more details.
> #<IfModule mod_dso.c>
> #   LoadModule mod_sql.c
> #   LoadModule mod_sql_mysql.c
> #   LoadModule mod_sql_postgres.c
> #</IfModule>
> 
> 
> # 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 proftpd asdfgf
> 
> 
> # 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
> 
> # set min UID and GID - otherwise these are 999 each
> SQLMinID        500
> 
> # create a user's home directory on demand if it doesn't exist
> SQLHomedirOnDemand on
> 
> # Update count every time user logs in
> SQLLog PASS updatecount
> SQLNamedQuery updatecount UPDATE "count=count+1, accessed=now() WHERE
> userid='%u'" ftpuser
> 
> # Update modified everytime user uploads or deletes a file
> SQLLog  STOR,DELE modified
> SQLNamedQuery modified UPDATE "modified=now() WHERE userid='%u'"
ftpuser
> 
> # User quotas
> # ===========
> QuotaEngine on
> QuotaDirectoryTally on
> QuotaDisplayUnits Mb
> QuotaShowQuotas on
> 
> SQLNamedQuery get-quota-limit SELECT "name, quota_type, per_session,
> limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_avail,
> files_in_avail, files_out_avail, files_xfer_avail FROM ftpquotalimits
> WHERE name = '%{0}' AND quota_type = '%{1}'"
> 
> SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used,
> bytes_out_used, bytes_xfer_used, files_in_used, files_out_used,
> files_xfer_used FROM ftpquotatallies WHERE name = '%{0}' AND
quota_type
> = '%{1}'"
> 
> SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used
+
> %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used =
> bytes_xfer_used + %{2}, files_in_used = files_in_used + %{3},
> files_out_used = files_out_used + %{4}, files_xfer_used =
> files_xfer_used + %{5} WHERE name = '%{6}' AND quota_type = '%{7}'"
> ftpquotatallies
> 
> SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4},
> %{5}, %{6}, %{7}" ftpquotatallies
> 
> QuotaLimitTable sql:/get-quota-limit
> QuotaTallyTable
> sql:/get-quota-tally/update-quota-tally/insert-quota-tally
> 
> RootLogin off
> RequireValidShell off
> 
> cat /etc/proftpd/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
> LoadModule mod_sql.c
> LoadModule mod_ldap.c
> LoadModule mod_sql_mysql.c
> LoadModule mod_sql_postgres.c
> LoadModule mod_quotatab.c
> LoadModule mod_quotatab_file.c
> LoadModule mod_quotatab_ldap.c
> LoadModule mod_quotatab_sql.c
> LoadModule mod_radius.c
> LoadModule mod_wrap.c
> LoadModule mod_rewrite.c
> 
> # keep this module the last one
> LoadModule mod_ifsession.c
> 
> uname -a
> Linux Calculon 2.6.18-6-amd64 #1 SMP Mon Jun 16 22:30:01 UTC 2008
x86_64
> GNU/Linux nmap localhost
> 
> Starting Nmap 4.11 ( http://www.insecure.org/nmap/ ) at 2008-12-04
19:30
> CET
> Interesting ports on localhost (127.0.0.1):
> Not shown: 1672 closed ports
> PORT      STATE SERVICE
> 21/tcp    open  ftp
> 22/tcp    open  ssh
> 
> 
> tcp        0      0 0.0.0.0:21              0.0.0.0:*
> LISTEN
> 
> La base de datos la he estructurado segun este howto.
>
http://www.howtoforge.com/virtual-hosting-with-proftpd-and-mysql-fedora9
> 
> Bién una vez seguido y terminado este manual, obtengo lo siguiente.
>
------------------------------------------------------------------------------------
> ftp localhost
> Connected to localhost.
> 421 Service not available, remote server has closed connection
>
------------------------------------------------------------------------------------
> 
> Agradezco todo tipo de ayudar o sugerencia. 
> 
> Gracias y Salu2.