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

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

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"

Are you sure your server connects to the mysql server?

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 ?

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.

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

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