[HELP] FTP: Wrong Password

[amilo]

Hi all

I have a problem with the FTP The situation is:

I create ftp user (user@domain.tld) - OK Then try to login with created user
in our case "user@domain.tld" it tell me that the password is wrong...
I change it but there is no result

OS: Ubuntu 8.04 Server

Core: 32bit - Intel Core 2 Duo Conroe 6700

Server Type: Real Server

Date of install : 23.05.2008

Trunk Number : ispcp-omega-trunk-20080523

Ticket #1283

A.W > I try with pureftpd too

Thanks in advance

Amilo1

[amilo]

I installed debian etch + ispcp but the proftpd doesn't work properly

[BeNe]

Maybe your Password has an special charater in proftpd.conf and can´t connect to your MySQL DB. This happens during the installation with the Autocreate function. It is a bit buggy. So check your proftpd pass for the MySQL.

Next is try to start the Proftp in Debug Mode but first kill all other proftpd process.

Code:

# proftpd -n -d5

Greez BeNe

[rbtux]

Additionaly turn on sql logging (mod_sql doesn't log in proftpd debug mode)

To enable logging add the following directive into you proftpd.conf
SQLLogFile /var/log/proftpd-mod_sql.log

[amilo]

BeNe Wrote:Maybe your Password has an special charater in proftpd.conf and can´t connect to your MySQL DB. This happens during the installation with the Autocreate function. It is a bit buggy. So check your proftpd pass for the MySQL.

Next is try to start the Proftp in Debug Mode but first kill all other proftpd process.

Code:

# proftpd -n -d5

Greez BeNe

rbtux Wrote:Additionaly turn on sql logging (mod_sql doesn't log in proftpd debug mode)

To enable logging add the following directive into you proftpd.conf
SQLLogFile /var/log/proftpd-mod_sql.log

-bash: proftpd: command not found

First i want to thank u for the help! Let's start now

First I add this in proftpd.conf

SQLLogFile /var/log/proftpd-mod_sql.lo

Than i type in terminal : proftpd -n -d5
It retutn me this error:

-bash: proftpd: command not found

When i adding the SQLLogFile /var/log/proftpd-mod_sql.log

I saw that the proftpd.conf is not configured right... i think look at the user and password field:

Code:

# ispCP SQL Managment
SQLBackend                 mysql
SQLAuthTypes               Crypt
SQLAuthenticate            on
SQLConnectInfo             ispcp@localhost vftp PASSWORD
SQLUserInfo                ftp_users userid passwd uid gid homedir shell
SQLGroupInfo               ftp_group groupname gid members
SQLMinID                   2000

I think it need to be {USER} @ {HOST} etc... but look at it

Code:

ServerName                 "i1.optiumbg.net"

Thanks in advance aggain

[rbtux]

amilo Wrote:-bash: proftpd: command not found

Well its not in your path... Are you logged in as root? (try sudo bash)
Use absolute path then...
/usr/sbin/proftpd


Please work with us!!!

[amilo]

Thanks,yes i am logged as root. sudo is not working on debian etch 4.0 U need to isntall it...

Quote:Use absolute path then...
/usr/sbin/proftpd

So when i type cd /usr/sbin/proftpd

Code:

i1:~# cd /usr/sbin/proftpd
bash: cd: /usr/sbin/proftpd: No such file or directory

Thanks in advance but this is very very strange because i think it was from ubuntu now i installed debian etch but it's a same work ;(

[rbtux]

is proftpd installed?

have you searched for the file?

[amilo]

yes there is a file not a folder can i ask u smth on pm?

[amilo]

So finally look after the command

Code:

- mod_ctrls/0.9.4: binding ctrls socket to '/var/run/proftpd/proftpd.sock'
- parsing '/etc/proftpd/proftpd.conf' configuration
- parsing '/etc/proftpd/modules.conf' configuration
- mod_tls/2.1.1: using OpenSSL 0.9.8c 05 Sep 2006
- disabling runtime support for IPv6 connections
- DenyFilter: compiling deny regex '\*.*/'
- <Directory /*>: deferring resolution of path
- <Directory ~/>: deferring resolution of path
- PathDenyFilter: compiling deny regex '^/(backups|cgi-bin|htdocs|errors|logs|phptmp|statistics)/?$'
- PathDenyFilter: compiling deny regex '.quota$'
- <IfModule>: skipping 'mod_quota.c' section at line 128
- <IfModule>: skipping 'mod_ratio.c' section at line 143
- <IfModule>: using 'mod_delay.c' section at line 150
- <IfModule>: using 'mod_ctrls.c' section at line 154
- mod_ctrls/0.9.4: closing ctrls socket '/var/run/proftpd/proftpd.sock' (3)
- <IfModule>: using 'mod_ctrls_admin.c' section at line 162
i1.optiumbg.net -
i1.optiumbg.net - Config for i1.optiumbg.net:
i1.optiumbg.net - Limit
i1.optiumbg.net -  IgnoreHidden
i1.optiumbg.net - ~/
i1.optiumbg.net -  PathDenyFilter
i1.optiumbg.net -  ShowSymlinks
i1.optiumbg.net -  AllowOverwrite
i1.optiumbg.net -  AllowStoreRestart
i1.optiumbg.net -  AllowForeignAddress
i1.optiumbg.net -  DisplayLogin
i1.optiumbg.net -  DisplayFirstChdir
i1.optiumbg.net -  ListOptions
i1.optiumbg.net -  DenyFilter
i1.optiumbg.net -  SQLAuthTypes
i1.optiumbg.net -  SQLAuthenticate
i1.optiumbg.net -  SQLConnectInfo
i1.optiumbg.net -  SQLMinID
i1.optiumbg.net -  RootLogin
i1.optiumbg.net -  TransferLog
i1.optiumbg.net - /*
i1.optiumbg.net -  Umask
i1.optiumbg.net -  DirUmask
i1.optiumbg.net -  AllowOverwrite
i1.optiumbg.net -  HideNoAccess
i1.optiumbg.net -  ShowSymlinks
i1.optiumbg.net -  AllowStoreRestart
i1.optiumbg.net -  AllowForeignAddress
i1.optiumbg.net -  DisplayLogin
i1.optiumbg.net -  DisplayFirstChdir
i1.optiumbg.net -  ListOptions
i1.optiumbg.net -  DenyFilter
i1.optiumbg.net -  SQLAuthTypes
i1.optiumbg.net -  SQLAuthenticate
i1.optiumbg.net -  SQLConnectInfo
i1.optiumbg.net -  SQLMinID
i1.optiumbg.net -  RootLogin
i1.optiumbg.net -  TransferLog
i1.optiumbg.net -  PathDenyFilter
i1.optiumbg.net - DeferWelcome
i1.optiumbg.net - DefaultServer
i1.optiumbg.net - ShowSymlinks
i1.optiumbg.net - AllowOverwrite
i1.optiumbg.net - IdentLookups
i1.optiumbg.net - AllowStoreRestart
i1.optiumbg.net - AllowForeignAddress
i1.optiumbg.net - TimeoutLogin
i1.optiumbg.net - TimeoutNoTransfer
i1.optiumbg.net - TimeoutStalled
i1.optiumbg.net - TimeoutIdle
i1.optiumbg.net - DisplayLogin
i1.optiumbg.net - DisplayFirstChdir
i1.optiumbg.net - ListOptions
i1.optiumbg.net - DenyFilter
i1.optiumbg.net - DefaultRoot
i1.optiumbg.net - UserID
i1.optiumbg.net - UserName
i1.optiumbg.net - GroupID
i1.optiumbg.net - GroupName
i1.optiumbg.net - DelayEngine
i1.optiumbg.net - SQLBackend
i1.optiumbg.net - SQLAuthTypes
i1.optiumbg.net - SQLAuthenticate
i1.optiumbg.net - SQLConnectInfo
i1.optiumbg.net - SQLUserTable
i1.optiumbg.net - SQLUsernameField
i1.optiumbg.net - SQLPasswordField
i1.optiumbg.net - SQLUidField
i1.optiumbg.net - SQLGidField
i1.optiumbg.net - SQLHomedirField
i1.optiumbg.net - SQLShellField
i1.optiumbg.net - SQLGroupTable
i1.optiumbg.net - SQLGroupnameField
i1.optiumbg.net - SQLGroupGIDField
i1.optiumbg.net - SQLGroupMembersField
i1.optiumbg.net - SQLMinID
i1.optiumbg.net - SQLLogFile
i1.optiumbg.net - RootLogin
i1.optiumbg.net - TransferLog
i1.optiumbg.net - ExtendedLog
i1.optiumbg.net - PathDenyFilter
i1.optiumbg.net - mod_ctrls/0.9.4: binding ctrls socket to '/var/run/proftpd/proftpd.sock'
i1.optiumbg.net - deleting existing scoreboard '/var/run/proftpd/proftpd.scoreboard'
i1.optiumbg.net - Failed binding to 0.0.0.0, port 21: Address already in use
i1.optiumbg.net - Check the ServerType directive to ensure you are configured correctly.

in /var/log/proftpd-mod_mysql.log

Code:

May 28 23:23:09 mod_sql/4.2.1[8819]: using SQLBackend 'mysql'
May 28 23:23:09 mod_sql/4.2.1[8819]: backend module 'mod_sql_mysql/4.05'
May 28 23:23:09 mod_sql/4.2.1[8819]: backend api    'mod_sql_api_v2'
May 28 23:23:09 mod_sql/4.2.1[8819]: >>> sql_sess_init
May 28 23:23:09 mod_sql/4.2.1[8819]: entering     mysql cmd_defineconnection
May 28 23:23:09 mod_sql/4.2.1[8819]:  name: 'default'
May 28 23:23:09 mod_sql/4.2.1[8819]:  user: 'vftp'
May 28 23:23:09 mod_sql/4.2.1[8819]:  host: 'localhost'
May 28 23:23:09 mod_sql/4.2.1[8819]:    db: 'ispcp'
May 28 23:23:09 mod_sql/4.2.1[8819]:  port: '3306'
May 28 23:23:09 mod_sql/4.2.1[8819]:   ttl: '0'
May 28 23:23:09 mod_sql/4.2.1[8819]: exiting     mysql cmd_defineconnection
May 28 23:23:09 mod_sql/4.2.1[8819]: entering     mysql cmd_open
May 28 23:23:09 mod_sql/4.2.1[8819]: connection 'default' opened
May 28 23:23:09 mod_sql/4.2.1[8819]: connection 'default' count is now 1
May 28 23:23:09 mod_sql/4.2.1[8819]: exiting     mysql cmd_open
May 28 23:23:09 mod_sql/4.2.1[8819]: backend successfully connected.
May 28 23:23:09 mod_sql/4.2.1[8819]: mod_sql engine     : on
May 28 23:23:09 mod_sql/4.2.1[8819]: negative_cache     : off
May 28 23:23:09 mod_sql/4.2.1[8819]: authenticate       : users groups userset groupset
May 28 23:23:09 mod_sql/4.2.1[8819]: usertable          : ftp_users
May 28 23:23:09 mod_sql/4.2.1[8819]: userid field       : userid
May 28 23:23:09 mod_sql/4.2.1[8819]: password field     : passwd
May 28 23:23:09 mod_sql/4.2.1[8819]: uid field          : uid
May 28 23:23:09 mod_sql/4.2.1[8819]: gid field          : gid
May 28 23:23:09 mod_sql/4.2.1[8819]: homedir field      : homedir
May 28 23:23:09 mod_sql/4.2.1[8819]: shell field        : shell
May 28 23:23:09 mod_sql/4.2.1[8819]: homedirondemand    : false
May 28 23:23:09 mod_sql/4.2.1[8819]: group table        : ftp_group
May 28 23:23:09 mod_sql/4.2.1[8819]: groupname field    : groupname
May 28 23:23:09 mod_sql/4.2.1[8819]: grp gid field      : gid
May 28 23:23:09 mod_sql/4.2.1[8819]: grp members field  : members
May 28 23:23:09 mod_sql/4.2.1[8819]: SQLMinUserUID      : 2000
May 28 23:23:09 mod_sql/4.2.1[8819]: SQLMinUserGID      : 2000
May 28 23:23:09 mod_sql/4.2.1[8819]: SQLDefaultUID      : 65533
May 28 23:23:09 mod_sql/4.2.1[8819]: SQLDefaultGID      : 65533
May 28 23:23:09 mod_sql/4.2.1[8819]: <<< sql_sess_init
May 28 23:23:09 mod_sql/4.2.1[8819]: >>> cmd_endpwent
May 28 23:23:09 mod_sql/4.2.1[8819]: <<< cmd_endpwent
May 28 23:23:09 mod_sql/4.2.1[8819]: >>> cmd_endgrent
May 28 23:23:09 mod_sql/4.2.1[8819]: <<< cmd_endgrent
May 28 23:23:09 mod_sql/4.2.1[8819]: >>> cmd_getgroups
May 28 23:23:09 mod_sql/4.2.1[8819]: entering     mysql cmd_escapestring
May 28 23:23:09 mod_sql/4.2.1[8819]: exiting     mysql cmd_escapestring
May 28 23:23:09 mod_sql/4.2.1[8819]: cache miss for user 'amilo@optiumbg.net'
May 28 23:23:09 mod_sql/4.2.1[8819]: : entering     mysql cmd_select
May 28 23:23:09 mod_sql/4.2.1[8819]: entering     mysql cmd_open
May 28 23:23:09 mod_sql/4.2.1[8819]: connection 'default' count is now 2
May 28 23:23:09 mod_sql/4.2.1[8819]: exiting     mysql cmd_open
May 28 23:23:09 mod_sql/4.2.1[8819]: query "SELECT userid, passwd, uid, gid, homedir, shell FROM ftp_users WHERE (userid='amilo@optiumbg.net') LIMIT 1"
May 28 23:23:09 mod_sql/4.2.1[8819]: entering     mysql cmd_close
May 28 23:23:09 mod_sql/4.2.1[8819]: connection 'default' count is now 1
May 28 23:23:09 mod_sql/4.2.1[8819]: exiting     mysql cmd_close
May 28 23:23:09 mod_sql/4.2.1[8819]: exiting     mysql cmd_select
May 28 23:23:09 mod_sql/4.2.1[8819]: <<< cmd_getgroups
May 28 23:23:09 mod_sql/4.2.1[8819]: >>> sql_pre_pass
May 28 23:23:09 mod_sql/4.2.1[8819]: >>> cmd_getgroups
May 28 23:23:09 mod_sql/4.2.1[8819]: entering     mysql cmd_escapestring
May 28 23:23:09 mod_sql/4.2.1[8819]: exiting     mysql cmd_escapestring
May 28 23:23:09 mod_sql/4.2.1[8819]: cache miss for user 'amilo@optiumbg.net'
May 28 23:23:09 mod_sql/4.2.1[8819]: : entering     mysql cmd_select
May 28 23:23:09 mod_sql/4.2.1[8819]: entering     mysql cmd_open
May 28 23:23:09 mod_sql/4.2.1[8819]: connection 'default' count is now 2
May 28 23:23:09 mod_sql/4.2.1[8819]: exiting     mysql cmd_open
May 28 23:23:09 mod_sql/4.2.1[8819]: query "SELECT userid, passwd, uid, gid, homedir, shell FROM ftp_users WHERE (userid='amilo@optiumbg.net') LIMIT 1"
May 28 23:23:09 mod_sql/4.2.1[8819]: entering     mysql cmd_close
May 28 23:23:09 mod_sql/4.2.1[8819]: connection 'default' count is now 1
May 28 23:23:09 mod_sql/4.2.1[8819]: exiting     mysql cmd_close
May 28 23:23:09 mod_sql/4.2.1[8819]: exiting     mysql cmd_select
May 28 23:23:09 mod_sql/4.2.1[8819]: <<< cmd_getgroups
May 28 23:23:09 mod_sql/4.2.1[8819]: <<< sql_pre_pass
May 28 23:23:09 mod_sql/4.2.1[8819]: >>> cmd_endpwent
May 28 23:23:09 mod_sql/4.2.1[8819]: <<< cmd_endpwent
May 28 23:23:09 mod_sql/4.2.1[8819]: >>> cmd_endgrent
May 28 23:23:09 mod_sql/4.2.1[8819]: <<< cmd_endgrent
May 28 23:23:09 mod_sql/4.2.1[8819]: >>> cmd_getpwnam
May 28 23:23:09 mod_sql/4.2.1[8819]: entering     mysql cmd_escapestring
May 28 23:23:09 mod_sql/4.2.1[8819]: exiting     mysql cmd_escapestring
May 28 23:23:09 mod_sql/4.2.1[8819]: cache miss for user 'amilo@optiumbg.net'
May 28 23:23:09 mod_sql/4.2.1[8819]: : entering     mysql cmd_select
May 28 23:23:09 mod_sql/4.2.1[8819]: entering     mysql cmd_open
May 28 23:23:09 mod_sql/4.2.1[8819]: connection 'default' count is now 2
May 28 23:23:09 mod_sql/4.2.1[8819]: exiting     mysql cmd_open
May 28 23:23:09 mod_sql/4.2.1[8819]: query "SELECT userid, passwd, uid, gid, homedir, shell FROM ftp_users WHERE (userid='amilo@optiumbg.net') LIMIT 1"
May 28 23:23:09 mod_sql/4.2.1[8819]: entering     mysql cmd_close
May 28 23:23:09 mod_sql/4.2.1[8819]: connection 'default' count is now 1
May 28 23:23:09 mod_sql/4.2.1[8819]: exiting     mysql cmd_close
May 28 23:23:09 mod_sql/4.2.1[8819]: exiting     mysql cmd_select
May 28 23:23:09 mod_sql/4.2.1[8819]: <<< cmd_getpwnam
May 28 23:23:14 mod_sql/4.2.1[8819]: >>> cmd_endpwent
May 28 23:23:14 mod_sql/4.2.1[8819]: <<< cmd_endpwent
May 28 23:23:14 mod_sql/4.2.1[8819]: >>> cmd_endgrent
May 28 23:23:14 mod_sql/4.2.1[8819]: <<< cmd_endgrent
May 28 23:23:14 mod_sql/4.2.1[8819]: >>> cmd_getgroups
May 28 23:23:14 mod_sql/4.2.1[8819]: entering     mysql cmd_escapestring
May 28 23:23:14 mod_sql/4.2.1[8819]: exiting     mysql cmd_escapestring
May 28 23:23:14 mod_sql/4.2.1[8819]: cache miss for user 'amilo@optiumbg.net'
May 28 23:23:14 mod_sql/4.2.1[8819]: : entering     mysql cmd_select
May 28 23:23:14 mod_sql/4.2.1[8819]: entering     mysql cmd_open
May 28 23:23:14 mod_sql/4.2.1[8819]: connection 'default' count is now 2
May 28 23:23:14 mod_sql/4.2.1[8819]: exiting     mysql cmd_open
May 28 23:23:14 mod_sql/4.2.1[8819]: query "SELECT userid, passwd, uid, gid, homedir, shell FROM ftp_users WHERE (userid='amilo@optiumbg.net') LIMIT 1"
May 28 23:23:14 mod_sql/4.2.1[8819]: entering     mysql cmd_close
May 28 23:23:14 mod_sql/4.2.1[8819]: connection 'default' count is now 1
May 28 23:23:14 mod_sql/4.2.1[8819]: exiting     mysql cmd_close
May 28 23:23:14 mod_sql/4.2.1[8819]: exiting     mysql cmd_select
May 28 23:23:14 mod_sql/4.2.1[8819]: <<< cmd_getgroups
May 28 23:23:14 mod_sql/4.2.1[8819]: >>> sql_pre_pass
May 28 23:23:14 mod_sql/4.2.1[8819]: >>> cmd_getgroups
May 28 23:23:14 mod_sql/4.2.1[8819]: entering     mysql cmd_escapestring
May 28 23:23:14 mod_sql/4.2.1[8819]: exiting     mysql cmd_escapestring
May 28 23:23:14 mod_sql/4.2.1[8819]: cache miss for user 'amilo@optiumbg.net'
May 28 23:23:14 mod_sql/4.2.1[8819]: : entering     mysql cmd_select
May 28 23:23:14 mod_sql/4.2.1[8819]: entering     mysql cmd_open
May 28 23:23:14 mod_sql/4.2.1[8819]: connection 'default' count is now 2
May 28 23:23:14 mod_sql/4.2.1[8819]: exiting     mysql cmd_open
May 28 23:23:14 mod_sql/4.2.1[8819]: query "SELECT userid, passwd, uid, gid, homedir, shell FROM ftp_users WHERE (userid='amilo@optiumbg.net') LIMIT 1"
May 28 23:23:14 mod_sql/4.2.1[8819]: entering     mysql cmd_close
May 28 23:23:14 mod_sql/4.2.1[8819]: connection 'default' count is now 1
May 28 23:23:14 mod_sql/4.2.1[8819]: exiting     mysql cmd_close
May 28 23:23:14 mod_sql/4.2.1[8819]: exiting     mysql cmd_select
May 28 23:23:14 mod_sql/4.2.1[8819]: <<< cmd_getgroups
May 28 23:23:14 mod_sql/4.2.1[8819]: <<< sql_pre_pass
May 28 23:23:14 mod_sql/4.2.1[8819]: >>> cmd_endpwent
May 28 23:23:14 mod_sql/4.2.1[8819]: <<< cmd_endpwent
May 28 23:23:14 mod_sql/4.2.1[8819]: >>> cmd_endgrent
May 28 23:23:14 mod_sql/4.2.1[8819]: <<< cmd_endgrent
May 28 23:23:14 mod_sql/4.2.1[8819]: >>> cmd_getpwnam
May 28 23:23:14 mod_sql/4.2.1[8819]: entering     mysql cmd_escapestring
May 28 23:23:14 mod_sql/4.2.1[8819]: exiting     mysql cmd_escapestring
May 28 23:23:14 mod_sql/4.2.1[8819]: cache miss for user 'amilo@optiumbg.net'
May 28 23:23:14 mod_sql/4.2.1[8819]: : entering     mysql cmd_select
May 28 23:23:14 mod_sql/4.2.1[8819]: entering     mysql cmd_open
May 28 23:23:14 mod_sql/4.2.1[8819]: connection 'default' count is now 2
May 28 23:23:14 mod_sql/4.2.1[8819]: exiting     mysql cmd_open
May 28 23:23:14 mod_sql/4.2.1[8819]: query "SELECT userid, passwd, uid, gid, homedir, shell FROM ftp_users WHERE (userid='amilo@optiumbg.net') LIMIT 1"
May 28 23:23:14 mod_sql/4.2.1[8819]: entering     mysql cmd_close
May 28 23:23:14 mod_sql/4.2.1[8819]: connection 'default' count is now 1
May 28 23:23:14 mod_sql/4.2.1[8819]: exiting     mysql cmd_close
May 28 23:23:14 mod_sql/4.2.1[8819]: exiting     mysql cmd_select
May 28 23:23:14 mod_sql/4.2.1[8819]: <<< cmd_getpwnam
May 28 23:23:15 mod_sql/4.2.1[8819]: entering     mysql cmd_exit
May 28 23:23:15 mod_sql/4.2.1[8819]: entering     mysql cmd_close
May 28 23:23:15 mod_sql/4.2.1[8819]: connection 'default' closed
May 28 23:23:15 mod_sql/4.2.1[8819]: connection 'default' count is now 0
May 28 23:23:15 mod_sql/4.2.1[8819]: exiting     mysql cmd_close
May 28 23:23:15 mod_sql/4.2.1[8819]: exiting     mysql cmd_exit