HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=4)
-   -   pureftpd mysql auth failing (http://www.howtoforge.com/forums/showthread.php?t=33043)

HooGLaNDeR 30th March 2009 14:58

pureftpd mysql auth failing
 
Hello,

I have 2 separate servers both running pureftpd and 1 of them i can't log in to.
Both are, i believe, setup the same, and both are sharing a database on the same MySQL server.

Does anyone have an idea where i could find out whats going wrong?
I checked logs, but i only see the testuser isn't getting in.

Thanks,

HooGLaNDeR

falko 31st March 2009 16:50

Which distribution are you using?
Have you tried both active and passive transfers in your FTP client?

HooGLaNDeR 31st March 2009 17:48

On both machines im using Debian. Debian 5.
I can connect both passive as active on the one working machine and neither on the other.

Both servers connect to a third machine where mysql is installed.
The working machine doesn't show anything except succesfull logins. The other states

"pure-ftpd: pam_unix_auth(pure-ftpd:auth): authentication failure; logname= uid=0 euid=0 tty=pure-ftpd ruser=t3st rhost=hosted.by.myself.com"

deconectat 31st March 2009 18:04

Are you sure your server connects to the mysql server?

HooGLaNDeR 31st March 2009 19:09

I think so, both config files (/etc/pure-ftpd/db/mysql.conf) point to the same MySQL server.

But how could i see that for sure ?

deconectat 31st March 2009 20:10

Maybe you have some iptables rules on your mysql server. Just try telnet mysql.ip:port and see if it connects. If that works, use netstat -ap to see if your mail server connects to mysql.

HooGLaNDeR 1st April 2009 00:54

Hmm, i dont know exactly why. but i "fixed" it, by copying the /conf directory from my working server to the non working server, replacing all files.

And, after restarting, its working...

Weird huh :O

HooGLaNDeR 1st April 2009 01:11

file:
containing text :

AllowUserFXP
yes

AltLog
clf:/var/log/pure-ftpd/transfer.log

MinUID
1000

MySQLConfigFile
/etc/pure-ftpd/db/mysql.conf

NoAnonymous
yes

PAMAuthentication
yes

PureDB
/etc/pure-ftpd/pureftpd.pdb

UnixAuthentication
no


All times are GMT +2. The time now is 15:24.

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