Error during TASK [postgres-init : Run mosip_kernel shell script]

[srinivasvaka]

Hi,

I am getting below error during the task TASK [postgres-init : Run mosip_kernel shell script]

TASK [postgres-init : Run mosip_kernel shell script] *******************************************************************************************************************
fatal: [console.sb]: FAILED! => {"changed": true, "cmd": "bash mosip_kernel_db_deploy.sh mosip_kernel_deploy.properties", "delta": "0:00:00.079061", "end": "2020-10-01 14:59:24.538886", "msg": "non-zero return code", "rc": 2, "start": "2020-10-01 14:59:24.459825", "stderr": "psql: /lib64/libpq.so.5: no version information available (required by psql)\npsql: /lib64/libpq.so.5: no version information available (required by psql)\npsql: could not connect to server: Connection refused\n\tIs the server running on host "mzworker0.sb" (192.168.10.186) and accepting\n\tTCP/IP connections on port 30090?", "stderr_lines": ["psql: /lib64/libpq.so.5: no version information available (required by psql)", "psql: /lib64/libpq.so.5: no version information available (required by psql)", "psql: could not connect to server: Connection refused", "\tIs the server running on host "mzworker0.sb" (192.168.10.186) and accepting", "\tTCP/IP connections on port 30090?"], "stdout": "10/01/2020 14:59:24 : mosip_kernel_deploy.properties\n10/01/2020 14:59:24 : Property file "mosip_kernel_deploy.properties" found.\n10/01/2020 14:59:24 : ------------------ Database server and service status check for mosip_kernel------------------------", "stdout_lines": ["10/01/2020 14:59:24 : mosip_kernel_deploy.properties", "10/01/2020 14:59:24 : Property file "mosip_kernel_deploy.properties" found.", "10/01/2020 14:59:24 : ------------------ Database server and service status check for mosip_kernel------------------------"]}

PLAY RECAP *************************************************************************************************************************************************************
console.sb : ok=172 changed=35 unreachable=0 failed=1 skipped=40 rescued=0 ignored=2
dmzmaster.sb : ok=11 changed=2 unreachable=0 failed=0 skipped=12 rescued=0 ignored=0
dmzworker0.sb : ok=23 changed=3 unreachable=0 failed=0 skipped=28 rescued=0 ignored=0
mzmaster.sb : ok=11 changed=2 unreachable=0 failed=0 skipped=12 rescued=0 ignored=0
mzworker0.sb : ok=23 changed=3 unreachable=0 failed=0 skipped=28 rescued=0 ignored=0
mzworker1.sb : ok=23 changed=3 unreachable=0 failed=0 skipped=28 rescued=0 ignored=0
mzworker2.sb : ok=23 changed=3 unreachable=0 failed=0 skipped=28 rescued=0 ignored=0

I am running this on our on-premise VMs (Total 7 Nos. 1 - Console, 1- MZ Master, 3 - MZ Workers, 1- DMZ Master, 1- DMZ Worker)

Please find below the ip mapping details

console.sb -> 192.168.10.184
mzmaster.sb -> 192.168.10.185
mzworker0.sb -> 192.168.10.186
mzworker1.sb -> 192.168.10.187
mzworker2.sb -> 192.168.10.188
dmzmaster.sb -> 192.168.10.189
dmzworker0.sb ->192.168.10.190

Port 30090 is opened on Console and also mzworker0
what might be the issue which is causing this error?

[pjoshi751]

Is postgres up and running? Check by connecting using 'psql'

psql -h mzworker0.sb -p 30090 -U postgres

Also, which version of mosip-infra are you using. Would recommend moving to 1.1.2 branch (although this problem may not be related to the same)

[srinivasvaka]

psql -h mzworker0.sb -p 30090 -U postgres

postgres is not running it seems. I am getting below error

[mosipuser@console ~]$ psql -h mzworker0.sb -p 30090 -U postgres
psql: /lib64/libpq.so.5: no version information available (required by psql)
psql: /lib64/libpq.so.5: no version information available (required by psql)
psql: could not connect to server: Connection refused
Is the server running on host "mzworker0.sb" (192.168.10.186) and accepting
TCP/IP connections on port 30090?

Regarding the branch, i am using master (default) one.

[0xabdi]

The master branch is so buggy. Use v1.1.2 onwards

[pjoshi751]

Please use mosip-infra 1.1.5.4. Master branch has not be updated to the latest.