FEDORA-2019-13d2ba0aed

security update in Fedora 30 for phpMyAdmin and php-phpmyadmin-sql-parser

Status: stable a month ago

Upstream announcement:

Welcome to phpMyAdmin 4.9.0.1, a bugfix release that includes important security fixes.

This release fixes two security vulnerabilities:

  • PMASA-2019-3 is an SQL injection flaw in the Designer feature
  • PMASA-2019-4 is a CSRF attack that's possible through the 'cookie' login form

Upgrading is highly recommended for all users. Using the 'http' auth_type instead of 'cookie' can mitigate the CSRF attack.

The solution for the CSRF attack does remove the former functionality to log in directly through URL parameters (as mentioned in FAQ 4.8, such as https://example.com/phpmyadmin/?pma_username=root&password=foo). Such behavior was discouraged and is now removed. Other query parameters work as expected; only pma_username and pma_password have been removed.

This release also includes fixes for many bugs, including:

  • Several issues with SYSTEM VERSIONING tables
  • Fixed json encode error in export
  • Fixed JavaScript events not activating on input (sql bookmark issue)
  • Show Designer combo boxes when adding a constraint
  • Fix edit view
  • Fixed invalid default value for bit field
  • Fix several errors relating to GIS data types
  • Fixed javascript error PMA_messages is not defined
  • Fixed import XML data with leading zeros
  • Fixed php notice, added support for 'DELETE HISTORY' table privilege (MariaDB >= 10.3.4)
  • Fixed MySQL 8.0.0 issues with GIS display
  • Fixed "Server charset" in "Database server" tab showing wrong information
  • Fixed can not copy user on Percona Server 5.7
  • Updated sql-parser to version 4.3.2, which fixes several parsing and linting problems

There are many, many more bug fixes thanks to the efforts of our developers, Google Summer of Code applicants, and other contributors.

The phpMyAdmin team


phpmyadmin/sql-parser version 4.3.2

  • Fix redundant whitespaces in build() outputs (#228)
  • Fix incorrect error on DEFAULT keyword in ALTER operation (#229)
  • Fix incorrect outputs from Query::getClause (#233)
  • Add support for reading an SQL file from stdin
  • Fix for missing tokenize-query in Composer's vendor/bin/ directory
  • Fix for PHP warnings with an incomplete CASE expression (#241)
  • Fix for error message with multiple CALL statements (#223)
  • Recognize the question mark character as a parameter (#242)

How to install

sudo dnf upgrade --advisory=FEDORA-2019-13d2ba0aed

Comments 9

This update has been submitted for testing by remi.

This update test gating status has been changed to 'waiting'.

This update test gating status has been changed to 'ignored'.

remi edited this update.

This update has been pushed to testing.

This update has reached 7 days in testing and can be pushed to stable now if the maintainer wishes

This update has been submitted for stable by remi.

This update has been pushed to stable.

Content Type
RPM
Status
stable
Test Gating
Submitted by
Update Type
security
Update Severity
high
Karma
+1
stable threshold: 3
unstable threshold: -3
Autopush
Enabled
Dates
submitted a month ago
in testing a month ago
in stable a month ago
modified a month ago

Related Bugs 4

00 #1717401 CVE-2019-11768 phpmyadmin: specially crafted database name in the designer feature can be used to trigger an SQL injection attack
00 #1717402 CVE-2019-12616 phpmyadmin: broken tag provided by attacker and pointing at the victim's phpMyAdmin database can cause CSRF through the victim
00 #1717406 CVE-2019-12616 phpMyAdmin: broken tag provided by attacker and pointing at the victim's phpMyAdmin database can cause CSRF through the victim [fedora-all]
00 #1717409 CVE-2019-11768 phpMyAdmin: specially crafted database name in the designer feature can be used to trigger an SQL injection attack [fedora-all]

Automated Test Results