Unable to connect to ISPConfig panel

Discussion in 'General' started by kike28101, Nov 15, 2022.

  1. kike28101

    kike28101 Member

    Hi
    I apologize for my ignorance
    But the server is a VPS only machine, I installed the Debian 9 OS and then ISPConfig with everything including myphpadmin.
     
  2. kike28101

    kike28101 Member

    from the panel icon, shows blank phpmyadmin page
    the url is correct
    [​IMG]
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    See post #20, I wrote there what to do next. The URL is not the problem, I just mentioned the URL as possible isse based on your original error description, but as we found out already, the description was not quite correct which means that my suggestion was not correct as well.

    Let me explain: if you describe a car mechanic 'my car does not start when it rains' then he will probably guess that the issue might be related to moisture, but in fact, your car does not start at all, no matter if it rains, so the car mechanic will suggest a completely different solution. Therefore it is very important to give a correct description of the issue, your phpmyadmin does not work at all, it's not related to ISPConfig, so the issue has not to be sought within ISPConfig, you have to look at a general config issue on your system and the reason for such a white page is logged by the web server in its error.log, so you must check the error.log to see which error is logged there when you access phpmyadmin on your server.
     
    Last edited: Nov 16, 2022
    pyte likes this.
  4. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    If I were you I wouldn't opt to install Debian 9 since it is quite old / outdated already and would try the latest one supported by ISPConfig which is version 11 for Debian.
     
  5. kike28101

    kike28101 Member

    Hi Till
    This is the log that is generated from the server when I try to access phpmyadmin.

    Can you guide me where would be the problem that it does not load?
    First I have restarted the server, then I have loaded the ISPConfig panel and then I have accessed phpmyadmin from the Database icon of the panel

    Code:
    2022-11-17 15:04:45 140110037616384 [Note] /usr/sbin/mysqld: Normal shutdown
    2022-11-17 15:04:45 140110037616384 [Note] Event Scheduler: Purging the queue. 0 events
    2022-11-17 15:04:46 140109445830400 [Note] InnoDB: FTS optimize thread exiting.
    2022-11-17 15:04:46 140110037616384 [Note] InnoDB: Starting shutdown...
    2022-11-17 15:04:47 140110037616384 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
    2022-11-17 15:04:48 140110037616384 [Note] InnoDB: Shutdown completed; log sequence number 27316207792
    2022-11-17 15:04:48 140110037616384 [Note] /usr/sbin/mysqld: Shutdown complete
    
    2022-11-17 15:06:45 139986014166400 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
    
    2022-11-17 15:06:45 139986014166400 [Note] InnoDB: Using mutexes to ref count buffer pool pages
    2022-11-17 15:06:45 139986014166400 [Note] InnoDB: The InnoDB memory heap is disabled
    2022-11-17 15:06:45 139986014166400 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2022-11-17 15:06:45 139986014166400 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    2022-11-17 15:06:45 139986014166400 [Note] InnoDB: Compressed tables use zlib 1.2.8
    2022-11-17 15:06:45 139986014166400 [Note] InnoDB: Using Linux native AIO
    2022-11-17 15:06:45 139986014166400 [Note] InnoDB: Using SSE crc32 instructions
    2022-11-17 15:06:45 139986014166400 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    2022-11-17 15:06:45 139986014166400 [Note] InnoDB: Completed initialization of buffer pool
    2022-11-17 15:06:46 139986014166400 [Note] InnoDB: Highest supported file format is Barracuda.
    2022-11-17 15:06:49 139986014166400 [Note] InnoDB: 128 rollback segment(s) are active.
    2022-11-17 15:06:49 139986014166400 [Note] InnoDB: Waiting for purge to start
    2022-11-17 15:06:49 139986014166400 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.49-89.0 started; log sequence number 27316207792
    2022-11-17 15:06:50 139986014166400 [Note] Plugin 'FEEDBACK' is disabled.
    2022-11-17 15:06:50 139985462224640 [Note] InnoDB: Dumping buffer pool(s) not yet started
    2022-11-17 15:06:50 139986014166400 [Note] Server socket created on IP: '0.0.0.0'.
    2022-11-17 15:06:50 139986014166400 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '10.1.48-MariaDB-0+deb9u2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Debian 9.13
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    That's not the error.log of the web server, you probably looked into the syslog. The error.log of the web server is either /var/log/apache2/error.log or /var/log/nginx/error.log
     
  7. kike28101

    kike28101 Member

    Hi Tell
    Sorry, Sorry
    This is what the error.log shows when clicking on the database icon in the ISPConfig panel at 8:05 p.m.

    Code:
    [Thu Nov 17 15:34:57.796889 2022] [core:notice] [pid 1243] AH00052: child pid 2197 exit signal Aborted (6)
    [Thu Nov 17 15:35:00.075083 2022] [mpm_prefork:error] [pid 1243] (12)Cannot allocate memory: AH00159: fork: Unable to fork new process
    [Thu Nov 17 15:35:13.031056 2022] [mpm_prefork:error] [pid 1243] (12)Cannot allocate memory: AH00159: fork: Unable to fork new process
    [Thu Nov 17 15:35:27.248219 2022] [mpm_prefork:error] [pid 1243] (12)Cannot allocate memory: AH00159: fork: Unable to fork new process
    [Thu Nov 17 15:35:40.052184 2022] [mpm_prefork:error] [pid 1243] (12)Cannot allocate memory: AH00159: fork: Unable to fork new process
    [Thu Nov 17 15:35:53.397418 2022] [mpm_prefork:error] [pid 1243] (12)Cannot allocate memory: AH00159: fork: Unable to fork new process
    [Thu Nov 17 15:36:05.826014 2022] [mpm_prefork:error] [pid 1243] (12)Cannot allocate memory: AH00159: fork: Unable to fork new process
    [Thu Nov 17 15:37:18.856642 2022] [mpm_prefork:error] [pid 1243] (12)Cannot allocate memory: AH00159: fork: Unable to fork new process
    [Thu Nov 17 15:37:51.403347 2022] [php:warn] [pid 2191] [client 92.190.81.57:65022] PHP Warning:  is_dir(): open_basedir restriction in effect. File(/usr/share/php/php-php-gettext/) is not within the allowed path(s): (/usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext/:/usr/share/php/php-gettext/:/usr/share/javascript/:/usr/share/php/tcpdf/:/usr/share/doc/phpmyadmin/:/usr/share/php/phpseclib/) in /usr/share/phpmyadmin/libraries/vendor_config.php on line 64, referer: https://51.75.254.67:8080/
    [Thu Nov 17 15:37:51.445536 2022] [php:warn] [pid 2191] [client 92.190.81.57:65022] PHP Warning:  require_once(): open_basedir restriction in effect. File(/usr/share/php/php-php-gettext/gettext.inc) is not within the allowed path(s): (/usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext/:/usr/share/php/php-gettext/:/usr/share/javascript/:/usr/share/php/tcpdf/:/usr/share/doc/phpmyadmin/:/usr/share/php/phpseclib/) in /usr/share/phpmyadmin/libraries/common.inc.php on line 77, referer: https://51.75.254.67:8080/
    [Thu Nov 17 15:37:51.445624 2022] [php:warn] [pid 2191] [client 92.190.81.57:65022] PHP Warning:  require_once(/usr/share/php/php-php-gettext/gettext.inc): Failed to open stream: Operation not permitted in /usr/share/phpmyadmin/libraries/common.inc.php on line 77, referer: https://51.75.254.67:8080/
    [Thu Nov 17 15:37:51.445897 2022] [php:error] [pid 2191] [client 92.190.81.57:65022] PHP Fatal error:  Uncaught Error: Failed opening required '/usr/share/php/php-gettext/gettext.inc' (include_path='.') in /usr/share/phpmyadmin/libraries/common.inc.php:77\nStack trace:\n#0 /usr/share/phpmyadmin/index.php(13): require_once()\n#1 {main}\n  thrown in /usr/share/phpmyadmin/libraries/common.inc.php on line 77, referer: https://51.75.254.67:8080/
    [Thu Nov 17 20:05:48.565172 2022] [php:warn] [pid 1361] [client 92.190.81.57:50315] PHP Warning:  is_dir(): open_basedir restriction in effect. File(/usr/share/php/php-php-gettext/) is not within the allowed path(s): (/usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext/:/usr/share/php/php-gettext/:/usr/share/javascript/:/usr/share/php/tcpdf/:/usr/share/doc/phpmyadmin/:/usr/share/php/phpseclib/) in /usr/share/phpmyadmin/libraries/vendor_config.php on line 64, referer: https://51.75.254.67:8080/
    [Thu Nov 17 20:05:48.568554 2022] [php:warn] [pid 1361] [client 92.190.81.57:50315] PHP Warning:  require_once(): open_basedir restriction in effect. File(/usr/share/php/php-php-gettext/gettext.inc) is not within the allowed path(s): (/usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext/:/usr/share/php/php-gettext/:/usr/share/javascript/:/usr/share/php/tcpdf/:/usr/share/doc/phpmyadmin/:/usr/share/php/phpseclib/) in /usr/share/phpmyadmin/libraries/common.inc.php on line 77, referer: https://51.75.254.67:8080/
    [Thu Nov 17 20:05:48.568662 2022] [php:warn] [pid 1361] [client 92.190.81.57:50315] PHP Warning:  require_once(/usr/share/php/php-php-gettext/gettext.inc): Failed to open stream: Operation not permitted in /usr/share/phpmyadmin/libraries/common.inc.php on line 77, referer: https://51.75.254.67:8080/
    [Thu Nov 17 20:05:48.568819 2022] [php:error] [pid 1361] [client 92.190.81.57:50315] PHP Fatal error:  Uncaught Error: Failed opening required '/usr/share/php/php-gettext/gettext.inc' (include_path='.') in /usr/share/phpmyadmin/libraries/common.inc.php:77\nStack trace:\n#0 /usr/share/phpmyadmin/index.php(13): require_once()\n#1 {main}\n  thrown in /usr/share/phpmyadmin/libraries/common.inc.php on line 77, referer: https://51.75.254.67:8080/
    
     
  8. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Code:
    12)Cannot allocate memory:
    Seems not enough memory. You could add a swap partition to that system.
    What does command
    Code:
    free -h
    show now?
     
    ahrasis likes this.
  9. kike28101

    kike28101 Member

    yes
    Code:
    root@vps622713:~# command free -h
                     total        used        free      shared  buff/cache   available
    Mem:             1.9G        677M         85M         99M        1.2G        1.0G
    Swap:             0B          0B          0B
    
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    And in addotion to that, you seem to have removed the php-gettext package, according to the error:

    Code:
    [Thu Nov 17 15:37:51.445897 2022] [php:error] [pid 2191] [client 92.190.81.57:65022] PHP Fatal error:  Uncaught Error: Failed opening required '/usr/share/php/php-gettext/gettext.inc' (include_path='.') in /usr/share/phpmyadmin/libraries/common.inc.php:77\nStack trace:\n#0 /usr/share/phpmyadmin/index.php(13): require_once()\n#1 {main}\n  thrown in /usr/share/phpmyadmin/libraries/common.inc.php on line 77, referer: https://51.75.254.67:8080/
    Install that package again.
     
  11. kike28101

    kike28101 Member

    Hi Tell
    The problem was not solved.
    the php-gettext package was already installed-
    What I have done has been to uninstall, clean and reinstall, but it doesn't work either
    This is the error that the log presents after uninstalling and installing php-gettext

    Code:
    [Fri Nov 18 16:12:14.987841 2022] [php:warn] [pid 9692] [client 92.190.81.57:50658] PHP Warning:  is_dir(): open_basedir restriction in effect. File(/usr/share/php/php-php-gettext/) is not within the allowed path(s): (/usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext/:/usr/share/php/php-gettext/:/usr/share/javascript/:/usr/share/php/tcpdf/:/usr/share/doc/phpmyadmin/:/usr/share/php/phpseclib/) in /usr/share/phpmyadmin/libraries/vendor_config.php on line 64, referer: https://51.75.254.67:8080/index.php
    [Fri Nov 18 16:12:14.988396 2022] [php:warn] [pid 9692] [client 92.190.81.57:50658] PHP Warning:  require_once(): open_basedir restriction in effect. File(/usr/share/php/php-php-gettext/gettext.inc) is not within the allowed path(s): (/usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext/:/usr/share/php/php-gettext/:/usr/share/javascript/:/usr/share/php/tcpdf/:/usr/share/doc/phpmyadmin/:/usr/share/php/phpseclib/) in /usr/share/phpmyadmin/libraries/common.inc.php on line 77, referer: https://51.75.254.67:8080/index.php
    [Fri Nov 18 16:12:14.988434 2022] [php:warn] [pid 9692] [client 92.190.81.57:50658] PHP Warning:  require_once(/usr/share/php/php-php-gettext/gettext.inc): Failed to open stream: Operation not permitted in /usr/share/phpmyadmin/libraries/common.inc.php on line 77, referer: https://51.75.254.67:8080/index.php
    [Fri Nov 18 16:12:14.988502 2022] [php:error] [pid 9692] [client 92.190.81.57:50658] PHP Fatal error:  Uncaught Error: Failed opening required '/usr/share/php/php-gettext/gettext.inc' (include_path='.') in /usr/share/phpmyadmin/libraries/common.inc.php:77\nStack trace:\n#0 /usr/share/phpmyadmin/index.php(13): require_once()\n#1 {main}\n  thrown in /usr/share/phpmyadmin/libraries/common.inc.php on line 77, referer: https://51.75.254.67:8080/index.php
    
     
  12. till

    till Super Moderator Staff Member ISPConfig Developer

    Run this command as root and post the result:

    ls -la /usr/share/php/php-gettext/gettext.inc
     
  13. kike28101

    kike28101 Member

    the result

    Code:
    lrwxrwxrwx 1 root root 30 Jan 29  2017 /usr/share/php/php-gettext/gettext.inc -> ../php-php-gettext/gettext.inc
    root@vps622713:~# ls -la /usr/share/php/php-gettext/gettext.inc
    lrwxrwxrwx 1 root root 30 Jan 29  2017 /usr/share/php/php-gettext/gettext.inc -> ../php-php-gettext/gettext.inc
    
     
  14. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Does the file
    Code:
    ls -lh /usr/share/php/php-php-gettext/gettext.inc
    exist? Maybe some typo with the php-php- thing in the directory name?
     
  15. till

    till Super Moderator Staff Member ISPConfig Developer

    I guess the problem is that the symlink leaves the directories listed in the open_basedir restriction.
    /usr/share/php/php-gettext/ and files inside that path are allowed, but /usr/share/php/php-php-gettext/gettext.inc is not.
     
  16. kike28101

    kike28101 Member

    Hi
    The file exists but look at the images I have several

    1 route /usr/share/php/
    on this route there are two capetas IMG 1 https://prnt.sc/R3ds4Pu6XtAN
    1- php-gettext
    2 php-php-gettext

    2 inside the folder php-gettext there are these files IMG 2 https://prnt.sc/4cLELdFbtLkP
    streams.php
    gettext.php
    gettext.inc

    3 inside the folder php-php-gettext there are these files IMG 3 https://prnt.sc/7b5BJR3x9eND
    folder
    php-gettext
    records
    streams.php
    gettext.php

    4 and inside this last folder php-gettext there are again these files IMG 4 https://prnt.sc/mbSmreoQtNRb
    streams.php
    gettext.php
    gettext.inc

    Conclusion that it is repeated several times and I think that it does not find the route
    Does what I'm saying make sense?
     

Share This Page