[Spacewalk-list] error running spacewalk-setup --disconnected .5 on F10

Bryan Schneiders bschneiders at woti.com
Fri Apr 3 13:39:44 UTC 2009


SQL> select rhn_channel_family_id_seq.nextval from dual;

   NEXTVAL
----------
      1020

SQL> 


Also, that certificate error may not be relevant, that's because I ran the activation program manually and missed an argument spacewalk-setup passes.  Here's the  output from /var/log/rhn/rhn-installation.log instead.



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/rhn/cluster.ini
/etc/sysconfig/rhn-satellite-prep/etc/rhn/rhn.conf
/etc/sysconfig/rhn-satellite-prep/etc/rhn/rhn.conf.orig
/etc/sysconfig/rhn-satellite-prep/etc/jabberd/s2s.xml
/etc/sysconfig/rhn-satellite-prep/etc/jabberd/c2s.xml
/etc/sysconfig/rhn-satellite-prep/etc/jabberd/sm.xml
/etc/sysconfig/rhn-satellite-prep/etc/tomcat5/tomcat5.conf
/etc/sysconfig/rhn-satellite-prep/etc -> /etc
/etc/sysconfig/rhn-satellite-prep/etc/rhn -> /etc/rhn
/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-04-02-18:34/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-04-02-18:34/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
/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-04-02-18:34/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/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-04-02-18:34/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/c2s.xml -> /etc/jabberd/c2s.xml
 * Making backup of /etc/jabberd/c2s.xml to /etc/sysconfig/rhn/backup-2009-04-02-18:34/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/jabberd/sm.xml -> /etc/jabberd/sm.xml
 * Making backup of /etc/jabberd/sm.xml to /etc/sysconfig/rhn/backup-2009-04-02-18:34/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/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-04-02-18:34/etc/tomcat5/tomcat5.conf
Unsubstituted Tags:

ERROR: RHN Entitlement Certificate failed to validate: 
Exception reported from swserver
Time: Thu Apr  2 18:37:22 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 569, in create_first_private_chan_family
    raise e
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


Pradeep Kilambi wrote:
> Pradeep Kilambi wrote:
>> Bryan Schneiders wrote:
>>> No change here with the new RPMs.  Here's all of my output and the 
>>> sql tests again.  Should there be something in the web_customer table?
>>>
>>> # /usr/bin/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.
>>> * Performing initial configuration.
>>> * Activating Spacewalk.
>>> ** Loading Spacewalk Certificate.
>>> ** Verifying certificate locally.
>>> ** Activating Spacewalk.
>>> There was a problem activating the satellite: Local activation failure.
>>>
>>> # /usr/bin/rhn-satellite-activate --disconnected
>>> NOTE: using backup cert as default: 
>>> /etc/sysconfig/rhn/rhn-entitlement-cert.xml
>>>
>>> ERROR: RHN Entitlement Certificate failed to validate: Exception 
>>> reported from swserver
>>
>> That's the problem right there, you are not providing a valid 
>> certificate for it to activate the satellite.
>> Thought we shipped a default certificate with sw-server, wonder if its 
>> not finding that. If you look
>> at my install in previous response, a valid cert successfully 
>> activated my sw-server.
>>
>> ~ Prad
> 
> I'll try another fresh f10 spacewalk install tonight and see if I can 
> reproduce your issue again. One thing that comes to mind looking at the 
> tracebacks is the sequence, Can you check this real quick for me,
> 
> SQL> select rhn_channel_family_id_seq.nextval from dual;
> 
> and see if the sequence has been created in the db. Thats the only other 
> thing I can think of wrt not all variables bound.
> 
> will let you know how my install goes tonight.
> 
> Thanks,
> 
> 
> 
>>
>>
>>
>>
>>
> 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list




More information about the Spacewalk-list mailing list