Thursday, May 17, 2018

Check Duplicate Data on Google Spreadsheet

  No comments
May 17, 2018


How to check duplicate data on Google Spreadsheet. You can do it this step.


  1. Select Column
  2. Choose Format - Conditional Formating
  3. in Conditional Formating Choose formula cell if custom 
  4. put the code
    =countif(A:A,A1)>1
  5. A is column A, you can change the column
  6. and the duplicate data will be highlight with color you choose

Read More

Wednesday, May 16, 2018

How to remove permanently a path from the fish $PATH

  No comments
May 16, 2018

How to remove permanently a path from the fish $PATH. There is also $fish_user_paths, which is a universal variable (meaning it carries the same value across fish sessions and is synchronized across them). On startup and whenever fish_user_paths is modified, fish adds it to $PATH. If the offending directory is added here, execute set -e fish_user_paths[index] once (e.g. in an interactive session).
set -e fish_user_paths would remove the entire variable (while set -U fish_user_pathswould clear it) which would also work but would also remove all other paths.
just type on your terminal
set -e fish_user_paths
set -U fish_user_paths
Close your terminal and open again. that clear another path

Read More

Tuesday, May 15, 2018

How to set $PATH permanently in fish shell

  No comments
May 15, 2018

How to set $PATH permanently fish shell.

  1. type this in your terminal
    vim ~/.config/fish/config.fish
    
  2. add this code to fish config

    
    set --universal fish_user_paths $fish_user_paths ~/path/name/here
    
    
  3. restart terminal type your bin


Read More

Tuesday, February 6, 2018

How to Add Second HDD to Samba Ubuntu

  1 comment
February 06, 2018

At this time I will share how to Add Second HDD (Harddrive) to Samba, after your plug your HDD to PC.



1. Create directory for mounting HDD, i create on folder media and create folder MM002 for mounting HDD
$ cd to /media/{username}
$ sudo mkdir MM002
$ sudo chmod 777 MM002
$ sudo chown nobody:nogroup MM002
2. Cek your HDD with command 

$ sudo fdisk -l

3. make your hdd to be ext4 linux system with command
$ sudo mkfs.ext4 /dev/sda

4. Cek your HDD UUID, and edit fstab with nano or your text editor, i use sublime text editor
$ sudo mkfs.ext4 /dev/sda$ sudo nano /etc/fstab
or
$ sudo subl /etc/fstab

5. Add new line for your HDD new mounting

6. remounting your HDD and cek
$ sudo mount -a
$ df -h

7. You can double check in disk tool -> klik HHD -> klik gear icon.

8. Now we add HDD name to samba config
$ sudo subl /etc/samba/smb.conf

9. restart samba and restart ubuntu
$ sudo subl /etc/samba/smb.conf

10. done you can access new HDD with samba
 

Read More

Wednesday, December 20, 2017

Setup VPN PPTP on Ubuntu Server

  No comments
December 20, 2017

Because of the need for public static IP Address usage for connection to the japanese and ISP servers I use using dynamic IP. I am trying to create a vpn server digital ocean and get static ip for registering on japanese server whitelist. the use of this vpn can also be used to open sites that are blocked by isp. i will give a tutorial How to setup PPTP VPN on ubuntu server.

  1. Login root SSH to your server and install some package
    $ apt-get install ppp pptpd iptables
  2. configuration of PPTP IP ranges in server.
    $ vim /etc/pptpd.conf
  3. Then remove the '#' in the configuration file on the following line:
    #localip 192.168.0.1
    #remoteip 192.168.0.234-238,192.168.0.245
    to
    localip 192.168.0.1
    remoteip 192.168.0.234-238,192.168.0.245
  4. Configuration DNS Server
    $ vim /etc/ppp/pptpd-options
    find 'ms-dns' and change to
    ms-dns 8.8.8.8
    ms-dns 8.8.4.4
  5. Create Account
    $ vim /etc/ppp/chap-secrets
    add new line and create account like this
    # client    server  secret      IP addresses
    izor        pptpd   asd1234     *
  6. Configure NAT for PPTP connections, otherwise we can not connect to any of these servers
    $ vim /etc/rc.local
    add before line exit 0
    iptables -t nat -A POSTROUTING -o eth0 -j MASQUERADE && iptables-save
  7. Aktifkan IPv4 forwarding
    $ vim /etc/sysctl.conf
    uncomment or remove the #
    net.ipv4.ip_forward=1
  8. Reload konfigurasi
    $ sysctl -p
  9. Reboot your server and run this command
    $ service pptpd start
  10. Now you can setup your PC client to connect the VPN PPTP

Read More

Wednesday, November 29, 2017

Install PHP Imagick in Windows

  No comments
November 29, 2017

How to install php_imagick.dll in windows php. you need to know the exact version of your PHP. To do this: open a command prompt and enter these commands

Determine the PHP version:
php -i|find "PHP Version"

Determine the thread safety
php -i|find "Thread Safety"
You’ll have enabled for thread safe or disable for not thread safe

Determine the architecture
php -i|find "Architecture"
You’ll have x86 for 32 bits and x64 for 64 bits

PHP Imagick

after knowing your php version,  you have to download the dll of the PHP extension and the ImageMagick archive using the following table:

VersionThread Safe# of bitsEstensionImageMagick
5.5Yes32php_imagick-3.4.3-5.5-ts-vc11-x86.zipImageMagick-6.9.3-7-vc11-x86.zip
5.5Yes64php_imagick-3.4.3-5.5-ts-vc11-x64.zipImageMagick-6.9.3-7-vc11-x64.zip
5.5No32php_imagick-3.4.3-5.5-nts-vc11-x86.zipImageMagick-6.9.3-7-vc11-x86.zip
5.5No64php_imagick-3.4.3-5.5-nts-vc11-x64.zipImageMagick-6.9.3-7-vc11-x64.zip
5.6Yes32php_imagick-3.4.3-5.6-ts-vc11-x86.zipImageMagick-6.9.3-7-vc11-x86.zip
5.6Yes64php_imagick-3.4.3-5.6-ts-vc11-x64.zipImageMagick-6.9.3-7-vc11-x64.zip
5.6No32php_imagick-3.4.3-5.6-nts-vc11-x86.zipImageMagick-6.9.3-7-vc11-x86.zip
5.6No64php_imagick-3.4.3-5.6-nts-vc11-x64.zipImageMagick-6.9.3-7-vc11-x64.zip
7.0Yes32php_imagick-3.4.3-7.0-ts-vc14-x86.zipImageMagick-6.9.3-7-vc14-x86.zip
7.0Yes64php_imagick-3.4.3-7.0-ts-vc14-x64.zipImageMagick-6.9.3-7-vc14-x64.zip
7.0No32php_imagick-3.4.3-7.0-nts-vc14-x86.zipImageMagick-6.9.3-7-vc14-x86.zip
7.0No64php_imagick-3.4.3-7.0-nts-vc14-x64.zipImageMagick-6.9.3-7-vc14-x64.zip
7.1Yes32php_imagick-3.4.3-7.1-ts-vc14-x86.zipImageMagick-6.9.3-7-vc14-x86.zip
7.1Yes64php_imagick-3.4.3-7.1-ts-vc14-x64.zipImageMagick-6.9.3-7-vc14-x64.zip
7.1No32php_imagick-3.4.3-7.1-nts-vc14-x86.zipImageMagick-6.9.3-7-vc14-x86.zip
7.1No64php_imagick-3.4.3-7.1-nts-vc14-x64.zipImageMagick-6.9.3-7-vc14-x64.zip

Download the file properly and do it this way


  • Extract from php_imagick-….zip to the ext directory the php_imagick.dll file of your PHP installation
  • Extract from ImageMagick-….zip to the root PHP directory (where php.exe resides) the DLL files that start with:
    CORE_RL_
    IM_MOD_RL_
  • Add this line to your php.ini file: extension=php_imagick.dll
Restart your php and your server. Done. your php imagick  on windows has been active

Read More

Friday, November 10, 2017

Add Pemanently to the PATH on MAC OS

  1 comment
November 10, 2017

Sometime after you install binary, example composer and package from composer. You must add composer to PATH, so many tutorial export PATH but is temporarly. Then how to add the path permanent.

  1. open terminal and type
    sudo nano /etc/paths

  2. Enter your password, when prompted.
  3. Go to the bottom of the file, and enter the path you wish to add
  4. Hit control-x to quit. and enter Y
  5. Open new terminal and type
    echo $PATH
You should see something similar to this (including the path you’ve added!):
add composer to PATH
add composer to PATH

Read More