[Spacewalk-list] Spacewalk 0.2 available

[Jan-Frode Myklebust]

On Tue, Sep 16, 2008 at 03:52:34PM -0400, Jesus M. Rodriguez wrote:
> Fellow Spacewalk users,
>
> The Spacewalk team is proud to announce the release of Spacewalk 0.2.
> In a few hours, the repos will be accessible and you can install 0.2
> and try it out.

I'm struggeling getting this version working on rhel5, 64bit, with
database on external RAC (oracle 10.2.0.4).

Whenever I try to enter the "Manage software channels" I get "Internal
Server Error" from apache, and it logs:

[Wed Sep 17 16:48:34 2008] [error] [client 192.168.11.160] RHN::Exception: DBD::Oracle::st execute failed: ORA-12801: error signaled in parallel query server P003, instance oracledb2.mydomain.com:racdb2 (2)\nORA-01722: invalid number (DBD ERROR: OCIStmtExecute) [for Statement "SELECT  DISTINCT UGT.label\n  FROM  rhnUserGroupMembers UGM, rhnUserGroupType UGT, rhnUserGroup UG\n WHERE  UGM.user_id = ?\n   AND  UGM.user_group_id = UG.id\n   AND  UGT.id = UG.group_type\n" with ParamValues: :p1="3"]\n  RHN::DB /usr/lib/perl5/site_perl/5.8.8/RHN/DB.pm 233 RHN::Exception::DB::throw\n  RHN::DB::User /usr/lib/perl5/site_perl/5.8.8/RHN/DB/User.pm 153 RHN::DB::handle_error\n  RHN::User /usr/lib/perl5/site_perl/5.8.8/RHN/User.pm 32 RHN::DB::User::lookup\n  PXT::Request /usr/lib/perl5/site_perl/5.8.8/PXT/Request.pm 667 RHN::User::lookup\n  PXT::ApacheHandler /usr/lib/perl5/site_perl/5.8.8/PXT/ApacheHandler.pm 680 PXT::Request::user\n  PXT::ApacheHandler /usr/lib/perl5/site_perl/5.8.8/PXT/ApacheHandler.pm 457 PXT::ApacheHandler::mail_traceback\n  PXT::ApacheHandler /usr/lib/perl5/site_perl/5.8.8/PXT/ApacheHandler.pm 67 PXT::ApacheHandler::initialize_pxt\n  main -e 0 PXT::ApacheHandler::handler\n  main -e 0 (eval)\n\nOffending Query: SELECT  DISTINCT UGT.label\n  FROM  rhnUserGroupMembers UGM, rhnUserGroupType UGT, rhnUserGroup UG\n WHERE  UGM.user_id = ?\n   AND  UGM.user_group_id = UG.id\n   AND  UGT.id = UG.group_type\n\n, referer: https://spacewalk.mydomain.com/rhn/software/channels/Relevant.do


I tried running the sql on the db (as user spacewalk), and got:

SQL> SELECT  DISTINCT UGT.label FROM  rhnUserGroupMembers UGM, rhnUserGroupType UGT, rhnUserGroup UG WHERE  UGM.user_id = 3 AND  UGM.user_group_id = UG.id  AND  UGT.id = UG.group_type;

LABEL
----------------------------------------------------------------
config_admin
system_group_admin
activation_key_admin
monitoring_admin
channel_admin
org_admin

6 rows selected.


so I think the sql looks good.  Any ideas ? It seems strange to me that
it's complaining about oracledb2.mydomain.com:racdb2, when I told it
to use oracledb1-vip.mydomain.com:racdb1 during the installation. I.e., 
we have the hosts oracledb1.mydomain.com and oracledb2.mydomain.com, 
with VIP addresses oracledb1-vip.mydomain.com and oracledb2-vip.mydomain.com.
And the dbinstances are running on:

    oracledb1-vip.mydomain.com:racdb1
    oracledb2-vip.mydomain.com:racdb2


BTW: are there any instructions available for setting spacewalk
up on a normal oracle (non-XE) database ?  

I simply added the user "spacewalk" with roles=resource,connect and system
privileges:

        ALTER SESSION
        CREATE SYNONYM
        CREATE VIEW

(since the installer said it needed them). 


Also, is it possible to get it to use the tnsnames.ora instead of hardcoded
hostname ?


  -jf