[Spacewalk-list] error running spacewalk-setup --disconnected .5 on F10
Pradeep Kilambi
pkilambi at redhat.com
Thu Apr 2 22:24:35 UTC 2009
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
>> 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
>>>
>>>
>>
>> _______________________________________________
>> 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
More information about the Spacewalk-list
mailing list