[Spacewalk-list] error running spacewalk-setup --disconnected .5 on F10
Matthew Opoka
mopoka at yahoo.com
Fri Apr 3 05:13:57 UTC 2009
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 <pkilambi at redhat.com>
To: spacewalk-list at redhat.com
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? pkilambi at redhat.com
* 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 [pkilambi at redhat.com]?
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 <pkilambi at redhat.com>
> To: spacewalk-list at redhat.com
> 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
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
More information about the Spacewalk-list
mailing list