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