Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #11  
Old 21st April 2009, 23:35
SirLancelot SirLancelot is offline
Member
 
Join Date: Jul 2007
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

/var/log/messages contains:-

Code:
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.
Reply With Quote
Sponsored Links
  #12  
Old 22nd April 2009, 14:30
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

Did you try both active and passive transfers in your FTP client?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #13  
Old 22nd April 2009, 19:41
SirLancelot SirLancelot is offline
Member
 
Join Date: Jul 2007
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko View Post
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.

Last edited by SirLancelot; 22nd April 2009 at 20:08.
Reply With Quote
  #14  
Old 23rd April 2009, 10:49
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,704
Thanks: 819
Thanked 5,321 Times in 4,174 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #15  
Old 23rd April 2009, 19:48
SirLancelot SirLancelot is offline
Member
 
Join Date: Jul 2007
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This is what is contained in mysql.log:-

Code:
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:-

Code:
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.

Last edited by SirLancelot; 23rd April 2009 at 20:28. Reason: Added phpmyadmin responce
Reply With Quote
  #16  
Old 24th April 2009, 15:37
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

Quote:
Originally Posted by SirLancelot View Post
I think we are getting somewhere as when I run the queries I am getting:-

Code:
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:
Code:
USE database;
(replace database with the database name).
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #17  
Old 24th April 2009, 17:12
SirLancelot SirLancelot is offline
Member
 
Join Date: Jul 2007
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko View Post
When you run the queries manually, you must first select the right database:
Code:
USE database;
(replace database with the database name).
Oops! My apologies.

OK I ran:-

Code:
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:-

Code:
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.
Reply With Quote
  #18  
Old 24th April 2009, 18:41
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,704
Thanks: 819
Thanked 5,321 Times in 4,174 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #19  
Old 24th April 2009, 19:07
SirLancelot SirLancelot is offline
Member
 
Join Date: Jul 2007
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

Last edited by SirLancelot; 24th April 2009 at 19:29.
Reply With Quote
  #20  
Old 24th April 2009, 20:09
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,704
Thanks: 819
Thanked 5,321 Times in 4,174 Posts
 
Default

Quote:
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%";
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Troubleshooting FTP bswinnerton Installation/Configuration 4 10th October 2008 19:34
proFTPd passive mode problems bisbell Server Operation 8 6th August 2008 21:12
Question about Virtual Hosting With Proftpd And MySQL (Incl. Quota) On Debian Etch ikkem HOWTO-Related Questions 30 26th February 2008 19:38
How to install BFD (Brute Force Detection) domino Tips/Tricks/Mods 9 31st March 2006 22:40
Website users? ctroyp General 25 6th January 2006 18:02


All times are GMT +2. The time now is 00:44.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.