+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Update/Upgrade (/forum-44.html)
+--- Thread: Proftp error in the sql db (/thread-7287.html)
Proftp error in the sql db - OKButton - 07-23-2009 08:09 AM
I have a problem in my domain_aliases table which is as bellow:
ERROR: Can't open file |/etc/proftpd/ispcp/domain.com.conf| for writing: No such file or directory
I have found the files in the following directory:
/etc/ispcp/proftpd/working/
it looks to me that a config is looking in the wrong place.
All FTP is down not just to the aliases.
Can someone point me in the right direction?
Cheers OKButton
RE: Proftp error in the sql db - joximu - 07-23-2009 08:15 PM
create the folder /etc/proftpd/ispcp/ (ispcp in /etc/proftpd).
This should solve your problem.
Cheers J
RE: Proftp error in the sql db - OKButton - 07-24-2009 06:01 AM
The directory exists and has files for each domain alias in.
However when I attempt to login I get
421 Service not available, remote server has closed connection
FYI The server is behind a NAT firewall using an internal ip address on the box in the logs I see
Jul 23 21:22:22 alpha proftpd[19011]: alpha.example.org - no matching vhost found for 192.168.1.3#21, using DefaultServer 'alpha.example.org'
I've put proftpd in debug mode below is the log
Jul 23 21:28:51 alpha proftpd[18979]: alpha.example.org - scrubbing scoreboard
Jul 23 21:28:51 alpha proftpd[18979]: alpha.example.org - ROOT PRIVS at scoreboard.c:761
Jul 23 21:28:51 alpha proftpd[18979]: alpha.example.org - RELINQUISH PRIVS at scoreboard.c:763
Jul 23 21:28:51 alpha proftpd[18979]: alpha.example.org - ROOT PRIVS at scoreboard.c:791
Jul 23 21:28:51 alpha proftpd[18979]: alpha.example.org - RELINQUISH PRIVS at scoreboard.c:822
Jul 23 21:28:53 alpha proftpd[19050]: alpha.example.org - ROOT PRIVS at main.c:1070
Jul 23 21:28:53 alpha proftpd[19050]: alpha.example.org - RELINQUISH PRIVS at main.c:1074
Jul 23 21:28:53 alpha proftpd[19050]: alpha.example.org - no matching vhost found for 192.168.1.3#21, using DefaultServer 'alpha.example.org'
Jul 23 21:28:53 alpha proftpd[19050]: alpha.example.org (89.148.63.190[89.148.63.190]) - ROOT PRIVS at main.c:919
Jul 23 21:28:53 alpha proftpd[19050]: alpha.example.org (89.148.63.190[89.148.63.190]) - SETUP PRIVS at main.c:924
Jul 23 21:28:53 alpha proftpd[19050]: alpha.example.org (89.148.63.190[89.148.63.190]) - FTP session requested from unknown class
Jul 23 21:28:53 alpha proftpd[19050]: alpha.example.org (89.148.63.190[89.148.63.190]) - performing module session initializations
Jul 23 21:28:53 alpha proftpd[19050]: alpha.example.org (89.148.63.190[89.148.63.190]) - ROOT PRIVS at mod_delay.c:1102
Jul 23 21:28:53 alpha proftpd[19050]: alpha.example.org (89.148.63.190[89.148.63.190]) - RELINQUISH PRIVS at mod_delay.c:1104
Jul 23 21:28:53 alpha proftpd[19050]: alpha.example.org (89.148.63.190[89.148.63.190]) - FTP session closed.
RE: Proftp error in the sql db - OKButton - 07-24-2009 09:32 PM
Fixed, the problem was a bad password on the sql connect. Unfortunatly the error in the case appears to be "FTP session requested from unknown class".
I dont know how to crypt the password, so at the moment I have changed authentication to Plaintext and embedded the password in the proftpd.conf.
Can anyone tell me how to crypt the password?