[Spacewalk-list] error running spacewalk-setup --disconnected .5 on F10
Pradeep Kilambi
pkilambi at redhat.com
Thu Apr 2 21:25:46 UTC 2009
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
>
>
> 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
--
--
Pradeep Kilambi
RHN Satellite Engineering
pkilambi at redhat.com
Phone: +1 919 754 4285
RHCE # 805008680430554
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: sp_activate.patch
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20090402/43c7666b/attachment.ksh>
More information about the Spacewalk-list
mailing list