Bug 27265

Updated phpmyadmin
This update removes a configuration option set in phpmyadmin which is commonly not used and is not available if apache_mod-php is not installed.


Update in core/updates_testing
========================
phpmyadmin-4.9.5-2.mga7.noarch.rpm
SRPM:
phpmyadmin-4.9.5-2.mga7.src.rpm

Blocks: (none) => 27239
Assignee: mageia => qa-bugs

Installed and tested without issues.


Tested local and remote servers. Using both php-fpm and mod_php. PHP version 7.3.22. No regressions.


System: Mageia 7, x86_64, Apache, php-fpm, MariaDB, Firefox, Chromium, Intel CPU.


$ uname -a
Linux marte 5.7.19-desktop-1.mga7 #1 SMP Thu Aug 27 20:27:55 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
$ rpm -q phpmyadmin apache mariadb php-fpm
phpmyadmin-4.9.5-2.mga7
apache-2.4.46-1.mga7
mariadb-10.3.24-1.mga7
php-fpm-7.3.22-2.mga7
$ systemctl status php-fpm.socket php-fpm.service mysqld.socket mysqld.service httpd.socket httpd.service 
● php-fpm.socket - php-fpm Server Socket
   Loaded: loaded (/usr/local/lib/systemd/system/php-fpm.socket; enabled; vendor preset: disabled)
   Active: inactive (dead) since Thu 2020-09-10 23:56:03 WEST; 8min ago
   Listen: /var/lib/php-fpm/php-fpm.sock (Stream)

set 10 08:33:39 marte systemd[1]: Listening on php-fpm Server Socket.
set 10 23:56:03 marte systemd[1]: php-fpm.socket: Succeeded.
set 10 23:56:03 marte systemd[1]: Closed php-fpm Server Socket.

● php-fpm.service - The PHP FastCGI Process Manager
   Loaded: loaded (/usr/lib/systemd/system/php-fpm.service; disabled; vendor preset: disabled)
   Active: active (running) since Thu 2020-09-10 23:56:04 WEST; 8min ago
 Main PID: 28315 (php-fpm)
   Status: "Processes active: 0, idle: 2, Requests: 50, slow: 0, Traffic: 0req/sec"
    Tasks: 3 (limit: 4697)
   Memory: 49.6M
   CGroup: /system.slice/php-fpm.service
           ├─28315 php-fpm: master process (/etc/php-fpm.conf)
           ├─28397 php-fpm: pool www
           └─28407 php-fpm: pool www

set 10 23:56:03 marte systemd[1]: Starting The PHP FastCGI Process Manager...
set 10 23:56:04 marte php-fpm[28315]: [NOTICE] fpm is running, pid 28315
set 10 23:56:04 marte php-fpm[28315]: [NOTICE] ready to handle connections
set 10 23:56:04 marte systemd[1]: Started The PHP FastCGI Process Manager.
set 10 23:56:04 marte php-fpm[28315]: [NOTICE] systemd monitor interval set to 10000ms

● mysqld.socket - mysqld Server Socket
   Loaded: loaded (/usr/local/lib/systemd/system/mysqld.socket; enabled; vendor preset: disabled)
   Active: inactive (dead) since Thu 2020-09-10 23:56:09 WEST; 8min ago
   Listen: /var/lib/mysql/mysql.sock (Stream)

set 10 08:33:39 marte systemd[1]: Listening on mysqld Server Socket.
set 10 23:56:09 marte systemd[1]: mysqld.socket: Succeeded.
set 10 23:56:09 marte systemd[1]: Closed mysqld Server Socket.

● mysqld.service - MySQL database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
   Active: active (running) since Thu 2020-09-10 23:56:10 WEST; 8min ago
  Process: 28348 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS)
 Main PID: 28362 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 32 (limit: 4697)
   Memory: 81.8M
   CGroup: /system.slice/mysqld.service
           └─28362 /usr/sbin/mysqld

set 10 23:56:10 marte mysqld[28362]: 2020-09-10 23:56:10 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
set 10 23:56:10 marte mysqld[28362]: 2020-09-10 23:56:10 0 [Note] InnoDB: 10.3.24 started; log sequence number 297292497; transaction id 895827
set 10 23:56:10 marte mysqld[28362]: 200910 23:56:10 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED.
set 10 23:56:10 marte mysqld[28362]: 200910 23:56:10 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2020-09-10 23:56:10 0 [Note] InnoDB: Loading buffer pool(s) from >
set 10 23:56:10 marte mysqld[28362]: 2020-09-10 23:56:10 0 [Note] Reading of all Master_info entries succeeded
set 10 23:56:10 marte mysqld[28362]: 2020-09-10 23:56:10 0 [Note] Added new Master_info '' to hash table
set 10 23:56:10 marte mysqld[28362]: 2020-09-10 23:56:10 0 [Note] /usr/sbin/mysqld: ready for connections.
set 10 23:56:10 marte mysqld[28362]: Version: '10.3.24-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 0  Mageia MariaDB Server
set 10 23:56:10 marte systemd[1]: Started MySQL database server.
set 10 23:56:10 marte mysqld[28362]: 2020-09-10 23:56:10 0 [Note] InnoDB: Buffer pool(s) load completed at 200910 23:56:10

● httpd.socket - httpd server activation socket
   Loaded: loaded (/usr/local/lib/systemd/system/httpd.socket; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2020-09-10 08:33:39 WEST; 15h ago
   Listen: [::]:80 (Stream)
           [::]:443 (Stream)
    Tasks: 0 (limit: 4697)
   Memory: 92.0K
   CGroup: /system.slice/httpd.socket

set 10 08:33:39 marte systemd[1]: Listening on httpd server activation socket.

● httpd.service - The Apache HTTP Server
   Loaded: loaded (/usr/lib/systemd/system/httpd.service; disabled; vendor preset: disabled)
   Active: active (running) since Thu 2020-09-10 09:17:42 WEST; 14h ago
 Main PID: 5585 (httpd)
   Status: "Total requests: 270; Idle/Busy workers 92/8;Requests/sec: 0.00507; Bytes served/sec:  44 B/sec"
    Tasks: 66 (limit: 4697)
   Memory: 33.8M
   CGroup: /system.slice/httpd.service
           ├─5585 /usr/sbin/httpd -DFOREGROUND
           ├─5586 /usr/sbin/httpd -DFOREGROUND
           └─5587 /usr/sbin/httpd -DFOREGROUND

set 10 09:17:42 marte systemd[1]: Starting The Apache HTTP Server...
set 10 09:17:42 marte systemd[1]: Started The Apache HTTP Server.

CC: (none) => mageia

MGA7-64 Plasma on Lenovo B50
No installation issues.
Tried torun it with php backport from bug 27245 is installed.
Made sure httpd and mysqld are running. Starting phpmyadmin gets me Error 503.
Following Comment 2 above:
# systemctl status php-fpm.socket php-fpm.service
Unit php-fpm.socket could not be found.
Unit php-fpm.servic.service could not be found.

CC: (none) => herman.viaene

Sorry, update of  bug 27245 was not installed yet at my first test.
After doin g this installation, I can work phpmyadmin to create a neew database, add a table with four columns, a primary key and a unique key on a secnd column .
Deleted another test database, all works OK.

Whiteboard: (none) => MGA7-64-OK

Validating. Advisory information in Comment 1.

CC: (none) => andrewsfarm, sysadmin-bugs
Keywords: (none) => validated_update

An update for this issue has been pushed to the Mageia Updates repository.

https://advisories.mageia.org/MGAA-2020-0208.html

Status: NEW => RESOLVED
Resolution: (none) => FIXED