Jump to content
Froxlor Forum

Archived

This topic is now archived and is closed to further replies.

  • 0
ade

[solved] Proftpd problem, no such user found - freebsd 9.1

Question

Hi Forum,

I just install Froxlor from ports (fresh install) and follow the intruction Froxlor-configuration wizard and when I try using ftp to user i get this error  U ftpuser: no such user found from xxx.xxx.xxx.xxx, and the user "ftpuser" is in mysql user.

 

this is the config from wizzard /usr/local/etc/proftpd.conf

# Server settings
ServerName                      "domain.com FTP Server"
ServerType                      standalone
DefaultServer                   on
Port                            21
UseIPv6                         off
Umask                           022
SyslogLevel            emerg
SystemLog                       /var/log/xferlog
LogFormat                       auth    "%v [%P] %h %t \"%r\" %s"
ExtendedLog                     /var/log/xferlog        AUTH auth

# General settings
DeferWelcome                    off
MultilineRFC2228                on
ShowSymlinks                    on
TimeoutNoTransfer               600
TimeoutStalled                  600
TimeoutIdle                     1200
DisplayLogin                    welcome.msg
DisplayChdir                    .message
ListOptions                     "-l"
DenyFilter                      \*.*/
MaxInstances                    30
CommandBufferSize        512
User                nobody
Group                nogroup
AllowOverwrite            on

# Allow up- and downloads to be continued
AllowRetrieveRestart    On
AllowStoreRestart        On

<IfModule mod_quotatab.c>
    QuotaEngine on
    QuotaShowQuotas on
    QuotaDisplayUnits Mb
    QuotaLock /var/lock/ftpd.quotatab.lock
</IfModule>

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

<IfModule mod_delay.c>
    DelayEngine off
</IfModule>

<IfModule mod_sql.c>
    DefaultRoot ~
    RequireValidShell off
    AuthOrder mod_sql.c
    SQLBackend mysql
    SQLEngine on
    SQLAuthenticate on
    SQLAuthTypes Crypt
    SQLAuthenticate users* groups*
    SQLConnectInfo froxlor@127.0.0.1 froxlor mypassword
    SQLUserInfo ftp_users username password uid gid homedir shell
    SQLGroupInfo ftp_groups groupname gid members
    SQLUserWhereClause "login_enabled = 'y'"

    SQLLog PASS login
    SQLNamedQuery login UPDATE "last_login=now(), login_count=login_count+1 WHERE username='%u'" ftp_users

    SQLLog RETR download
    SQLNamedQuery download UPDATE "down_count=down_count+1, down_bytes=down_bytes+%b WHERE username='%u'" ftp_users

    SQLLog STOR upload
    SQLNamedQuery upload UPDATE "up_count=up_count+1, up_bytes=up_bytes+%b WHERE username='%u'" ftp_users

    QuotaLimitTable sql:/get-quota-limit
    QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally
    SQLNamedQuery get-quota-limit SELECT "ftp_users.username AS name, ftp_quotalimits.quota_type, ftp_quotalimits.per_session, ftp_quotalimits.limit_type, panel_customers.diskspace*1024 AS bytes_in_avail, ftp_quotalimits.bytes_out_avail, ftp_quotalimits.bytes_xfer_avail, ftp_quotalimits.files_in_avail, ftp_quotalimits.files_out_avail, ftp_quotalimits.files_xfer_avail FROM ftp_users, ftp_quotalimits, panel_customers WHERE ftp_users.username = '%{0}' AND panel_customers.loginname = SUBSTRING_INDEX('%{0}', 'ftp', 1) 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 ftp_quotatallies 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}'" ftp_quotatallies
    SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4},%{5}, %{6}, %{7}" ftp_quotatallies
</IfModule>


#<IfModule mod_tls.c>
#    TLSEngine on
#    TLSLog /var/log/xferlog
#    TLSProtocol SSLv23
#    TLSRequired off
#    TLSRSACertificateFile /etc/ssl/cert.pem
#    TLSRSACertificateKeyFile /etc/ssl/key.pem
#    TLSVerifyClient off
#    TLSRenegotiate required off
#</IfModule>

Thank you

 

Ade

Share this post


Link to post
Share on other sites

9 answers to this question

Recommended Posts

Die you double check that your MySQL connection credentials are correct? Does the ftp-user exists in table 'ftp_users'?

Share this post


Link to post
Share on other sites

Yes, I can login using username password and find thta username

mysql> SELECT * FROM `ftp_users`;
+----+---------------+-------+-------+------------------------------------+--------------------------------+------------+---------------+-------------+---------------------+----------+----------+------------+------------+------------+
| id | username      | uid   | gid   | password                           | homedir                        | shell      | login_enabled | login_count | last_login          | up_count | up_bytes | down_count | down_bytes | customerid |
+----+---------------+-------+-------+------------------------------------+--------------------------------+------------+---------------+-------------+---------------------+----------+----------+------------+------------+------------+
|  1 | ftpuser       | 10000 | 10000 | XXX | /var/customers/webs/domainxxx/ | /bin/false | Y             |           0 | 0000-00-00 00:00:00 |        0 |        0 |          0 |          0 |          1 |
|  2 | ftpuser1      | 10001 | 10001 | XXX | /var/customers/webs/domainxxx/ | /bin/false | Y             |           0 | 0000-00-00 00:00:00 |        0 |        0 |          0 |          0 |          2 |
|  3 | ftpuser123    | 10000 | 10000 | XXX | /var/customers/webs/domainxxx/ | /bin/false | Y             |           0 | 0000-00-00 00:00:00 |        0 |        0 |          0 |          0 |          1 |
+----+---------------+-------+-------+------------------------------------+--------------------------------+------------+---------------+-------------+---------------------+----------+----------+------------+------------+------------+
3 rows in set (0.00 sec)

Share this post


Link to post
Share on other sites

Try changing the following line in proftpd.conf

- SQLConnectInfo froxlor@127.0.0.1 froxlor mypassword
+ SQLConnectInfo froxlor@localhost froxlor mypassword

sometimes this does the trick. If not, enable debugging in proftpd to see if he at least connects to the database etc.

Share this post


Link to post
Share on other sites

I tried change with but still have same problem

here is  proftpd in debug mode

