Last activity: 24 Jun 2019 2:07 EDT
Unable to startup pega Prpc personal edition
As there are 2 Personal edition is installed in my system. till yesterday both are working fine . pega 8 server was up CMD window is open at the same time I open Pega 7.3 Server as well. Post that i am unable to launch Pega 7.3 application
Attaching Log file as well for Server start
DB port -5432
Connection port for pega 7.3- 8084
Connection port for pega 8- 8083
i tried to change server.xml file as well with new port , multiple times server start & stop
i tried to change postgresql.conf file as well with new db port but issue still persist
***Moderator Edit-Vidyaranjan: Updated SR details***
There are multiple port number in server.xml of you tomcat.
For both the tomcat, all ports should be unique(Eg. SHUDDOWN port). Try with this, if still not working share both your server.xml file as well as logs.
Thanks for your response, i changed connector port, shutdown port as well but still same issue
PFA for both server.xml fille in txt format
<Server port="9003" shutdown="SHUTDOWN"> in pega 7.3
<Server port="9005" shutdown="SHUTDOWN"> in pega 8
log file on cmd is as it is what I attached in earlier post
Along with above suggestions, I could see below error in logs.
Cannot create JDBC driver of class 'org.postgresql.Driver' for connect URL 'jdbc:postgresql://localhost:@PG_PORT/postgres'
java.sql.SQLException: No suitable driver
please make sure you have the postgresql jar file in lib directory of tomcat. If the issue is not resolved, please share the server.xml file of Pega 8 and Pega 7.3 along with server start up logs.
Postgre SQL jar is already in the correct path
PFB for 7.3- C:\PRPCPersonalEdition\tomcat\lib\postgresql-42.0.0.jar
For Pega 8- C:\Personal edition 8\PRPCPersonalEdition\tomcat\lib\postgresql-42.0.0.jar
PFB attached server.xml file
PFA startup log for Pega 7 & 8, Kindly help me out to resolve this issue ASAP
Thanks for your quick response
Yes i changed to port="@TCHTTP" during the conversion of HTTP to HTTPS, it was initially working fine .
Ok as you suggested then just now i changed to new unique port as 8086. But still same issue persists
PFB updated server.xml file & cmd starting log for pega 7
I have reviewed the start up logs, and could see that the database connectivity is failing.
09-Jun-2019 17:03:27.387 1050 [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Bootstrap datatables schema: data 09-Jun-2019 17:03:27.395 SEVERE [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Unable to connect to database. Will only use properties from file. java.sql.SQLException: Cannot create JDBC driver of class 'org.postgresql.Driver' for connect URL 'jdbc:postgresql://localhost:@PG_PORT/postgres' at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2167) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2037)
Could you please check in context.xml in conf folder of tomcat and verify if you have you have defined database details correctly. Please share the context.xml for reference.
Hi Wasim ,
PFB attached file for Context.xml
Now i changed url url="jdbc:postgresql://localhost:@PG_PORT/postgres" to url="jdbc:postgresql://localhost:5432/postgres"
But still server is down
Please check logs, if you are still getting JDBC error or not.
If yes please cross check with you postgres DB, if you have provides all the details correctly.
i crosschecked eventhough i changed Port & host name then after in log getting error
org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
This works in my local setup, so you might as well give it a go.
Let us know if it works. If it does not, then kindly attach the latest logs post making the change above.
i updated the context.xml code with your above code but issue still persist.
same unable to start server
Still, this issue is there, tried all possible way but didn't work out so far
Latest that I see is
Latest that I see is
Caused by: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:265) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194) at org.postgresql.Driver.makeConnection(Driver.java:431) at org.postgresql.Driver.connect(Driver.java:247) at org.apache.tomcat.dbcp.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:257) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2313) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2299) ... 21 more Caused by: java.net.ConnectException: Connection refused: connect at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method) at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:589) at org.postgresql.core.PGStream.<init>(PGStream.java:62) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
It seems certain that 5432 port is closed.
Can you check above. Can you also try to ping PostGres server at 5432