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.