/usr/local/sbin/proftpd -n -d 20
cana.mydomain.com proftpd[97408]: using PCRE 8.33 2013-05-28
cana.mydomain.com proftpd[97408]: using TCP receive buffer size of 65536 bytes
cana.mydomain.com proftpd[97408]: using TCP send buffer size of 32768 bytes
cana.mydomain.com proftpd[97408]: testing Unix domain socket using S_ISFIFO
cana.mydomain.com proftpd[97408]: testing Unix domain socket using S_ISSOCK
cana.mydomain.com proftpd[97408]: using S_ISSOCK macro for Unix domain socket detection
cana.mydomain.com proftpd[97408]: ROOT PRIVS at mod_log.c:588
cana.mydomain.com proftpd[97408]: RELINQUISH PRIVS at mod_log.c:593
cana.mydomain.com proftpd[97408]: DenyFilter: compiling regex '\*.*/'
cana.mydomain.com proftpd[97408]: retrieved UID 65534 for user 'nobody'
cana.mydomain.com proftpd[97408]: retrieved GID 65533 for group 'nogroup'
cana.mydomain.com proftpd[97408]: <IfModule>: skipping 'mod_quotatab.c' section at line 34
cana.mydomain.com proftpd[97408]: <IfModule>: skipping 'mod_ratio.c' section at line 41
cana.mydomain.com proftpd[97408]: <IfModule>: using 'mod_delay.c' section at line 45
cana.mydomain.com proftpd[97408]: <IfModule>: skipping 'mod_sql.c' section at line 49
cana.mydomain.com proftpd[97408]: ROOT PRIVS at mod_core.c:392
cana.mydomain.com proftpd[97408]: <IfModule>: skipping 'mod_sql.c' section at line 1
cana.mydomain.com proftpd[97408]: RELINQUISH PRIVS at mod_core.c:414
cana.mydomain.com proftpd[97408] cana:
cana.mydomain.com proftpd[97408] cana: Config for mydomain.com FTP Server:
cana.mydomain.com proftpd[97408] cana: DefaultServer
cana.mydomain.com proftpd[97408] cana: Umask
cana.mydomain.com proftpd[97408] cana: SyslogLevel
cana.mydomain.com proftpd[97408] cana: ExtendedLog
cana.mydomain.com proftpd[97408] cana: DeferWelcome
cana.mydomain.com proftpd[97408] cana: MultilineRFC2228
cana.mydomain.com proftpd[97408] cana: ShowSymlinks
cana.mydomain.com proftpd[97408] cana: TimeoutNoTransfer
cana.mydomain.com proftpd[97408] cana: TimeoutStalled
cana.mydomain.com proftpd[97408] cana: TimeoutIdle
cana.mydomain.com proftpd[97408] cana: DisplayLogin
cana.mydomain.com proftpd[97408] cana: DisplayChdir
cana.mydomain.com proftpd[97408] cana: ListOptions
cana.mydomain.com proftpd[97408] cana: DenyFilter
cana.mydomain.com proftpd[97408] cana: CommandBufferSize
cana.mydomain.com proftpd[97408] cana: UserID
cana.mydomain.com proftpd[97408] cana: UserName
cana.mydomain.com proftpd[97408] cana: GroupID
cana.mydomain.com proftpd[97408] cana: GroupName
cana.mydomain.com proftpd[97408] cana: AllowOverwrite
cana.mydomain.com proftpd[97408] cana: AllowRetrieveRestart
cana.mydomain.com proftpd[97408] cana: AllowStoreRestart
cana.mydomain.com proftpd[97408] cana: DelayEngine
cana.mydomain.com proftpd[97408] cana: mod_lang/0.9: binding to text domain 'proftpd' using locale path '/usr/local/share/locale'
cana.mydomain.com proftpd[97408] cana: mod_lang/0.9: using locale files in '/usr/local/share/locale'
cana.mydomain.com proftpd[97408] cana: mod_lang/0.9: added the following supported languages: es_ES.UTF-8, es_ES, fr_FR.UTF-8, fr_FR, zh_CN.UTF-8, zh_CN, zh_TW.UTF-8, zh_TW, bg_BG.UTF-8, bg_BG, en_US.UTF-8, en_US, it_IT.UTF-8, it_IT, ja_JP.UTF-8, ja_JP, ko_KR.UTF-8, ko_KR, ru_RU.UTF-8, ru_RU
cana.mydomain.com proftpd[97408] cana: ROOT PRIVS at mod_ctrls.c:1168
cana.mydomain.com proftpd[97408] cana: RELINQUISH PRIVS at mod_ctrls.c:1170
cana.mydomain.com proftpd[97408] cana: retrieved group ID: 65534
cana.mydomain.com proftpd[97408] cana: setting group ID: 65534
cana.mydomain.com proftpd[97408] cana: SETUP PRIVS at main.c:3336
cana.mydomain.com proftpd[97408] cana: ROOT PRIVS at main.c:2306
cana.mydomain.com proftpd[97408] cana: RELINQUISH PRIVS at main.c:2315
cana.mydomain.com proftpd[97408] cana: ROOT PRIVS at main.c:2673
cana.mydomain.com proftpd[97408] cana: opening scoreboard '/var/run/proftpd.scoreboard'
cana.mydomain.com proftpd[97408] cana: RELINQUISH PRIVS at main.c:2699
cana.mydomain.com proftpd[97408] cana: ROOT PRIVS at inet.c:235
cana.mydomain.com proftpd[97408] cana: RELINQUISH PRIVS at inet.c:254
cana.mydomain.com proftpd[97408] cana: ROOT PRIVS at inet.c:348
cana.mydomain.com proftpd[97408] cana: RELINQUISH PRIVS at inet.c:411
cana.mydomain.com proftpd[97408] cana: ProFTPD 1.3.4d (maint) (built Tue Sep 24 2013 17:50:55 WIT) standalone mode STARTUP
cana.mydomain.com proftpd[97408] cana: ROOT PRIVS at pidfile.c:47
cana.mydomain.com proftpd[97408] cana: RELINQUISH PRIVS at pidfile.c:49
cana.mydomain.com proftpd[97408] cana: ROOT PRIVS at mod_ctrls.c:709
cana.mydomain.com proftpd[97408] cana: RELINQUISH PRIVS at mod_ctrls.c:713
cana.mydomain.com proftpd[97408] cana: scrubbing scoreboard
cana.mydomain.com proftpd[97408] cana: ROOT PRIVS at scoreboard.c:1369
cana.mydomain.com proftpd[97408] cana: RELINQUISH PRIVS at scoreboard.c:1372
cana.mydomain.com proftpd[97414] cana: ROOT PRIVS at main.c:1272
cana.mydomain.com proftpd[97414] cana: RELINQUISH PRIVS at main.c:1276
cana.mydomain.com proftpd[97414] cana: no matching vhost found for xxx.xxx.xxx.xxx#21, using 'mydomain.com FTP Server' listening on wildcard address
cana.mydomain.com proftpd[97414] cana: notice: unable to resolve 'fm-dyn-xxx-xxx-xxx-xxx.com': Unknown host
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): ROOT PRIVS at main.c:1087
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): SETUP PRIVS at main.c:1092
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): session requested from client in unknown class
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): performing module session initializations
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): mod_ident/1.0: ident lookup disabled
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): mod_log: opening ExtendedLog '/var/log/xferlog'
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): ROOT PRIVS at mod_log.c:1558
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): RELINQUISH PRIVS at mod_log.c:1561
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): ROOT PRIVS at mod_auth.c:129
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): opening scoreboard '/var/run/proftpd.scoreboard'
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): RELINQUISH PRIVS at mod_auth.c:131
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): connected - local  : 117.103.65.14:21
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): connected - remote : xxx.xxx.xxx.xxxx:51103
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): FTP session opened.
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): setting CommandBufferSize to 512
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): dispatching PRE_CMD command 'USER ftpuser' to mod_core
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): dispatching PRE_CMD command 'USER ftpuser' to mod_core
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): dispatching PRE_CMD command 'USER ftpuser' to mod_delay
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): dispatching PRE_CMD command 'USER ftpuser' to mod_auth
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): dispatching CMD command 'USER ftpuser' to mod_auth
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): dispatching POST_CMD command 'USER ftpuser' to mod_delay
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): dispatching LOG_CMD command 'USER ftpuser' to mod_log
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): dispatching PRE_CMD command 'PASS (hidden)' to mod_core
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): dispatching PRE_CMD command 'PASS (hidden)' to mod_core
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): dispatching PRE_CMD command 'PASS (hidden)' to mod_delay
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): dispatching CMD command 'PASS (hidden)' to mod_auth
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): USER ftpuser: no such user found from xxx.xxx.xxx.xxxx [xxx.xxx.xxx.xxxx] to xxx.xxx.xxx.xxx:21
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_delay
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth
cana.mydomain.com proftpd[97414] cana (xxx.xxx.xxx.xxxx[xxx.xxx.xxx.xxxx]): FTP session closed.
cana.mydomain.com proftpd[97408] cana: scrubbing scoreboard
cana.mydomain.com proftpd[97408] cana: ROOT PRIVS at scoreboard.c:1369
cana.mydomain.com proftpd[97408] cana: RELINQUISH PRIVS at scoreboard.c:1372

