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

From Lsdf
Jump to navigationJump to search
(Created page with "==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)…")
 
mNo edit summary
 
(4 intermediate revisions by the same user not shown)
Line 21: Line 21:
* start/stop/status
* start/stop/status
service postgresql-9.3 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 trust
# 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==
==ODBC==
Line 43: Line 74:
export ODBCINI=/etc/odbc.ini
export ODBCINI=/etc/odbc.ini
* test:
* test:
[root@irods-2]# odbcinst -q -s
[root@irods-2]# odbcinst -q -s
[PostgreSQL]
[PostgreSQL]
[root@irods-2]# odbcinst -q -d
[root@irods-2]# odbcinst -q -d
[PostgreSQL]
[PostgreSQL]
[MySQL]
[MySQL]


==irods installation==
==irods installation==
Line 57: 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 do not let irods controll start and stop of postgres

==irods configuration==
==irods configuration==

Latest revision as of 10:58, 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                                     trust
# 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

irods configuration