Threaded Mode | Linear Mode

Arturo2 · 04-28-2009 01:28 AM

I upgrade from 1.00 (stable) to the new release that fix the problems on debian lenny.

And proftpd don't start, it say:

ns1:/etc/apache2/sites-available# /etc/init.d/proftpd restart
Stopping ftp server: proftpd.
Starting ftp server: proftpd - warning: the DisplayFirstChdir directive is deprecated and will be removed in a future release. Please use the DisplayChdir directive.
- Fatal: unknown configuration directive 'SQLAuthTypes' on line 164 of '/etc/proftpd/proftpd.conf'
failed!

my /etc/proftpd/modules.conf config:

Code:

#

# This file is used to manage DSO modules and features.

#

# This is the directory where DSO modules reside

ModulePath /usr/lib/proftpd

# Allow only user root to load and unload modules, but allow everyone

# to see which modules have been loaded

ModuleControlsACLs insmod,rmmod allow user root

ModuleControlsACLs lsmod allow user *

LoadModule mod_ctrls_admin.c

LoadModule mod_tls.c

# Install proftpd-mod-mysql or proftpd-mod-pgsql to use this

LoadModule mod_sql.c

# Install proftpd-mod-ldap to use this

LoadModule mod_ldap.c

# 

# 'SQLBackend mysql' or 'SQLBackend postgres' directives are required

# to have SQL authorization working. You can also comment out the

# unused module here, in alternative.

#

# Install proftpd-mod-mysql to use this

LoadModule mod_sql_mysql.c

# Install proftpd-mod-pgsql to use this

LoadModule mod_sql_postgres.c

LoadModule mod_radius.c

LoadModule mod_quotatab.c

LoadModule mod_quotatab_file.c

# Install proftpd-mod-ldap to use this

LoadModule mod_quotatab_ldap.c

# Install proftpd-mod-pgsql or proftpd-mod-mysql to use this

LoadModule mod_quotatab_sql.c

LoadModule mod_quotatab_radius.c

LoadModule mod_wrap.c

LoadModule mod_rewrite.c

LoadModule mod_load.c

LoadModule mod_ban.c

LoadModule mod_wrap2.c

LoadModule mod_wrap2_file.c

# Install proftpd-mod-pgsql or proftpd-mod-mysql to use this

LoadModule mod_wrap2_sql.c

LoadModule mod_dynmasq.c

# keep this module the last one

LoadModule mod_ifsession.c

& my /etc/proftpd/proftpd.conf config:

Code:

#

# ispCP �^� (OMEGA) a Virtual Hosting Control System

#

# @copyright    2001-2006 by moleSoftware GmbH

# @copyright    2006-2008 by ispCP | http://isp-control.net

# @version              SVN: $Id$

# @link                 http://isp-control.net

# @author               ispCP Team

#

# @license

#   This program is free software; you can redistribute it and/or modify it under

#   the terms of the MPL General Public License as published by the Free Software

#   Foundation; either version 1.1 of the License, or (at your option) any later

#   version.

#   You should have received a copy of the MPL Mozilla Public License along with

#   this program; if not, write to the Open Source Initiative (OSI)

#   http://opensource.org | osi@opensource.org

#

################################################################################​

# Includes DSO modules (this is mandatory in proftpd 1.3)

#Include /etc/proftpd/modules.conf

# Set off to disable IPv6 support which is annoying on IPv4 only boxes.

UseIPv6                    off

ServerName                 "MYDOMAIN"

ServerType                 standalone

DeferWelcome               off

MultilineRFC2228           on

DefaultServer              on

ShowSymlinks               on

AllowOverwrite             on

UseReverseDNS              off

#

# ispCP �^� (OMEGA) a Virtual Hosting Control System

#

# @copyright    2001-2006 by moleSoftware GmbH

# @copyright    2006-2008 by ispCP | http://isp-control.net

# @version              SVN: $Id$

# @link                 http://isp-control.net

# @author               ispCP Team

#

# @license

#   This program is free software; you can redistribute it and/or modify it under

#   the terms of the MPL General Public License as published by the Free Software

#   Foundation; either version 1.1 of the License, or (at your option) any later