pkg_info |grep ftp
php5-ftp-5.4.19     The ftp shared extension for php
proftpd-1.3.4d      Highly configurable FTP daemon
proftpd-mod_sql_mysql-1.3.4d MySQL ProFTPD module


 

Share this post


Link to post
Share on other sites

Seems you mod_sql is not enabled, can you verify that you have proftpd with mysql support and that the modules mod_sql and mod_sql_mysql are loaded correctly?

Share this post


Link to post
Share on other sites

I add into proftpd.conf

LoadModule mod_quotatab.c
LoadModule mod_ratio.c
LoadModule mod_tls.c
LoadModule mod_sql.c
LoadModule mod_ban.c
 

pkg_info |grep ftp
proftpd-1.3.4d      Highly configurable FTP daemon
proftpd-mod_sql_mysql-1.3.4d MySQL ProFTPD module

 

and have different error

/usr/local/sbin/proftpd -n -d 20
cana.mydomain.com proftpd[98569]: using PCRE 8.33 2013-05-28
cana.mydomain.com proftpd[98569]: using TCP receive buffer size of 65536 bytes
cana.mydomain.com proftpd[98569]: using TCP send buffer size of 32768 bytes
cana.mydomain.com proftpd[98569]: testing Unix domain socket using S_ISFIFO
cana.mydomain.com proftpd[98569]: testing Unix domain socket using S_ISSOCK
cana.mydomain.com proftpd[98569]: using S_ISSOCK macro for Unix domain socket detection
cana.mydomain.com proftpd[98569]: ROOT PRIVS at mod_log.c:588
cana.mydomain.com proftpd[98569]: RELINQUISH PRIVS at mod_log.c:593
cana.mydomain.com proftpd[98569]: DenyFilter: compiling regex '\*.*/'
cana.mydomain.com proftpd[98569]: retrieved UID 65534 for user 'nobody'
cana.mydomain.com proftpd[98569]: retrieved GID 65533 for group 'nogroup'
cana.mydomain.com proftpd[98569]: loading 'mod_quotatab.c'
cana.mydomain.com proftpd[98569]: loading 'mod_ratio.c'
cana.mydomain.com proftpd[98569]: loading 'mod_tls.c'
cana.mydomain.com proftpd[98569]: mod_tls/2.4.3: using OpenSSL 0.9.8x 10 May 2012
cana.mydomain.com proftpd[98569]: loading 'mod_sql.c'
cana.mydomain.com proftpd[98569]: loading 'mod_ban.c'
cana.mydomain.com proftpd[98569]: <IfModule>: using 'mod_quotatab.c' section at line 39
cana.mydomain.com proftpd[98569]: <IfModule>: using 'mod_ratio.c' section at line 46
cana.mydomain.com proftpd[98569]: <IfModule>: using 'mod_delay.c' section at line 51
cana.mydomain.com proftpd[98569]: <IfModule>: using 'mod_sql.c' section at line 55
cana.mydomain.com proftpd[98569]: SQLAuthenticate: use of '*' in SQLAuthenticate has been deprecated.  Use AuthOrder for setting authoritativeness
cana.mydomain.com proftpd[98569]: SQLAuthenticate: use of '*' in SQLAuthenticate has been deprecated.  Use AuthOrder for setting authoritativeness
cana.mydomain.com proftpd[98569] cana:
cana.mydomain.com proftpd[98569] cana: Config for mydomain.com FTP Server:
cana.mydomain.com proftpd[98569] cana: DefaultServer
cana.mydomain.com proftpd[98569] cana: Umask
cana.mydomain.com proftpd[98569] cana: SyslogLevel
cana.mydomain.com proftpd[98569] cana: ExtendedLog
cana.mydomain.com proftpd[98569] cana: DeferWelcome
cana.mydomain.com proftpd[98569] cana: MultilineRFC2228
cana.mydomain.com proftpd[98569] cana: ShowSymlinks
cana.mydomain.com proftpd[98569] cana: TimeoutNoTransfer
cana.mydomain.com proftpd[98569] cana: TimeoutStalled
cana.mydomain.com proftpd[98569] cana: TimeoutIdle
cana.mydomain.com proftpd[98569] cana: DisplayLogin
cana.mydomain.com proftpd[98569] cana: DisplayChdir
cana.mydomain.com proftpd[98569] cana: ListOptions
cana.mydomain.com proftpd[98569] cana: DenyFilter
cana.mydomain.com proftpd[98569] cana: CommandBufferSize
cana.mydomain.com proftpd[98569] cana: UserID
cana.mydomain.com proftpd[98569] cana: UserName
cana.mydomain.com proftpd[98569] cana: GroupID
cana.mydomain.com proftpd[98569] cana: GroupName
cana.mydomain.com proftpd[98569] cana: AllowOverwrite
cana.mydomain.com proftpd[98569] cana: AllowRetrieveRestart
cana.mydomain.com proftpd[98569] cana: AllowStoreRestart
cana.mydomain.com proftpd[98569] cana: QuotaEngine
cana.mydomain.com proftpd[98569] cana: QuotaShowQuotas
cana.mydomain.com proftpd[98569] cana: QuotaDisplayUnits
cana.mydomain.com proftpd[98569] cana: QuotaLock
cana.mydomain.com proftpd[98569] cana: Ratios
cana.mydomain.com proftpd[98569] cana: DelayEngine
cana.mydomain.com proftpd[98569] cana: DefaultRoot
cana.mydomain.com proftpd[98569] cana: RequireValidShell
cana.mydomain.com proftpd[98569] cana: AuthOrder
cana.mydomain.com proftpd[98569] cana: SQLBackend
cana.mydomain.com proftpd[98569] cana: SQLEngine
cana.mydomain.com proftpd[98569] cana: SQLAuthenticate
cana.mydomain.com proftpd[98569] cana: SQLAuthTypes
cana.mydomain.com proftpd[98569] cana: SQLAuthenticate
cana.mydomain.com proftpd[98569] cana: SQLConnectInfo
cana.mydomain.com proftpd[98569] cana: SQLUserTable
cana.mydomain.com proftpd[98569] cana: SQLUsernameField
cana.mydomain.com proftpd[98569] cana: SQLPasswordField
cana.mydomain.com proftpd[98569] cana: SQLUidField
cana.mydomain.com proftpd[98569] cana: SQLGidField
cana.mydomain.com proftpd[98569] cana: SQLHomedirField
cana.mydomain.com proftpd[98569] cana: SQLShellField
cana.mydomain.com proftpd[98569] cana: SQLGroupTable
cana.mydomain.com proftpd[98569] cana: SQLGroupnameField
cana.mydomain.com proftpd[98569] cana: SQLGroupGIDField
cana.mydomain.com proftpd[98569] cana: SQLGroupMembersField
cana.mydomain.com proftpd[98569] cana: SQLUserWhereClause
cana.mydomain.com proftpd[98569] cana: SQLLog_PASS
cana.mydomain.com proftpd[98569] cana: SQLNamedQuery_login
cana.mydomain.com proftpd[98569] cana: SQLLog_RETR
cana.mydomain.com proftpd[98569] cana: SQLNamedQuery_download
cana.mydomain.com proftpd[98569] cana: SQLLog_STOR
cana.mydomain.com proftpd[98569] cana: SQLNamedQuery_upload
cana.mydomain.com proftpd[98569] cana: QuotaLimitTable
cana.mydomain.com proftpd[98569] cana: QuotaTallyTable
cana.mydomain.com proftpd[98569] cana: SQLNamedQuery_get-quota-limit
cana.mydomain.com proftpd[98569] cana: SQLNamedQuery_get-quota-tally
cana.mydomain.com proftpd[98569] cana: SQLNamedQuery_update-quota-tally
cana.mydomain.com proftpd[98569] cana: SQLNamedQuery_insert-quota-tally
cana.mydomain.com proftpd[98569] cana: mod_lang/0.9: binding to text domain 'proftpd' using locale path '/usr/local/share/locale'
cana.mydomain.com proftpd[98569] cana: mod_lang/0.9: using locale files in '/usr/local/share/locale'
cana.mydomain.com proftpd[98569] cana: mod_lang/0.9: added the following supported languages: es_ES.UTF-8, es_ES, fr_FR.UTF-8, fr_FR, zh_CN.UTF-8, zh_CN, zh_TW.UTF-8, zh_TW, bg_BG.UTF-8, bg_BG, en_US.UTF-8, en_US, it_IT.UTF-8, it_IT, ja_JP.UTF-8, ja_JP, ko_KR.UTF-8, ko_KR, ru_RU.UTF-8, ru_RU
cana.mydomain.com proftpd[98569] cana: ROOT PRIVS at mod_ctrls.c:1168
cana.mydomain.com proftpd[98569] cana: RELINQUISH PRIVS at mod_ctrls.c:1170
cana.mydomain.com proftpd[98569] cana: retrieved group ID: 65534
cana.mydomain.com proftpd[98569] cana: setting group ID: 65534
cana.mydomain.com proftpd[98569] cana: SETUP PRIVS at main.c:3336
cana.mydomain.com proftpd[98569] cana: ROOT PRIVS at main.c:2306
cana.mydomain.com proftpd[98569] cana: RELINQUISH PRIVS at main.c:2315
cana.mydomain.com proftpd[98569] cana: ROOT PRIVS at main.c:2673
cana.mydomain.com proftpd[98569] cana: opening scoreboard '/var/run/proftpd.scoreboard'
cana.mydomain.com proftpd[98569] cana: RELINQUISH PRIVS at main.c:2699
cana.mydomain.com proftpd[98569] cana: ROOT PRIVS at inet.c:235
cana.mydomain.com proftpd[98569] cana: RELINQUISH PRIVS at inet.c:254
cana.mydomain.com proftpd[98569] cana: ROOT PRIVS at inet.c:348
cana.mydomain.com proftpd[98569] cana: RELINQUISH PRIVS at inet.c:411
cana.mydomain.com proftpd[98569] cana: ProFTPD 1.3.4d (maint) (built Tue Sep 24 2013 17:50:55 WIT) standalone mode STARTUP
cana.mydomain.com proftpd[98569] cana: ROOT PRIVS at pidfile.c:47
cana.mydomain.com proftpd[98569] cana: RELINQUISH PRIVS at pidfile.c:49
cana.mydomain.com proftpd[98569] cana: ROOT PRIVS at mod_ctrls.c:709
cana.mydomain.com proftpd[98569] cana: RELINQUISH PRIVS at mod_ctrls.c:713
cana.mydomain.com proftpd[98570] cana: ROOT PRIVS at main.c:1272
cana.mydomain.com proftpd[98570] cana: RELINQUISH PRIVS at main.c:1276
cana.mydomain.com proftpd[98570] cana: no matching vhost found for xxx.xxx.xxx.xxx#21, using 'mydomain.com FTP Server' listening on wildcard address
cana.mydomain.com proftpd[98570] cana: notice: unable to resolve 'fm-dyn-xxx-xxx-xxx-xxx.com': Unknown host
cana.mydomain.com proftpd[98570] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): ROOT PRIVS at main.c:1087
cana.mydomain.com proftpd[98570] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): SETUP PRIVS at main.c:1092
cana.mydomain.com proftpd[98570] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): session requested from client in unknown class
cana.mydomain.com proftpd[98570] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): performing module session initializations
cana.mydomain.com proftpd[98570] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): mod_sql/4.3: no SQL backends registered
cana.mydomain.com proftpd[98570] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): mod_sql.c: error initializing session: No such file or directory
cana.mydomain.com proftpd[98570] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): FTP session closed.
cana.mydomain.com proftpd[98571] cana: ROOT PRIVS at main.c:1272
cana.mydomain.com proftpd[98571] cana: RELINQUISH PRIVS at main.c:1276
cana.mydomain.com proftpd[98571] cana: no matching vhost found for xxx.xxx.xxx.xxx#21, using 'mydomain.com FTP Server' listening on wildcard address
cana.mydomain.com proftpd[98571] cana: notice: unable to resolve 'fm-dyn-xxx-xxx-xxx-xxx.com': Unknown host
cana.mydomain.com proftpd[98571] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): ROOT PRIVS at main.c:1087
cana.mydomain.com proftpd[98571] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): SETUP PRIVS at main.c:1092
cana.mydomain.com proftpd[98571] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): session requested from client in unknown class
cana.mydomain.com proftpd[98571] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): performing module session initializations
cana.mydomain.com proftpd[98571] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): mod_sql/4.3: no SQL backends registered
cana.mydomain.com proftpd[98571] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): mod_sql.c: error initializing session: No such file or directory
cana.mydomain.com proftpd[98571] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): FTP session closed.
cana.mydomain.com proftpd[98569] cana: ProFTPD terminating (signal 2)
cana.mydomain.com proftpd[98569] cana: ROOT PRIVS at main.c:2074
cana.mydomain.com proftpd[98569] cana: RELINQUISH PRIVS at main.c:2099
cana.mydomain.com proftpd[98569] cana: ProFTPD 1.3.4d standalone mode SHUTDOWN
cana.mydomain.com proftpd[98569] cana: ROOT PRIVS at main.c:2106
cana.mydomain.com proftpd[98569] cana: deleting existing scoreboard '/var/run/proftpd.scoreboard'
cana.mydomain.com proftpd[98569] cana: RELINQUISH PRIVS at main.c:2108

