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

Pradeep Kilambi pkilambi at redhat.com
Thu Apr 2 22:45:30 UTC 2009


hrm are you sure? I'm jus running it myself and:

** Database: Testing database connection.
** Database: Populating database.
** Database: --clear-db option used.  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.
*** Progress: ############################################################
* Setting up users and groups.
** GPG: Initializing GPG and importing key.
* Performing initial configuration.
* Activating RHN Satellite.
Where is your satellite certificate file? Where is your satellite 
certificate file? Where is your satellite certificate file? Where is 
your satellite certificate file? Where is your satellite certificate 
file? Where is your satellite certificate file?
Where is your satellite certificate file?
Where is your satellite certificate file? /root/5.3.cert
** Loading RHN Satellite Certificate.
** Verifying certificate locally.
** Activating RHN Satellite.
* Enabling Monitoring.
* Configuring apache SSL virtual host.
Should setup configure apache's default ssl server for you (saves 
original ssl.conf) y/n? y
* Creating SSL certificates.
CA certificate password?
Re-enter CA certificate password?
Organization? RHT
Organization Unit [rlx-2-22.xx]?
Email Address [pkilambi at xx.com]?
City? xx
State? NC
Country code (Examples: "US", "JP", "IN", or type "?" to see a list)? US
** SSL: Generating CA certificate.
** SSL: Deploying CA certificate.
** SSL: Generating server certificate.

# rpm -q spacewalk-backend
spacewalk-backend-0.5.31-1.fc10

SQL> select * from web_customer;

no rows selected

SQL> /

    ID
----------
NAME
--------------------------------------------------------------------------------
ORACLE_CUSTOMER_ID ORACLE_CUSTOMER_NUMBER C C CREATED    MODIFIED
------------------ ---------------------- - - --------- ---------
     1
Miroslav Suchy
         1            1 B   02-APR-09 02-APR-09


SQL> select * from rhnChannelFamily;

    ID     ORG_ID
---------- ----------
NAME
--------------------------------------------------------------------------------
LABEL
--------------------------------------------------------------------------------
PRODUCT_URL
--------------------------------------------------------------------------------
CREATED   MODIFIED
--------- ---------
      1000        1
Private Channel Family 1
private-channel-family-1

    ID     ORG_ID
---------- ----------
NAME
--------------------------------------------------------------------------------
LABEL
--------------------------------------------------------------------------------
PRODUCT_URL
--------------------------------------------------------------------------------
CREATED   MODIFIED
--------- ---------
First Org Created
02-APR-09 02-APR-09



~ Prad


Bryan Schneiders wrote:
> 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


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





More information about the Spacewalk-list mailing list