[Spacewalk-list] There was a problem activating the satellite: Local activation failure.

Fri Mar 27 14:36:34 UTC 2009

I'm trying to install spacewalk-0.5.4-1.fc10.noarch on Fedora 10 x86-64.  I'm following the directions in the wiki.  (Speaking of which the wiki directions for installing Oracle XE are wrong in a few places).  While running spacewalk-setup I can only get as far as: "There was a problem activating the satellite: Local activation failure."  There is an Oracle error in the logs.

So I can get this far:

# spacewalk-setup --disconnected
* Setting up Oracle environment.
* Setting up database.
** Database: Setting up database connection.
DB User? spacewalk
DB Password? 
DB SID? xe
DB hostname? localhost
DB port [1521]? 
DB protocol [TCP]? 
** Database: Testing database connection.
** Database: Populating database.
The Database has schema.  Would you like to clear the database [Y]? Y
** Database: Clearing database.
** Database: Shutting down services that may be using DB: [tomcat5, taskomatic, httpd, jabberd, osa-dispatcher, tsdb_local_queue].
** Database: Services stopped.  Clearing DB.
** Database: Re-populating database.
*** Progress: #############################################################
* Setting up users and groups.
** GPG: Initializing GPG and importing key.
You must enter an email address.
Admin Email Address? bschneiders at woti.com
* Performing initial configuration.
* Activating Spacewalk.
** Loading Spacewalk Certificate.
** Verifying certificate locally.
** Activating Spacewalk.
There was a problem activating the satellite: Local activation failure.

# cat /var/log/rhn/rhn-installation.log
Spacewalk installation log.
Command: /usr/bin/spacewalk-setup 

