Help with phpmyadmin upload limit

Discussion in 'Installation/Configuration' started by RafaelSP, Aug 2, 2025.

  1. RafaelSP

    RafaelSP New Member

    Hello, I installed ISPConfig based on this tutorial: (mailserverguru :install-ispconfig-on-ubuntu-24-04/) and everything seemed to work perfectly. However, when I tried to import my database, PHPMyAdmin wouldn't allow it, saying the file was too large. I've already added "upload-max-filesize" to all php.ini files for all versions of PHP I have installed. I also tried adding these directives to the domain menu (in the ISPConfig dashboard) for PHP, but that didn't work either. When I accessed PHPMyAdmin, under the import tab, it still says "Browse your computer: (Maximum size: 2,048KB)."
    I know there are ways to import large backups directly, but since I plan to try installing my WHMCS in ISPConfig, it's important for me to increase the maximum size within PHPMyAdmin. If anyone can help me figure out how to do this, I'd appreciate it.
    Code:
    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    [WARN] could not determine server's ip address by ifconfig
    [INFO] OS version is Ubuntu 24.04.2 LTS
     
    [INFO] uptime:  08:46:39 up 11:05,  1 user,  load average: 0.04, 0.01, 0.00
     
    [INFO] memory:
                   total        used        free      shared  buff/cache   available
    Mem:           1.9Gi       987Mi       237Mi        70Mi       994Mi       979Mi
    Swap:          2.0Gi       1.3Gi       696Mi
     
    [INFO] systemd failed services status:
      UNIT LOAD ACTIVE SUB DESCRIPTION
    
    0 loaded units listed.
    
    [INFO] ISPConfig is installed.
    
    ##### ISPCONFIG #####
    ISPConfig version is 3.3.0p2
    
    
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 8.3.23
    [INFO] php-cgi (used for cgi php in default vhost!) is version 8.3.23
    
    ##### PORT CHECK #####
    
    
    ##### MAIL SERVER CHECK #####
    
    [WARN] I found no "smtps" entry in your postfix master.cf
    [INFO] this is not critical, but if you want to offer SSL for smtp (not TLS) con
    nections you have to enable this.
    
    ##### RUNNING SERVER PROCESSES #####
    
    [INFO] I found the following web server(s):
        Apache 2 (PID 21768)
    [INFO] I found the following mail server(s):
        Postfix (PID 1531)
    [INFO] I found the following pop3 server(s):
        Dovecot (PID 696)
    [INFO] I found the following imap server(s):
        Dovecot (PID 696)
    [INFO] I found the following ftp server(s):
        PureFTP (PID 1275)
    
    ##### LISTENING PORTS #####
    (only        ()
    Local        (Address)
    [anywhere]:465        (1531/master)
    [anywhere]:110        (696/dovecot)
    [anywhere]:4190        (696/dovecot)
    [localhost]:53        (702/named)
    [localhost]:53        (702/named)
    [localhost]:11334        (837/rspamd:)
    [localhost]:11332        (837/rspamd:)
    [localhost]:11333        (837/rspamd:)
    [anywhere]:25        (1531/master)
    [anywhere]:22        (1/init)
    [anywhere]:21        (1275/pure-ftpd)
    [anywhere]:3306        (11023/mariadbd)
    [localhost]:6379        (730/redis-server)
    [anywhere]:143        (696/dovecot)
    [localhost]:10023        (432/postgrey)
    [anywhere]:995        (696/dovecot)
    [anywhere]:993        (696/dovecot)
    [localhost]:953        (702/named)
    [localhost]:953        (702/named)
    [localhost]:11211        (700/memcached)
    ***.***.***.***:53        (702/named)
    ***.***.***.***:53        (702/named)
    [anywhere]:587        (1531/master)
    *:*:*:*::*:953        (702/named)
    *:*:*:*::*:953        (702/named)
    *:*:*:*::*:11211        (700/memcached)
    *:*:*:*::*:465        (1531/master)
    *:*:*:*::*:10023        (432/postgrey)
    *:*:*:*::*:443        (21768/apache2)
    [localhost]10        (696/dovecot)
    *:*:*:*::**:*:*:*::*53        (702/named)
    *:*:*:*::**:*:*:*::*53        (702/named)
    *:*:*:*::*:4190        (696/dovecot)
    *:*:*:*::*:80        (21768/apache2)
    *:*:*:*::*:25        (1531/master)
    *:*:*:*::*:22        (1/init)
    *:*:*:*::*:21        (1275/pure-ftpd)
    *:*:*:*::*:3306        (11023/mariadbd)
    [localhost]43        (696/dovecot)
    *:*:*:*::*:995        (696/dovecot)
    *:*:*:*::*:993        (696/dovecot)
    *:*:*:*::*:8081        (21768/apache2)
    *:*:*:*::*:8080        (21768/apache2)
    *:*:*:*::*:587        (1531/master)
    *:*:*:*::*:6379        (730/redis-server)
    *:*:*:*::*:53        (702/named)
    *:*:*:*::*:53        (702/named)
    *:*:*:*::*:11332        (837/rspamd:)
    *:*:*:*::*:11333        (837/rspamd:)
    *:*:*:*::*:11334        (837/rspamd:)
    
    
    
    
    ##### IPTABLES #####
    Chain INPUT (policy ACCEPT)
    target     prot opt source               destination         
    
    Chain FORWARD (policy ACCEPT)
    target     prot opt source               destination         
    
    Chain OUTPUT (policy ACCEPT)
    target     prot opt source               destination         
    
    
    
    
    ##### LET'S ENCRYPT #####
    acme.sh is installed in /root/.acme.sh/acme.sh
    
    php version server 8.3
    php site db 7.4
    Ubuntuubuntu-24.04-x86_64

    Since I'm new here, I can't post the link, so here's the information generated by info.php:



    Code:
    PHP Version 7.4.33
    System    Linux painel 6.8.0-31-generic #31-Ubuntu SMP PREEMPT_DYNAMIC Sat Apr 20 00:40:06 UTC 2024 x86_64
    Build Date    Jul 3 2025 16:41:49
    Server API    FPM/FastCGI
    Virtual Directory Support    disabled
    Configuration File (php.ini) Path    /etc/php/7.4/fpm
    Loaded Configuration File    /etc/php/7.4/fpm/php.ini
    Scan this dir for additional .ini files    /etc/php/7.4/fpm/conf.d
    Additional .ini files parsed    /etc/php/7.4/fpm/conf.d/10-mysqlnd.ini, /etc/php/7.4/fpm/conf.d/10-opcache.ini, /etc/php/7.4/fpm/conf.d/10-pdo.ini, /etc/php/7.4/fpm/conf.d/15-xml.ini, /etc/php/7.4/fpm/conf.d/20-calendar.ini, /etc/php/7.4/fpm/conf.d/20-ctype.ini, /etc/php/7.4/fpm/conf.d/20-curl.ini, /etc/php/7.4/fpm/conf.d/20-dom.ini, /etc/php/7.4/fpm/conf.d/20-exif.ini, /etc/php/7.4/fpm/conf.d/20-ffi.ini, /etc/php/7.4/fpm/conf.d/20-fileinfo.ini, /etc/php/7.4/fpm/conf.d/20-ftp.ini, /etc/php/7.4/fpm/conf.d/20-gd.ini, /etc/php/7.4/fpm/conf.d/20-gettext.ini, /etc/php/7.4/fpm/conf.d/20-iconv.ini, /etc/php/7.4/fpm/conf.d/20-imap.ini, /etc/php/7.4/fpm/conf.d/20-intl.ini, /etc/php/7.4/fpm/conf.d/20-json.ini, /etc/php/7.4/fpm/conf.d/20-mbstring.ini, /etc/php/7.4/fpm/conf.d/20-mysqli.ini, /etc/php/7.4/fpm/conf.d/20-pdo_mysql.ini, /etc/php/7.4/fpm/conf.d/20-pdo_sqlite.ini, /etc/php/7.4/fpm/conf.d/20-phar.ini, /etc/php/7.4/fpm/conf.d/20-posix.ini, /etc/php/7.4/fpm/conf.d/20-pspell.ini, /etc/php/7.4/fpm/conf.d/20-readline.ini, /etc/php/7.4/fpm/conf.d/20-shmop.ini, /etc/php/7.4/fpm/conf.d/20-simplexml.ini, /etc/php/7.4/fpm/conf.d/20-soap.ini, /etc/php/7.4/fpm/conf.d/20-sockets.ini, /etc/php/7.4/fpm/conf.d/20-sqlite3.ini, /etc/php/7.4/fpm/conf.d/20-sysvmsg.ini, /etc/php/7.4/fpm/conf.d/20-sysvsem.ini, /etc/php/7.4/fpm/conf.d/20-sysvshm.ini, /etc/php/7.4/fpm/conf.d/20-tidy.ini, /etc/php/7.4/fpm/conf.d/20-tokenizer.ini, /etc/php/7.4/fpm/conf.d/20-xmlreader.ini, /etc/php/7.4/fpm/conf.d/20-xmlrpc.ini, /etc/php/7.4/fpm/conf.d/20-xmlwriter.ini, /etc/php/7.4/fpm/conf.d/20-xsl.ini, /etc/php/7.4/fpm/conf.d/20-zip.ini
    PHP API    20190902
    PHP Extension    20190902
    Zend Extension    320190902
    Zend Extension Build    API320190902,NTS
    PHP Extension Build    API20190902,NTS
    Debug Build    no
    Thread Safety    disabled
    Zend Signal Handling    enabled
    Zend Memory Manager    enabled
    Zend Multibyte Support    provided by mbstring
    IPv6 Support    enabled
    DTrace Support    available, disabled
    Registered PHP Streams    https, ftps, compress.zlib, php, file, glob, data, http, ftp, phar, zip
    Registered Stream Socket Transports    tcp, udp, unix, udg, ssl, tls, tlsv1.0, tlsv1.1, tlsv1.2, tlsv1.3
    Registered Stream Filters    zlib.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, convert.iconv.*
    Zend logoThis program makes use of the Zend Scripting Language Engine:
    Zend Engine v3.4.0, Copyright (c) Zend Technologies
        with Zend OPcache v7.4.33, Copyright (c), by Zend Technologies
    Configuration
    calendar
    Calendar support    enabled
    cgi-fcgi
    php-fpm    active
    Directive    Local Value    Master Value
    cgi.discard_path    0    0
    cgi.fix_pathinfo    1    1
    cgi.force_redirect    1    1
    cgi.nph    0    0
    cgi.redirect_status_env    no value    no value
    cgi.rfc2616_headers    0    0
    fastcgi.error_header    no value    no value
    fastcgi.logging    1    1
    fpm.config    no value    no value
    Core
    PHP Version    7.4.33
    Directive    Local Value    Master Value
    allow_url_fopen    On    On
    allow_url_include    Off    Off
    arg_separator.input    &    &
    arg_separator.output    &    &
    auto_append_file    no value    no value
    auto_globals_jit    On    On
    auto_prepend_file    no value    no value
    browscap    no value    no value
    default_charset    UTF-8    UTF-8
    default_mimetype    text/html    text/html
    disable_classes    no value    no value
    disable_functions    pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,    pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,
    display_errors    Off    Off
    display_startup_errors    Off    Off
     
    Last edited: Aug 2, 2025
  2. till

    till Super Moderator Staff Member ISPConfig Developer

  3. remkoh

    remkoh Active Member HowtoForge Supporter

    Some general php.ini settings are probably overruled within the config file enabling phpmyadmin in your webserver.
    Or within de php related settings you'll find in that config file.
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    In a default setup, changing the parameters in php.ini should be enough. Maybe he did not restart the web server and php-fpm daemons to apply them.
     
  5. RafaelSP

    RafaelSP New Member

  6. RafaelSP

    RafaelSP New Member

    Yes, I did that, I even restarted the VPS. The info.php shows the change correctly, but in the phpmyadmin panel, it didn't change. Look the print
     

    Attached Files:

    • ispc.png
      ispc.png
      File size:
      142.8 KB
      Views:
      11
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    PHPmyadmin is not part of that website, so any changes you make to the website or info.php file will not show the settings from PHPMyAdmin, it just shows what an app would see that you host in that site. PHPMyAdmin is a globally installed Ubuntu package that is just blended into the website using an Alias.

    You must check the php-fpm php.ini file for the default PHP version of the OS (PHP 8.3) and adjust it in that file. The file on Ubuntu is /etc/php/8.3/fpm/php.ini. Then restart php 8.3 FPM daemon:

    service php8.3-fpm restart
     
    remkoh likes this.
  8. RafaelSP

    RafaelSP New Member

    It worked. The problem was in phpmyadmin. I was simply refreshing the page. After making the changes, I had to log out and log back into phpmyadmin, and it updated. Thanks everyone for your help!
     
    remkoh likes this.

Share This Page