Difference between revisions of "hidden:Irods installation on irods-2"

From Lsdf
(postgresql)
Line 33: Line 33:
 
* /var/lib/pgsql/9.3/data/pg_hba.conf:
 
* /var/lib/pgsql/9.3/data/pg_hba.conf:
 
# TYPE DATABASE USER CIDR-ADDRESS METHOD
 
# TYPE DATABASE USER CIDR-ADDRESS METHOD
  +
 
 
# "local" is for Unix domain socket connections only
 
# "local" is for Unix domain socket connections only
 
local all all md5
 
local all all md5
Line 45: Line 45:
 
host all all 0.0.0.0/0 md5
 
host all all 0.0.0.0/0 md5
 
host all all ::/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==
 
==ODBC==
Line 81: Line 88:
 
cd iRODS
 
cd iRODS
 
less INSTALL.txt
 
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 not not let irods controll start and stop of postgres
  +
 
==irods configuration==
 
==irods configuration==

Revision as of 10:41, 28 October 2013

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        not not let irods controll start and stop of postgres 

irods configuration