Stopping tomcat5: ESC[60G[ESC[0;31mFAILEDESC[0;39m]
Stopping RHN Taskomatic...
RHN Taskomatic was not running.
Stopping httpd: ESC[60G[ESC[0;31mFAILEDESC[0;39m]
Terminating jabberd processes ...
Stopping router: ESC[60G[ESC[0;31mFAILEDESC[0;39m]
Stopping sm: ESC[60G[ESC[0;31mFAILEDESC[0;39m]
Stopping c2s: ESC[60G[ESC[0;31mFAILEDESC[0;39m]
Stopping s2s: ESC[60G[ESC[0;31mFAILEDESC[0;39m]
Shutting down osa-dispatcher: ESC[60G[ESC[0;31mFAILEDESC[0;39m]
tsdb_local_queue: unrecognized service
/root/.gnupg/pubring.gpg
------------------------
pub   1024D/F24F1B08 2002-04-23 [expired: 2004-04-22]
uid                  Red Hat, Inc (Red Hat Network) <rhn-feedback at redhat.com>

gpg: key F24F1B08: "Red Hat, Inc (Red Hat Network) <rhn-feedback at redhat.com>" not changed
gpg: Total number processed: 1
gpg:              unchanged: 1
/etc/sysconfig/rhn-satellite-prep/etc/jabberd/s2s.xml
/etc/sysconfig/rhn-satellite-prep/etc/jabberd/sm.xml
/etc/sysconfig/rhn-satellite-prep/etc/jabberd/c2s.xml
/etc/sysconfig/rhn-satellite-prep/etc/tomcat5/tomcat5.conf
/etc/sysconfig/rhn-satellite-prep/etc/rhn/rhn.conf.orig
/etc/sysconfig/rhn-satellite-prep/etc/rhn/cluster.ini
/etc/sysconfig/rhn-satellite-prep/etc/rhn/rhn.conf
/etc/sysconfig/rhn-satellite-prep/etc -> /etc
/etc/sysconfig/rhn-satellite-prep/etc/jabberd -> /etc/jabberd
/etc/sysconfig/rhn-satellite-prep/etc/jabberd/s2s.xml -> /etc/jabberd/s2s.xml
 * Making backup of /etc/jabberd/s2s.xml to /etc/sysconfig/rhn/backup-2009-03-27-10:19/etc/jabberd/s2s.xml
/sbin/restorecon reset /etc//jabberd/s2s.xml context unconfined_u:object_r:etc_t:s0->system_u:object_r:etc_t:s0
/etc/sysconfig/rhn-satellite-prep/etc/jabberd/sm.xml -> /etc/jabberd/sm.xml
 * Making backup of /etc/jabberd/sm.xml to /etc/sysconfig/rhn/backup-2009-03-27-10:19/etc/jabberd/sm.xml
/sbin/restorecon reset /etc//jabberd/sm.xml context unconfined_u:object_r:etc_t:s0->system_u:object_r:etc_t:s0
/etc/sysconfig/rhn-satellite-prep/etc/jabberd/c2s.xml -> /etc/jabberd/c2s.xml
 * Making backup of /etc/jabberd/c2s.xml to /etc/sysconfig/rhn/backup-2009-03-27-10:19/etc/jabberd/c2s.xml
/sbin/restorecon reset /etc//jabberd/c2s.xml context unconfined_u:object_r:etc_t:s0->system_u:object_r:etc_t:s0
/etc/sysconfig/rhn-satellite-prep/etc/tomcat5 -> /etc/tomcat5
/etc/sysconfig/rhn-satellite-prep/etc/tomcat5/tomcat5.conf -> /etc/tomcat5/tomcat5.conf
 * Making backup of /etc/tomcat5/tomcat5.conf to /etc/sysconfig/rhn/backup-2009-03-27-10:19/etc/tomcat5/tomcat5.conf
/etc/sysconfig/rhn-satellite-prep/etc/rhn -> /etc/rhn
/etc/sysconfig/rhn-satellite-prep/etc/rhn/rhn.conf.orig -> /etc/rhn/rhn.conf.orig
 * Making backup of /etc/rhn/rhn.conf.orig to /etc/sysconfig/rhn/backup-2009-03-27-10:19/etc/rhn/rhn.conf.orig
/sbin/restorecon reset /etc//rhn/rhn.conf.orig context unconfined_u:object_r:etc_t:s0->system_u:object_r:etc_t:s0
/etc/sysconfig/rhn-satellite-prep/etc/rhn/cluster.ini -> /etc/rhn/cluster.ini
 * Making backup of /etc/rhn/cluster.ini to /etc/sysconfig/rhn/backup-2009-03-27-10:19/etc/rhn/cluster.ini
/sbin/restorecon reset /etc//rhn/cluster.ini context unconfined_u:object_r:etc_t:s0->system_u:object_r:etc_t:s0
/etc/sysconfig/rhn-satellite-prep/etc/rhn/rhn.conf -> /etc/rhn/rhn.conf
 * Making backup of /etc/rhn/rhn.conf to /etc/sysconfig/rhn/backup-2009-03-27-10:19/etc/rhn/rhn.conf
/sbin/restorecon reset /etc//rhn/rhn.conf context unconfined_u:object_r:etc_t:s0->system_u:object_r:etc_t:s0
Unsubstituted Tags:

ERROR: RHN Entitlement Certificate failed to validate: 
Exception reported from swserver
Time: Fri Mar 27 10:22:54 2009
Exception type <class 'server.rhnSQL.sql_base.SQLError'>

Exception Handler Information
Traceback (most recent call last):
  File "/usr/share/rhn/satellite_tools/rhn_satellite_activate.py", line 203, in activateSatellite_local
    satCerts.storeRhnCert(cert, check_generation=1, check_version=not(options.ignore_version_mismatch))
  File "/usr/share/rhn/satellite_tools/satCerts.py", line 231, in storeRhnCert
    create_first_org(owner=sc.owner)
  File "/usr/share/rhn/satellite_tools/satCerts.py", line 104, in create_first_org
    create_first_private_chan_family()
  File "/usr/share/rhn/satellite_tools/satCerts.py", line 555, in create_first_private_chan_family
    org=1, url="First Org Created")
  File "/usr/share/rhn/server/rhnSQL/sql_base.py", line 161, in execute
    return apply(self._execute_wrapper, (self._execute, ) + p, kw)
  File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 118, in _execute_wrapper
    raise apply(sql_base.SQLError, ret)
SQLError: (1008, 'ORA-01008: not all variables bound\n', 'INSERT INTO  rhnChannelFamily (id, name, label, org_id, product_url) VALUES (rhn_channel_family_id_seq.nextval, :name, :label, :org, :url)')

-- 

Bryan Schneiders
bschneiders at woti.com
301-562-1900 ext 305