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
  #21  
Old 24th April 2009, 21:38
SirLancelot SirLancelot is offline
Member
 
Join Date: Jul 2007
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Now I think we are getting somwhere.
mysql will not let me log in:-

Code:
test:~# mysql
produces:-

Code:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
I've also tried:-

mysql -u root
mysql -u admin
mysql -u steve

mysql -u root -p mypassword
mysql -u admin -p mypassword
mysql -u steve -p mypassword

they all produce:-

Code:
ERROR 1045 (28000): Access denied for user
though i can log in with phpmyadmin and if I select table "ftp_user" steve_ftp is there.
It is strange that I am unable to connect from the command line as this is the 5'th time that I have built an ISPConfig 3 server and the problem is always the same.
Reply With Quote
Sponsored Links
  #22  
Old 24th April 2009, 21:47
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,651 Times in 4,461 Posts
Default

Please note the difference, you said that steve_ftp is there but you tried to login with steve-ftp with the FTP client (underscore not -). Please try to login with steve_ftp with your ftp client now.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #23  
Old 24th April 2009, 21:53
SirLancelot SirLancelot is offline
Member
 
Join Date: Jul 2007
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sorry that was a typo the user that is in the table "ftp_user" is steve-ftp.

And I am able to log into mysql from the command line with:-

Code:
mysql -u root -p
I wasnt thinking earlier.

The output of:-

Code:
select * from ftp_user where username like "%steve%";
does confirm the ftp user is correct:-

Code:
+-------------+------------+-------------+---------------+----------------+----------------+-----------+------------------+-----------+------------------------------------+------------+--------+------+---------+-------------------------------+-------------+----------+----------+--------------+--------------+
| ftp_user_id | sys_userid | sys_groupid | sys_perm_user | sys_perm_group | sys_perm_other | server_id | parent_domain_id | username  | password                           | quota_size | active | uid  | gid     | dir                           | quota_files | ul_ratio | dl_ratio | ul_bandwidth | dl_bandwidth |
+-------------+------------+-------------+---------------+----------------+----------------+-----------+------------------+-----------+------------------------------------+------------+--------+------+---------+-------------------------------+-------------+----------+----------+--------------+--------------+
|           2 |          2 |           2 | riud          | riud           |                |         1 |                1 | steve-ftp | $1$]x[ZlDk{$iqfI7NbkFBsUBhnrPcDLr1 |         -1 | y      | web1 | client1 | /var/www/clients/client1/web1 |          -1 |       -1 |       -1 |           -1 |           -1 |
+-------------+------------+-------------+---------------+----------------+----------------+-----------+------------------+-----------+------------------------------------+------------+--------+------+---------+-------------------------------+-------------+----------+----------+--------------+--------------+
1 row in set (1.02 sec)

Last edited by SirLancelot; 25th April 2009 at 00:56.
Reply With Quote
  #24  
Old 25th April 2009, 12:44
SirLancelot SirLancelot is offline
Member
 
Join Date: Jul 2007
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am now thinking that there is something strange with how the password is saved, because if I change the password for "steve-ftp" in ISPConfig to something like "123456" then issue:-

Code:
select * from ftp_user where username like "%steve%";
the follwing is displayed:-

Code:
+-------------+------------+-------------+---------------+----------------+----------------+-----------+------------------+-----------+------------------------------------+------------+--------+------+---------+-------------------------------+-------------+----------+----------+--------------+--------------+
| ftp_user_id | sys_userid | sys_groupid | sys_perm_user | sys_perm_group | sys_perm_other | server_id | parent_domain_id | username  | password                           | quota_size | active | uid  | gid     | dir                           | quota_files | ul_ratio | dl_ratio | ul_bandwidth | dl_bandwidth |
+-------------+------------+-------------+---------------+----------------+----------------+-----------+------------------+-----------+------------------------------------+------------+--------+------+---------+-------------------------------+-------------+----------+----------+--------------+--------------+
|           2 |          2 |           2 | riud          | riud           |                |         1 |                1 | steve-ftp | $1$iA@S_fYP$oFSVwi/B1PMg1hfUxJs4G0 |         -1 | y      | web1 | client1 | /var/www/clients/client1/web1 |          -1 |       -1 |       -1 |           -1 |           -1 |
+-------------+------------+-------------+---------------+----------------+----------------+-----------+------------------+-----------+------------------------------------+------------+--------+------+---------+-------------------------------+-------------+----------+----------+--------------+--------------+
1 row in set (0.00 sec)
now if I again change the password in ISPConfig to something else, then change it back to "123456" and again issue at the command prompt:-

Code:
select * from ftp_user where username like "%steve%";
The following is generated:-

Code:
+-------------+------------+-------------+---------------+----------------+----------------+-----------+------------------+-----------+------------------------------------+------------+--------+------+---------+-------------------------------+-------------+----------+----------+--------------+--------------+
| ftp_user_id | sys_userid | sys_groupid | sys_perm_user | sys_perm_group | sys_perm_other | server_id | parent_domain_id | username  | password                           | quota_size | active | uid  | gid     | dir                           | quota_files | ul_ratio | dl_ratio | ul_bandwidth | dl_bandwidth |
+-------------+------------+-------------+---------------+----------------+----------------+-----------+------------------+-----------+------------------------------------+------------+--------+------+---------+-------------------------------+-------------+----------+----------+--------------+--------------+
|           2 |          2 |           2 | riud          | riud           |                |         1 |                1 | steve-ftp | $1$LJ{jwQ]L$qR3hTenZw0ueRN7MDhjkO0 |         -1 | y      | web1 | client1 | /var/www/clients/client1/web1 |          -1 |       -1 |       -1 |           -1 |           -1 |
+-------------+------------+-------------+---------------+----------------+----------------+-----------+------------------+-----------+------------------------------------+------------+--------+------+---------+-------------------------------+-------------+----------+----------+--------------+--------------+
1 row in set (0.00 sec)
As can be seen the encrypted password is now different even though I set it to "123456" in both cases.
Reply With Quote
  #25  
Old 25th April 2009, 12:47
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,651 Times in 4,461 Posts
Default

Thats all fine. This is named a salted password, it is always different so it can not be attacked with wordbook attacks. Al Linux passwords are saved as salted passwords for this reason.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #26  
Old 25th April 2009, 12:51
SirLancelot SirLancelot is offline
Member
 
Join Date: Jul 2007
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by till View Post
Thats all fine. This is named a salted password, it is always different so it can not be attacked with wordbook attacks. Al Linux passwords are saved as salted passwords for this reason.
OK thanks, at least I know the ftp account and password are being stored correctly. I just cannot seem to get to the bottom of the login problem.
Reply With Quote
  #27  
Old 28th April 2009, 19:10
SirLancelot SirLancelot is offline
Member
 
Join Date: Jul 2007
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'm pretty convinced that this is an issue with the original debian template that I am using, as it does not seem to matter how many times I try to rebuild my ISPConfig 3 server the error with ftp password rejected is always the same.
I believe that Hypervm uses a jailtime xen domu image to build xen domu servers. I had a look at the image details listed at:-

http://jailtime.org/download:debian:v4.0?s=debian+4

and it states that:-

Quote:
tls has been disabled (/lib/tls > /lib/tls.disabled)
Is it possible that this could cause a problem?
I may be just grasping at straws here.
Reply With Quote
  #28  
Old 6th May 2009, 14:11
SirLancelot SirLancelot is offline
Member
 
Join Date: Jul 2007
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

SOLVED

Though I used the brute force method.
If you use HyperVM to administrate your Xen domu's there is an issue with the osteplate (at least for Debian) this also goes for the Debian image from jailtime.org. (though I am not sure about other distros), that prevents ftp from working when ISPConfig 3 is installed.
In order to get ISPConfig 3 working as a domu using HyperVM I had to install a xen dom0 on an old server, then create a basic debian domu with ssh installed. Then convert the domu image to a formate that HyperVM uses (debian-5.0-i386-minimal.tar.gz) then move this to the xen ostemplates of the HyperVM server. I was then able to use this template for building the ISPConfig 3 server, and all worked perfectly.

Many thanks to all involved while trying to fix this.
Reply With Quote
  #29  
Old 15th May 2013, 15:46
TomasZu TomasZu is offline
Junior Member
 
Join Date: Apr 2013
Posts: 5
Thanks: 2
Thanked 0 Times in 0 Posts
Default

EDIT: noobish me, slipped under username prefix...

Last edited by TomasZu; 15th May 2013 at 16:08.
Reply With Quote
  #30  
Old 15th May 2013, 16:13
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,651 Times in 4,461 Posts
 
Default

If you use ubuntu 12.04 LTS then its very unlikely thats its the same problem as the problem is about a issue in a debian image from jailtime.org and not a ispconfig specific problem.

The most likely reason for rejected passwords is that you tried to use a wrong ftp username, e.g. using it without prefix. Take a look at the ftp user list in ispconfig, you have to use the full ftp username incl. prefix as it is displayed there.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
TomasZu (15th May 2013)
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 20:34
proFTPd passive mode problems bisbell Server Operation 8 6th August 2008 22:12
Question about Virtual Hosting With Proftpd And MySQL (Incl. Quota) On Debian Etch ikkem HOWTO-Related Questions 30 26th February 2008 20:38
How to install BFD (Brute Force Detection) domino Tips/Tricks/Mods 9 31st March 2006 23:40
Website users? ctroyp General 25 6th January 2006 19:02


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


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