November 2019 - Developers - lists.phpmyadmin.net

phpMyAdmin 5.0.0-rc1 (release candidate) is now available
by Isaac Bennetch 23 Nov '19

23 Nov '19

Welcome to the first release candidate of phpMyAdmin 5.0.0. This release features a great number of new features and bug fixes. This is expected to be the final release candidate before 5.0.0 is finalized. Please visit https://github.com/phpmyadmin/phpmyadmin/milestones to stay updated on the expected release date and known bugs. Since 5.0.0-alpha1, there have been several bugfixes, none of which are particularly notable. For a complete comparison, you could visit https://github.com/phpmyadmin/phpmyadmin/compare/RELEASE_5_0_0ALPHA1..RELEA…. The following are the release notes from 5.0.0-alpha1: With this release, we are removing support of old PHP versions (5.5, 5.6, 7.0, and HHVM). These versions are outdated and are no longer supported by the PHP team. Detailed requirement information is available in the documentation included with the download or at https://docs.phpmyadmin.net/en/latest/require.html. As shown at https://www.phpmyadmin.net/downloads/#support our current branch of 4.9.x is planned to remain supported for some time in an LTS capacity. Some of the changes and new features include: * Enable columns names by default for CSV exports * Add Metro theme * Automatically add the index when creating an auto increment column * Improvements to exporting views * Prompt the user for confirmation before running an UPDATE query with no WHERE clause * Improvements to how errors are show to the user (including allowing easier copying of the error text to the clipboard) * Added keystrokes to clear the line (ctrl+l) and clear the entire console window (ctrl+u) * Use charset 'windows-1252' when export format is MS Excel There are several more changes, please refer to the ChangeLog file included with the 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. Downloads are available now at https://phpmyadmin.net/downloads/ Our work would not be possible without the donations of our generous sponsor, and this release in particular is brought to you thanks to the hard work of our Google Summer of Code students and many other contributors. For the team, Isaac

1 0

phpMyAdmin 4.9.2 is released
by Isaac Bennetch 22 Nov '19

22 Nov '19

Welcome to phpMyAdmin 4.9.2, a bugfix release that also contains a security fix. This security fix is part of an ongoing effort to improve the security of the Designer feature and is designated PMASA-2019-5. There is also an improvement for how we sanitize Git version information shown on the home page, thanks to Ali Hubail. This release includes fixes for many bugs, including: - Fixes for the "Failed to set session cookie" error which relates to the cookie name. In some cases, data stored in the cookie (such as the previously-used user account) may not be loaded from a previous phpMyAdmin cookie the first time you run version 4.9.2 - Fix for Advisor with MySQL 8.0.3 and newer - Fix PHP deprecation errors - Fix a situation where exporting users after a delete query could remove users - Fix incorrect "You do not have privileges to manipulate with the users!" warning - Fix copying a database's privileges and several other problems moving columns with MariaDB - Fix for phpMyAdmin not selecting all the values when using shift-click to select during Export There are many, many more bug fixes thanks to the efforts of our developers and other contributors. The phpMyAdmin team

1 0

PHP and PhpMyAdmin Licenses
by Ashkar Dev 22 Nov '19

22 Nov '19

Hi, can anyone answer my questions about PHP and PhpMyAdmin Licenses? Can I create web application with PHP and sell it and prevent buyer from reselling? is it legal? what the licenses is about?

3 2

Encapsulation Errors (major, very annoying)
by Frederic Steinfels 18 Nov '19

18 Nov '19

Hi When editing a trigger (and probably also stored procedures), when writing something like SET ctype=REGEXP_REPLACE(REGEXP_REPLACE(ctype,'^enum\$',''),'\$$',''); And saving it, it will show as SET ctype=REGEXP_REPLACE(REGEXP_REPLACE(ctype,'^enum$',''),'$$',''); when reopening it. When saving that and reopening it, it will show as SET ctype=REGEXP_REPLACE(REGEXP_REPLACE(ctype,'^enum(',''),')$',''); Those backslash character seem to be incorrectly handled. Thanks for fixing. I honestly wonder why nobody found this over all those years. Regards -- Frederic Steinfels F. Steinfels Hard- & Software Seestrasse 110b 8610 Uster 043 544 08 08

1 0

GuardianKey plugin to phpMyAdmin
by Gesiel Bernardes 15 Nov '19

15 Nov '19

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/ . 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

1 0

Saying Hello!
by Mohammed Rabeeh 09 Nov '19

09 Nov '19

Hello, My name is Mohammed Rabeeh. I'm a second year pursuing Computer Science and Engineering in College of Engineering, Trivandrum, India. My domain is web development both front end and back end. I've been using phpMyAdmin for a long time and I would love to contribute to it now. I'm a beginner, but I would love to learn to contribute and submit a lot of bug fixes and new features. While going through the code, I saw a lot of documentation written for the code. I'm guessing it can be auto-generated into a website or something like that. I would like to know how to do that so I'll better understand the functionality of each function. I've already taken up an issue and would like to resolve it as soon as possible. I'm hoping I'll be able to contribute a lot to phpMyAdmin. Thank You! - Rabeeh mohammdrabeeh(a)gmail.com

1 0