[Spacewalk-list] Spacewalk 1.6 on Oracle

[Jan Šoc]

Hi,
it is working!
it is realy something! ;-)

Thanks a lot,
Jan Šoc

Dne 19.1.2012 14:15, BUPE(Peter Burgstaller) napsal(a):
> I have the same issue and use the following patch to work around the problem:
>
> -----
> # pwd
> /etc/sysconfig/rhn/oracle
> # diff -u main.sql-20110504 main.sql
> --- main.sql-20110504	2011-04-08 21:40:53.000000000 +0200
> +++ main.sql	2011-05-04 14:20:24.000000000 +0200
> @@ -38940,6 +38940,12 @@
>
>
> -- Source: data/common/rhnPackageSyncBlacklist.sql
> +
> +select lookup_package_name('gpg-pubkey') from dual;
> +
> +select lookup_package_name('rhns-ca-cert') from dual;
> +
> +select lookup_package_name('rhn-org-trusted-ssl-cert') from dual;
>
> insert into rhnPackageSyncBlacklist (package_name_id)
> 	values (lookup_package_name('gpg-pubkey'));
> -----
>
> - Cheers, Peter
>
> On Jan 19, 2012, at 14:03, Jan Pazdziora wrote:
>
>> On Thu, Jan 19, 2012 at 01:49:19PM +0100, Jan Šoc wrote:
>>> My oracle server is
>>> SQL>  select * from V$VERSION;
>>>
>>> BANNER
>>> --------------------------------------------------------------------------------
>>> Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
>>> PL/SQL Release 11.2.0.2.0 - Production
>>> CORE    11.2.0.2.0      Production
>>> TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
>>> NLSRTL Version 11.2.0.2.0 - Production
>>>
>>>
>>> and with install procedure i have:
>>>
>>> [root at elektra]# spacewalk-setup --disconnected
>>> * Setting up Oracle environment.
>>> * Setting up database.
>>> ** Database: Setting up database connection for Oracle backend.
>>> Database service name (SID)? XXXXXX
>>> Database hostname [localhost]? oracle.acme.com
>>> Username? space_walk
>>> Password?
>>> ** Database: Testing database connection.
>>> ** Database: Populating database.
>>> *** Progress: ####################################################################
>>> Could not populate database.
>>>
>>> AND:
>>>
>>> cat /var/log/rhn/populate_db.log|grep ORA
>>> ORA-02291: integrity constraint (SPACE_WALK.RHN_PACKAGESYNCBL_PNID_FK) violated - parent key not found
>>>
>>> could anyone help me? ;-)
>> You are hitting
>>
>> 	https://www.redhat.com/archives/spacewalk-list/2011-May/msg00019.html
>>
>> I suggest you escalate the issue to your Oracle support.
>>
>> -- 
>> Jan Pazdziora
>> Principal Software Engineer, Satellite Engineering, Red Hat
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
> --
> DI Peter Burgstaller
> -----------------------------------
> Head of Hosted Services
>
> SKIDATA AG
> Untersbergstraße 40
> A-5083 Grödig, Salzburg
> [p] +43 (0) 6246 888-4155
> [f] +43 (0) 6246 888-7
> [e] peter.burgstaller at skidata.com
> [w] http://www.skidata.com
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>