uportal-start will not initialize data

41 views
Skip to first unread message

rpixley .

unread,
Mar 2, 2021, 7:32:35 AM3/2/21
to uporta...@apereo.org
Hello,

I'm running debian 10 and followed the instructions for running a fresh uPortal-start. Installed JDK8 and git cloned uPortal-start. 
Runing gradlew portalInit throws a build execption of overlays:uPortal:dataInit FAILED alongside multiple java.sql.SQLSyntaxErrorExceptions of user lacks privilege or object not found.

What could be the source of the errors?

Benito Gonzalez

unread,
Mar 2, 2021, 11:35:25 AM3/2/21
to rpixley ., uporta...@apereo.org
Hi,

Did you configure a separate database? If not, I would check file ownership/permissions under .gradle/hsqldb .

Best,
-bjagg


--
You received this message because you are subscribed to the Google Groups "uPortal Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to uportal-user...@apereo.org.
To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/uportal-user/777334023.843359.1614688352859%40mail.yahoo.com.

rpixley .

unread,
Mar 2, 2021, 2:15:43 PM3/2/21
to Benito Gonzalez, uporta...@apereo.org
I had not. It was very simply the uPortal-start from git and an install of JDK8 on Debian 10. I am running the script as root and all the files and directories are owned by root.

Ryan Melissari

unread,
Mar 2, 2021, 2:28:41 PM3/2/21
to rpixley ., Benito Gonzalez, uporta...@apereo.org
Try running as a non-root user after resetting all the permissions.  I have seen an issue with the newer versions of NPM that the gradle script uses have issues with running as root since it doesn't have the --allow-root flag set. 

To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/uportal-user/1707441620.968659.1614712538089%40mail.yahoo.com.

rpixley .

unread,
Mar 5, 2021, 5:02:56 PM3/5/21
to Ryan Melissari, Benito Gonzalez, uporta...@apereo.org
That seems to have worked after wiping the configs and redownloading. I've now a nice default uPortal 5 instance up and running. I am trying to find some documentation for configuring Postgresql with uPortal 5 and all the ones I have seem to be for uPortal 4. Do you know of any information I can read through for that process?

Roger

Jonathan M. Tran

unread,
Mar 5, 2021, 5:43:53 PM3/5/21
to uporta...@apereo.org
The docs folder has some documentation for getting uPortal work with PostgreSQL: https://github.com/uPortal-Project/uPortal-start/blob/master/docs/en/database/postgresql.md

Hope this helps!
From: uporta...@apereo.org <uporta...@apereo.org> on behalf of rpixley . <rpi...@thelvws.com>
Sent: Friday, March 5, 2021 14:02
To: Ryan Melissari <rmeli...@tamu.edu>
Cc: Benito Gonzalez <bgon...@unicon.net>; uporta...@apereo.org <uporta...@apereo.org>
Subject: Ex: Re: [uportal-user] uportal-start will not initialize data
 
To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/uportal-user/1015962907.36769.1614981768925%40mail.yahoo.com.
CAUTION: This email was not sent from a Cal Poly Pomona service. Exercise caution when clicking links or opening attachments. Please forward suspicious email to suspec...@cpp.edu.

rpixley .

unread,
Mar 6, 2021, 5:09:11 PM3/6/21
to uporta...@apereo.org, Jonathan M. Tran
Yes I followed that. The only two aspects that I might have had a question on was Maven's site had a version number with jre appeneded to the end. I included that with the version string but I didn't know if I should have. The other inquiry was I am using Postgresql 12 but I did not know if that made a difference in my setup. 

Other than that I can login manually to the db, I have rights etc. When I run my portalInit I get a dataInit error against Announcements

> Task :overlays:Announcements:dataInit FAILED

FAILURE: Build failed with an exception.

* Where:
Build file '/home/portal/deploy/uPortal-start/overlays/Announcements/build.gradle' line: 55

* What went wrong:
Execution failed for task ':overlays:Announcements:dataInit'.
> Java returned: 1

I'm assuming that Announcements would be the first alphabetized data instance in the build 

line 55 says 

ant.java(fork: true, failonerror: true, dir: rootProject.projectDir, classname: 'org.jasig.portlet.announcements.SchemaCreator')


Not sure what from that is making it fail.

Roger

rpixley .

unread,
Mar 21, 2021, 2:41:16 AM3/21/21
to uporta...@apereo.org, Jonathan M. Tran
I have taken a few shots at this. I keep hittin on the Announcements not being able to Initalize the data in the database. Is there a better method of troubleshooting? I do know that although I have the hslqdb section on the global.properties disabled in favour of the postgresql connection section I am still seeing a hsqldb running check in my portalInit logs.

Reply all
Reply to author
Forward
0 new messages