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.
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 :).
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 INTERFACE [METRIC]
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
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
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
in my server this is the result for above command
[admin@servergue ~]$ cd ~
[admin@servergue ~]$ cd .ssh
[admin@servergue .ssh]$ ls
id_rsa id_rsa.pub known_hosts
if files above don’t exist you need to create one using below command
ssh-keygen -t rsa
[admin@servergue ~]$ ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/home/admin/.ssh/id_rsa):
Created directory ‘/home/admin/.ssh’.
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/admin/.ssh/id_rsa.
Your public key has been saved in /home/admin/.ssh/id_rsa.pub.
The key fingerprint is:
The key’s randomart image is:
+–[ RSA 2048]—-+
| .E+ |
| . +=o+ |
| + o.** .|
| S + o .B |
| . . o|
| . |
now check directory .ssh
file id_rsa id_rsa.pub known_hosts should appear there.
Now what you need to do is to copy what inside id_rsa.pub to your remote 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.
Open Teradata SQL Assistant
on Menubar choose tool > Define ODBC Data Source , new window will pop up
Choose User DSN on menubar, then choose Add
new window will pop up, scroll to the bottom, and choose teradata.
Fill the information needed such as database connection name, username, and password to your teradata database
6. After you completed step above you can now connect to Teradata Database
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.
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
Caused by: sun.security.provider.certpath.SunCertPathBuilderException: 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
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.. 😛
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, 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.
So far this solution works for me. hope it works for you too
SUBSYSTEM==”vchiq”, GROUP=”video”, MODE=”0660″
3. Save file
4. Add user kodi to input group sudo usermod -a -G input kodi
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.
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.
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
UP BROADCAST MULTICAST MTU:1500 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
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
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.
to restart raspberry networking you can enter this command instead rebooting raspberry
sudo /etc/init.d/networking stop
sudo /etc/init.d/networking start