[Spacewalk-list] error running spacewalk-setup --disconnected .5 on F10
Matthew Opoka
mopoka at yahoo.com
Thu Apr 2 22:50:32 UTC 2009
Same where with the patch.
----- Original Message ----
From: Bryan Schneiders <bschneiders at woti.com>
To: spacewalk-list at redhat.com
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 spacewalk at 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
bschneiders at woti.com
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
>>> 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
>
>
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
More information about the Spacewalk-list
mailing list