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

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 :).

Telegram users, now if you want to play werewolf on telegram you can add werewolf moderator bot.
you can create group and add @werewolfbot to your group. then any member of the group who want to join the game should send message to the @werewolfbot (PM) and click start button that appears on screen. now you can initiate the game by /startgame command on your groupchat screen. anyone can join by /join command.

the explanation of the rule is available on the official site
http://werewolf.parawuff.com/

its pretty nice to be able to play werewolf without having to be in the same place :), enjoyyyy.

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

NAME
ifmetric - An IPv4 route metrics manipulation tool
SYNOPSIS
ifmetric INTERFACE [METRIC]
DESCRIPTION
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.

there is time when we want to automate process like transfer file between our server or sending command to remote server. to be able to make cronjob do the job easily we will need to ssh without password to remote server.

first you need to create ssh pub key of your server or if you can check first if its existed on you server

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 td-ttu-15.00_for_Windows.zip\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 10.1.1.1 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.

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

java SSLPoke 10.10.133.194 8443
sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:387)
at sun.security.validator.PKIXValidator.engineValidate(PKIXValidator.java:292)
at sun.security.validator.Validator.validate(Validator.java:260)
at sun.security.ssl.X509TrustManagerImpl.validate(X509TrustManagerImpl.java:324)
at sun.security.ssl.X509TrustManagerImpl.checkTrusted(X509TrustManagerImpl.java:229)
at sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(X509TrustManagerImpl.java:124)
at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1491)
at sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:216)
at sun.security.ssl.Handshaker.processLoop(Handshaker.java:979)
at sun.security.ssl.Handshaker.process_record(Handshaker.java:914)
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1062)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1375)
at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:747)
at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:123)
at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:138)
at SSLPoke.main(SSLPoke.java:31)
Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at sun.security.provider.certpath.SunCertPathBuilder.build(SunCertPathBuilder.java:146)
at sun.security.provider.certpath.SunCertPathBuilder.engineBuild(SunCertPathBuilder.java:131)
at java.security.cert.CertPathBuilder.build(CertPathBuilder.java:280)
at sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:382)

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

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

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.. 😛

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

arm_freq=900

gpu_mem=512
core_freq=250
sdram_freq=450
over_voltage=2

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, 9gag.tv, 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.