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 <[email protected]> To: [email protected] 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: >> >> [r...@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 >> [email protected] >> https://www.redhat.com/mailman/listinfo/spacewalk-list >> > > -- -- Pradeep Kilambi RHN Satellite Engineering [email protected] Phone: +1 919 754 4285 RHCE # 805008680430554 _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
