install proftpd with account in sql
컴파일 옵션 ./configure –prefix=/usr/local/proftpd –with-shared=mod_sql:mod_sql_mysql 보통 설치시엔 기타 옵션이 더 있는데.. 일단 sql기반의 유저를 사용하기 위해서는 위 옵션이면 된다. 설정 파일 시스템 기반의 계정을 사용 하는 경우에는 필요가 없음 <IfModule mod_dso.c> LoadModule mod_quotatab.c LoadModule mod_quotatab_sql.c LoadModule mod_sql.c LoadModule mod_sql_mysql.c </IfModule> ################################################################################ # Auth ################################################################################ # Use only AuthUserFiles when authenticating, and not the system’s /etc/passwd AuthOrder mod_sql.c mod_auth_file.c mod_auth_pam.c mod_auth_unix.c MaxLoginAttempts 2 # Block based on /etc/ftpusers UseFtpUsers on AuthPAM on # Use pam to authenticate (default) and be authoritative. # Only need the LoadModule if mod_auth_pam is a DSO. AuthPAMConfig proftpd DebugLevel 0 TransferLog /usr/local/proftpd/logs/transfer.log ExtendedLog /usr/local/proftpd/logs/proftpd.log ALL <IfModule mod_sql.c> SQLBackend mysql SQLAuthenticate users groups SQLAuthTypes OpenSSL Crypt Plaintext SQLLogFile /usr/local/proftpd/logs/sql.log #SQLLog DELE,MKD,RETR,RMD,RNFR,RNTO,STOR,APPE extendedlog # used to connect to the database # databasename@host database_user user_password SQLConnectInfo ftp_db@localhost ftp_db password_of_user # set min UID and GID – otherwise these [ more… ]