ProFTPD + authentication via PostgreSQL under SID - not working
my system is as follows
Debian ver.: SID
ProFTPD: proftpd-pgsql-1.2.4+1.2.5rc1-2 (apt-get'ed)
PostgreSQL: 7.2 (self compiled)
The problem is that, even though I have a *correctly* configure mod_sql and
postgres database, proftpd is unable to authenticate via postgres. If I
downgrade proftpd to 1.2.4 from woody all works fine, but the dependencies
for libpgsql2 are broken so I cannot "apt-get upgrade" the system without
running into problems. Well, SID should be upgraded daily I guess ;-)
There for sure is some communication between proftpd and postgres - I have
sniffed it - and even more: there is a reply! Both the query and result of
it look correct to me. So, what the heck can be wrong?!
OK, to be precise it looks like this
PAM (system account):
PostgreSQL (virtual account):
I logon with user name "test" and password "test" - the reply is short
"login incorrect" but in the background a nice sniffer shows that proftpd
asked postgres for data about user "test" and received a *correct* reply...
but didn't use it. Nice...
So what I do now is logging on with the credentials of the PAM account: just
an eye blink later I'm in and hapily ftping. Excuse me!?
Here's my proftpd config part responsible for SQL:
SQLAuthenticate users groups
SQLAuthTypes plaintext backend
SQLConnectInfo ftp_db@localhost ftp_u ******
SQLUserInfo users username uid gid password homedir lcount NULL
SQLGroupInfo groups groupname gid members NULL
and some communication I've sniffed:
ProFTPD -> PostgreSQL
QSELECT username, uid, gid, password, homedir, lcount FROM users
WHERE(username='test') LIMIT 1.
PostgreSQL -> ProFTPD
....123CSEL? ?? ?ECT.Z
Any ideas? I have none anymore :-/
Or maybe it'll be better if I apt-get remove all libpgsql2 and proftpd files
and compile it myself? Naaaah... where would be the sense to have a distro
Ah, this machine is mainly a desktop therefore it has SID not Potato or
Woody. SID is unstable, sure, but up2date with the world ;-)
Thanks for *any* help.
Na newsy piszący wyłącznie prywatnie