Leave task running after logging out from SSH

Assume you are logged in to a remote server via SSH and are running a task which takes longer to complete than you want to wait.

The straight-forward option would be to terminate the task and re-run it at a later time, but that is not always an acceptable option.

Instead you can send the active task to background and leave it running even after you log out.

  • Press Ctrl-Z to pause the task
  • Type bg to send it to the background and resume running
  • Type disown to disassociate the process with your SSH login, so that it does not terminate when you log out
  • Type exit to log out

Ref.:[1]

Advertisements

MySQL throws import error with TYPE=MyISAM

So you are attempting to import SQL data from an ancient dump file and it fails with an error:

  • You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TYPE=MyISAM’

This is due to an obsolete syntax. Fixing it may be quite easy. Just open the file in an appropriate text editor,  run search and replace, and save it:

  • search for: TYPE=MyISAM
  • replace with: ENGINE=MyISAM

Shipping tab is missing in WooCommerce

The Shipping tab is supposed to be between the Tax and Payments tabs in:

  • WooCommerce -> Settings -> Shipping

But it is not there?!

Check the parameters in

  • WooCommerce -> General

You may have

  • Shipping location(s)

set to

  • Disable shipping & shipping calculations

Just change it to something else and the missing tab will appear.


Kill a process from the command line in Windows

You can kill (end, terminate) a process (task, program, application) in Windows in a way that is similar to the way it is done in Linux.

Start cmd.exe, e.g.:

  • Start -> Run -> cmd

In the terminal window that pops up at the prompt type:

  • tasklist

Look for the PID of the process you want to terminate and use the following command to ask it nicely to quit:

  • taskkill /PID <your PID here>

If you were lucky, the process will terminate. If it doesn’t, use force:

  • taskkill /PID <your PID here> /F 

FontAwesome icons do not show up

You may experience a situation where FontAwesome icons used in styling of your page with Bootstrap CSS fail to show up. Everything seems fine, you may even have them working perfectly well in your development environment, but then stubbornly refusing to display in the production environment.

The first thing to do is to check if you are using the same protocol for requesting the CSS as you are using for serving your page. If you are serving the site over HTTPS but will attempt to request the CSS via HTTP, you will get the “Mixed Content” error and the CSS will be rejected by the browser.

In such cases a message can be seen in Chrome’s console similar to this one:

Mixed Content: The page at ‘https://www.example.com/&#8217; was loaded over HTTPS, but requested an insecure stylesheet ‘http://maxcdn.bootstrapcdn.com/font-awesome/4.1.0/css/font-awesome.min.css&#8217;. This request has been blocked; the content must be served over HTTPS.


See differences between PDF files

A very convenient tool to visually display differences between two PDF files is diffpdf.


Multiple domains sharing one Nextcloud installation

You may easily have access to your Nextcloud via multiple domain names, e.g. cloud.myname.com and cloud.myname.org.

Set up virtual servers as you normally would and either configure them both to use the same WWW document root directory or create symbolic links to the initial directory as needed.

Do not forget to add all these domains to the trusted_domains section of config/config.php file in the Nextcloud directory, like:

‘trusted_domains’ =>
array (
0 => ‘cloud.myname.com’,
1 => ‘cloud.myname.org’,
),