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 <[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
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
