PHPMyAdmin Upload Size Limit (PHP Upload Size Limit)

Solomon_Bachman · March 8, 2024, 5:52pm

NethServer Version: 8
Module: Mariadb

Ok, I’m probably just developmentally challenged, however… I would like to restore a database backup from my current webserver, but the php upload limit is defaulted to 2048kb. Is this changeable, if so, how?

oneitonitram · March 8, 2024, 6:14pm

Hello @Solomon_Bachman welcome to the Nethserver community, We hope to provide you more value.

You mentioned restoring mysql database, then mentioned php upload limit.

Might i ask, what method were you using to restore the said database? is this through phpMyadmin or is it through the app you are hosting

mrmarkuz · March 8, 2024, 6:57pm

You can change the php settings in the webserver virtual host advanced settings:

Solomon_Bachman · March 8, 2024, 7:17pm

Attempting to upload a sql dump through phpMyadmin.

Solomon_Bachman · March 8, 2024, 7:17pm

I’ll take a look, I didn’t realize there was a virtual host for the phpMyadmin that is part of the mariadb module.

mrmarkuz · March 8, 2024, 7:21pm

Sorry, there’s no virtual host for phpmyadmin, I thought you wanted to use some webapp on the webserver…

EDIT:

@Solomon_Bachman I was able to set a 20M upload size with following steps on CLI:

Enter the pod:

runagent -m mariadb1

Add UPLOAD_LIMIT size in K, M or G to the environment file:

echo UPLOAD_LIMIT=20M >> environment

Restart the phpmyadmin-app:

systemctl --user restart phpmyadmin-app

You may remove the “UPLOAD_LIMIT=20M” line from the environment file and restart the service after uploading your database file.

oneitonitram · March 8, 2024, 7:59pm

@mrmarkuz i presume those configs for webserver would not affect the PhpMyAdmin, which in this case seems to be the one with the limitations right?

Solomon_Bachman · March 8, 2024, 8:11pm

I’ll give this a go, thank you!

stephdl · March 8, 2024, 8:38pm

https://hub.docker.com/_/phpmyadmin

It wont be enough the environment var must be mounted in the systemd service or the file environment itself can be mounted globally to the container

stephdl · March 8, 2024, 8:42pm

github.com

NethServer/ns8-mariadb/blob/c7acb8c4c56d1197ff103144daf4848ec58f641b/imageroot/systemd/user/phpmyadmin-app.service#L16


      
          [Service]
          Environment=PODMAN_SYSTEMD_UNIT=%n
          EnvironmentFile=%S/state/environment
          EnvironmentFile=%S/state/secrets/passwords.secret
          Restart=always
          TimeoutStopSec=70
          ExecStartPre=/bin/rm -f %t/phpmyadmin-app.pid %t/phpmyadmin-app.ctr-id
          ExecStart=/usr/bin/podman run --conmon-pidfile %t/phpmyadmin-app.pid \
              --cidfile %t/phpmyadmin-app.ctr-id --cgroups=no-conmon \
              --pod-id-file %t/mariadb.pod-id --replace -d --name phpmyadmin-app \
              --env-file=%S/state/environment -e PMA_HOST=127.0.0.1 -e PMA_PORT=3306 \
              -e PMA_PMADB=phpmyadmin -e PMA_CONTROLUSER=phpmyadmin \
              -e PMA_CONTROLPASS=${MARIADB_PASSWORD} \
              -v %S/scripts/create_phpmyadmin_web_alias.sh:/docker-entrypoint.d/create_phpmyadmin_web_alias.sh:Z \
              -v config.user.inc.php:/etc/phpmyadmin/config.user.inc.php:Z \
              -v sql:/var/www/html/sql:z \
              ${PHPMYADMIN_IMAGE}
          ExecStartPost=/usr/bin/podman exec  phpmyadmin-app /bin/bash /docker-entrypoint.d/create_phpmyadmin_web_alias.sh
          ExecStop=/usr/bin/podman stop --ignore --cidfile %t/phpmyadmin-app.ctr-id -t 10
          ExecStopPost=/usr/bin/podman rm --ignore -f --cidfile %t/phpmyadmin-app.ctr-id
          PIDFile=%t/phpmyadmin-app.pid

I was wrong I tought how to mount custom php in the environment file

You are true @mrmarkuz

mrmarkuz · March 8, 2024, 8:47pm

It was luck, I didn’t check the systemd file.
But it’s just a workaround. I think we need a higher upload limit default or maybe a UI control to raise it?

stephdl · March 8, 2024, 8:55pm

Yep. The good new is there was a move of some module to nethforge. Mariadd is one of them.

stephdl · March 9, 2024, 9:12am

new version coming

stephdl · March 9, 2024, 9:13am

oneitonitram · March 9, 2024, 10:08am

wonderful works @stephdl you are a life saver.

Also make considerations for max execution time limit, some SQL files are huge, and therefore, their execurition time is longer.

I am not sure if this is in relation to PhpMadmin or if its something from the mariaDB side of things.

I encountered said issue importing a 400 Mb database, i reverted to cpanel based hosting…

stephdl · March 9, 2024, 10:13am

… envvar:: MAX_EXECUTION_TIME

If set, this option will override the maximum execution time in seconds for phpMyAdmin :config:option:`$cfg['ExecTimeLimit']` and PHP's `max_execution_time`.

.. note:: Format as `[0-9+]`. Default value is `600`.

github.com

phpmyadmin/phpmyadmin/blob/master/docs/setup.rst

.. _setup:

Installation
============

phpMyAdmin does not apply any special security methods to the MySQL
database server. It is still the system administrator's job to grant
permissions on the MySQL databases properly. phpMyAdmin's :guilabel:`Users`
page can be used for this.

Linux distributions
+++++++++++++++++++

phpMyAdmin is included in most Linux distributions. It is recommended to use
distribution packages when possible - they usually provide integration to your
distribution and you will automatically get security updates from your distribution.

.. _debian-package:

Debian and Ubuntu

This file has been truncated. show original

10 minutes to upload 256MB, well it is true I live in europe with a 300Mb fiber internet connexion but but