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

From Lsdf
(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)…")
 
(postgresql)
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 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
   
 
==ODBC==
 
==ODBC==

Revision as of 10:31, 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

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

irods configuration