Categories
WordPress

Moving “o6asan’s BBS”.-#2

I made a box, so I prepare the contents.

Theme and Plugins.

The theme is the WordPress official, Twenty Twenty-One, I took. I did “NetWork Enable”. When it isn’t customized, it is very very simple look.

The plugins I put in before preparing the contents are as follows. Akismet is already in. I initially set the following four to “NetWork Enable”, but in the end, I enabled them for each site. Because I decided to merge my old Perl posts to this WordPress.

  1. bbPress
  2. bbPress Notify (No-Spam) It’s new for me. I used bbPress Notification before.
  3. GD bbPress Attachments
  4. Content Aware Sidebars

Database export and import.

Access the old MySQL with phpMyAdmin (from a browser’s URL bar) and export 8tables, commentmeta, comments, postmeta, posts, termmeta, terms, term_relationships and term_taxonomy for each site. This is for each site, so 16 tables in this case.

Replace the following two URLs in the exported files.

o6asanforum.webcrow.jp → o6asanforum2.starfree.jp
o6asanforum.webcrow.jp/enforum → o6asanforum2.starfree.jp/en

Replace the following to change the engine from MyISAM to InnoDB.

ENGINE=MyISAM → ENGINE=InnoDB

Replace character set from utf8 to utf8mb4 and collation from default to utf8mb4_unicode_ci. Well, around here, I just wondered if utf8mb4_unicode_ci is good or utf8mb4_unicode_520_ci is good for the Japanese blog.

DEFAULT CHARSET=utf8 → DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Access the new database with phpMyAdmin in the server administration tool, drop 16 destination tables, and import the old files I customized earlier.

A work after importing.

Both Japanese and English sites,
Go to “Settings” >> “Reading” to set the front page.
Go to “Appearance” >> “Menu” and set the imported menu as the primary menu.

I had trouble with the plugin Content Aware Sidebars.

Twenty Twenty-One doesn’t have a default sidebar. Originally I used a theme with a sidebar, so right after I imported the database, the old sidebar I looked there. After all, I decided to display the original sidebar items in the footer, but I had trouble with the work because the interface of Content Aware Sidebars had been very changed.

I forgot about media files.

Upload the saved images etc. to the wp-content/uploads using WebFTP of the server management tool. Nowadays, WordPress default has each date directory for files, but the olders haven’t had such directories, so leave it as it is.

For uploading images on the sites.

I used GD bbPress Attachments before, because bbPress doesn’t have an image attachment function. Now I use again. I customize the two filters in gd-bbpress-attachments/code/class.php as follows so that visitors can use them without registering as a user.

return apply_filters('d4p_bbpressattchment_is_user_allowed', $allowed);
     ↓
return apply_filters('d4p_bbpressattchment_is_user_allowed', true);


return apply_filters('d4p_bbpressattchment_is_hidden_from_visitors', $value == 1);
     ↓
return apply_filters('d4p_bbpressattchment_is_hidden_from_visitors', false);

I do the same for my old Perl posts.

Note that when I downloaded the media files, I pulled them with Internet Explorer. I don’t know why but I couldn’t connect to the directory with the newest FileZilla. Security reason or something? IE I used is a new one on Windows10.

Publishing the sites and setting Redirect permanent for the root .htaccess of the old sites.

Redirect permanent /enforum/ http://o6asanforum2.starfree.jp/en/
Redirect permanent / http://o6asanforum2.starfree.jp/

By the way, at 『フリー WP』 I can access the wp-content folder only. I cannot use a .htaccess nor HTML meta tag neither. So I announced my moving on each old Perl post. Hehe.

That’s it. 😊

同一記事の日本語版

Categories
WordPress

Moving “o6asan’s BBS”.

Hehe, it’s been almost a year since my last post.

I received a notification email from Netowl on 2021 Sep.2. It said, “the services 『ウェブクロウ』 and 『フリー WP』 will be terminated at noon on 2022 Mar.31.” I was wondering the services would not continue from quite before, because they didn’t update PHP from 7.1.2 to newer.

Well, they say the deadline for accessing my WordPress source files and database is at noon on 2022.9.30. As I have o6asan’s BBS on 『ウェブクロウ』 and my old Perl’s posts on 『フリー WP』, I should do something for fixing them.

I tried a bit of this and that, in the end I decided to use the PHP/MySQL supported plan on 『 スターサーバーフリー』.

Easy installation by the PHP/MySQL supported plan on 『スターサーバーフリー』.

They offer an easy installation of WordPress by the server management tool, so I use it first.

It seems that the easy installation will do what is explained in the URL below. I installed it in the blog directory created under root.

Ref URL : https://wordpress.org/support/article/how-to-install-wordpress/

When you access the dashboard, you will have a instruction if you want to hide /blog directory from the site URL, so do it before converting to NetWork.

Also reconfirm the permalink settings at the same time.

So, the URL of new o6asan’s BBS is http://o6asanforum2.starfree.jp/en/. The PHP version becomes 7.4.25 and 8.0.x is also possible, but the free server does not support https this time either.

I think it’s easy to hide the WordPress dedicated directory from the URL, but I’ll just give the following URL for you.

Ref URL : https://wordpress.org/support/article/giving-wordpress-its-own-directory/#method-ii-with-url-change

Make it NetWork for a multi-site WordPress.

Step1 If you want to hide your WordPress dedicated directory from the URL, confirm the above changes before making it NetWork.

Step2 Access wp-config.php by FTP tool (WebFTP is offered by the server management tools of 『スターサーバーフリー』). Add the following lines to the specified position and save the overwriting.

/* Multisite */
define( 'WP_ALLOW_MULTISITE', true );

Refresh the browser.

Step3 Go to “Create A Network” of Tools in the dashboard admin bar. Check the displayed contents and install.

I feIt troublesome of cecking 『スターサーバーフリー』 server settings, so I decide to go with the sub-directories type this time again. Because the previous free service was okay there, so I took easy path. 😅

Step4 Use WebFTP. Edit and save wp-config.php and .htaccess in the root directory as instructed. Follow the login link of the displayed page on the browser, and log in again.

When overwriting, replace the displayed code with the code between # BEGIN WordPress and # END WordPress in .htaccess.

If you make a mistake in this edit, you might get “too many redirects”. In my case, as I had this message and could not access the dashboard after adding another site, I was very confused.

Step5 Add o6asan’s BBS of English.

I forgot to say. Keep both sites private during this work.

Network actibate Akismet.

Activate Akismet plugin on your network from Site Network Management. After that, go to Akismet settings from the plugin settings of each site and enable it. In my case, I have an API key that I have been using for some time, so I used it to activate.

I made a box. Now, I’m ready.

同一記事の日本語版

Categories
WordPress

I completed my WordPress to Sub-domain.

About a week ago, I finally started to renew my sites, which I had been announce “it’s under maintenance” since the end of July, but honestly speaking I did nothing until last week. Now I will start temporary operation as of the end of September, today. 😅😅😅

For the time being, I was able to change from the Sub-directory of Multisite of WordPress, which is the main purpose, to Sub-domain, but there are various leftovers.

After the support for Windows 7 ended in January, I switched to Web server operation on Windows 10. But at that time I moved the whole sites without touching anything in particular, also I’ve stopped my new articles since the beginning of last year.

I would like to write articles about reconstructing my new server, but I cannot promise “when?” because of my real life problems. I would appreciate it if you could wait patiently.

同一記事の日本語版

Categories
everyday life

Happy New Year!

   Happy New Year! It is the beginning of a new year.

   This is a year of 亥, according to the Oriental Zodiac. 亥’s Kun-reading (訓読み) is ‘inoshishi’.

   We call ‘inoshishi’ ‘boar’ in English. Boars on the image was made by my 95 year old aunt who made this for New Year celebration!

   I wish you guys Happy New Year.

   Gods bless you, guys!

Categories
Windows

My Web server supports TLSv1.3 now.

TLSv1.3   Apache 2.4.37 from Apache Lounge supported TLSv1.3, so I enabled TLSv1.3 on my Web server which runs on Windows7 HP SP1 32-bit. I only changed from SSLProtocol -all +TLSv1.2 to SSLProtocol -all +TLSv1.2 +TLSv1.3. I did nothing about SSLCipherSuite Directive because the SSL_CTX_set_cipher_list page says ‘An empty list is permissible’.
The default value for the this setting is: “TLS_AES_256_GCM_SHA384:TLS_CHACHA20_POLY1305_SHA256:TLS_AES_128_GCM_SHA256”

   Here is the results before and after of SSL Labs Server Test.

同一記事の日本語版
Categories
everyday life

I made an external 1seg antenna for SC-02H.

I made it without understanding, but I think I got some good results, so I’ll write a post about it for my memorandum. What is it? It is an external 1seg antenna for SC-02H. Why did I make it? Actually, I want to watch Fukuoka SoftBank Hawks games on my way to and from go swimming.

Categories
Windows

phpMyAdmin uses Twig by default from the version 4.8.0.

   I updated phpMyAdmin from 4.7.9 to 4.8.0 the day before yesterday. Although they wrote that ‘it is possible to install phpMyAdmin from our own Composer repository.’ on the official download page, I still uses the manually installation in my own way. After updating, I was surprised with a folder named tmp in my phpMyAdmin root directory. But it’s not a malicious but a proper one by phpMyAdmin.

Categories
everyday life

The director of ‘Hotaru no haka’ Takahata Isao (高畑勲) passed away.

   On Apr. 5 in Japan time, the director of ‘Hotaru no haka’ Takahata Isao (高畑勲) passed away at the age of 82.
   One of my articles of a very early time was about ‘Hotaru no haka’. My very first comment in English was maybe about ‘Hotaru no haka’ on IMDB. It was around 2005.

   May his soul rest in peace.

Categories
everyday life

My server have been down for about eight hours.

   I noticed I could not access the Internet from my house around 8 am. I checked my environment and found it was my router fault. After my ISP maintenance, it could not reach the Internet properly. The ISP told me this might be occurred, though. I rebooted the router and all works well now.

同一記事の日本語版
Categories
Windows

Hey MSE, why did you make me panic? It told Apache files are Trojan:Win32/Critet.BS.

Update (Mar.22):

   Today, I’ve updated Apache from 2.4.32 to 2.4.33. Now, MSE says all files are clean. What was that alert? Really compromised or not? Anyway, I backed the MSE settings to the default.

   This morning Microsoft Security Essentials suddenly told Apache files are Trojan:Win32/Critet.BS and quarantined them, so Apache stopped on my server PC whose OS is Windows7 HE SP1. Although I needed to recover the service immediately, I had to take my mother to a hospital. Therefore the service must have been unavailable for about an hour.