LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   Proftpd with SQL and problem with groups (https://www.linuxquestions.org/questions/linux-server-73/proftpd-with-sql-and-problem-with-groups-4175722869/)

lkisiel 03-09-2023 09:26 AM

Proftpd with SQL and problem with groups
 
Hi,
I've installed that app for managing accounts:
https://github.com/ChristianBeer/ProFTPd-Admin
Underneath there is Proftpd with Mysql and together with that app is working - I mean I can log to FTP with accounts from that app.

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.

Configuration in proftpd of sql.conf looks like that:
Code:

<IfModule mod_sql.c>

SQLBackend              mysql
SQLEngine              on
SQLAuthenticate        on
SQLPasswordEngine      on

SQLAuthTypes SHA1
SQLAuthenticate users groups

SQLConnectInfo          proftpd2@localhost ftp 123w
SQLUserInfo            users userid passwd uid gid homedir shell
SQLGroupInfo            groups groupname gid members
SQLUserWhereClause      "disabled != 1"
SQLLog PASS            updatecount
SQLNamedQuery          updatecount UPDATE "login_count=login_count+1, last_login=now() WHERE userid='%u'" users

 # Used to track xfer traffic per user (without invoking a quota)
SQLLog RETR            bytes-out-count
SQLNamedQuery          bytes-out-count UPDATE "bytes_out_used=bytes_out_used+%b WHERE userid='%u'" users
SQLLog RETR            files-out-count
SQLNamedQuery          files-out-count UPDATE "files_out_used=files_out_used+1 WHERE userid='%u'" users

SQLLog STOR            bytes-in-count
SQLNamedQuery          bytes-in-count UPDATE "bytes_in_used=bytes_in_used+%b WHERE userid='%u'" users
SQLLog STOR            files-in-count
SQLNamedQuery          files-in-count UPDATE "files_in_used=files_in_used+1 WHERE userid='%u'" users


</IfModule>

Tables in Mysql are correct and consists users and groups as should.
So what can be wrong here ?
Thanks

lkisiel 03-22-2023 04:47 PM

Answer here:
https://sourceforge.net/p/proftp/mai...l/#msg37788200
Cheers


All times are GMT -5. The time now is 07:18 PM.