[Spacewalk-list] Can't delete system

[Jan Pazdziora]

On Tue, Jan 10, 2012 at 05:42:28PM +0100, Jan Šoc wrote:
> Hi,
> i cant delete system from spacewalk, i have:
> 
> The following exception occurred while executing this request:
> POST /rhn/systems/details/DeleteConfirm.do
> 
> Date:1/10/12 1:10:21 PM CET
> Headers:
>   host: spacewalkserver.acme.com
>   user-agent: Mozilla/5.0 (X11; U; Linux x86_64; cs-CZ; rv:1.9.2.24) Gecko/20111107 Ubuntu/10.04 (lucid) Firefox/3.6.24
>   accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
>   accept-language: cs,en-us;q=0.7,en;q=0.3
>   accept-encoding: gzip,deflate
>   accept-charset: windows-1250,utf-8;q=0.7,*;q=0.7
>   Keep-Alive: 115
>   connection: keep-alive
>   referer:https://spacewalkserver.acme.com/rhn/systems/details/DeleteConfirm.do?sid=1000010062
>   cookie: JSESSIONID=C5C5374F0B198B6C72FA3E704A743D5E; __utma=27782179.93297412.1323189392.1324643965.1325151856.7; __utmz=27782179.1323189392.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); owa_v=cdh%3D%3E85f6b788%7C%7C%7Cvid%3D%3E-234190141%7C%7C%7Cfsts%3D%3E1311829981%7C%7C%7Cnps%3D%3E22%7C%7C%7Cdsfs%3D%3E70; owa_s=cdh%3D%3E85f6b788%7C%7C%7Clast_req%3D%3E1317894202%7C%7C%7Csid%3D%3E1550386075%7C%7C%7Cdsps%3D%3E2%7C%7C%7Creferer%3D%3E%28none%29%7C%7C%7Cmedium%3D%3Edirect%7C%7C%7Csource%3D%3E%28none%29%7C%7C%7Csearch_terms%3D%3E%28none%29; jira.conglomerate.cookie=; pxt-session-cookie=192xea5055a9251f52f197bf6f396b9d1aa9
>   content-type: application/x-www-form-urlencoded
>   content-length: 67
> 
> Request:
> Local Name = spacewalkserver.acme.com
> Server Name = spacewalkserver.acme.com
> Requested Session Id came from Cookie
> Requested Session Valid = true
> Session = org.apache.catalina.session.StandardSessionFacade at 72b072bd[session=StandardSession[C5C5374F0B198B6C72FA3E704A743D5E]]
> Protocol = https
> Request Locale = en_US
> Request Character Encoding = UTF-8
> Attribute Names = rhnActiveLang, sid, org.apache.struts.action.ERROR, javax.servlet.jsp.jstl.fmt.timeZone.request, submittedForm, javax.servlet.request.key_size, requestedUri, javax.servlet.request.ssl_session, org.apache.struts.action.MESSAGE, system, session, __sitemesh__filterapplied, javax.servlet.request.cipher_suite, org.apache.struts.action.mapping.instance, org.apache.struts.action.MODULE,
> 
> Form Variables:
>   submitted: true
>   sid: 1000010062
>   button: Delete Profile
>   csrf_token: 2200245591428613372
> 
> 
> User Information:
> User geralt (id 1, org_id 1)
> 
> Exception:
> javax.servlet.ServletException: ERROR: function update_perms_for_user(numeric) does not exist

Please execute content of

	http://git.fedorahosted.org/git/?p=spacewalk.git;a=blob_plain;f=schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/004-update_perms_for_server_group.sql.postgresql;hb=HEAD

in your psql to see if it fixes the problem.

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat