BI Report Tools

Our database has more then 42 millions records. We need to create reports for different roles.
I prefer opensource BI since we can build the website on our own server and access data directly.

Read More

How to install pip on Ubuntu 16

  1. Upgrade packages to the latest version
    sudo apt-get update && sudo apt-get -y upgrade
  2. Install python-pip
    sudo apt-get install python-pip
  3. Check version
    pip -V
Read More

CIFS Samba mount hangs for several minutes


Add a network share folder in /etc/fstab

//windows-server/shared /mnt/shared cifs  iocharset=utf8,credentials=/root/.naspasswd,dir_mode=0750,file_mode=0750  0 0

Most time it works well. But every few days or weeks, the connection or the mount point seems to go dead or hang, such that any process that tries to access the mount point gets stuck in D state (disk, or I/O wait). those processed become impervious to TERM and KILL signals. The frozen state lasts for 5+ minutes.

Read More

Install Ansible on Mac OSX

Brew Install

  • Install Homebrew if there is no brew.
    /usr/bin/ruby -e "$(curl -fsSL"
  • Install Ansible
    brew install ansible
Read More

McAfee Installation Process Hung

When I installed McAfee Antivirus Enterprise v8.8 on a Windows 8.1, it was hung. Checked the log @ c:\users$user\AppData\Local\Temp\McAfeeLogs and found a messge “Waiting on McShield to report RUNNING or STOPPED (current state 2)” in installation log.

Read More

Force Removing Windows Services

Some services are denied administrator to access on Windows such as McAfee services. I don’t know why administrator cannot manage every thing on Windows system. I think vrius maker and hacker already know this technology. How does administrator fight with them?

Read More