Categories
translation

I am depressed for some reason.

   Can I complain the difficulty of my translation?

   Actually, for about 10 days, I have been depressed for some reason. I know my English is bad, so my translation is not good. But when I find that someone says about it not here but somewhere on the Internet, which lets me down. Because it is the same as to talk behind my back, I can do nothing against it.

   Previously, one of my blog visitors offered me some help, and I was very glad though it was not done well. Now, another visitor are giving me some help. The two told me straight “this is better than that”. I really appreciate their help. My English is not good, so I think the translation has a lot of points to be corrected. But the problem is I cannot get them by myself. If I know about them by myself, I can correct them, of course.

   You know, I am NOT a professional translator and I am NOT a native English speaker. Like some software developers who volunteered sometimes ask for donations, I want your correction as a donation for my translation if you are good at English. (^^;)

   Thanks in advance!!

Categories
everyday life

Finally, autumn has come.

同一記事の日本語版

I think autumn has come.
I think autumn has come.
   From Wednesday to Monday, we had rain after a certain interval in my town. Especially, we had a good amount of rainfall from 24th to 26th. Though the rain made disasters some other areas, we had good rain for us because some crops wanted water in my town. And, the rain brought autumn to my town. The rain stopped on 26th and we have very sunny days yesterday and today, so the heat comes back again during the day. But, very much different compared to a week ago. I made a graph, please take a look!

   The graph based on the data of my town AMeDAS(アメダス). Do you know Japanese AMeDAS? First, “AMeDAS” is an abbreviation of “automated meteorological data acquisition system”. Second, AMeDAS instruments exist throughout Japan. Of course, in my town. Third, we use its data anytime we need them. Where can we find them? At JMA official site. So, I used them and made the graph. Actually, my town AMeDAS is a miner version and does not give us the humidity data, so I took the data of it from the nearest city AMeDAS.

   If you want to visit Japan except Hokkaidō someday, and if the length of the visit is very short, I am never going to recommend a summer travel to you. (^^;)(^^;)(^^;)

Note for the graph:
　8月:August
　気温(℃):Temperature(℃)

What is the name of this caterpillar? #2
What is the name of this caterpillar? #2
What is the name of this caterpillar?
What is the name of this caterpillar?
　湿度(%):Humidity(%)
　降水量(㎜):Precipitation(㎜)
　於わが町:at mytown
　昨日まで:until yesterday
　最高気温(℃):Highest temperature(℃)
　平均:Mean/Average
　最低気温(℃):Lowest temperature(℃)
　最高:Maximum
　最低:Minimum

   By the way, I found a caterpillar in my garden. Of course, in the garden some insects live everyday. But this kind of caterpillar is very first time for me. Do you know the name of this caterpillar?

Edit:
   One of my Japanese Blog visitors told me the name of the caterpillar. It is a caterpillar of Theretra japonica. Now, my head was cleared. (^^)

   Thanks a lot, FHさん.

Categories
Windows

Updating to PHP5.5.3.

同一記事の日本語版

   At Aug-21 17:44:24UTC, they released PHP5.5.3.

   Acoording to the ChangeLog, they fixed UMR(unInitialized Memory Read) in fix for CVE-2013-4248. A fix for CVE-2013-4248 again?

   Anyway, I downloaded a Thread Safe version php-5.5.3-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.

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

Updating to PHP5.5.2.

同一記事の日本語版

   At Aug-16 02:13:06UTC, they released PHP5.5.2. So, I downloaded a Thread Safe version php-5.5.2-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.

   Acoording to the ChangeLog, it has some bug fixes and includes the patch for CVE-2013-4248.

   The new php.ini-production has two difference from the php.ini-production of version 5.5.1.
　　　The line “;extension=php_zip.dll” doesn’t exist anymore.
　　　Edit typos: mssql.compatability_mode = Off　—>　mssql.compatibility_mode = Off

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

Memorandum #4.

同一記事の日本語版

   How to create from the mo file to the po file on Windows OS.

  1. Install Poedit.
  2. Run cmd.exe
    >cd (Poedit bin Path)
    >msgunfmt -o (po file) (mo file)　　　—>See Command Line Help.
  3. That’s it. I have the po file. Happy.

   I stopped using the three plugins because they haven’t been updated in over 2 years.

  • Similar Posts
  • Post-Plugin Library
  • Picbox

   I started using the next plugins instead of the three plugins above.

Categories
WordPress

Upgrading to WordPress 3.6.

同一記事の日本語版

   Today, Japanese WordPress develop members announced they brought the new Japanese version WordPress for us, according to the Codex for Version 3.6, 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.6-ja.zip manually and upgraded.

   Happy upgrade!! But, to use the new features I should update my themes I made by myself. Sigh!

Categories
everyday life

The Return of the Prodigal Server.

同一記事の日本語版

   This early morning, I moved my live production site from the old laptop PC to the xw4200 in which I made a wamp-like server until yesterday.

   The xw4200 is my previous server machine. In the mid-April of last year, its SCSI HDD was broken. It took a long time before I found out the SCSI HDD was broken. At that time, the PC gave me a lot of trouble.

   But now, the PC works in a very cheerful way. That is “The Return of the Prodigal Server”. (^o^)(^o^)(^o^)

【Current server applications】
　Windows7 Home Premium SP1(x86)
　httpd-2.4.6-win32-VC11.zip
　ActivePerl-5.16.3.1603-MSWin32-x86-296746.msi
　php-5.5.1-Win32-VC11-x86.zip
　mysql-5.6.12-win32.zip
　phpMyAdmin-4.0.4.2-english.zip

Categories
Windows

To create a Wamp-like Web Server in Windows7-#4.

同一記事の日本語版

   Continued from my last post.

Enabled SSL.

  1. Copy cacert.pem, server.crt, server.key to the Apache conf directory.

    If you need how to make these three files, please see WordPress: Administration Over SSL #1.

    I think a cmd.exe on a Windows7 recognizes both slashes(/) and backslashes() in a openssl.cnf. Maybe, you need not use “” in the openssl.cnf when you customize it. On a Windows7, you can see a openssl.cnf as a openssl.conf instead of openssl, a file type “SpeedDial”. Ha-ha-ha.

  2. Customize the file httpd-ssl.conf in the Apache extra conf directory.
    If you need how to customize, please see WordPress: Administration Over SSL #1.
  3. Customize the file httpd.conf.
    If you need how to customize, please see WordPress: Administration Over SSL #1.
  4. Control Panel >> Administrative tools >> Windows Firewall with Advanced Security >> Inbound Rules
    Add the port 443 to “Apache HTTP Server”.

    By the way, if you accept about the port alert from your Windows Firewall, the rules are created automatically. But they seem too looser for the Web Server wares. At “Windows Firewall with Advanced Security” you can strictly set up them. So, you should use this advanced feature.

  5. Restart the Apache.

   Mission Complete!

Categories
Windows

To create a Wamp-like Web Server in Windows7-#3.

同一記事の日本語版

   Continued from my last post.

The installation of MySQL 5.6.

  1. Download mysql-5.6.12-win32.zip.
  2. Extract the Zip archive.
  3. Make the directory ‘MySQL’ in Drive_SV (A partition for server wares I made), then, install the directories and files to the MySQL. You can install all of extracted things. But, I only installed the next 5 directories and 2 files because I do not use others on my server by remote.
    • directories
      bin
      data
      include
      lib
      share
    • files
      COPYING
      my.ini　　<—　　　Copy of the my-default.ini.
  4. Customize the my.ini file. (See Creating an Option File)
    # basedir = …..　　—>　　basedir = Drive_SV:/MySQL　　　(*) not a backslash() but a slash(/).
    # datadir = …..　　—>　　datadir = Drive_SV:/MyDATA
    Add the next line.
    explicit_defaults_for_timestamp = true
  5. Move the data directory (Current location:Drive_SV:MySQLdata) to Drive_SV: and rename to MyDATA.
  6. Run a cmd.exe as an Administrator.
    >Drive_SV:
    >cd Drive_SV:MySQLbin
    >mysqld –console　　　 (See Starting the Server for the First Time)

    2013-07-30 08:22:26 3484 [Note] Plugin ‘FEDERATED’ is disabled.
    ・　　　　　　　　　　　　　　　　　・
    ・　　　　　　　　　　　　　　　　　・
    2013-07-30 08:22:27 3484 [Warning] No existing UUID has been found, …………
    ・　　　　　　　　　　　　　　　　　・
    ・　　　　　　　　　　　　　　　　　・
    2013-07-30 08:22:27 3484 [Note] mysqld: ready for connections.
    Version: ‘5.6.12’ socket: ” port: 3306 MySQL Community Server (GPL)

    If you have other errors or warnings, customize the my.ini again. If having an alert about the port 3306 from Windows Firewall, you may accept it.

    Run another cmd.exe as an Administrator.
    >Drive_SV:
    >cd Drive_SV:MySQLbin
    >mysqladmin -u root shutdown

  7. Run a cmd.exe as an Administrator.
    >Drive_SV:
    >cd Drive_SV:MySQLbin
    >mysqld.exe –install
  8. Control Panel >> Administrative tools >> Services
    Select the MySQL Service name and start
    If its ‘Startup Type’ is not ‘Automatic’, you have to change it to ‘Automatic’.
  9. Add the directory Drive_SV:MySQLbin to the Path.Change root password.

    Run a cmd.exe as an Administrator.
    >mysql -u root
    >SET PASSWORD FOR root@localhost=PASSWORD(‘password’);
    > quit

    Logon check.
    >mysql -u root -p
    Enter password: ************
    > quit

The installation of phpMyAdmin4.

  1. Download phpMyAdmin-4.0.4.2-english.zip.
    Extract the Zip archive.
  2. Rename the directory phpMyAdmin-4.0.4.2-english to phpMyAdmin.
    Remove the config.sample.inc.php in the extracted files.
    Remove three directorates: doc, examples, and setup.
    Copy my old config.inc.php in the phpMyAdmin. (If you don’t have an old config.inc.php, see Quick Install.)

    Move the phpMyAdmin to Drive_SV.

  3. Make an extra conf file as phpMyAdmin.conf in Drive_SV:Apache24confextra.
    The text of phpMyAdmin.conf:
    Alias /phpMyAdmin “Drive_SV:/phpMyAdmin/”

    <Directory “Drive_SV:/phpMyAdmin”>
    Options None
    AllowOverride None
    Require ip Lan IP range.
    </Directory>
    <Directory “Drive_SV:/phpMyAdmin/libraries”>
    Require all denied
    </Directory>

    Customize the httpd.conf (Location:Apache24conf).
    Add the next two lines to at the end of the Supplemental configuration section:
    # phpMyAdmin settings
    Include conf/extra/phpMyAdmin.conf

  4. Restart Apache.
    Access http://xxx.xxx.xxx.xxx/phpMyAdmin

    Username: root
    Password: MySQL root password

    I have the caution:
    The phpMyAdmin configuration storage is not completely configured,
    some extended features have been deactivated. To find out why click here.

    So, to configure the phpMyAdmin configuration storage, I import my old database phpmyadmin. (If you don’t have an old database phpmyadmin, see phpMyAdmin configuration storage.)

  5. Log out, and log in. The caution has gone.
  6. Delete all users except root@localhost.Make a user(WP-User) and a database(WPdatabase) for the WordPress.
    WP-user was given all Global privileges except Grant. WP-user was given no Global privileges and was given all WPdatabase privileges except Grant. Their collation is utf8_general_ci.
  7. Log out.
Categories
Windows

To create a Wamp-like Web Server in Windows7-#2.

同一記事の日本語版
Update information      Edit(Dec.27)    Edit2(2014.Mar.24)

   Continued from my last post.

The installation of ActivePerl.

  1. Download ActivePerl-5.16.3.1603-MSWin32-x86-296746.msi.
  2. Install ActivePerl-5.16.3.1603-MSWin32-x86-296746.msi into Drive_SV (A partition for server wares I made) by the default.
  3. Run a cmd.exe
    >perl -v
    If you get the version information, the directory Perl is already added to the Path.
  4. Customize the printenv.pl file (Location:Apache24cgi-bin).
    #!D:/programs/perl/bin/perl.exe　　—>　　#!Drive_SV:/Perl/bin/perl.exe

    Move printenv.pl from Apache24cgi-bin to drive_DC:WEBcgi-bin.
    Access http://xxx.xxx.xxx.xxx/cgi-bin/printenv.pl from a web browser.

    If you have the server environment variables list, the installation is complete.

  5. Remove printenv.pl.
  6. (*) To use CGI scripts outside of ScriptAliased directories, you will need directive AddHandler: (You will also need to add “ExecCGI” to the “Options” directive.)

The installation of PHP5.5.

  1. Actually, on Jun 20th PHP5.5 was released, but, this doesn’t support WindowsXP anymore. So, until now, I wasn’t able to use it if I wanted to use it. Now, I have a Windows7 on Xw4200, so I downloaded php-5.5.1-Win32-VC11-x86.zip. This is a thread safe version because my web server software is Apache and OS is Windows. To confirm about this thing, please read the install.txt of PHP by yourself.
    Extract the Zip archive.
    Rename the directory php-5.5.1-Win32-VC11-x86 to PHP.
  2. Copy the file php.ini-production as the file php.ini. Customize the php.ini file (Location:PHP).
      Default Custom
    1 ;default_charset = “UTF-8” default_charset = “UTF-8”
    2 ; extension_dir = “ext” extension_dir = “Drive_SV:PHPext”
    3 allow_url_fopen = On allow_url_fopen = Off
    4 ;extension=php_curl.dll extension=php_curl.dll
    5 ;extension=php_gd2.dll extension=php_gd2.dll
    6 ;extension=php_mbstring.dll extension=php_mbstring.dll
    7 ;extension=php_mysql.dll extension=php_mysql.dll
    8 ;extension=php_mysqli.dll extension=php_mysqli.dll
    9 ;extension=php_openssl.dll extension=php_openssl.dll
    10 ;date.timezone = date.timezone =”Asia/Tokyo”
    11 ;sendmail_from = me@example.com sendmail_from = My email address
    12 ;mbstring.language = Japanese mbstring.language = Japanese
    13 ;mbstring.internal_encoding = UTF-8 mbstring.internal_encoding = UTF-8
    14 ;mbstring.http_input = UTF-8 mbstring.http_input = pass
    15 ;mbstring.http_output = pass mbstring.http_output = pass
    16 ;mbstring.encoding_translation = Off mbstring.encoding_translation = Off
    17 ;mbstring.detect_order = auto mbstring.detect_order = UTF-8,ASCII,SJIS,EUC-JP,JIS
    18 ;mbstring.substitute_character = none mbstring.substitute_character = none

    (*) About the 14-18, it should work by leaving the default. The above 14-18 customization is particularly for my server.

    Three additional settings by the security reason. The 19 and 21 settings might give some troubles on your server. It depends on your server environment. (Edit:Dec.27).

      Default Custom
    19 output_buffering = 4096 output_buffering = Off
    20 expose_php = On expose_php = Off
    21 mysql.allow_persistent = On mysql.allow_persistent = Off
  3. Move the directory PHP to Drive_SV.
  4. Make an extra conf file as php55.conf in Drive_SV:Apache24confextra.
    The text of php55.conf:
    LoadModule php5_module “Drive_SV:/PHP/php5apache2_4.dll”
    AddHandler application/x-httpd-php .php
    PHPIniDir “Drive_SV:/PHP”

    Customize the httpd.conf (Location:Apache24conf).
    DirectoryIndex index.html　　—>　　DirectoryIndex index.php index.html
    Add the next two lines to at the end of the Supplemental configuration section:
    # PHP settings
    Include conf/extra/php55.conf

  5. Make a php file as test.php in drive_DC:WEBhtdocs
    The text of test.php:
    <?php phpinfo() ?>

    6. Restart Apache.

    Access http://xxx.xxx.xxx.xxx/test.php from a web browser.

    If you have the phpinfo list, the installation is complete.

  6. Remove test.php.
  7. Customize the php.ini (Location:PHP).
    ;disable_functions =　　—>　　disable_functions =”shell_exec, suexec, passthru, phpinfo”
  8. Restart Apache.

Edit2(2014.Mar.24):
   I enabled the Opcache on 2013 Dec. 27. If you use a lot of PHP scripts on your server, I also recommend the post “Enabled Opcache”.