Michal Čihař - Blog Archives for phpMyAdmin

Weblate 3.0 has been released today. It contains brand new access control module and 61 fixed isssues.

Full list of changes:

• Rewritten access control.
• Several code cleanups that lead to moved and renamed modules.
• New addon for automatic component discovery.
• The import_project management command has now slightly different parameters.
• Added basic support for Windows RC files.
• New addon to store contributor names in PO file headers.
• The per component hook scripts are removed, use addons instead.
• Add support for collecting contributor agreements.
• Access control changes are now tracked in history.
• New addon to ensure all components in a project have same translations.
• Support for more variables in commit message templates.
• Add support for providing additional textual context.

If you are upgrading from older version, please follow our upgrading instructions, the upgrade is more complex this time.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Last week was pretty quiet. The most interesting part was licensing issue with two factor authentication library we use. In the end the library was relicensed to MIT, what makes it compatible with pretty much anything.

I've spent some time on the Debian packages as well, I'm getting closer to make them work again, but there are still some issues to overcome.

Handled issues:

• #14074 Replace google2fa library
• #14046 Restore SQL query after session expire

Last week was a bit quiet, I've spend some time on our infrastructure and doing reviews. There is still big pending task to update Debian packages and I will hopefully get to it this week.

Handled issues:

• #14065 Can not connect to remote server without manual modification in codebase
• #61 Add CAA DNS Record for PMA websites when possible
• #179 Documentation improvements

Last week I've continued on reviewing incoming pull requests and issues without coding much myself. It seems that amount of incoming issues is still quite big.

Handled issues:

• #14005 Supported versions
• #14048 Fixes adding new column in query builder, #14047
• #13940 arg_separator breaks PMA: Call to a member function getCurrentUserAndHost
• #13927 NEED HELP PHPMyAdmin compatibility with PHP 7.1
• #13984 Unable to logout of phpMyAdmin-4.6.6-5 on Ubuntu
• #14003 Issue saving design
• #14047 Add column button in query builder doesn't work
• #14032 Warning in ./libraries/sql.lib.php#601
• #14034 Designer add table
• #14035 Fix Broken Designer Add Table
• #13887 4.7.7: PHP Warning: Unknown: Input variables exceeded 1000. To increase the limit change max_input_vars in php.ini.

Last week was mostly spent on reviewing pull requests. There is quite a lot them coming in and I always feel bad when we're not able to review incoming code in timely manner, but unfortunately it happens time to time.

Handled issues:

• #13892 Fix charset error when creating/editing routines; bug #13889
• #14036 Fix broken sort
• #14006 Translated using Weblate (Filipino)
• #13964 Warning: hash_equals(): Expected known_string to be a string, null given
• #14021 fix maintenance operations
• #14022 Max height not set for console
• #14024 Set console max height, issue #14022
• #13889 Create/Edit routine charset bug
• #150 Security release 4.7.8 missing on docker hub

Last week was mostly spent on fixing issues with translations and improving our Docker container. That is now based on official PHP FPM image, so it will always get latest stable PHP instead of the one shipped by Alpine.

Besides that there was small, but important change in the motranslator library which no longer sets system locale (as it really has no good reason to do that). This change lead to releasing new major version of the library as it might need code changes for users who relied on this (what was the phpMyAdmin case).

Handled issues:

• #13996 Translated using Weblate (Filipino)
• #144 Use upstream PHP FPM Alpine Docker image
• #147 502 error on logout under a load-balancer
• #24 Number format may be changed inadvertently

Last week was mostly spent on our infrastructure - I've migrated all virtual machines from old server to new one. This went pretty smoothly with about one hour delay during the migration. Everything now should work just fine and with considerably increased performance.

Handled issues:

• #13938 Warning in PHP 7.2
• #13939 Warning in PHP 7.2
• #13917 Force PHP platform in composer to oldest supported version
• #13831 PHP 5 / 7 compatibility

Last week was equally spent on issues and infrastructure. There is quite serious regression in the 4.7.7 release which needs to be fixed (so far just the issue has been identified). In the same time our server is having hardware problems and we're preparing to migrate to new one (if everything goes well, the migration will be completed by the time you read this).

Handled issues:

• #13890 open in new tab on edit query dont't work on 4.7.7
• #13913 Distinct values -> No database selected
• #13885 create_release should only generate signatures for the current release
• #13907 4.7.7 -- clicking column title to sort results opens "insert" form.
• #13886 Upload rate limit error in manage.py
• #13910 fix #13712 Doesn't default to primary key when creating relations
• #13712 Doesn't default to primary key when creating relations
• #13758 single-sign-on: mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given
• #13914 Settings reset prevents login and causes PHP Warnings

First week of 2018 was a bit less intense on the code fixing side, but I've done some work on our infrastructure preparing for migration to the new server, which should be available as soon as Conservancy approves payments for it.

The new server will be located at Hetzner and you can check more details on the selection process in our wiki. The current server has been used for almost 10 years and is really showing it's age.

Handled issues:

• #13828 Two factor: doesn't ask for second factor
• #145 Update to Alpine 3.7

Last week before Christmas was pretty calm, I've mostly spent time on fixing our Selenium tests which again showed a bit of instability, what should be hopefully addressed now.

Handled issues:

• #13866 Invalid links containing SQL query
• #141 Docker phpmyadmin after login: 504 Gateway Time-out