PRPC 719PE and PostgreSQL

On the console, I can see the the 'Unable to locate KeyringImpl keyring after trying' but I have created Seri-Keyring.keyring?

My keyring is the same location as the Java command line

Q1. Where would PRPC find the keyring file?

Answer: System.getPropery("user.home")

e.g. file:/C:/Users/chars1/Seri-Keyring.keyring

Q2. Is there a setting to set the full path and keyring file location?, "identification/KeyringPrefix" is only the name of the keyring, not the full path.

Answer: ???

//---------Below is output from console---------------------------

============ PegaRULES Bootstrap Configuration ============

Date: Sat May 07 14:05:16 EST 2016

Java Version: Oracle Corporation 1.8.0_25

Configuration: file:/C:/PRPC/AES/BIXCmd/PRPCCrypto/MyCipher/WEB-INF/classes/pr

bootstrap.properties

Pega-EngineCode: 07-10-19

ASM Version: 554097615

Database: PostgreSQL 9.1.14

Driver: PostgreSQL Native Driver PostgreSQL 9.2devel JDBC4 (build 1000)

Active CodeSets: pega-enginecode:07-10-19 at (latest patch)

pegaaes:07-20-01 at (latest patch)

customer:06-01-01 at (latest patch)

Ignored JNDI Options

=============== End Bootstrap Configuration ===============

log4j:WARN Continuable parsing error 59 and column 69

log4j:WARN Attribute value "ASYNC" of type ID must be unique within the document

.

log4j:WARN Continuable parsing error 70 and column 75

log4j:WARN Attribute value "ALERT-ASYNC" of type ID must be unique within the do

cument.

log4j:WARN Continuable parsing error 219 and column 23

log4j:WARN The content of element type "log4j:configuration" must match "(render

er*,appender*,(category|logger)*,root?,categoryFactory?)".

log4j:WARN No such property [bufferSize] in com.pega.pegarules.priv.util.SOAPApp

enderPega.

log4j:WARN No such property [blocking] in com.pega.pegarules.priv.util.SOAPAppen

derPega.

log4j:WARN No such property [bufferSize] in com.pega.pegarules.priv.util.SOAPApp

enderPega.

log4j:WARN No such property [blocking] in com.pega.pegarules.priv.util.SOAPAppen

derPega.

May 07, 2016 2:05:16 PM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI

19830421: Could not find java:comp/env/prconfig/ in the local JNDI context, skip

ping prconfig setting lookup

May 07, 2016 2:05:16 PM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI

19830421: Could not find prconfig in the local JNDI context, skipping prconfig s

etting lookup

Unable to locate KeyringImpl keyring after trying:

<properties>

chars1-Seri-Keyring.keyring

LCHARS1W7APAC-Seri-Keyring.keyring

Seri-Keyring.keyring

PRPC default rounding mode set to HALF_EVEN

//--------------- MY PRCONFIG-----------------

<?xml version="1.0" encoding="UTF-8"?>

<pegarules>

<env name="identification/systemName" value="pega" />

<env name="initialization/settingsource" value="merged" />

<env name="fua/conclusionQueryPerformance" value="false" />

<env name="initialization/minimalStartup" value="true" />

<env name="ruleresolution/useclassancestorjoin" value="false" />

<env name="ruleresolution/userulesetindexjoin" value="false" />

<env name="ruleresolution/usejoinsforallclasses" value="false" />

<env name="agent/enable" value="false" />

<env name="fua/enableAssemblyAvoidance" value="false" />

<env name="agent/masteragentenable" value="false" />

<env name="initialization/daemonenable" value="false" />

<env name="usage/usagetrackingenabled" value="false" />

<env name="asyncservices/enable" value="false" />

<env name="/compatibility/BIXUseOptimizedClipboardXML" value="true" />

<env name="/compatibility/BIXdisableForwardChaining" value="true" />

<env name="/compatibility/BIXdisableBackwardChaining" value="false" />

<env name="bix/useHistoryClasses" value="true" />

<!--- key ring -->

<env name="identification/KeyringPrefix" value="Seri-Keyring" />

<env name="identification/KeyringAlgorithm" value="AES" />

<env name="identification/KeyringLength" value="256" />

<!-- This is a minimum format prconfig.xml file. Only the settings which are required to access settings in the database are included.

All other settings which were formerly located only in this file are now Data-Admin-System-Settings. -->

