ftp password rejected

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.

 

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)

 

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.

 

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.

 

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

Is it possible that this could cause a problem?
I may be just grasping at straws here.

 

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.

 

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

 

yes, you are 100% right.

Is there any magic to get rid of prefix for ftp users ?

 

thank you twice till. I'll check it later.