Same where with the patch.
----- Original Message ---- From: Bryan Schneiders <[email protected]> To: [email protected] Sent: Thursday, April 2, 2009 6:41:31 PM Subject: Re: [Spacewalk-list] error running spacewalk-setup --disconnected .5 on F10 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 _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
