I tried that too, then I get the following in /var/log/rhn/rhn-installation.log
<snip>
ERROR: RHN Entitlement Certificate failed to validate:
Exception reported from swserver
Time: Fri Apr 3 09:47:27 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 243, in storeRhnCert
row = retrieve_db_cert()
File "/usr/share/rhn/satellite_tools/satCerts.py", line 326, in
retrieve_db_cert
h.execute(label=label)
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', "SELECT nvl(version, 0) version, version orig_version, cert, TO_CHAR(issued, 'YYYY-MM-DD HH24:MI:SS') issued, TO_CHAR(expires, 'YYYY-MM-DD HH24:MI:SS') expires FROM rhnSatelliteCert
WHERE label = :label ORDER BY version DESC NULLS LAST")
Bryan Schneiders
[email protected]
301-562-1900 ext 305
Matthew Opoka wrote:
Well it didn't quiet resolve the issue but it did get a little further.
----- Original Message ----
From: Matthew Opoka <[email protected]>
To: [email protected]
Sent: Friday, April 3, 2009 1:13:57 AM
Subject: Re: [Spacewalk-list] error running spacewalk-setup --disconnected .5
on F10
So it looks like the fix is to run this:
INSERT into web_customer(id, name) VALUES (1, 'Owner');
then run the setup.
----- Original Message ----
From: Pradeep Kilambi <[email protected]>
To: [email protected]
Sent: Thursday, April 2, 2009 9:55:38 PM
Subject: Re: [Spacewalk-list] error running spacewalk-setup --disconnected .5
on F10
Matthew Opoka wrote:
Here is what I get:
SQL> select rhn_channel_family_id_seq.nextval from dual;
NEXTVAL
----------
1000
Yea that looks right as well.
So here is my another attempt with a fresh spacewalk 0.5 install on
fedora-10
# rpm -q fedora-release
fedora-release-10-1.noarch
# rpm -q spacewalk
spacewalk-0.5.4-1.fc10.noarch
# rpm -q spacewalk-backend
spacewalk-backend-0.5.31-1.fc10.noarch
# spacewalk-setup --disconnected
* Setting up Oracle environment.
* Setting up database.
** Database: Setting up database connection.
DB User? rhnsat
DB Password?
DB SID? rhnsat
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.
** GPG: Creating /root/.gnupg directory
You must enter an email address.
Admin Email Address? [email protected]
* Performing initial configuration.
* Activating Spacewalk.
** Loading Spacewalk Certificate.
** Verifying certificate locally.
** Activating Spacewalk.
* Enabling Monitoring.
* Configuring apache SSL virtual host.
Should setup configure apache's default ssl server for you (saves
original ssl.conf) y/n? y
** /etc/httpd/conf.d/ssl.conf has been backed up to ssl.conf-swsave
* Creating SSL certificates.
CA certificate password?
Re-enter CA certificate password?
Organization? rht
Organization Unit [xxx]?
Email Address [[email protected]]?
City? RDU
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.
** SSL: Storing SSL certificates.
* Deploying configuration files.
* Update configuration in database.
* Setting up Cobbler..
* Restarting services.
Installation complete.
Visit https://localhost to create the Spacewalk administrator account.
Database checks:
SQL> select * from web_customer;
ID
----------
NAME
--------------------------------------------------------------------------------
ORACLE_CUSTOMER_ID ORACLE_CUSTOMER_NUMBER C C CREATED MODIFIED
------------------ ---------------------- - - --------- ---------
1
Spacewalk Public Cert
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
So, on a freshly kickstarted fedora10, installed pkgs as our wiki
suggests and ran the spacewalk-setup and seems to work as expected.
Please lemme know if you want me to try anything else. So far seems to
work fine.
Thanks,
~ Prad
----- Original Message ----
From: Pradeep Kilambi <[email protected]>
To: [email protected]
Sent: Thursday, April 2, 2009 9:12:56 PM
Subject: Re: [Spacewalk-list] error running spacewalk-setup --disconnected .5
on F10
Pradeep Kilambi wrote:
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
That's the problem right there, you are not providing a valid certificate for
it to activate the satellite.
Thought we shipped a default certificate with sw-server, wonder if its not
finding that. If you look
at my install in previous response, a valid cert successfully activated my
sw-server.
~ Prad
I'll try another fresh f10 spacewalk install tonight and see if I can reproduce
your issue again. One thing that comes to mind looking at the tracebacks is the
sequence, Can you check this real quick for me,
SQL> select rhn_channel_family_id_seq.nextval from dual;
and see if the sequence has been created in the db. Thats the only other thing
I can think of wrt not all variables bound.
will let you know how my install goes tonight.
Thanks,
_______________________________________________
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
_______________________________________________
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
