Join the community today
Become a Member

PostgreSQL install failed

Discussion in 'Bug Reports' started by tininho, Mar 24, 2021.

  1. tininho

    tininho Active Member

    152
    36
    28
    May 22, 2019
    Finland
    Ratings:
    +110
    Local Time:
    3:30 PM
    On a fresh centminmod beta install I have added the following to the custom.conf:


    Code:
    POSTGRESQL='y'
    LETSENCRYPT_DETECT='y'
    
    After that I ran option 5 for PHP upgrade, and this is error came up:

    Code:
    ...
    checking for PostgreSQL support for PDO... yes
    checking for pg_config... not found
    configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
    
    Tue Mar 23 14:41:17 UTC 2021
    Success: PHP configure ok
    
                   ____   _   _  ____       __  __         _
                  |  _ \ | | | ||  _ \  _  |  \/  |  __ _ | | __ ___
                  | |_) || |_| || |_) |(_) | |\/| | / _` || |/ // _ \
                  |  __/ |  _  ||  __/  _  | |  | || (_| ||   <|  __/
                  |_|    |_| |_||_|    (_) |_|  |_| \__,_||_|\_\\___|
    
    PHPMUVER = 7.4
    PHP_PGO = n
    make -j1
    make: *** No targets specified and no makefile found.  Stop.
    
    real    0m0.001s
    user    0m0.001s
    sys     0m0.000s
    
    Tue Mar 23 14:41:17 UTC 2021
    Error: 2, PHP make failed (123.09beta01.b659)
    
    Some extra info:
    Code:
    [root@centos-1cpu-2gb-de-fra1 addons]# pg_config
    -bash: pg_config: command not found
    [root@centos-1cpu-2gb-de-fra1 addons]# yum list postgresql11 postgresql11-devel postgresql11-contrib postgresql11-libs postgresql11-server -q | tr -s ' ' | column -t
    Error: No matching Packages to list
    [root@centos-1cpu-2gb-de-fra1 addons]# which pg_config
    /usr/bin/which: no pg_config in (/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin)
     
  2. eva2000

    eva2000 Administrator Staff Member

    47,210
    10,672
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,579
    Local Time:
    10:30 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    Every centmin.sh menu option has a full server log created with time stamped file name at /root/centminlogs. You can check that specific error log for clues or copy and paste log contents and post to pastebin.com or gist.github.com for sharing.

    To troubleshoot, you need to check the the php upgrade logs at /root/centminlogs and instructions under Sharing logs and errors heading for using Pastebin.com or Gists to share a sanitised version of the contents of the nginx_upgrade and php_upgrade logs. You can see full details at How to troubleshoot Centmin Mod initial install issues

    if you type this command it lists all logs in date ascending order so latest log at bottom
    Code (Text):
    ls -lArt /root/centminlogs

    so copy the entire contents of latest php_upgrade log to gist.github.com or pastebin.com

    you can use grep to filter the logs, i.e. look for nginx_upgrade or php in log name
    Code (Text):
    ls -lahrt /root/centminlogs/ | egrep 'nginx_upgrade|php_upgrade'
    

    Code (Text):
    ls -lahrt /root/centminlogs/ | egrep 'nginx_upgrade|php_upgrade'
    -rw-r--r--  1 root root  2.6M Oct  3 03:48 centminmod_1.2.3-eva2000.09.001_031016-034409_php_upgrade.log
    -rw-r--r--  1 root root  664K Oct 12 09:24 centminmod_1.2.3-eva2000.09.001_121016-092406_nginx_upgrade.log
    

    So the last php upgrade log was named centminmod_1.2.3-eva2000.09.001_031016-034409_php_upgrade.log and located at /root/centminlogs/centminmod_1.2.3-eva2000.09.001_031016-034409_php_upgrade.log
    then use cat command to output the contents of that log.

    clear your ssh window buffer/screen and type
    Code (Text):
    cat /root/centminlogs/centminmod_1.2.3-eva2000.09.001_031016-034409_php_upgrade.log

    then select and copy and paste output to pastebin.com or gist.github.com file to share. If your SSH client's scroll buffer isn't large enough using cat might not output the entire log file contents, so you may need to download the log and use local text editor to open and copy and paste.

    so only need content of a specific log, in this case most recent php_upgrade.log logs
     
  3. eva2000

    eva2000 Administrator Staff Member

    47,210
    10,672
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,579
    Local Time:
    10:30 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x