Author Archives: ronaldpringadi

Using VBA macro for Excel

Posted on January 22, 2014 by ronaldpringadi

Let’s start with something simple. Assume that we have a big spreadsheet and we want to highlight it based on a certain subject — for example, expenses about car. For the sake of the example we’ll keep it short, but … Continue reading →

Posted in Visual Basic | Comments Off

Remote copy using scp

Posted on January 15, 2014 by ronaldpringadi

Do you ever need to copy one file from one server to another? If you have ssh access to the remote server then you can do an scp command like so: 1$ scp remoteUsername@remoteServername:remoteFile localFile

Posted in Linux, Operating System | Tagged Linux | Comments Off

Delete files older than X number of days in Linux

Posted on November 17, 2013 by ronaldpringadi

Say you backup your database daily and you need to delete the old backup files. You can issue the command bellow which will erase any files within the specified directory that are older than 7 days. 1$ find /your/target/directory* -mtime … Continue reading →

Posted in Bash, Linux, Operating System | Comments Off

LDAP basics: Base DN, Search Filters, and a test directory in 5 minutes

Posted on November 5, 2013 by ronaldpringadi

If you’ve ever pasted an LDAP query into a config file without really understanding what each piece means, this post is for you. We’ll cover the two concepts that trip people up most — Base DN and Search Filter — … Continue reading →

Posted in LDAP and Active Directory | Comments Off

Calling a mysql query from linux or dos command line

Posted on October 26, 2013 by ronaldpringadi

There are times when you want to call a mysql command from the bash or dos script then call this script in a scheduler (cron job). The example below will show you how to do so. 1mysql -uYOURUSERNAME -pYOURPASSWORD -DYOURDATABASE … Continue reading →

Posted in Database, Linux, MySQL | Comments Off

Remove all svn directory

Posted on October 20, 2013 by ronaldpringadi

Subversion (SVN) sometimes clutter our source directory by creating .svn folder in each folder or sub folder that we version control. The easiest way to erase them is by using a bash command: 1find . -name ".svn" -type d -exec … Continue reading →

Posted in Linux, Version Control | Comments Off

Adding New VirtualHost in Apache2

Posted on October 16, 2012 by ronaldpringadi

On linux Ubuntu 1. If your apache has /etc/apache2/sites-available directory then just create a new file “dev.newwebsite.com.conf” with the following content: 12345678910111213<VirtualHost *:80> ServerName dev.newwebsite.com DocumentRoot "/var/www/www.newwebsite.com" # Error handlers ErrorDocument 500 … Continue reading →

Posted in Operating System, PHP, Ubuntu | Comments Off

Memcache test connection script

Posted on October 15, 2012 by ronaldpringadi

12345678910111213<?php error_reporting(E_ALL); $memcache = new Memcache; // Connect to memcached server $memcache->connect(’127.0.0.1′, 11211) or die ("Could not connect"); // Add it to memcached server // The parameters are: KEY, VALUE, USE COMPRESSION, EXPIRY IN SECONDS $memcache->set(’MyKey1′, ‘The value of My … Continue reading →

Posted in PHP, Web Development | Comments Off

Redis connection test script

Posted on October 15, 2012 by ronaldpringadi

1234567891011121314151617181920212223242526<?php require "../predis/autoload.php"; // Update with your location to predis Predis\Autoloader::register(); try { $redis = new Predis\Client(); // Uncomment the following lines and adjust them accordingly if you have a non-default redis configuration /* … Continue reading →

Posted in PHP, Web Development | Comments Off

SVN Tricks in Linux

Posted on October 13, 2012 by ronaldpringadi

To show colorized svn diff 1sudo aptitude install colordiff Then on your home directory there is a hidden file called .bashrc. Edit it. 1vim ~/.bashrc Append the following code at the end of the file 1234svndiff() { svn diff … Continue reading →

Posted in Linux, Operating System, Version Control | Comments Off