Re: [Proftpd-user] [SPAM] Re: Proftpd with SQL and problem with groups

W dniu 2023-03-10 00:59, TJ Saunders napisał(a):
>> The problem is with groups unfortunatelly. I've set few groups and 
>> users
>> and I see groups don't work. In documentation of that app is written
>> permission to accounts folders should be 775 so I have these exactly 
>> and
>> it doean't work because users can enter accounts they don't should.
> 
> Can you provide some of the GIDs, configured in your tables, that
> should be being retrieved, and are not?
> 
> One of the most common surprises with mod_sql, and groups, is that it
> has a default filtering of GID values; see _e.g._:
> 
>   http://www.proftpd.org/docs/contrib/mod_sql.html#SQLMinUserGID
> 
> So if the GID values that should be being used are less than the
> filter value (999 by default), then mod_sql will return the
> SQLDefaultGID value instead.
> 
> Could this be happening for you?  The ProFTPD debug logging, from when
> a client authenticates, could help show whether it is this issue, or
> something else:
> 
>   http://www.proftpd.org/docs/howto/Debugging.html
> 
> Cheers,
> TJ
> 
> 
> _______________________________________________
> ProFTPD Users List   <[email protected]>
> Unsubscribe problems?
> http://www.proftpd.org/list-unsub.html

Hi,
Groups table:
+-----------+------+---------------+
| groupname | gid  | members       |
+-----------+------+---------------+
| pierwsza  | 2021 | pawel,piotrek |
| default   | 2001 |               |
| druga     | 2022 | tomek,karol   |
| trzecia   | 2023 | piotrek,tomek |
| czwarta   | 2024 | piotrek,karol |
+-----------+------+---------------+

User UIDs are also are above 2000.
In Proftpd configuration I don't have any parameter about min, max UIDs 
and Gids. So should I set anything yet in this case ?


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