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