SAS Web Infrastructure Platform Data Server Configuration Failed : The server cannot be located.

[mkiran]

I am installing Grid compute node1 and installation failed for WIPD, server process started and I see the PID on linux server but installation not able to find the service. We are on Red Hat Enterprise Linux 8. 

re-tried installation after wiping the previous configuration as well but no luck. is there anything missing on OS level?.

An error occurred while starting the Web Infrastructure Platform Data Server on port 9432. The server cannot be located.

[sas@hostname data]$ ps -ef | grep 9432

sas 435918 1 0 22:09 ? 00:00:00 /sas/foundation/compute/SASWebInfrastructurePlatformDataServer/9.4/bin/postgres -D /sas/platform/config_compute/Lev1/WebInfrastructurePlatformDataServer/data -i -p 9432
sas 436506 430612 0 22:11 pts/0 00:00:00 grep --color=auto 9432

Error Log:

     [exec] Setting environment variable: LD_LIBRARY_PATH=/sas/foundation/compute/SASWebInfrastructurePlatformDataServer/9.4/lib:/sas/platform/config_compute/Lev1/${webinfdsvrc.env.LD_LIBRARY_PATH}

     [exec] Setting environment variable: LIBPATH=/sas/foundation/compute/SASWebInfrastructurePlatformDataServer/9.4/lib:/sas/platform/config_compute/Lev1/${webinfdsvrc.env.LD_LIBRARY_PATH}

     [exec] Executing '/sas/foundation/compute/SASWebInfrastructurePlatformDataServer/9.4/bin/pg_isready' with arguments:

     [exec] '-h'

     [exec] 'hostname.com'

     [exec] '-p'

     [exec] '9432'

     [exec] 

     [exec] The ' characters around the executable and arguments are

     [exec] not part of the command.

     [exec] hostname.com:9432 - no response

     [exec] Result: 2

    [sleep] sleeping for 6000 milliseconds

BUILD FAILED

/sas/foundation/compute/SASWebInfrastructurePlatformDataServerConfiguration/9.4/Config/webinfdsvrc_config.xml:196: The following error occurred while executing this line:

/sas/foundation/compute/SASDeploymentManager/9.4/products/cfgwizard__94602__prt__xx__sp0__1/Utilities/webinfdsvrcTasks.xml:462: An error occurred while starting the Web Infrastructure Platform Data Server on port 9432.  The server cannot be located.

at org.apache.tools.ant.taskdefs.Exit.execute(Exit.java:162)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)

at jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:566)

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)

at org.apache.tools.ant.Task.perform(Task.java:350)

at java.base/java.util.Vector.forEach(Vector.java:1388)

at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:67)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)

at jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:566)

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.taskdefs.MacroInstance.execute(MacroInstance.java:391)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)

at jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:566)

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)

[mkiran]

clicked Retry option and have the below error

Logfile:

BUILD FAILED

/sas/foundation/compute/SASWebInfrastructurePlatformDataServerConfiguration/9.4/Config/webinfdsvrc_config.xml:401: The initdb command failed, see the log for details. rc:1 output:The files belonging to this database system will be owned by user "sas".

This user must also own the server process.

The database cluster will be initialized with locale "C".

The default text search configuration will be set to "english".

Data page checksums are disabled.

at org.apache.tools.ant.taskdefs.Exit.execute(Exit.java:162)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)

at jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:566)

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)

[gwootton]

I might start by checking the data server's log (/sas/platform/config_compute/Lev1/WebInfrastructurePlatformDataServer/Logs) for any errors it's encountering at startup.

[mkiran]

@gwootton  : Yes, I did verify these logs. All look normal in these logs,. I see database is up and running and log has messages "Database system is ready to accept connection"

[gwootton · Accepted solution]

Seems like when "pg_isready" is being run it can't connect to the host "hostname.com" on port 9432.

You can repeat these tests outside of the config process. Here I'm using "localhost" instead of "hostname.com":
# Command being run by SAS:
$ LD_LIBRARY_PATH=$LD_LIBRARY_PATH:<SASHome>/SASWebInfrastructurePlatformDataServer/9.4/lib
$ export LD_LIBRARY_PATH
$ <SASHome>/SASWebInfrastructurePlatformDataServer/9.4/bin/pg_isready -h localhost -p 9432
localhost:9432 - accepting connections

# Use netcat to test TCP connectivity
$ nc -zv -w1 localhost 9432
Connection to localhost (::1) 9432 port [tcp/*] succeeded!

# Use netstat to confirm postgres process is listening on port 9432
$ netstat -nlp | grep 9432
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 0.0.0.0:9432 0.0.0.0:* LISTEN 2215/postgres
tcp6 0 0 :::9432 :::* LISTEN 2215/postgres
unix 2 [ ACC ] STREAM LISTENING 32952 2215/postgres /tmp/.s.PGSQL.9432

# Use lsof to confirm postgres process is listening on port 9432
$ lsof -i:9432 | grep LISTEN
postgres 2215 sas 3u IPv4 32950 0t0 TCP *:9432 (LISTEN)
postgres 2215 sas 4u IPv6 32951 0t0 TCP *:9432 (LISTEN)

[mkiran]

Thank you @gwootton : I think here is the catch.. when I tried to use "nc" using localhost it is connecting to the DB but not with the actual hostname, is this could be a problem?.

[sas@hostname.com Logs]$ nc -zv -w1 localhost 9432
Ncat: Version 7.92 ( https://nmap.org/ncat )
Ncat: Connected to 127.0.0.1:9432.
Ncat: 0 bytes sent, 0 bytes received in 0.01 seconds.

[sas@hostname.com Logs]$ nc -zv -w1 hostname.com 9432   /*changed the actual servername to a string hostname.com */
Ncat: Version 7.92 ( https://nmap.org/ncat )
Ncat: TIMEOUT.

[mkiran]

Found an issue with the DNS , worked with server admin team to correct it.

Thanks @gwootton