[Spacewalk-list] Can't delete system

[Jan Šoc]

Dne 16.1.2012 16:31, Jan Pazdziora napsal(a):
> 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.
YES! it is working.
Thanks a lot.

Jan Šoc