[Owncloud] User account search ability

[CJ Keist]

Is there a way to re-create any missing tables in the owncloud database?



On 5/13/13 2:03 PM, CJ Keist wrote:
> 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'