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***