Tag: Windows7

Categories
Uncategorized

phpMyAdmin 4.1.0 is released.

同一記事の日本語版

   phpMyAdmin 4.1.0 is released. They say “With this release the minimum supported PHP version is now 5.3 and the minimum MySQL version is 5.5”. It has a ton of information in the ChangeLog. So I updated.

   I downloaded a phpMyAdmin-4.1.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, I found some additional lines in it. Like this:
　　　　At /* User used to manipulate with storage */ area
　　　　　// $cfg[‘Servers’][$i][‘controlport’] = ”;

　　　　At /* Storage database and tables */ area
　　　　　// $cfg[‘Servers’][$i][‘users’] = ‘pma__users’;
　　　　　// $cfg[‘Servers’][$i][‘usergroups’] = ‘pma__usergroups’;
　　　　　// $cfg[‘Servers’][$i][‘navigationhiding’] = ‘pma__navigationhiding’;

　　　　At the last area above the doc/ folder information
　　　　　/**
　　　　　 * Should error reporting be enabled for JavaScript errors
　　　　　 *
　　　　　 * default = ‘ask’
　　　　　 */
　　　　　//$cfg[‘SendErrorReports’] = ‘ask’;

   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][‘users’] … not OK [ Documentation ]
　　　　　$cfg[‘Servers’][$i][‘usergroups’] … not OK [ Documentation ]
　　　　　Configurable menus: Disabled

　　　　　$cfg[‘Servers’][$i][‘navigationhiding’] … not OK [ Documentation ]
　　　　　Hide/show navigation items: 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 tables manually. Then, I added new additional lines above to my config.inc.php, and removed “//” from the head of the next lines.
　　　　　$cfg[‘Servers’][$i][‘users’] = ‘pma__users’;
　　　　　$cfg[‘Servers’][$i][‘usergroups’] = ‘pma__usergroups’;
　　　　　$cfg[‘Servers’][$i][‘navigationhiding’] = ‘pma__navigationhiding’;

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

Categories
Uncategorized

Updating to Apache 2.4.7.

同一記事の日本語版

   Apache HTTP Server 2.4.7 was released, and I think I found something good on Steffen’s post Apache 2.4.7 available.

   I downloaded httpd-2.4.7-win32-VC11.zip (22 Nov) from the ApacheLounge for My Windows7 server. If you need the information about Apache 2.4.x configuration on Windows, see my post ‘To create a Wamp-like Web Server in Windows7-#1.‘.

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

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