Can't access to ISPConfig Interface

Discussion in 'Installation/Configuration' started by yasine, Aug 13, 2022.

  1. yasine

    yasine New Member

    Hi !
    I have a big problem that has caused me insomnia in the past few days

    I Can't access to ISPConfig Interface due to a Fatal error: Call to undefined function mysqli_init()

    I have extension=php_mysqli.dll enabled in php.ini and mysqli module installed

    Untitled-1.png
    ~$ php -v
    PHP 7.4.30 (cli)
    (built: Jun 27 2022 08:11:59) ( NTS )
    Copyright (c) The PHP Group
    Zend Engine v3.4.0, Copyright (c) Zend Technologies
    with Zend OPcache v7.4.30, Copyright (c), by Zend Technologies
    phpinfo :

    PHP-7-4-30-phpinfo-.png

    ~$ which php
    /usr/bin/php

    ~$ update-alternatives --config php
    There are 4 choices for the alternative php (providing /usr/bin/php).

    Selection Path Priority Status
    ------------------------------------------------------------
    0 /usr/bin/php8.1 81 auto mode
    1 /usr/bin/php7.3 73 manual mode
    * 2 /usr/bin/php7.4 74 manual mode
    3 /usr/bin/php8.0 80 manual mode
    4 /usr/bin/php8.1 81 manual mode


    Thank you for your help !
     
  2. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    I can only found your OS is Debian so I cannot be sure to its php is the right one. It is always better for you to provide the test report (htf_report.txt) as suggested in: Please read before posting!
     
  3. yasine

    yasine New Member

    OK , Thank you !
    here is the test report :

    Code:
    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    [WARN] could not determine server's ip address by ifconfig
    [INFO] OS version is Debian GNU/Linux 10 (buster)
    
    [INFO] uptime:  13:48:15 up 133 days, 14:09,  1 user,  load average: 0.05, 0.08,
     0.04
    
    [INFO] memory:
                  total        used        free      shared  buff/cache   available
    Mem:          3.8Gi       2.2Gi       1.0Gi       156Mi       562Mi       1.2Gi
    Swap:            0B          0B          0B
    
    [INFO] systemd failed services status:
      UNIT               LOAD   ACTIVE SUB    DESCRIPTION
    ● php7.3-fpm.service loaded failed failed The PHP 7.3 FastCGI Process Manager
    
    LOAD   = Reflects whether the unit definition was properly loaded.
    ACTIVE = The high-level unit activation state, i.e. generalization of SUB.
    SUB    = The low-level unit activation state, values depend on unit type.
    
    1 loaded units listed. Pass --all to see loaded but inactive units, too.
    To show all installed unit files use 'systemctl list-unit-files'.
    
    [INFO] ISPConfig is installed.
    [WARN] /usr/local/ispconfig/server/lib/config.inc.php is missing.
    
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 7.4.30
    [INFO] php-cgi (used for cgi php in default vhost!) is version 7.3.33
    
    ##### PORT CHECK #####
    
    
    ##### MAIL SERVER CHECK #####
    
    
    ##### RUNNING SERVER PROCESSES #####
    
    [WARN] I could not determine which web server is running.
    [WARN] I could not determine which mail server is running.
    [WARN] I could not determine which pop3 server is running.
    [WARN] I could not determine which imap server is running.
    [WARN] I could not determine which ftp server is running.
    
    ##### LISTENING PORTS #####
    (only           ()
    Local           (Address)
    [anywhere]:110          (-)
    [anywhere]:143          (-)
    [anywhere]:465          (-)
    [anywhere]:21           (-)
    ***.***.***.***:53              (-)
    [localhost]:53          (-)
    [anywhere]:22           (-)
    [anywhere]:25           (-)
    [localhost]:953         (-)
    [anywhere]:993          (-)
    [anywhere]:995          (-)
    [localhost]:10023               (-)
    [localhost]:10024               (-)
    [localhost]:10025               (-)
    [localhost]:10026               (-)
    [localhost]:10027               (-)
    [anywhere]:587          (-)
    [localhost]:11211               (-)
    [localhost]10           (-)
    [localhost]43           (-)
    *:*:*:*::*:8080         (-)
    *:*:*:*::*:80           (-)
    *:*:*:*::*:8081         (-)
    *:*:*:*::*:465          (-)
    *:*:*:*::*:21           (-)
    *:*:*:*::*:53           (-)
    *:*:*:*::*:22           (-)
    *:*:*:*::*:25           (-)
    *:*:*:*::*:953          (-)
    *:*:*:*::*:443          (-)
    *:*:*:*::*:993          (-)
    *:*:*:*::*:995          (-)
    *:*:*:*::*:10023                (-)
    *:*:*:*::*:10024                (-)
    *:*:*:*::*:10026                (-)
    *:*:*:*::*:3306         (-)
    *:*:*:*::*:587          (-)
    
    
    
    
    ##### IPTABLES #####
    
    
    
    
    ##### LET'S ENCRYPT #####
    
     
  4. nhybgtvfr

    nhybgtvfr Well-Known Member HowtoForge Supporter

    the default php on debian 10 (buster) should be 7.3, not 7.4
     
  5. yasine

    yasine New Member

    there is 7.3 for php-cgi
    I did : update-alternatives --config php and choose 7.3 but the problem still occurs :
    here is the php info : PHP-7-4-30-phpinfo-.png
     
  6. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    What is the test report showing now?
     
  7. yasine

    yasine New Member

    it shows that :
    Code:
    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    [WARN] could not determine server's ip address by ifconfig
    [INFO] OS version is Debian GNU/Linux 10 (buster)
    
    [INFO] uptime:  21:11:21 up 134 days, 21:32,  1 user,  load average: 0.15, 0.11,
     0.09
    
    [INFO] memory:
                  total        used        free      shared  buff/cache   available
    Mem:          3.8Gi       2.0Gi       661Mi       167Mi       1.1Gi       1.4Gi
    Swap:            0B          0B          0B
    
    [INFO] systemd failed services status:
      UNIT               LOAD   ACTIVE SUB    DESCRIPTION
    ● php7.3-fpm.service loaded failed failed The PHP 7.3 FastCGI Process Manager
    
    LOAD   = Reflects whether the unit definition was properly loaded.
    ACTIVE = The high-level unit activation state, i.e. generalization of SUB.
    SUB    = The low-level unit activation state, values depend on unit type.
    
    1 loaded units listed. Pass --all to see loaded but inactive units, too.
    To show all installed unit files use 'systemctl list-unit-files'.
    
    [INFO] ISPConfig is installed.
    [WARN] /usr/local/ispconfig/server/lib/config.inc.php is missing.
    
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 7.3.33-4+0~20220627.98+debian10~1.gbp40b3e4
    [INFO] php-cgi (used for cgi php in default vhost!) is version 7.3.33
    
    ##### PORT CHECK #####
    
    
    ##### MAIL SERVER CHECK #####
    
    
    ##### RUNNING SERVER PROCESSES #####
    
    [WARN] I could not determine which web server is running.
    [WARN] I could not determine which mail server is running.
    [WARN] I could not determine which pop3 server is running.
    [WARN] I could not determine which imap server is running.
    [WARN] I could not determine which ftp server is running.
    
    ##### LISTENING PORTS #####
    (only           ()
    Local           (Address)
    [anywhere]:110          (-)
    [anywhere]:143          (-)
    [anywhere]:465          (-)
    ***.***.***.***:53              (-)
    [localhost]:53          (-)
    [anywhere]:21           (-)
    [anywhere]:22           (-)
    [localhost]:953         (-)
    [anywhere]:25           (-)
    [anywhere]:993          (-)
    [anywhere]:995          (-)
    [localhost]:10023               (-)
    [localhost]:10024               (-)
    [localhost]:10025               (-)
    [localhost]:10026               (-)
    [localhost]:10027               (-)
    [anywhere]:587          (-)
    [localhost]:11211               (-)
    [localhost]10           (-)
    [localhost]43           (-)
    *:*:*:*::*:8080         (-)
    *:*:*:*::*:80           (-)
    *:*:*:*::*:8081         (-)
    *:*:*:*::*:465          (-)
    *:*:*:*::*:53           (-)
    *:*:*:*::*:21           (-)
    *:*:*:*::*:22           (-)
    *:*:*:*::*:953          (-)
    *:*:*:*::*:25           (-)
    *:*:*:*::*:443          (-)
    *:*:*:*::*:993          (-)
    *:*:*:*::*:995          (-)
    *:*:*:*::*:10023                (-)
    *:*:*:*::*:10024                (-)
    *:*:*:*::*:10026                (-)
    *:*:*:*::*:3306         (-)
    *:*:*:*::*:587          (-)
    
    
    
    
    ##### IPTABLES #####
    
    
    
    
    ##### LET'S ENCRYPT #####
    
    
     
  8. nhybgtvfr

    nhybgtvfr Well-Known Member HowtoForge Supporter

    is php7.4-fpm enabled in etc/apache2/conf-enabled? is so, disable it and enable php7.3-fpm

    run 'ls -l /etc/alternatives | grep php' and see what versions are enabled by default. zet them to 7.3 if they are different.

    the if the php7.3-fpm service still fails to load, look in the logs for the reason why.
     
  9. yasine

    yasine New Member

    the php-fpm enabled is 7.3 :
    Code:
    lrwxrwxrwx 1 root root  15 Aug 27 14:21 php -> /usr/bin/php7.3
    lrwxrwxrwx 1 root root  31 Aug 27 14:21 php.1.gz -> /usr/share/man/man1/php7.3.1.gz
    lrwxrwxrwx 1 root root  19 Apr 22  2021 php-cgi -> /usr/bin/php-cgi7.3
    lrwxrwxrwx 1 root root  35 Apr 22  2021 php-cgi.1.gz -> /usr/share/man/man1/php-cgi7.3.1.gz
    lrwxrwxrwx 1 root root  23 Apr 22  2021 php-cgi-bin -> /usr/lib/cgi-bin/php7.3
    lrwxrwxrwx 1 root root  18 Mar 10 00:32 phpdbg -> /usr/bin/phpdbg8.0
    lrwxrwxrwx 1 root root  34 Mar 10 00:32 phpdbg.1.gz -> /usr/share/man/man1/phpdbg8.0.1.gz
    lrwxrwxrwx 1 root root  24 Apr 14 23:38 php-fpm.sock -> /run/php/php7.3-fpm.sock
    
    I try this solution https://stackoverflow.com/questions...-10-3-error-failed-to-start-the-php-7-3-fastc to start php7-3-fpm but it's not working
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    Take care you installed php mysqli extension for all PHP versions by reinstalling it:

    apt install --reinstall php7.3-mysqli php7.4-mysqli php8.0-mysqli php8.1-mysqli

    then restart apache2 and check if the error persists. If your system currently uses PHP 7.3 or 7.4 is not really critical as both should work, it would be critical if it would be PHP 8 or 8.1.
     
  11. yasine

    yasine New Member

    I just did that but the error still persists
    I think is the main problem :
    Untitled.png

    if I succeed to overcoming this ; the problem will be resolved
    here is the phpinfo : https://dryaqini.ilyasine.com/phpinfo.php
    although the test report shows the active php is 7.3 but in phpinfo still 7.4
     

    Attached Files:

  12. till

    till Super Moderator Staff Member ISPConfig Developer

    ISPconfig GUI does not use php-fpm on Apache, it uses php-fastcgi (php-cgi binary). Do you still get the exact same message about missing mysqli?

    To fix php-fpm, create the missing PHP fpm config file:

    /etc/php/7.3/fpm/php-fpm.conf

    and insert the following content:

    Code:
    ;;;;;;;;;;;;;;;;;;;;;
    ; FPM Configuration ;
    ;;;;;;;;;;;;;;;;;;;;;
    
    ; All relative paths in this configuration file are relative to PHP's install
    ; prefix (/usr). This prefix can be dynamically changed by using the
    ; '-p' argument from the command line.
    
    ;;;;;;;;;;;;;;;;;;
    ; Global Options ;
    ;;;;;;;;;;;;;;;;;;
    
    [global]
    ; Pid file
    ; Note: the default prefix is /var
    ; Default Value: none
    pid = /run/php/php7.3-fpm.pid
    
    ; Error log file
    ; If it's set to "syslog", log is sent to syslogd instead of being written
    ; into a local file.
    ; Note: the default prefix is /var
    ; Default Value: log/php-fpm.log
    error_log = /var/log/php7.3-fpm.log
    
    ; syslog_facility is used to specify what type of program is logging the
    ; message. This lets syslogd specify that messages from different facilities
    ; will be handled differently.
    ; See syslog(3) for possible values (ex daemon equiv LOG_DAEMON)
    ; Default Value: daemon
    ;syslog.facility = daemon
    
    ; syslog_ident is prepended to every message. If you have multiple FPM
    ; instances running on the same server, you can change the default value
    ; which must suit common needs.
    ; Default Value: php-fpm
    ;syslog.ident = php-fpm
    
    ; Log level
    ; Possible Values: alert, error, warning, notice, debug
    ; Default Value: notice
    ;log_level = notice
    
    ; Log limit on number of characters in the single line (log entry). If the
    ; line is over the limit, it is wrapped on multiple lines. The limit is for
    ; all logged characters including message prefix and suffix if present. However
    ; the new line character does not count into it as it is present only when
    ; logging to a file descriptor. It means the new line character is not present
    ; when logging to syslog.
    ; Default Value: 1024
    ;log_limit = 4096
    
    ; Log buffering specifies if the log line is buffered which means that the
    ; line is written in a single write operation. If the value is false, then the
    ; data is written directly into the file descriptor. It is an experimental
    ; option that can potentionaly improve logging performance and memory usage
    ; for some heavy logging scenarios. This option is ignored if logging to syslog
    ; as it has to be always buffered.
    ; Default value: yes
    ;log_buffering = no
    
    ; If this number of child processes exit with SIGSEGV or SIGBUS within the time
    ; interval set by emergency_restart_interval then FPM will restart. A value
    ; of '0' means 'Off'.
    ; Default Value: 0
    ;emergency_restart_threshold = 0
    
    ; Interval of time used by emergency_restart_interval to determine when
    ; a graceful restart will be initiated.  This can be useful to work around
    ; accidental corruptions in an accelerator's shared memory.
    ; Available Units: s(econds), m(inutes), h(ours), or d(ays)
    ; Default Unit: seconds
    ; Default Value: 0
    ;emergency_restart_interval = 0
    
    ; Time limit for child processes to wait for a reaction on signals from master.
    ; Available units: s(econds), m(inutes), h(ours), or d(ays)
    ; Default Unit: seconds
    ; Default Value: 0
    ;process_control_timeout = 0
    
    ; The maximum number of processes FPM will fork. This has been designed to control
    ; the global number of processes when using dynamic PM within a lot of pools.
    ; Use it with caution.
    ; Note: A value of 0 indicates no limit
    ; Default Value: 0
    ; process.max = 128
    
    ; Specify the nice(2) priority to apply to the master process (only if set)
    ; The value can vary from -19 (highest priority) to 20 (lowest priority)
    ; Note: - It will only work if the FPM master process is launched as root
    ;       - The pool process will inherit the master process priority
    ;         unless specified otherwise
    ; Default Value: no set
    ; process.priority = -19
    
    ; Send FPM to background. Set to 'no' to keep FPM in foreground for debugging.
    ; Default Value: yes
    ;daemonize = yes
    
    ; Set open file descriptor rlimit for the master process.
    ; Default Value: system defined value
    ;rlimit_files = 1024
    
    ; Set max core size rlimit for the master process.
    ; Possible Values: 'unlimited' or an integer greater or equal to 0
    ; Default Value: system defined value
    ;rlimit_core = 0
    
    ; Specify the event mechanism FPM will use. The following is available:
    ; - select     (any POSIX os)
    ; - poll       (any POSIX os)
    ; - epoll      (linux >= 2.5.44)
    ; - kqueue     (FreeBSD >= 4.1, OpenBSD >= 2.9, NetBSD >= 2.0)
    ; - /dev/poll  (Solaris >= 7)
    ; - port       (Solaris >= 10)
    ; Default Value: not set (auto detection)
    ;events.mechanism = epoll
    
    ; When FPM is built with systemd integration, specify the interval,
    ; in seconds, between health report notification to systemd.
    ; Set to 0 to disable.
    ; Available Units: s(econds), m(inutes), h(ours)
    ; Default Unit: seconds
    ; Default value: 10
    ;systemd_interval = 10
    
    ;;;;;;;;;;;;;;;;;;;;
    ; Pool Definitions ;
    ;;;;;;;;;;;;;;;;;;;;
    
    ; Multiple pools of child processes may be started with different listening
    ; ports and different management options.  The name of the pool will be
    ; used in logs and stats. There is no limitation on the number of pools which
    ; FPM can handle. Your system will tell you anyway :)
    
    ; Include one or more files. If glob(3) exists, it is used to include a bunch of
    ; files from a glob(3) pattern. This directive can be used everywhere in the
    ; file.
    ; Relative path can also be used. They will be prefixed by:
    ;  - the global prefix if it's been set (-p argument)
    ;  - /usr otherwise
    include=/etc/php/7.3/fpm/pool.d/*.conf
     
  13. yasine

    yasine New Member

    I did what you said ; create the php-fpm.conf file and paste the content you provide to it , restart apache , but no result .
    still getting the exact same message about missing mysqli :
    Code:
    root@azure:/# apt install --reinstall php7.3-mysqli php7.4-mysqli php8.0-mysqli php8.1-mysqli
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    Note, selecting 'php7.3-mysql' instead of 'php7.3-mysqli'
    Note, selecting 'php7.4-mysql' instead of 'php7.4-mysqli'
    Note, selecting 'php8.0-mysql' instead of 'php8.0-mysqli'
    Note, selecting 'php8.1-mysql' instead of 'php8.1-mysqli'
    The following packages were automatically installed and are no longer required:
      linux-image-4.19.0-16-cloud-amd64 php8.0-imagick
    Use 'apt autoremove' to remove them.
    0 upgraded, 0 newly installed, 4 reinstalled, 0 to remove and 89 not upgraded.
    1 not fully installed or removed.
    Need to get 0 B/477 kB of archives.
    After this operation, 0 B of additional disk space will be used.
    (Reading database ... 67152 files and directories currently installed.)
    Preparing to unpack .../php7.3-mysql_7.3.33-4+0~20220627.98+debian10~1.gbp40b3e4_amd64.deb ...
    Unpacking php7.3-mysql (7.3.33-4+0~20220627.98+debian10~1.gbp40b3e4) over (7.3.33-4+0~20220627.98+debian10~1.gbp40b3e4) ...
    Preparing to unpack .../php7.4-mysql_1%3a7.4.30-3+0~20220627.69+debian10~1.gbpf2b381_amd64.deb ...
    Unpacking php7.4-mysql (1:7.4.30-3+0~20220627.69+debian10~1.gbpf2b381) over (1:7.4.30-3+0~20220627.69+debian10~1.gbpf2b381) ...
    Preparing to unpack .../php8.0-mysql_1%3a8.0.22-1+0~20220815.40+debian10~1.gbpf6bdf4_amd64.deb ...
    Unpacking php8.0-mysql (1:8.0.22-1+0~20220815.40+debian10~1.gbpf6bdf4) over (1:8.0.22-1+0~20220815.40+debian10~1.gbpf6bdf4) ...
    Preparing to unpack .../php8.1-mysql_8.1.9-1+0~20220815.24+debian10~1.gbp4d5b5a_amd64.deb ...
    Unpacking php8.1-mysql (8.1.9-1+0~20220815.24+debian10~1.gbp4d5b5a) over (8.1.9-1+0~20220815.24+debian10~1.gbp4d5b5a) ...
    Setting up php7.4-mysql (1:7.4.30-3+0~20220627.69+debian10~1.gbpf2b381) ...
    Setting up php7.3-fpm (7.3.33-4+0~20220627.98+debian10~1.gbp40b3e4) ...
    Not replacing deleted config file /etc/php/7.3/fpm/php.ini
    NOTICE: Not enabling PHP 7.3 FPM by default.
    NOTICE: To enable PHP 7.3 FPM in Apache2 do:
    NOTICE: a2enmod proxy_fcgi setenvif
    NOTICE: a2enconf php7.3-fpm
    NOTICE: You are seeing this message because you have apache2 package installed.
    Job for php7.3-fpm.service failed because the control process exited with error code.
    See "systemctl status php7.3-fpm.service" and "journalctl -xe" for details.
    invoke-rc.d: initscript php7.3-fpm, action "restart" failed.
    ● php7.3-fpm.service - The PHP 7.3 FastCGI Process Manager
       Loaded: loaded (/lib/systemd/system/php7.3-fpm.service; enabled; vendor preset: enabled)
       Active: failed (Result: exit-code) since Sun 2022-08-28 19:16:27 UTC; 13ms ago
         Docs: man:php-fpm7.3(8)
      Process: 21503 ExecStart=/usr/sbin/php-fpm7.3 --nodaemonize --fpm-config /etc/php/7.3/fpm/php-fpm.conf (code=exited, status=78)
      Process: 21511 ExecStopPost=/usr/lib/php/php-fpm-socket-helper remove /run/php/php-fpm.sock /etc/php/7.3/fpm/pool.d/www.conf 73 (code=exited, status=0/SUCCESS)
     Main PID: 21503 (code=exited, status=78)
    
    Aug 28 19:16:27 azure systemd[1]: Starting The PHP 7.3 FastCGI Process Manager...
    Aug 28 19:16:27 azure php-fpm7.3[21503]: [28-Aug-2022 19:16:27] WARNING: Nothing matches the include pattern '/etc/php/7.3/fpm/pool.d/*.conf' from /etc/php/7.3/fpm/php-fpm.conf at line 143.
    Aug 28 19:16:27 azure php-fpm7.3[21503]: [28-Aug-2022 19:16:27] ERROR: No pool defined. at least one pool section must be specified in config file
    Aug 28 19:16:27 azure php-fpm7.3[21503]: [28-Aug-2022 19:16:27] ERROR: failed to post process the configuration
    Aug 28 19:16:27 azure php-fpm7.3[21503]: [28-Aug-2022 19:16:27] ERROR: FPM initialization failed
    Aug 28 19:16:27 azure systemd[1]: php7.3-fpm.service: Main process exited, code=exited, status=78/CONFIG
    Aug 28 19:16:27 azure systemd[1]: php7.3-fpm.service: Failed with result 'exit-code'.
    Aug 28 19:16:27 azure systemd[1]: Failed to start The PHP 7.3 FastCGI Process Manager.
    dpkg: error processing package php7.3-fpm (--configure):
     installed php7.3-fpm package post-installation script subprocess returned error exit status 1
    Setting up php8.0-mysql (1:8.0.22-1+0~20220815.40+debian10~1.gbpf6bdf4) ...
    Setting up php8.1-mysql (8.1.9-1+0~20220815.24+debian10~1.gbp4d5b5a) ...
    Setting up php7.3-mysql (7.3.33-4+0~20220627.98+debian10~1.gbp40b3e4) ...
    Not replacing deleted config file /etc/php/7.3/mods-available/mysqlnd.ini
    WARNING: Module mysqlnd ini file doesn't exist under /etc/php/7.3/mods-available
    WARNING: Module mysqlnd ini file doesn't exist under /etc/php/7.3/mods-available
    WARNING: Module mysqlnd ini file doesn't exist under /etc/php/7.3/mods-available
    WARNING: Module mysqlnd ini file doesn't exist under /etc/php/7.3/mods-available
    Not replacing deleted config file /etc/php/7.3/mods-available/mysqli.ini
    WARNING: Module mysqli ini file doesn't exist under /etc/php/7.3/mods-available
    WARNING: Module mysqli ini file doesn't exist under /etc/php/7.3/mods-available
    WARNING: Module mysqli ini file doesn't exist under /etc/php/7.3/mods-available
    WARNING: Module mysqli ini file doesn't exist under /etc/php/7.3/mods-available
    Not replacing deleted config file /etc/php/7.3/mods-available/pdo_mysql.ini
    WARNING: Module pdo_mysql ini file doesn't exist under /etc/php/7.3/mods-available
    WARNING: Module pdo_mysql ini file doesn't exist under /etc/php/7.3/mods-available
    WARNING: Module pdo_mysql ini file doesn't exist under /etc/php/7.3/mods-available
    WARNING: Module pdo_mysql ini file doesn't exist under /etc/php/7.3/mods-available
    Processing triggers for libapache2-mod-php7.4 (1:7.4.30-3+0~20220627.69+debian10~1.gbpf2b381) ...
    Processing triggers for libapache2-mod-php7.3 (7.3.33-4+0~20220627.98+debian10~1.gbp40b3e4) ...
    Processing triggers for libapache2-mod-php8.1 (8.1.9-1+0~20220815.24+debian10~1.gbp4d5b5a) ...
    Processing triggers for php7.4-cli (1:7.4.30-3+0~20220627.69+debian10~1.gbpf2b381) ...
    Processing triggers for php8.0-cli (1:8.0.22-1+0~20220815.40+debian10~1.gbpf6bdf4) ...
    Processing triggers for php8.0-phpdbg (1:8.0.22-1+0~20220815.40+debian10~1.gbpf6bdf4) ...
    Processing triggers for php8.1-cli (8.1.9-1+0~20220815.24+debian10~1.gbp4d5b5a) ...
    Processing triggers for php7.3-cgi (7.3.33-4+0~20220627.98+debian10~1.gbp40b3e4) ...
    Processing triggers for php7.3-cli (7.3.33-4+0~20220627.98+debian10~1.gbp40b3e4) ...
    Errors were encountered while processing:
     php7.3-fpm
    E: Sub-process /usr/bin/dpkg returned an error code (1)
    
    this what I get when I'm trying to access to ISPconfig GUI : https://azure.ilyasine.com:8080/index.php
     
  14. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    I still say the error
    Code:
    Fatal error: Uncaught Error: Call to undefined function mysqli_init() in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:83 Stack trace: #0 /usr/local/ispconfig/interface/lib/app.inc.php(70): db->__construct() #1 /usr/local/ispconfig/interface/lib/app.inc.php(399): app->__construct() #2 /usr/local/ispconfig/interface/web/index.php(32): require_once('/usr/local/ispc...') #3 {main} thrown in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 83
    about undefined php function is because the version of PHP running is missing the module that contains that function.
    I now notice you have long uptime:
    Code:
    [INFO] uptime:  21:11:21 up 134 days, 21:32,  1 user,  load average: 0.15, 0.11,
     0.09
    WIth mysterious errors and 4 month uptime I would just reboot and see if that fixes it. Also, have you run apt update ; apt upgrade recently?
     
  15. till

    till Super Moderator Staff Member ISPConfig Developer

    Seems as if you somehoe deleted the mysqli config file and reinstall will not add it again:

    That's probably the reason why you get the error that MySQL support in php is missing. Create the deleted file again:

    /etc/php/7.3/mods-available/mysqli.ini

    and insert this content:

    Code:
    ; configuration for php mysql module
    ; priority=20
    extension=mysqli.so
    into that file and restart apache.
     
  16. yasine

    yasine New Member

    I restarted the VPS like Taleman said :
    OVHcloud.png

    also , I created the /etc/php/7.3/mods-available/mysqli.ini file and inserted the content to it , restart apache ..

    mysqli.png

    but nothing new

    this is what the test report still shows :
    Code:
    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    [WARN] could not determine server's ip address by ifconfig
    [INFO] OS version is Debian GNU/Linux 10 (buster)
    
    [INFO] uptime:  16:58:49 up 40 min,  1 user,  load average: 0.03, 0.08, 0.04
    
    [INFO] memory:
                  total        used        free      shared  buff/cache   available
    Mem:          3.8Gi       1.8Gi       835Mi       124Mi       1.1Gi       1.6Gi
    Swap:            0B          0B          0B
    
    [INFO] systemd failed services status:
      UNIT               LOAD   ACTIVE SUB    DESCRIPTION
    ● php7.3-fpm.service loaded failed failed The PHP 7.3 FastCGI Process Manager
    
    LOAD   = Reflects whether the unit definition was properly loaded.
    ACTIVE = The high-level unit activation state, i.e. generalization of SUB.
    SUB    = The low-level unit activation state, values depend on unit type.
    
    1 loaded units listed. Pass --all to see loaded but inactive units, too.
    To show all installed unit files use 'systemctl list-unit-files'.
    
    [INFO] ISPConfig is installed.
    [WARN] /usr/local/ispconfig/server/lib/config.inc.php is missing.
    
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 7.3.33-4+0~20220627.98+debian10~1.gbp40b3e4
    [INFO] php-cgi (used for cgi php in default vhost!) is version 7.3.33
    
    ##### PORT CHECK #####
    
    
    ##### MAIL SERVER CHECK #####
    
    
    ##### RUNNING SERVER PROCESSES #####
    
    [WARN] I could not determine which web server is running.
    [WARN] I could not determine which mail server is running.
    [WARN] I could not determine which pop3 server is running.
    [WARN] I could not determine which imap server is running.
    [WARN] I could not determine which ftp server is running.
    
    ##### LISTENING PORTS #####
    (only           ()
    Local           (Address)
    [localhost]:10023               (-)
    [localhost]:10024               (-)
    [localhost]:10025               (-)
    [localhost]:10026               (-)
    [localhost]:10027               (-)
    [anywhere]:587          (-)
    [localhost]:11211               (-)
    [anywhere]:110          (-)
    [anywhere]:143          (-)
    [anywhere]:465          (-)
    [anywhere]:21           (-)
    ***.***.***.***:53              (-)
    [localhost]:53          (-)
    [anywhere]:22           (-)
    [anywhere]:25           (-)
    [localhost]:953         (-)
    [anywhere]:993          (-)
    [anywhere]:995          (-)
    *:*:*:*::*:10023                (-)
    *:*:*:*::*:10024                (-)
    *:*:*:*::*:10026                (-)
    *:*:*:*::*:3306         (-)
    *:*:*:*::*:587          (-)
    [localhost]10           (-)
    [localhost]43           (-)
    *:*:*:*::*:8080         (-)
    *:*:*:*::*:80           (-)
    *:*:*:*::*:465          (-)
    *:*:*:*::*:8081         (-)
    *:*:*:*::*:21           (-)
    *:*:*:*::*:53           (-)
    *:*:*:*::*:22           (-)
    *:*:*:*::*:25           (-)
    *:*:*:*::*:953          (-)
    *:*:*:*::*:443          (-)
    *:*:*:*::*:993          (-)
    *:*:*:*::*:995          (-)
    
    
    
    
    ##### IPTABLES #####
    
    
    
    
    ##### LET'S ENCRYPT #####
    
    the same problem here : https://azure.ilyasine.com:8080/index.php

    and the phpinfo : https://dryaqini.ilyasine.com/phpinfo.php
     
  17. till

    till Super Moderator Staff Member ISPConfig Developer

    I guess you put the phpinfo file in the wrong place, so it does not show the PHP ISPConfig is using. The phpinfo file must be in the path /usr/local/ispconfig/interface/web/phpinfo.php and it is accessed with https://azure.ilyasine.com:8080/phpinfo.php
     
  18. yasine

    yasine New Member

  19. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, seems as if this php nearly has no modules installed. Please post the result of this command:

    ls -la /etc/php/7.3/cgi/conf.d/
     
  20. yasine

    yasine New Member

    here is the result :
    Code:
    debian@azure:/$ ls -la /etc/php/7.3/cgi/conf.d/
    total 8
    drwxr-xr-x 2 root root 4096 Jun 27 08:11 .
    drwxr-xr-x 3 root root 4096 Aug 12 00:05 ..
    
     

Share This Page