A little something about everything

internet marketing and website development made simple..

Solution for LOAD DATA INFILE errors on Windows with IIS

Several items that are likely setup incorrectly by default.

First verify you are using the latest thread safe version of php.

in your pnp.ini, verify you have enabled INFILE by uncommenting this line:

mysqli.allow_local_infile = On

(come back to this after everything is running correctly, as it's easier to check without path errors first) For heightened security you can also specify the file you want to allow LOAD DATA INFILE access to, uncomment the next line as well and specify the correct directory.

mysqli.local_infile_directory = "Drive:\path\tmp\assets"

Next verify you have enable INFILE access in your my.ini. You can specify a path or leave it blank to allow all.

secure-file-priv=""

Last step!
This is what most matomo on windows users get stuck on. By default, your website is usually running in an IIS AppPool permission setup like it should be. However MySQL runs under NETWORK SERVICE by default. In this case you need to add permissions for NETWORK SERVICE to your  \assets directory like this:

and give it read/write permissions like this:

Once this is done your System Check should be all good assuming you have no other issues to deal with.

3DM2 / 3ware Error: ERR_SSL_VERSION_OR_CIPHER_MISMATCH or Error Code: DLG_FLAGS_INVALID_CA

This is caused because the 3dM2 app is using a very outdated TLS 1.0 protocol.

To solve this you need to enable TLS 1.0 while accessing the local 3DM2 web GUI. You should change this back as it presents a large security risk as TLS 1.0 is easily exploited.

To enable TLS 1.0 while using 3DM2 go to "Internet Options" (Internet Properties on newer Windows OS), under advanced check the box for "Use TLS 1.0" then click apply. It's advisable to keep this window open so you remember to disable TLS 1.0 after you are done.

With Use TLS 1.0 checked you should now be able to access the 3DM2 web GUI for your 3ware raid cards using Internet Explorer mode in edge.

Then click more information and go on to the webpage

That's it, you're done.

 

Don't forget to turn off TLS 1.0 when you're done.

Quick Tip: if you've just installed 3DM2 and don't know your password it's 3ware, be sure to change it.

How to run Syncthing as a windows service, with a tray icon on login

First you will need to download the latest official syncthing application from github here:
https://github.com/syncthing/syncthing/releases 

 

Lets make syncthing run as a service on startup.

IMPORTANT!
Make sure you set a Syncthing GUI password to prevent other users from potentially accessing the console giving them full access to all files. 

Install nssm or another service wrapper. (instructions for nssm to follow)

https://nssm.cc/download 

copy the nssm.exe to the same folder as your syncthing.exe, for added security you can rename nssm.exe to something else.

Using nssm, you can open a command prompt and enter the following command:

cd [path to nssm.exe]

then run

You can replace SyncThingServiceName with whatever name you want to use for your service.
Replace {path} with the actual path to the exe.

nssm install SyncThingServiceName binPath= "{path}\syncthin.exe" start= delayed-auto

It should be setup like this:

on the details tab set the startup type to delayed start.

for the login on tab, in most cases you can leave this as the local system account unless you do not use a GUI password, in which case you will need to setup a specific user account that does not have elevated privileges to prevent a security breach.

!Critical, to prevent data loss or file corruption you need to set the shutdown timeout to 10,000ms. It should look like this:

Exit actions:

If you would like to set error logging or other settings you can do so now.

Click Install Service: 

Next, you need to set a few more final settings to handle upgrades, restarts and unexpected exits correctly. In a command promp enter the following commands:

nssm set SyncThingServiceName AppExit Default Exit
nssm set SyncThingServiceName AppExit 0 Exit
nssm set SyncThingServiceName AppExit 3 Restart
nssm set SyncThingServiceName AppExit 4 Restart

Don't forget to start the service or restart your system.

Finally, in order to add the tray icon, use the syncthingtray application from github here:
https://github.com/Martchus/syncthingtray/releases 

If using the full installer, you should start syncthing before running the installer in order to force it to use the latest version instead of the bundled version included with the package.

Use the first option during the setup and follow the guide.

In some cases the tray icon may not be able to connect because it's using the default path. After you restart, open the tray icon settings here:

Then under "connection" click here:

apply and it should connect.

Thats it, you're done.

How to increase the maximum number of pinned items on the taskbar in windows?

You can do this with a registry change, 

Whenever making registry changes be sure to do a full backup first, I am not responsible for your mistakes.

Open your registry editor (regedit)

goto 

Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Advanced

right click on advanced and add new DWORD value "JumpListItems_Maximum" and assign the desired value in decimal format.

In most cases you do not need to restart anything, if you would like you can restart explorer using the task manager.
open task manager: Ctrl+Alt+DEL select task manager and under the processes tab right click on "Windows Explorer" and choose restart.

That's it, your done.