[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