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
Time: Thu Apr 2 18:37:34 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)')
# sqlplus spacew...@xe
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 2 18:37:52 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> INSERT INTO rhnChannelFamily (id, name, label, org_id, product_url) VALUES (rhn_channel_family_id_seq.nextval, 'Private Channel Family 1', 'private-channel-family-1', 1, 'First Org Created');
INSERT INTO rhnChannelFamily (id, name, label, org_id, product_url) VALUES (rhn_channel_family_id_seq.nextval, 'Private Channel Family 1', 'private-channel-family-1', 1, 'First Org Created')
*
ERROR at line 1:
ORA-02291: integrity constraint (SPACEWALK.RHN_CHANNEL_FAMILY_ORG_FK) violated
- parent key not found
SQL> select * from WEB_CUSTOMER;
no rows selected
SQL> select * from rhnChannelFamily;
no rows selected
SQL>
Bryan Schneiders
[email protected]
301-562-1900 ext 305
Pradeep Kilambi wrote:
Pradeep Kilambi wrote:
Bryan Schneiders wrote:
How do I just rerun the activation step?
Running /usr/bin/rhn-satellite-activate --disconnected just results
in the original error from the logs.
NOTE: using backup cert as default:
/etc/sysconfig/rhn/rhn-entitlement-cert.xml
ERROR: RHN Entitlement Certificate failed to validate: Exception
reported from swserver
Time: Thu Apr 2 15:49:15 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)')
I'm in the process of getting new packages for this issue live soon.
But until then, you'll first have to apply the attached patch to
/usr/share/rhn/satellite_tools/satCerts.py ,
and run your spacewalk-setup again.
Lemme know how this goes.
Thanks,
~ Prad
Until the packages are in the repo, you can grab the latest builds with
this fix from http://pkilambi.fedorapeople.org/spacewalk-backend/* .
jus rpm -Uvh those and restart your spacewalk-setup or
rhn-satellite-activate --disconnected. Please lemme know if you run into
any issues.
Thanks,
~ Prad
Bryan Schneiders
[email protected]
301-562-1900 ext 305
Pradeep Kilambi wrote:
Bryan Schneiders wrote:
I can confirm the same results and same database errors. I have
done this 3 times, each on a fresh install of Fedora 10, and each
with the same outcome.
I also reported this on March 37th with no response.
"[Spacewalk-list] There was a problem activating the satellite:
Local activation failure."
Bryan Schneiders
[email protected]
301-562-1900 ext 305
Matthew Opoka wrote:
I have a new error:
SQL> INSERT INTO rhnChannelFamily (id, name, label, org_id,
product_url) VALUES (rhn_channel_family_id_seq.nextval, 'Private
Channel Family 1', 'private-channel-family-1', 1, 'First Org
Created');
INSERT INTO rhnChannelFamily (id, name, label, org_id,
product_url) VALUES (rhn_channel_family_id_seq.nextval, 'Private
Channel Family 1', 'private-channel-family-1', 1, 'First Org
Created')
*
ERROR at line 1:
ORA-02291: integrity constraint
(SPACEWALK.RHN_CHANNEL_FAMILY_ORG_FK) violated
- parent key not found
That tells me that your first org did not get created and orgid of 1
is not available in web_customer table and throwing a primary key
constraint. You'll need to re run your activation not a direct sql
query. This will of course fail as the first org is not created yet.
Just rerun the activation step.
For the quotes issues, I'll add in the fix and rebuild new packages
so the fixed ones get pushed to the repo.
Thanks,
~ Prad
----- Original Message ----
From: Michael Mraka <[email protected]>
To: [email protected]
Sent: Thursday, April 2, 2009 9:33:55 AM
Subject: Re: [Spacewalk-list] error running spacewalk-setup
--disconnected .5 on F10
Matthew Opoka wrote:
% % New results:
% % SQL> INSERT INTO rhnChannelFamily (id, name, label, org_id,
product_url) VALUES (rhn_channel_family_id_seq.nextval, "Private
Channel Family 1" , "private-channel-family-1", 1, "First Org
Created");
% INSERT INTO rhnChannelFamily (id, name, label, org_id,
product_url) VALUES (rhn_channel_family_id_seq.nextval, "Private
Channel Family 1" , "private-channel-family-1", 1, "First Org
Created")
%
*
% ERROR at line 1:
% ORA-00984: column not allowed here
Please exchange " for '.
% % SQL> select * from rhnChannelFamily;
% no rows selected
--
Michael Mráka
Satellite Engineering, Red Hat
_______________________________________________
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
_______________________________________________
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
------------------------------------------------------------------------
_______________________________________________
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
