Re: [Proftpd-user] mod_sql backend error: could not lookup local user ID

Oli Kessler <[email protected]>
Newsgroups gmane.network.proftpd.user
Message-ID <[email protected]>
Hi all

Here is a short update to this issue:

* We could not disable "DefaultRoot ~" as this is a system for multiple users which must be isolated from each other 
* We had enabled "SQLOptions NoDisconnectOnError” which helped the last couple of weeks

We currently see more occurrences of the issue again and "SQLOptions NoDisconnectOnError” does not seem to help anymore, the session is terminated with

ProFTPD terminating (signal 11)
mod_sql/4.3: unrecoverable backend error: (mod_sql_postgres/4.0.4) could not look up local user ID 1001: No such file or directory#012
mod_sql/4.3: check the SQLLogFile for more details
mod_sql/4.3: unrecoverable backend error: (mod_sql_postgres/4.0.4) could not look up local user ID 1001: No such file or directory#012
mod_sql/4.3: check the SQLLogFile for more details
mod_sql/4.3: unrecoverable backend error: (mod_sql_postgres/4.0.4) could not look up local user ID 1001: No such file or directory#012
mod_sql/4.3: check the SQLLogFile for more details
mod_sql/4.3: unrecoverable backend error: (mod_sql_postgres/4.0.4) could not look up local user ID 1001: No such file or directory#012
mod_sql/4.3: check the SQLLogFile for more details
SSH2 session closed

Any news on the original chroot pg library issue?

Cheers
-ok

> On 05 Jun 2017, at 23:24, Oli Kessler <[email protected]> wrote:
> 
> Thanks TJ!
> 
> We use “DefaultRoot ~” and this explication seems very reasonable.
> 
> I’ll check if we can disable this and see any different behaviour.
> 
> In the meantime, we use "SQLOptions NoDisconnectOnError” which seems to help - the sql error is now swallowed and the file upload operations seem to succeed, no temporary files left behind.
> 
> Cheers
> -ok
> 
>> 

--
Oli Kessler
[email protected]

CargoServer AG
Badenerstrasse 623
CH-8048 Zürich
+41 44 552 22 80
https://www.cargoserver.ch


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
ProFTPD Users List   <[email protected]>
Unsubscribe problems?
http://www.proftpd.org/list-unsub.html
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.