Posts

INSTALL MARIADB ALONG WITH MYSQL IN CENTOS

MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. You can use the  link  to know more about MariaDB and  it's features. If you want to try MariaDB without losing MySQL, then here is the tutorial for running MariaDB alongside MySQL. Let's start with the steps to install Mariadb along with Mysql Download the latest version (mariadb-10.0.20-linux-i686.tar.gz - as of writing this article) from  here  and extract the files in /opt directory. Create a directory for storing the mariadb data [root@knackforge opt]# mkdir mariadb-data Create symlinks from mariadb-10.0.20-linux-i686 to mariadb [root@knackforge opt]# ln -s mariadb-10.0.20-linux-i686 mariadb [root@knackforge opt]# ls -al total 32 lrwxrwxrwx  1 root       root         26 Jun 24 10:06 mariadb -> mariadb-10.0.20-linux-i686 drwxr-xr-x 12 mariadb    mariadb    4096 Jun 24 10:05 mariadb-10.0.20-linux-i686 drwxr-xr-x  9 mariadb    mariadb    ...

Deploy Birt Report in Jetty Server

Image
1 – Downloading You can download Jetty from two sources: Eclipse or Codehaus. https://www.eclipse.org/jetty/download.html 2 - Simply uncompress the file to a directory. 3 – Running Jetty Open a terminal. Go to the Jetty installation directory. Enter the following command: $ java -jar start.jar Now open a browser and go to localhost to check if Jetty was installed sucessfully: http://localhost:8080/ ​Deploy Birt Report in Jetty Unzip the BIRT Reports runtime archive. Copy the WebViewerExample folder to the webapps folder of the Tomcat server. Rename the WebViewerExample folder to birt ​ Your BIRT Reports viewer application is accessible at http://localhost:8080/birt/ . ​ ​ ​ ​

Migrating from MySQL to Postgres

Dump your database: mysqldump --compatible=postgresql --default-character-set=utf8 -r databasename.mysql -u root databasename Convert the dump to Postgres syntax using https://github.com/lanyrd/mysql-postgresql-converter : wget https://raw.github.com/lanyrd/mysql-postgresql-converter/master/db_converter.py chmod +rx db_converter.py python db_converter.py databasename.mysql databasename.psql Install postgres: apt-cache search postgres # find the most recent sudo apt-get install postgresql-x.x Create the database and insert the data: sudo -u postgres createdb databasename psql databasename -U postgres -h 127.0.0.1 < databasename.psql

How to fix /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory

I encountered several days ago this error on a fresh installed CentOS 6 – 64 bit machine while installing IBM LSF. This will happen only on 64 bit systems, the cause is the fact that 32 bit libraries are missing from the system, so you can easily fix this issue by installing the 32 bit libraries on your system. So if you encounter this error  /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory  this is how you can fix it: On any RPM based distribution (CentOS/RedHat/Fedora/Suse/Mandriva): yum -y install glibc.i686 On any DEB based distribution (Debian/Ubuntu/Mint/Crunchbang): apt-get update apt-get install ia32-libs

InfoSphere Information Server installer hangs

Problem(Abstract) InfoSphere Information Server (IS) installer hangs when you attempt to restart a failed installation attempt. Symptom IS installer simply hangs at the Installation screen. If you inspect the IS Install log, it is not updated. Cause IS installer hangs at a place where it finds an existing inprogress directory and it assumes that previous installation is still pending and tries to resume it with the help of response file, but it fails since there was no response file provided. Environment Restarting a previously failed IS install attempt without providing that response file. Diagnosing the problem IS Installer log contains the entries similar to below. 2015-06-30T10:56:49.98, SEVERE: com.ibm.is.install.atlasinstaller.ui.control.InstallEngineMonitor com.ibm.is.install.exception.InstallException: java.lang.NullPointerException at com.ibm.is.install.AbstractInstaller.checkInprogressDirEx...

pnp4Nagios Installation configuration Step by step Guide

Image
Pnp4Nagios is an tool which will store performance data into RRD (Round Robin Database) and show in graphical representation. Its easy to understand and represent the values in graphs. Let's see pnp4nagios installation configuration Step by Step guide. Perf Data Flow to RRD Database is below pnp4nagios data flow There are three modes of data collection Using pnp4nagios Default mode Bulk Mode Bulk with NPCD mode Configure   Local Yum Repository   and Install rrdtool necessary (dependency)  # yum install rrdtool # yum install ruby xorg-x11-fonts-Type1 rrdtool verification # cd /tmp # wget https://sourceforge.net/projects/pnp4nagios/files/PNP-0.6/pnp4nagios-0.6.25.tar.gz # tar -xvf pnp4nagios-0.6.25 # cd pnp4nagios-0.6.25 # ./configure --with-rrdtool=/usr/bin/rrdtool pnp4nagios installation Note:   Do not download pnp-0.4-14 which does not work properly Download pnp4nagios # make all # make fullinstall Sure that No errors while installing  Edit the /usr/local/nagios/etc/nagios....

How to manually checkpoint Secondary Name Node

There are scenarios when checkpointing fails ( due to various reasons, for example network issues ). In those cases we can manually run checkpointing to allow NameNode and Secondary NameNode to sync in the metadata. Manual steps to checkpoint is as below: 1. On primary NameNode, we will try to save latest metadata to the fsimage as : hdfs dfsadmin -safemode enter   hdfs dfsadmin -saveNamespace   hdfs dfsadmin -safemode leave  2. we will now run manual checkpointing:  Stop secondary NN or HDFS service or Cluster . Now execute following command on the Secondary NameNode: mv /data/dfs/snn /data/dfs/snn.old hdfs secondarynamenode -checkpoint force Start the SNN  or HDFS service or Cluster   .