# Example config file /etc/vsftpd.conf
#
# The default compiled in settings are fairly paranoid. This sample file
# loosens things up a bit, to make the ftp daemon more usable.
# Please see vsftpd.conf.5 for all compiled in defaults.
#
# READ THIS: This example file is NOT an exhaustive list of vsftpd options.
# Please read the vsftpd.conf.5 manual page to get a full idea of vsftpd's
# capabilities.
#
#
# Run standalone?  vsftpd can run either from an inetd or as a standalone
# daemon started from an initscript.
listen=YES
#
# Run standalone with IPv6?
# Like the listen parameter, except vsftpd will listen on an IPv6 socket
# instead of an IPv4 one. This parameter and the listen parameter are mutually
# exclusive.
#listen_ipv6=YES
#
# Allow anonymous FTP? (Beware - allowed by default if you comment this out).
anonymous_enable=NO
#
# Uncomment this to allow local users to log in.
local_enable=YES
#
# Uncomment this to enable any form of FTP write command.
write_enable=YES
#
# Default umask for local users is 077. You may wish to change this to 022,
# if your users expect that (022 is used by most other ftpd's)
#local_umask=022
#
# Uncomment this to allow the anonymous FTP user to upload files. This only
# has an effect if the above global write enable is activated. Also, you will
# obviously need to create a directory writable by the FTP user.
#anon_upload_enable=YES
#
# Uncomment this if you want the anonymous FTP user to be able to create
# new directories.
#anon_mkdir_write_enable=YES
#
# Activate directory messages - messages given to remote users when they
# go into a certain directory.
dirmessage_enable=YES
#
# If enabled, vsftpd will display directory listings with the time
# in  your  local  time  zone.  The default is to display GMT. The
# times returned by the MDTM FTP command are also affected by this
# option.
use_localtime=YES
#
# Activate logging of uploads/downloads.
xferlog_enable=YES
#
# Make sure PORT transfer connections originate from port 20 (ftp-data).
connect_from_port_20=YES
#
# If you want, you can arrange for uploaded anonymous files to be owned by
# a different user. Note! Using "root" for uploaded files is not
# recommended!
#chown_uploads=YES
#chown_username=whoever
#
# You may override where the log file goes if you like. The default is shown
# below.
xferlog_file=/var/log/vsftpd.log
#
# If you want, you can have your log file in standard ftpd xferlog format.
# Note that the default log file location is /var/log/xferlog in this case.
xferlog_std_format=YES
#
# You may change the default value for timing out an idle session.
#idle_session_timeout=600
#
# You may change the default value for timing out a data connection.
#data_connection_timeout=120
#
# It is recommended that you define on your system a unique user which the
# ftp server can use as a totally isolated and unprivileged user.
nopriv_user=vsftpd
#
# Enable this and the server will recognise asynchronous ABOR requests. Not
# recommended for security (the code is non-trivial). Not enabling it,
# however, may confuse older FTP clients.
#async_abor_enable=YES
#
# By default the server will pretend to allow ASCII mode but in fact ignore
# the request. Turn on the below options to have the server actually do ASCII
# mangling on files when in ASCII mode.
# Beware that on some FTP servers, ASCII support allows a denial of service
# attack (DoS) via the command "SIZE /big/file" in ASCII mode. vsftpd
# predicted this attack and has always been safe, reporting the size of the
# raw file.
# ASCII mangling is a horrible feature of the protocol.
#ascii_upload_enable=YES
#ascii_download_enable=YES
#
# You may fully customise the login banner string:
ftpd_banner=Bienvenido al servidor FTP de OfertaSatel.com.
#
# You may specify a file of disallowed anonymous e-mail addresses. Apparently
# useful for combatting certain DoS attacks.
#deny_email_enable=YES
# (default follows)
#banned_email_file=/etc/vsftpd.banned_emails
#
# You may restrict local users to their home directories.  See the FAQ for
# the possible risks in this before using chroot_local_user or
# chroot_list_enable below.
chroot_local_user=YES
#
# You may specify an explicit list of local users to chroot() to their home
# directory. If chroot_local_user is YES, then this list becomes a list of
# users to NOT chroot().
chroot_local_user=YES
#chroot_list_enable=YES
# (default follows)
#chroot_list_file=/etc/vsftpd.chroot_list
#
# You may activate the "-R" option to the builtin ls. This is disabled by
# default to avoid remote users being able to cause excessive I/O on large
# sites. However, some broken FTP clients such as "ncftp" and "mirror" assume
# the presence of the "-R" option, so there is a strong case for enabling it.
#ls_recurse_enable=YES
#
#
# Debian customization
#
# Some of vsftpd's settings don't fit the Debian filesystem layout by
# default.  These settings are more Debian-friendly.
#
# This option should be the name of a directory which is empty.  Also, the
# directory should not be writable by the ftp user. This directory is used
# as a secure chroot() jail at times vsftpd does not require filesystem
# access.
secure_chroot_dir=/etc/vsftpd/vacio
#
# This string is the name of the PAM service vsftpd will use.
pam_service_name=vsftpd
#
# This option specifies the location of the RSA certificate to use for SSL
# encrypted connections.
rsa_cert_file=/etc/ssl/certs/ssl-cert-snakeoil.pem

