Filemanager

[andreas-1@hotmail.it]

Hi,
i try ispCP 1.0.0 RC6 OMEGA for my servers...the installation is simple and work fine....beautiful layout, but 1 thing not work...filemanager...when i click the blank page opened. Also Choose dir not work...."Can not open directory !
Please contact your administrator !"...mmm...i think the problem is proftpd with mysql...is possible?because when i create a ftp accounts, these not work....but proftpd is installed with mysql modules...and ispCP overwrite the configuration....

/etc/proftpd/proftpd.conf

# ispCP SQL Managment
# Activate for proftpd >= 1.3
SQLBackend mysql
SQLAuthTypes Crypt Plaintext
SQLAuthenticate on
SQLConnectInfo ispcp@localhost:3306 vftp *****
SQLUserInfo ftp_users userid passwd uid gid homedir shell
SQLGroupInfo ftp_group groupname gid members
SQLMinUserUID 2000
SQLMinUserGID 2000

the OS is ubuntu server 8.04 hardy

where is the problem??ispCP or proftpd?

thanks
best regards

[sci2tech]

(11-06-2008 05:05 AM)andreas-1@hotmail.it Wrote:  Hi,
i try ispCP 1.0.0 RC6 OMEGA for my servers...the installation is simple and work fine....beautiful layout, but 1 thing not work...filemanager...when i click the blank page opened. Also Choose dir not work...."Can not open directory !
Please contact your administrator !"...mmm...i think the problem is proftpd with mysql...is possible?because when i create a ftp accounts, these not work....but proftpd is installed with mysql modules...and ispCP overwrite the configuration....

/etc/proftpd/proftpd.conf

# ispCP SQL Managment
# Activate for proftpd >= 1.3
SQLBackend mysql
SQLAuthTypes Crypt Plaintext
SQLAuthenticate on
SQLConnectInfo ispcp@localhost:3306 vftp *****
SQLUserInfo ftp_users userid passwd uid gid homedir shell
SQLGroupInfo ftp_group groupname gid members
SQLMinUserUID 2000
SQLMinUserGID 2000

the OS is ubuntu server 8.04 hardy

where is the problem??ispCP or proftpd?

thanks
best regards

Your proftpd is not running with mysql module activated. Add this to you proftpd.conf after

Code:

# 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>

Code:

# Loading required modules
<IfModule !mod_sql.c>
  LoadModule mod_sql.c
</IfModule>
<IfModule !mod_sql_mysql.c>
  LoadModule mod_sql_mysql.c
</IfModule>
<IfModule !mod_quotatab.c>
  LoadModule mod_quotatab.c
</IfModule>
<IfModule !mod_quotatab_sql.c>
  LoadModule mod_quotatab_sql.c
</IfModule>

[four2theizz0]

Hi,

I am having the same problem. I have added the lines:

Code:

# Loading required modules
<IfModule !mod_sql.c>
  LoadModule mod_sql.c
</IfModule>
<IfModule !mod_sql_mysql.c>
  LoadModule mod_sql_mysql.c
</IfModule>
<IfModule !mod_quotatab.c>
  LoadModule mod_quotatab.c
</IfModule>
<IfModule !mod_quotatab_sql.c>
  LoadModule mod_quotatab_sql.c
</IfModule>

to my proftpd.conf after the <Global> entries. I have reset proftp and am still getting the blank page. any thougts?

[sci2tech]

Then you must stop proftpd (/etc/init.d/proftpd stop), kill any remaining instance (find pid with ps aux | grep proftpd and kill them with kill -s sigkill <pid> ) . Then start proftpd with proftpd -n -d5, try to connect and put here output.

[Gymnogyp]

I am having the same problem, here is my proftpd.conf......

#
# /etc/proftpd/proftpd.conf -- This is a basic ProFTPD configuration file.
# To really apply changes reload proftpd after modifications.
#

# Includes DSO modules
Include /etc/proftpd/modules.conf

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

