Based on John Cook's successful Oracle builds to 1.4-1.5, I'm honing
in on a need to rebuild sparsemapcontent to include the oracle driver
at its level. For OAE 1.2 this will be with sparsemapcontent 1.3.4.
I'll copy the list when I have more meaningful details.
-- Max
On May 11, 2012, at 2:46 PM, Zach A. Thomas wrote:
I can't say for sure, but this is consistent with something wrong
with the config file. Try setting up the JDBCStorageClient using the
web console. When it writes the config file, you can check that
against the one you're using.
Avoid using the bundle location property if you do copy a config
file produced by the console, because it's the one that will become
obsolete if your bundle file name ever changes.
I hope we can find a way for bundles to fail more loudly if they
find a problem with configuration. As it is, they quietly start up
with all the defaults, which is almost never what you want.
Zach
On May 11, 2012, at 11:49 AM, Max Whitney <[email protected]> wrote:
Continuing with the theme of "Max Whitney, making mistakes so
newbies don't have to"
I'm at a loss on how to get OAE 1.2 to appropriately build
sparsemapcontent objects in an Oracle 10.2.0.5 database.
Here are my steps:
(1) Grab the OAE nakamura zip from
https://github.com/sakaiproject/nakamura/tree/nakamura-1.2.0
(2) Unzip and head down to the contrib/oracle-jdbc directory
(3) Grab ojdbc14.jar for 10.2.0.5 from Oracle at http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
. Put the ojdbc14.jar file in contrib/oracle-jdbc directory
(4) in contrib/oracle-jdbc do a mvn clean install. This succeeds,
and appears to load the needed material into my maven repository
(5) Edit list.xml in app/src/main/bundles/ replacing
<artifactId>org.sakaiproject.nakamura.postgreswrapper</artifactId>
with <artifactId>org.sakaiproject.nakamura.ojdbc</artifactId>
(6) Create JDBCStorageClientPool.config in sling/config/org/
sakaiproject/nakamura/lite/storage/jdbc/ (creating the directories
as well, since this is the very first run.
Contents of the config file are akin to
service
.pid
="org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool"
jdbc-driver="oracle.jdbc.driver.OracleDriver"
jdbc-url="jdbc:oracle:thin:@example.edu:1521:SID0"
password="pass"
username="user"
store-base-dir="store"
Where jdbc-url, password and username are customized for my
location, and service.pid, jdbc-drive and store-base-dir are
exactly as configured for the app.
(7) Run OAE with ./tools/run_production.sh &
(8) sling/log/error.log shows nakamura resolving and starting
ojdbc[1], but subsequently initializing Apache for sparsemap usage
[2]. The system never even tries to reach oracle.
Any pointers would be gratefully received.
-- Max
[1] ==============
11.05.2012 12:32:56.675 *INFO* [FelixDispatchQueue]
org.sakaiproject.nakamura.ojdbc BundleEvent RESOLVED
11.05.2012 12:32:56.682 *INFO* [FelixDispatchQueue]
org.sakaiproject.nakamura.ojdbc BundleEvent STARTED
[2] ==============
11.05.2012 12:33:03.438 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.core
[org.sakaiproject.nakamura.lite.RepositoryImpl] Dependency not
satisfied: clientPool
11.05.2012 12:33:03.439 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.core
[org.sakaiproject.nakamura.lite.RepositoryImpl] Dependency not
satisfied: principalValidatorResolver
11.05.2012 12:33:03.445 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.core
[org.sakaiproject.nakamura.lite.RepositoryImpl] Not all
dependencies satisified, cannot activate
11.05.2012 12:33:03.460 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.core
[org.sakaiproject.nakamura.lite.RepositoryImpl] Dependency Manager:
Service principalValidatorResolver registered, activate component
11.05.2012 12:33:03.462 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.core
[org.sakaiproject.nakamura.lite.RepositoryImpl] Dependency not
satisfied: clientPool
11.05.2012 12:33:03.463 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.core
[org.sakaiproject.nakamura.lite.RepositoryImpl] Not all
dependencies satisified, cannot activate
11.05.2012 12:33:03.474 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.core Service
[org
.sakaiproject
.nakamura.lite.accesscontrol.PrincipalValidatorResolverImpl,44]
ServiceEvent REGISTERED
11.05.2012 12:33:03.499 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.core Service
[org.sakaiproject.nakamura.lite.http.SparseSessionTrackerImpl,45]
ServiceEvent REGISTERED
11.05.2012 12:33:03.500 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.core
[org
.sakaiproject
.nakamura.lite.storage.jdbc.migrate.MigrateContentComponent]
Dependency not satisfied: repository
11.05.2012 12:33:03.501 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.core
[org
.sakaiproject
.nakamura.lite.storage.jdbc.migrate.MigrateContentComponent]
Dependency not satisfied: propertyMigratorTracker
11.05.2012 12:33:03.501 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.core
[org
.sakaiproject
.nakamura.lite.storage.jdbc.migrate.MigrateContentComponent] Not
all dependencies satisified, cannot activate
11.05.2012 12:33:03.526 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.core
[org
.sakaiproject
.nakamura.lite.storage.jdbc.migrate.MigrateContentComponent]
Dependency Manager: Service propertyMigratorTracker registered,
activate component
11.05.2012 12:33:03.526 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.core
[org
.sakaiproject
.nakamura.lite.storage.jdbc.migrate.MigrateContentComponent]
Dependency not satisfied: repository
11.05.2012 12:33:03.526 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.core
[org
.sakaiproject
.nakamura.lite.storage.jdbc.migrate.MigrateContentComponent] Not
all dependencies satisified, cannot activate
11.05.2012 12:33:03.540 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.core Service
[org
.sakaiproject
.nakamura.lite.storage.jdbc.migrate.PropertyMigratorTrackerService,
46] ServiceEvent REGISTERED
11.05.2012 12:33:03.651 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool
Loaded Driver Class class org.apache.derby.jdbc.EmbeddedDriver with
classloader 48.0
11.05.2012 12:33:04.336 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool
Created Driver Instance as
org.apache.derby.jdbc.EmbeddedDriver@16f21478
11.05.2012 12:33:04.336 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool
Loaded Database Driver org.apache.derby.jdbc.EmbeddedDriver as
class org.apache.derby.jdbc.EmbeddedDriver
11.05.2012 12:33:04.337 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool
JDBC Driver Registration
[org.apache.derby.jdbc.AutoloadedDriver@513b8f62] [class
org.apache.derby.jdbc.AutoloadedDriver] [48.0]
11.05.2012 12:33:07.348 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool
No SQL configuation at org/sakaiproject/nakamura/lite/storage/jdbc/
config/client.ApacheDerby.10.6.sql
11.05.2012 12:33:07.348 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool
No SQL configuation at org/sakaiproject/nakamura/lite/storage/jdbc/
config/client.ApacheDerby.10.sql
11.05.2012 12:33:07.352 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool
Using SQL configuation from org/sakaiproject/nakamura/lite/storage/
jdbc/config/client.ApacheDerby.sql
11.05.2012 12:33:08.073 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool
Starting Sparse Map Content database
11.05.2012 12:33:08.074 *INFO* [FelixStartLevel]
org
.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool
Database Vendor: Apache Derby 10.6.2.1 - (999685)
11.05.2012 12:33:08.074 *INFO* [FelixStartLevel]
org
.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool
Database Driver: org.apache.derby.jdbc.EmbeddedDriver
11.05.2012 12:33:08.074 *INFO* [FelixStartLevel]
org
.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClientPool
Database URL : jdbc:derby:sling/sparsemap/db;create=true
11.05.2012 12:33:08.115 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClient
Schema does not exist Schema 'SA' does not exist
11.05.2012 12:33:08.117 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClient No
Schema found at org/sakaiproject/nakamura/lite/storage/jdbc/config/
client.ApacheDerby.10.6.ddl
11.05.2012 12:33:08.118 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClient No
Schema found at org/sakaiproject/nakamura/lite/storage/jdbc/config/
client.ApacheDerby.10.ddl
11.05.2012 12:33:08.356 *INFO* [FelixStartLevel]
org.sakaiproject.nakamura.lite.storage.jdbc.JDBCStorageClient SQL
OK org/sakaiproject/nakamura/lite/storage/jdbc/config/
client.ApacheDerby.ddl:7 CREATE TABLE css ( id INTEGER NOT NULL
GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1), rid
varchar(32) NOT NULL, ci
d varchar(64) NOT NULL, v varchar(780) NOT NULL, primary key(id))
_______________________________________________
oae-dev mailing list
[email protected]
http://collab.sakaiproject.org/mailman/listinfo/oae-dev
_______________________________________________
oae-dev mailing list
[email protected]
http://collab.sakaiproject.org/mailman/listinfo/oae-dev