Share this post


Link to post
Share on other sites

From another (german) topic: in case it's an "older" ftp user, try to re-set the password using froxlor (new format)

Share this post


Link to post
Share on other sites

I did change password and tried make new user but still have same result :(

 

cana.mydomain.com proftpd[38772] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): ROOT PRIVS at main.c:1087
cana.mydomain.com proftpd[38772] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): SETUP PRIVS at main.c:1092
cana.mydomain.com proftpd[38772] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): session requested from client in unknown class
cana.mydomain.com proftpd[38772] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): performing module session initializations
cana.mydomain.com proftpd[38772] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): mod_sql/4.3: no SQL backends registered
cana.mydomain.com proftpd[38772] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): mod_sql.c: error initializing session: No such file or directory
cana.mydomain.com proftpd[38772] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): FTP session closed.

 

update:

finnaly ican login :)

 

I added mode module in proftpd.conf :

 

LoadModule mod_ratio.c
LoadModule mod_tls.c
LoadModule mod_sql.c
LoadModule mod_ban.c
LoadModule mod_sql_mysql.c
LoadModule mod_quotatab.c
LoadModule mod_quotatab_file.c
LoadModule mod_quotatab_sql.c
LoadModule mod_radius.c
LoadModule mod_rewrite.c

 

Thanks d00p :)

 

