Category Archives: Software

Sotfware is program that made by human to help them work easier.

How to add Title on Adobe Premiere Pro

Adding title / teks in the middle of your video can be done simply by pressing CTRL + T button on Adobe Premiere Pro ūüôā

Adobe Create Title name Window
Adobe Create Title name Window

After pressing the button title window will appear and let you insert text and modify some parameter such as position, font, font-size, colour, and text alignment.

Adobe Premiere How to Add Title, Modify Title Window
Adobe Premiere How to Add Title, Modify Title Window

After you finish, just simply close the window, and the title object will be available on your media browser toolbox, select it, and do some drag and drop to your movie sequence.

Adobe Premiere How to Add Title, create title window
Adobe Premiere How to Add Title, create title window

That is how to add titile on adobe premiere pro ūüôā

Pokemon Go Banned Bot

Yesterday to keep update with niantic pokemon go feature i tested bot software released on the internet. This bot is very easy to use since it only requires us to do little setup in file configuration, after this little setup, bam!, the bot is running. The bot is accepting PTC & Google login.

This bot was running well with around 20k exp/hour, as i set this bot to farm in some place in tokyo, japan. However this morning i saw error message displayed in bot command line interface saying “softban”. As you expect from bot, it also has unban methode which can be done by spinning pokestop 45 times. But after bot trying to remove the softban using this method, the softban notification sunddenly appeared in cli error message, again. Actually im hoping that niantic begin to take bot user & spoofer seriously. Since many players missuse this bot to occupy gym, rather than simply doing research.

Softban in Bot
Softban in Bot

i think bot that occupies most gyms right now is the most annoying thing we can find in pokemon go. Niantic should proceed this further and faster and i hope this softban message is the result of a new patch done by niantic before they do the ban wae. Let’s hope for the best :).


how to change default network interface in linux

how to change default network interface in linux,
how to change network interface priority in linux,

to install ifmetric in linux use this command

sudo apt-get install ifmetric

it happened when i want to change my wlan as default network interface in raspberry pi. i have two connection

  1. LAN connection = eth0
  2. Wifi connection = wlan0
pi@raspberrypi:~ $ ifconfig
eth0      Link encap:Ethernet 
          inet addr:  Bcast:  Mask:
          inet6 addr: fe80::5df2:5b0c:8062:b551/64 Scope:Link
          RX packets:1194121 errors:0 dropped:77 overruns:0 frame:0
          TX packets:116003 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:1428192778 (1.3 GiB)  TX bytes:10600602 (10.1 MiB)

lo        Link encap:Local Loopback
          inet addr:  Mask:
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:65536  Metric:1
          RX packets:200 errors:0 dropped:0 overruns:0 frame:0
          TX packets:200 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:16656 (16.2 KiB)  TX bytes:16656 (16.2 KiB)

wlan0     Link encap:Ethernet 
          inet addr:  Bcast:  Mask:
          inet6 addr: fe80::8751:b941:7c96:a41/64 Scope:Link
          RX packets:35 errors:0 dropped:0 overruns:0 frame:0
          TX packets:27 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:4143 (4.0 KiB)  TX bytes:5843 (5.7 KiB)

