[Owncloud] User account search ability

[CJ Keist]

I don't think I'm seeing any errors in the log file.  I did a grep for 
just "preferences" and this is what I got of the log file. Hard to tell 
if these errors is do to the missing table.

egrep -i preferences owncloud.log
{"app":"PHP","message":"fopen(\/tmp\/2dc91675031689a145abef29907ac714.0\/Preferences\/Collab\/Temp\/CollabPROTOCOL_A_TO_B): 
failed to open stream: No such file or directory at 
\/var\/www\/owncloud\/apps\/files_external\/3rdparty\/phpseclib\/phpseclib\/Net\/SFTP.php#1517","level":2,"time":1368115312}
{"app":"PHP","message":"fopen(\/tmp\/2dc91675031689a145abef29907ac714.0\/Preferences\/Collab\/Temp\/CollabPROTOCOL_A_TO_B): 
failed to open stream: No such file or directory at 
\/var\/www\/owncloud\/apps\/files_external\/lib\/sftp.php#205","level":2,"time":1368115312}
{"app":"PHP","message":"fopen(\/tmp\/f1ae3ebd731351009b8f85158af1ff34.0\/Preferences\/reader_prefs): 
failed to open stream: No such file or directory at 
\/var\/www\/owncloud\/lib\/helper.php#537","level":2,"time":1368115316}
{"app":"PHP","message":"fopen(\/tmp\/f1ae3ebd731351009b8f85158af1ff34.0\/Preferences\/reader_prefs): 
failed to open stream: No such file or directory at 
\/var\/www\/owncloud\/apps\/files_external\/3rdparty\/phpseclib\/phpseclib\/Net\/SFTP.php#1517","level":2,"time":1368115316}
{"app":"PHP","message":"fopen(\/tmp\/f1ae3ebd731351009b8f85158af1ff34.0\/Preferences\/reader_prefs): 
failed to open stream: No such file or directory at 
\/var\/www\/owncloud\/apps\/files_external\/lib\/sftp.php#205","level":2,"time":1368115316}
[root at cloud data]#


On 5/13/13 9:43 AM, Arthur Schiwon wrote:
> On 05/13/2013 05:18 PM, CJ Keist wrote:
>> Thank you for the LDAP information.
>>
>> My owncloud database doesn't have a oc_preferences table, see attached
>> pic of my database.  So wondering how it is storing the current quota I
>> have set???
>
> No, it should be there. Do you see any error in your owncloud.log that
> it could not have been created? It is a core table [1], i.e. is always
> created on install.
>
> Cheers
> Arthur
>
> [1] https://github.com/owncloud/core/blob/stable5/db_structure.xml#L563
>
>>
>>
>> On 5/13/13 5:19 AM, Arthur Schiwon wrote:
>>> On 05/08/2013 09:17 PM, CJ Keist wrote:
>>>> I'd love to do that, is it documented somewhere?  We use inetOrgPerson
>>>> scheme and it doesn't look like it has place for disk quota storage.
>>>
>>> On ownCloud side, you can specify the attribute is described here
>>> http://doc.owncloud.org/server/5.0/admin_manual/configuration/auth_ldap.html#special-attributes
>>>
>>>
>>>
>>>
>>> On LDAP side you would need to extend/customize your schema. How to do
>>> that your servers manual should tell you, e.g. openLDAP:
>>> http://www.openldap.org/doc/admin24/schema.html
>>>
>>>> Where is the current disk quota for accounts being stored? I cannot
>>>> find
>>>> it anywhere in the MySQL tables or local files on the server.
>>>
>>> IIRC in the table oc_preferences
>>>
>>> Cheers
>>> Arthur
>>>
>>>
>>>>
>>>>
>>>>
>>>> On 5/8/13 11:14 AM, Arthur Schiwon wrote:
>>>>> Why don't you manage quota via LDAP attribute?
>>>>>
>>>>> CJ Keist <cj.keist at colostate.edu> wrote:
>>>>>
>>>>>     Hello,
>>>>>     Just request on owncloud server. When looking at user accounts
>>>>> with
>>>>>     the admin account, there is no way to search for login names.
>>>>> With
>>>>>     thousands of accounts this is a big issue when you are trying to
>>>>> modify
>>>>>     an account disk quota setting.
>>>>>
>>>>>     Where are the disk quota settings for each account stored in the
>>>>>     database?  We are using LDAP back end for authentication.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Sent from my Android phone with K-9 Mail. Please excuse my brevity.
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Owncloud mailing list
>>>>> Owncloud at kde.org
>>>>> https://mail.kde.org/mailman/listinfo/owncloud
>>>>>
>>>>
>>> _______________________________________________
>>> Owncloud mailing list
>>> Owncloud at kde.org
>>> https://mail.kde.org/mailman/listinfo/owncloud
>>
>>
>>
>> _______________________________________________
>> Owncloud mailing list
>> Owncloud at kde.org
>> https://mail.kde.org/mailman/listinfo/owncloud
>>
> _______________________________________________
> Owncloud mailing list
> Owncloud at kde.org
> 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'