[Proftpd-user] Proftpd with SQL and problem with groups

Good day all,

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:

<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 ?
Thank you.


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