GSoC 2015 : Weekly Report #10 : RFE #1396 & others

Week #10

Task(s) completedNone

Tasks worked upon:

RFE #1396 : Support MySQL 5.6 SHA256 secure password

Scheduled Deadline: 9th August

Completed on: NA

Details:

1. I started working on the last feature on the timeline i.e. RFE #1396 : Support MySQL 5.6 SHA256 secure password

I referred extensively to the documentation. Here the versions of MySQL were quite important as this area of ALTER USER syntax[0], CREATE USER syntax[1] and the newly added sha256 authentication plugin are some of the major changes that have been done in the recent versions.

So, an extra bit of care has to be taken that phpMyAdmin shows only the options which will work with the current version of MySQL server that the user is using.

But the documentation and good head-starts by Isaac, my mentor, helped a lot and I have implemented the changes required here[2]. You can refer to the description of the PR for more details regarding what changes have been made. Isaac is currently reviewing the behavior on various versions of MySQL server so that we can ensure that this does not break the normal usage with previous versions.

2. I realized that we display a notice below on server_privileges.php i.e. User Accounts Tab, saying that phpMyAdmin takes the privileges shown on that page directly from the `mysql` db. So for this changed privileges to take effect, one has to run the FLUSH PRIVILEGES query and we provide a link which runs this query.

But I realized that query is obviously going to fail if the user does not have the RELOAD privilege[3]. So, we should make the visibility of this notice conditional, so I and Isaac discussed and decided to go ahead with this. I have made the PR with related changes here [4].

Also, while I was working on RFE #1396 and waiting for the Travis CI’s build reports, I realized that even though they were not failing but they were showing some notices about ‘Not supported query’. I immediately realized that this were introduced in commit at [5] and fixed the problem with PR at [6].

Links:
​[0] : https://dev.mysql.com/doc/refman/5.7/en/alter-user.html
[1] : https://dev.mysql.com/doc/refman/5.7/en/create-user.html
[2] : https://dev.mysql.com/doc/refman/5.6/en/sha256-authentication-plugin.html
[3] : https://dev.mysql.com/doc/refman/5.6/en/privileges-provided.html#priv_reload
[4] : https://github.com/phpmyadmin/phpmyadmin/pull/1797
[5] : https://github.com/phpmyadmin/phpmyadmin/commit/d014dbcc293118e2dd43ba2d36465b745537d5f8
[6] : https://github.com/phpmyadmin/phpmyadmin/pull/1796

Advertisements

About Deven Bansod

I am a final year undergraduate student pursuing B.E.(Hons.) Computer Science Engg. + M.Sc.(Hons.) Economics(Dual Degree) at BITS Pilani, Pilani (India). I am interested in and have been contributing to development of PHP-based Open Source organisations. More recently, I have been contributing to phpMyAdmin, a web interface to MySQL, written in PHP.

Posted on July 20, 2015, in GSoC 2015, phpMyAdmin, Weekly Reports and tagged , , , . Bookmark the permalink. 2 Comments.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: