Categories
Windows

Updating to AWStats7.3.

同一記事の日本語版

   I updated AWStats from 7.2 to 7.3. See ChangeLog and current features. Wow!

  1. Downloaded awstats-7.3.zip for my server (Windows7HP + SP1 (x86)).
  2. Extracted the Zip archive.
  3. Replaced the old folders below by new ones. (Location:Drive_DC:awstatswwwroot)
         classes
         css
         icon
         js
  4. Replaced the old folders below by new ones. (Location:Drive_DC:awstatswwwrootcgi-bin)
         lang
         lib
         plugins
  5. Customize new awdownloadcsv.pl, awredir.pl and awstats.pl. (Location:Drive_DC:awstatswwwrootcgi-bin).
         #!/usr/bin/perl  —>  #!Drive_SV:/perl/bin/perl
    Replaced the old files by new ones.
  6. Use old awstats.MyDomain.com.conf as the new conf.

   If you install AWStats at the first time, see AWStats Installation, Configuration and Reporting.

   I use this opportunity to do the software blow up-to-date. Actually, about PERL I did on Dec.26. I forgot to write it. Now, I updated AWStats, which is a PERL scripts package. So, the information about it needs the PERL version. Right? (^_^;)

  • ActivePerl-5.16.3.1603 —> ActivePerl-5.18.1.1800
  • phpMyAdmin-4.1.0 —> phpMyAdmin-4.1.6
  • mariadb-5.5.34 —> mariadb-5.5.35
Categories
Windows

Updating to PHP5.5.8.

同一記事の日本語版

   At Jan-09 18:16:03UTC, they released PHP5.5.8. My physical strength was slightly back. So, I updated my PHP.

   According to ( ChangeLog ), it fixes some bugs against PHP 5.5.7, and An addition. The addition is related to the old voluntary CVE-2011-3379 (See H. Tokumaru’s tumblr “Added validation of class names in the autoload process“. This is only in Japanese.).

   I downloaded a Thread Safe version php-5.5.8-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 php.ini-production has nothing changed.

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

Moving to MariaDB5.5.

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

MaintenanceNotice   Yesterday, I worked very hard. For what? Well, moving to MariaDB5.5 from MySQL on Windows7HP+SP1(x86). Haha.

   First, I backed up all the sever data.
   Next, I made a maintenance.html like the right, and for maintenance I added the next lines to the head of my .htaccess at the Document Root. The text in it is like the below. (refer to: mod_rewrite, <IfModule>)

     ErrorDocument 503 /maintenance.html

     RewriteEngine On
     RewriteCond %{REQUEST_URI} !=/maintenance.html
     RewriteCond %{REMOTE_ADDR} !=IP address for Admin
     RewriteRule ^.*$ – [R=503,L]

     Header set Retry-After “Wed, 18 Dec 2013 01:00:00 GMT”

   On the page, I found “This section should only be used if you need to have one configuration file that works whether or not a specific module is available. In normal operation, directives need not be placed in <IfModule> sections.”. So, I thought I did not need <IfModule> sections.

   Then, I announced the server maintenance on my sites and began moving to MariaDB5.5.

   I had a clean installation of MariaDB because I wanted to change my sql engine from MyISAM to InnoDB. When I started using MySQL, I made the tables by MyISAM. Recently, I heard about InnoDB merits several times. So I always wanted to move to InnoDB, but I also found someone was in troubles on moving to it on the Internet. Hence I have hesitated to make a move because I can NOT handle them if something wrong happens despite my poor knowledge about the sql.

   MariaDB has InnoDB as its default. So I was going to recreate all my tables on this occasion if necessary.

Step1 The uninstallation of MySQL.

  1. Deactivated all WordPress plugins on my sites.
  2. Backed all databases up separately from the sever data backup.
  3. Also exported all contents of my WordPress from the site Dashboard. Because I was going to import all contents by the WordPress Importer if possible. I gave it up as described below, though.
  4. Stop the service.
    Control Panel >> Administrative tools >> Services
    Select the MySQL service name and stop.
  5. Delete the service.
    Run a cmd.exe as an Administrator.
    > sc delete MySql
  6. Removed the folders, MySQL and MyDATA (<--- These are MySQL scripts and data on my server).

Step2 The installation of MariaDB.

  1. Downloaded mariadb-5.5.34-win32.zip from MariaDB.
  2. Running my eyes overInstalling MariaDB Windows ZIP packages, I went to the page about mysql_install_db.exe.
  3. Extracted the Zip archive. Made two folders named MariaDB and MyDB on my server ware partition named Drive_SV. Installed all things made by extract to the folder MariaDB.

    Run a cmd.exe as an Administrator.
    > cd Drive_SV:MariaDBbin
    > mysql_install_db.exe –datadir=Drive_SV:MyDB –service=MyDB –password=secret

    By this, I was able to set the password for the root user and had a new my.ini in the MyDB.

  4. Control Panel >> Administrative tools >> Services
    Select the MyDB service name and start
    If its ‘Startup Type’ is not ‘Automatic’, you should change it to ‘Automatic’.