Share this post


Link to post
Share on other sites

I did change password and tried make new user but still have same result :(

 

cana.mydomain.com proftpd[38772] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): ROOT PRIVS at main.c:1087

cana.mydomain.com proftpd[38772] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): SETUP PRIVS at main.c:1092

cana.mydomain.com proftpd[38772] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): session requested from client in unknown class

cana.mydomain.com proftpd[38772] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): performing module session initializations

cana.mydomain.com proftpd[38772] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): mod_sql/4.3: no SQL backends registered

cana.mydomain.com proftpd[38772] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): mod_sql.c: error initializing session: No such file or directory

cana.mydomain.com proftpd[38772] cana (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]): FTP session closed.

 

update:

finnaly ican login :)

 

I added mode module in proftpd.conf :

 

LoadModule mod_ratio.c

LoadModule mod_tls.c

LoadModule mod_sql.c

LoadModule mod_ban.c

LoadModule mod_sql_mysql.c

LoadModule mod_quotatab.c

LoadModule mod_quotatab_file.c

LoadModule mod_quotatab_sql.c

LoadModule mod_radius.c

LoadModule mod_rewrite.c

 

Thanks d00p :)

 

 

Seeing, that you load a bunch of modules, I'd like to hop in for some clarification. Albeit a bit late, I realize :)

 

 

The port installs ftp/proftpd and databases/proftpd-mod_sql_mysql, but you need to manually insert the modules into ProFTPDs configuration file. I could make the port do that for you, but then, there's far more to configure - and picking out a single configuration change for automatic handling is likely to have people asking me for doing it for anything else, also.

 

For being able to authenticate against a MySQL database, you just need:

LoadModule mod_sql.c
LoadModule mod_sql_mysql.c
AuthOrder mod_sql.c

The fist two lines tell ProFTPD to load the needed modules, the third line tells it only authenticate against the MySQL database.

 

Of course you then need to add some more SQL* statements for the actual authentication, but obviously you already did that.

 

All other modules you're loading are not needed for simply authenticating against ProFTPD.

 

MfG CoCo

Edit: Removed factual error.

Share this post


Link to post
Share on other sites

×
×
  • Create New...