Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Christoph Hug (CHRISHUG)
Sopra Steria AG

Sopra Steria AG
CH
CHRISHUG Member since 2013 9 posts
Sopra Steria AG
Posted: Dec 13, 2017
Last activity: Dec 13, 2017
Posted: 13 Dec 2017 3:50 EST
Last activity: 13 Dec 2017 5:10 EST
Closed
Solved

Error while deployment of prweb.war

Hello Community

I'm on an insallation of Pega 7.3.1 with Tomcat and Postgresql with split schema.

While the deployment of the prweb.war, I'm getting the following error:

SEVERE [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Unable to connect to database.  Will only use properties from file.
 org.postgresql.util.PSQLException: ERROR: permission denied for schema prpc_data
  Position: 34
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)

I granted the user on the DB-Schema.

The context.xml (<Tomcat>/conf/context.xml) is the follow:

Show More

Hello Community

I'm on an insallation of Pega 7.3.1 with Tomcat and Postgresql with split schema.

While the deployment of the prweb.war, I'm getting the following error:

SEVERE [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Unable to connect to database.  Will only use properties from file.
 org.postgresql.util.PSQLException: ERROR: permission denied for schema prpc_data
  Position: 34
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)

I granted the user on the DB-Schema.

The context.xml (<Tomcat>/conf/context.xml) is the follow:

<Context>

    <Resource name="jdbc/PegaRULES"
        auth="Container"
        type="javax.sql.DataSource"
        driverClassName="org.postgresql.Driver"
        url="jdbc:postgresql://localhost:5432/prpc"
        username="prpc_base"
        password="xxxxxxx"
        maxActive="100"
        maxIdle="30"
        maxWait="10000"
    />

    <Resource name="jdbc/AdminPegaRULES"
        auth="Container"
        type="javax.sql.DataSource"
        driverClassName="org.postgresql.Driver"
        url="jdbc:postgresql://localhost:5432/prpc"
        username="prpc_adm"
        password="xxxxx"
        maxTotal="10"
        maxIdle="5"
        maxWaitMillis="5000"
    />

    <Environment
        name="prconfig/database/databases/PegaRULES/dataSourceAdmin"
        value="java:comp/env/jdbc/AdminPegaRULES"
        type="java.lang.String"
    />

    <Environment
        name="prconfig/database/databases/PegaDATA/dataSourceAdmin"
        value="java:comp/env/jdbc/AdminPegaRULES"
        type="java.lang.String"
    />

    <Environment
        name="prconfig/database/databases/PegaRULES/defaultSchema"
        value="prpc_rules"
        type="java.lang.String"
    />

    <Environment
        name="prconfig/database/databases/PegaDATA/defaultSchema"
        value="prpc_data"
        type="java.lang.String"
    />



    <!-- Default set of monitored resources. If one of these changes, the    -->
    <!-- web application will be reloaded.                                   -->
    <WatchedResource>WEB-INF/web.xml</WatchedResource>
    <WatchedResource>${catalina.base}/conf/web.xml</WatchedResource>

    <!-- Uncomment this to disable session persistence across Tomcat restarts -->

    <Manager pathname="" />

    <Environment name="url/initialization/explicittempdir"
        value="/opt/pega/tomcat/temp"
        type="java.lang.String"
    />

</Context>

Any ideas or hints what is not working correct or config issue?

Thanks for support,
Chris


Show Less
To see attachments, please log in.
Installation and Deployment
Data Integration

Posted: 6 years ago
Posted: 13 Dec 2017 4:52 EST
Ujjwal Kumar Shukla (UjjwalShukla_GCS)
PEGA
Senior Manager, Technical Support
Pegasystems Inc.
IN

Hi There,

Error suggests that user is able to login but not use schema.

Check for database logs which would give you more info. postgresql.conf should have info on logfiles.

By default, users cannot access any objects in schemas they do not own. To allow that, the owner of the schema must grant the USAGE privilege on the schema.

