Friday, September 4, 2020

Stop / hide up pcieport error in Ubuntu / Linux

 Number of ways  to try in grub:

  • pci=nomsi
  • pci=noaer
  • pcie_aspm=off

Actual steps:
  1. sudo vi /etc/default/grub
  2. Edit line:
    GRUB_CMDLINE_LINUX_DEFAULT="quiet splash pci=noaer"
  3. sudo update-grub
  4. Reboot machine

Restart / Reboot Linux


To restart Linux anytime: Hold Alt-SysRq (i.e. PrtSc) and type R E I S U B


Reference:

http://blog.kember.net/articles/reisub-the-gentle-linux-restart/

Friday, August 7, 2020

Console log freezes / hangs in Eclipse

Sometimes your Eclipse console log becomes very jerky, freezes or even hang up.

It's very likely that your console log got something which is very long without word warp. It can even causes Windows itself becomes freezing too!

So make your console "Word wrap". Or set a width limit on the console in Eclipse preference. The problem will be solved.

SQL Developer installation in Windows 10

 Quick suggestion for getting the SQL Developer to work in Windows 10:

  1. Get the SQL Developer (with JRE) edition. I got bad experience when getting SQL Developer to work with my own JDK 1.8 installation in Windows 10. No matter where I copy the MSVCR100.DLL (It always said JAVA_HOME\jre\bin\msvcr100.dll cannot be launched, crazy). So, just get the "with JRE" version.

  2. The font size are crazily small on a high DPI screen. So get a larger font, right-click on the "sqldeveloper.exe", choose "Compatibility > Change high DPI settings > High DPI scaling override > System (Enhanced)"
    (Reference: https://christian-gohmann.de/2018/10/25/running-sql-developer-on-high-dpi-screens/)

Friday, July 24, 2020

Command line to stop Windows 10 updates

To stop Windows 10 updates:

> net stop wuauserv
> net stop bits
> net stop dosvc

Resume it:

> net start wuauserv
> net start bits
> net start dosvc

Sunday, July 19, 2020

Friday, July 17, 2020

Add git information to your bash prompt

To show git information in your bash prompt, add the following function in your ~/.bashrc

function git-shell() {
  export GIT_PS1_SHOWDIRTYSTATE=1
  export PS1='\[\033[01;33m\] (git) \[\033[01;34m\]\w$(__git_ps1 " \[\033[01;32m\](%s)")\[\033[00m\]\n\$ '
}

Then, in your bash, run "git-shell" and you will get a nice git prompt:

 (git) /path_to_your_git_project (master *)
$ 

Wednesday, July 15, 2020

curl returns "ssl_choose_client_version:unsupported protocol" error in Ubuntu 20.x

If you encountered "ssl_choose_client_version:unsupported protocol" when using curl in Ubuntu 20:

    $ curl https://somehost/
 
curl: (35) error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol


It may because the "somehost" only accepts old protocol (e.g. TLS v1, etc.), but in Ubuntu 20.x, the OpenSSL assumes minimum = TLS v1.2 by default. 

If the "somehost" just cannot upgrade to TLS v1.2, you might consider fixing it with the following:

1) Modify /etc/ssl/openssl.cnf

Search for the line "oid_section = new_oids"

Add the following lines below it:

openssl_conf = default_conf

[default_conf]
ssl_conf = ssl_sect

[ssl_sect]
system_default = system_default_sect

[system_default_sect]
MinProtocol = TLSv1.1
CipherString = DEFAULT@SECLEVEL=1

2) curl "somehost" with the following parameters

$ curl --tlsv1 https://somehost

3) If the "somehost" just using a self-signed certificate

    $ curl -k --tlsv1 https://somehost

Reference:



Tuesday, June 30, 2020

SQL Developer JavaFX problem

When running SQL Developer in Linux, you may encounter the "JavaFX" problem stating that the JavaFX libraries / components are not found. To solve this issue, you can consider the following solution:

  1. Install SDKMAN
  2. Use SDKMAN to install either "OpenJDK 11" or "Zulu JDK with FX"
    • sdk install java 11.0.7-open
                OR
    • sdk install java 8.0.252.fx-zulu
  1. Check the SQL Developer "product.conf" file to make sure the correct JDK is used.
    • ~/.sqldeveloper/<version>/product.conf
    • SetJavaHome /path_to_java_home
  2. If you just comment out the "SetJavaHome" variable, then the current JDK you use will be used with SQL Developer.
Enjoy!

Wednesday, May 20, 2020

Tab key not working in tmux

Add the following to the .tmux.conf:

    unbind -n Tab

Wow, TAB is back!

Upgrade nodejs in conda (from v18 to v26)

If your conda env is nodejs v18, doing a conda install nodejs=26 is likely to create a lot of conflict. Consider remove those conflicting p...