Read SMS directly from Sqlite database in Android
Today I wanted to extract the SMS content out of the android SMS application SQLite database using ADB.
Posts by Category
Android
Java String Util Class
Unfortunately, Java does not include a proper String manipulation class in its Java SE SDK. I really do not understand why… However, we see so many implement...
Java Calculate Orthodox Easter Date
Today I wondered if there is an algorithm to calculate the date of Orthodox Easter. After some searching in the web I found the algorithm and converted it to...
Extend SQLiteOpenHelper as a singleton class in Android
Update: 2012-07-27
Launch Logcat programmatically in Android
Today I wanted to write logcat output to a file while my application is running. To do so I executed the following code:
Android pre-populated Database
Today I am going to show you how to create an android application which comes with a pre-populated database. The database file has to be stored in assets dir...
Bluetooth adapter device name and MAC address in Android
Today I am going to show you how to get the bluetooth adapter device name (if exists) and MAC address programmatically in Android. Note that this code will ...
Check Network connectivity and obtain Wifi MAC address in Android
Updated: 2012-05-09
Android MD5 password encryption
Today I will show you how to generate the MD5 hash String for a given String in Android
Android External Storage Free Space
Today I wanted to store some images to SD card and I wanted to find the available space:
Android get SQLite Library Version
```java /** * get the version of the SQLite Library that is installed in the android * system * * @return version , for example 3.5.2 */ public ...
Apache
Let’s Encrypt SSL certificate without root or sudo privileges
Five days ago we had to renew a number of SSL certificates using free Let’s Encrypt SSL authority to a few Apache servers which were installed in Jelastic Pa...
Solr fix corrupted index using Lucene
A few days ago, a Solr server in our SolrCloud installation stopped unexpectedly. After examining solr.log file I spotted that it could not start again becau...
Install Apache Solr as Windows Service using NSSM
Today I wanted to install Apache Solr index in Windows 7, Windows Server 2008R2 and Windows Server 2012 machines. So I achieved that , using the following st...
Change timezone to Apache server , PHP and MySql in XAMPP
I have installed XAMPP in my Windows machine and I want to alter the timezone in Apache HTTP server, PHP module and MySql in order to see proper dates in ser...
Application Server
Install Jboss 5.1.0.GA to Windows 7
Today I am going to show you how to install Jboss 5.1.0.GA on a Windows 7 machine.
Databases
MongoDB replica error RS102 too stale to catch up during full recovery
We run MongoDB 2.6.0 on a production system configured with a replica set of 3 members: Primary Secondary Arbiter
Read SMS directly from Sqlite database in Android
Today I wanted to extract the SMS content out of the android SMS application SQLite database using ADB.
MySQL connection ERROR 1129
Today I had to configure a MySQL database cluster and I faced the following error
Import a large sql dump file to a MySQL database from command line
Today I had to import a very large SQL dump file (6 Gb) to a MySQL database using windows command line. If you are using linux it is the same. The process is...
Change timezone to Apache server , PHP and MySql in XAMPP
I have installed XAMPP in my Windows machine and I want to alter the timezone in Apache HTTP server, PHP module and MySql in order to see proper dates in ser...
Windows 7 64bit ODBC Data sources
Today I was trying to create and ODBC Data Source to a database using 32 bit database drivers. When I accessed ODBC Data Sources (32bit) from Control Panel, ...
SQL Server Select Table information
Today I am going to show you how do we obtain schema information in SQL Server 2005/2008. If you want to select all table names from a specific schema you ne...
SQL Server Truncate All Table Data
Today I want to truncate ( delete all table data) in a large SQL Server database instance. Plain delete statements are not going to work as there is a big nu...
Extend SQLiteOpenHelper as a singleton class in Android
Update: 2012-07-27
Android pre-populated Database
Today I am going to show you how to create an android application which comes with a pre-populated database. The database file has to be stored in assets dir...
Android get SQLite Library Version
```java /** * get the version of the SQLite Library that is installed in the android * system * * @return version , for example 3.5.2 */ public ...
Test1
Welcome to WordPress.com. After you read this, you should delete and write your own post, with a new title above. Or hit Add New on the left (of the admin da...
Debian
Install, configure and troubleshoot NTP servers in Debian Linux
If you are reading this article, perhaps you have searched a lot about NTP server installation in Linux, issues and problems encountered and how to troublesh...
Docker
Migrate a Gitlab Docker container from version 8.0.4 to 8.2.0
Update 2016-05-13: The following procedure works perfectly for migrations from version 8.0.4 to 8.7.5
Eclipse
Configure Eclipse in order to build MapStruct in Java projects
Today I was working on a Java Spring MVC project which uses Maven. My editor was the Eclipse IDE, with the current version of the M2E plug-in. When I pulled ...
Elasticsearch
Rsyslog - Parse Json and enrich IP with Geolocation using Maxmind GeoLite2 City and ISP
Today we wanted to parse some json logs which we had in a file using Rsyslog and enrich them with Geolocation information regarding the city and the ISP an ...
Logstash - Enrich IP with Geolocation using Maxmind GeoLite2 City and ISP
Today we wanted to parse some json logs which we had in a file using Logstash and enrich them with Geolocation information regarding the city and the ISP an...
Creating a Beat based on Metricbeat resolving Init and create metricset failures
I suspect that you are reading this post after having trouble creating a new Elastic Beat based on Metricbeat. Bud do not worry! We have you covered and solv...
Git
Git merge conflicts using Tortoise Git merge in Windows
Today we wanted to use Tortoise Git Merge, a Windows Git utility which comes with Tortoise Git. It helps us do a 3 way merge and solve our conflicts easily. ...
Migrate a Gitlab Docker container from version 8.0.4 to 8.2.0
Update 2016-05-13: The following procedure works perfectly for migrations from version 8.0.4 to 8.7.5
Export Untracked, modified, moved and deleted files from a Git repository to archive
Today I wanted to export to a .tar.gz archive all unstracked (new) , modified and deleted files from a Git repository. After some searching, I found a StackO...
Gitlab
Migrate a Gitlab Docker container from version 8.0.4 to 8.2.0
Update 2016-05-13: The following procedure works perfectly for migrations from version 8.0.4 to 8.7.5
Go
Creating a Beat based on Metricbeat resolving Init and create metricset failures
I suspect that you are reading this post after having trouble creating a new Elastic Beat based on Metricbeat. Bud do not worry! We have you covered and solv...
Golang
Creating a Beat based on Metricbeat resolving Init and create metricset failures
I suspect that you are reading this post after having trouble creating a new Elastic Beat based on Metricbeat. Bud do not worry! We have you covered and solv...
HAProxy
Use HAProxy and Docker to load balance requests to Solr and SolrCloud
We use Solr 4.6 with SolrCloud configuration in a production system. You may say: “It is hight time you upgraded to the latest version, isn’t it?”. And you w...
HTTP
Let’s Encrypt SSL certificate without root or sudo privileges
Five days ago we had to renew a number of SSL certificates using free Let’s Encrypt SSL authority to a few Apache servers which were installed in Jelastic Pa...
Change timezone to Apache server , PHP and MySql in XAMPP
I have installed XAMPP in my Windows machine and I want to alter the timezone in Apache HTTP server, PHP module and MySql in order to see proper dates in ser...
HaProxy
MySQL connection ERROR 1129
Today I had to configure a MySQL database cluster and I faced the following error
JBoss
Install Jboss 5.1.0.GA to Windows 7
Today I am going to show you how to install Jboss 5.1.0.GA on a Windows 7 machine.
Java
Debug HTTP request of Java SOAP JAX-WS web service client
Today I wanted to debug in Java a JAX-WS SOAP web service client and see the exact message that is send as an HTTP request. So after searching, I found in th...
HTTP Basic Authentication in Java SOAP JAX-WS web service client
Today I had to create a Java client for a SOAP web service. So I opened Netbeans IDE and used the great tool which generates JAX-WS client code using the res...
Configure Eclipse in order to build MapStruct in Java projects
Today I was working on a Java Spring MVC project which uses Maven. My editor was the Eclipse IDE, with the current version of the M2E plug-in. When I pulled ...
JSON remove new lines via Linux and use it as string variable and as param in cURL POST request
Today I had to parse a JSON response in a JUnit test and then reuse it in a cURL command line call. Unfortunately I could not read the JSON response from a f...
Solr fix corrupted index using Lucene
A few days ago, a Solr server in our SolrCloud installation stopped unexpectedly. After examining solr.log file I spotted that it could not start again becau...
Java send smtp mail using Gmail
Today I wanted to make a mail notification mechanism for a project of mine. After some web searching I stumbled upon a mkyong.com tutorial where he uses SMTP...
Java String Util Class
Unfortunately, Java does not include a proper String manipulation class in its Java SE SDK. I really do not understand why… However, we see so many implement...
Java Calculate Orthodox Easter Date
Today I wondered if there is an algorithm to calculate the date of Orthodox Easter. After some searching in the web I found the algorithm and converted it to...
Java get file size and download using HTTP
Today I wanted to download a file using Http protocol but before that determine its size. First aff all I open an Http connection and get file size using Con...
Launch Logcat programmatically in Android
Today I wanted to write logcat output to a file while my application is running. To do so I executed the following code:
Bluetooth adapter device name and MAC address in Android
Today I am going to show you how to get the bluetooth adapter device name (if exists) and MAC address programmatically in Android. Note that this code will ...
Check Network connectivity and obtain Wifi MAC address in Android
Updated: 2012-05-09
Android MD5 password encryption
Today I will show you how to generate the MD5 hash String for a given String in Android
Android External Storage Free Space
Today I wanted to store some images to SD card and I wanted to find the available space:
Object ArrayList Sort
Let’s say we have a simple class called Person public class Person{ public String name; public int age; public Person(String name, int age) { this.nam...
Linux
Git merge conflicts using Tortoise Git merge in Windows
Today we wanted to use Tortoise Git Merge, a Windows Git utility which comes with Tortoise Git. It helps us do a 3 way merge and solve our conflicts easily. ...
Install, configure and troubleshoot NTP servers in Debian Linux
If you are reading this article, perhaps you have searched a lot about NTP server installation in Linux, issues and problems encountered and how to troublesh...
MongoDB replica error RS102 too stale to catch up during full recovery
We run MongoDB 2.6.0 on a production system configured with a replica set of 3 members: Primary Secondary Arbiter
Use HAProxy and Docker to load balance requests to Solr and SolrCloud
We use Solr 4.6 with SolrCloud configuration in a production system. You may say: “It is hight time you upgraded to the latest version, isn’t it?”. And you w...
SublimeText 3 Fix greek (and other languages) accented chars input
Yesterday I installed SublimeText 3 editor (build 3143) in my PC and the first thing I realised was that I could not type any Greek accented characters. Thus...
Let’s Encrypt SSL certificate without root or sudo privileges
Five days ago we had to renew a number of SSL certificates using free Let’s Encrypt SSL authority to a few Apache servers which were installed in Jelastic Pa...
Migrate a Gitlab Docker container from version 8.0.4 to 8.2.0
Update 2016-05-13: The following procedure works perfectly for migrations from version 8.0.4 to 8.7.5
JSON remove new lines via Linux and use it as string variable and as param in cURL POST request
Today I had to parse a JSON response in a JUnit test and then reuse it in a cURL command line call. Unfortunately I could not read the JSON response from a f...
Solr fix corrupted index using Lucene
A few days ago, a Solr server in our SolrCloud installation stopped unexpectedly. After examining solr.log file I spotted that it could not start again becau...
Linux: Extract audio and video using ffmpeg
Today I had some mp4 video files and I wanted to extract the audio and video into separate files. So to do that you can do the following:
Nginx https reverse proxy to Wordpress with Apache, http and different port
Today I had to hide a Wordpress 3.8.1 blog behind an Nginx reverse proxy configured to use only https. Nginx was behind an external firewall which forwarded ...
Export Untracked, modified, moved and deleted files from a Git repository to archive
Today I wanted to export to a .tar.gz archive all unstracked (new) , modified and deleted files from a Git repository. After some searching, I found a StackO...
Remove special and control characters from string using Python
Today I had a database table which contained special and control characters (like DLE, DC1, ACK, DC3 etc.) in its records. After some searching I found a way...
Read SMS directly from Sqlite database in Android
Today I wanted to extract the SMS content out of the android SMS application SQLite database using ADB.
Linux get hard disk statistics using Python
Today I wanted to collect disk usage information and send them to a remote server script. I used df command to collect disk usage information and Python to s...
Fix Vmware tools “ kernel header path is not valid “ error
UPDATE (2015-05-13): Confirming that the following approach works for Lubuntu versions 12.10, 14.04 and 14.10 and Linux Mint 15 and 17.
Vi set color scheme , line numbers and syntax highlighting
Today I wanted to to set the Color Scheme in vi / vim in my Linux. The default configuration looks ugly:
MySQL connection ERROR 1129
Today I had to configure a MySQL database cluster and I faced the following error
Install Raspbian Wheezy Linux to Raspberry Pi using Linux
Επιτέλους! (at last! in greek) After a month and a half of waiting, I received my Raspberry Pi! Now I am going to show you how to install Raspbian Wheezy Lin...
Perl UTF-8 and Regular Expressions
Today I wanted to explore Perl’s Unicode and regular expression capabilities, so I wrote down this simple script. It is quite amazing how simply Perl handles...
Ubuntu Debian Linux useful commands
Updated: 2015-09-08
Test1
Welcome to WordPress.com. After you read this, you should delete and write your own post, with a new title above. Or hit Add New on the left (of the admin da...
Logstash
Logstash - Enrich IP with Geolocation using Maxmind GeoLite2 City and ISP
Today we wanted to parse some json logs which we had in a file using Logstash and enrich them with Geolocation information regarding the city and the ISP an...
Lucene
Solr fix corrupted index using Lucene
A few days ago, a Solr server in our SolrCloud installation stopped unexpectedly. After examining solr.log file I spotted that it could not start again becau...
Mint
JSON remove new lines via Linux and use it as string variable and as param in cURL POST request
Today I had to parse a JSON response in a JUnit test and then reuse it in a cURL command line call. Unfortunately I could not read the JSON response from a f...
Fix Vmware tools “ kernel header path is not valid “ error
UPDATE (2015-05-13): Confirming that the following approach works for Lubuntu versions 12.10, 14.04 and 14.10 and Linux Mint 15 and 17.
Vi set color scheme , line numbers and syntax highlighting
Today I wanted to to set the Color Scheme in vi / vim in my Linux. The default configuration looks ugly:
Networking
Java send smtp mail using Gmail
Today I wanted to make a mail notification mechanism for a project of mine. After some web searching I stumbled upon a mkyong.com tutorial where he uses SMTP...
Send email from VBScript using SMTP and Gmail
Today I wanted to send an email using SMTP from my gmail account. I searched the web and I found this and this and this which helped me a lot. So this is the...
Nginx
Nginx https reverse proxy to Wordpress with Apache, http and different port
Today I had to hide a Wordpress 3.8.1 blog behind an Nginx reverse proxy configured to use only https. Nginx was behind an external firewall which forwarded ...
PHP
Change timezone to Apache server , PHP and MySql in XAMPP
I have installed XAMPP in my Windows machine and I want to alter the timezone in Apache HTTP server, PHP module and MySql in order to see proper dates in ser...
PowerBuilder
PowerBuilder Datawindow Grid delete selected rows efficiently
Today I wanted to delete the selected rows of a datawindow grid in Powerbuilder. When I say delete I wanted just to remove them from the screen and not from ...
PowerBuilder 10 Get and Set System Language
Today I wanted to retrieve the selected system language from PowerBuilder 10. To accomplish that I had to do some search in the web. After a long period I fo...
Python
Remove special and control characters from string using Python
Today I had a database table which contained special and control characters (like DLE, DC1, ACK, DC3 etc.) in its records. After some searching I found a way...
Linux get hard disk statistics using Python
Today I wanted to collect disk usage information and send them to a remote server script. I used df command to collect disk usage information and Python to s...
Raspberry Pi
Install Raspbian Wheezy Linux to Raspberry Pi using Linux
Επιτέλους! (at last! in greek) After a month and a half of waiting, I received my Raspberry Pi! Now I am going to show you how to install Raspbian Wheezy Lin...
Raspbian
Vi set color scheme , line numbers and syntax highlighting
Today I wanted to to set the Color Scheme in vi / vim in my Linux. The default configuration looks ugly:
Install Raspbian Wheezy Linux to Raspberry Pi using Linux
Επιτέλους! (at last! in greek) After a month and a half of waiting, I received my Raspberry Pi! Now I am going to show you how to install Raspbian Wheezy Lin...
Rsyslog
Rsyslog - Parse Json and enrich IP with Geolocation using Maxmind GeoLite2 City and ISP
Today we wanted to parse some json logs which we had in a file using Rsyslog and enrich them with Geolocation information regarding the city and the ISP an ...
SQLite
Read SMS directly from Sqlite database in Android
Today I wanted to extract the SMS content out of the android SMS application SQLite database using ADB.
Server
Nginx https reverse proxy to Wordpress with Apache, http and different port
Today I had to hide a Wordpress 3.8.1 blog behind an Nginx reverse proxy configured to use only https. Nginx was behind an external firewall which forwarded ...
Solr
Use HAProxy and Docker to load balance requests to Solr and SolrCloud
We use Solr 4.6 with SolrCloud configuration in a production system. You may say: “It is hight time you upgraded to the latest version, isn’t it?”. And you w...
Solr fix corrupted index using Lucene
A few days ago, a Solr server in our SolrCloud installation stopped unexpectedly. After examining solr.log file I spotted that it could not start again becau...
Install Apache Solr as Windows Service using NSSM
Today I wanted to install Apache Solr index in Windows 7, Windows Server 2008R2 and Windows Server 2012 machines. So I achieved that , using the following st...
Source control
Migrate a Gitlab Docker container from version 8.0.4 to 8.2.0
Update 2016-05-13: The following procedure works perfectly for migrations from version 8.0.4 to 8.7.5
Export Untracked, modified, moved and deleted files from a Git repository to archive
Today I wanted to export to a .tar.gz archive all unstracked (new) , modified and deleted files from a Git repository. After some searching, I found a StackO...
Spring
Configure Eclipse in order to build MapStruct in Java projects
Today I was working on a Java Spring MVC project which uses Maven. My editor was the Eclipse IDE, with the current version of the M2E plug-in. When I pulled ...
Sql Server
Windows 7 64bit ODBC Data sources
Today I was trying to create and ODBC Data Source to a database using 32 bit database drivers. When I accessed ODBC Data Sources (32bit) from Control Panel, ...
SQL Server Select Table information
Today I am going to show you how do we obtain schema information in SQL Server 2005/2008. If you want to select all table names from a specific schema you ne...
SQL Server Truncate All Table Data
Today I want to truncate ( delete all table data) in a large SQL Server database instance. Plain delete statements are not going to work as there is a big nu...
Text editor
SublimeText 3 Fix greek (and other languages) accented chars input
Yesterday I installed SublimeText 3 editor (build 3143) in my PC and the first thing I realised was that I could not type any Greek accented characters. Thus...
Ubuntu
JSON remove new lines via Linux and use it as string variable and as param in cURL POST request
Today I had to parse a JSON response in a JUnit test and then reuse it in a cURL command line call. Unfortunately I could not read the JSON response from a f...
Linux get hard disk statistics using Python
Today I wanted to collect disk usage information and send them to a remote server script. I used df command to collect disk usage information and Python to s...
Fix Vmware tools “ kernel header path is not valid “ error
UPDATE (2015-05-13): Confirming that the following approach works for Lubuntu versions 12.10, 14.04 and 14.10 and Linux Mint 15 and 17.
Vi set color scheme , line numbers and syntax highlighting
Today I wanted to to set the Color Scheme in vi / vim in my Linux. The default configuration looks ugly:
Install Raspbian Wheezy Linux to Raspberry Pi using Linux
Επιτέλους! (at last! in greek) After a month and a half of waiting, I received my Raspberry Pi! Now I am going to show you how to install Raspbian Wheezy Lin...
Virtualisation
Fix Vmware tools “ kernel header path is not valid “ error
UPDATE (2015-05-13): Confirming that the following approach works for Lubuntu versions 12.10, 14.04 and 14.10 and Linux Mint 15 and 17.
Windows
Solr fix corrupted index using Lucene
A few days ago, a Solr server in our SolrCloud installation stopped unexpectedly. After examining solr.log file I spotted that it could not start again becau...
Install Apache Solr as Windows Service using NSSM
Today I wanted to install Apache Solr index in Windows 7, Windows Server 2008R2 and Windows Server 2012 machines. So I achieved that , using the following st...
mysql
MySQL connection ERROR 1129
Today I had to configure a MySQL database cluster and I faced the following error
Import a large sql dump file to a MySQL database from command line
Today I had to import a very large SQL dump file (6 Gb) to a MySQL database using windows command line. If you are using linux it is the same. The process is...
Change timezone to Apache server , PHP and MySql in XAMPP
I have installed XAMPP in my Windows machine and I want to alter the timezone in Apache HTTP server, PHP module and MySql in order to see proper dates in ser...
smtp
Java send smtp mail using Gmail
Today I wanted to make a mail notification mechanism for a project of mine. After some web searching I stumbled upon a mkyong.com tutorial where he uses SMTP...
Send email from VBScript using SMTP and Gmail
Today I wanted to send an email using SMTP from my gmail account. I searched the web and I found this and this and this which helped me a lot. So this is the...
vmware
Fix Vmware tools “ kernel header path is not valid “ error
UPDATE (2015-05-13): Confirming that the following approach works for Lubuntu versions 12.10, 14.04 and 14.10 and Linux Mint 15 and 17.