Proftpd med mod_sql_mysql

• Next message: Xride: "xe0 Xircom net card under FreeBSD"
• Previous message: Ole Guldberg Jensen: "Re: BSD-DK møde i Århus"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
• Mail actions: [ respond to this message ] [ mail a new topic ]

From: "Simon A. F. Lund" <none@safl--vip.cybercity.dk.lh.bsd-dk.dk>
To: <none@bsd-dk--bsd-dk.dk.lh.bsd-dk.dk>
Subject: Proftpd med mod_sql_mysql
Date: Thu, 4 Oct 2001 19:54:21 +0200

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

• Next message: Xride: "xe0 Xircom net card under FreeBSD"
• Previous message: Ole Guldberg Jensen: "Re: BSD-DK møde i Århus"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
• Mail actions: [ respond to this message ] [ mail a new topic ]

This archive was generated by hypermail 2b30 : Wed 15 Nov 2006 - 18:24:16 CET