Centovacast needs second ip-address

T

theplayer

Verified User
Joined
Jan 26, 2009
Messages
69
I have a server with Debian 5 and DirectAdmin. For a customer i have install Centovacast wit ices-cc so other people can make an ftp connection to the server and upload there music files. I must configure a second port for ftp, because directadmin/proftpd uses port 21. So i have configured the .conf file from Centovacast to port 2121 and want to add this line to /etc/proftpd.conf file:

Include /etc/proftpd/centovacast.conf
Click to expand...

This is the file:

#
# CentovaCast Configuration for ProFTPd
# Copyright 2006-2007, Centova Technologies Inc.
#
# This will configure ProFTPd to listen on a particular IP address and/or port
# for FTP connections. When a connection is received, it will authenticate
# against your CentovaCast user database instead of your normal UNIX accounts.
#
# To install this file, copy it to the same directory as your proftpd.conf file.
# Then make the modifications noted below. Finally, modify your proftpd.conf
# file and add the following command at the top of the file:
#
# Include /path/to/centovacast.conf
#
# Then restart ProFTPd to make the changes take effect.
#


#
# Replace 192.168.0.10 below with the IP address on which CentovaCast's FTP
# server should listen. Be sure to choose an address that is NOT already in
# use by ProFTPd, otherwise ProFTPd will fail to start. (Alternately, you can
# re-use an IP address and specify a different port number below.)
#
<VirtualHost 212.115.192.78>

#
# Specify your MySQL connection details for your CentovaCast database below.
# This must match the settings in system/config.php.
#
SQLConnectInfo test_centova@localhost test_centova test_centova

#
# If you want to use a port other than 21, change it below.
#
Port 2121

#
# Do not modify anything below this line.
#

ServerName "CentovaCast FTP Service"
RequireValidShell off
DefaultRoot ~

SQLEngine on
SQLAuthenticate users userset
SQLAuthTypes crypt
SQLBackend mysql
#SQLLogFile /var/log/proftpd/sql.log

SQLUserInfo accounts,settings accounts.username accounts.password settings.ccui$
SQLUserWhereClause "status='enabled'"
</VirtualHost>
Click to expand...

But as soon as i place this code
include /etc/proftpd/centovacast.conf
Click to expand...
in the /etc/proftpd.conf file, proftp wil stops and i can't restart it.
I have read all the centovacast help files to solf this problem but can't find it.

Can anybody help me or knows the answher?
 
Last edited:
Im sure centovacast provides customer service with their licenses. They can help you set it up.
 
theplayer said:
But as soon as i place this code in the /etc/proftpd.conf file, proftp wil stops and i can't restart it.
I have read all the centovacast help files to solf this problem but can't find it.

Can anybody help me or knows the answher?
Click to expand...

Try restarting ProFTPD and check the log files:
Code: 
/etc/init.d/proftpd stop
/etc/init.d/proftpd start
tail -15 /var/log/messages
This should give you an idea of what is going on behind the scenes.
 
i get this:

theplayer:~# /etc/init.d/proftpd stop
Stopping ftp server: proftpd.
theplayer:~# /etc/init.d/proftpd start
Starting ftp server: proftpd - Fatal: unknown configuration directive 'SQLConnec
tInfo' on line 31 of '/etc/proftpd/centovacast.conf'
failed!
Click to expand...
 
You need to build/compile ProFTP on your own from source, enabling the mysql module
 
Last edited:
ok i now know the problem:

This indicates that you've tried to configure MySQL-based integration with ProFTPd, but your copy of ProFTPd has not been built with MySQL support.
Click to expand...

Can i safely rebuild proftpd with mysql support? if yes how?

Thnx all for your support!
 
if i do "proftpd -l | grep sql" i get nothing...

Is it possible to rebuild or recompile proftpd without losing any data etc. ?

Thanks for your great help!

Webcart said:
Check whether your ProFTPD is compiled with mod_sql module
Code: 
proftpd -l | grep sql
and recompile your ProFTPD if necessary.
You might be able to avoid recompiling ProFTPD and use dynamic mod_sql module instead if your ProFTPD was compiled with Dynamic Shared Objects support.
Click to expand...
 
theplayer said:
if i do "proftpd -l | grep sql" i get nothing...

Is it possible to rebuild or recompile proftpd without losing any data etc. ?

Thanks for your great help!
Click to expand...

Sure, rebuild should not overwrite any config files, however, to be on the safe side make sure to back up whole /etc directory before the rebuild.
 
