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.

o6asanforum2.starfree.jp → o6asanforum2.starfree.jp
o6asanforum2.starfree.jp/en → 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
WordPress

A redux folder.

同一記事の日本語版

   This morning, I was surprised with a redux folder whose time stamp is Nov.13 @15:05:11. I found it in WordPress wp-contentuploads folder. Why does the folder exist? Why???
   I checked files up on my site and I realized it was not a suspicious folder but given by the plugin AMP for WP – Accelerated Mobile Pages.
   I felt relieved. Hey, o6asan, you always need to read the ChangeLogs!!

Categories
WordPress

How to connect to MariaDB secure server from phpMyAdmin and WordPress.

同一記事の日本語版

   After “MariaDB with Secure Connections.”, my SQL server has Secure Connections. Now I have to add some options to phpMyAdmin and WordPress settings.
   Their versions are MariaDB 10.2.9 win 32-bit, phpMyAdmin 4.7.4 and WordPress 4.8.2 on Windows 7 32-bit HE SP1.

Categories
WordPress

Jetpack gives a good thing but it is too much for me.

同一記事の日本語版

   I found a link that is something like “hxxps://i2.wp.com/test.o6asan.com/img/xxxxx.jpg?ssl=1” on the WordPress access log. I went to the page for checking the link. Yes, it was there. But, I couldn’t find such a link from the editor on my WordPress Dashboard. I could see the link “hxxps://test.o6asan.com/lmg/xxxxx.jpg”, though.

Categories
Vulnerability WordPress

Attacks against WordPress 4.7 or 4.7.1 are still increasing.

同一記事の日本語版

   Still increasing. Do updating you WordPress ASAP. I read some articles and also got an email about this from my ISP. So I’m writing this.

   I talked about this with くりくりさん on Twitter. I first mentioned it on February 6. It was because of my finding a 徳丸’s post, “WordPress 4.7.1 の権限昇格脆弱性について検証した”.

   Yesterday, Security Next told us some IP addresses about attackers. I checked up on my log last night. I found an access from one of questionable IP addresses, which was on February 6. It caused 500 error on my server. Maybe because my WordPress was already version 4.7.2 at this point.
   Its user-agent is python-requests/2.11.1 and its destination is /wp-json/wp/v2/posts/.

   WordPress 4.7.2 was released more than a week ago, and WordPress has an auto-update feature enabled by default, along with an easy manual update process. Despite this, this situation. It’s indeed disappointing.

Categories
WordPress

From WP Mail SMTP to PostmanSMTP.

同一記事の日本語版

   Recently, I had an email from YAHOO!. Its subject is “Secure your Yahoo account”. I think this is maybe related to “Yahoo hit in worst hack ever, 500 million accounts swiped”. Because …

Categories
WordPress

WordPress4.6 has come.

同一記事の日本語版

   Actually, I failed once. My Web Browser status bar told ‘done’, but the progressing page showed only two lines. Besides, the update marker didn’t have gone. So I tried again and had ‘Another update is currently in progress’.

   I accessed via FTP but couldn’t find .maintenance file. I looked for a solution on the internet and reached ‘Get rid of Another update is currently in progress’.

Categories
WordPress

About ‘Embed Everything’ of WordPress 4.4.

同一記事の日本語版

   WordPress4.4 has new features called ‘Embed Everything‘. Actually it means that WordPress becomes an oEmbed provider, Wow! So we can embed our posts on other WordPress sites now. Of course, this is possible between your own WordPress sites. Only thing you need is drag & drop or paste URL on edit area of the post. Like this.