#   version.

#   You should have received a copy of the MPL Mozilla Public License along with

#   this program; if not, write to the Open Source Initiative (OSI)

#   http://opensource.org | osi@opensource.org

#

################################################################################​

# Includes DSO modules (this is mandatory in proftpd 1.3)

#Include /etc/proftpd/modules.conf

# Set off to disable IPv6 support which is annoying on IPv4 only boxes.

UseIPv6                    off

ServerName                 "liveyeah.com"

ServerType                 standalone

DeferWelcome               off

MultilineRFC2228           on

DefaultServer              on

ShowSymlinks               on

AllowOverwrite             on

UseReverseDNS              off

# To prevent DoS attacks, set the maximum number of child processes

# to 30.  If you need to allow more than 30 concurrent connections

# at once, simply increase this value.  Note that this ONLY works

# in standalone mode, in inetd mode you should use an inetd server

# that allows you to limit maximum number of processes per service

# (such as xinetd)

MaxInstances               30

# Set the user and group that the server normally runs at.

User                       nobody

Group                      nogroup

# Normally, we want files to be overwriteable.

<Directory /*>

  # Umask 022 is a good standard umask to prevent new files and dirs

  # (second parm) from being group and world writable.

  Umask                    022  022

  # Normally, we want files to be overwriteable.

  AllowOverwrite           on

  HideNoAccess             on

</Directory>

<Limit ALL>

  IgnoreHidden             on

</Limit>

# Be warned: use of this directive impacts CPU average load!

#

# Uncomment this if you like to see progress and transfer rate with ftpwho

# in downloads. That is not needed for uploads rates.

# UseSendFile               off

<Global>

  RootLogin                off

 TransferLog              /var/log/proftpd/xferlog

  ExtendedLog              /var/log/proftpd/ftp_traff.log read,write traff

  PathDenyFilter           "\.quota$"

</Global>

#

# SSL via TLS

# 

#<IfModule mod_tls.c>

#  TLSEngine                off                           # on for use of TLS

#  TLSLog                   /var/log/proftpd/ftp_ssl.log  # where to log to

#  TLSProtocol              SSLv23                        # SSLv23 or TLSv1

#  TLSOptions               NoCertRequest                 # either to request the certificate or not

#  TLSRSACertificateFile    /etc/proftpd/ssl.crt          # SSL certfile

#  TLSRSACertificateKeyFile /etc/proftpd/ssl.key          # SSL keyfile

#  TLSVerifyClient          off                           # client verification

#</IfModule>

#

# ISPCP Quota management;

#

<IfModule mod_quotatab.c>

  QuotaEngine              on

  QuotaShowQuotas          on

  QuotaDisplayUnits        Mb

  SQLNamedQuery            get-quota-limit SELECT "name, quota_type, per_session, limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_avail, files_in_av$

  SQLNamedQuery            get-quota-tally SELECT "name, quota_type, bytes_in_used, bytes_out_used, bytes_xfer_used, files_in_used, files_out_used, files_xf$

  SQLNamedQuery            update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_$

  SQLNamedQuery            insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" quotatallies

  QuotaLock                /var/run/proftpd/tally.lock

  QuotaLimitTable          sql:/get-quota-limit

QuotaLock                /var/run/proftpd/tally.lock

  QuotaLimitTable          sql:/get-quota-limit

  QuotaTallyTable          sql:/get-quota-tally/update-quota-tally/insert-quota-tally

</IfModule>

<IfModule mod_ratio.c>

  Ratios                   on

</IfModule>

# Delay engine reduces impact of the so-called Timing Attack described in

# http://security.lss.hr/index.php?page=details&ID=LSS-2004-10-02

# It is on by default.

<IfModule mod_delay.c>

  DelayEngine              on

</IfModule>

<IfModule mod_ctrls.c>

  ControlsEngine           on

  ControlsMaxClients       2

  ControlsLog              /var/log/proftpd/controls.log

  ControlsInterval         5

  ControlsSocket           /var/run/proftpd/proftpd.sock

</IfModule>

<IfModule mod_ctrls_admin.c>

  AdminControlsEngine      on

</IfModule>

# ispCP SQL Managment

# Activate for proftpd >= 1.3

#SQLBackend                 mysql

SQLAuthTypes               Crypt

SQLAuthenticate            on

SQLConnectInfo             ispcp@localhost vftp PASSWORD

SQLUserInfo                ftp_users userid passwd uid gid homedir shell

SQLConnectInfo             ispcp@localhost vftp PASSWORD

SQLUserInfo                ftp_users userid passwd uid gid homedir shell

SQLGroupInfo               ftp_group groupname gid members

SQLMinUserUID              2000

SQLMinUserGID              2000

# A basic anonymous configuration, no upload directories.

# <Anonymous ~ftp>

#   User                   ftp

#   Group                  nogroup

#   # We want clients to be able to login with "anonymous" as well as "ftp"

#   UserAlias              anonymous ftp

#   # Cosmetic changes, all files belongs to ftp user

#   DirFakeUser            on ftp

#   DirFakeGroup           on ftp

#

#   RequireValidShell      off

#

#   # Limit the maximum number of anonymous logins

#   MaxClients             10

#

#   # We want 'welcome.msg' displayed at login, and '.message' displayed

#   # in each newly chdired directory.

#   DisplayLogin           welcome.msg

#   DisplayFirstChdir      .message

#

#   # Limit WRITE everywhere in the anonymous chroot

#   <Directory *>

#     <Limit WRITE>

#       DenyAll

#     </Limit>

#   </Directory>

#

#   # Uncomment this if you're brave

#

#   # Uncomment this if you're brave.

#   # <Directory incoming>

#   #   # Umask 022 is a good standard umask to prevent new files and dirs

#   #   # (second parm) from being group and world writable.

#   #   Umask              022  022

#   #   <Limit READ WRITE>

#   #     DenyAll

#   #   </Limit>

#   #   <Limit STOR>

#   #     AllowAll

#   #   </Limit>

#   # </Directory>

#   

# </Anonymous>

Include /etc/proftpd/ispcp/*

and the error that say's phpmyadmin when i pretend connect to it:

at top: #2005 - Unknown MySQL server host '{HOSTNAME}' (1)

at footer: Connection for controluser as defined in your configuration failed.

Thanks for all

**joximu** · 04-28-2009 01:39 AM

pma: use the original config from your backup...

**kilburn** · 04-28-2009 01:52 AM

Uncomment the line

#Include /etc/proftpd/modules.conf

at the beggining of your proftpd.conf and try to restart....

PS: (guide updated)

Arturo2 · 04-28-2009 02:31 AM

Thanks kilburn Big Grin

i solved the ftp error, but i haven't backups for restore the problem with pma.

Thanks for all & sorry for my bad english

**kilburn** · 04-28-2009 02:41 AM

Well, you will have to restore the pma user password and prepare a new configuration file:

1. Connect to mysql and change the 'pma' user password

Code:

mysql -uroot -p    (you will be asked root's mysql password)

... Blah blah mysql connected.

> USE mysql;

> UPDATE mysql.user SET Password=PASSWORD('newpass') WHERE User='pma';

> FLUSH PRIVILEGES;

2. Go to pma's folder, remove the current config file and grab the original one from subversion:

Code:

cd /var/www/ispcp/tools/pma/

rm config.inc.php

wget http://www.isp-control.net/ispcp/export/1714/tags/omega-1.0.0/gui/tools/pma/config.inc.php

3. Replace these values from the grabbed file:

PHP Code:

...
$cfg['Servers'][$i]['host']             = 'localhost';
...
$cfg['Servers'][$i]['controluser']         = 'pma';
$cfg['Servers'][$i]['controlpass']         = 'newpass';
... 

4. Give me a reputation point Tongue

Arturo · 04-29-2009 01:47 AM

Thanks for all, i finally resolve the problem Smile

PD: How i can give you the reputation point? :S

Lucan · 04-29-2009 02:10 AM

http://www.isp-control.net/forum/reputation.php?uid=232

And press the "RATE USER" button.

Threaded Mode \| Linear Mode [URGENT] ftp & phpmyadmin fail
Author	Message