Hello!
Jeg har installeret proftpd med mysql support problemet er at
"authorizationingen" ikke fungerer. Selvom brugerne ikke er oprettede i
databasen bliver brugerne tilladt afgang fordi de er shellusers. Jeg vil
have at MySQL er det eneste der skal bruges til authorizing!
Dette er min proftpd.conf:
#
# Safl ftp server
ServerName "Testing 1 2 3 testing"
ServerType standalone
DefaultServer on
UseReverseDNS off
IdentLookups off
DefaultRoot ~
Port 2121
Umask 022
MaxInstances 30
User simon
Group simon
PassivePorts 60000 65535
#Sql stuff:
#SQLDoAuth
SQLConnectInfo proftpd@localhost root
SQLAuthTypes Plaintext
SQLUserTable users
SQLUidField uid
SQLUsernameField username
SQLPasswordField password
SQLHomedirField homedir
SQLGroupTable groups
SQLGidField gid
SQLGroupnameField groupname
#no more sql from here :)
RequireValidShell off
<Directory /*>
AllowOverwrite on
</Directory>
# FriFoed webserver adgang
<VirtualHost 192.168.0.2>
AllowForeignAddress on
Servername "FriFoed development server"
Port 210
MaxClients 3
MaxLoginAttempts 3
DeferWelcome off
Umask 000
user simon rodler
group frifoed
AllowOverwrite On
DefaultRoot /usr/local/www/data/frifoed/
UseReverseDNS off
IdentLookups off
SystemLog /usr/logs/frifoed.log
</VirtualHost>
Og dette er et dump af databasen:
CREATE TABLE `groups` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`groupname` varchar(50) NOT NULL default '',
`gid` int(11) unsigned NOT NULL default '0',
`members` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen 'users'
#
CREATE TABLE `users` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`username` varchar(30) NOT NULL default '',
`uid` int(11) unsigned NOT NULL default '0',
`gid` int(11) unsigned NOT NULL default '0',
`password` varchar(30) NOT NULL default '',
`homedir` varchar(50) NOT NULL default '',
`shell` varchar(30) NOT NULL default '',
`count` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;
Håber i kan hjælpe! på forhånd tak!
mvh Simon A. F. Lund
|