Forums

Resolved
0 votes
Hello

I've 4 users and 2 remaining licenses in my ClearOS 7 Home edition.
Where are my 4 other licenses ?

http://i68.tinypic.com/bi1pqo.png
Thursday, May 05 2016, 01:28 PM
Share this post:
Responses (6)
  • Accepted Answer

    Sunday, May 08 2016, 08:02 AM - #Permalink
    Resolved
    0 votes
    Hello Ben,

    I've reinstalling my server due some LDAP problems.... :( :( (see other post)
    After installing the ClearOS 7.2 everything was running perfect.

    When everything was set. i've installed Owncloud through marketplace.
    When i tried to install in Owncloud i could not log in.
    The problem was that the 'dbpassword' was not correct. In the dbpassword is a "/" and this was put in the owncloud/config.php as "\/\"
    After removing the both "/ /" is was working and could login.

    The LDAP setting were not in the config file, so i've put them in manually and it is now working.

    http://i63.tinypic.com/bgzku8.png

    I needed to change Objectclassess to "ownclouduser" and not to use the rawfilter.
    After clicking on the rawfilter, the same setting is returning and it is working......

    same as for groupfilter.
    The reply is currently minimized Show
  • Accepted Answer

    Friday, May 06 2016, 02:39 PM - #Permalink
    Resolved
    0 votes
    Hello ben,

    Thanks for the work around. Some how i've a problem with my LDAP.
    I've made a new post for this, so this thread in not contaminated.
    The reply is currently minimized Show
  • Accepted Answer

    Friday, May 06 2016, 01:59 PM - #Permalink
    Resolved
    0 votes
    Hi Patrick,

    You shouldn't have to create users via the ownCloud admin account, since, as you've seen, it creates them in a separate island, whereas, everything *should* be in the OpenLDAP.

    I'm am by no means an expert in ownCloud, but I dug around a bit on my system, here's what I was able to find out and perhaps those with more knowledge can chime in.

    #1. On my system too, folders for users appear to be using the UUID instead of the username:

    drwxr-xr-x 7 apache apache 4096 Dec 27 17:21 945fa794-412c-1035-806b-55dce2551a0c
    drwxr-xr-x 5 apache apache 4096 Nov 16 10:02 a8283132-18ec-1035-9cb8-911b0795f79e
    drwxr-xr-x 4 apache apache 4096 Nov 9 14:46 admin
    -rw-r--r-- 1 apache apache 0 Nov 13 12:02 index.html
    -rw-r--r-- 1 apache apache 0 Mar 30 11:21 owncloud.log


    Seems like things still work, but this could be annoying for maintenance/backup etc. in identifying stuff easily.

    There is a long thread on ownCloud's forums about this same issue dating back to 2013...hard to believe it's still an issue in ownCloud 8 on ClearOS 7, so I'd imagine it's something we're doing incorrectly.

    #2. When I logged into ownCloud as admin and click on the admin section and took a look at the LDAP wizard settings, this is what I saw:

    https://ibin.co/2gE0vIEYxxGA.png

    Zero users? Wah?

    Looking at groups, it was the same thing...zero groups, even though I had created some groups via Webconfig.

    Clicking on the (non obvious) "Edit raw filter instead", I set the "only those object classes" to ownCloudUser and voila! my users appeared. Doing the same to groups, but selecting "posixGroups" did the same for groups.

    Thinking 'aha', I found something that will help Patrick, I changed back to the old settings to document the process...something even stranger happened...putting in the old values did not reset the found user/groups to zero, but instead showed the correct totals.

    https://ibin.co/2gE2O9GuuoRD.png

    Very strange...so it looks like the action of changing and configuring the same settings 'jumps starts' things and if the admin tool can identify that you have X groups, I'll bet your need to creating users via admin will disappear because the groups will show up in the user's ownCloud interface and allow for sharing that way.

    Maybe this is enough to get this working as you need it, and we (experts included, not just me!) could circle around and figure out how to make sure this all works out of the box.

    B.
    The reply is currently minimized Show
  • Accepted Answer

    Friday, May 06 2016, 09:52 AM - #Permalink
    Resolved
    0 votes
    maybe this helps.
    I see these errors in /var/log/messages.log

    May  6 11:42:58 pdebrabander ownCloud[12004]: {user_ldap} Error when searching: Bad search filter code -7
    May 6 11:42:58 pdebrabander ownCloud[12004]: {user_ldap} Attempt for Paging? 1
    May 6 11:42:58 pdebrabander ownCloud[12004]: {user_ldap} Error when searching: Bad search filter code -7
    May 6 11:42:58 pdebrabander ownCloud[12004]: {user_ldap} Attempt for Paging? 1
    May 6 11:42:58 pdebrabander ownCloud[12004]: {user_ldap} Error when searching: Bad search filter code -7
    May 6 11:42:58 pdebrabander ownCloud[12004]: {user_ldap} Attempt for Paging? 1
    May 6 11:42:58 pdebrabander ownCloud[12004]: {user_ldap} Error when searching: Bad search filter code -7
    May 6 11:42:58 pdebrabander ownCloud[12004]: {user_ldap} Attempt for Paging? 1
    May 6 11:42:58 pdebrabander ownCloud[7950]: {user_ldap} Error when searching: Bad search filter code -7
    May 6 11:42:58 pdebrabander ownCloud[7950]: {user_ldap} Attempt for Paging? 1
    May 6 11:42:58 pdebrabander ownCloud[7950]: {user_ldap} Error when searching: Bad search filter code -7
    May 6 11:42:58 pdebrabander ownCloud[7950]: {user_ldap} Attempt for Paging? 1
    May 6 11:42:58 pdebrabander ownCloud[14798]: {user_ldap} Error when searching: Bad search filter code -7
    May 6 11:42:58 pdebrabander ownCloud[14798]: {user_ldap} Attempt for Paging? 1
    May 6 11:42:58 pdebrabander ownCloud[14798]: {user_ldap} Error when searching: Bad search filter code -7
    May 6 11:42:58 pdebrabander ownCloud[14798]: {user_ldap} Attempt for Paging? 1
    May 6 11:42:58 pdebrabander ownCloud[7437]: {user_ldap} Error when searching: Bad search filter code -7
    May 6 11:42:58 pdebrabander ownCloud[7437]: {user_ldap} Attempt for Paging? 1
    May 6 11:42:58 pdebrabander ownCloud[7437]: {user_ldap} Error when searching: Bad search filter code -7
    May 6 11:42:58 pdebrabander ownCloud[7437]: {user_ldap} Attempt for Paging? 1
    May 6 11:43:02 pdebrabander ownCloud[7126]: {user_ldap} Error when searching: Bad search filter code -7
    May 6 11:43:02 pdebrabander ownCloud[7126]: {user_ldap} Attempt for Paging? 1
    May 6 11:43:02 pdebrabander ownCloud[7126]: {user_ldap} Error when searching: Bad search filter code -7
    May 6 11:43:02 pdebrabander ownCloud[7126]: {user_ldap} Attempt for Paging? 1
    May 6 11:43:02 pdebrabander ownCloud[7333]: {user_ldap} Error when searching: Bad search filter code -7
    May 6 11:43:02 pdebrabander ownCloud[7333]: {user_ldap} Attempt for Paging? 1
    May 6 11:43:02 pdebrabander ownCloud[7333]: {user_ldap} Error when searching: Bad search filter code -7
    May 6 11:43:02 pdebrabander ownCloud[7333]: {user_ldap} Attempt for Paging? 1
    May 6 11:43:06 pdebrabander ownCloud[14896]: {user_ldap} Error when searching: Bad search filter code -7
    May 6 11:43:06 pdebrabander ownCloud[14896]: {user_ldap} Attempt for Paging? 1
    The reply is currently minimized Show
  • Accepted Answer

    Friday, May 06 2016, 06:22 AM - #Permalink
    Resolved
    0 votes
    Hello ben,

    This is the output:


    MariaDB [owncloud]> select * from oc_users;
    +---------+-------------+----------------------------------------------------------------+
    | uid | displayname | password |
    +---------+-------------+----------------------------------------------------------------+
    | admin | NULL | 1|xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
    | jordy | NULL | 1|xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
    | linda | NULL | 1|xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
    | patrick | NULL | 1|xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
    | thomas | NULL | 1|xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
    +---------+-------------+----------------------------------------------------------------+
    5 rows in set (0.00 sec)



    I also created the users in Owncloud, because wanted to make a shared group for the users.
    The default groups from Clearos are not available in Owncloud

    http://i66.tinypic.com/x2rmyu.png

    The directory names are strange names when you use them through ClearOS.
    When you add the uses in Owncloud the directory is the same as the user name

    http://i64.tinypic.com/okptep.png

    I don't see the subscription waring from Owncloud any more.
    Is this correct ??

    http://i64.tinypic.com/2n9hxc9.png
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, May 05 2016, 04:10 PM - #Permalink
    Resolved
    0 votes
    My guess looking at the code is that you've created (somehow) OC users in the database directly, as well as in LDAP. Would be interesting to see results of the following (don't need your db password!):

    [code]
    cat /var/clearos/system_database/owncloud
    password = xxxxxxxxxxxxxxxx
    [root@chambers libraries]# /usr/clearos/sandbox/usr/bin/mysql -uowncloud owncloud -pxxxxxxxxxxxxxxxx
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A

    Welcome to the MariaDB monitor. Commands end with ; or \g.
    Your MariaDB connection id is 24808
    Server version: 5.5.41-MariaDB MariaDB Server

    Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

    MariaDB [owncloud]> select * from oc_users;
    +-------+-------------+----------------------------------------------------------------+
    | uid | displayname | password |
    +-------+-------------+----------------------------------------------------------------+
    | admin | NULL | xxxxx|
    +-------+-------------+----------------------------------------------------------------+
    1 row in set (0.01 sec)
    The reply is currently minimized Show
Your Reply