[proftpd-mysql] problem z konfiguracja

[Sebastian Seeb Pachla <seeb1@tlen.pl>]

Ktos moze instalowal proftpd-mysql i moglby sie podzielic
informacjami?

moja konfiguracja wyglada tak:

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

ServerName                      "main"
ServerType                      standalone
DeferWelcome                    off

MultilineRFC2228                on
DefaultServer                   on
ShowSymlinks                    on

TimeoutNoTransfer               600
TimeoutStalled                  600
TimeoutIdle                     1200

DisplayLogin                    welcome.msg
DisplayFirstChdir               .message
ListOptions                     "-l"

DenyFilter                      \*.*/
Port                            21
MaxInstances                    30

User                            nobody
Group                           nogroup
Umask                           022  022
AllowOverwrite                  on
DefaultRoot ~

##################################################################################
################################# proma config ###################################
##################################################################################

SQLConnectInfo        ftp@localhost proftpd haslo
SQLAuthenticate       users
SQLAuthTypes          backend
SQLDefaultHomedir     /home/mail/ftp/
SQLUserInfo           users userid passwd uid gid homedir shell
SQLGroupInfo          groups groupname gid members
SQLLog                PASS updatecount
SQLNamedQuery         updatecount UPDATE "count=count+1 WHERE userid='%u'" users

RootLogin off
RequireValidShell off
---------------------------------------------------------------------------------
mysql:

CREATE TABLE `users` (
  `userid` varchar(255) NOT NULL default '',
  `name` varchar(255) default NULL,
  `mail` varchar(255) default NULL,
  `uid` int(11) default '65534',
  `gid` int(11) default '65534',
  `passwd` varchar(255) NOT NULL default '',
  `shell` varchar(255) NOT NULL default '/bin/false',
  `homedir` varchar(255) NOT NULL default '/home/mail/ftp',
  `note` text,
  `count` int(11) NOT NULL default '0',
  `admin` int(1) NOT NULL default '0',
  `closed` int(1) NOT NULL default '0',
  UNIQUE KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;