uPortal IRC Logs-2009-02-23

Owned by Apereo Infrastructure
Last updated: Feb 23, 2009Version comment
8 min read

[02:06:04 EST(-0500)] * dstn (n=dstn@unaffiliated/dstn) has joined ##uportal
[05:06:09 EST(-0500)] * higmad (n=chatzill@pcit-8752.HIG.SE) has joined ##uportal
[08:06:57 EST(-0500)] * athena7 (n=athena7@adsl-99-136-251-32.dsl.wlfrct.sbcglobal.net) has joined ##uportal
[08:34:17 EST(-0500)] * jayshao (n=jayshao@ool-45731e0f.dyn.optonline.net) has joined ##uportal
[09:38:28 EST(-0500)] * EricDalquist (n=dalquist@bohemia.doit.wisc.edu) has joined ##uportal
[10:19:36 EST(-0500)] <dstn> In the trunk, how do I just drop tables and not create or populate them? It used to be ant db -Dcreatetables=-nC -Dpopulatetables=-nP -Ddroptables=-D ... I'm not seeing the -n type options?
[10:20:33 EST(-0500)] <EricDalquist> its a bit more of a pain now since there are a few different db tasks that need to be called ...
[10:20:39 EST(-0500)] <EricDalquist> I'd have to go read the build.xml to see
[10:21:15 EST(-0500)] <dstn> well I tried using just ant db -Ddroptables=-D but it still populates/creates the tables
[10:23:20 EST(-0500)] * [jlee] (n=jlee@adsl-074-184-125-241.sip.asm.bellsouth.net) has joined ##uportal
[10:25:41 EST(-0500)] * [jlee_] (n=jlee@adsl-074-184-125-241.sip.asm.bellsouth.net) has joined ##uportal
[10:29:20 EST(-0500)] <EricDalquist> so it looks like that property changed a bit
[10:29:37 EST(-0500)] <EricDalquist> it uses a bunch of properties:
[10:29:38 EST(-0500)] <EricDalquist> <property name="usetable" value="-t" />
[10:29:38 EST(-0500)] <EricDalquist> <property name="tablefile" value="/properties/db/tables.xml" />
[10:29:38 EST(-0500)] <EricDalquist> <property name="usedata" value="-d" />
[10:29:38 EST(-0500)] <EricDalquist> <property name="datafile" value="/properties/db/data.xml" />
[10:29:38 EST(-0500)] <EricDalquist> <property name="createscript" value=" " />
[10:29:40 EST(-0500)] <EricDalquist> <property name="droptables" value="-D" />
[10:29:42 EST(-0500)] <EricDalquist> <property name="createtables" value="-C" />
[10:29:44 EST(-0500)] <EricDalquist> <property name="populatetables" value="-P" />
[10:29:59 EST(-0500)] <EricDalquist> so you could probably add -Dcreatetables= -Dpopulatetables=
[10:30:16 EST(-0500)] <EricDalquist> and that would remove the createtables and populatetables flags
[10:31:01 EST(-0500)] <dstn> to replace the defaults, that makes sense
[10:38:13 EST(-0500)] * holdorph (n=holdorph@wsip-98-174-242-39.ph.ph.cox.net) has joined ##uportal
[10:39:05 EST(-0500)] * lennard1 (n=sparhk@wsip-98-174-242-39.ph.ph.cox.net) has joined ##uportal
[10:52:58 EST(-0500)] * colinclark (n=colin@12.107.86.135) has joined ##uportal
[11:28:31 EST(-0500)] * michelled (n=team@142.150.154.193) has joined ##uportal
[11:48:49 EST(-0500)] * apetro (n=apetro@ip68-3-207-51.ph.ph.cox.net) has joined ##uportal
[11:52:39 EST(-0500)] <athena7> i feel really bad whenever i have to explain our ldap config file
[11:52:54 EST(-0500)] <EricDalquist> which one?
[11:53:29 EST(-0500)] <athena7> ldapContext.xml
[11:53:34 EST(-0500)] <EricDalquist> ah
[11:53:43 EST(-0500)] <athena7> in particular the part where authentication and person directory stuff are configured separately
[11:53:53 EST(-0500)] <EricDalquist> yeah
[11:54:05 EST(-0500)] <EricDalquist> I'm not sure what better options we have
[11:54:12 EST(-0500)] <EricDalquist> other than actually getting some docs out there
[11:54:34 EST(-0500)] <athena7> well
[11:54:38 EST(-0500)] <athena7> documentation, yes
[11:55:05 EST(-0500)] <athena7> eventually if we used spring ldap for that security context, we wouldn't have to monkey around w/ two configs
[11:56:32 EST(-0500)] <EricDalquist> oh yeah
[11:56:38 EST(-0500)] <EricDalquist> switching to acegi would fix that
[11:56:47 EST(-0500)] <EricDalquist> well spring-security as it is now named
[11:56:54 EST(-0500)] <EricDalquist> that can use a spring-ldap ContextSource
[11:57:48 EST(-0500)] <athena7> yeah
[12:01:30 EST(-0500)] * apetro (n=apetro@wsip-98-174-242-39.ph.ph.cox.net) has joined ##uportal
[12:04:41 EST(-0500)] * awills (n=awills@wsip-98-174-242-39.ph.ph.cox.net) has joined ##uportal
[12:16:01 EST(-0500)] * invisibill (i=80876350@gateway/web/ajax/mibbit.com/x-fe4cf35ca3e916c6) has joined ##uportal
[12:19:25 EST(-0500)] <invisibill> Greetings uPortal devs: I want to remove the sole tab for the 'guest' user and add a single tab for the 'guest-lo' user which is configured in the dlm.xml. I seem to lack the permissions as the guest user to remove the tab.
[12:20:58 EST(-0500)] <invisibill> is there a way to remove the tab for the guest user?
[12:24:24 EST(-0500)] <EricDalquist> you'd need to either log in as or swap to the guest user
[12:24:27 EST(-0500)] <EricDalquist> what version of uPortal?
[12:29:49 EST(-0500)] <athena7> you should be able to edit the guest layout either by logging in as "guest" or by using the import/export tools
[12:29:58 EST(-0500)] <athena7> but either way, you'll need to restart the portal afterwards
[12:30:35 EST(-0500)] <athena7> the guest layout is cached permanently once it's loaded
[12:33:17 EST(-0500)] <invisibill> sorry. Im in uPortal 3.0.2
[12:33:35 EST(-0500)] <invisibill> I can login as "guest" but I'm not able to remove the tab that is there.
[12:34:03 EST(-0500)] <EricDalquist> try editing the guest.layout entity file and importing it
[12:37:16 EST(-0500)] <invisibill> ok. I have commented out the tab in the guest.layout file. but this was after I'd been working with it for a while. how do I do the "import" ?
[12:37:35 EST(-0500)] <invisibill> is that an ant target?
[12:37:50 EST(-0500)] <EricDalquist> ant crn-import -Ddir=/path/to/dir/with/entity/file/ -Dpattern=guest.layout
[12:38:04 EST(-0500)] <invisibill> thanks. I'll try now.
[12:38:35 EST(-0500)] <EricDalquist> you'll need to restart the portal after doing that
[12:38:43 EST(-0500)] <EricDalquist> since the guest layout is only built once
[12:38:51 EST(-0500)] <invisibill> ok.
[13:26:53 EST(-0500)] * colinclark (n=colin@12.107.86.135) has joined ##uportal
[13:31:35 EST(-0500)] <invisibill> thanks for your help earlier. athena7 and EricDalquist the tabs are showing up better now. I'm trying to do a compound permission in my dlm.xml http://uportal.pastebin.com/m2fe52596 to show a tab for all users except the guest user (basically all logged in users) but this does not see to work.
[13:32:10 EST(-0500)] <invisibill> Is this because I"m mixing the GroupMembershipEvaluatorFactory and PersonEvaluatorFactory logic?
[13:33:31 EST(-0500)] <invisibill> I guess I can just use the PersonEvaluatorFactory with the "not" for guest.
[13:36:30 EST(-0500)] * apetro (n=apetro@wsip-98-174-242-39.ph.ph.cox.net) has joined ##uportal
[13:54:09 EST(-0500)] <EricDalquist> invisibill: your evaluator looks like it should work
[13:54:17 EST(-0500)] <EricDalquist> oh wait
[13:54:33 EST(-0500)] <EricDalquist> yeah you can't check against user attributes inside a group evaluator
[13:56:12 EST(-0500)] * colinclark (n=colin@c-98-221-165-113.hsd1.nj.comcast.net) has joined ##uportal
[13:57:07 EST(-0500)] * colinclark_ (n=colin@c-98-221-165-113.hsd1.nj.comcast.net) has joined ##uportal
[14:12:39 EST(-0500)] <invisibill> thats fine EricDalquist. I just used the person eveluator example that comes with uportal that excludes the guest, and that works fine.
[14:12:54 EST(-0500)] <EricDalquist> great
[14:33:09 EST(-0500)] <invisibill> Hi again. in the components.xsl file I'm using this xpath expression to restrict the visibility of some of the links in the "Customize My Portal" <xsl:if test="upAuth:canRender($USER_ID, 'admin.navigation.links')"> this is helpful to test against the admin group. Is there a way I can use something like this to test against other groups in the system?
[14:33:30 EST(-0500)] <EricDalquist> not yet
[14:33:33 EST(-0500)] <EricDalquist> but there will be in 3.0.3
[14:33:38 EST(-0500)] <invisibill> ok. thanks.
[14:33:43 EST(-0500)] <EricDalquist> which will be out towards the end of the week
[14:37:50 EST(-0500)] <invisibill> ok thanks.
[14:43:11 EST(-0500)] <invisibill> Hello. I want to lock a tab so that no more content can be added to it by all users. It is only showing what the fragment owner has put out there and nothing else. Is that possible?
[14:43:44 EST(-0500)] <EricDalquist> I believe so
[14:44:28 EST(-0500)] <EricDalquist> you have to click on the tab name and the column headers in customize mode when logged in as the fragment owner
[14:44:36 EST(-0500)] <EricDalquist> and you get checkboxes to lock things down
[14:44:44 EST(-0500)] <EricDalquist> you can also do it via the entity files if you want
[14:44:46 EST(-0500)] <invisibill> I'm trying to do this from the Customize section and I have selected the tab which I want to lock down . I see options to "Move Tab", "Edit Properties", "Add Columns" and "Delete Tab" but not "Add Content"
[14:44:59 EST(-0500)] <EricDalquist> uncheck add columns
[14:45:06 EST(-0500)] <EricDalquist> then on each column you have to edit the settings
[14:45:20 EST(-0500)] <EricDalquist> unfortunatly I don't think there is a tab-wide setting
[14:45:25 EST(-0500)] <EricDalquist> it is per-column
[14:45:27 EST(-0500)] <invisibill> right now none of those options is checked.
[14:45:35 EST(-0500)] <invisibill> ok.
[14:45:38 EST(-0500)] <invisibill> per column.
[14:47:42 EST(-0500)] <invisibill> That worked. Thanks again so much for your help.
[14:47:49 EST(-0500)] <EricDalquist> no problem
[15:02:42 EST(-0500)] <EricDalquist> dstn: can you look in persistenceContext.xml and see what the counterStore bean is set to?
[15:03:48 EST(-0500)] <dstn> <bean id="counterStore" class="org.jasig.portal.utils.PooledCounterStore">
[15:03:48 EST(-0500)] <dstn> <property name="dataSource" ref="PortalDb" />
[15:03:48 EST(-0500)] <dstn> <property name="transactionManager" ref="transactionManager" />
[15:03:48 EST(-0500)] <dstn> </bean>
[15:03:48 EST(-0500)] <dstn> <bean id="counterStoreFactory" class="org.jasig.portal.utils.CounterStoreFactory">
[15:03:50 EST(-0500)] <dstn> <property name="counterStore" ref="counterStore" />
[15:03:52 EST(-0500)] <dstn> </bean>
[15:03:56 EST(-0500)] <EricDalquist> weird
[15:04:10 EST(-0500)] <EricDalquist> so the SequenceGeneratorPhrase should be calling back to that eventually
[15:04:26 EST(-0500)] <EricDalquist> and that all uses Spring JDBC so it shouldn't be leaking database references like you're seeing
[15:04:27 EST(-0500)] <dstn> Ya, I'm not so sure anymore that is the problem because I just looked at the database and the data isn't even actually there!
[15:04:53 EST(-0500)] <dstn> So I'm gonna switch back to the sequencegenerator and see if the data is actually inserted
[15:05:31 EST(-0500)] <EricDalquist> ok
[15:08:13 EST(-0500)] <EricDalquist> where did you make those JDBC pool config changes that were posted?
[15:10:53 EST(-0500)] <dstn> dataSourceContext.xml
[15:10:59 EST(-0500)] <EricDalquist> ok
[15:11:31 EST(-0500)] <dstn> with the exception of connectionProperties because that's not a property of BasicDataSource
[15:13:21 EST(-0500)] <EricDalquist> maybe try setting
[15:13:22 EST(-0500)] <EricDalquist> <property name="poolPreparedStatements" value="true" />
[15:13:23 EST(-0500)] <EricDalquist> to false?
[15:32:26 EST(-0500)] <dstn> ok, so using the sequencegenerator I actually get data in the database
[15:32:37 EST(-0500)] <EricDalquist> but you run out of cursors (tongue)
[15:32:45 EST(-0500)] <dstn> lol, ya
[15:32:53 EST(-0500)] <EricDalquist> that is strange
[15:32:55 EST(-0500)] <dstn> let me try the pool property
[15:33:23 EST(-0500)] <EricDalquist> we imported 80k users and 20k layouts into an Oracle 11g database using code very close to trunk
[15:35:10 EST(-0500)] <dstn> I know, that's what I keep telling mysel
[15:35:13 EST(-0500)] <dstn> myself*
[15:35:49 EST(-0500)] <EricDalquist> do you have any local mods to the uPortal JDBC code?
[15:56:11 EST(-0500)] * dstn (n=dstn@unaffiliated/dstn) has joined ##uportal
[16:06:27 EST(-0500)] <dstn> no, no local mods to jdbc code
[16:09:03 EST(-0500)] <athena7> are you still getting that open cursor error?
[16:09:43 EST(-0500)] * lennard1 (n=sparhk@wsip-98-174-242-39.ph.ph.cox.net) has joined ##uportal
[16:10:10 EST(-0500)] <dstn> ya, trying the pooledPreparedStatments=false right now
[16:10:19 EST(-0500)] <dstn> computer locked up a min ago, had to restart
[16:13:19 EST(-0500)] <dstn> that appears to have fixed it...
[16:13:24 EST(-0500)] <invisibill> Hello again. Do I use 'ant dbunload' to export the whole uPortal db for transfer to anohter server/environment? I tried that and get an "invalid table name" exception.
[16:13:56 EST(-0500)] <EricDalquist> you actually want ant crn-export -Ddir=destDir -Dtype=all
[16:14:03 EST(-0500)] <invisibill> ok. thanks.
[16:14:51 EST(-0500)] <invisibill> then to import "crn-import -Ddir=current -Dtype=all" ?
[16:15:17 EST(-0500)] <EricDalquist> to import "crn-import -Ddir=current"
[16:15:29 EST(-0500)] <invisibill> thanks.
[16:15:31 EST(-0500)] <dstn> so I wonder if I set maxOpenPreparedStatements=300 and do poolPreparedStatments=true if that'll help
[16:15:33 EST(-0500)] <EricDalquist> though I'm not sure that is complete
[16:15:40 EST(-0500)] <EricDalquist> there are instructions in the manual for a full data migration
[16:15:57 EST(-0500)] <invisibill> ok. I'll double take there.
[16:23:12 EST(-0500)] * michelled (n=team@142.150.154.193) has left ##uportal
[16:36:20 EST(-0500)] <dstn> ok, ya, maxOpenPreparedStatements set to 300 works great
[16:36:48 EST(-0500)] <dstn> thanks for the help
[16:37:28 EST(-0500)] <awills> dstn I'm glad this got resolved
[16:37:43 EST(-0500)] <dstn> me too :-D
[16:38:12 EST(-0500)] <dstn> I'm wondering why others haven't ran into it, I guess others modify their dataSourceContext.xml first?
[16:38:18 EST(-0500)] <EricDalquist> weird
[16:38:20 EST(-0500)] <EricDalquist> we never hit it
[16:38:48 EST(-0500)] <dstn> hmm, we'll post to the list in case others have problems
[16:38:58 EST(-0500)] <EricDalquist> sounds good
[16:43:26 EST(-0500)] <invisibill> Hi. Do I need to run a database restore on an empty database or can I just run the crn-import on an existing db? I didn't see it in the import documentation http://www.ja-sig.org/wiki/display/UPM30/Importing
[16:44:55 EST(-0500)] <invisibill> I tried this on an existing db and didn't run into any error. I'm waiting for the admins to bounce tomcat to see if the changes took.
[16:53:39 EST(-0500)] <holdorph> what's the java_opt for turning on permgen reclamation?
[16:53:53 EST(-0500)] <holdorph> doh! just after eric left too, he'd know that one too.
[17:04:51 EST(-0500)] * ChanServ (ChanServ@services.) has joined ##uportal
[17:21:39 EST(-0500)] <holdorph> anyone here responsible for the uportal trunk (3.1.x) person directory work?
[17:21:51 EST(-0500)] <holdorph> or was it all Eric?
[17:25:04 EST(-0500)] * lennard1 (n=sparhk@wsip-98-174-242-39.ph.ph.cox.net) has left ##uportal
[17:28:15 EST(-0500)] * lennard2 (n=sparhk@uni1.unicon.net) has joined ##uportal
[17:28:30 EST(-0500)] <awills> i added an IPersonDirectoryDao impl in the last couple weeks
[17:29:22 EST(-0500)] <holdorph> it's a personDirectoryContext.xml file issue. definitely was eric's id that made the change. I pinged him on AIM though, and he said to just go ahead and fix what I found.
[17:29:43 EST(-0500)] <holdorph> which was that certain aliase's that used to exist in up 3.0.x and before, were dropped on accident.
[17:29:48 EST(-0500)] <holdorph> like user.name.given
[17:32:08 EST(-0500)] <awills> ah ic
[17:32:54 EST(-0500)] * ChanServ (ChanServ@services.) has joined ##uportal
[19:28:18 EST(-0500)] * ChanServ (ChanServ@services.) has joined ##uportal
[20:30:36 EST(-0500)] * lennard2 (n=sparhk@uni1.unicon.net) has left ##uportal
[20:40:39 EST(-0500)] * tsnfoo_ (n=tsnfoo@cpe-65-24-108-125.columbus.res.rr.com) has joined ##uportal
[22:12:22 EST(-0500)] * apetro (n=apetro@ip68-3-207-51.ph.ph.cox.net) has joined ##uportal
[22:17:34 EST(-0500)] * [jlee] (n=jlee@adsl-074-184-125-241.sip.asm.bellsouth.net) has joined ##uportal
[22:36:49 EST(-0500)] * [jlee] (n=jlee@adsl-074-184-125-241.sip.asm.bellsouth.net) has left ##uportal