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

Pierre Casenove pcasenove at gmail.com
Thu Dec 8 10:50:22 UTC 2011


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




More information about the Spacewalk-list mailing list