Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 15th September 2006, 19:39
unclecameron unclecameron is offline
Senior Member
 
Join Date: Apr 2006
Posts: 115
Thanks: 2
Thanked 8 Times in 7 Posts
Default Fedora 5 pureftpd mysql authentication error

Hi all,

I'm running Fedora Core 5, ftp logs in anonymously but can't upload, system verifies username and creates home/user but won't authenticate. SELinux and firewall are disabled. BTW, great site, great help, let me know how I can support you guys

Details:
ftp connection attempt:
-----------------------
Status: Connecting to 192.168.2.143 ...
Status: Connected with 192.168.2.143. Waiting for welcome message...
Response: 220---------- Welcome to Pure-FTPd [privsep] [TLS] ----------
Response: 220-You are user number 1 of 500 allowed.
Response: 220-Local time is now 08:42. Server port: 21.
Response: 220-IPv6 connections are also welcome on this server.
Response: 220 You will be disconnected after 15 minutes of inactivity.
Command: USER unclecameron
Response: 331 User unclecameron OK. Password required
Command: PASS ********
Error: Disconnected from server
Error: Unable to connect!
--------------------------------

query from mysql db pureftpd/ftpd
---------------------------------
user unclecameron
status 1
Password d282b64578d46bd539cdb47c36.....
Uid 2001
Gid 2001
Dir /home/unclecameron
everything else = 0
--------------------------

/etc/pure-ftpd/pure-ftpd.conf
-----------------------------
ChrootEveryone yes
BrokenClientsCompatibility no
MaxClientsNumber 500
Daemonize yes
MaxClientsPerIP 100
VerboseLog yes
DisplayDotFiles yes
AnonymousOnly no
NoAnonymous no
SyslogFacility ftp
DontResolve yes
MaxIdleTime 15
MySQLConfigFile /etc/pure-ftpd/pureftpd-mysql.conf
PAMAuthentication yes
AnonymousCanCreateDirs no
MaxLoad 4
ntiWarez yes
Umask 133:022
MinUID 500
AltLog clf:/var/log/pureftpd.log
CreateHomeDir yes
CustomerProof yes
----------------------------

/etc/pure-ftpd/pureftpd-mysql.conf
-----------------------------------

MYSQLServer localhost
MYSQLSocket /var/lib/mysql/mysql.sock
MYSQLUser pureftpd
MYSQLPassword ftpd
MYSQLDatabase pureftpd
MYSQLCrypt md5
MYSQLGetPW SELECT Password FROM ftpd WHERE User="\L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetUID SELECT Uid FROM ftpd WHERE User="\L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetGID SELECT Gid FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetDir SELECT Dir FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetQTAFS SELECT QuotaFiles FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetQTASZ SELECT QuotaSize FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetBandwidthUL SELECT ULBandwidth FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetBandwidthDL SELECT DLBandwidth FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
------------------------------------

There's nothing in /var/log/pureftpd.log

1. Is there a way I can change to simpler authentication just see if I can get it working?
2. Is there any way I can test the current authentication to see what password mysql is really seeing, and if it matches the user password?
3. I normally work in Debian, but there are no RAID drivers for a Dell Poweredge 1850, so I went with FC5.

Thanks,
Cameron Camp
San Diego
Reply With Quote
Sponsored Links
  #2  
Old 17th September 2006, 00:45
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,745 Times in 2,578 Posts
Default

Quote:
Originally Posted by unclecameron
BTW, great site, great help, let me know how I can support you guys
Have a look here: http://www.howtoforge.com/membership

I see you're using Pure-FTPd with MySQL. Did you have a look at the configuration in this tutorial? http://www.howtoforge.com/pureftpd_m...irtual_hosting
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 18th September 2006, 01:24
unclecameron unclecameron is offline
Senior Member
 
Join Date: Apr 2006
Posts: 115
Thanks: 2
Thanked 8 Times in 7 Posts
Default

Yeah, that's the tutorial I used.

Thanks,
Cameron
Reply With Quote
  #4  
Old 18th September 2006, 13:28
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,745 Times in 2,578 Posts
Default

Quote:
Originally Posted by unclecameron
There's nothing in /var/log/pureftpd.log
Is there anything in the other logs in /var/log?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 18th September 2006, 18:20
unclecameron unclecameron is offline
Senior Member
 
Join Date: Apr 2006
Posts: 115
Thanks: 2
Thanked 8 Times in 7 Posts
Default

no, nothing in pureftpd.log, mysqld.log or any other log file that looked related.
Thanks,
Cameron
Reply With Quote
  #6  
Old 19th September 2006, 00:34
sayfanet sayfanet is offline
Junior Member
 
Join Date: Sep 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i also need ftpd mysql solution.

i have tried to install proftpd - mysql on fc5 but it gives signal15 and doesnt start.

tried everything. entered root password on proftpd.conf.

what do you recommend me? is pureftpd easy to install?
Reply With Quote
  #7  
Old 19th September 2006, 07:16
unclecameron unclecameron is offline
Senior Member
 
Join Date: Apr 2006
Posts: 115
Thanks: 2
Thanked 8 Times in 7 Posts
Default

Yeah, I had to get something up and running, and couldn't make proftpd work either, I installed

yum install proftpd*

which installed proftpd and proftpd-mysql, but I did:

/etc/init.d/proftpd start

and it failed, no matter what I edited with the configuration file proftpd.conf, even if I deleted the reference to the mysql function. I have this setup running perfectly on a Debian box for years, but Debian doesn't have the RAID driver for my Dell PowerEdge 1850, so I'm stuck.

For now, I installed vsftpd with yum and it pretty much worked after modifying vsftpd.conf and just

/etc/init.d/vsftpd start

But I only have it working with system users, so that kind of sucks, I really need to have mysql and virtual users, but ran out of time. But at least people stopped screaming at me because they could upload to their home dir's, so I guess good enough until I get something else figured out

Thanks,
Cameron Camp
San Diego
Reply With Quote
  #8  
Old 19th September 2006, 07:23
unclecameron unclecameron is offline
Senior Member
 
Join Date: Apr 2006
Posts: 115
Thanks: 2
Thanked 8 Times in 7 Posts
Default

Hey Falko and Till, thanks for the help, I just signed up as a supporter, do you have those images on Xen?
Thanks,
Cameron Camp
Reply With Quote
  #9  
Old 19th September 2006, 16:25
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,745 Times in 2,578 Posts
 
Default

Quote:
Originally Posted by unclecameron
do you have those images on Xen?
Thanks,
Cameron Camp
You mean, instead of VMware images? No, I'm sorry, we only have VMware images.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
configuring IPTABLES firewall adityavpratap HOWTO-Related Questions 9 27th May 2006 22:42
Frustrated with ISPConfig install! woozyerdaddee Installation/Configuration 4 19th May 2006 04:38
Installation Fails... :( cyberstorm Installation/Configuration 1 15th January 2006 19:07
Could not make OpenSSL yontengyatso Installation/Configuration 3 3rd November 2005 11:50
Install stop at uuwish, UUDeview SeaWolf Installation/Configuration 6 5th October 2005 00:53


All times are GMT +2. The time now is 17:05.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.