Compiling DB2 UDFs The solution presented here has been tested on DB2 versions 9.7 and 10.1. The $INSTHOME/sqllib/samples/c directory on Linux and AIX contains many examples of C routines to extend DB2 or to work with DB2 from C programs. This article describes how to compile the sample code for 64 bit. Setting up the [...]
Perl Regular Expressions (using PCRE libs) for DB2 10.1
Regular expressions come in many flavors. Since Perl is a very popular scripting language, many programmers already know the Perl regex way. Here is an article from 2003 that we just used successfully to deploy pcre compatible matching on DB2 10.1 Bringing the Power of Regular Expression Matching to SQL http://www.ibm.com/developerworks/data/library/techarticle/0301stolze/0301stolze.html
Upgrading Android on Samsung Galaxy Pro B7510
The official tool to upgrade the Samsung Galaxy Pro B7510 is Kies, but in most cases, the upgrade can’t be done. Instead there is a tool named Odin: http://enzag.com/technology/android/how-to-upgrade-samsung-galaxy-pro-b7510-to-gingerbread/ It is recommended to register at SamFirmware where you can download the official firmware, then you can install it using: http://www.sammobile.com/firmware/?page=8&view=2588
Cognos 10.1 install on CentOS 6.3 64 bit
yum update (then reboot if kernel has been patched) yum install glibc.i686 yum install openmotif yum install libgcc.i686 yum install openmotif22 yum install openmotif22.i686 yum install xauth yum install libXtst tar xvzf bisrvr_linuxi8664h_10.1.1_ml.tar.gz cd linuxi38664h/ ./isetup
CSF / LDF user / IP lock out info
Where can we view the lock out triggers / logs? There are a few ways to do it. The log itself is in /var/log/lfd.log – this provides you with all the information about what lfd is doing. lfd is the process that keeps track of many things: login failures (technically it is called the “login [...]
Setting up FileZilla for connecting to the server (first time only)
Start FileZilla. I’m using FileZilla 3.5.0 for this tutorial, but the steps should be the same in any recent version. We will start by creating a new site in FileZilla so that we won’t have to fill the credentials every time we would like to connect to the server. Open File > Site Manager… and [...]
WHMCS Admin Area Text (English Version)
# Global $_ADMINLANG['global']['hometitle'] = “Admin Summary”; $_ADMINLANG['global']['searchfilter'] = “Search/Filter”; $_ADMINLANG['global']['search'] = “Search”; $_ADMINLANG['global']['recordsfound'] = “Records Found”; $_ADMINLANG['global']['page'] = “Page”; $_ADMINLANG['global']['of'] = “of”; $_ADMINLANG['global']['jumppage'] = “Jump to Page”; $_ADMINLANG['global']['go'] = “Go”; $_ADMINLANG['global']['any'] = “Any”; $_ADMINLANG['global']['withselected'] = “With Selected”; $_ADMINLANG['global']['previouspage'] = “« Previous Page”; $_ADMINLANG['global']['nextpage'] = “Next Page »”; $_ADMINLANG['global']['norecordsfound'] = “No Records Found”; $_ADMINLANG['global']['welcomeback'] = “Welcome [...]
Creating an easy to deploy SSL certificate in PEM format
When ordering a secure certificate, most often one has to deal with the following files: certificate key file (aka private key): .key certificate request file: .csr primary certificate file (issued by the CA): .crt certificate chain (aka intermediate certificate, or sf bundle): sf_bundle.crt As a result, when deploying to a web server, it is necessary [...]
How to install Tomcat 6 on RHEL 6 or CentOS 6
Here are some steps to install Tomcat 6 on Red Hat 6 (or CentOS 6). First we are going to prepare the repository: yum install yum-priorities rpm -Uvh http://apt.sw.be/redhat/el6/en/x86_64/rpmforge/RPMS/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm rpm -Uvh http://download.fedora.redhat.com/pub/epel/6/x86_64/epel-release-6-5.noarch.rpm rpm -Uvh http://mirrors.dotsrc.org/jpackage/6.0/generic/free/RPMS/jpackage-utils-5.0.0-7.jpp6.noarch.rpm Next we will install Java and Tomcat 6: yum -y install java yum -y install tomcat6 tomcat6-webapps tomcat6-admin-webapps Finally [...]
Life after Firepublish
My friend Andrew (CTO of LiquidCompass) recommended Firepublish a few years ago for helping manging team work between web developers, and web designers. Unfortuantely, Firepublish has been offline for quite some time now, and here is what Andrew recommends to replace it: Mercurial Capistrano Quoting Andrew: We actually moved to Mercurial for version control over [...]