hidden:Irods installation on irods-2

OS

• SL 6.4
• various packages:

yum install ntp bind-utils man strace nmap emacs gcc-c++ make

• add user:

useradd -u 995 irods 
[root@irods-2 ~]# id irods
uid=995(irods) gid=995(irods) groups=995(irods)

postgresql

• repository

wget http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-sl93-9.3-1.noarch.rpm
rpm -ihv pgdg-sl93-9.3-1.noarch.rpm

• installation

yum install postgresql93-server ppostgresql93-libs ostgresql93 

• directory

/var/lib/pgsql/9.3/data

• first start

service postgresql-9.3 initdb

• start/stop/status

service postgresql-9.3 start/stop/status

• database user access

su - postgres
/usr/pgsql-9.3/bin/psql
=>CREATE USER irods WITH PASSWORD 'mypassword'; (see password in /data/irods/iRODS/config/irods.config)
=>ALTER USER irods CREATEDB;
=>\q

• useful symlinks

cd /var/lib/pgsql/9.3
ln -s /usr/pgsql-9.3/bin
ln -s /usr/pgsql-9.3/lib

• /var/lib/pgsql/9.3/data/pg_hba.conf:

# TYPE  DATABASE        USER            CIDR-ADDRESS            METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     md5
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5

# iRODS connections:
#     Force use of md5 scrambling for all connections.
host    all         all         0.0.0.0/0             md5
host    all         all         ::/0                  md5

• /var/lib/pgsql/9.3/data/postgresql.conf

...
listen_addresses = '*'
...

• restart postgres after modification of pg_hba.conf and postgresql.conf
• check that postgresql listens on all ip's (netstat -nlp)

ODBC

yum install unixODBC unixODBC-devel

• config files:

/etc/odbcinst.ini
/etc/odbc.ini

• replace /etc/odbc.ini by (taken from irods-1 and adopted):

[PostgreSQL]
Driver=/usr/lib64/psqlodbc.so
Debug=0
CommLog=0
Servername=irods-2
ReadOnly=no
Ksqo=0
Port=5432
Database=ICAT

• crosscheck that all libs in /etc/odbcinst.ini exist
• point to config files (not sure whether this is needed):

# cat /etc/profile.d/odbc.sh
export ODBCSYSINI=/etc
export ODBCINI=/etc/odbc.ini

• test:

[root@irods-2]# odbcinst -q -s [PostgreSQL] [root@irods-2]# odbcinst -q -d [PostgreSQL] [MySQL]

irods installation

• get irods3.2.tgz from somewhere (e.g. irods-1)

mkdir /data/irods
cd /data/irods
mv irods3.2.tgz .
tar xfvz irods3.2.tgz
cd iRODS
less INSTALL.txt

• run irodssetup

./irodssetup

• use the following settings

   --------------------------------------------------------
   Build iRODS data server + iCAT metadata catalog
       directory     '/data/irods/iRODS'
       port          '1247'
       start svrPort '20000'
       end svrPort   '20199'
       account       'rods'
       password      '***'
       zone          'tempZone'
       db name       'ICAT'
       scramble key  '321'
       resource name 'demoResc'
       resource dir  '/data/irods/iRODS/Vault'

   Use existing Postgres
       host          'localhost'
       port          '5432'
       directory     '/var/lib/pgsql/9.3'
       account       'irods'
       password      '***'
       pg version    
       odbc version  
       control        do not let irods controll start and stop of postgres