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

[Pradeep Kilambi]

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


-- 
--
Pradeep Kilambi
RHN Satellite Engineering
pkilambi at redhat.com
Phone: +1 919 754 4285
RHCE # 805008680430554