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