On 7/26/10 9:23 AM, Colin Coe wrote:
On Mon, Jul 26, 2010 at 3:30 PM, Michael Mraka<michael.mr...@redhat.com> wrote:
Colin Coe wrote:
% Hmmm, when I say 'works', I mean that when browsing to
% http://spacewalk.example.com/ a login screen is displayed. In 'dev
% mode', it does not.
%
% CC
%
% On 7/26/10, Colin Coe<colin....@gmail.com> wrote:
%> Hi all
%>
%> I'm getting heaps of these errors in my dev environment ATM.
Hi Collin,
that's probably result of my configuration file shuffles.
Historically we had database connect info in several places
(default_db, db_*, hibernate.connection*) and I made changes so all
components use db_* variables. It was tested on spacewalk installation
but AFAIK Tomas experienced some troubles java in developer setup.
Database part of /etc/rhn/rhn.conf should now looks like:
db_backend = oracle
db_user = spacewalk
db_password = somepassword
db_name = XE
db_host =
db_port =
server.nls_lang = english.AL32UTF8
hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.driver_proto=jdbc:oracle:oci
Notice that default_db and hibernate.connection.url has been
decommissioned.
Jdbc:oracle:oci need oracle library libocijdbc10.so so make also sure
you have
LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.4/client64/lib:/usr/lib/oracle/10.2.0.4/client/lib
in your tomcat5.conf or tomcat6.conf.
If jdbc:oracle:oci doesn't work for you for some reason you can fill in
db_host and db_port and switch back to jdbc:oracle:thin.
If all above fails, feel free to ping me on IRC.
Regards,
--
Michael Mráka
Satellite Engineering, Red Hat
Colin,
Try setting
hibernate.connection.driver_proto=jdbc:oracle:thin
within /etc/rhn/rhn.conf (overwriting the jdbc:oracle:oci value).
-Justin
Hi Michael
No luck. Now getting:
---
2010-07-26 21:16:25,788 [main] FATAL
com.redhat.rhn.common.hibernate.ConnectionManager -
jdbc:oracle:oci:@XE
Jul 26, 2010 9:16:30 PM com.mchange.v2.log.MLog<clinit>
INFO: MLog clients using java 1.4+ standard logging.
Jul 26, 2010 9:16:30 PM com.mchange.v2.c3p0.C3P0Registry banner
INFO: Initializing c3p0-0.9.0 [built 16-January-2006 22:02:55 +0000;
debug? false; trace: 5]
Jul 26, 2010 9:16:31 PM com.mchange.v2.c3p0.PoolBackedDataSource getPoolManager
INFO: Initializing c3p0 pool...
com.mchange.v2.c3p0.poolbackeddatasou...@23d08b [
connectionPoolDataSource ->
com.mchange.v2.c3p0.WrapperConnectionPoolDataSo
u...@122d9c [ acquireIncrement -> 3, acquireRetryAttempts -> 30,
acquireRetryDelay -> 1000, autoCommitOnClose -> false,
automaticTestTable -> null, breakAfte
rAcquireFailure -> false, checkoutTimeout -> 0,
connectionTesterClassName ->
com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation
-> null,
forceIgnoreUnresolvedTransactions -> false, identityToken -> 122d9c,
idleConnectionTestPeriod -> 300, initialPoolSize -> 5, maxIdleTime ->
300, maxPoolSize -
20, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 5,
nestedDataSource -> com.mchange.v2.c3p0.drivermanagerdatasou...@1db9f45 [ descri
ption -> null, driverClass -> null, factoryClassLocation -> null,
identityToken -> 1db9f45, jdbcUrl -> jdbc:oracle:oci:@XE, properties
-> {user=******, passw
ord=******, driver_proto=jdbc:oracle:oci} ], preferredTestQuery ->
null, propertyCycle -> 300, testConnectionOnCheckin -> false,
testConnectionOnCheckout ->
false, usesTraditionalReflectiveProxies -> false ],
factoryClassLocation -> null, identityToken -> 23d08b,
numHelperThreads -> 3 ]
Exception in thread
"com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2"
java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
Exception in thread
"com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1" at
java.lang.ClassLoader.loadLibrary(ClassLoader.java:1678)
at java.lang.Runtime.loadLibrary0(Runtime.java:840)
at java.lang.System.loadLibrary(System.java:1047)
at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3135)
at java.security.AccessController.doPrivileged(Native Method)
at
oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3131)
at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:221)
at
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:132)
at
oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:78)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:81)
at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:96)
at
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireResource(C3P0PooledConnectionPool.java:89)
at
com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:665)
at
com.mchange.v2.resourcepool.BasicResourcePool.access$500(BasicResourcePool.java:32)
at
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1204)
at
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:368)
java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1678)
at java.lang.Runtime.loadLibrary0(Runtime.java:840)
at java.lang.System.loadLibrary(System.java:1047)
at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3135)
at java.security.AccessController.doPrivileged(Native Method)
...
---
Any ideas
CC
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel