[Proftpd-user] Would like to do custom SqlGroupInfo query

[Jacques B. <jac...@cs...>]

Hi,

Follow-up...

Adding this feature to proftpd and using it with horde/gollem
would allow me to have a "users administrated" "read only or read/write"
rigths to a group of files.

Could be use as a flexible backend for horde/gollem.

Jacques Beaudoin
Agent d'administration
Les services des technologies
de l'information et des communications
Commission scolaire de la Pointe de l'=CEle


----- Message de jac...@cs... ---------
     Date : Sun, 29 Apr 2007 10:59:09 -0400
      De : Jacques Beaudoin <jac...@cs...>
R=E9pondre =E0 : Jacques Beaudoin <jac...@cs...>
  Objet : Would like to do custom SqlGroupInfo query
       =C0 : ProFTPD <pro...@li...>


> Hi,
>
> I have been doing custom SqlUserInfo query like this:
>
> SQLNamedQuery  info SELECT "U.userid, U.passwd, concat('5500'),
> concat('5500'), CONCAT('/proftpd/',U.ftpdir), concat('/sbin/nologin')
> FROM dbmail_users U WHERE U.userid =3D '%U' AND U.ftpdir !=3D '%U'"
> SQLUserInfo    custom:/info
>
> and now I would like to do custom SqlGroupInfo query like this:
>
> SQLNamedQuery  info SELECT "U.userid, concat('5500'), U.group FROM
> dbmail_users U WHERE U.userid =3D '%U'"
> SQLGroupInfo   custom:/info
>
> and I would use the result in
>
> <Limit WRITE>
> AllowGroup postmaster
> DenyAll
> </Limit>
>
>
> I don't think this is possible but can this be added to
> the next proftpd version 1.3.1
>
> I will help in testing.
>
> Thanks
>
> Jacques
>
>
>
>
>
> Best regards
>
> Jacques Beaudoin
> Agent d'administration
> Les services des technologies
> de l'information et des communications
> Commission scolaire de la Pointe de l'=CEle
>
>
>
>
> ----------------------------------------------------
> Ce message a =E9t=E9 achemin=E9 par le Webmail de la CSPI.


----- Fin du message de jac...@cs... -----


----------------------------------------------------
Ce message a =E9t=E9 achemin=E9 par le Webmail de la CSPI.