hmmm searching and found this one:
(from this url: http://forums.gplhost.com/phpBB2/image-vp7793.html)

Edit /etc/proftpd/modules.conf

Enable mod_sql.c and mod_sql_mysql.c (in that order), disable mod_sql_postgres.c

Code:
# Install proftpd-mod-mysql or proftpd-mod-pgsql to use this
LoadModule mod_sql.c
# Install proftpd-mod-mysql to use this
LoadModule mod_sql_mysql.c
# mod_sql_postgres.c
Click to expand...

Do you think this wil fix my problem to? thats not to many work and souns easy, because i'm not a hero in configging servers... but till now i have everything running that i want ;-)
 
theplayer said:
hmmm searching and found this one:
(from this url: http://forums.gplhost.com/phpBB2/image-vp7793.html)
Do you think this wil fix my problem to? thats not to many work and souns easy, because i'm not a hero in configging servers... but till now i have everything running that i want ;-)
Click to expand...
Well, most probably it will not be enough. Check the link about Dynamic Shared Objects support I provided above for details ;)
 
nope thats not gonna work...

Is there also a sort of manual to rebuild proftpd with debian 5 and directadmin? i dont know where to begin. affraid to blow up the server :p
 
theplayer said:
Do you think this wil fix my problem to? thats not to many work and souns easy, because i'm not a hero in configging servers... but till now i have everything running that i want ;-)
Click to expand...

Actually, it shouldn't be too much work if you do it DA way :) which is customizing the build made by custombuild. It should look like this (THIS EXAMPLE IS NOT FULLY TESTED, but it should give you some idea):

Code: 
#### BACK UP, BACK UP, BACK UP
mkdir /tmp/PROFTPD
chmod 700 /tmp/PROFTPD
cd /tmp/PROFTPD
tar cvfz etc.tgz /etc
cp /etc/proftpd.* .
cp `which proftpd` .

#### Customize the build
cd /usr/local/directadmin/custombuild
mkdir -p custom/proftpd
cp -i configure/proftpd/configure.proftpd custom/proftpd/
perl -pi -e 's/(--with-modules=)/${1}mod_sql:/' custom/proftpd/configure.proftpd

# Go!
./build proftpd
 
Ok thnx!

So all my working accounts without sql will still work after i do this?

But i must add something like this to the lines, so it will be working?:

./configure --enable-dso --with-shared=mod_sql:mod_sql_mysql --with-includes=... --with-libraries=...

Webcart said:
CHeck this HOWTO Compiling proftpd
I wouldn't do it this way, but it should work for you.
Click to expand...
 
ok, i will try this one.... seems to be ok i think (because you said its not fully tested)

Webcart said:
Actually, it shouldn't be too much work if you do it DA way :) which is customizing the build made by custombuild. It should look like this (THIS EXAMPLE IS NOT FULLY TESTED, but it should give you some idea):

Code: 
#### BACK UP, BACK UP, BACK UP
mkdir /tmp/PROFTPD
chmod 700 /tmp/PROFTPD
cd /tmp/PROFTPD
tar cvfz etc.tgz /etc
cp /etc/proftpd.* .
cp `which proftpd` .

#### Customize the build
cd /usr/local/directadmin/custombuild
mkdir -p custom/proftpd
cp -i configure/proftpd/configure.proftpd custom/proftpd/
perl -pi -e 's/(--with-modules=)/${1}mod_sql:/' custom/proftpd/configure.proftpd

# Go!
./build proftpd
Click to expand...
 
theplayer said:
Ok thnx!
So all my working accounts without sql will still work after i do this?
Click to expand...

Actually, I am not sure your FTP will work after you enable mod_sql support, that depends on other config settings in your /etc/proftd.conf file.
But you won't get "unknown configuration directive" error.

theplayer said:
But i must add something like this to the lines, so it will be working?:

./configure --enable-dso --with-shared=mod_sql:mod_sql_mysql --with-includes=... --with-libraries=...
Click to expand...
If you compile from scratch, you might as well compile it statically. The whole idea of using DSO was avoiding complete rebuild. I guess it's a matter of preference.

In any event, I should be back to whatever I was doing :)

Good luck to you and keep us updated.
 
I have exaxtly following this code. but it looks like nothing changes, still get the same error...

What do i wrong?


Webcart said:
Actually, it shouldn't be too much work if you do it DA way :) which is customizing the build made by custombuild. It should look like this (THIS EXAMPLE IS NOT FULLY TESTED, but it should give you some idea):

Code: 
#### BACK UP, BACK UP, BACK UP
mkdir /tmp/PROFTPD
chmod 700 /tmp/PROFTPD
cd /tmp/PROFTPD
tar cvfz etc.tgz /etc
cp /etc/proftpd.* .
cp `which proftpd` .

#### Customize the build
cd /usr/local/directadmin/custombuild
mkdir -p custom/proftpd
cp -i configure/proftpd/configure.proftpd custom/proftpd/
perl -pi -e 's/(--with-modules=)/${1}mod_sql:/' custom/proftpd/configure.proftpd

# Go!
./build proftpd
Click to expand...
 
You must log in or register to reply here.
Back
Top