Proftp error in the sql db

[OKButton]

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

[joximu]

create the folder /etc/proftpd/ispcp/ (ispcp in /etc/proftpd).
This should solve your problem.

Cheers J

[OKButton]

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.

[OKButton]

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?