June 2016 - Developers - lists.phpmyadmin.net

[REQUEST] Remove chunks from profiling pie-chart
by Alec Teal 10 Jun '16

10 Jun '16

Hello again, Sorry for the double post and not using your bug tracker, I'm not on GitHub and don't know the markup, I really hope no one minds. When profiling does work (see previous email) quite often the pie-chart can be dominated by one very large chunk (usually "sending data"), it'd be great if you could "uncheck" rows from the summary table (or even the raw table) and then remove them from the summary contributions or the pie chart. Alec

2 1

[BUG REPORT]: profiling not working & cut of errors
by Alec Teal 10 Jun '16

10 Jun '16

Hello there, I've had a few problems with PMA (I'm trying to migrate from the 7-year-deprecated mysql gui tools I still run via Wine, am I alone in this?) and I've found a bug, and a minor bug. First, if you profile a select that uses a user-defined function, no profiling result is shown, there's no error or warning either, nothing. Just the result set. That's the bug. Second, when designing the user defined function that has the power to disable profiles I'd get quite a long error report if the syntax was wrong, something like: "Error in statement (ENTIRE BODY OF QUERY) at or around (bit that actually went wrong)" I had to use a mix of zoom and responsive design view to actually get to read the bit I wanted. If you could make the error box wider, or show the useful bit of information, that'd be great. While I am here, I'd really love an "explain extended" option next to explain, and also there's a new JSON format, it'd be really good if you guys allowed fields to be of a JSON type (so you can collapse and expand lists, items of lists) - you wouldn't need to interpret the actual explain format to make this useful as it's pretty self descriptive. Alec I can help if you guys can are willing to answer questions about where to find things.

2 1

Build failed in Jenkins: documentation #59
by Jenkins Daemon 10 Jun '16

10 Jun '16

1 1

Re: [phpMyAdmin Developers] Connect with SSL
by Kordován Szabolcs 09 Jun '16

09 Jun '16

