Categories
WordPress

Upgrading to WordPress 3.7.

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

   Today, Japanese WordPress develop members announced they brought the new Japanese version WordPress for us, according to the Codex for Version 3.7, there are tons of changes.

   My WordPress is a multisite type and the parent site language is English. Probably for this reason, the WordPress Updates page does not show me the Japanese version update message.

   So, I downloaded wordpress-3.7-ja.zip manually and upgraded.

   In the wp-includes folder, I found a certificates folder which contained a ca-bundle.crt. The ca-bundle.crt is for the below.
————————————————————————————————————————–
　　##
　　## ca-bundle.crt — Bundle of CA Root Certificates
　　##
　　## Certificate data from Mozilla as of: Sat Dec 29 20:03:40 2012
　　##
　　## This is a bundle of X.509 certificates of public Certificate Authorities
　　## (CA). These were automatically extracted from Mozilla’s root certificates
　　## file (certdata.txt). This file can be found in the mozilla source tree:
　　## http://mxr.mozilla.org/mozilla/source/security/nss/lib/ckfw/builtins/certdata.txt?raw=1
　　##
　　## It contains the certificates in PEM format and therefore
　　## can be directly used with curl / libcurl / php_curl, or with
　　## an Apache+mod_ssl webserver for SSL client authentication.
　　## Just configure this file as the SSLCACertificateFile.
　　##
————————————————————————————————————————–

   I have no error about this upgrade, but I have a warning about the site “o6asan’s netradi” like the below.

　　Warning! Problem updating https://MySiteName. Your server may not be able to connect
　　to sites running on it. Error message: SSL certificate problem: self signed certificate in
　　certificate chain

   But I can log in the site. About using “SSL certificate: self signed certificate in certificate chain”, my sites are all in the same condition. But, on the site, I use a streaming server. I think the warning happens due to this situation. As pointed out above, the new version of WordPress gives us “Bundle of CA Root Certificates”, so, should I make a new certificate by it? I don’t get it exactly. If someone knows about the warning, please tell me in detail.

   Anyway, I completed the upgrade.

Edit:
   I slightly concern about one of the new features of version 3.7 that is automatic updates for maintenance and security updates. But I think it’s probably O.K. because the automatic updates are only for maintenance and security updates. There are no differences between JP version and global version about such minor update. Am I right?

Edit2(Nov.5):
   I wrote a new article about the ca-bundle.crt.

   By the way, if you have the “Warning! Problem updating https://SITENAME. Your server may not be able to connect to sites running on it. Error message: SSL certificate problem: self signed certificate in certificate chain.“, please try Oiram’s workaround (PDF version).

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

Categories
Windows

Updating to PHP5.5.5.

同一記事の日本語版

   At Oct-17 00:30:06UTC, they released PHP5.5.5.

   According to ( ChangeLog ), it fixes about twenty bugs against PHP 5.5.4, some of them regarding the build system.

   I downloaded a Thread Safe version php-5.5.5-Win32-VC11-x86.zip for my server (Windows7HP+SP1(x86)). It requires VC11. If you don’t have VC11 on your Windows, you must install vcredist_x__.exe before the PHP configuration.

   The text in the file php.ini-production is no changed except adding a comment line “; This is php.ini-production INI file.”.

   As the official PHP binary includes php5apache2_4.dll, I extract the zip archive and replace all PHP5.5.4 files with all PHP5.5.5 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

Tonight is another “Otsukimi”, but…

後の月(2013)
後の月(2013)
   Hi, guys!! Tonight, we have another “Otsukimi”. We call it “Nochi no tsuki (後の月)”, and hold it at the night of September 13 by our old calendar (旧暦). But, this event gets very old-fashioned than “中秋の名月” on August 15.

   I saw a beautiful moon at that night. However, today cloudy. I was waiting, waiting and waiting. Finally, I was able to take a picture of the moon which broke through the clouds. Still, it was covered with thin clouds though.

   Every year, I want to achieve that I see the both moon on August 15 and September 13, but I can seldom do it. This year, can I say I saw the both moon? I wonder.

Categories
private remark

Totsuki Tōka (十月十日).

   In Juuni Kokuki, Ono sensei writes the pregnancy duration is ten months. This depends on not only lunar months but also counting from 1 instead of 0. In Juuni Kokuki world, they often use East Asian age reckoning system about characters’ age. So, I think they use old Japanese counting system in other ways as well.

   When we read 十月十日 as Jūgatsu Tōka, which means October 10. But, Totsuki Tōka (十月十日) means ten months and ten days, and also means the normal pregnancy duration. Sometimes, today’s Japanese people say it is longer than the true pregnancy duration. But I don’t think so.

   I will write my opinion about this, though a lot of texts about it already exist on the Internet. The opinion is not academic but experiential. Shall we start?

   First, you think of yourself as a Japanese woman who lived in more than 150 years ago.
   She doesn’t know her ovulation days and doesn’t have thermometers nor pregnancy self test kits. She uses a traditional Japanese lunar-solar calendar, so in her mind a month basically has 29 or 30 days alternately.

   If she is in such circumstances, how does she know her pregnancy by herself? Probably, by her morning sickness or by missing her period. When she has got her pregnancy, she would recall her last period. If she is a healthy woman, the last period should be within a few months when she knew her pregnancy. And then, she counts months of her pregnancy. At this time, she must think the first day of her last period as the first day of the pregnancy. And she thinks the month is the first month of the pregnancy.

   According to counting system from 1 instead of 0, Totsuki Tōka (十月十日) is approximately 280 days. For example, imagine the first day of her last period is October 13. October is the first month by counting from 1 instead of 0. Then the tenth month is July and July 23 is her expected delivery date. As pointed out above, in the old Japanese calendar, a month basically has 29 or 30 days alternately.

   Now, we try to calculate the number of days from October 13 to July 23.
   It is 29 days x 4 + 30 days x 5 + 10 days = 276 days or 29 days x 5 + 30 days x 4 + 10 days = 275 days.
   This is very close to 280 days.

   As you know, the pregnancy duration is vary considerably from person to person. So, Totsuki Tōka (十月十日) was a very practical and useful way in the past.

Categories
Windows

Updating to MySQL5.6.14.

同一記事の日本語版
Update information      Edit(9/25)

   I updated from MySQL5.6.12 to 5.6.14 on my server (Windows7HP+SP1(x86)).

  1. Download mysql-5.6.14-win32.zip.
  2. Extract the Zip archive.
  3. Stop the MySQL Service.
    Run a cmd.exe as an Administrator.
    >net stop mysql
  4. To be on the safe side, buck up the directories ‘MySQL’ and ‘MyDATA’ in Drive_SV (My server ware partition).
    Note: The default location of ‘MySQL’ is C:mysql and the default location of ‘MyDATA’ is C:mysqldata.
  5. Overwrite four directories and a file into the existing ‘MySQL’. Of course, my old my.ini still remains in the directory ‘MySQL’.
    • directories
      　　bin
      　　include
      　　lib
      　　share
    • file
      　　COPYING
  6. Overwrite two directories and three files into the existing ‘MyDATA’ except next four files, db.MYD, db.MYI, user.MYD, user.MYI. The files exist in the directory mysql of ‘MyDATA’. If you overwrite these files, you must reconfigure users and passwords about MySQL. My old auto.cnf remains in the directory ‘MyDATA’.
    • directories
      　　mysql
      　　performance_schema
    • files
      　　ib_logfile0
      　　ib_logfile1
      　　ibdata1
  7. Start the MySQL Service.
    Run a cmd.exe as an Administrator.
    >net start mysql

   That’s it.

Edit(9/25):
   I have had a lot of errors about a table in my database since the day before yesterday. I don’t know it had a relationship with this update or not, I dropped all database about my WordPress, and imported my backup. Now, it seems to look well.

Categories
Windows

Updating to PHP5.5.4.

同一記事の日本語版
Update information      Edit(9/21)

   At Sep-18 23:44:17UTC, they released PHP5.5.4.

   They say this release fixes several bugs against PHP 5.5.3. ( ChangeLog )

   I downloaded a Thread Safe version php-5.5.4-Win32-VC11-x86.zip for my server (Windows7HP+SP1(x86)). It requires VC11. If you don’t have VC11 on your Windows, you must install vcredist_x__.exe before the PHP configuration.

   The text in the file php.ini-production is slightly changed.

   About short_open_tag
———————————————————————————————————————————————
On PHP5.5.3 —
; This directive determines whether or not PHP will recognize code between
; <? and ?> tags as PHP source which should be processed as such. It’s been
; recommended for several years that you not use the short tag “short cut” and
; instead to use the full <?php and ?> tag combination. With the wide spread use
; of XML and use of these tags by other languages, the server can become easily
; confused and end up parsing the wrong code in the wrong context. But because
; this short cut has been a feature for such a long time, it’s currently still
; supported for backwards compatibility, but we recommend you don’t use them.
———————————————————————————————————————————————
On PHP5.5.4 —
; This directive determines whether or not PHP will recognize code between
; <? and ?> tags as PHP source which should be processed as such. It is
; generally recommended that <?php and ?> should be used and that this feature
; should be disabled, as enabling it may result in issues when generating XML
; documents, however this remains supported for backward compatibility reasons.
; Note that this directive does not control the [PHP-DEV] Is it true that short_open_tag is deprecated in PHP 6?“.

   And, about session.use_strict_mode, which finally showed up.
———————————————————————————————————————————————
On PHP5.5.3 —
   Nothing
———————————————————————————————————————————————
On PHP5.5.4 —
; Whether to use strict session mode.
; Strict session mode does not accept uninitialized session ID and regenerate
; session ID if browser sends uninitialized session ID. Strict mode protects
; applications from session fixation via session adoption vulnerability. It is
; disabled by default for maximum compatibility, but enabling it is encouraged.
; https://wiki.php.net/rfc/strict_sessions
session.use_strict_mode = 0
———————————————————————————————————————————————

   As the official PHP binary includes php5apache2_4.dll, I extract the zip archive and replace all PHP5.5.3 files with all PHP5.5.4 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.

Edit(9/21):
   I tried this script to be sure that “Note that this directive does not control the <?= shorthand tag, which can be used regardless of this directive.”.
———————————————
      <? echo “1. Can I use this directive?”; ?>
      <br>
      <?php echo “2. Can I use this directive?”; ?>
      <br>
      <?= “3. Can I use this directive?”; ?>
———————————————
   The answer was the below.

      2. Can I use this directive?
      3. Can I use this directive?
———————————————
   In my php.ini, the short tag “short cut” is disabled, but the shorthand tag is available despite it. The PHP manual reads;

Note:

This directive also affected the shorthand <?= before PHP 5.4.0, which is identical to <? echo. Use of this shortcut required short_open_tag to be on. Since PHP 5.4.0, <?= is always available.
Categories
everyday life

Tonight is “Otsukimi”, soooo beautiful Full moon.

中秋の名月(2013)
中秋の名月(2013)
   Hi, guys!! This year’s “Otsukimi” is come. Today, we have very very clear sky, so, we can see soooooooooooooo beautiful Full moon. We hold Otsukimi(お月見) on 15th of August by our old calendar(旧暦).

   I took its picture. And I remember a child song “月(moon)” like this.

  1. Detadeta tsukiga
    出た出た　月が
    Maruimarui manmarui
    丸い丸い　まん丸い
    Bonnoyōna tsukiga
    盆のような　月が
  2. Kakureta kumoni
    隠れた　雲に
    Kuroikuroi makkuroi
    黒い黒い　まっ黒い
    Suminoyōna kumoni
    墨のような　雲に
  3. Matadeta tsukiga
    また出た　月が
    Maruimarui manmarui
    丸い丸い　まん丸い
    Bonnoyōna tsukiga
    盆のような　月が

   If you want, listen to the song.   
   If your browser doesn’t support audio tags, please download and listen!!

   In second Lyrics, he is covered with thick clouds. But, this has never happened tonight. Who is he? He is the moon. Don’t think it is my mistake. In Japan the god of moon is a man named 月讀命(Tsukuyomi no mikoto). (^^)

Categories
WordPress

An access control after such a long time-#2.

同一記事の日本語版

   About seven months ago, I made an Apache extra conf file “access-denied.conf” like this. Today, I’ve modified it to control accesses to the directory “wp-admin”.

   I opened the access-denied.conf and changed the text like this.

Old:
<Files “wp-login.php”>
　　Require ip xxx.xxx.xxx.xxx/xx　　<<--- my local IP addresses 　　Require host My wifi domain name </Files> New: <Files "wp-login.php"> 　　Require ip xxx.xxx.xxx.xxx/xx　　<<--- my local IP addresses 　　Require host My wifi domain name </Files> <Directory "drive_DC:/WEB/htdocs/wp-admin">　　<<--- drive_DC:/WEB/htdocs/ is my DocumentRoot. 　　Require ip xxx.xxx.xxx.xxx/xx　　<<--- my local IP addresses 　　Require host My wifi domain name 　　<Files "wp-admin-ajax.php"> 　　　　Require all granted 　　</Files> </Directory>    I excluded the file "admin-ajax.php" from this deny rule, because the plugins which use the Ajax features need it (Ref:「Re: WordPress使いならこれだけはやっておきたい本当のセキュリティ対策10項目」). Actually, I examined plugins on my WordPress, and found some of them used the hook wp_ajax_(action). So, I needed to exclude the file from the rule.

   The rule works well. (^^)

Categories
translation

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

   I’ve posted the last half of chapter 1, “Seijō no Ran (青条の蘭)”.

   I wanted to add some notes about this part of the story. For example, Sekijin(迹人) is literally a “tracker” who gathers wildlife and vegetation from wild trees. And, Sekijin(迹人) is Hyōchū(標仲)’s position. But I have not done, yet.

   By the way, for the Juuni kokuki series Ono sensei borrowed many words from ancient Chinese administration system, like 地官, 迹人, etc. And, she gave different meanings to some words. Originally, Chōsai(冢宰), Taisai(太宰), and Saiho(宰輔) had the same meaning. But in the series, these three express three different positions. Honestly, I want to write about such things. However, in English, always, “I cannot find adequate words to express my feelings” (in Japanese 「その心あまりて，ことばたらず。」 from the kana preface of Kokin Wakashū).

   Actually, if I translate the meaning from the original context of the kana preface, it is “He cannot find adequate words to express his feelings”. But, the 「その心あまりて，ことばたらず。」 has neither I/he nor my/his. This is one of differences between Japanese and English.

Categories
translation

The translation of “Hisho no Tori (丕緒の鳥)”, Third Edition.

   Yesterday, I released the translation of “Hisho no Tori (丕緒の鳥)”, Third Edition. I think this edition has more reader-friendly English because Delonix helped me so much. He is so kind as to have offered me some help for my translating. We’ve worked together since June 17.

   I posted the article about the difficulty of my translation, and the person like him is very helpful to such a situation. He is not like a helicopter parent but like a good parent. He told me a lot of points to be corrected. He does not only blame my translation, but gives the alternatives.

   I really appreciate his help. We completed our mission. If the result makes you happy, which will make me happy. (^^)

   In addition, Delonix has a site on Flickr, and you can see beautiful flowers on it.