[Owncloud] How to manage thousands of users?

[Soma Kashyap]

here you go...


+--------+----------------+---------------+-------------+
| userid | appid          | configkey     | configvalue |
+--------+----------------+---------------+-------------+
| admin  | files          | cache_version | 5           |
| admin  | firstrunwizard | show          | 0           |
+--------+----------------+---------------+-------------+
2 rows in set (0.00 sec)




On Mon, Sep 30, 2013 at 10:17 AM, CJ Keist <cj.keist at colostate.edu> wrote:

> Could someone send me the the table structure for oc_preferneces? For some
> reason my database doesn't have it.
>
> On 9/27/13 4:18 PM, Stefan Vollmar wrote:
>
>> Dear CJ Keist,
>>
>> On 27.09.2013, at 22:28, CJ Keist <cj.keist at colostate.edu> wrote:
>>
>>  The web interface doesn't look to have the ability to list thousands of
>>> users on my owncloud system. So there is no way for me to set custom disk
>>> quotas for users that are not displayed on the web interface.  I have tried
>>> the search function on the page but that doesn't work.
>>> So I tried to see where disk quota settings are stored on the mysql
>>> database but have not had any luck finding where that value is set per user
>>> account.  Could someone direct me on how I can set default disk quota for
>>> users on my system?
>>>
>>
>> I am not sure that this is the "official" way of doing things but I would
>> suggest a different approach: if you use the MySQL backend, it seems to be
>> pretty straightforward to set all sorts of parameters with a few lines of
>> SQL code. In fact, this is similar to our own automated method of creating
>> a large number of users in OwnCloud and sending automatically generated
>> E-mails with activation links (tokens).
>>
>> With OwnCloud 5, you can look up user data in the oc_user table (here:
>> "aeinstein" is the "uid" of "Albert Einstein"), you can then set a quota of
>> 10 GB like this:
>>
>> INSERT INTO `oc_preferences` VALUES
>>   ('aeinstein','files','quota','**10 GB');
>>
>> If you have a list of uids it is very easy to repeat that line as often
>> as required.
>>
>> Warm regards,
>>   Stefan
>>
>>
>>>
>>> --
>>> C. J. Keist                     Email: cj.keist at colostate.edu
>>> Systems Group Manager           Solaris 10 OS (SAI)
>>> Engineering Network Services    Phone: 970-491-0630
>>> College of Engineering, CSU     Fax:   970-491-5569
>>> Ft. Collins, CO 80523-1301
>>>
>>> All I want is a chance to prove 'Money can't buy happiness'
>>>
>>> ______________________________**_________________
>>> Owncloud mailing list
>>> Owncloud at kde.org
>>> https://mail.kde.org/mailman/**listinfo/owncloud<https://mail.kde.org/mailman/listinfo/owncloud>
>>>
>>
>>
> --
> C. J. Keist                     Email: cj.keist at colostate.edu
> Systems Group Manager           Solaris 10 OS (SAI)
> Engineering Network Services    Phone: 970-491-0630
> College of Engineering, CSU     Fax:   970-491-5569
> Ft. Collins, CO 80523-1301
>
> All I want is a chance to prove 'Money can't buy happiness'
> ______________________________**_________________
> Owncloud mailing list
> Owncloud at kde.org
> https://mail.kde.org/mailman/**listinfo/owncloud<https://mail.kde.org/mailman/listinfo/owncloud>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/owncloud/attachments/20130930/3109226a/attachment.html>