[Spacewalk-list] error running spacewalk-setup --disconnected .5 on F10
Pradeep Kilambi
pkilambi at redhat.com
Fri Apr 3 14:02:59 UTC 2009
Bryan Schneiders wrote:
> 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.
>
>
Same steps as we stated in the wiki here,
https://fedorahosted.org/spacewalk/wiki/HowToInstall
# rpm -qa oracle\*
oracle-instantclient-sqlplus-10.2.0.4-1.i386
oracle-instantclient-basic-10.2.0.4-1.i386
oracle-lib-compat-10.2-19.fc10.i386
oracle-instantclient-selinux-10.2-8.fc10.noarch
oracle-nofcontext-selinux-0.1-23.6.fc10.noarch
web_customer is populated at the activation time. So thats expected to
be empty until the the activation is complete. I'm puzzled myself wrt
your case.
The only difference I see is the arch. Mine is i386 and yours is x86_64.
Would you mind trying the install on i386 and see ? If that works then
this is some weird 64 bit issue looks like. I'll see if I can grab a 64
bit system and try it myself sometime today.
~ Prad
>
> 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
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
--
--
Pradeep Kilambi
RHN Satellite Engineering
pkilambi at redhat.com
Phone: +1 919 754 4285
RHCE # 805008680430554
More information about the Spacewalk-list
mailing list