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) <[email protected]>
gpg: key F24F1B08: "Red Hat, Inc (Red Hat Network) <[email protected]>"
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
[email protected]
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
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
