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 <[email protected]>: > 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 _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