ServerName "Debian"
ServerType standalone
DeferWelcome off

MultilineRFC2228 on
DefaultServer on
ShowSymlinks on

TimeoutNoTransfer 600
TimeoutStalled 600
TimeoutIdle 1200

DisplayLogin welcome.msg
DisplayChdir .message true
ListOptions "-l"

DenyFilter \*.*/

# Use this to jail all users in their homes
# DefaultRoot ~

# Users require a valid shell listed in /etc/shells to login.
# Use this directive to release that constrain.
# RequireValidShell off

# Port 21 is the standard FTP port.
Port 21

# In some cases you have to specify passive ports range to by-pass
# firewall limitations. Ephemeral ports can be used for that, but
# feel free to use a more narrow range.
# PassivePorts 49152 65534

# If your host was NATted, this option is useful in order to
# allow passive tranfers to work. You have to use your public
# address and opening the passive ports used on your firewall as well.
# MasqueradeAddress 1.2.3.4

# 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 proftpd
Group nogroup

# 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

# Uncomment this if you are using NIS or LDAP via NSS to retrieve passwords:
# PersistentPasswd off

# This is required to use both PAM-based authentication and local passwords
# AuthOrder *mod_auth_pam.c mod_auth_unix.c

# 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

# Choose a SQL backend among MySQL or PostgreSQL.
# Both modules are loaded in default configuration, so you have to specify the backend
# or comment out the unused module in /etc/proftpd/modules.conf.
# Use 'mysql' or 'postgres' as possible values.
#
#<IfModule mod_sql.c>
#SQLBackend mysql
#</IfModule>

TransferLog /var/log/proftpd/xferlog
SystemLog /var/log/proftpd/proftpd.log

<IfModule mod_quotatab.c>
QuotaEngine off
</IfModule>

<IfModule mod_ratio.c>
Ratios off
</IfModule>


# Delay engine reduces impact of the so-called Timing Attack described in
# http://security.lss.hr/index.php?page=de...2004-10-02
# It is on by default.
<IfModule mod_delay.c>
DelayEngine on
</IfModule>

<IfModule mod_ctrls.c>
ControlsEngine off
ControlsMaxClients 2
ControlsLog /var/log/proftpd/controls.log
ControlsInterval 5
ControlsSocket /var/run/proftpd/proftpd.sock
</IfModule>

<IfModule mod_ctrls_admin.c>
AdminControlsEngine off
</IfModule>

#
# Alternative authentication frameworks
#
#Include /etc/proftpd/ldap.conf
#Include /etc/proftpd/sql.conf

#
# This is used for FTPS connections
#
#Include /etc/proftpd/tls.conf

# 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.
# # <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>

---

also, I can't login via filezilla. I have no clue whats wrong.

[four2theizz0]

Hi,

Here is the output from loading proftpd in standalone mode. I see it loads attempts to load a couple things more than once. I am thinking I can get rid of a few things, please let me know. Thank you!

- mod_tls/2.1.2: using OpenSSL 0.9.8g 19 Oct 2007
- disabling runtime support for IPv6 connections
- DenyFilter: compiling deny regex '\*.*/'
- <Directory /*>: deferring resolution of path
- <Directory ~/>: deferring resolution of path
- PathDenyFilter: compiling deny regex '^/(backups|cgi-bin|htdocs|errors|logs|phptmp|statistics)/?$'
- PathDenyFilter: compiling deny regex '.quota$'
- <IfModule>: skipping '!mod_sql.c' section at line 112
- <IfModule>: skipping '!mod_sql_mysql.c' section at line 115
- <IfModule>: skipping '!mod_quotatab.c' section at line 118
- <IfModule>: skipping '!mod_quotatab_sql.c' section at line 121
- <IfModule>: using 'mod_quotatab.c' section at line 140
- <IfModule>: skipping 'mod_ratio.c' section at line 155
- <IfModule>: using 'mod_delay.c' section at line 162
- <IfModule>: using 'mod_ctrls.c' section at line 166
- <IfModule>: using 'mod_ctrls_admin.c' section at line 174
- <IfModule>: using 'mod_auth_pam.c' section at line 177
domain.com -
domain.com - Config for domain.com:
domain.com - Limit
domain.com - IgnoreHidden
domain.com - ~/
domain.com - PathDenyFilter
domain.com - ShowSymlinks
domain.com - AllowOverwrite
domain.com - AllowStoreRestart
domain.com - AllowForeignAddress
domain.com - DisplayLogin
domain.com - DisplayChdir
domain.com - ListOptions
domain.com - DenyFilter
domain.com - SQLNamedQuery_get-quota-limit
domain.com - SQLNamedQuery_get-quota-tally
domain.com - SQLNamedQuery_update-quota-tally
domain.com - SQLNamedQuery_insert-quota-tally
domain.com - SQLAuthTypes
domain.com - SQLAuthenticate
domain.com - SQLConnectInfo
domain.com - SQLMinUserUID
domain.com - SQLMinUserGID
domain.com - RootLogin
domain.com - TransferLog
domain.com - /*
domain.com - Umask
domain.com - DirUmask
domain.com - AllowOverwrite
domain.com - HideNoAccess
domain.com - ShowSymlinks
domain.com - AllowStoreRestart
domain.com - AllowForeignAddress
domain.com - DisplayLogin
domain.com - DisplayChdir
domain.com - ListOptions
domain.com - DenyFilter
domain.com - SQLNamedQuery_get-quota-limit
domain.com - SQLNamedQuery_get-quota-tally
domain.com - SQLNamedQuery_update-quota-tally
domain.com - SQLNamedQuery_insert-quota-tally
domain.com - SQLAuthTypes
domain.com - SQLAuthenticate
domain.com - SQLConnectInfo
domain.com - SQLMinUserUID
domain.com - SQLMinUserGID
domain.com - RootLogin
domain.com - TransferLog
domain.com - PathDenyFilter
domain.com - DeferWelcome
domain.com - DefaultServer
domain.com - ShowSymlinks
domain.com - AllowOverwrite
domain.com - IdentLookups
domain.com - AllowStoreRestart
domain.com - AllowForeignAddress
domain.com - TimeoutLogin
domain.com - TimeoutNoTransfer
domain.com - TimeoutStalled
domain.com - TimeoutIdle
domain.com - DisplayLogin
domain.com - DisplayChdir
domain.com - ListOptions
domain.com - DenyFilter
domain.com - DefaultRoot
domain.com - UserID
domain.com - UserName
domain.com - GroupID
domain.com - GroupName
domain.com - QuotaEngine
domain.com - QuotaShowQuotas
domain.com - QuotaDisplayUnits
domain.com - SQLNamedQuery_get-quota-limit
domain.com - SQLNamedQuery_get-quota-tally
domain.com - SQLNamedQuery_update-quota-tally
domain.com - SQLNamedQuery_insert-quota-tally
domain.com - QuotaLock
domain.com - QuotaLimitTable
domain.com - QuotaTallyTable
domain.com - DelayEngine
domain.com - AuthPAM
domain.com - SQLAuthTypes
domain.com - SQLAuthenticate
domain.com - SQLConnectInfo
domain.com - SQLUserTable
domain.com - SQLUsernameField
domain.com - SQLPasswordField
domain.com - SQLUidField
domain.com - SQLGidField
domain.com - SQLHomedirField
domain.com - SQLShellField
domain.com - SQLGroupTable
domain.com - SQLGroupnameField
domain.com - SQLGroupGIDField
domain.com - SQLGroupMembersField
domain.com - SQLMinUserUID
domain.com - SQLMinUserGID
domain.com - RootLogin
domain.com - TransferLog
domain.com - ExtendedLog
domain.com - PathDenyFilter
domain.com - ProFTPD 1.3.1 (stable) (built Thu Feb 21 04:21:14 UTC 2008) standalone mode STARTUP