Current time: 05-20-2024, 12:57 AM Hello There, Guest! (LoginRegister)


Post Reply 
FTP failure after upgrade
Author Message
Rusted Offline
Newbie
*

Posts: 9
Joined: Aug 2009
Reputation: 0
Post: #4
RE: FTP failure after upgrade
Fixed it after a lot of googling and trial and error. This seems to be the culprit and fix:
vftp user was hosed up after the upgrade (I think). After commenting out the root entry in the /etc/ftpusers file, I tested connections while in debug mode and received much more info. Still failed, but more info. I added the line:
SQLLogFile /var/log/proftpd/mod_sql.log
to the end of the # ispCP SQL Managment section of the proftpd.conf and received even more info on the authentication errors in the log file. Found a site that detailed how to configure ftp users in mysql and ran the following:

GRANT SELECT, INSERT, UPDATE, DELETE ON ispcp.* TO 'vftp'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT, INSERT, UPDATE, DELETE ON ispcp.* TO 'vftp'@'ipaddress' IDENTIFIED BY 'password';
GRANT SELECT, INSERT, UPDATE, DELETE ON ispcp.* TO 'vftp'@'localhost.localdomain' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

-where localhost is the computername and password is the actual vftp password

After restarting the proftpd service, all is good.
12-03-2009 07:38 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Messages In This Thread
FTP failure after upgrade - Rusted - 12-02-2009, 07:31 AM
RE: FTP failure after upgrade - kilburn - 12-02-2009, 08:20 PM
RE: FTP failure after upgrade - Rusted - 12-03-2009, 02:48 AM
RE: FTP failure after upgrade - Rusted - 12-03-2009 07:38 AM
RE: FTP failure after upgrade - kilburn - 12-03-2009, 06:19 PM
RE: FTP failure after upgrade - Rusted - 12-03-2009, 11:44 PM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)