Re: [uportal-user] uportal-start will not initialize data

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: [uportal-user] uportal-start will not initialize data

rpixley .
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.

On Tuesday, March 2, 2021, 11:35:27 AM EST, Benito Gonzalez <[hidden email]> wrote:


Hi,

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

Best,
-bjagg


On Tue, Mar 2, 2021 at 4:32 AM rpixley . <[hidden email]> wrote:
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?

--
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 [hidden email].
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.

--
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 [hidden email].
To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/uportal-user/CAJ_1GkSjNm4ES14X_yETUm%2BGqMJsB3gy9cs%3DBCAvmWeQAMKzFg%40mail.gmail.com.

--
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 [hidden email].
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.
Reply | Threaded
Open this post in threaded view
|

Re: [uportal-user] uportal-start will not initialize data

rpixley .
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

On Tuesday, March 2, 2021, 02:28:43 PM EST, Ryan Melissari <[hidden email]> wrote:


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. 

On Tue, Mar 2, 2021 at 1:15 PM rpixley . <[hidden email]> wrote:
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.

On Tuesday, March 2, 2021, 11:35:27 AM EST, Benito Gonzalez <[hidden email]> wrote:


Hi,

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

Best,
-bjagg


On Tue, Mar 2, 2021 at 4:32 AM rpixley . <[hidden email]> wrote:
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?

--
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 [hidden email].
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.

--
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 [hidden email].
To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/uportal-user/CAJ_1GkSjNm4ES14X_yETUm%2BGqMJsB3gy9cs%3DBCAvmWeQAMKzFg%40mail.gmail.com.

--
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 [hidden email].
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.

--
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 [hidden email].
To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/uportal-user/CAFngfG9xOZn8vSBFXaTv08gpi%2BgBzCoRAViNiwUnwDtXFbZeWA%40mail.gmail.com.

--
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 [hidden email].
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.
Reply | Threaded
Open this post in threaded view
|

Re: Ex: Re: [uportal-user] uportal-start will not initialize data

rpixley .
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.

On Saturday, March 6, 2021, 05:09:12 PM EST, rpixley . <[hidden email]> wrote:


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

On Friday, March 5, 2021, 05:43:55 PM EST, Jonathan M. Tran <[hidden email]> wrote:


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: [hidden email] <[hidden email]> on behalf of rpixley . <[hidden email]>
Sent: Friday, March 5, 2021 14:02
To: Ryan Melissari <[hidden email]>
Cc: Benito Gonzalez <[hidden email]>; [hidden email] <[hidden email]>
Subject: Ex: Re: [uportal-user] uportal-start will not initialize data
 
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

On Tuesday, March 2, 2021, 02:28:43 PM EST, Ryan Melissari <[hidden email]> wrote:


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. 

On Tue, Mar 2, 2021 at 1:15 PM rpixley . <[hidden email]> wrote:
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.

On Tuesday, March 2, 2021, 11:35:27 AM EST, Benito Gonzalez <[hidden email]> wrote:


Hi,

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

Best,
-bjagg


On Tue, Mar 2, 2021 at 4:32 AM rpixley . <[hidden email]> wrote:
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?

--
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 [hidden email].
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.

--
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 [hidden email].
To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/uportal-user/CAJ_1GkSjNm4ES14X_yETUm%2BGqMJsB3gy9cs%3DBCAvmWeQAMKzFg%40mail.gmail.com.

--
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 [hidden email].
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.

--
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 [hidden email].
To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/uportal-user/CAFngfG9xOZn8vSBFXaTv08gpi%2BgBzCoRAViNiwUnwDtXFbZeWA%40mail.gmail.com.

--
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 [hidden email].
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 [hidden email].

--
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 [hidden email].
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/uportal-user/BYAPR01MB49353C2ADACF579D652FB2B4B0969%40BYAPR01MB4935.prod.exchangelabs.com
.

--
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 [hidden email].
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/uportal-user/660279726.202814.1615068544130%40mail.yahoo.com
.

--
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 [hidden email].
To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/uportal-user/1112510714.2615017.1616308869354%40mail.yahoo.com.