Developers March 2020

developers@phpmyadmin.net

3 participants
4 discussions

Start a nNew thread

Question
by Zach 22 Mar '20

22 Mar '20

Hi there, I have a question about my database Sent from my iPhone

2 1

phpMyAdmin 4.9.5 and 5.0.2 are released
by Isaac Bennetch 21 Mar '20

21 Mar '20

Hello, The phpMyAdmin team announces the release of both 4.9.5 and 5.0.2. Both versions contain several security fixes: * PMASA-2020-2 SQL injection vulnerability in the user accounts page, particularly when changing a password * PMASA-2020-3 SQL injection vulnerability relating to the search feature * PMASA-2020-4 SQL injection and XSS having to do with displaying results * Removing of the "options" field for the external transformation. We are removing the ability for users to set "options" field for the external transformation. This must now be hard coded in the plugin file directly (where the program is configured). This feature allows users to pipe output directly to an executable file, however the options field presented a security risk and we have decided to move the options to be hard coded in the transformation plugin file. For further assistance, please reach out to our support team through email or Github pull request. Version 5.0.3 also contains many bug fixes: * Fix for copying a user account * Removed SET AUTOCOMMIT=0 from SQL export * Fix for the display of table borders * Fix for ENUM radio button user interface problems * Improved the prompt for abandoning changes when no changes were made in the SQL window * Fix for inserting a primary key with "insert as new row" * Fix incorrect suggested latest available version to version 5 There are many other bugs fixes, please see the ChangeLog file included with this release for full details. Known shortcomings: Due to changes in the MySQL authentication method, PHP versions prior to 7.4 are unable to authenticate to a MySQL 8.0 or newer server (our tests show the problem actually began with MySQL 8.0.11). This relates to a PHP bug https://bugs.php.net/bug.php?id=76243. There is a workaround, that is to set your user account to use the current-style password hash method, mysql_native_password. This unfortunate lack of coordination has caused the incompatibility to affect all PHP applications, not just phpMyAdmin. For more details, you can see our bug tracker item at https://github.com/phpmyadmin/phpmyadmin/issues/14220. We suggest upgrading your PHP installation to take advantage of the authentication methods. As a reminder, phpMyAdmin 4.9 is in the long-term support phase where it will only get important security fixes and critical bug fixes. Users are suggested to migrate to version 5.0. Downloads are available now at https://phpmyadmin.net/downloads/ For the phpMyAdmin team, Isaac

1 0

phpMyAdmin security pre-release announcement
by Isaac Bennetch 19 Mar '20

19 Mar '20

Hello, The phpMyAdmin team is announcing that we are preparing a security fix which we plan to release Friday, tomorrow, approximately 30 hours from now. The attack vector requires that the attacker be authenticated through a valid MySQL/MariaDB account. Both the 4.9 and 5.0 branches will be updated. This announcement is part of our ongoing effort to announce security releases in advance, when available, and should not be interpreted as any commentary on the details of any specific vulnerability. If you have questions or concerns, you can reach me directly or contact the security team at security(a)phpmyadmin.net. Isaac for the phpMyAdmin team

1 0

GuardianKey plugin to phpMyAdmin
by James Brown 02 Mar '20

02 Mar '20

On Thu Nov 14 18:44:13 CET 2019 Gesiel Bernardes gesiel at guardiankey.io said: > HI Everyone, > > We are trying create a GuardianKey plugin to phpMyAdmin. However, we have > doubts related to the best way to do this and the best point in the code > for this integration. > > GuardianKey is a solution to protect systems against authentication > attacks. It uses Artificial Intelligence and analyses the user's behavior, > threat intelligence and psychometrics (or behavioral biometrics). The > protected system (in the concrete case, phpMyAdmin) must send an event via > REST for the GuardianKey on each login attempt. More info at > https://guardiankey.io/services/guardiankey-auth-security-lite/ <https://guardiankey.io/services/guardiankey-auth-security-lite/> . > > The best way to integrate would be on having a hook in the procedure that > process the user credentials submission in phpMyAdmin (the script that > receives the POST), something such as: > > if(POST IN AUTH FORM) { > boolean loginFailed = checkLogin(); > GuardianKeyEvent event = createEventForGuardianKey(username,loginFailed); > boolean GuardianKeyValidation = checkGuardianKeyViaREST(event); > if(GuardianKeyValidation){ > // Allow access > } else { > // Deny access > } > } > > Where is the best place to create this integration? Is there a way to > create a hook for this purpose? Should we create an extension? > > Any help is welcome. > > Thank you in advance. > > Best regards, > Gesiel I’d be very interested in using GuardianKey with PHPMyAdmin. Does anyone have any suggestions on how Gesiel should go about such an integration? Thanks, James.

1 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

Developers March 2020