View Single Post
  #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