Question about Virtual Hosting With Proftpd And MySQL (Incl. Quota) On Debian Etch

[ikkem]

@topdog could you please be more specific i am not that fast

[topdog]

I mean connect to the mysql server like i showed you in the previous post then run those sql queries to verify that the user name and password you are using to login in to the ftp server are correct in the database since i have seen that the ftpuser can connect to the db without a problem.

[ikkem]

@topdog Thanks for the code this is the output...

mysql> select userid,passwd,homedir from ftpuser;
+-----------+-------------------------------------------+----------------------+| userid | passwd | homedir |+-----------+-------------------------------------------+----------------------+| ikkem | *4D92122090AC8A37E694A3B068FC0B727F8BEF35 | /var/proftp/ikkem|

+-----------+-------------------------------------------+----------------------+2 rows in set (0.01 sec)

[topdog]

can ftpuser/ftpgroup write to /var/proftp/ikkem, further that that i cannot think of anything else

[ikkem]

again I must say I am not that fast please talk slowly
which commands should I use to check or make ftpuser/ftpgroup write to /var/proftp/ikkem...

thanks in advance

[topdog]

Originally Posted by ikkem

again I must say I am not that fast please talk slowly
which commands should I use to check or make ftpuser/ftpgroup write to /var/proftp/ikkem...

thanks in advance

ls -l /var/proftp
ls -l /var/

[ikkem]

@topdog Thanks for pointing me in the right direction

ls -l /var/proftp =drwxrwxr-x 2 ftpuser ftpgroup 4096 2008-02-21 05:55 proftp

ls -l /var/=drwxrwxr-x 2 ftpuser ftpgroup 4096 2008-02-21 05:55 proftp

thanks in advance....

[topdog]

Okay i think i know what the problem is i have just glanced through the howto, i think the system expects clear text passwords and your password in the db is encrypted. You need to change the password to cleartext then test.
http://www.howtoforge.com/proftpd_my...debian_etch_p3

remember to reload proftpd after you have made the change.

[ikkem]

thanks again topdog I have tried changing it to clear text but I still get the error message....

Status:	Connecting to 127.0.0.1:21...
Status:	Connection established, waiting for welcome message...

Status:	Connecting to myip:21...
Status:	Connection established, waiting for welcome message...
Error:	Could not connect to server
Error:	Could not connect to server

Thanks in advance....
ikkem

[topdog]

Isn't it a different error now as even the welcome message is not being displayed.