Current time: 11-25-2024, 10:37 PM Hello There, Guest! (LoginRegister)


Post Reply 
Proftp error in the sql db
Author Message
OKButton Offline
Newbie
*

Posts: 9
Joined: Apr 2007
Reputation: 0
Post: #1
Proftp error in the sql db
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
07-23-2009 08:09 AM
Visit this user's website Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #2
RE: Proftp error in the sql db
create the folder /etc/proftpd/ispcp/ (ispcp in /etc/proftpd).
This should solve your problem.

Cheers J
07-23-2009 08:15 PM
Visit this user's website Find all posts by this user Quote this message in a reply
OKButton Offline
Newbie
*

Posts: 9
Joined: Apr 2007
Reputation: 0
Post: #3
RE: Proftp error in the sql db
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.
(This post was last modified: 07-24-2009 06:31 AM by OKButton.)
07-24-2009 06:01 AM
Visit this user's website Find all posts by this user Quote this message in a reply
OKButton Offline
Newbie
*

Posts: 9
Joined: Apr 2007
Reputation: 0
Post: #4
RE: Proftp error in the sql db
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?
07-24-2009 09:32 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


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