Does Yast-installed phpMyAdmin follow php.ini directives?

English Applications
,
1

Hi all,

I installed phpMyAdmin from the Yast software install option, thinking it would save time, hassle, etc since it would be natively installed as it were.
It all went fine until I decided to import databases that had been exported via a Debian-based phpMyAdmin.
Most of these databases are well over 100MB in size. Having noticed that my OpenSuse phpMyAdmin had a file upload limit set at 64MiB, I immediately went to “/etc/php8/apache2/php.ini” and upped some values:

memory_limit = 512M
...
post_max_size = 512M
...
upload_max_filesize = 512M

Note: the above lines are straight copy-paste from the php.ini in the console.
I then restarted the apache server.
Changing these values did not alter the phpMyAdmin max upload file size of 64MiB.
I cleared the browser cache: still no change.

To test that phpMyAdmin is reading the proper php.ini, I changed the values to:

memory_limit = 256M
...
post_max_size = 32M
...
upload_max_filesize = 32M

I restarted apache and cleared the cache.
phpMyAdmin did register the change and showed a max upload file size of 32MiB.

I restored the values to what I need:

memory_limit = 512M
...
post_max_size = 512M
...
upload_max_filesize = 512M

I restarted apache and cleared the cache.
phpMyAdmin did register the change somewhat but restored its seemingly own max upload file size of 64MiB.

Anything I’m missing here?
Help appreciated.
Thank you.

2

I’ve ran into this in the past IIRC. What I do remember is that I had to change (a) value(s) inside phpmyadmin

3

memory_limit should be greater than the other two.

4

@jsc
Thank you for the reminder.
I tried the following:
memory_limit = 1G ... post_max_size = 512M ... upload_max_filesize = 512M
phpMyAdmin still stuck on 64MiB…

5

Hi all,
@knurpht alluded to having the same problem and mentioned value(s) changed inside phpMyAdmin.
Thank you for that. It was enough to make me look deeper into the OpenSuse phpMyAdmin install.
It looks like two files are created in /etc/apache2/conf.d/:
phpMyAdmin.conf
and
phpMyAdmin.inc
Looking inside phpMyAdmin.inc there are what seem to be php.ini overrides.
One of them: php_admin_value upload_max_filesize 64M
I changed this to 256M, restarted apache and now phpMyAdmin accepts uploads up to 256MiB.

Thank you all for your help.

6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.