[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pureftpd-list
Subject:    Re: [pure-ftpd] mysql and quota
From:       "Charles Hill" <charles.e.hill () gmail ! com>
Date:       2007-08-01 17:29:12
Message-ID: 588c15450708011029p3253f0f3w334c573021beccf1 () mail ! gmail ! com
[Download RAW message or body]


pure-quotacheck



On 8/1/07, Samuel Vogel <samy-delux@gmx.de> wrote:
>
> Do I see it right, that only files actually Uploaded through pureftpd
> will be accounted for the quota?
> If so, how can I refresh the .ftpquota file of multiple users like
> /data/user1, /data/user2/ ... etc. ?
>
> Charles Hill schrieb:
> > No, just make sure they don't have write permission.  chmod 0400 should
> do
> > it.
> >
> >
> > On 8/1/07, Samuel Vogel <samy-delux@gmx.de> wrote:
> >
> >> I actually have to admit, that it works now...
> >> I can't explain to mysql why, but it does.
> >> 3 days ago I uploaded 3 10MB files and the quota wouldn't get exceeded.
> >> O well.
> >>
> >> So should I chown the .ftpquota to root, to prevent my users from
> >> exceeding it ?
> >>
> >> Charles Hill schrieb:
> >>
> >>> And?
> >>>
> >>> 3,723,203 bytes < 5 Mb
> >>>
> >>> You haven't gone over the quota.
> >>>
> >>>  Charles
> >>>
> >>> On 8/1/07, Samuel Vogel <samy-delux@gmx.de> wrote:
> >>>
> >>>
> >>>> June 29. was just the last time I uploaded something...
> >>>> I just uploaded a new file, while allready being over my quota. Here
> is
> >>>> how .ftpquota looks now:
> >>>>
> >>>> ls -al /data/apache/users/samy.newkilu.de/.ftpquota
> >>>> -rwx------ 1 www-data www-data        10 2007-08-01 14:22 .ftpquota
> >>>>
> >>>> # cat /data/apache/users/samy.newkilu.de/.ftpquota
> >>>> 4 3723203
> >>>>
> >>>> So it is read and updated. The quota is just not enforced.
> >>>> I just copied the MySQL command pureftpd issues from the log to the
> >>>> mysql shell:
> >>>>
> >>>> mysql> SELECT quota FROM users WHERE name="samy.newkilu.de" AND
> >>>> status="active";
> >>>> +-------+
> >>>> | quota |
> >>>> +-------+
> >>>> |     5 |
> >>>> +-------+
> >>>>
> >>>> As you can see it should be 5MB...
> >>>>
> >>>> Stefan Hornburg schrieb:
> >>>>
> >>>>
> >>>>> Samuel Vogel wrote:
> >>>>>
> >>>>>
> >>>>>> Yes, the uid and gid is www-data and .ftpquota looks like the
> >>>>>>
> >>>>>>
> >>>> following:
> >>>>
> >>>>
> >>>>>> -rwx------ 1 www-data www-data        10 2007-07-29 22:11 .ftpquota
> >>>>>>
> >>>>>>
> >>>>> What are the contents of the file ? It looks outdated to me.
> >>>>> Also you can strace pureftpd to determine if the file is read etc.
> >>>>>
> >>>>> Bye
> >>>>>     Racke
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>
> >
> >
>


[prev in list] [next in list] [prev in thread] [next in thread]