# En octal: 0022 xor 0777 = permisos 755
local_umask=0022
file_open_mode=0777
dirmessage_enable=NO
# Número máximo de sesiones de usuario conectados simultáneamente
max_clients=50
# Nr. máximo de ss. de usuario para un mismo origen (IP).
max_per_ip=5
# Unificación de los clientes como único usuario del sistema
guest_enable=YES
# Usuario del sistema con que actuaran los usuarios FTP
guest_username=ftp
# Dónde encontrar las configuraciones específicas de cada usuario
user_config_dir=/etc/vsftpd/usuarios
# Directorio FTP predeterminado. Si no creamos un perfil, no toquen nada.
local_root=/etc/vsftpd/vacio
# Privilegios locales para escribir, para los usuarios FTP remotos.
virtual_use_local_privs=YES
# Enmascarar la información de usuario/grupo en directorios como "ftp"
hide_ids=YES

# Standard behaviour for ftpd(8).
#auth   required   pam_listfile.so item=user sense=deny file=/etc/ftpusers onerr=succeed

# Note: vsftpd handles anonymous logins on its own. Do not enable pam_ftp.so.

# Standard pam includes
#pam_ftp.so
#@include common-account
@include common-session
#@include common-auth
#auth   #required   #pam_shells.so

auth required pam_mysql.so config_file=/etc/security/pam_mysql.conf try_first_pass=false
account required pam_mysql.so config_file=/etc/security/pam_mysql.conf try_first_pass=false

users.host=localhost
users.database=vsftpd
users.db_user=vsftpd
users.db_passwd=123456789
users.table=usuarios
users.user_column=nombre
users.password_column=password
users.password_crypt=2
verbose=1
log.enabled=1
log.table=bitacora
log.message_column=mensaje
log.pid_column=proceso
log.user_column=usuario
log.host_column=servidor
log.rhost_column=cliente
log.time_column=momento

Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option verbose is set to "1"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option log.enabled is set to "1"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option log.table is set to "bitacora"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option log.message_column is set to "mensaje"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option log.pid_column is set to "proceso"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option log.user_column is set to "usuario"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option log.host_column is set to "servidor"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option log.rhost_column is set to "cliente"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option log.time_column is set to "momento"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_sm_authenticate() called.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_converse() called.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_open_db() called.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_open_db() returning 0.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_check_passwd() called.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_format_string() called
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_quick_escape() called.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - SELECT password FROM usuarios WHERE nombre = 'prueba'
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_check_passwd() returning 0.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_sql_log() called.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_format_string() called
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_quick_escape() called.
Jan  1 21:03:34 mako-ubuntu vsftpd: last message repeated 3 times
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - INSERT INTO bitacora (mensaje, usuario, servidor, cliente, proceso, momento) VALUES ('AUTHENTICATION SUCCESS', 'prueba', '127.0.1.1', '192.168.0.3', '1', NOW())
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_sql_log() returning 0.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_sm_authenticate() returning 0.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option config_file is set to "/etc/security/pam_mysql.conf"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option try_first_pass is set to "false"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_close_db() called.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option users.host is set to "localhost"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option users.database is set to "vsftpd"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option users.db_user is set to "vsftpd"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option users.db_passwd is set to "123456789"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option users.table is set to "usuarios"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option users.user_column is set to "nombre"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option users.password_column is set to "password"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option users.password_crypt is set to "2"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option verbose is set to "1"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option log.enabled is set to "1"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option log.table is set to "bitacora"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option log.message_column is set to "mensaje"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option log.pid_column is set to "proceso"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option log.user_column is set to "usuario"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option log.host_column is set to "servidor"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option log.rhost_column is set to "cliente"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - option log.time_column is set to "momento"
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_sm_acct_mgmt() called.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_open_db() called.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_open_db() returning 0.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_query_user_stat() called.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_format_string() called
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_quick_escape() called.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - SELECT 0, password FROM usuarios WHERE nombre = 'prueba'
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_query_user_stat() returning 0.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_sql_log() called.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_format_string() called
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_quick_escape() called.
Jan  1 21:03:34 mako-ubuntu vsftpd: last message repeated 3 times
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - INSERT INTO bitacora (mensaje, usuario, servidor, cliente, proceso, momento) VALUES ('QUERYING SUCCESS', 'prueba', '127.0.1.1', '192.168.0.3', '1', NOW())
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_sql_log() returning 0.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_sm_acct_mgmt() returning 0.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_release_ctx() called.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_destroy_ctx() called.
Jan  1 21:03:34 mako-ubuntu vsftpd: pam_mysql - pam_mysql_close_db() called.