[04:43:12 CDT(-0500)] <skreech_> athena: Hi do ing an upgrade to uportal. 4.0.6 and doing a test on the database with ant dbtest gets me the error "Caused by: org.postgresql.util.PSQLException: ERROR: relation "up_mutex" does not exist" what could be the problem?
[10:20:12 CDT(-0500)] <skreech_> Hello.
[10:21:28 CDT(-0500)] <skreech_> I'm running an upgrade to uPortal 4.0.6 and switching it to a postgresql database throws a "Caused by: org.postgresql.util.PSQLException: ERROR: relation "up_mutex" does not exist" Error.
[10:21:37 CDT(-0500)] <skreech_> Does anyone have any insight on what might cause that?
[10:21:55 CDT(-0500)] <EricDalquist> can you explain a bit more?
[10:22:14 CDT(-0500)] <EricDalquist> what do you mean switching it to a postgres database?
[10:24:03 CDT(-0500)] <skreech_> from a hsqldb
[10:24:07 CDT(-0500)] <EricDalquist> ok
[10:24:13 CDT(-0500)] <EricDalquist> how are you switching?
[10:24:15 CDT(-0500)] <EricDalquist> are you migrating data?
[10:24:30 CDT(-0500)] <EricDalquist> or did you just run "initportal" against the postgres db?
[10:25:18 CDT(-0500)] <skreech_> Well I haven't run init portal at all so far >_>
[10:25:25 CDT(-0500)] <skreech_> Migrating data
[10:25:29 CDT(-0500)] <EricDalquist> ok
[10:25:43 CDT(-0500)] <EricDalquist> can you give me a complete list of the steps you've followed?
[10:25:55 CDT(-0500)] <EricDalquist> I don't think I'm understanding what you're doing
[10:26:00 CDT(-0500)] <skreech_> just testing connectivity against the database with a test database
[10:26:38 CDT(-0500)] <skreech_> I created a newdatabase under postgres and followed the steps under the https://wiki.jasig.org/display/UPM40/PostgreSQL page
[10:26:55 CDT(-0500)] <EricDalquist> ok
[10:27:04 CDT(-0500)] <EricDalquist> so that creates the postgres schema
[10:27:08 CDT(-0500)] <EricDalquist> and verifies the portal can connect
[10:27:17 CDT(-0500)] <EricDalquist> did dbtest run successfully?
[10:27:30 CDT(-0500)] <skreech_> No it's throwing the up_mutex
[10:27:40 CDT(-0500)] <EricDalquist> oh ok
[10:28:11 CDT(-0500)] <EricDalquist> can you run
[10:28:11 CDT(-0500)] <EricDalquist> ant dbtest > dbtest.log
[10:28:24 CDT(-0500)] <EricDalquist> and paste the result somewhere like https://gist.github.com/
[10:28:34 CDT(-0500)] <EricDalquist> make sure you check that the db credentials aren't in the output
[10:29:03 CDT(-0500)] <EricDalquist> also in the future stating the command/task you're running that throws the error when reporting the error is really helpful
[10:29:12 CDT(-0500)] <EricDalquist> otherwise we're just guessing at what you're doing
[10:29:31 CDT(-0500)] <skreech_> Sorry I had said I was running ant dbtest but before you logged in
[10:29:42 CDT(-0500)] <EricDalquist> ah
[10:31:22 CDT(-0500)] <skreech_> The output loops so I'll tee it and choose some time and kill it
[10:31:33 CDT(-0500)] <EricDalquist> ah ok
[10:44:04 CDT(-0500)] <skreech_> http://pastebin.ca/2228875
[10:44:29 CDT(-0500)] <EricDalquist> ok ... so your dbtest looks good
[10:44:42 CDT(-0500)] <EricDalquist> this just looks like a bug in the dbtest in 4.0.6 that fails to shut down the app context
[10:45:08 CDT(-0500)] <skreech_> Ah
[10:46:29 CDT(-0500)] <EricDalquist> https://issues.jasig.org/browse/UP-3583
[10:46:37 CDT(-0500)] <EricDalquist> so you can continue with initportal
[10:48:24 CDT(-0500)] <skreech_> web.RequestAttributeSourceFilter.[] 2012-09-28 15:45:39,710 - No username found for attribute 'null' among is also something I notice in the logs. Is that an initportal issue as well?
[10:48:41 CDT(-0500)] <EricDalquist> that is just an overzealous log message
[10:48:46 CDT(-0500)] <EricDalquist> I think that is fixed in 4.0.7
[10:48:51 CDT(-0500)] <EricDalquist> you can ignore it
[10:49:07 CDT(-0500)] <skreech_> Alright 
[10:51:50 CDT(-0500)] <athena> morning EricDalquist
[10:51:55 CDT(-0500)] <EricDalquist> morning
[10:52:06 CDT(-0500)] <athena> jwennmacher created a pull request for making all our log directories and the default log level configurable
[10:52:15 CDT(-0500)] <athena> do you have any worried about that going into 4.0.x as well?
[10:53:55 CDT(-0500)] <EricDalquist> I don't think so
[10:54:07 CDT(-0500)] <EricDalquist> the patch will need tweaking since 4.0 is using log4j
[10:54:09 CDT(-0500)] <EricDalquist> and not logback
[10:54:54 CDT(-0500)] <athena> well
[10:55:17 CDT(-0500)] <athena> er, ok, backing up first
[10:55:22 CDT(-0500)] <athena> clearly i need to go actually make some coffee
[10:55:30 CDT(-0500)] <athena> so most of the change is for the portlets, which aren't yet using logback
[10:55:35 CDT(-0500)] <EricDalquist> right
[10:55:41 CDT(-0500)] <EricDalquist> I took a peek at it
[10:55:56 CDT(-0500)] <EricDalquist> I was just saying that you can't just cherry-pick it into 4.0
[10:56:05 CDT(-0500)] <athena> oh
[10:56:06 CDT(-0500)] <athena> yes
[10:56:10 CDT(-0500)] <EricDalquist> since logback.xml for the portal doesn't exist in 4.0
[10:56:15 CDT(-0500)] <athena> just wanted to make sure that we wanted to backport it
[10:56:18 CDT(-0500)] <EricDalquist> yeah
[10:56:20 CDT(-0500)] <EricDalquist> I'm fine with that
[10:56:21 CDT(-0500)] <athena> should be easy enough to just modify that one file
[10:56:22 CDT(-0500)] <athena> ok
[10:56:28 CDT(-0500)] <athena> i'll take care of that today
[10:56:30 CDT(-0500)] <EricDalquist> found and fixed several reporting related bugs
[10:56:37 CDT(-0500)] <EricDalquist> I think I'll get this in today
[10:56:42 CDT(-0500)] <EricDalquist> also added some neat features ....
[10:56:48 CDT(-0500)] <EricDalquist> like the ability to download the graph as a png
[10:57:00 CDT(-0500)] <EricDalquist> getting both html and csv versions of the data
[10:57:16 CDT(-0500)] <athena> oh nice!
[10:57:19 CDT(-0500)] <athena> that's terrific
[10:57:23 CDT(-0500)] <athena> thanks so much for finishing that off
[10:57:27 CDT(-0500)] <EricDalquist> yup
[10:57:31 CDT(-0500)] <athena> should be pretty cool
[10:57:38 CDT(-0500)] <EricDalquist> there were some gross bugs in a few existing methods
[10:58:28 CDT(-0500)] <athena> yeah, i noticed some weird behavior when i was getting screenshots for the coop dev forum
[11:22:38 CDT(-0500)] <skreech_> Hmm
[11:23:03 CDT(-0500)] <Daskreech> It's pairing the wrong username with the database when I run ant stop
[11:23:25 CDT(-0500)] <Daskreech> it's using the username sa
[11:24:05 CDT(-0500)] <Daskreech> is that from the data-test properties ?
[11:25:47 CDT(-0500)] <Daskreech> ok I think it may be from the dataSource.properties
[11:27:01 CDT(-0500)] <Daskreech> No that's pulling from local.properties
[11:27:31 CDT(-0500)] <athena> if you make any changes to local.properties, make sure you do a full clean, then deploy-ear
[11:28:33 CDT(-0500)] <Daskreech> athena: ah so why would it change the database it's connecting to but not the user?
[11:29:46 CDT(-0500)] <athena> what have you done so far? did you make changes to local.properties or to another file?
[11:30:18 CDT(-0500)] <Daskreech> local.properties. All the other files are pulling fromthat file
[11:31:07 CDT(-0500)] <Daskreech> I just did a grep for all the files with a username of sa and they are pretty much all commented out except for properties files for test cases
[11:31:51 CDT(-0500)] <Daskreech> so I think I should have all the files that reference sa.
[11:39:17 CDT(-0500)] <athena> ok
[11:39:41 CDT(-0500)] <athena> the way uportal works these days, you only edit local.properties
[11:39:48 CDT(-0500)] <athena> everything else gets replaced during the build
[11:40:07 CDT(-0500)] <athena> i'd recommend reverting those changes, updating local.properties, and running an ant clean deploy-ear
[11:40:59 CDT(-0500)] <athena> https://wiki.jasig.org/display/UPM40/PostgreSQL
[11:42:00 CDT(-0500)] <athena> EricDalquist: as of the last commit, i think the web proxy portlet is baseline usable
[11:42:08 CDT(-0500)] <athena> missing a large number of features, of course
[11:42:19 CDT(-0500)] <athena> but i think it's working for simple use cases
[11:50:59 CDT(-0500)] <skreech_> I just said I only edited local.properties
[11:51:25 CDT(-0500)] <athena> sorry
[11:51:37 CDT(-0500)] <athena> missed the first comment, just saw the grep one
[11:51:43 CDT(-0500)] <Daskreech> No problems
[11:51:57 CDT(-0500)] <athena> hmm.
[11:52:02 CDT(-0500)] <athena> are you using the quickstart?
[11:54:24 CDT(-0500)] <Daskreech> yes
[11:54:50 CDT(-0500)] <Daskreech> rerunning deploy-ear
[11:55:11 CDT(-0500)] <athena> ah! ok
[11:55:42 CDT(-0500)] <athena> so ant start starts up tomcat as well as an hsql instance
[11:55:56 CDT(-0500)] <athena> it's really targeted towards simple evaluation rather than development or production use
[11:56:19 CDT(-0500)] <athena> so ant start and ant stop are going to start / stop the test hsql instance regardless of what the properties file indicates
[11:56:30 CDT(-0500)] <athena> you might want to switch over to using uportal from source at some point
[12:18:43 CDT(-0500)] <drewwills> hey folks, question: what do we do about license headers for JS & CSS files that we bundle with Jasig portlets but that come from somewhere else?
[12:18:47 CDT(-0500)] <drewwills> example: https://github.com/Jasig/AnnouncementsPortlet/blob/master/src/main/webapp/date-picker/js/datepicker.js
[12:19:13 CDT(-0500)] <drewwills> but that one is in announcements, which hasn't had a release in m2 central...
[12:19:27 CDT(-0500)] <drewwills> would that license header pass license:check?
[12:36:51 CDT(-0500)] <athena> drewwills: we exclude them from the license headers plugin
[12:38:56 CDT(-0500)] <drewwills> yeah i found some info in that... just made a guess that's the right thing to do
[12:42:27 CDT(-0500)] <EricDalquist> skreech__: you still there?
[12:50:33 CDT(-0500)] <skreech__> EricDalquist: Yes but My internet is getting really unstable
[12:50:50 CDT(-0500)] <EricDalquist> so I saw you were running "ant stop" against postgresql?
[12:51:00 CDT(-0500)] <EricDalquist> are you pointing the quickstart at a postgres db?
[12:51:07 CDT(-0500)] <skreech__> kicking me off every few minutes which makes remote administration umm let's label it annoying
[12:51:21 CDT(-0500)] <skreech__> EricDalquist: Yes athena just said that I should switch to source
[12:51:32 CDT(-0500)] <EricDalquist> yeah ... "ant stop" is very quickstart specific
[12:51:59 CDT(-0500)] <EricDalquist> and includes a call to the hsql-shutdown ant target
[12:52:09 CDT(-0500)] <EricDalquist> which is where you were seeing that sa user connection from
[12:52:20 CDT(-0500)] <EricDalquist> as that isn't intended for non hsql-local dbs
[12:52:38 CDT(-0500)] <Daskreech> Yes
[12:52:39 CDT(-0500)] <EricDalquist> switching to a source release will solve that though
[12:52:47 CDT(-0500)] <Daskreech> My issue right now is the server is out of space
[12:53:04 CDT(-0500)] <Daskreech> so I'm trying to solve that without being kicked off during transfer
[12:53:19 CDT(-0500)] <EricDalquist> :/
[12:54:38 CDT(-0500)] <Daskreech> first world problems
[12:54:48 CDT(-0500)] <Daskreech> I had much better internet in the Caribbean 
[14:28:59 CDT(-0500)] <athena> ok, logs patch looks mostly good
[14:29:07 CDT(-0500)] <athena> but i'm wondering if we should make the property names more consistent
[14:29:33 CDT(-0500)] <athena> all of our existing properties start with "environment.build" to make it really clear that they're coming from the filter file
[14:29:58 CDT(-0500)] <athena> i'm wondering if it might make sense to change portal.logging.* to environment.build.log.*
[14:30:12 CDT(-0500)] <athena> it seems like that'd keep things more consistent
[14:33:29 CDT(-0500)] <EricDalquist> sounds good to me
[14:39:13 CDT(-0500)] <athena> ok
[14:39:21 CDT(-0500)] <athena> jwennmacher: when you get back, let me know what you think of the above
[14:39:30 CDT(-0500)] <athena> how are we looking for 4.0.7?
[14:41:37 CDT(-0500)] <EricDalquist> good
[14:41:40 CDT(-0500)] <EricDalquist> probably monday again
[14:41:48 CDT(-0500)] <EricDalquist> baring getting sick and missing half a week
[14:45:00 CDT(-0500)] <athena>
[14:45:42 CDT(-0500)] <athena> hah the marching band is practicing
[14:47:09 CDT(-0500)] <athena> maybe once that's set we can talk a bit about the web proxy portlet
[14:47:16 CDT(-0500)] <athena> make sure there's a clear list of features that need adding
[14:47:59 CDT(-0500)] <EricDalquist> sounds good
[14:49:57 CDT(-0500)] <athena> by the way, the hamburgler message keeps randomly opening on my portal page
[14:50:00 CDT(-0500)] <athena> any idea what's going on there?
[14:50:08 CDT(-0500)] <athena> i don't have it enabled
[14:50:23 CDT(-0500)] <EricDalquist> huh?
[14:50:28 CDT(-0500)] <athena> the emergency alert portlet
[14:50:42 CDT(-0500)] <athena> when i go to the admin account, then click on at least one other tab
[14:50:47 CDT(-0500)] <athena> it appears in the heaer
[14:50:49 CDT(-0500)] <athena> er, header
[14:51:12 CDT(-0500)] <athena> haven't looked into it yet, wasn't sure if you were seeing that too
[14:51:21 CDT(-0500)] <EricDalquist> I might be
[14:51:24 CDT(-0500)] <EricDalquist> haven't notice if I have
[14:51:31 CDT(-0500)] <athena> you'd notice
[14:51:33 CDT(-0500)] <athena> it's giant
[14:51:35 CDT(-0500)] <athena>
[14:51:47 CDT(-0500)] <EricDalquist> ah
[14:51:47 CDT(-0500)] <EricDalquist> ok
[14:51:52 CDT(-0500)] <EricDalquist> well time to go home and paint more
[14:51:55 CDT(-0500)] <athena> enjoy!
[14:52:03 CDT(-0500)] <EricDalquist> going to try and get this stats stuff in tonight
[14:52:04 CDT(-0500)] <athena> close to done?
[14:52:05 CDT(-0500)] <athena> awesome
[14:52:08 CDT(-0500)] <EricDalquist> lots of little things there
[14:52:12 CDT(-0500)] <EricDalquist> but making progress
[14:52:15 CDT(-0500)] <EricDalquist> and almost done painting
[14:52:19 CDT(-0500)] <EricDalquist> one more coat for the color
[14:52:22 CDT(-0500)] <EricDalquist> then lots of touch up 
[14:52:48 CDT(-0500)] <athena>
[15:55:11 CDT(-0500)] <jwennmacher> RE 'change portal.logging.* to environment.build.log.*' that sounds fine. I'll make the changes and submit a pull request
[15:59:39 CDT(-0500)] <athena> thanks!