User of mysql/mariadb for wordpress

Today, I followed a guild to deploy a database using mysql and mariadb for wordpress instance. It failed in a strange way: I can use the user I created for the database to login from bash using mysql command, but wordpress reports access denied.

After a long time digging, the problem is solved:

Creating an account in database for wordpress, “mysql_native_password” is required to be specified, like CREATE USER [email protected] IDENTIFIED WITH mysql_native_password BY 'password'.

Generate password node for SoftEther config file

Recently, I wrote an C# project for connect all devices from clients of my company to the server for remotely fault detection. SoftEther is chosen for underlying network solution.

The maintenance engineers don’t want to use the GUI of SoftEther to create profiles for each clients. A project is required for generating config files.

The only problem is how SoftEther store the password. I dig a lot and got the answer.

  • Password is encrypted by SHA0 on password + USERNAME in capital.
  • NTLM related password is encrypted by MD4.


Here is the password node generating project, based on C#, dotnet core 3. Actually, the code is tested on dotnet core 2 and netfx 4 also.

Fix Catalina Beta boot cache problem (Little Snitch related)

If your app need to modify boot caches on macos, like Little Snitch, it may fail on macos Catalina beta version after macos updated from Software Update due to system bug.


Some app, like Little Snitch, need to update boot caches while installing. But due to bug introduced by Software Update of Catalina beta, it may fail. After reboot, you will get an error like “version mismatched” reported by Little Snitch.


To fix that, you need to boot into the recovery mode (CMD+R while booting), unlock your hard disk if you enabled FileVault, start Terminal from menu and enter:

touch /Volumes/<Volume>/System/Library/Extensions

and press enter. <Volume> is your hard disk volume. You can use ls /Volumes to check all mounted volumes.

This command will finish very fast. After it run, wait about 10 seconds and restart your computer. This will fix the boot cache problem.



GPIO support is not fully launched in dotnet core 3 currently

I’m developing using dotnet core on Raspberry Pi.

After the dotnet core 3 launched finally, I rushed to the released version from the preview one. Some package I used, like System.Devices.Gpio, was published in dotnet-corefxlab under myget. Now I can find it on nuget.

But, sadly, the current version of System.Device.GPIO (not Devices, but Device) in nuget seems contains only abstract classes. The UnixSpiDevice, GpioPin and something useful are missing in the version of nuget. Now I have to turn back to use the preview version on myget.

Good thing to know is, the preview version of Gpio supports dotnet core 3 with no problem.

Latest Chrome Dev version crashed on macOS Catalina DP 5


I’m using Chrome from developer channel for a long time on my macOS.
Since August 14th, 2019, after an auto upgrade of the Chrome, it cannot be launched again. When starts, it shows a empty window with only 3 common color dots at the top left corner and then halt.

Tried rebooting and reinstalling, the problem cannot be fixed.

Currently, I turned it back to the stable channel, which works well.

Sorry that I cannot provide the version number of the affected version, which I cannot get without start it.

Update: In DP6 (19A536g), Chrome Dev version is working well now.

MSDN Magazine

It says MSDN Magazine is ending soon.

Here is the MSDN Magazine collection hosted on my OneDrive. Password is “” without quotes.

All files are mainly downloaded from official site. The missing (2018 Jan / Connect) and not published (2019 June / July) are from my received emails (subscribed version). I will update the rest when they are published.

I attached some main tech involved at the file name.


The final issue of MSDN Magazine is published.


The issues listed below are replaced by the versions from emails due to reason specified.

  • 2018 Jan version: Wrong link to 2017 Jan.
  • 2018 Connect(); Missing link
  • 2019 July: 404 link
  • 2019 October: Not published yet.
  • 2019 November: Not published yet.

Bug and workaround in dotnet MEF — The export is not assignable to type .

Today, while writing an app use netfx 4.8 with MEF support based on System.ComponentModel.Composition 4.5 from nuget, a strange bug hit me.

Because I’m not treat MEF as essential, I’d like to write the main code in a project and create MEF wrap in another one like:

  • In Project A: class Real : InterfaceA
  • In Project B: class MEFWrap : Real, and marked with Export attribute.

Certainly, Project A is referenced by Project B.  While building the solution, both dlls generated from Project A and Project B are placed in the output folder of Project B.

While trying to use MEF to load the class from Project B, the funny thing happened:

  • If AssemblyCatalog is chosen to create the object, from the assembly object loaded by LoadFrom method, nothing is wrong, but
  • If AggregateCatalog is used with all assemblies loaded from the folder (Project A and Project B) at the same time, an exception raised while calling ComposesParts:

    The export InterfaceA is not assignable to type InterfaceA.

I don’t know why it’s happened but here are 2 ways to get avoid of it.

  • Only load assembly Project B, not both of them, if it’s possible, when you know the name or name pattern while searching files, or
  • Using AssemblyCatalog for each file, instead of using AggregateCatalog as a whole, will also works.