[Spacewalk-list] error running spacewalk-setup --disconnected .5 on F10
Bryan Schneiders
bschneiders at woti.com
Fri Apr 3 13:45:14 UTC 2009
Everyone one of my attempts was after a fresh kickstarted Fedora 10 install. So I'm curious about what's in my environment that's giving me consistent results that are different than yours?
# rpm -qa oracle\*
oracle-instantclient-sqlplus-10.2.0.4-1.x86_64
oracle-nofcontext-selinux-0.1-23.6.fc10.noarch
oracle-instantclient-basic-10.2.0.4-1.x86_64
oracle-xe-univ-10.2.0.1-1.0.i386
oracle-instantclient-selinux-10.2-8.fc10.noarch
oracle-lib-compat-10.2-19.fc10.x86_64
Which steps are you taking to setup the database? Since this looks like that's where the problem is, I don't know why my web_customer table is empty when it reaches the "Activating Spacewalk" step and fails.
Bryan Schneiders
bschneiders at woti.com
301-562-1900 ext 305
Pradeep Kilambi wrote:
> 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