Question
EvonSys, LLC
LK
Last activity: 7 Mar 2023 5:31 EST
Pega 8.7 Personal Edition Installation error : Unable to connect to database
Hi All,
I'm getting the below error log while trying to install Pega 8.7 Personal Edition in Windows 10 operating system.
Could you please help me out to resolve the issues?
Error log:
Targets:Initialization,Database Server Installation,Data Load,Configuration,PRPC Launching
Buildfile: C:\Intel\117149_PE_8.7\.\pegaGuiInstallerTemp\build.xml
Initialization:
[echo] Beginning installation of Pega Platform 8.7.0 Personal Edition -- this process should take about 5-10 minutes ...
[mkdir] Created dir: C:\PRPCPersonalEdition
[mkdir] Created dir: C:\PRPCPersonalEdition\temp
[unzip] Expanding: C:\Intel\117149_PE_8.7\pegaGuiInstallerTemp\PersonalEdition.zip into C:\PRPCPersonalEdition
[echo] Configuring Tomcat (Setting Java Home and Catalina Home)...
[replace] Replaced 0 occurrences in 0 files.
[replace] Replaced 1 occurrences in 1 files.
[replace] Replaced 2 occurrences in 1 files.
[replace] Replaced 1 occurrences in 1 files.
Hi All,
I'm getting the below error log while trying to install Pega 8.7 Personal Edition in Windows 10 operating system.
Could you please help me out to resolve the issues?
Error log:
Targets:Initialization,Database Server Installation,Data Load,Configuration,PRPC Launching
Buildfile: C:\Intel\117149_PE_8.7\.\pegaGuiInstallerTemp\build.xml
Initialization:
[echo] Beginning installation of Pega Platform 8.7.0 Personal Edition -- this process should take about 5-10 minutes ...
[mkdir] Created dir: C:\PRPCPersonalEdition
[mkdir] Created dir: C:\PRPCPersonalEdition\temp
[unzip] Expanding: C:\Intel\117149_PE_8.7\pegaGuiInstallerTemp\PersonalEdition.zip into C:\PRPCPersonalEdition
[echo] Configuring Tomcat (Setting Java Home and Catalina Home)...
[replace] Replaced 0 occurrences in 0 files.
[replace] Replaced 1 occurrences in 1 files.
[replace] Replaced 2 occurrences in 1 files.
[replace] Replaced 1 occurrences in 1 files.
Database Server Installation:
[exec] The files belonging to this database system will be owned by user "Delegate".
[exec] This user must also own the server process.
[exec]
[exec] The database cluster will be initialized with locale "English_United States.1252".
[exec] The default text search configuration will be set to "english".
[exec]
[exec] Data page checksums are disabled.
[exec]
[exec] creating directory C:/PRPCPersonalEdition/pgsql/data ... ok
[exec] creating subdirectories ... ok
[exec] selecting default max_connections ... 100
[exec] selecting default shared_buffers ... 128MB
[exec] selecting default timezone ... Asia/Calcutta
[exec] selecting dynamic shared memory implementation ... windows
[exec] creating configuration files ... ok
[exec] running bootstrap script ... ok
[exec] performing post-bootstrap initialization ... ok
[exec]
[exec] WARNING: enabling "trust" authentication for local connections
[exec] You can change this by editing pg_hba.conf or using the option -A, or
[exec] --auth-local and --auth-host, the next time you run initdb.
[exec] syncing data to disk ... ok
[exec]
[exec] Success. You can now start the database server using:
[exec]
[exec] C:/PRPCPersonalEdition/pgsql/bin/pg_ctl -D ^"C^:^\PRPCPersonalEdition^/pgsql^\data^" -l logfile start
[exec]
[echo]
[echo] Waiting for Postgres to start...
[echo] Connected to Database.
[exec] ALTER ROLE
[exec] ALTER ROLE
[exec] psql:C:/PRPCPersonalEdition/scripts/installPLJava.sql:6: WARNING: Java virtual machine not yet loadedCREATE SCHEMA
[exec] GRANT
[exec]
[exec] CREATE FUNCTION
[exec] CREATE LANGUAGEDETAIL: The specified module could not be found.
[exec] CREATE FUNCTION
[exec]
[exec]
[exec] CREATE LANGUAGE
[exec] CREATE TABLEHINT: SET pljava.libjvm_location TO the correct path to the jvm library (libjvm.so or jvm.dll, etc.)
[exec] GRANT
[exec]
[exec] CREATE TABLE
[exec] GRANT
[exec] CREATE TABLE
[exec] GRANT
[exec] CREATE TABLE
[exec] GRANT
[exec] CREATE TABLE
[exec] GRANT
[exec] CREATE FUNCTION
[exec] CREATE FUNCTION
[exec] CREATE FUNCTION
[exec] CREATE FUNCTION
[exec] CREATE FUNCTION
[exec] CREATE FUNCTION
[exec] CREATE FUNCTION
[exec] CREATE FUNCTION
[exec] CREATE FUNCTION
Data Load:
[exec] The process cannot access the file because it is being used by another process.
[exec] pg_ctl: could not start server
[exec] Examine the log output.
[exec] Result: 1
[echo]
[echo] Waiting for Postgres to restart...
May 26, 2022 12:42:50 PM org.postgresql.Driver connect
SEVERE: Connection 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.
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 java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at com.pega.pegarules.util.anttasks.IsDBAvailable.execute(IsDBAvailable.java:112)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
at org.apache.tools.ant.Task.perform(Task.java:350)
at org.apache.tools.ant.Target.execute(Target.java:449)
at org.apache.tools.ant.Target.performTasks(Target.java:470)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
at org.apache.tools.ant.Project.executeTarget(Project.java:1374)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
at org.tp23.antinstaller.antmod.Main.runBuild(Main.java:710)
at org.tp23.antinstaller.antmod.Main.startAnt(Main.java:218)
at org.tp23.antinstaller.antmod.Launcher.run(Launcher.java:216)
at org.tp23.antinstaller.runtime.exe.AntLauncherFilter.exec(AntLauncherFilter.java:79)
at org.tp23.antinstaller.runtime.ExecInstall.exec(ExecInstall.java:88)
at org.tp23.antinstaller.selfextract.SelfExtractor.main(SelfExtractor.java:398)
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)
... 25 more
Unable to connect to database -- will retry in 1 second...
May 26, 2022 12:42:53 PM org.postgresql.Driver connect
SEVERE: Connection 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.
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 java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at com.pega.pegarules.util.anttasks.IsDBAvailable.execute(IsDBAvailable.java:112)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
at org.apache.tools.ant.Task.perform(Task.java:350)
at org.apache.tools.ant.Target.execute(Target.java:449)
at org.apache.tools.ant.Target.performTasks(Target.java:470)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
at org.apache.tools.ant.Project.executeTarget(Project.java:1374)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
at org.tp23.antinstaller.antmod.Main.runBuild(Main.java:710)
at org.tp23.antinstaller.antmod.Main.startAnt(Main.java:218)
at org.tp23.antinstaller.antmod.Launcher.run(Launcher.java:216)
at org.tp23.antinstaller.runtime.exe.AntLauncherFilter.exec(AntLauncherFilter.java:79)
at org.tp23.antinstaller.runtime.ExecInstall.exec(ExecInstall.java:88)
at org.tp23.antinstaller.selfextract.SelfExtractor.main(SelfExtractor.java:398)
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)
... 25 more
Unable to connect to database -- will retry in 1 second...
May 26, 2022 12:42:56 PM org.postgresql.Driver connect
SEVERE: Connection 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.
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 java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at com.pega.pegarules.util.anttasks.IsDBAvailable.execute(IsDBAvailable.java:112)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
at org.apache.tools.ant.Task.perform(Task.java:350)
at org.apache.tools.ant.Target.execute(Target.java:449)
at org.apache.tools.ant.Target.performTasks(Target.java:470)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
at org.apache.tools.ant.Project.executeTarget(Project.java:1374)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
at org.tp23.antinstaller.antmod.Main.runBuild(Main.java:710)
at org.tp23.antinstaller.antmod.Main.startAnt(Main.java:218)
at org.tp23.antinstaller.antmod.Launcher.run(Launcher.java:216)
at org.tp23.antinstaller.runtime.exe.AntLauncherFilter.exec(AntLauncherFilter.java:79)
at org.tp23.antinstaller.runtime.ExecInstall.exec(ExecInstall.java:88)
at org.tp23.antinstaller.selfextract.SelfExtractor.main(SelfExtractor.java:398)
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)
... 25 more
***Edited by Moderator Marije to change Content Type from Discussion to Question; added capability tags***
@Gayan_Wijesiri
Please can you check the Related Content forum posts with show up on the forum search with similar issues?
Unable to install Pega personal edition 8.6 version unable to connect database
unable to install 8.6.0 PE
Unable to install Pega 8.5.1 PE
DB Port 5432 unavailable error
PEGA PE 8.6 install error
Pega 8.7 installation error-unable to connect to db
How to update postgres port in Pega 7.3.1 PE
Suggest:
This error might be because of port unavailability.
Before starting of installation check whether the port numbers are available or not.
Try to proceed with the installation after installing VC++ runtime on Windows Server
https://docs.microsoft.com/en-US/cpp/windows/latest-supported-vc-redist?view=msvc-170
@Gayan_Wijesiri
Please can you check the Related Content forum posts with show up on the forum search with similar issues?
Unable to install Pega personal edition 8.6 version unable to connect database
unable to install 8.6.0 PE
Unable to install Pega 8.5.1 PE
DB Port 5432 unavailable error
PEGA PE 8.6 install error
Pega 8.7 installation error-unable to connect to db
How to update postgres port in Pega 7.3.1 PE
Suggest:
This error might be because of port unavailability.
Before starting of installation check whether the port numbers are available or not.
Try to proceed with the installation after installing VC++ runtime on Windows Server
https://docs.microsoft.com/en-US/cpp/windows/latest-supported-vc-redist?view=msvc-170
Users above were able solve it by installing the Microsoft Visual C++ 2015 Redistributable Update 3 RC program.
"The issue was that the pg_ctl executable was not able to run due to the VCRUNTIME140.dll being missing in the Windows System. This error is not exclusive of the pg_ctl command but it seems to be common for other programs that need that DLL to run correctly."
Please delete this folder C:/PRPCPersonalEdition/ and then try to install it again. or you can give a new folder name during the installation with new port for database and server.
Please go through all the posts I've listed above,
eg https://collaborate.pega.com/question/pega-87-installation-error-unable-connect-db.