COmanage Users List

[Niels van Dijk <>]

On 08-03-14 02:46, Benn Oshrin wrote:
> On 3/7/14 5:40 AM, Niels van Dijk wrote:
> 
>> I think what was missing initially is that an invite cannot be send as
>> long as there is no email for the organizational identity. That is very
>> logical, however some sort of message stating why the page "Find a
>> Person to Invite to" is empty (I assume because there are no emails
>> configured?) would have helped ;)
> 
> That page would be empty only if there are no org identities defined. If
> you try to invite an org identity with no email address, you'll get an
> error message to that effect.
> 
> Definitely room for improved documentation, though.
> 
>> However, altough I think I now have a user in the admin group of the CO,
>> this user is still not able to administer the CO after a new login (see
>> screenshot). Anything else I need to configure?
> 
> How do you know they cannot administer the CO? Do you get some sort of
> error message? What do you see in the Collaborations > Testing CoManage
> menu when you log in as "Student number 3"? (Since the black bar is
> truncated, I can't see who you are logged in as.)
> 
I can log in as "Student nr 3". The "Collaborations" button is
available, however selecting it is not possible. The dropdown menu seems
to have no sub menu items that can be displayed.

In the source of the HTML I do not see the submenu items:

<div id="row3">
<div class="contentWidth">
<ul class="sf-menu sf-js-enabled">
<li class="dropMenu">
<a class="menuTop">
<span> Collaborations </span>
<span class="sf-sub-indicator"> »</span>
</a>
</li>
</ul>
</div>
</div>
</div>

Find attached the query debug output.

Cheers,
Niels

Nr      Query   Error   Affected        Num. rows       Took (ms)
1       SELECT `Identifier`.`id`, `Identifier`.`identifier`, 
`Identifier`.`type`, `Identifier`.`login`, `Identifier`.`status`, 
`Identifier`.`co_person_id`, `Identifier`.`org_identity_id`, 
`Identifier`.`created`, `Identifier`.`modified` FROM 
`comanage_registry`.`cm_identifiers` AS `Identifier` WHERE 
`Identifier`.`identifier` = 
''
 AND `Identifier`.`login` = '1' AND `Identifier`.`status` = 'A' ORDER BY 
`identifier` ASC LIMIT 1              1       1       0
2       SELECT `CoOrgIdentityLink`.`id`, `CoOrgIdentityLink`.`co_person_id` 
FROM `comanage_registry`.`cm_co_org_identity_links` AS `CoOrgIdentityLink` 
WHERE `CoOrgIdentityLink`.`org_identity_id` = 2 ORDER BY 
`CoOrgIdentityLink`.`id` ASC            0       0       0
3       SELECT `Identifier`.`id`, `Identifier`.`identifier`, 
`Identifier`.`type`, `Identifier`.`login`, `Identifier`.`status`, 
`Identifier`.`co_person_id`, `Identifier`.`org_identity_id`, 
`Identifier`.`created`, `Identifier`.`modified` FROM 
`comanage_registry`.`cm_identifiers` AS `Identifier` WHERE 
`Identifier`.`identifier` = 
''
 AND `Identifier`.`login` = '1' AND `Identifier`.`status` = 'A' ORDER BY 
`identifier` ASC LIMIT 1              1       1       0
4       SELECT `CoOrgIdentityLink`.`id`, `CoOrgIdentityLink`.`co_person_id` 
FROM `comanage_registry`.`cm_co_org_identity_links` AS `CoOrgIdentityLink` 
WHERE `CoOrgIdentityLink`.`org_identity_id` = 2 ORDER BY 
`CoOrgIdentityLink`.`id` ASC            0       0       0
5       SELECT `Identifier`.`id`, `Identifier`.`identifier`, 
`Identifier`.`type`, `Identifier`.`login`, `Identifier`.`status`, 
`Identifier`.`co_person_id`, `Identifier`.`org_identity_id`, 
`Identifier`.`created`, `Identifier`.`modified` FROM 
`comanage_registry`.`cm_identifiers` AS `Identifier` WHERE 
`Identifier`.`identifier` = 
''
 AND `Identifier`.`login` = '1' AND `Identifier`.`status` = 'A' ORDER BY 
`identifier` ASC LIMIT 1              1       1       0
6       SELECT `CoOrgIdentityLink`.`id`, `CoOrgIdentityLink`.`co_person_id` 
FROM `comanage_registry`.`cm_co_org_identity_links` AS `CoOrgIdentityLink` 
WHERE `CoOrgIdentityLink`.`org_identity_id` = 2 ORDER BY 
`CoOrgIdentityLink`.`id` ASC            0       0       0
7       SELECT `Identifier`.`id`, `Identifier`.`identifier`, 
`Identifier`.`type`, `Identifier`.`login`, `Identifier`.`status`, 
`Identifier`.`co_person_id`, `Identifier`.`org_identity_id`, 
`Identifier`.`created`, `Identifier`.`modified` FROM 
`comanage_registry`.`cm_identifiers` AS `Identifier` WHERE 
`Identifier`.`identifier` = 
''
 AND `Identifier`.`login` = '1' AND `Identifier`.`status` = 'A' ORDER BY 
`identifier` ASC LIMIT 1              1       1       0
8       SELECT `CoOrgIdentityLink`.`id`, `CoOrgIdentityLink`.`co_person_id` 
FROM `comanage_registry`.`cm_co_org_identity_links` AS `CoOrgIdentityLink` 
WHERE `CoOrgIdentityLink`.`org_identity_id` = 2 ORDER BY 
`CoOrgIdentityLink`.`id` ASC            0       0       0
9       SELECT `OrgIdentity`.`o`, `OrgIdentity`.`id` FROM 
`comanage_registry`.`cm_org_identities` AS `OrgIdentity` LEFT JOIN 
`comanage_registry`.`cm_organizations` AS `Organization` ON 
(`OrgIdentity`.`organization_id` = `Organization`.`id`) LEFT JOIN 
`comanage_registry`.`cm_cos` AS `Co` ON (`OrgIdentity`.`co_id` = `Co`.`id`) 
LEFT JOIN `comanage_registry`.`cm_names` AS `PrimaryName` ON 
(`PrimaryName`.`org_identity_id` = `OrgIdentity`.`id` AND 
`PrimaryName`.`primary_name` = '1') WHERE `OrgIdentity`.`id` = 2 LIMIT 1      
    1       1       0
10      SELECT `Address`.`id`, `Address`.`line1`, `Address`.`line2`, 
`Address`.`locality`, `Address`.`state`, `Address`.`postal_code`, 
`Address`.`country`, `Address`.`type`, `Address`.`language`, 
`Address`.`co_person_role_id`, `Address`.`org_identity_id`, 
`Address`.`created`, `Address`.`modified` FROM 
`comanage_registry`.`cm_addresses` AS `Address` WHERE 
`Address`.`org_identity_id` = (2)          0       0       0
11      SELECT `CoOrgIdentityLink`.`id`, `CoOrgIdentityLink`.`co_person_id`, 
`CoOrgIdentityLink`.`org_identity_id`, `CoOrgIdentityLink`.`created`, 
`CoOrgIdentityLink`.`modified` FROM 
`comanage_registry`.`cm_co_org_identity_links` AS `CoOrgIdentityLink` WHERE 
`CoOrgIdentityLink`.`org_identity_id` = (2)          0       0       0
12      SELECT `CoPetition`.`id`, `CoPetition`.`co_enrollment_flow_id`, 
`CoPetition`.`co_id`, `CoPetition`.`cou_id`, 
`CoPetition`.`enrollee_org_identity_id`, 
`CoPetition`.`enrollee_co_person_id`, 
`CoPetition`.`enrollee_co_person_role_id`, 
`CoPetition`.`petitioner_co_person_id`, `CoPetition`.`sponsor_co_person_id`, 
`CoPetition`.`approver_co_person_id`, `CoPetition`.`co_invite_id`, 
`CoPetition`.`status`, `CoPetition`.`created`, `CoPetition`.`modified` FROM 
`comanage_registry`.`cm_co_petitions` AS `CoPetition` WHERE 
`CoPetition`.`enrollee_org_identity_id` = (2)            0       0       0
13      SELECT `EmailAddress`.`id`, `EmailAddress`.`mail`, 
`EmailAddress`.`type`, `EmailAddress`.`verified`, 
`EmailAddress`.`co_person_id`, `EmailAddress`.`org_identity_id`, 
`EmailAddress`.`created`, `EmailAddress`.`modified` FROM 
`comanage_registry`.`cm_email_addresses` AS `EmailAddress` WHERE 
`EmailAddress`.`org_identity_id` = (2)          1       1       0
14      SELECT `HistoryRecord`.`id`, `HistoryRecord`.`co_person_id`, 
`HistoryRecord`.`co_person_role_id`, `HistoryRecord`.`org_identity_id`, 
`HistoryRecord`.`actor_co_person_id`, `HistoryRecord`.`action`, 
`HistoryRecord`.`comment`, `HistoryRecord`.`created`, 
`HistoryRecord`.`modified` FROM `comanage_registry`.`cm_history_records` AS 
`HistoryRecord` WHERE `HistoryRecord`.`org_identity_id` = (2)            3    
   3       0
15      SELECT `Identifier`.`id`, `Identifier`.`identifier`, 
`Identifier`.`type`, `Identifier`.`login`, `Identifier`.`status`, 
`Identifier`.`co_person_id`, `Identifier`.`org_identity_id`, 
`Identifier`.`created`, `Identifier`.`modified` FROM 
`comanage_registry`.`cm_identifiers` AS `Identifier` WHERE 
`Identifier`.`org_identity_id` = (2)                1       1       0
16      SELECT `Name`.`id`, `Name`.`honorific`, `Name`.`given`, 
`Name`.`middle`, `Name`.`family`, `Name`.`suffix`, `Name`.`type`, 
`Name`.`language`, `Name`.`co_person_id`, `Name`.`org_identity_id`, 
`Name`.`primary_name`, `Name`.`created`, `Name`.`modified` FROM 
`comanage_registry`.`cm_names` AS `Name` WHERE `Name`.`org_identity_id` = (2) 
            1       1       0
17      SELECT `TelephoneNumber`.`id`, `TelephoneNumber`.`number`, 
`TelephoneNumber`.`type`, `TelephoneNumber`.`co_person_role_id`, 
`TelephoneNumber`.`org_identity_id`, `TelephoneNumber`.`created`, 
`TelephoneNumber`.`modified` FROM `comanage_registry`.`cm_telephone_numbers` 
AS `TelephoneNumber` WHERE `TelephoneNumber`.`org_identity_id` = (2)         
0       0       0
18      SELECT `CmpEnrollmentConfiguration`.`pool_org_identities` FROM 
`comanage_registry`.`cm_cmp_enrollment_configurations` AS 
`CmpEnrollmentConfiguration` WHERE `CmpEnrollmentConfiguration`.`name` = 'CMP 
Enrollment Configuration' AND `CmpEnrollmentConfiguration`.`status` = 'A' 
ORDER BY `name` ASC LIMIT 1            1       1       0
19      SELECT `NavigationLink`.`title`, `NavigationLink`.`url` FROM 
`comanage_registry`.`cm_navigation_links` AS `NavigationLink` WHERE 1 = 1 
ORDER BY `NavigationLink`.`ordr` ASC             0       0       0
20      SELECT `CoNavigationLink`.`title`, `CoNavigationLink`.`url` FROM 
`comanage_registry`.`cm_co_navigation_links` AS `CoNavigationLink` LEFT JOIN 
`comanage_registry`.`cm_cos` AS `Co` ON (`CoNavigationLink`.`co_id` = 
`Co`.`id`) WHERE `CoNavigationLink`.`co_id` = -1 ORDER BY 
`CoNavigationLink`.`ordr` ASC             0       0       0