[Owncloud] User account search ability

[Arthur Schiwon]

On Wednesday, May 15, 2013 02:00:33 PM CJ Keist wrote:
> Is there a way to re-create any missing tables in the owncloud database?

Easiest is probably to do a second install, and afterwards check how the 
missing table was created by
SHOW CREATE TABLE oc_preferences
subsequently execute what is returned in the target database.

Cheers
Arthur

> 
> 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\/P
> > references\/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\/P
> > references\/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\/P
> > references\/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\/P
> > references\/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\/P
> > references\/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