Step3 Access MariaDB via phpMyAdmin.

  1. Accessed MyDB as the root user from phpMyAdmin.
    Imported one of my backup database, phpmyadmin.
  2. Made a WordPress User and gave it all WordPress database privileges except Grant and no Global privileges. Of course set a password for it. Made a database for the WordPress. Their collation is utf8_general_ci.
    Logout.

   Import by WordPress Importer and I gave it up. The reason is the below.

   After a new WordPress installation, I imported all contents by WordPress Importer. But unfortunately, I found the fact that the plugin neglected some tags like <object>, it was inconvenient for me. I don’t know it neglects what kind tags and to examine them by myself is too much trouble. Therefore, I gave up this method.

Step4 Restored all WordPress database via phpMyAdmin.

  1. I wanted to use the InnoDB, so I replaced all ‘ENGINE=MyISAM’ by ‘ENGINE=InnoDB’ in the backup sql file.
  2. Login as the WordPress User.
    Exported the current WordPress database.
    Dropped all tables on the WordPress table because my backup sql file contained all data.
  3. Imported the backup. I had an error like this.
         #1214 – The used table type doesn’t support FULLTEXT indexes

    The backup file was originally MyISAM, so it includes FULLTEXT indexes. Actually it uses by YARPP as keys of post_title and post_content. Hummm. But on the forum the plugin author says we can use YARPP on the InnoDB though its performance slows down.

    I removed all lines about FULLTEXT indexes in the file. (I remember I heard we can use FULLTEXT with InnoDB on MySQL5.6.–Dec.25Edit)

  4. Dropped all tables again.

    Imported the customized file. I had another error.
         #1064 – You have an error in your SQL syntax;

    This error was my fault. When I removed FULLTEXT indexes I forgot to remove a “,” like this.
         KEY `post_author` (`post_author`),   <<--------This is the ',' I forgot to remove.      ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=xxxx ; I removed all such ','s.

  5. Dropped all tables again.

    Imported the customized file. Complete.

Step5 Back to normal condition.

  1. Login the WordPess.
    Activated all plugins.
    Checked all script behaviors.

    Change .htaccess text to end the maintenance.

  2. Actually, I still have an error about Jetpack on my parent site. Like this.

         Your website needs to be publicly accessible to use Jetpack: site_inaccessible
         Error Details: The Jetpack server was unable to communicate with your site https://MySITE
         [IXR -32300: transport error: http_request_failed SSL certificate problem: self signed
         certificate in certificate chain]

    But I think this is not the maintenance faults. Now I am waiting for a reply on the Jetpack forum.

   Now I use MariaDB5.5. Clap, clap.

Edit(Dec.21):
   After I changed SQL Storage Engine from MyISAM to InnoDB, the plugin YARPP performance slowed down very much. It was more than my expecting. So, I decided to rollback the Engine about the table wp_posts by YARPP instruction message.

  1. Login phpMyAdmin.
  2. Select the database for WordPress.
  3. Select the table wp_posts.
  4. Select ‘Operations’ from the top navigation bar.
  5. Change Storage Engine from Innodb to MyISAM at Table options.
  6. Click Go button of Tabble options.
  7. Logout phpMyAdmin.

   But YARPP didn’t recognize this change, though the author have a specialized feature for this. I went to the YARPP support forum to find a solution. I found MyISAM Override check doesn’t work. I followed hussong‘s instructions.

  1. Deactivate the plugin.
  2. Login phpMyAdmin.
  3. Select the database for WordPress.
  4. Select the table wp_options.
  5. Select ‘SQL’ from the top navigation bar.
  6. Use SELECT * FROM `wp_options` WHERE option_name LIKE "yarpp%"
  7. Delete all I found.You can see yarpp_fulltext_disabled = 1. Change it to yarpp_fulltext_disabled = 0
  8. Logout phpMyAdmin.
  9. Activate the plugin.
  10. Setting the plugin again because all old settings gone.

Now, I can use Titles and Bodies consider options. Happy!

Edit2(Dec.25):
   I wrote “About Jetpack trouble“.

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.7.

同一記事の日本語版

   At Dec-12 01:43:06UTC, they released PHP5.5.7.

   According to ( ChangeLog ), it fixes some bugs against PHP 5.5.6, and especially includes the fix for CVE-2013-6420.

   I downloaded a Thread Safe version php-5.5.7-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 php.ini-production has nothing changed.

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

Installed a Vista Business on my KeyPaso.

