LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices


Reply
  Search this Thread
Old 01-29-2005, 06:29 PM   #1
KR-data
LQ Newbie
 
Registered: Nov 2004
Location: Denmark
Distribution: Slackware
Posts: 20

Rep: Reputation: 0
Exclamation Pure-ftpd, login with MySQL as control - problem


Hi

I got a problem with my Pure-ftpd. I have compiled it with mysql-support and done what their manuals sais I have to do.

I Execute it with the command:
Code:
# pure-ftpd -C 3 -H -E -K 95 -p 1025:3000 -t 512:128 -U 755:755 -Y 2 -l mysql:/cmn/pftpd-mysql.conf
I have set up the database, table, user etc. etc.

My config file looks like this:

Code:
MYSQLServer     localhost
MYSQLPort       3306
MYSQLSocket     /var/lib/mysql/mysql.sock
MYSQLUser       pftpd
MYSQLPassword   ******
MYSQLDatabase   pftpd
MYSQLCrypt      MD5
MYSQLDefaultUID 1000
MYSQLDefaultGID 1000
MYSQLGetPW      SELECT Password FROM users WHERE User="\L"
MYSQLGetUID     SELECT Uid FROM users WHERE User="\L"
MYSQLGetGID     SELECT Gid FROM users WHERE User="\L"
MYSQLGetDir     SELECT Dir FROM users WHERE User="\L"
MySQLGetRatioUL SELECT ULRatio FROM users WHERE User="\L"
MySQLGetRatioDL SELECT DLRatio FROM users WHERE User="\L"
And it is also made after the manual.

If I take a look in my system-log it tells me this:

Quote:
Jan 30 01:19:14 stine pure-ftpd: (?@127.0.0.1) [ERROR] The SQL server seems to be down
Jan 30 01:19:14 stine pure-ftpd: (?@127.0.0.1) [WARNING] Authentication failed for user [kr-data]
To me it seems like it is completely ignoring my configurations, also because if I change localhost to anette (which should resolve the ip 192.168.0.1) it still says 127.0.0.1

What can I do to fix this problem?
 
  


Reply


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
pure-ftpd and root login szymon Linux - Software 6 03-13-2012 11:28 AM
pure-ftpd mysql virtual groups augustmacbizzle Linux - Software 0 04-27-2005 01:09 PM
Pure-ftpd-mysql + Sarge nestor10 Linux - Software 1 01-26-2005 08:06 AM
pure-ftpd and mysql dominant Linux - General 1 01-11-2005 02:33 AM
pure-ftpd connection problem bbaum Linux - Software 1 01-07-2004 02:46 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:45 PM.

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