[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

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



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

SQL> select * from rhnChannelFamily;
no rows selected

 


----- Original Message ----
From: Pradeep Kilambi <pkilambi redhat com>
To: spacewalk-list redhat com
Sent: Thursday, April 2, 2009 9:11:35 AM
Subject: Re: [Spacewalk-list] error running spacewalk-setup --disconnected .5 on F10

Matthew Opoka wrote:
> 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
>  

hrm doesn't look like this statement got executed. I dont see the 
result. Can you end this with a ; or / and paste back the result.

Thanks,
~ Prad

> SQL> select * from rhnChannelFamily where org_id = 1;
> no rows selected
> SQL> select * from rhnChannelFamily
>  2
> SQL>
>
>
>
>
> ----- Original Message ----
> From: Pradeep Kilambi <pkilambi redhat com>
> To: spacewalk-list 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 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 redhat com
>>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>>>  
>>>      
>>    
>
>
> -- --
> Pradeep Kilambi
> RHN Satellite Engineering
> pkilambi redhat com
> Phone: +1 919 754 4285
> RHCE # 805008680430554
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list redhat com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
>      
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list redhat com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>  

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



      


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]