[Spacewalk-list] error running spacewalk-setup --disconnected .5 on F10
Bryan Schneiders
bschneiders at woti.com
Fri Apr 3 13:49:13 UTC 2009
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
bschneiders at woti.com
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 <mopoka at yahoo.com>
> To: spacewalk-list at redhat.com
> 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 <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
>
>
>
>
>
> _______________________________________________
> 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