[Proftpd-user] Proftpd, mod_Sql and unknown file owners

Mattias Larsson <[email protected]> Mon, 27 Oct 2025 14:11:33 +0100
Newsgroups gmane.network.proftpd.user
Message-ID <[email protected]>
Hello.

We have a proftpd setup with mod_sql + unixodbc that authenticates users 
against a oracle database with a named query. This works great and users 
can login no problem. The users gets their own root and a static (and 
same) uid and gid from the query. The only useful parts are username, 
password and rootdir basicly.

Recently I noticed that if a directory contains files created from 
windows, getting the 1000254 or something uid, proftpd or mod_sql does a 
"default" query which fail since we don't have any "users" table in the 
database. This makes mod_sql error out and the user is disconnected.

The users in question have access to the files through the gid anyway 
but gets disconnected so.

I have never noticed this before, maybe because it rarely happends and 
the user doesn't report it, or maybe because of something new.

Any idea why this happends? And what to do about it? We have users 
accessing the filearea from both Windows and Linux so it's hard to keep 
those pesky uid's away. Any way to disable this or work around it?

// Mattias




_______________________________________________
ProFTPD Users List   <[email protected]>
Unsubscribe problems?
http://www.proftpd.org/list-unsub.html