pi@raspberrypi:~ $
pi@raspberrypi:~ $
pi@raspberrypi:~ $
pi@raspberrypi:~ $ ping
PING ( 56(84) bytes of data.
[2]+  Stopped                 ping

while it uses LAN connection as default connection i can’t reach the internet because it only connects internal network. In order to be able to connect internet i set tethering via my smartphone and let raspberry pi download what i need via this tethering connection.

using ifmetric, changing default network interface in linux is as simply as running 3 words command on your shell command.

ifmetric interface metric

ifmetric - An IPv4 route metrics manipulation tool


ifmetric  is  a  Linux  tool for setting the metrics of all IPv4 routes
attached to a given network interface at once.  This  may  be  used  to
change  the  priority of routing IPv4 traffic over the interface. Lower
metrics correlate with higher priorities.

ifmetric uses the Linux NETLINK interface  to  manipulate  the  routes.
Because  of  that  it  is  compatible  with routes created with the new
iproute2 utility.

as stated by above “man” page, Lower metrics correlate with higher priorities.

So if i want to set wlan0 as default connection (connection with higher priority). i can enter this command

pi@raspberrypi:~ $ sudo ifmetric eth0 10
pi@raspberrypi:~ $ sudo ifmetric wlan0

Now i can reach the internet via wlan0 connection

pi@raspberrypi:~ $ ping
PING ( 56(84) bytes of data.
64 bytes from icmp_seq=1 ttl=50 time=396 ms
64 bytes from icmp_seq=2 ttl=50 time=524 ms

How to connect Teradata Database

How to connect Teradata Database

Connecting to teradata database via dekstop client can be done using Teradata SQL Assistant. This software can be obtained from teradata link This package as stated by the website, contail full teradata software to connect to teradata database

This Teradata Tools and Utilities (TTU) 15.00 package is the full collection of Teradata client tools for Windows.

The size is around 500Mb. however all you need to simply connect to teradata database is by using SQL Assistant which is included in TTU package. The location of Teradata SQL Assistant is in\TTUExpress\x86\SQLAssistant. You can open the zip file and go through the folders above..

After installation, what you have to make sure is that there is no firewall that blocks your connection to teradata database and the teradata database itself is up and running. To make sure that you ip is allowed to make a connection to teradata db you can test using telnet to ipteradataserver teradataport.

For example mine is

telnet 1025

1025 is default port using by teradata to connect to their service. IF its OK, now you can use Teradata SQL Assistant.

You have to make sure you have username and password provided by DB administrator to access to your teradata database.

  1. Open Teradata SQL Assistant
  2. on Menubar choose tool > Define ODBC Data Source , new window will pop up
  3. Choose User DSN on menubar, then choose Add

    Teradata Data Source Administrator
    Teradata Data Source Administrator
  4. new window will pop up, scroll to the bottom, and choose teradata.

    Teradata Create New Data Structure
    Teradata Create New Data Structure
  5. Fill the information needed such as database connection name, username, and password to your teradata database
    ODBC Driver Setup for Teradata Database
    ODBC Driver Setup for Teradata Database

    6. After you completed step above you can now connect to Teradata Database

    Teradata Select Data Source
    Teradata SQL Assistant Connect
    Teradata Select Data Source
    Teradata Select Data Source





Now Database Explorer Side Bar should appear on your Teradata SQL Assistant. You can browse any database you have access to and you can execute you query by typing it in Query toolbox.

Teradata Database Explorer & Query Toolbox
Teradata Database Explorer & Query Toolbox


Java HTTPS testing : PKIX path validation failed:

I’ve had this https connection problem from my java client to other https server. PKIX path validation failed:

apparently the problem lies on invalid https certificate on https server i want to access.

for simple https connection testing from java client you can use this small java class : sslPoke

after downloading above class, just go to the directory where you put SSLPoke.class and run this command

java SSLPoke 443

*replace and port with https server and port you want to test

if there is no problem with your https connection you’ll get
connection successfull response

pi@raspberrypi /home $ java SSLPoke 443
Successfully connected

otherwise youll get exception error printed
for example i test against tomcat https server with self-signed certificate created using keytool

java SSLPoke 8443 PKIX path building failed: unable to find valid certification path to requested target
at SSLPoke.main(
Caused by: unable to find valid certification path to requested target

Some https problem require you to import certificate used on https server to your java (client) keystore.
after importing the certificate from the server (to client), we can execute this java command to access the https server

pi@raspberrypi /home $ java SSLPoke 8443
Successfully connected



InnoDB Slower Update Performance

Yesterday, i had locking table problem in myIsam table. The solution proposed is to change existing myIsam table into InnoDB table. So we changed the engine table as proposed. For information, my existing table had about 50000 rows. Atfer changing the table functionality test was performed and the program worked well. But we notice another problem when real load is applied to the application. we notice the reduced TPS.

From mysql command “show full processlist”, we saw UPDATE query in action.

So in default localhos mysql server i tried to run that run the same query againts +- 5000 rows innodb table & +-5000 rows myIsam table

UPDATE testisam SET sent = sent + 1 WHERE id = ‘5000’;

Table isam, 100 query update on particular row

Id            sent       startupdate                        endupdate
5000       99           2015-09-23 15:48:53        2015-09-23 15:48:53

execution time ~ 1 s


UPDATE testinno SET sent = sent + 1 WHERE id = ‘5000’;

Table inno, 100 query update on particular row

Id            sent       startupdate                        endupdate
5000       99           2015-09-23 15:47:07        2015-09-23 15:47:11

execution time ~5 s

From the result above, in default configuration, UPDATE query to single row on innodb table will take longer time than myIsam table. While it is true that InnoDB engine will prevent table locking, several tuning and changes in query should be made in order to work well with InnoDB table.

So because this “tuning & changes in query” will take sometime to learn/read. I decided to revert back to MyIsam table.. ūüėõ


Kodi video and add-on sound problem raspberry pi2

in previous post ive install kodi on raspberry pi2.
installation was successfull and i can see kodi start screen on my tv. but what about its feature to play any videos (almost format) and music files?

the next step is to try some movie files with different display size, from sd to hd.
all SD file size was played smoothly by kodi. but for 1080p size first i saw lag on video.
to solve this lag problem it is suggested that we change gpu parameter in /boot/config.txt to be larger than 160. just to make sure it is larger than 160 i set it to 512 haha don’t know whether it was necessary or not. alongside with increasing gpu mem i also try menu raspi-config to do the overclocking.

now the bottom of my /boot/config.txt  looks like this



i did the reboot and tried to play the 1080p video file and other video file. Viola there was no lag. But some of the videos didn’t output sound. There was just no output sound.
i tought maybe it was codec problem. so i move to next step. Testing video add-on. and yes, the same problem appeared, all add-on video (display) was playing well, but there was no sound :(. i’ve tried several add-ons such as youtube,, and ted talk.

after some googling i found some posts suggest us to set some options in kodi setting > system > audio output. you can try by yourself. i found my issue was solved by doing this..

Step 1. Testing analogue output

1. setting > system > audio output2. plug your headset/earphone (3.5 mm jack) to your raspberry pi 2
3. back to kodi menu, choose audio output device, change from default PI:HDMI to other output device >> PI:analogue. Don’t forget to adjust kodi volume with your remote :D. set the volume up to make sure it was not reset to minimum volume.
4. the sound shoud’ve came up by now :). now you can listen with your earphone all the time, or output it to speaker (using 3.5 mm jack).

Now what you want is offcourse sound output on you tv (via hdmi).

1. now choose “Audion Output Device” back to original >> PI:HDMI.
2. see if the sound appear, if not now check the “Output Configuration” menu.
3. Change from default “Best Match” to “Fixed”. Check “Limit sampling rate” the default value is “48.0”.
4. “This is”, Now my video that previously didn’t output sound on HDMI audio ouput begin to sound :D. if it still not ouput anything try to change default value “48.0” with other value available in the menu. see if one gives you what you want. dont forget check the kodi volume (via remote) each time you try your configuration.

So far this solution works for me. hope it works for you too

KODI XBMC installation on raspbian raspberry pi

Kodi / XBMC enable raspbian raspberry pi to act as module to convert dumb tv to smart tv :). ill also add how to connect xbmc via android phone.

What you need:

1. raspberry pi
2. internet connection
3. mouse
4. wifi module (for remote application on adroid phone)
5. hdmi cable

Raspberry pi 2 kodi hdmi connection
Raspberry pi 2 kodi hdmi connection

Step by step.

A. Install kodi/xmbc

1. sudo apt-get update
2. apt-get install kodi

B. enable kodi on startup

1. sudo nano /etc/default/kodi
2. change ENABLED=0 to ENABLED=1

C. enable kodi keyboard & mouse input

1. sudo nano /etc/udev/rules.d/10-permissions.rules
2. add these lines
# input
KERNEL==”mouse*|mice|event*”,¬†¬† MODE=”0660″, GROUP=”input”
KERNEL==”ts[0-9]*|uinput”,¬†¬†¬†¬†¬† MODE=”0660″, GROUP=”input”
KERNEL==”js[0-9]*”,¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† MODE=”0660″, GROUP=”input”

# tty
KERNEL==”tty[0-9]*”,¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† MODE=”0666″

# vchiq
SUBSYSTEM==”vchiq”,¬† GROUP=”video”, MODE=”0660″
3. Save file

4. Add user kodi to input group
sudo usermod -a -G input kodi

5. reboot
sudo reboot

on this point when you plug hdmi, xbmc/kodi display will appear on your monitor screen.
you can control xbmc input via your mouse :D.

kodi add-on 9gag tv
kodi add-on 9gag tv

Now if you want to connect raspberry pi xbmc / kodi via android phone, follow instructions below

D. Connect raspberry pi kodi/xbmc via android phone
1. on kodi/xbmc display, choose setting > webserver
2. click enable webserver option, edit webserver port with any number you like.
The default value is 8080 but u can change it if you also have other webserver application installed on your raspberry pi such as apache
3. edit username and password, default value is username:kodi, password:kodi
4. install xbmc remote application on your android phone.
5. connect your android phone & rasberry pi to your home network. (hotspot), input your raspberry ip address, and username, password for kodi on xbmc remote application
6. Viola, now you can control raspberry pi kodi/xbmc via your android phone.

Raspberry pi how to connect raspberry to android phone

After you are able to install and connect you raspberry pi via laptop and lan.
maybe its necesarry for you to connect your rasberry pi via android phone.

here is how

What you need.

1. wifi module
2. access to rasberry pi (via putty or direct).
3. android phone with SSH Client application installed
here is to download SSH Client application

Step by step

1. plug in wifi module to raspberry pi
2. turn on raspberry pi. enter ifconfig command, wlan0 should come up in list, but not connected to any address
pi@raspberrypi ~ $ ifconfig
wlan0     Link encap:Ethernet  HWaddr
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:0 (0.0 B)  TX bytes:0 (0.0 B)

4. turn on wifi hotspot/tethering on your android phone
5. enter command sudo iwlist wlan0 scan | grep ESSID

pi@raspberrypi ~ $ sudo iwlist wlan0 scan | grep ESSID
ESSID:”HP-Print-41-Officejet Pro 8600″

6. edit wpa_supplicant.conf
sudo nano /etc/wpa_supplicant/wpa_supplicant.conf
add this line

ssid=”your essid name/copy paste from earlier scan result”
psk=”you hotspot password”

for example with my handphone


7. save file, and reboot raspberry pi.
8. after reboot you’ll see that now your raspberry wlan module is connected to you hotspot. enter command sudo ifconfig wlan0 to see its ip address.
9. open SSH client on your android phone and enter raspberry pi address,
10. Now you can access your raspberry via your android phone. :D.

raspberry SSH from android phone
raspberry SSH from android phone

to restart raspberry networking you can enter this command instead rebooting raspberry
sudo /etc/init.d/networking stop
sudo /etc/init.d/networking start