Review your favorite Linux distribution.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 04-03-2004, 08:46 AM   #1
LQ Newbie
Registered: Apr 2004
Posts: 4

Rep: Reputation: 0
ProFTPD with MySQL Auth - SQLAuthType Problem

Hi there,

I've installed ProFTPD on Suse 9 Pro with MySQL Authentication but when I go to execute the ./proftpd command I get this error:

- Fatal: unknown configuration directive 'SQLAuthTypes' on line 11 of '/usr/local/etc/proftpd.conf'.

This line is:

SQLAuthTypes Plaintext

I've tried it also as:

SQLAuthTypes Plaintext Crypt

I'm 99.9% sure the installation was successful and the database is setup right.

Thanks for any help.

Here is my proftpd.conf file:

ServerName			"Brooky FTP Server"
ServerType			standalone
DefaultServer			on
ScoreboardFile                  "/usr/local/var/proftpd/proftpd.scoreboard"
Port				21
Umask				022
MaxInstances			10
User				nobody
Group				nogroup
DefaultRoot ~
SQLAuthTypes         Plaintext Crypt
SQLAuthenticate      users usersetfast
SQLConnectInfo       proftpd@localhost proftpd mypassword
SQLDefaultUID        80
SQLDefaultGID        80
SQLMinUserUID        3000
SQLMinUserGID        21
SQLUserInfo          users username password uid gid homedir shell
SQLLog PASS login
SQLNamedQuery login UPDATE "last_login = NOW() WHERE username = '%u'" users
RequireValidShell               off
UseReverseDNS off
<Directory />
  AllowOverwrite		on

Last edited by brooky; 04-03-2004 at 08:51 AM.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
proftpd auth julc Linux - Software 2 09-12-2005 09:00 AM
proftpd with mysql auth pumazi Linux - Software 0 07-03-2005 01:30 PM
[PROFTPD] LDAP vs basic auth. Creak Linux - Security 1 09-21-2004 07:52 PM
Would like to get CourierImap, Sasl and ProFTPd to auth from MySql pembo13 Linux - Networking 0 03-29-2004 10:26 PM
Proftpd Password Auth Sifvion Slackware 10 09-12-2002 08:53 AM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 01:56 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration