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

[Matthew Opoka]

Pradeep,

Here are my 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")
  2
SQL> select * from rhnChannelFamily where org_id = 1;
no rows selected
SQL> select * from rhnChannelFamily
  2
SQL>




----- Original Message ----
From: Pradeep Kilambi <pkilambi at redhat.com>
To: spacewalk-list at redhat.com
Sent: Wednesday, April 1, 2009 10:56:03 AM
Subject: Re: [Spacewalk-list] error running spacewalk-setup --disconnected .5 on F10

Pradeep Kilambi wrote:
> Matthew Opoka wrote:
>> All,
>> 
>> I'm running into an error running spacewalk-setup --disconnected on F10. Any ideas? Please find the error below:
>> 
>> [root at localhost ~]# 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.
>> *** Progress: #############################################################
>> * Setting up users and groups.
>> ** GPG: Initializing GPG and importing key.
>> ** GPG: Creating /root/.gnupg directory
>> You must enter an email address.
>> Admin Email Address? * Performing initial configuration.
>> * Activating Spacewalk.
>> ** Loading Spacewalk Certificate.
>> ** Verifying certificate locally.
>> ** Activating Spacewalk.
>> There was a problem activating the satellite: Local activation failure.
>> 
>> Unsubstituted Tags:
>> ERROR: RHN Entitlement Certificate failed to validate:
>> Exception reported from localhost.localdomain
>> Time: Tue Mar 31 23:51:20 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)')
>>  
> 
> hrm I thought we fixed this. Can you please do an rpm -q spacewalk-backend and lemme know, looking into this now.
> 
> ~ Prad

Seems to work jus fine on mine.
SQL> select * from rhnChannelFamily where org_id = 1;

  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
31-MAR-09 31-MAR-09


Can you run the following query manually in your database and see what variable its complaining about?

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")

and dont commit it. Jus run that and see if it work. If not what exact variable its complaining about.

~ Prad




> 
>> 
>> 
>>      _______________________________________________
>> 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


_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list