uPortal IRC Logs-2009-02-09

Owned by Apereo Infrastructure
Last updated: Feb 09, 2009Version comment
6 min read

[11:13:57 EST(-0500)] * JASIGLogBot (n=PircBot@jasigch.Princeton.EDU) has joined ##uportal
[11:13:57 EST(-0500)] * Topic is 'http://uportal.pastebin.com/ - http://www.ja-sig.org/wiki/display/UPC/uportal+IRC+Logs' set by EricDalquist on 2008-02-27 12:32:13 EST(-0500)
[11:15:51 EST(-0500)] <dstn> k, let me try that
[11:16:43 EST(-0500)] <dstn> question...should I be using what's in trunk or out of that export.zip? I used export.zip based on what's in the uPortal manual
[11:17:04 EST(-0500)] <EricDalquist> I'm trying to remember ...
[11:17:21 EST(-0500)] <EricDalquist> the import/export scripts in trunk are the most recent
[11:17:34 EST(-0500)] <EricDalquist> but I thought I had updated the 2.x export scripts but I may not have
[11:18:29 EST(-0500)] * jayshao (n=jayshao@ool-45731e0f.dyn.optonline.net) has joined ##uportal
[11:24:29 EST(-0500)] * apetro (n=apetro@12.164.139.7) has joined ##uportal
[11:34:32 EST(-0500)] <dstn> is there any reason I couldn't use the trunk to export 2.6 data or is it necessary/suggested to export using the same codebase?
[11:34:48 EST(-0500)] <EricDalquist> you HAVE TO use the same codebase
[11:34:55 EST(-0500)] <EricDalquist> database tables are different
[11:34:58 EST(-0500)] <EricDalquist> DAOs are different
[11:35:08 EST(-0500)] <dstn> ok, thanks
[11:35:52 EST(-0500)] <EricDalquist> so the better line would be: "you have to use the same minor release, if you're using 2.6, you have to use some version of 2.6 to do the export"
[11:36:03 EST(-0500)] * [jlee] (n=jlee@adsl-074-184-125-241.sip.asm.bellsouth.net) has joined ##uportal
[11:40:54 EST(-0500)] <dstn> i c
[11:41:30 EST(-0500)] <dstn> it'd be nice to have a rel-2.6-export, rel-2.5-export branch with the latest retrofitted import/export, is that possible?
[11:42:14 EST(-0500)] <dstn> if so, I'm going to try to do 2.6 since I'm still having issues with the export.zip one
[11:56:08 EST(-0500)] <athena7> do the import/export scripts support edited fragments yet?
[11:56:31 EST(-0500)] <EricDalquist> athena7: "edited fragments"
[11:57:01 EST(-0500)] <athena7> so i believe at least at one point it was the case that if a pushed DLM fragment was edited by a user, there was no representation of that edit in the exported layout
[11:57:13 EST(-0500)] <EricDalquist> dstn: it would be very good for someone to take the latest export scripts from trunk and figure out how to merge them back into 2.6-patches and 2.5-patches
[11:57:27 EST(-0500)] <EricDalquist> if you were so inclined to do so the commits would be very much welcome
[11:57:40 EST(-0500)] <EricDalquist> ah
[11:57:52 EST(-0500)] <EricDalquist> yes the latest export scripts support DLM nodes just fine
[11:58:10 EST(-0500)] <EricDalquist> we used the same approach as we came up with for portlet entity preferences
[11:58:14 EST(-0500)] <EricDalquist> with XPATH node references
[11:58:47 EST(-0500)] <EricDalquist> so you get a DLM node entry with a reference that looks like "lo-welcome:/layout/folder/folder[2]/channel"
[11:59:06 EST(-0500)] <EricDalquist> which is the XML equivalent of the u12l1n32 syntax used in the DB
[11:59:28 EST(-0500)] <EricDalquist> the export scripts in the zip file dstn is using should do that as well
[11:59:43 EST(-0500)] <athena7> yay (smile)
[11:59:48 EST(-0500)] <athena7> glad to hear that's all set up
[12:00:06 EST(-0500)] <athena7> what about user-level permissions on channels?
[12:00:10 EST(-0500)] <EricDalquist> nope
[12:00:21 EST(-0500)] <EricDalquist> someone just needs to add it
[12:00:24 EST(-0500)] <EricDalquist> shouldn't be too hard
[12:00:44 EST(-0500)] <athena7> yeah
[13:01:19 EST(-0500)] * athena7 (n=athena7@12.164.139.7) has joined ##uportal
[13:19:46 EST(-0500)] * athena7_ (n=athena7@12.164.139.7) has joined ##uportal
[13:43:57 EST(-0500)] * athena7 (n=athena7@12.164.139.7) has joined ##uportal
[15:17:42 EST(-0500)] * colinclark (n=colin@142.150.154.101) has joined ##uportal
[15:17:42 EST(-0500)] * awills (n=awills@wsip-98-174-242-39.ph.ph.cox.net) has joined ##uportal
[16:12:41 EST(-0500)] * jayshao (n=jayshao@ool-45731e0f.dyn.optonline.net) has joined ##uportal
[16:19:42 EST(-0500)] * invisibill (i=80876350@gateway/web/ajax/mibbit.com/x-641aaaa550a50815) has joined ##uportal
[16:21:04 EST(-0500)] <invisibill> Greetings uPortal devs: I'm getting an exception when trying to run either an initportal or initdb: http://uportal.pastebin.com/m1265bf5f Its a reqular class not found exception, but I'm not sure where the oracle driver needs to be.
[16:21:54 EST(-0500)] <invisibill> the driver is located in the WEB-INF/lib of the extracted uPortal war. does it need to be somewhere else?
[16:22:10 EST(-0500)] <EricDalquist> http://www.ja-sig.org/wiki/display/UPM30/04+Oracle
[16:45:17 EST(-0500)] <invisibill> ok. I went thorugh the Oracle configuration from the wiki and am still coming up with error for 'ant dbtest' http://uportal.pastebin.com/m274acaeb could this line in the log ' [java] WARN [main] cfg.SettingsFactory Feb/09 15:39:33.487 - Could not obtain connection metadata' be a hint that the remote oracle db is down?
[16:49:46 EST(-0500)] <holdorph> can you use a db tool to determine if your database connection properites are right/the database is up
[16:50:00 EST(-0500)] <holdorph> something like db visualizer, squirrel, or comparable tool?
[16:51:39 EST(-0500)] <invisibill> I don't have any of those running, but I just tried the deploy-ear target followed by deploy war and see this in the logs "Caused by: java.sql.SQLException: ORA-00942: table or view does not exist " does that mean I can connect but the db is not initialized. I apologize but I'm not well versed with oracle errors .
[16:52:30 EST(-0500)] <EricDalquist> that last pastebin still shows: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'
[16:53:06 EST(-0500)] <invisibill> I know. I have the jar files in my repository
[16:53:17 EST(-0500)] <EricDalquist> and you've updated the uPortal pom.xml file with the Oracle driver info?
[16:54:12 EST(-0500)] <EricDalquist> if you run "mvn dependency:tree" in the uPortal directory you should see your oracle driver listed in the output
[16:54:22 EST(-0500)] <invisibill> I do. When I do the actual deploy, the connection pool is erroring org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFact ory (ORA-00942: table or view does not exist )
[16:54:38 EST(-0500)] <invisibill> ok. I'll try that.
[16:54:47 EST(-0500)] <EricDalquist> but that isn't the error in your pastebin bost
[16:54:48 EST(-0500)] <EricDalquist> post
[16:55:17 EST(-0500)] <invisibill> the pastebin post is of the ant testdb
[16:55:42 EST(-0500)] <invisibill> the pasted error here is from ant deploy-ear && ant deploy-war
[16:56:05 EST(-0500)] <EricDalquist> so you said you manually copied the oracle jar into WEB-INF/lib?
[16:56:17 EST(-0500)] <EricDalquist> that would be why you get different output from starting the portal versus dbtest
[16:56:26 EST(-0500)] <EricDalquist> I'm assuming 'ant initportal' failed?
[16:56:44 EST(-0500)] <invisibill> yes that also failed.
[16:56:55 EST(-0500)] <invisibill> that i believe was my first pastebin
[16:57:26 EST(-0500)] <EricDalquist> ok, well until initportal completes successfully starting the portal will always fail
[16:58:59 EST(-0500)] <holdorph> you should get a tool to connect to your database, that's useful with or without db errors
[16:59:20 EST(-0500)] <invisibill> I'm rying to pastebin the mvn dependency:tree but it is giving a spam filter errror
[16:59:44 EST(-0500)] <EricDalquist> what OS are you on?
[17:00:18 EST(-0500)] <EricDalquist> on linux/unix/mac an easy way to check is:
[17:00:21 EST(-0500)] <EricDalquist> mvn dependency:tree | grep oracle
[17:00:24 EST(-0500)] <EricDalquist> I get:
[17:00:25 EST(-0500)] <EricDalquist> [INFO] +- com.oracle:ojdbc5:jar:11.1.0.6.0:provided
[17:00:25 EST(-0500)] <EricDalquist> [INFO] +- com.oracle:ojdbc5:jar:11.1.0.6.0:compile
[17:00:35 EST(-0500)] <invisibill> http://uportal.pastebin.com/m4419ff2a that is the depenency tree but I'm not sure how to read it.
[17:00:52 EST(-0500)] <invisibill> Linux piglet 2.6.18-92.1.22.el5 #1 SMP Fri Dec 5 09:29:46 EST 2008 i686 athlon i386 GNU/Linux
[17:01:08 EST(-0500)] * awills (n=awills@wsip-98-174-242-39.ph.ph.cox.net) has joined ##uportal
[17:01:24 EST(-0500)] <EricDalquist> it looks like you're still configured to use HSQL
[17:01:55 EST(-0500)] <EricDalquist> if you open the pom.xml file in the root uPortal directory
[17:02:00 EST(-0500)] <EricDalquist> what are the 3 lines under the line: <!-- The JDBC Driver used by uPortal -->
[17:07:08 EST(-0500)] <invisibill> its hibernate, but I'm running it with "mvn -e clean install -Pstage -Dmaven.test.skip=true && ant dbtest" here is my pom.xml http://uportal.pastebin.com/m798a22ba
[17:07:32 EST(-0500)] <EricDalquist> the manual page states that you need to change those 3 lines
[17:07:51 EST(-0500)] <EricDalquist> so on http://www.ja-sig.org/wiki/display/UPM30/04+Oracle
[17:08:10 EST(-0500)] <EricDalquist> there is the line: "We will add the Oracle driver here using the group, artifact and version information from the mvn install:install-file command above."
[17:08:35 EST(-0500)] <invisibill> so for the purposes of the init db I need to change them. then I can change back after the db is initialized?
[17:08:42 EST(-0500)] <EricDalquist> no
[17:08:52 EST(-0500)] <EricDalquist> that section tells uPortal you're using an Oracle JDBC driver
[17:08:56 EST(-0500)] <EricDalquist> not HSQL JDBC Driver
[17:09:08 EST(-0500)] <EricDalquist> HSQL != Hibernate
[17:09:18 EST(-0500)] <EricDalquist> HSQL is a light-weight Java database used for local development and testing
[17:09:24 EST(-0500)] <invisibill> right. I' meant hsql
[17:09:41 EST(-0500)] <EricDalquist> so if you want to use HSQL locally you would have to change it back
[17:10:02 EST(-0500)] <invisibill> thats what we are doing with the Profiles at the bottom of the pom.
[17:10:14 EST(-0500)] <EricDalquist> but to do anything with regards to your deployment DB those lines in the pom.xml need to specify the JDBC driver you're using
[17:10:35 EST(-0500)] <invisibill> I see. I'm going to change them now and try the build.
[17:10:36 EST(-0500)] <EricDalquist> specifying those also result in the correct driver being included when you run initportal or deploy-war
[17:18:57 EST(-0500)] <invisibill> thanks for your help. this is not quite resolved but I think I can take a fresh start with this in the morning.
[19:37:47 EST(-0500)] * athena7 (n=athena7@ip68-230-77-209.ph.ph.cox.net) has joined ##uportal
[20:11:29 EST(-0500)] * awills (n=awills@wsip-98-174-242-39.ph.ph.cox.net) has left ##uportal
[23:51:54 EST(-0500)] * colinclark (n=colin@bas2-toronto09-1176131452.dsl.bell.ca) has joined ##uportal