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

[Bryan Schneiders]

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)')



Bryan Schneiders
bschneiders at woti.com
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
>> bschneiders at woti.com
>> 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 <michael.mraka at redhat.com>
>>> To: spacewalk-list at redhat.com
>>> 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
>>> Spacewalk-list at redhat.com
>>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>>>
>>>
>>>
>>>      _______________________________________________
>>> Spacewalk-list mailing list
>>> Spacewalk-list at redhat.com
>>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
> 
>