[Spacewalk-list] ISE on SW 1.5 on user management

[Pierre Casenove]

Any help on this one?

Thanks,

2011/12/8 Pierre Casenove <pcasenove at gmail.com>:
> Just a quick update:
> running the query in psql shell works (I forgot the select * at the
> beggining). So the query is correct.
> From the error log, I guess that an Integer is returned in case the
> user is ldap-enabled, and a Long for a regular user.
> But I wasn't able to find the code behind this.
>
> Pierre
>
> 2011/12/8 Pierre Casenove <pcasenove at gmail.com>:
>> Hello List,
>> I've plugged my SW 1.5 installation with PGSQL on a LDAP.
>> When I create a user with PAM authentication, and then going to Users
>> --> <ldapUser> --> Systems, I get an ISE.
>> If I navigate to this page on a non ldap user, I don't get an ISE.
>> I've attached the catalina.out logs.
>> Two errors appears:
>> First:
>> ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error
>> while processing cached statement sql: select * from (
>>  SELECT  DISTINCT S.id AS ID,
>>          S.name AS SERVER_NAME,
>>          (SELECT 1
>>          FROM rhnServerFeaturesView SFV
>>         WHERE SFV.server_id = S.id
>>           AND SFV.label = 'ftr_system_grouping') AS selectable
>>    FROM  rhnServer S, rhnUserServerPerms USP
>>   WHERE  USP.user_id = ?
>>     AND  S.id = USP.server_id
>> ) X
>> ORDER BY  UPPER(COALESCE(X.server_name, '(none)')), X.id
>>
>> --> When running it in psql, here is the output : ERROR:
>> syntax error at or near ")"
>> LINE 10: ) X
>>
>>
>> Second error:
>> Could not find method called: setSelectable in class:
>> com.redhat.rhn.frontend.dto.VisibleSystems with params: [type:
>> java.lang.Integer, value: 1]
>> Indeed, looking at the source code, it is public void
>> setSelectable(Long selectableIn)
>>
>>
>> Could you please point me to some clue? I can't find in the source
>> code where the query is built,  and I don't see what is erroneous in
>> the query.
>>
>> Thanks,
>>
>> Pierre