So either make your created user the owner of the schema, or grant USAGE on the schema to required user.

Thanks,
Ujjwal

To see attachments, please log in.
Posted: 6 years ago
Posted: 13 Dec 2017 5:10 EST
Mohammad Asif Hasan (Mohammad_Asif_Hasan)
EPAM Systems, Inc.
Mohammad Asif Hasan
EPAM Systems, Inc.
ES

Hi Chris,

Thanks for posting on PSC.

I have faced the similar issue, could you confirm your Postgres version? Make sure you are using the compatible version which Postgres 9.6.

Please share the application stack(versions). 

I could see, it is different in parameter name for both the users' entries in context.xml

As per your entries, I have highlighted it:- 

Show More

Hi Chris,

Thanks for posting on PSC.

I have faced the similar issue, could you confirm your Postgres version? Make sure you are using the compatible version which Postgres 9.6.

Please share the application stack(versions). 

I could see, it is different in parameter name for both the users' entries in context.xml

As per your entries, I have highlighted it:- 

  1. <Context>
  2.  
  3. <Resource name="jdbc/PegaRULES"
  4. auth="Container"
  5. type="javax.sql.DataSource"
  6. driverClassName="org.postgresql.Driver"
  7. url="jdbc:postgresql://localhost:5432/prpc"
  8. username="prpc_base"
  9. password="xxxxxxx"
  10. maxActive="100"
  11. maxIdle="30"
  12. maxWait="10000" -------<Correct It>
  13. />
  14.  
  15. <Resource name="jdbc/AdminPegaRULES"
  16. auth="Container"
  17. type="javax.sql.DataSource"
  18. driverClassName="org.postgresql.Driver"
  19. url="jdbc:postgresql://localhost:5432/prpc"
  20. username="prpc_adm"
  21. password="xxxxx"
  22. maxTotal="10"
  23. maxIdle="5"
  24. maxWaitMillis="5000" ------<Correct IT>
  25. />

Correct entries as per your Java version:

Add data source resources. The parameter names differ based on your version of Tomcat

Tomcat 7.x:


a. Insert the following entry to add a data source resource for the Base user. Substitute your
specific values for the host, port, database or service name, user name, password, and
connection URL. For more information about connection URL strings, see Obtaining
database connection information on page 56
<Resource name="jdbc/PegaRULES"
auth="Container"
type="javax.sql.DataSource"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://[host]:[port]/[dbname]"
username="Base user name"
password="password"
maxActive="100"
maxIdle="30"
maxWait="10000"
/>
b. Optional: For dual-user configurations, insert the following entry to add a data source
resource for the Admin user.
<Resource name="jdbc/AdminPegaRULES"
auth="Container"
type="javax.sql.DataSource"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://[host]:[port]/[dbname]
username="Admin user name"
password="password"
maxActive="10"
maxIdle="5"
maxWait="5000"
/>

Tomcat 8.x

a. Insert the following entry to add a data source resource for the Base user. Substitute your
specific values for the host, port, database or service name, user name, password, and
connection URL. For more information about connection URL strings, see Obtaining
database connection information on page 56
<Resource name="jdbc/PegaRULES"
auth="Container"
type="javax.sql.DataSource"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://[host]:[port]/[dbname]"
username="Base user name"
password="password"
maxTotal="100"
maxIdle="30"
maxWaitMillis="10000"
/>
b. Optional: For dual-user configurations, insert the following entry to add a data source
resource for the Admin user.
<Resource name="jdbc/AdminPegaRULES"
auth="Container"
type="javax.sql.DataSource"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://[host]:[port]/[dbname]
username="Admin user name"
password="password"
maxTotal="10"
maxIdle="5"
maxWaitMillis="5000"
/>

Hope it helps in establishing connect now. Kindly notify if it does.

Regards,

Asif


Show Less
To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice