[Spacewalk-list] RHN Traceback when trying to push content to Spacewalk Server

[Jesus M. Rodriguez]

Kent Baxley wrote:
> On Thu, 19 Jun 2008 10:22:03 -0400
> Pradeep Kilambi <pkilambi at redhat.com> wrote:
> 
>> A quick look at the traceback shows that its not able to connect to
>> the db. May be worth rechecking your db connection.
> 
> Ok. Still can't seem to get anything working.  Here are the contents of
> tnsnames.ora:
> 
> cat /etc/tnsnames.ora
> XE =
>     (DESCRIPTION =
>        (ADDRESS_LIST =
>           (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
>        )
>        (CONNECT_DATA =
>           (SERVICE_NAME = xe)
>        )
>     )
> 
> ...and I can connect to the database manually by using sqlplus
> spacewalk/spacewalk at xe:
> 
>  sqlplus spacewalk/spacewalk at xe
> 
> SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 19 15:56:09 2008
> 
> Copyright (c) 1982, 2005, Oracle.  All rights reserved.
> 
> 
> Connected to:
> Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
> 
> SQL>
> 
> ...any other ideas?

Good so we know /etc/tnsnames.ora is correct. Next, we'll need to look
at /etc/rhn/rhn.conf.

Verify you have the following entry:

    default_db = spacewalk/spacewalk at xe

If it says web.default_db change it to just default_db.

Also, ensure that the hibernate configs match as well:

hibernate.connection.username=spacewalk
hibernate.connection.password=spacewalk
hibernate.connection.url=jdbc:oracle:thin:@localhost:1521:xe

Let us know if that doesn't work for you.

-- 
jesus m. rodriguez     | jesusr at redhat.com
sr. software engineer  | irc: zeus
red hat network        | 919.754.4413 (w)
rhce # 805008586930012 | 919.623.0080 (c)
+-------------------------------------------+
|  "Those who cannot learn from history     |
|   are doomed to repeat it."               |
|                       -- George Santayana |
+-------------------------------------------+