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!

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:\MySQL\data) to Drive_SV: and rename to MyDATA.
  6. Run a cmd.exe as an Administrator.
    >Drive_SV:
    >cd Drive_SV:\MySQL\bin
    >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:\MySQL\bin
    >mysqladmin -u root shutdown

  7. Run a cmd.exe as an Administrator.
    >Drive_SV:
    >cd Drive_SV:\MySQL\bin
    >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:\MySQL\bin 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:\Apache24\conf\extra\.
    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:Apache24\conf\).
    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.

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:Apache24\cgi-bin\).
    #!D:/programs/perl/bin/perl.exe  —>  #!Drive_SV:/Perl/bin/perl.exe

    Move printenv.pl from Apache24\cgi-bin\ to drive_DC:\WEB\cgi-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:\PHP\ext\"
    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:\Apache24\conf\extra\.
    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:Apache24\conf\).
         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:\WEB\htdocs
    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.

  7. Remove test.php.
  8. Customize the php.ini (Location:PHP\).
         ;disable_functions =  —>  disable_functions =”shell_exec, suexec, passthru, phpinfo”
  9. 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”.

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

Update information      Edit(Aug.11)

   Yesterday, I had the PC which was installed Windows7HP+SP1(x86) as I wrote the article. It is good for me to create a new Wamp-like Web Server.

   First I make two partitions. One for server wares(Drive_SV), another for other files(drive_DC).

   By the way, during creation, Windows Firewall gives alerts several times. At the time, confirm and open required ports. Well, let me get started.

The installation of the Apache HTTP Server.

  1. Download httpd-2.4.6-win32-VC11.zip.
    It requires VC11. So, I downloaded and installed vcredist_x86.exe.
    Extract the Zip archive.
  2. Customize the httpd.conf file in extracted files (Location:Apache24\conf\).
      Default Custom
    1 ServerRoot “c:/Apache24” ServerRoot “Drive_SV:/Apache24”
    2 ServerAdmin admin@example.com ServerAdmin My email address
    3 #ServerName www.example.com:80 ServerName xxx.xxx.xxx.xxx:80
    4 DocumentRoot “c:/Apache24/htdocs” DocumentRoot “drive_DC:/WEB/htdocs”
    5 <Directory “c:/Apache24/htdocs”> <Directory “drive_DC:/WEB/htdocs”>
    6 Options Indexes FollowSymLinks Options FollowSymLinks
    7 ErrorLog “logs/error.log” ErrorLog “|bin/rotatelogs.exe -l -f logs/error.%Y.%m.%d 86400”
    8 CustomLog “logs/access.log” common # CustomLog “logs/access.log” common
    9 #CustomLog “logs/access.log” combined CustomLog “|bin/rotatelogs.exe -l -f logs/access.%Y.%m.%d 86400” combined
    10 ScriptAlias /cgi-bin/ “c:/Apache24/cgi-bin/” ScriptAlias /cgi-bin/ “drive_DC:/WEB/cgi-bin/”
    11 <Directory “c:/Apache24/cgi-bin”> <Directory “drive_DC:/WEB/cgi-bin”>
    12 Require all granted Require ip Lan IP range (Access control to cgi-bin directory)
    13   ServerTokens Prod
  3. Move the directory Apache24 to Drive_SV.
  4. Run a cmd.exe as an Administrator.
    >cd Drive_SV:\Apache24\bin
    >httpd.exe -t
    If having error messages, you have to fix them before continuing procedures.

    Install as a Service:
    >httpd.exe -k install
    Make an ApacheMonitor.exe shortcut in the Windows Startup folder. Start Apache.

  5. Move index.html from Apache24/htdocs to drive_DC:\WEB\htdocs
    Access http://xxx.xxx.xxx.xxx/ from a web browser.
    If you have “It works!”, the installation is complete.
  6. Remove index.html.

Edit(Aug.11):
   These days, I was in trouble because my Apache sometimes made no response. At that time, I think the error log gave me the message “(OS 64)The specified network name is no longer available. : AH00341: winnt_accept: Asynchronous AcceptEx failed.”, so I added the next lines my httpd.conf. (Ref:AcceptFilter Directive)

   <IfModule mpm_winnt_module>
      AcceptFilter http none
      AcceptFilter https none
   </IfModule>

Upgrading from WinXpPro+SP3(x86) to Win7HP+SP1(x86).

   On 2014.Apr.8, Extended Support of Windows XP support ends completely, so I planed to change my server OS to CentOS until the day. But, fortunately, one of my friends gave me ‘Microsoft Windows 7 Home Premium, Upgrade Edition for XP or Vista users’ DVD. I think this is no problem for a license. Because the friend doesn’t use this Win 7 anymore. Am I right?

   Immediately, I installed Windows7HP+SP1(x86) on HP xw4200 Workstation. This is a previous server machine. About this PC, I wrote some articles on the Japanese Blog.

   When you use the upgrade DVD, you need a target OS, of course. So, I installed WinXpPro+SP3(x86) first, and upgraded. By the way, when you upgrade from XP to 7, you have to choose Custom (advanced) type of installation.

   During upgrading, the PC gave me the next message several times. Grrr.
     ***Hardware Malfunction
     Call your hardware vendor for support
     NMI:Parity Check / Memory Parity Error
     ***The system has halted***

   I used Memtest86+ and checked it out, but I had no error.

   Fortunately, I found the page “***Hardware Malfunction Call your Hardware Vendor for Support NMI: Parity Check/Memory Parity Error *** The system has halted ***” at last. (PDF file here.)

   I tried and tested this solution, and then, I installed Windows7 completely. I am still afraid of the error above occurring. But, there is as yet no sign of error.

   Well, I got a Windows7 Desktop PC. Now, my weak heart thinks a Windows7 server instead of a CentOS server. Because, I am a Windows person. (^^;)

Updating to Apache 2.4.6.

   Apache HTTP Server 2.4.6 was released, which is for reverting a broken fix for PR54948 that was applied to 2.4.5 (which was not released) and found post-2.4.5 tagging. I heard Apache HTTP Server 2.4.5 broke vhost mapping.

   I downloaded httpd-2.4.6-win32-VC9.zip (16 Jul) from the ApacheLounge for My WindowsXP server. The new httpd.conf has the next four additional lines which are all commented.
————————————————————————————————————————————————
   #LoadModule auth_form_module modules/mod_auth_form.so
   #LoadModule cache_socache_module modules/mod_cache_socache.so
   #LoadModule macro_module modules/mod_macro.so
   #LoadModule proxy_wstunnel_module modules/mod_proxy_wstunnel.so

The Eccentric Family(有頂天家族)

   Today, I found Ep.1 of this anime on Gyao. Though Gyao has only Ep.1 as a free content, I can watch it on my TV, the station is BS11. If you have an interest in this anime, you can watch it on crunchyroll.

   I liked EP.1, so I will keep watching.

   The original novel (有頂天家族) is written by Morimi Tomihiko (森見登美彦).

The_Eccentric_Family

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

WritingBrushes   I’ve posted a part of Chapter 1, “Seijō no Ran (青条の蘭)”.

   Every time when I translate the story, some Japanese words task my brain. A word, not a sentence. Of course, sentences task my brain much more (^^;).

   When I translated “The Birds of Hisho (丕緒の鳥)”, I used “a writing brush” as the meaning of “筆”. We still use a writing brush when we write calligraphy, and, in the old days East Asian people used “筆” on a daily basis. But at least two people asked me “what is a writing brush exactly?”. Please take a look at the image right. They are writing brushes, i.e. “筆”.

   At this time, I use “a fur coat” as the meaning of “kawagoromo (裘)”. This is maybe O.K. But, I worry about I use “a boxy knapsack” as the meaning of “oibako (笈筺)”. 笈筺 is a thing like this in my mind.

Updating to PHP5.4.17.

Update information      Edit(Aug.3)

   At Jul-03 23:29:25UTC, they released PHP5.4.17. So, I downloaded a Thread Safe version php-5.4.17-Win32-VC9-x86.zip for my server (WindowsXP SP3 (x86)).

   Acoording to the ChangeLog, it has some bug fixes.

   As php5apache2_4.dll included in the official PHP binary 5.4.10+, I extracted the zip archive and replaced all PHP5.4.15 files with all PHP5.4.16 files except my php.ini. Then, I restarted my Apache. That’s it.

   If you need how to configure PHP5.4, please see the post on my Japanese blog. Of course, it is only in Japanese and for a mbstrings user, but I think the information gives some help for you.

   By the way, they also announced PHP 5.5.0 was available. It doesn’t support WindowsXP anymore. At some point in the near future, i.e. until 2014/Apr/8, I have to reconstruct my server.

Edit(Aug.3):
   If you need how to configure PHP5.5, please see “To create a Wamp-like Web Server in Windows7-#2“.

I’ve released the first part of the translation “Seijō no Ran”.

   On July 1st, I started to translate a story again, despite the difficulties. (^_^;)(^_^;)
   So, today, I’ve released the first part of the translation “Seijō no Ran (青条の蘭)”. (^o^)(^o^)

   Has anyone else translated the same story, yet? Well, that’s O.K.

   I almost forget to write. The day before yesterday, I added the new link to the post “You can look inside!“.