pureftpd mysql auth failing

[HooGLaNDeR]

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]

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

[HooGLaNDeR]

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]

Are you sure your server connects to the mysql server?

[HooGLaNDeR]

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]

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

[HooGLaNDeR]

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]

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