git clone git://gtkpod.git.sourceforge.net/gitroot/gtkpod/gtkpod gtkpod cd gtkpod sh ./autogen.sh make sudo mkdir -p /usr/local/stow/gtkpod-git sudo make install prefix=/usr/local/stow/gtkpod-git sudo rm /usr/local/stow/gtkpod-git/share/icons/hicolor/icon-theme.cache (cd /usr/local/stow; sudo stow gtkpod-git)

Here I''ll go through the steps to install the Informix (http://www.informix.com/) RDBMS on Linux.

This guide is based on http://webxpert.wordpress.com/how-to-install-informix-dynamic-server-in-redhat-linux/.

Download Informix

On the informix website go to: Support & Downloads -> Downloads -> Trials and Demos

Under I click on Informix Dynamic Server.

Download either IBM Informix Dynamic Server Express Edition or IBM Informix Dynamic Server Developer Edition.

Create Informix User and Group

addgroup informix

  adduser --ingroup informix informix

Run GUI Installer

Extract the tarball, then as root (with a working X $DISPLAY) run:

./ids_install -gui -javahome none

Choose /home/informix as the installation path.

Do not create the sample database, it will likely fail anyway, we will do that later.

Configure ''informix'' User Environment

sudo su - informix

Edit the .bashrc and add the following at the bottom:

export INFORMIXDIR=/home/informix

  export INFORMIXSERVER=demo_on

  export ONCONFIG=onconfig

  export INFORMIXTERM=terminfo

Relogin.

Configure Informix

Copy etc/onconfig.std to etc/onconfig and make the following changes:

--- onconfig.std        2009-04-14 23:02:02.000000000
  -0400

  +++ onconfig    2010-03-26 04:00:41.000000000 -0400

  @@ -40,11 +40,11 @@

   ###################################################################

     


   ROOTNAME rootdbs

  -ROOTPATH $INFORMIXDIR/tmp/demo_on.rootdbs

  +ROOTPATH /home/informix/dbspaces/online_root

   ROOTOFFSET 0

   ROOTSIZE 200000

   MIRROR 0

  -MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirror

  +MIRRORPATH /home/informix/mirrors/root_mirror

   MIRROROFFSET 0

     


   ###################################################################

  @@ -123,7 +123,7 @@

   # CONSOLE      - The path of the IDS console message
  file

   ###################################################################

     


  -MSGPATH $INFORMIXDIR/tmp/online.log

  +MSGPATH /home/informix/logs/online.log

   CONSOLE $INFORMIXDIR/tmp/online.con

     


   ###################################################################

  @@ -198,7 +198,7 @@

   ###################################################################

     


   SERVERNUM 0

  -DBSERVERNAME 

  +DBSERVERNAME demo_on

   DBSERVERALIASES

     


   ###################################################################

  @@ -398,7 +398,7 @@

   #                positive integral multiple of LTAPEBLK.

   ###################################################################

     


  -LTAPEDEV /dev/tapedev

  +LTAPEDEV /dev/null

   LTAPEBLK 32

   LTAPESIZE 0

Copy etc/sqlhosts.std to etc/sqlhosts and add the following line:

demo_on         onipcshm        localhost           demo_on

Change localhost to the host name of the machine.

Make some directories and files:

cd ~

  mkdir dbspaces mirrors
  logs

  cd dbspaces

  touch online_root

  chmod 660 online_root

Create and start the instance:

oninit -iv

To optionally create a sample database, run dbaccessdemo7 or dbaccessdemo9.

Starting and Stopping

To start the instance, run:

oninit

To stop, run:

onmode -ky

I''ll provide an init script once I write one.

Create a Database

The sample database is not created with logging, this makes it not very useful for use with e.g. DBD::Informix.

To create a database, first log in as informix and run the dbaccess command.

Go to Database -> Create, type in the name you want; then go to Log -> Buffered_log; then Exit -> Create-new-database .

Configure your User Environment

In your .bashrc or whatever, put:

export INFORMIXDIR=/home/informix

  export INFORMIXSERVER=demo_on

  export INFORMIXTERM=terminfo

  export DBD_INFORMIX_DATABASE=stores_demo

  export DELIMIDENT=y


  export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/home/informix/lib:/home/informix/lib/esql

  export PATH=$PATH:/home/informix/bin

You can now use the dbaccess command as a shell to run SQL queries. Unfortunately, it''s a menu-driven program.

Build DBD::Informix for Perl

With the environment set as above, just install DBD::Informix as normally from CPAN. Or just perl Makefile.PL; make; sudo make install. The DBD_INFORMIX_DATABASE environment variable should be set to a database that exists, you have stores_demo if you ran dbaccessdemo7 or 9.

Verify that it works:

perl -MDBI -le 'my $dbh = DBI->connect("dbi:Informix:stores_demo",
  "", ""); print for $dbh->selectrow_array("select today
  from sysmaster:sysdual")'

Replace stores_demo with the name of the logged database you created earlier.

Setting up TCP Connection Support

This information taken from http://database.itags.org/informix/57440/.

Edit etc/onconfig.

Find the DBSERVERALIASES line and change it to:

DBSERVERALIASES hlaghdb_tcp

Edit etc/sqlhosts and add the line:

hlaghdb_tcp    onsoctcp    localhost    informix_tcp

replace localhost with your hostname.

As root, edit /etc/services and add:

informix_tcp   33333/tcp

or whatever port you want to use.

Restart informix:

onmode -ky

  oninit

Your DBI DSN becomes:

dbi:Informix:hlaghdb@hlaghdb_tcp

SQL Shell

You can use the dbaccess program to run SQL statements against your DBs, but it''s some sort of very cumbersome, ancient terminal GUI.

I use the DBI::Shell CPAN module: http://search.cpan.org/perldoc?DBI::Shell.

Unfortunately DBI::Shell does not have history support, so I use rlwrap to add one.

Putting it all together:

alias informix="rlwrap -a -N -t dumb -i -f ~/.informix_dbish_history -H ~/.informix_dbish_history
  -s 30000 dbish dbi:Informix:hlaghdb@hlaghdb_tcp"

Statements end with ; like in SQL*Plus, use /quit to quit. Readline uses emacs keybindings by default, but you can change this in your ~/.inputrc.

#!/bin/sh # # Startup script for DB2 Personal Edition # # description: DB2 RDBMS System # processname: dataserver DB2_USER=db2inst1 # Find the name of the script NAME=`basename $0` # For SELinux we need to use 'runuser' not 'su' if [ -x /sbin/runuser ] then SU=runuser else SU=su fi # Find home DB2_HOME=`$SU $DB2_USER -c 'echo \$HOME'` start() { DB2_START=$"Starting ${NAME} service: " $SU $DB2_USER -c '. $DB2_HOME/sqllib/db2profile; \ $DB2_HOME/sqllib/adm/db2start > /dev/null' ret=$? if [ $ret -eq 0 ] then echo "$DB2_START Success." else echo "$DB2_START Failed!" exit 1 fi echo } stop() { echo -n $"Stopping ${NAME} service: " $SU $DB2_USER -c '. $DB2_HOME/sqllib/db2profile; \ $DB2_HOME/sqllib/adm/db2stop > /dev/null' ret=$? if [ $ret -eq 0 ] then echo "Success." else echo "Failed!" exit 1 fi echo } restart() { stop start } case "$1" in start) start ;; stop) stop ;; restart) restart ;; *) echo $"Usage: $0 {start|stop|restart}" exit 1 esac exit 0

#!/bin/sh # # Startup script for Sybase SQL Anywhere # # description: Sybase SQL Anywhere RDBMS System # processname: dbsrv11 ASA_USER=sybase-asa ASA_BIN=/opt/sqlanywhere11/bin32/ DB_FILE=hlaghdb.db SRV_NAME=ASA # Find the name of the script NAME=`basename $0` # For SELinux we need to use 'runuser' not 'su' if [ -x /sbin/runuser ] then SU=runuser else SU=su fi # Find home ASA_HOME=`$SU $ASA_USER -c 'echo \$HOME'` start() { ASA_START=$"Starting ${NAME} service: " $SU $ASA_USER -c ". $ASA_BIN/sa_config.sh; $ASA_BIN/dbsrv11 -ud -n $SRV_NAME $ASA_HOME/$DB_FILE" ret=$? if [ $ret -eq 0 ] then echo "$ASA_START Success." else echo "$ASA_START Failed!" exit 1 fi echo } stop() { echo -n $"Stopping ${NAME} service: " pkill dbsrv11 ret=$? if [ $ret -eq 0 ] then echo "Success." else echo "Failed!" exit 1 fi echo } restart() { stop start } case "$1" in start) start ;; stop) stop ;; restart) restart ;; *) echo $"Usage: $0 {start|stop|restart}" exit 1 esac exit 0