Categories
Windows

On my home network, I’ve built an FTP server that I left for long time.

After a long time, when I checked broken links and fixed them, I got an error about the size of the uploaded file. I haven’t changed the setting in php.ini about file sizes from before. I thought why. At sometime in the past I set them as below, because I wanted to prevent large files uploading from someone.

post_max_size = 8M
upload_max_filesize = 2M

So I built an intra FileZilla server with FTP over TLS, and I used it for my articles’ images.

I haven’t noticed this trouble until now, which tells me that I didn’t do anything other than updating server software after changing to a Windows10 server. 😅

So, at this time, I’m going to build a FileZilla server.

Step1 Download a FTP server software from FileZilla site. FileZilla Server Download

Step2 Install the downloaded program on the server machine. I left the default except for the installation directory.

Step3 FTP Server / Security settings.

I am using the Let ’s Encrypt certificates for my web server, so I will also use them for the FTP server. The key.pem and cert.pem are in the md directory of Apache.

FTPS setting for Local
Repositioning of Security tag

Addition: Today (2022.Feb.20), I noticed that FileZilla Server was updated to 1.3.0, and Security Tag location was replaced into Administration area.

Ref URL : Let’s encrypt – how?

Step4 Set users. But only me this time again. I also set a password for accessing as a client.

Step5 AS I need a permission by Windows10 Firewall, I go to “Windows Defender Firewall” >> “Allow apps or functions through Windows Defender Firewall” from Windows10 Control Panel. Now “Allow another app” button isn’t grayout, so click it. By the “Browse”, add filezilla-server.exe of the FileZilla Server folder.

Ref URL : The method about Windows 8 is written at the bottom.

Well, that’s it.

By the way, I got the following errors on the server log, when I disconnected as a user from Client Software.

I mention the four lines of the bottom.

After surffing the Internet, I find out Trac has a comment from Tim Kosse that is ” Completely harmless, safe to ignore if there is no ongoing activity. I’m looking into a way to suppress these messages during periods of no activity.”

My FileZilla Server is on Windows10 Home x64 version 21H1 19043.1348 and version 1.1.0.

FileZilla Client version is 3.56.2.

同一記事の日本語版

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

Categories
Windows

A batch file of VLC for hardcoding subtitles to each mp4 on Windows.

   Recently, I needed to merge some mp4 files and srt files. If you only need to merge, it is very easy way you have. That is to use MP4Box. But I needed a hardcord subtitle version this time. I think MP4Box cannot give this type. Am I right? Anyway I couldn’t create a mp4 file with a hardcord subtitle by MP4Box, so I was searching for information and found this out on YouTube. It’s very nice. But, this time I had mp4 files more than twenty and have to set this about each mp4 file if I use VLC GUI. It’s very inconvenient. So I wrote a batch file as below.
   For VLC batch file transcode information, see Transcode – VideoLAN Wiki.

Categories
Windows

From dehydrate to mod_md, Let’s Encrypt Tool.

同一記事の日本語版
Update information      Edit(Nov.16)  Edit2(Nov.30)

   Early this morning, I changed Let’s Encrypt Tool from dehydrated to mod_md. On August 17, Steffen announced “mod_md is available for 2.4.27 VC15”. I did nothing about it though I became curious, because I was busy and I already used ‘dehydrated’. But the day before yesterday, I found “ACME Support in Apache HTTP Server Project”. So I decided to use ‘mod_md’ yesterday.

Categories
Windows

MariaDB with Secure Connections.

同一記事の日本語版

   These days, I was working hard about using MariaDB with Secure Connections. First, I did SHOW VARIABLES LIKE 'have_ssl'; and got this:

+---------------+----------+
| Variable_name | Value    |
+---------------+----------+
| have_ssl      | DISABLED |
+---------------+----------+

   DISABLED means that the server was compiled with TLS support, but was not started with TLS support. So I can use MariaDB with Secure Connections on my server.

Categories
Windows

A very beginner for Visual C++ with CMake.

同一記事の日本語版

   Yesterday, I installed Visual Studio Community 2017 for learning Visual C++ with CMake. Why did I decide to learn Visual C++? Because I want to compile Apache Dev version for Microsoft Windows. The page says httpd can be built on Windows using a cmake-based build system. Besides, Visual C++ Team says they can support CMake in Visual Studio 2017 easily and CMake Team does CMake version 3.7 or higher are compatible with Visual Studio 2017. The time is very good. I decided to learn Visual C++ with CMake.

Categories
Windows

Moving to MariaDB10.2.

同一記事の日本語版

   Yesterday, くりくりさん told me MariaDB 10.2 became GA by his tweet. So I moved to MariaDB 10.2.6 last night.

   About upgrading procedures, there was no troubles. See “Updating to MariaDB 10.0.11” about HowTo.

Categories
Windows

I updated CF-J10 and NJ2100 to Redstone2.

同一記事の日本語版
Update information      Edit(Jun.13)

   On May 10, I updated CF-J10 and NJ2100 to Redstone2 manually. ‘manually’ means I accessed Download Windows 10.
   You think my NJ2100 did not work anymore.
   Yes, it was into that status once. I wrote about it. But the laptop came back to me after I did not give no energy to it for a long long time. If I had cleared the CMOS, I would have been able to use NJ2100 earlier than in reality. Actually, I wasn’t able to reach the on-board battery. Anyway, the NJ2100 works well now.

   After updating I had the same troubles with them when I updated to Redstone1, but they are still alive. This is very good for me.

Edit(Jun.13):
   Today, I’ve found Cortana back after Windows Update. Besides, Start Menu is disabled if I kill Cortana, and Colrtana is back if I fix Start Menu malfunction. Umm. I give up against fighting for Cortana at this point.