ftp password rejected

[SirLancelot]

/var/log/messages contains:-

Apr 21 22:15:26 test pure-ftpd: (?@localhost.localdomain) [INFO] New connection from localhost.localdomain
Apr 21 22:16:19 test pure-ftpd: (?@localhost.localdomain) [INFO] PAM_RHOST enabled. Getting the peer address
Apr 21 22:16:21 test pure-ftpd: (?@localhost.localdomain) [WARNING] Authentication failed for user [steve-ftp]

there is no /var/log/security or /var/log/pure-ftpd
I don't seem to have any ftp logs at all.

[falko]

Did you try both active and passive transfers in your FTP client?

[SirLancelot]

Originally Posted by falko

Did you try both active and passive transfers in your FTP client?

Yes, as mentioned in the first post.

Also I have tried passive from localhost with "-p" switch. I am not to familiar with command line ftp, so I am guessing that:-

"ftp localhost" will connect active

and

"ftp -p localhost" will connect passive

But which ever one I try still rejects the password.

[till]

Please enaböe logging for mysql in the my.cnf file and then check which mysql queries get executed on ftp login and try these queries in phpmyadmin to see if they work.

[SirLancelot]

This is what is contained in mysql.log:-

090423 19:35:40	     72 Connect     ispconfig@localhost on dbispconfig
		     72 Query       set autocommit=0
		     72 Query       SELECT password FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="steve-ftp"
		     72 Query       SELECT uid FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="steve-ftp"
		     72 Query       SELECT gid FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="steve-ftp"
		     72 Query       SELECT dir FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="steve-ftp"
		     72 Query       COMMIT
		     72 Quit       
090423 19:36:01	     73 Connect     ispconfig@localhost on 
		     73 Init DB     dbispconfig
		     73 Query       SELECT updated, config FROM server WHERE server_id = 1
		     73 Init DB     dbispconfig
		     73 Query       SELECT count(server_id) as number from sys_datalog WHERE datalog_id > 48 AND (server_id = 1 OR server_id = 0)
		     73 Quit       
090423 19:36:09	     74 Connect     ispconfig@localhost on dbispconfig
		     74 Query       set autocommit=0
		     74 Query       SELECT password FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="steve-ftp"
		     74 Query       SELECT uid FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="steve-ftp"
		     74 Query       SELECT gid FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="steve-ftp"
		     74 Query       SELECT dir FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="steve-ftp"
		     74 Query       COMMIT

I think we are getting somewhere as when I run the queries I am getting:-

Error

SQL query: Documentation

SELECT PASSWORD FROM ftp_user
WHERE active = 'y'
AND server_id = '1'
AND username = "steve-ftp"
LIMIT 0 , 30

MySQL said: Documentation
#1046 - No database selected

both attempts to connect were from the command line as localhost. the first attempt was in active mode and the second attempt was in passive mode. I'm not sure if I am reading it corretly but does it look by the log that both attempts apear to be in active mode? Also no database selected error?
I'm begining to wonder if there is an issue with running xen through hypervm for ISPconfig 3 as this is the 5'th ispconfig sever that I have built and the FTP issue is always the same.
Many thanks for any assitance with this as it has got me confused.

[falko]

Originally Posted by SirLancelot

I think we are getting somewhere as when I run the queries I am getting:-

Error

SQL query: Documentation

SELECT PASSWORD FROM ftp_user
WHERE active = 'y'
AND server_id = '1'
AND username = "steve-ftp"
LIMIT 0 , 30

MySQL said: Documentation
#1046 - No database selected

When you run the queries manually, you must first select the right database:

USE database;

(replace database with the database name).

[SirLancelot]

Originally Posted by falko

When you run the queries manually, you must first select the right database:

USE database;

(replace database with the database name).

Oops! My apologies.

OK I ran:-

USE dbispconfig; set autocommit=0; SELECT password FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="steve-ftp"; SELECT uid FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="steve-ftp"; SELECT gid FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="steve-ftp"; SELECT dir FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="steve-ftp"; COMMIT

This is the result:-

USE dbispconfig;# MySQL returned an empty result set (i.e. zero rows).
SET AUTOCOMMIT =0;# MySQL returned an empty result set (i.e. zero rows).
SELECT PASSWORD FROM ftp_user
WHERE active = 'y'
AND server_id = '1'
AND username = "steve-ftp";# Rows: 1
SELECT uid
FROM ftp_user
WHERE active = 'y'
AND server_id = '1'
AND username = "steve-ftp";# Rows: 1
SELECT gid
FROM ftp_user
WHERE active = 'y'
AND server_id = '1'
AND username = "steve-ftp";# Rows: 1
SELECT dir
FROM ftp_user
WHERE active = 'y'
AND server_id = '1'
AND username = "steve-ftp";# Rows: 1
COMMIT # MySQL returned an empty result set (i.e. zero rows).

Mysql seems to think the database is empty?
But the user and password are there in the table ftp_user.

[till]

And you are really sure that the username is "steve-ftp" and not something like "defaultsteve-ftp" or so? There is a user prefix prepended by default, please check the ftp username that is displayed in the ftp user list in ispconfig. Also make sure that the ftp user is active.

[SirLancelot]

Yes the user steve-ftp is correct.

After installing ISPConfig 3 I logged in as admin and created a client "steve".
I then logged in as steve and created a web site for steve. Then created an ftp account for this website selecting client "steve" plus my user defined text "-ftp" so creating "steve-ftp"

Is this the correct way to do it?
Thanks

I think I should add that in order to use debian 5 I upgraded the basic Hypervm ostemplate provided by hypevm from deb 4 to deb 5. If you have looked back through this thread you will notice that this template was missing the ftp client that I believe comes with a basic install of Debian. (I had to apt-get install ftp). I am now wondering if there are any other packages that are required that the hypervm ostemplate is missing.

[till]

Is this the correct way to do it?

Yes, this is fine.

may you plese execute the following sql command and post the output:

select * from ftp_user where username like "%steve%";