Categories
Uncategorized

phpMyAdmin 4.2.0 is released.

同一記事の日本語版

   phpMyAdmin 4.2.0 is released. Here is the ChangeLog. I’ve updated.

   I downloaded a phpMyAdmin-4.2.0-english.zip, extracted it, copied my old config.inc.php to the phpmyadmin folder made by extracting, and uploaded all of them to the server (See “To create a Wamp-like Web Server in Windows7-#3.“).

   By the way, when I compared the new config.sample.inc.php with my old one(=Ver.4.1.x), I found two lines were lost and seven lines were added.
   The lost lines.
    At /* First server */ area
     /* Select mysql if your server does not have mysqli */
     $cfg[‘Servers’][$i][‘extension’] = ‘mysqli’;
   Does this mean they don’t support mysql modules anymore? (I noticed ‘Added warning about the mysql extension being deprecated and removed the extension directive’ in the ChangeLog.)

   The added lines.
    At /* Storage database and tables */ area
     // $cfg[‘Servers’][$i][‘favorite’] = ‘pma__favorite’;
     // $cfg[‘Servers’][$i][‘savedsearches’] = ‘pma__savedsearches’;

    As a new parameter of the configuration
     /**
     * Whether to display icons or text or both icons and text in table row
     * action segment. Value can be either of ‘icons’, ‘text’ or ‘both’.
     */
     //$cfg[‘RowActionType’] = ‘both’;

   So, when I logged on the new phphmyadmin at the first time, I got “The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.”.

   By a clicking, I got the next three alerts.

     $cfg[‘Servers’][$i][‘savedsearches’] … not OK [ Documentation ]
     Saving Query-By-Example searches: Disabled

   I had instructions, too.

     Quick steps to setup advanced features:

     Create the needed tables with the examples/create_tables.sql.
     Create a pma user and give access to these tables.
     Enable advanced features in configuration file (config.inc.php), for example by starting from
     config.sample.inc.php.
     Re-login to phpMyAdmin to load the updated configuration file.

   To create the tables with the examples/create_tables.sql or by your hand, it is your choice. Further information about this, see “Configuration storage“. As I already had the pma user, I created the two tables manually. Then, I edited nine lines above in my config.inc.php, and removed “//” from the head of the next lines.
     $cfg[‘Servers’][$i][‘favorite’] = ‘pma__favorite’;
     $cfg[‘Servers’][$i][‘savedsearches’] = ‘pma__savedsearches’;

   I re-logined to phpMyAdmin to load the updated configuration file. Mission complete.

Categories
WordPress

WordPress3.9.1 Background Updates.

同一記事の日本語版
Update information      Edit

   This morning I had a update message about WordPress 3.9.1 by an email. It is a minor maintenance release. But it includes 34 bug fixes and they say the fixes are very related to multisite networks.

   List of Files Revised

readme.html
wp-admin/css/edit.css
wp-admin/css/forms-rtl.css
wp-admin/css/login-rtl.min.css
wp-admin/css/admin-menu-rtl.css
wp-admin/css/wp-admin-rtl.min.css
wp-admin/css/edit-rtl.css
wp-admin/css/forms.css
wp-admin/css/admin-menu.css
wp-admin/css/login.min.css
wp-admin/css/wp-admin.min.css
wp-admin/about.php
wp-admin/user/menu.php
wp-admin/includes/ajax-actions.php
wp-admin/js/post.min.js
wp-admin/js/customize-controls.min.js
wp-admin/js/post.js
wp-admin/js/customize-controls.js
wp-admin/custom-header.php
wp-admin/credits.php
wp-admin/freedoms.php
wp-includes/ms-settings.php
wp-includes/class-wp-editor.php
wp-includes/media.php
wp-includes/js/shortcode.min.js
wp-includes/js/customize-views.js
wp-includes/js/media-views.min.js
wp-includes/js/tinymce/plugins/wpview/plugin.js
wp-includes/js/tinymce/plugins/wpview/plugin.min.js
wp-includes/js/tinymce/plugins/wordpress/plugin.js
wp-includes/js/tinymce/plugins/wordpress/plugin.min.js
wp-includes/js/tinymce/plugins/wpeditimage/plugin.js
wp-includes/js/tinymce/plugins/wpeditimage/plugin.min.js
wp-includes/js/tinymce/plugins/wplink/plugin.min.js
wp-includes/js/tinymce/plugins/wplink/plugin.js
wp-includes/js/tinymce/wp-tinymce.js.gz
wp-includes/js/customize-models.js
wp-includes/js/mce-view.js
wp-includes/js/mediaelement/wp-playlist.js
wp-includes/js/mediaelement/wp-mediaelement.css
wp-includes/js/media-audiovideo.min.js
wp-includes/js/shortcode.js
wp-includes/js/media-views.js
wp-includes/js/customize-views.min.js
wp-includes/js/media-audiovideo.js
wp-includes/js/customize-models.min.js
wp-includes/js/mce-view.min.js
wp-includes/version.php
wp-includes/default-widgets.php
wp-includes/script-loader.php
wp-includes/media-template.php
wp-includes/ms-load.php
wp-includes/css/editor-rtl.css
wp-includes/css/editor.css
wp-includes/css/media-views-rtl.min.css
wp-includes/css/media-views.min.css
wp-includes/css/editor-rtl.min.css
wp-includes/css/editor.min.css
wp-includes/css/media-views-rtl.css
wp-includes/css/media-views.css
wp-includes/widgets.php

Edit:
   After writing the post, I checked the new files out. I am very surprised that I found out 165 files removed. Most of them are kinds of css or js. They includes a lot of files related to TinyMCE. I heard several issues of the visual editor on WordPress 3.9. The troubles were maybe related to TinyMCE. I remember TinyMCE 4.0 merged into WordPress Core announce on this January. I think this probably influenced the behavior of the visual editor, so they had this acts. Do you think so, too?
      List of Files Removed

Categories
translation

The translation “Seijō no Ran (青条の蘭)”-#7.

   I’ve posted the chapter 3, “Seijō no Ran (青条の蘭)” after a long interval.

   I have added some new explanations to the notes.

Categories
Windows

Updating to PHP5.5.12.

同一記事の日本語版

   They released PHP5.5.12 on Apr-30 21:11:32UTC. So, I updated my PHP from 5.5.11 to 5.5.12 yesterday.

   According to ChangeLog, this includes the fix for CVE-2014-0185. At this time, its Description is still ** RESERVED ** on the page but it is related with PHP-FPM and I think it was first reported by Christian Hoffmann. You can find its detail at php-fpm: privilege escalation due to insecure default config. Otherwise php5embed.lib comes back.

   The php.ini-production has two small changes about the comment lines. As the official PHP binary includes php5apache2_4.dll, I extract the zip archive and replace all PHP5.5.11 files with all PHP5.5.12 files except my php.ini. Then, I restart my Apache. That’s it.

   If you need how to configure PHP5.5, please see the post. It is for a mbstrings user, but the information gives some help for you.

Categories
everyday life

Rhododendrons of the mountain (2014).

同一記事の日本語版

   Yesterday, very sunny. I went and saw blooming rhododendrons (シャクナゲ) to the mountain again. The garden is named Hikosan Kaen (英彦山花園).

   I found the blooming rhododendrons and others in and out of the garden. Beautiful!! I also saw a skink – it’s a Japanese five-lined skink(ニホントカゲ). Don’t you think it’s so cute? Is the person like me who thinks it’s cute strange? He-he. I also visited Hōheiden (奉幣殿) and got Omikuji (お御籤) as usual.

   I’ll show you some photos I took yesterday.

Fig.1 Rhododendrons and Kerrias
Fig.1 Rhododendrons and Kerrias
Fig.2 Rhododendrons
Fig.2 Rhododendrons
Fig.3 A carpenter bee on duty
Fig.3 A carpenter bee on duty
Fig.4 Primulas
Fig.4 Primulas
Fig.5 Spring color of leaves
Fig.5 Spring color of leaves
Fig.6 Camellia
Fig.6 Camellia
Fig.7 Double-flowered cherry blossoms
Fig.7 Double-flowered cherry blossoms
Fig.8 Japanese five-lined skink
Fig.8 Japanese five-lined skink
Fig.9 Mulan magnolia
Fig.9 Mulan magnolia
Fig.10 San no torii
Fig.10 San no torii
Fig.11 Spring color of leaves in the mountains
Fig.11 Spring color of leaves in the mountains
Fig.12 Dōdan tsutsuji
Fig.12 Dōdan tsutsuji
Categories
everyday life

Hazakura(葉桜) completely.

同一記事の日本語版

Hazakura (葉桜)
Hazakura (葉桜)
   On Mar.26, I wrote “The declaration of flowering(開花宣言)”. Now, it’s Hazakura(葉桜) completely. What is Hazakura(葉桜)? See the right image. 葉 means a leaf/leaves. 桜 means (a) cherry tree/trees. One of the most popular species of cherry tree in Japan is SomeiYoshino(染井吉野) which has blossoms first, after that its leaves grow. So we first see the blossoms only, and when we find the leaves the trees are all fresh green. We call the scenery Hazakura(葉桜).
 
   By the way, I’ll show you other photos of my garden flowers and fruits in the table.

Fig.1 Rhododendron yedoense
Fig.1 Rhododendron yedoense
Fig.2 Rhododendron yedoense
Fig.2 Rhododendron yedoense
Fig.3 Rhododendron obtusum
Fig.3 Rhododendron obtusum
Fig.4 Ixia
Fig.4 Ixia
Fig.5 Iris ?
Fig.5 Iris ?
Fig.6 Papaver rhoeas
Fig.6 Papaver rhoeas
Fig.7 Muscari
Fig.7 Muscari
Fig.8 Summer Snowflake
Fig.8 Summer Snowflake
Fig.9 Iris japonica
Fig.9 Iris japonica
Fig.10 Aquilegia vulgaris
Fig.10 Aquilegia vulgaris
Fig.11 Anzu(杏)
Fig.11 Anzu(杏)
Fig.12 Ume(梅)
Fig.12 Ume(梅)
Categories
WordPress

WordPress 3.9 named “Smith” is available but waiting Japanese version.

同一記事の日本語版
Update information      Edit    Edit2(Jun.22)

   WordPress 3.9 named “Smith” is available but waiting Japanese version. How about you, guys?
 
Edit:
   I upgraded to WordPress 3.9-ja at 20:19. I still have the same issue when I updated to 3.8.3. The issue is that Warning! Problem updating https://SITENAME. Your server may not be able to connect to sites running on it. Error message: error:14094410:SSL routines:SSL3_READ_BYTES:sslv3 alert handshake failure. Why does it happen???
 
   Here are the information pages about WordPress 3.9. Codex, Blog, Changelog.

Edit2(Jun.22):
   I wrote an article The solution of “SSL3_READ_BYTES:sslv3 alert handshake failure” on WordPress.

Categories
WordPress

A subsequent update: WordPress 3.8.3

同一記事の日本語版
Update information      Edit    Edit(Jun.22)

   A few days earlier, I wrote “I think Automatic Background Updates for minor updates are no problem.” in my reply to one of the Japanese blog visitors. But it might have a problem if the Update has files related with localizations like 3.8.3.

   This update includes the following Revised Files.

wp-admin/includes/upgrade.php
wp-admin/includes/post.php
wp-admin/about.php
wp-includes/version.php
readme.html

   Actually, the file version.php has the $wp_local_package as its last line if you installed a localized WordPress. Some troubles might happen if the line is deleted by the Automatic Update. If you installed the localized WordPress and had the Automatic Update of 3.8.3, you’d better add the line $wp_local_package = ‘your_localize_code’ to your version.php’s last line.

   By the way, in spite of using Oiram’s workaround, I had Warning! Problem updating https://SITENAME. Your server may not be able to connect to sites running on it. again. The error code is Error message: error:14094410:SSL routines:SSL3_READ_BYTES:sslv3 alert handshake failure. This is different from the previous one. I couldn’t find how to solve it still now. The same site has the error again. Why does it happen?

Edit:
   My talk on this post is repugnant to “WordPress 3.8.2 has come in this morning.”. The version.php of 3.8.2 had no $wp_local_package = ‘your_localize_code’ but gave no problem. Ummm.

Edit(Jun.22):
   I wrote an article The solution of “SSL3_READ_BYTES:sslv3 alert handshake failure” on WordPress.

Categories
Windows

Upgrading from MariaDB 5.5 to 10 on Windows.

同一記事の日本語版
Update information      Edit(Jun.30)

   Now we have the first stable version of MariaDB 10.0 Series which was released on Mar 31. Today, I’ve upgraded from MariaDB 5.5 to 10 on Windows7HP+SP1(x86). Though this is not an update but an upgrade, the procedures are nothing different from the last update.

   First, I backed up all the sever data. Especially, MariaDB and MyDB.

   Next, I upgraded to MariaDB 10.0.10.

  1. Downloaded mariadb-10.0.10-win32.zip.
  2. Extracted the Zip archive.
  3. Control Panel >> Administrative tools >> Services
    Select the MyDB service name and stop.
  4. Delete all contents in the MariaDB folder. Install the four folders named bin, include, lib and share and license files to the folder.
  5. Control Panel >> Administrative tools >> Services
    Select the MyDB service name and start.

   That’s it.

Edit(Jun.30):
   I forgot to write. After upgrading, you have the error message “Please use mysql_upgrade to fix this error.” on the error log, so you need “mysql_upgrade“.

Categories
WordPress

WordPress 3.8.2 has come in this morning.

同一記事の日本語版
Update information      Edit(Apr.15)

   WordPress 3.8.2 has come in this morning.

   Of course, I actualy found it when I logged in my admin panel in the morning he-he. Last night I re-created the SSL things and re-patched Oiram’s workaround to the ca-bundle.crt, so I slightly worry about the update of WordPress, but I have no problem at this time. Happy!

Edit(Apr.15):
   My talk on this post is repugnant to “A subsequent update: WordPress 3.8.3”. The version.php had no $wp_local_package = ‘your_localize_code’ but gave no problem. Ummm.