[Spacewalk-list] upgrade to 1.5 and migrated to postgres... issues

[Jason Ball]

Two issues which are apparently related.

1. can't delete systems.

2. Can't register new systems.

In both cases the error is a call to the non existent routine:

HINT:  No function matches the given name and argument types. You might need
> to add explicit type casts.
> *QUERY:  SELECT  update_perms_for_user( $1 )*
> CONTEXT:  PL/pgSQL function "update_perms_for_server_group" line 22 at
> PERFORM
>

and

The following exception occurred while executing this request:
>
> POST /rhn/systems/details/DeleteConfirm.do
>


Exception:

javax.servlet.ServletException: ERROR: function
update_perms_for_user(numeric) does not exist

      at
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)



This procedure does not exist in the DB and the definition in main.sql would
throw an exception anyway:

create or replace function update_perms_for_server_group
> (
>   server_group_id_in in numeric
> )
> returns void
> as $$
> begin
>   raise exception 'Stub called, must be replace by .pkb';
> end;
> $$ language plpgsql;
>


Adding the stored procedure as defined in
/etc/sysconfig/rhn/postgres/main.sql doesn't solve the problem, it simply
prints the error "Stub called..." and errors out.

The second issue of not being able to register new systems using an
activation key occurs when there are 'group' listed in the activation key
and results in the 'rhn_reg' returning the error 'Internal Server Error'.
Removing the groups from the activation key allows the systems to be
registered, and you can manually assign the groups after registration.

Any suggestions or is this simply 'not supported' in postgres yet ?

Cheers
Jason.


-- 
--jason at ball.net
vk2flnx at google.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110818/b1e02247/attachment.htm>