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

Installing fonts locally in Linux

You can simply copy the font either as separate .TTF files or as a whole directory named after the family of the font, into the hidden directory .fonts inside your user’s home directory.

Then, if you want to start using the new font immediately, do rebuild the font cache with the command:

  • fc-cache -f -v

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.


Enabling PostgreSQL server at startup

To have PostgreSQL server start automatically at boot do:

  • sudo systemctl enable postgresql