Hi, Sorry for delay. I forgot the versions: Database server Server: fone2 (127.0.0.1 via TCP/IP) Server type: MySQL Server version: 5.7.12-0ubuntu1 - (Ubuntu) Protocol version: 10 User: szabolcs@localhost Server charset: UTF-8 Unicode (utf8) Web server Apache/2.4.18 (Ubuntu) Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: f59eb767fe17a6679589b5c076d9fa88d3d4eac0 $ PHP extension: mysqli curl mbstring PHP version: 7.0.4-7ubuntu2.1 openssl OpenSSL support enabled OpenSSL Library Version OpenSSL 1.0.2g-fips 1 Mar 2016 OpenSSL Header Version OpenSSL 1.0.2g-fips 1 Mar 2016 Openssl default config /usr/lib/ssl/openssl.cnf If you have to authenticate with certification you use mysqli_ssl_set(). In this case you need private key and certification. But if you want only a secure communication (like https) you don't need these. Only need mysqli_client_ssl flag to use ssl. >From mysql log: 2016-06-03T06:02:02.098148Z11604 Connect szabolcs(a)xxx.xxx.xxx.xxx on using SSL/TLS Regards, Szabolcs Date: Thu, 2 Jun 2016 09:16:40 -0400 > From: Isaac Bennetch <bennetch(a)gmail.com> > To: Developer discussion for phpMyAdmin <developers(a)phpmyadmin.net> > Subject: Re: [phpMyAdmin Developers] Connect with SSL > Message-ID: <dc965fae-89cf-26a0-d22a-c3b7fab3f561(a)gmail.com> > Content-Type: text/plain; charset=utf-8 > > Hi, thanks for your report and detailed research. Please see below... > > On 6/2/16 8:24 AM, Kordován Szabolcs wrote: > > Hi, > > > > I had a problem with secure connection to sql server. > > I use mysqli extension, I configured server['ssl'] = true. I have a user > > 'szabolcs' in sql who needs ssl. > > First I received 'mysqli_real_connect(): (HY000/1045): Access denied for > > user 'szabolcs'@'localhost' (using password: YES)'. > > That was why PMA doesn't use MYSQLI_CLIENT_SSL. I should add it to > > $client_flags. > > As far as I'm aware, PHP doesn't need MYSQLI_CLIENT_SSL when calling > mysql_ssl_set() before mysqli_real_connect(). The current documentation > doesn't reference this scenario at all, but previous versions did state > that MYSQLI_CLIENT_SSL was not required here (see, for example, [1]). > > > After this I got the following error:'mysqli_query(): SSL operation > > failed with code 1. OpenSSL Error messages: error:0607A082:digital > > envelope routines:EVP_CIPHER_CTX_set_key_length:invalid key length > > error:0607A082:digital envelope > > routines:EVP_CIPHER_CTX_set_key_length:invalid key length'. > > > > PMA uses openssel functions to encrypt values in cookie if openssl > > functions exist, other case PMA uses Crypt\AES. With Crypt\AES PMA works > > fine. > > I don't know the exact source of this problem. I think openssl functions > > have a bug. > > There was some incompatibility between MySQL and OpenSSL (see [2]), > however the error reported was a bit different. > > > Because the mysqli connection with ssl is successful After connection > > in common.inc.php $auth_plugin->storeUserCredentials() is called. This > > function stores the username and password and other parameters into > > cookie. To encrypt: > > openssl_encrypt( > > $data, > > 'AES-128-CBC', > > $secret, > > 0, > > $this->_cookie_iv > > ); > > I think the problem is that openssl_encrypt change the cipher to > > AES-128-CBC globally. It means the cipher of mysqli connection is also > > modified. This is why mysqli_query failed after encryption. > > Interesting. > > > Here is my solution: > > > > diff -ruN original/libraries/dbi/DBIMysqli.php > > working/libraries/dbi/DBIMysqli.php > > --- original/libraries/dbi/DBIMysqli.php 2016-05-25 > > 19:07:44.000000000 +0200 > > +++ working/libraries/dbi/DBIMysqli.php 2016-05-26 15:55:49.000000000 > +0200 > > @@ -152,6 +152,7 @@ > > > > /* Optionally enable SSL */ > > if ($cfg['Server']['ssl']) { > > + $client_flags |= MYSQLI_CLIENT_SSL; > > mysqli_ssl_set( > > $link, > > $cfg['Server']['ssl_key'], > > diff -ruN original/libraries/plugins/auth/AuthenticationCookie.php > > working/libraries/plugins/auth/AuthenticationCookie.php > > --- original/libraries/plugins/auth/AuthenticationCookie.php > > 2016-05-25 19:07:44.000000000 +0200 > > +++ working/libraries/plugins/auth/AuthenticationCookie.php > > 2016-05-26 15:56:27.000000000 +0200 > > @@ -661,6 +661,7 @@ > > */ > > public static function useOpenSSL() > > { > > + return false; > > This also makes me think about some sort of OpenSSL problem. > > > return ( > > function_exists('openssl_encrypt') > > && function_exists('openssl_decrypt') > > diff -ruN original/RELEASE-DATE-4.6.1 working/RELEASE-DATE-4.6.1 > > --- original/RELEASE-DATE-4.6.1 1970-01-01 01:00:00.000000000 +0100 > > +++ working/RELEASE-DATE-4.6.1 2016-05-02 17:24:00.000000000 +0200 > > @@ -0,0 +1 @@ > > +Mon May 2 21:23:35 UTC 2016 > > > > Regards, > > Szabolcs > > > > > > _______________________________________________ > > Developers mailing list > > Developers(a)phpmyadmin.net > > https://lists.phpmyadmin.net/mailman/listinfo/developers > > >From phpinfo() could you please provide your OpenSSL version? Mine is > 1.0.1k. > > >From the main page of phpMyAdmin, could you please provide "Database > client version", "PHP extension", and "PHP version" information? (Mine > is libmysql - 5.5.49 / mysqli curl mbstring / 5.6.20-0+deb8u1 ) > > Regards, > Isaac > > > 1 - > > http://board.phpbuilder.com/showthread.php?10383611-Connecting-PHP-and-MYSQ… > 2 - https://bugs.mysql.com/bug.php?id=64870 > > >

2 4

Build failed in Jenkins: phpMyAdmin-continuous #12024
by Jenkins Daemon 09 Jun '16

09 Jun '16

See <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/12024/changes> Changes: [weblate] Translated using Weblate (Hungarian) [Michal Čihař] Include phpMyAdmin version in JSON dump [Michal Čihař] Add test for possible rounding issues ------------------------------------------ [...truncated 376 lines...] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 38) PMA_SeleniumExportTest::testServerImport with data set #2 ('JSON', array('[{"id":"1","val":"2"}]')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 39) PMA_SeleniumExportTest::testDbExport with data set #0 ('CSV', array('"1","2"')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 40) PMA_SeleniumExportTest::testDbExport with data set #1 ('SQL', array('CREATE TABLE IF NOT EXISTS `t...table`', 'INSERT INTO `test_table` (`id...VALUES', '(1, 2);')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 41) PMA_SeleniumExportTest::testDbExport with data set #2 ('JSON', array('[{"id":"1","val":"2"}]')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 42) PMA_SeleniumExportTest::testTableExport with data set #0 ('CSV', array('"1","2"')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 43) PMA_SeleniumExportTest::testTableExport with data set #1 ('SQL', array('CREATE TABLE IF NOT EXISTS `t...table`', 'INSERT INTO `test_table` (`id...VALUES', '(1, 2);')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 44) PMA_SeleniumExportTest::testTableExport with data set #2 ('JSON', array('[{"id":"1","val":"2"}]')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 45) PMA_SeleniumImportTest::testServerImport [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 46) PMA_SeleniumImportTest::testDbImport [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 47) PMA_SeleniumImportTest::testTableImport [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 48) PMA_SeleniumLoginTest::testSuccessfulLogin [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 49) PMA_SeleniumLoginTest::testLoginWithWrongPassword [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 50) PMA_SeleniumNormalizationTest::testNormalizationTo1NF [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 51) PMA_SeleniumPrivilegesTest::testChangePassword [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 52) PMA_SeleniumSettingsTest::testHideDatabase [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 53) PMA_SeleniumSettingsTest::testSettingsTabsAreDisplayed [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 54) PMA_SeleniumSettingsTest::testHideLogo [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 55) PMA_SeleniumTableBrowseTest::testSortRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 56) PMA_SeleniumTableBrowseTest::testChangeRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 57) PMA_SeleniumTableBrowseTest::testChangeRecordsByDoubleClick [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 58) PMA_SeleniumTableBrowseTest::testCopyRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 59) PMA_SeleniumTableBrowseTest::testSearchRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 60) PMA_SeleniumTableBrowseTest::testDeleteRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 61) PMA_SeleniumTableCreateTest::testCreateTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] 62) PMA_SeleniumTableInsertTest::testAddData [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:29 [exec] [exec] 63) PMA_SeleniumTableOperationsTest::testChangeTableOrder [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 64) PMA_SeleniumTableOperationsTest::testMoveTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 65) PMA_SeleniumTableOperationsTest::testRenameTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 66) PMA_SeleniumTableOperationsTest::testCopyTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 67) PMA_SeleniumTableOperationsTest::testTruncateTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 68) PMA_SeleniumTableOperationsTest::testDropTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 69) PMA_SeleniumTableStructureTest::testAddColumn [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 70) PMA_SeleniumTableStructureTest::testChangeColumn [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 71) PMA_SeleniumTableStructureTest::testDropColumns [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 72) PMA_SeleniumTrackingTest::testTrackingData [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 73) PMA_SeleniumTrackingTest::testDeactivateTracking [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 74) PMA_SeleniumTrackingTest::testDropTracking [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 75) PMA_SeleniumTrackingTest::testStructureSnapshot [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 76) PMA_SeleniumXSSTest::testQueryTabWithNullValue [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:168 [exec] [exec] FAILURES! [exec] Tests: 2185, Assertions: 6022, Failures: 1, Skipped: 76, Incomplete: 7, Risky: 3. BUILD FAILED <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build.xml>:33: exec returned: 1 Total time: 52 seconds Build step 'Invoke Ant' marked build as failure [CHECKSTYLE] Skipping publisher since build result is FAILURE [JSLINT] Skipping publisher since build result is FAILURE [DRY] Collecting duplicate code analysis files... [DRY] Finding all files that match the pattern build/logs/pmd-cpd.xml [DRY] Computing warning deltas based on reference build #12023 [TASKS] Skipping publisher since build result is FAILURE [ANALYSIS-COLLECTOR] Computing warning deltas based on reference build #12023 Recording plot data [xUnit] [INFO] - Starting to record. [xUnit] [INFO] - Processing PHPUnit-3.x (default) [xUnit] [INFO] - [PHPUnit-3.x (default)] - 1 test report file(s) were found with the pattern 'build/logs/junit.xml' relative to '<https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/'> for the testing framework 'PHPUnit-3.x (default)'. [xUnit] [INFO] - Check 'Failed Tests' threshold. [xUnit] [INFO] - Check 'Skipped Tests' threshold. [xUnit] [INFO] - Setting the build status to FAILURE [xUnit] [INFO] - Stopping recording.

1 1

Seeking a phpMyAdmin Developer (one year contract position)
by Isaac Bennetch 09 Jun '16

09 Jun '16

Overview The phpMyAdmin Project is looking for a full-time or part-time developer to assist in development, including bug fixing and refactoring. Work plan The ideal candidate will dynamically balance their workload based on outstanding issues and priority, but is anticipated to break down to these percentages (in priority order of what's most important to least important): Security maintenance (5%) Bug fixing and issue assessment (45%) Code base improvement like refactoring and writing unit tests (45%) Implementation of new features (5%) Work conditions The Developer shall publish a weekly blog post about his/her work to the phpMyAdmin community. The Developer shall send a monthly invoice to the Software Freedom Conservancy for the work done during that month. All work produced by the Developer is to be licensed under "GPLv2 or later". This is an independent contractor position: the Developer will be responsible for his/her own equipment and expenses. The Candidate The candidate will be able to demonstrate a very good knowledge of phpMyAdmin's code base. In addition, we expect excellent skills in all of the technologies used by phpMyAdmin (PHP, HTML, JavaScript, jQuery, CSS, MySQL) and excellent communication skills. Applying Candidates should submit their proposal (including their CV, availability, and financial terms) to: pmadeveloper(a)sfconservancy.org. The deadline for this initial round of proposals is 2016-06-30.

1 0

"Weird table size" reported in 4.6.1
by Isaac Bennetch 08 Jun '16

08 Jun '16

Hi, over at Stack Overflow a user has a strange table size reported (2.1,000,000,000,000,000,888 KiB; after running REPAIR one other table's similar problem was fixed). This seems odd, our rounding of this number should not produce such a strange number. Has anyone seen anything similar to this? One table affected for one user doesn't make a very good bug report, but if there's a shortcoming we of course want to try to fix it. Any thoughts?

2 3

IRC meeting on Wednesday
by Isaac Bennetch 08 Jun '16

08 Jun '16

Hello, just a reminder that we have the scheduled monthly phpMyAdmin developer meeting on Wednesday. The agenda is quite light, so feel free to add some more discussion points[1] See you then, Isaac 1 - https://github.com/phpmyadmin/phpmyadmin/wiki/2016-06_Meeting

3 8

EOL of security updates
by Isaac Bennetch 08 Jun '16

08 Jun '16

Since the 4.4 branch is scheduled to end security-support status in October, around the first of July (three months prior to the end of support), I plan to send out an announcement like the one below. We at the phpMyAdmin project wish to remind you that the 4.4 branch will enter end-of-life and receive no further updates or support after October 1, 2016. We recommend upgrading promptly to avoid any interruption to security support.

2 1

Build failed in Jenkins: documentation #53
by Jenkins Daemon 04 Jun '16

04 Jun '16

See <https://ci.phpmyadmin.net/job/documentation/53/changes> Changes: [weblate] Translated using Weblate (Chinese (China)) [weblate] Translated using Weblate (German) ------------------------------------------ [...truncated 4 lines...] Fetching changes from the remote Git repository > git config remote.origin.url https://github.com/phpmyadmin/phpmyadmin.git # timeout=10 Fetching upstream changes from https://github.com/phpmyadmin/phpmyadmin.git > git --version # timeout=10 > git -c core.askpass=true fetch --tags --progress https://github.com/phpmyadmin/phpmyadmin.git +refs/heads/*:refs/remotes/origin/* > git rev-parse origin/master^{commit} # timeout=10 Checking out Revision 2d0822d672537fec7e433e63f770592a4527953a (origin/master) > git config core.sparsecheckout # timeout=10 > git checkout -f 2d0822d672537fec7e433e63f770592a4527953a > git rev-list 2dc895368f8c48df01552680b64efe46d12c3274 # timeout=10 [workspace] $ /bin/sh -xe /tmp/hudson8343426306418457481.sh + make -C doc linkcheck make: Entering directory '<https://ci.phpmyadmin.net/job/documentation/ws/doc'> sphinx-build -b linkcheck -d ./doctrees . ./linkcheck Running Sphinx v1.4.1 loading pickled environment... done building [mo]: targets for 0 po files that are out of date building [linkcheck]: targets for 19 source files that are out of date updating environment: 0 added, 0 changed, 0 removed looking for now-outdated files... none found preparing documents... done writing output... [ 5%] bookmarks writing output... [ 10%] charts (line 25) ok http://www.jqplot.com/ writing output... [ 15%] config (line 807) ok https://dev.mysql.com/doc/refman/5.7/en/grant.html (line 247) ok https://dev.mysql.com/doc/refman/5.7/en/connecting.html (line 262) ok https://dev.mysql.com/doc/refman/5.7/en/connecting.html (line 227) ok https://dev.mysql.com/doc/refman/5.7/en/connecting.html (line 1152) ok https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html (line 595) broken https://php.net/manual/en/reference.pcre.pattern.syntax.php - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 1433) broken https://php.net/manual/en/function.mysql-pconnect.php - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 1435) broken https://php.net/manual/en/mysqli.persistconns.php - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 1429) broken https://php.net/manual/en/features.persistent-connections.php - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 1674) ok http://www.google.com/recaptcha/intro/ (line 1684) ok http://www.google.com/recaptcha/intro/ (line 3025) ok https://www.phpmyadmin.net/try (line 2386) redirect http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.ht… - with Found to http://www.gnu.org/savannah-checkouts/gnu/libiconv/documentation/libiconv-1… (line 1472) broken https://php.net/session_save_path - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 1617) broken https://php.net/manual/en/session.configuration.php#ini.session.gc-maxlifet… - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 2339) ok https://dev.mysql.com/doc/refman/5.7/en/charset-charsets.html writing output... [ 21%] copyright (line 28) ok http://www.gnu.org/licenses/ writing output... [ 26%] credits (line 183) ok http://www.fpdf.org/ (line 208) ok http://www.tcpdf.org (line 183) ok http://www.tcpdf.org/ (line 183) ok https://acko.net/blog/ufpdf-unicode-utf-8-extension-for-fpdf/ (line 141) ok https://sourceforge.net/projects/phpmysqlformgen/ writing output... [ 31%] developers (line 10) ok https://www.phpmyadmin.net/contribute/ writing output... [ 36%] faq (line 6) ok https://www.phpmyadmin.net/docs/ (line 192) ok https://www.phpmyadmin.net/downloads/ (line 192) ok http://www.mysql.com/ (line 175) ok http://www.ozerov.de/bigdump/ (line 131) ok https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html (line 196) ok http://mariadb.org/ (line 203) ok https://dev.mysql.com/doc/refman/5.7/en/old-client.html (line 323) ok https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html (line 460) ok http://httpd.apache.org (line 46) broken https://bugs.php.net/bug.php?id=12061 - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 203) broken https://php.net/mysqli - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 541) ok https://suhosin.org/stories/configuration.html#suhosin-post-max-vars (line 539) ok https://suhosin.org/stories/configuration.html#suhosin-request-max-vars (line 543) ok https://suhosin.org/stories/configuration.html#suhosin-request-max-array-in… (line 545) ok https://suhosin.org/stories/configuration.html#suhosin-post-max-array-index… (line 547) ok https://suhosin.org/stories/configuration.html#suhosin-request-max-totalnam… (line 448) ok https://tools.ietf.org/html/rfc2616.html (line 549) ok https://suhosin.org/stories/configuration.html#suhosin-post-max-totalname-l… (line 362) broken https://bugs.php.net/bug.php?id=21079 - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 573) ok http://httpd.apache.org/docs/2.4/mod/mod_ssl.html (line 551) ok https://suhosin.org/stories/configuration.html#suhosin-get-max-value-length (line 553) ok https://suhosin.org/stories/configuration.html#suhosin-sql-bailout-on-error (line 602) ok http://httpd.apache.org/docs/2.2/mod/mod_proxy.html (line 555) ok https://suhosin.org/stories/configuration.html#logging-configuration (line 829) ok https://suhosin.org/stories/faq.html (line 829) ok https://suhosin.org/stories/index.html (line 840) ok http://php.net/manual/en/book.apc.php (line 840) ok http://pecl.php.net/package/uploadprogress (line 734) ok https://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html (line 853) ok https://tools.ietf.org/html/rfc1867.html (line 960) ok https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html (line 820) broken https://bugs.php.net/bug.php?id=31134 - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 886) ok https://bugs.mysql.com/bug.php?id=21704 (line 831) broken https://bugs.php.net/bug.php?id=39842 - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 960) ok https://sourceforge.net/p/phpmyadmin/bugs/1013/ (line 1550) ok https://dev.mysql.com/doc/refman/5.7/en/silent-column-changes.html (line 1578) ok https://dev.mysql.com/doc/refman/5.7/en/drop-table.html (line 1599) ok https://dev.mysql.com/doc/refman/5.7/en/insert-delayed.html (line 1256) ok https://bugzilla.mozilla.org/ (line 1817) ok http://wiki.phpmyadmin.net/pma/Charts (line 2105) ok https://www.phpmyadmin.net/security (line 1601) ok https://dev.mysql.com/doc/refman/5.7/en/insert.html (line 2114) ok https://hosted.weblate.org/projects/phpmyadmin/ (line 2105) ok https://github.com/phpmyadmin/phpmyadmin/issues (line 1695) ok https://bugs.mysql.com/bug.php?id=179 (line 2142) ok https://www.phpmyadmin.net/security/ (line 2114) ok https://www.phpmyadmin.net/translate/ (line 2192) ok https://sites.google.com/site/bughunteruniversity/nonvuln/csv-excel-formula… (line 1763) broken https://php.net/strftime - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> writing output... [ 42%] glossary (line 38) ok https://en.wikipedia.org/wiki/CGI (line 13) ok https://en.wikipedia.org/wiki/.htaccess (line 31) ok https://en.wikipedia.org/wiki/Bzip2 (line 26) ok https://en.wikipedia.org/wiki/Web_browser (line 21) ok https://en.wikipedia.org/wiki/Blowfish_(cipher) (line 58) ok https://en.wikipedia.org/wiki/HTTP_cookie (line 43) ok https://en.wikipedia.org/wiki/Changelog (line 48) ok https://en.wikipedia.org/wiki/Client_(computing) (line 63) ok https://en.wikipedia.org/wiki/Comma-separated_values (line 53) ok https://en.wikipedia.org/wiki/Column_(database) (line 71) ok https://en.wikipedia.org/wiki/Database (line 85) ok https://en.wikipedia.org/wiki/FAQ (line 90) ok https://en.wikipedia.org/wiki/Field_(computer_science) (line 79) ok https://en.wikipedia.org/wiki/Software_extension (line 97) ok https://en.wikipedia.org/wiki/Foreign_key (line 107) ok https://en.wikipedia.org/wiki/GD_Graphics_Library (line 120) ok https://en.wikipedia.org/wiki/Host (line 125) ok https://en.wikipedia.org/wiki/Hostname (line 115) ok https://en.wikipedia.org/wiki/Gzip (line 131) ok https://en.wikipedia.org/wiki/HyperText_Transfer_Protocol (line 145) ok https://en.wikipedia.org/wiki/Internet_Information_Services (line 150) ok https://en.wikipedia.org/wiki/Index_(database) (line 157) ok https://en.wikipedia.org/wiki/Internet_Protocol (line 136) ok https://en.wikipedia.org/wiki/Https:_URI_scheme (line 169) ok https://en.wikipedia.org/wiki/IPv6 (line 188) ok https://en.wikipedia.org/wiki/JPEG (line 180) ok https://en.wikipedia.org/wiki/ISP (line 174) ok https://en.wikipedia.org/wiki/ISAPI (line 199) ok https://en.wikipedia.org/wiki/LaTeX (line 204) ok https://en.wikipedia.org/wiki/Mac (line 209) ok https://en.wikipedia.org/wiki/Mac_OS_X (line 162) ok https://en.wikipedia.org/wiki/IP_Address (line 221) ok https://en.wikipedia.org/wiki/MCrypt (line 232) ok https://en.wikipedia.org/wiki/MIME (line 237) ok https://en.wikipedia.org/wiki/Apache_HTTP_Server (line 246) ok https://en.wikipedia.org/wiki/MySQL (line 261) ok https://en.wikipedia.org/wiki/OpenDocument (line 266) ok https://en.wikipedia.org/wiki/OS_X (line 273) ok https://en.wikipedia.org/wiki/Portable_Document_Format (line 278) ok http://pear.php.net/ (line 216) broken https://php.net/manual/en/book.mbstring.php - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 226) broken https://php.net/mcrypt - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 292) ok https://en.wikipedia.org/wiki/PHP (line 251) broken https://php.net/manual/en/book.mysqli.php - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 256) broken https://php.net/manual/en/book.mysql.php - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 321) ok https://en.wikipedia.org/wiki/Request_for_Comments (line 297) ok https://en.wikipedia.org/wiki/Port_(computing) (line 336) ok https://en.wikipedia.org/wiki/Server_(computing) (line 352) ok https://en.wikipedia.org/wiki/Unix_domain_socket (line 331) ok https://en.wikipedia.org/wiki/Row_(database) (line 358) ok https://en.wikipedia.org/wiki/Secure_Sockets_Layer (line 363) ok https://en.wikipedia.org/wiki/Stored_procedure (line 368) ok https://en.wikipedia.org/wiki/SQL (line 376) ok https://en.wikipedia.org/wiki/Table_(database) (line 387) ok https://en.wikipedia.org/wiki/TCP (line 326) ok https://tools.ietf.org/html/rfc1952.html (line 397) ok https://en.wikipedia.org/wiki/Database_trigger (line 284) broken https://php.net/pcre - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 381) ok https://en.wikipedia.org/wiki/Tar_(file_format) (line 419) ok https://en.wikipedia.org/wiki/Webserver (line 347) ok https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html (line 414) ok https://en.wikipedia.org/wiki/URL (line 426) ok https://en.wikipedia.org/wiki/XML (line 431) ok https://en.wikipedia.org/wiki/ZIP_(file_format) (line 436) ok https://en.wikipedia.org/wiki/Zlib writing output... [ 47%] import_export (line 125) ok https://en.wikipedia.org/wiki/NHibernate (line 160) ok https://www.ctan.org/ (line 200) ok http://odf-converter.sourceforge.net/ (line 160) ok https://www.ctan.org/tex/ (line 273) ok http://www.yaml.org (line 237) ok https://dev.mysql.com/doc/refman/5.7/en/packet-too-large.html (line 258) ok https://texy.info/ (line 258) ok https://texy.info/en/try/4q5we (line 253) ok http://www.scriptalicious.com/blog/2009/04/complete-inserts-or-extended-ins… writing output... [ 52%] index writing output... [ 57%] intro (line 47) ok https://www.phpmyadmin.net/translations/ writing output... [ 63%] other (line 21) ok https://cihar.com/publications/linuxsoft/ (line 33) ok http://php-myadmin.ru/ (line 26) ok http://garv.in/tops/texte/mimetutorial (line 27) ok http://www.php-editors.com/articles/sql_phpmyadmin.php (line 28) ok http://www.iis-aid.com/articles/how_to_guides/install_and_configure_phpmyad… writing output... [ 68%] privileges writing output... [ 73%] relations writing output... [ 78%] require (line 58) ok https://jquery.com/browser-support/ (line 28) broken https://php.net/libxml - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 31) broken https://php.net/openssl - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 34) broken https://php.net/curl - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 23) broken https://php.net/openssl - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> writing output... [ 84%] setup (line 85) ok http://fedoraproject.org/wiki/EPEL (line 85) ok http://fedoraproject.org/wiki/EPEL/FAQ#howtouse (line 53) ok https://launchpad.net/~nijel/+archive/ubuntu/phpmyadmin (line 102) ok https://en.wikipedia.org/wiki/List_of_AMP_packages (line 131) ok https://getcomposer.org/ (line 114) ok https://getcomposer.org/ (line 131) ok https://packagist.org/ (line 135) ok https://www.phpmyadmin.net/packages.json (line 98) ok https://www.apachefriends.org/index.html (line 408) ok https://www.phpmyadmin.net/ (line 225) ok https://github.com/phpmyadmin/docker (line 408) ok https://demo.phpmyadmin.net/master/setup/ (line 145) ok https://hub.docker.com/r/phpmyadmin/phpmyadmin/ (line 436) ok https://keybase.io/ibennetch (line 427) ok https://keybase.io/lem9 (line 454) ok https://files.phpmyadmin.net/phpmyadmin.keyring (line 485) ok https://www.gnupg.org/gph/en/manual.html#AEN335 (line 485) ok http://pgp.cs.uu.nl/mk_path.cgi?FROM=00411886&TO=8259BD92 (line 41) ok http://anonscm.debian.org/cgit/collab-maint/phpmyadmin.git/tree/debian/READ… (line 874) ok https://github.com/phpmyadmin/phpmyadmin/issues/11922 (line 880) ok https://github.com/phpmyadmin/phpmyadmin/issues/11898 (line 47) ok http://software.opensuse.org/package/phpMyAdmin (line 821) broken https://php.net/manual/en/errorfunc.configuration.php#ini.display-errors - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> writing output... [ 89%] transformations (line 134) broken https://php.net/mysql_fetch_field - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> (line 134) broken https://php.net/mysql_fetch_field - <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)> writing output... [ 94%] user writing output... [100%] vendors build finished with problems. Makefile:179: recipe for target 'linkcheck' failed make: *** [linkcheck] Error 1 make: Leaving directory '<https://ci.phpmyadmin.net/job/documentation/ws/doc'> Build step 'Execute shell' marked build as failure [WARNINGS] Skipping publisher since build result is FAILURE

1 1