mysql didn't work
Posted: 01. October 2005 07:23- Code: Select all
----proftpd.conf-----
# This is a basic ProFTPD configuration file (rename it to
# 'proftpd.conf' for actual use. It establishes a single server
# and a single anonymous login. It assumes that you have a user/group
# "nobody" and "ftp" for normal operation and anon.
ServerName "ProFTPD Default Installation"
ServerType standalone
DefaultServer on
# Port 21 is the standard FTP port.
Port 21
# Umask 022 is a good standard umask to prevent new dirs and files
# from being group and world writable.
Umask 022
# 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 under which the server will run.
User nobody
Group nogroup
#MySQL
SQLConnectInfo proftpd root simon111
SQLUserInfo ftpusers username uid gid password homedir count
SQLAuthenticate on
SQLAuthTypes plaintext
------proftpd.conf--------
when i try to login ftp i get this
- Code: Select all
Connecting to 172.16.1.33 Port: 21
Connected to mepis1.
220 ProFTPD 1.2.10 Server (ProFTPD Default Installation) [172.16.1.33]
USER xray15
An established connection was aborted by the software in your host machine.
Server closed connection
I made the database
- Code: Select all
-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 01, 2005 at 02:25 AM
-- Server version: 4.1.14
-- PHP Version: 4.4.0
--
-- Database: `proftpd`
--
-- --------------------------------------------------------
--
-- Table structure for table `ftp`
--
CREATE TABLE `ftp` (
`username` varchar(60) default NULL,
`uid` int(11) default NULL,
`gid` int(11) default NULL,
`password` varchar(30) default NULL,
`homedir` varchar(50) default NULL,
`count` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ftp`
--
INSERT INTO `ftp` VALUES ('xray15', 500, 500, '****', '/opt/lampp', 2);