uPortal IRC Logs-2012-09-28

Owned by Apereo Infrastructure
Last updated: Sept 28, 2012Version comment
8 min read

[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

Unknown macro: {serverName=[74.50.61.81]}

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 (smile)

[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 (smile)

[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 (smile)

[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_> (smile) I just said I only edited local.properties (smile)

[11:51:25 CDT(-0500)] <athena> sorry (smile)

[11:51:37 CDT(-0500)] <athena> missed the first comment, just saw the grep one

[11:51:43 CDT(-0500)] <Daskreech> No problems (smile)

[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 (smile)

[12:52:39 CDT(-0500)] <EricDalquist> switching to a source release will solve that though (smile)

[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 (smile)

[12:54:48 CDT(-0500)] <Daskreech> I had much better internet in the Caribbean (sad)

[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> (smile)

[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> (smile)

[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 (tongue)

[14:52:48 CDT(-0500)] <athena> (smile)

[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!