<env name="initialization/settingsource" value="merged" />

<!-- seri: We still need these entries even if we do NOT bootstrap from Container Managed JNDI, ie using prdbcp.jar ??? -->

<env name="database/databases/PegaRULES/dataSource" value="java:comp/env/jdbc/PegaRULES"/>

<env name="database/databases/PegaDATA/dataSource" value="java:comp/env/jdbc/PegaRULES"/>

<!-- Most nodes have a 'default' classification and for these nodes, no additional changes need to be made to this file. However,

if this is node has a non-general purpose, for example: 'Agent', then the node classification setting should be added to this file. -->

<!--env name="initialization/nodeclassification" value="Agent" /> -->

<!--<env name="/Authentication/RedirectGuests" value="false"/>-->

<!-- Settings can still be put in this file. If they are, then the value in this file will override the value in the database

for this node. This is useful for settings which are specific to this node and should not be shared by multiple nodes on this

system. -->

<!--

Pegasystems recommends that you use Application Server connection pooling to the database for Websphere and

Weblogic. These examples are provided if you need to use Pega Connection Pooling for Tomcat or for testing purposes.

If you are using Application server connection pooling, there is no longer a need to edit this file.

****The new format for this file is only valid if you are using Application Server connection pooling. If you are not, please replace

this file with an older version. ***

Oracle 10g (Type 4) oracle.jdbc.OracleDriver jdbc:oracle:thin:@serverName:1521:db

IBM DB/2 Type 4 com.ibm.db2.jcc.DB2Driver jdbc:db2://serverName:port/dbName

SQL Server 2005 com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc:sqlserver://serverName:1433;SelectMethod=cursor;SendStringParametersAsUnicode=false

-->

<!--<env name="database/drivers" value="com.microsoft.sqlserver.jdbc.SQLServerDriver;oracle.jdbc.OracleDriver" />-->

<env name="database/drivers" value="org.postgresql.Driver" />

<!--<env name="database/databases/PegaRULES/url" value="jdbc:sqlserver://serverName:1433;SelectMethod=cursor;SendStringParametersAsUnicode=false" /> -->

<env name="database/databases/PegaRULES/url" value="jdbc:postgresql://localhost:5436/pega" />

<env name="database/databases/PegaRULES/userName" value="pega" />

<!-- password is in Seri-Keyring.keyring -->

<!--<env name="database/databases/PegaRULES/password" value="pega" />-->

<!--<env name="database/databases/PegaDATA/url" value="jdbc:sqlserver://serverName:1433;SelectMethod=cursor;SendStringParametersAsUnicode=false" /> -->

<env name="database/databases/PegaDATA/url" value="jdbc:postgresql://localhost:5436/pega" />

<env name="database/databases/PegaDATA/userName" value="pega" />

<!-- password is in Seri-Keyring.keyring -->

<!--<env name="database/databases/PegaDATA/password" value="pega" />-->

<env name="database/databases/PegaRULES/defaultSchema" value="personaledition"/>

<env name="database/databases/PegaDATA/defaultSchema" value="personaledition"/>

</pegarules>

//---------------------------------------------------

My BIX Commandline:

echo "Seri Start"

java.exe -classpath "./MyCipher/WEB-INF/lib/prbootstrap.jar;./MyCipher/WEB-INF/lib/prbootstrap-api.jar;./MyCipher/WEB-INF/lib/prbootstrap.jar;./MyCipher/WEB-INF/lib/prdbcp.jar;./MyCipher/WEB-INF/lib/postgresql-9.2-1002.jdbc4.jar" -Xms128m -Xmx256m -Dcom.pega.pegarules.bootstrap.properties.url="file:///C:/PRPC/AES/BIXCmd/PRPCCrypto/MyCipher/WEB-INF/classes/prbootstrap.properties" -Dpegarules.config=./MyCipher/WEB-INF/classes/prconfig.xml -Dpegarules.logging.configuration=./MyCipher/WEB-INF/classes/prlogging.xml -Dcom.pega.pegarules.bootstrap.ignorejndi=true com.pega.pegarules.pub.PegaRULES com.pega.pegarules.data.internal.access.ExtractImpl -i PEGAAES-WORK-ACTION!SAMPLE -a admin@sco1 -p rules

echo "Seri End"

//-------------------------

Regards

Seri