同一記事の日本語版
Update information      Edit(Mar.19)    Edit2(2014.Oct.16)

   I installed a Windows Vista Business I have on my KeyPaso. KeyPaso is a brand name of Elite 4 in Japan.

   I have used it as my living room PC. I gave up it because it has a lot of freezes when we watch videos. But, it is still alive. As I wanted to use it as my private video PC, I tried customizing it again. They end to support Windows XP on 2014/Apr/8 UTC, so I changed its OS to a Windows Vista Business I have. About VIDEO & GRAPHICS, both Built-in SiS651 and RADEON 9200 SE PCI have low ability. But the RADEON has a TV-Out and the Built-in does not have it. As the display I wanted to use this time has no VGA nor DVI, this is the reason why I replaced them, i.e. I disabled the Built-in.

   Here its speculation table.
 

  Old New
Installed OS Windows XP Professional SP3 Windows Vista Business SP2
CPU Intel(R) Celeron(R) 2.40GHz (Northwood-128) Socket 478 mPGA
Mainboard SiS-650
MEMORY 2GB (1GBx2) PC2700 DDR SDRAM(166 MHz)
SYSTEM BIOS Phoenix Technologies LTD ver. 6.00 PG 2003/Apr/04
VIDEO & GRAPHICS Built-in SiS651 RADEON 9200 SE PCI
NETWORKING SiS900 NIC
AUDIO SiS 7012 Audio Device
USB 2.0 SUPPORT Four USB 2.0 ports, transfer rate up to 480Mbps.
Also supports full-speed (11Mbps) and low speed
(1.5Mbps) USB devices.
FIREWIRE IEEE-1394 Two 1394 ports

   When I clean-installed the Vista, its device manager gave me a yellow ! mark about SiS 7012 Audio Device. I was unable to find out the Windows Vista driver for it, finally I found it worked under the driver for Windows XP (x86) named a12112d.zip. Of course, I cleaned the fan and the CPU up before the OS installation.

   I set the power option High, turned Aero off, chose the lowest resolution (800×600) because the display is 17 inches. If I choose the lowest resolution at the living room display, we were unable to watch videos because the display is 50 inches. After this settings, it still gave me some freezes when I watched videos. At last, I gave up the driver for RADEON 9200 SE PCI and installed a Standard VGA Graphics Adapter driver. This made much improvement.

   Now I use KeyPaso in my bedroom. Very good!

Edit(Mar.19):
   I try to use a VL-17VS2, and I wrote a post about this. If you are interested in it, see here. “FUJITSU 30 pin display connector —>> DVI-D.

Edit(2014.Oct.16):
   After the MS Patch Tuesday of October, I suddenly had audio jumpiness on the KeyPaso, the driver was from a12112d.zip. Finally I have a clear sound again after installing very very old Avance AC’97 Drivers for SiS that I forgot to have it from where.

Categories
Windows

Updating to PHP5.5.6.

同一記事の日本語版

   At Nov-13 20:57:44UTC, they released PHP5.5.6.

   According to ( ChangeLog ), it fixes some bugs against PHP 5.5.5, and adds some performance improvements.

   I downloaded a Thread Safe version php-5.5.6-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 has a change as fixed bug #65939 (Space before “;” breaks php.ini parsing —> [; size of the optimized code.]). So, I also fixed the line in my php.ini though the bug had had no influence on my server.

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

Tried Windows8.1 Pro on the laptop PC (NJ2100), and failed.

同一記事の日本語版

   Yesterday, I changed my OS from Windows8 Pro to Windows8.1 Pro on NJ2100. By the way, NJ2100 is an Epson Direct product in Japan. But, I think an ASUS product X51C and this are the same in specs.

   First I backed up my Win8 Pro by AOMEI Backupper.

   Second, I accessed the Store from the Metro UI and tried to update.

Windows8.1 #3
Windows8.1 #3
Windows8.1 #2
Windows8.1 #2
Windows8.1 #1
Windows8.1 #1

   The downloading maybe takes several hours, of course, though it depends on the environment.

   When ending the downloading, it shows us the reboot message. So, reboot the PC.

   I had no problem until this point. However, even after several hours, the installation did not end, the monitor displayed nothing and the HDD indicator never lighted up. I gave it up, and turned off the PC. When I turned it on, the PC restored Windows8 Pro and gave me an error code “0xC1900101 – 0x30018”. According to information on the Internet, the error seems to happen the PC has driver(s) which is older than Windows8.1 Pro requires. As my six sense told me the driver was the driver for “SiS Mirage 3 Graphics” (^_^;), I removed it and tried again.

   This time, I reached the goal. I tried to use the Windows8.1 Pro. The monitor resolution was 1024×768, so I installed the driver for “SiS Mirage 3 Graphics” again. But after that, I had a lot of freezes. Besides, I felt the High Definition Audio driver version 6.0.1.5506 did not work well, either. These two drivers are very necessary for comfortable using NJ2100. I can still use my Windows8 Pro. So, I decided that I kept my Windows8 Pro until updating to Windows8.1 Pro was absolutely required.

   I backed up the new Windows8.1 Pro because I didn’t want to waste my time again, and restored the old Windows8 Pro to my NJ2100.

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
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.