Hi Gurus,
This is my 3rd attempt to create ODI repositories (master and work) on MySQL Server 5.6:
suprio@ubuntu15:~$ cat /etc/mysql/mysql.conf.d/mysqld.cnf | grep -v "^#"
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
bind-address = 127.0.0.1
key_buffer_size = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam-recover = BACKUP
query_cache_limit = 1M
query_cache_size = 16M
log_error = /var/log/mysql/error.log
expire_logs_days = 10
max_binlog_size = 100M
innodb_file_format=Barracuda
innodb_large_prefix=ON
log_bin_trust_function_creator=ON
suprio@ubuntu15:~$mysql -u root -p XXXXXXXXXXXX
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.25-0ubuntu0.15.04.1 (Ubuntu)
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> create database db_odim;
Query OK, 1 row affected (0.03 sec)
mysql> create database db_odiw;
Query OK, 1 row affected (0.00 sec)
mysql> create database db_svrdb;
Query OK, 1 row affected (0.00 sec)
mysql> create user 'ODIM'@'localhost' identified by 'odi';
Query OK, 0 rows affected (0.00 sec)
mysql> create user 'ODIW'@'localhost' identified by 'odi';
Query OK, 0 rows affected (0.00 sec)
mysql> create user 'ODIM'@'%' identified by 'odi';
Query OK, 0 rows affected (0.00 sec)
mysql> create user 'ODIW'@'%' identified by 'odi';
Query OK, 0 rows affected (0.00 sec)
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> grant all privileges on db_odim.* to ODIM;
Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on db_odim.* to ODIM@localhost;
Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on db_odiw.* to ODIW;
Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on db_odiw.* to ODIW@localhost;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| db_odim |
| db_odiw |
| db_svrdb |
| mysql |
| performance_schema |
+--------------------+
6 rows in set (0.02 sec)
MySQL variables:
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- ----------------------------------------
auto-rehash TRUE
auto-vertical-output FALSE
bind-address (No default value)
character-sets-dir (No default value)
column-type-info FALSE
comments FALSE
compress FALSE
debug-check FALSE
debug-info FALSE
database (No default value)
default-character-set auto
delimiter ;
enable-cleartext-plugin FALSE
vertical FALSE
force FALSE
named-commands FALSE
ignore-spaces FALSE
init-command (No default value)
local-infile FALSE
no-beep FALSE
host (No default value)
html FALSE
xml FALSE
line-numbers TRUE
unbuffered FALSE
column-names TRUE
sigint-ignore FALSE
port 0
prompt mysql>
quick FALSE
raw FALSE
reconnect TRUE
socket (No default value)
ssl FALSE
ssl-ca (No default value)
ssl-capath (No default value)
ssl-cert (No default value)
ssl-cipher (No default value)
ssl-key (No default value)
ssl-crl (No default value)
ssl-crlpath (No default value)
ssl-verify-server-cert FALSE
table FALSE
user (No default value)
safe-updates FALSE
i-am-a-dummy FALSE
connect-timeout 0
max-allowed-packet 16777216
net-buffer-length 16384
select-limit 1000
max-join-size 1000000
secure-auth TRUE
show-warnings FALSE
plugin-dir (No default value)
default-auth (No default value)
histignore (No default value)
binary-mode FALSE
connect-expired-password FALSE
but it stops right when it is importing the /home/suprio/Oracle/Middleware/Oracle_Home/odi/sdk/lib/scripts/xml/CONVDT_CONVDATATYPESLST.xml
It has been stuck while I am Posting this (for about 75 minutes now!!)
What am i missing?
suprio@ubuntu15:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 5.6.25-0ubuntu0.15.04.1 (Ubuntu)
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| db_odim |
| db_odiw |
| db_svrdb |
| mysql |
| performance_schema |
+--------------------+
6 rows in set (0.00 sec)
mysql> use db_odim;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+--------------------+
| Tables_in_db_odim |
+--------------------+
| SNP_ACTION |
| SNP_AGENT |
| SNP_AGENT_PROP |
| SNP_AGENT_PROP_LST |
| SNP_ALLOC_AGENT |
| SNP_CONNECT |
| SNP_CONNECT_PROP |
| SNP_CONTEXT |
| SNP_CONV_DT |
| SNP_DATA |
| SNP_DATASOURCE |
| SNP_DT |
| SNP_ENTITY |
| SNP_ENT_ID |
| SNP_ENT_PRINCIPAL |
| SNP_ESS |
| SNP_FF_VALUEM |
| SNP_FIELD |
| SNP_FIELD_LOOKUP |
| SNP_FLEX_FIELD |
| SNP_GRP_ACTION |
| SNP_HIST_VERSION |
| SNP_HOST |
| SNP_HOST_MOD |
| SNP_INDEX_TYPE |
| SNP_INST_OBJ |
| SNP_LAGENT |
| SNP_LANG |
| SNP_LANG_ELT |
| SNP_LANG_TECHNO |
| SNP_LB_AGENT |
| SNP_LE_TECHNO |
| SNP_LICENSE |
| SNP_LINE_ACTION |
| SNP_LINK |
| SNP_LOC_REP |
| SNP_LOOKUP |
| SNP_LOOKUP_VALUE |
| SNP_LSCHEMA |
| SNP_METHOD |
| SNP_MODULE |
| SNP_MORIG_TXT |
| SNP_MTXT |
| SNP_MTXT_PART |
| SNP_M_IMPORT_REP |
| SNP_OBJECT |
| SNP_OPEN_TOOL |
| SNP_PROFILE |
| SNP_PROF_METH |
| SNP_PSCHEMA |
| SNP_PSCHEMA_CONT |
| SNP_PWD_POLICY |
| SNP_PWD_RULE |
| SNP_REM_REP |
| SNP_ROLE_ENT_PRP |
| SNP_SOLUTION |
| SNP_SOL_ELT |
| SNP_SUB_LANG |
| SNP_TECHNO |
| SNP_USER |
| SNP_USER_METH |
| SNP_USER_OBJ_METH |
| SNP_USER_PREF |
| SNP_USER_PROF |
| SNP_USR_PREFERENCE |
| SNP_U_O_M_REP |
| SNP_VERSION |
+--------------------+
67 rows in set (0.00 sec)
mysql> select * from SNP_USER;
+---------+-----------------+------------+------+----------------+---------------------+------------------+---------------------+------------------+------------+-------------+---------------+--------------+--------------------+---------------+--------------------------------------+----------+
| I_WUSER | WUSER_NAME | WUSER_INIT | PASS | AUT_SUPERVISOR | FIRST_DATE | FIRST_USER | LAST_DATE | LAST_USER | IND_CHANGE | EXT_VERSION | EXPIRACY_DATE | I_TXT_DETAIL | USER_EXPIRACY_DATE | GUID_EXTERNAL | GLOBAL_ID | IND_ROLE |
+---------+-----------------+------------+------+----------------+---------------------+------------------+---------------------+------------------+------------+-------------+---------------+--------------+--------------------+---------------+--------------------------------------+----------+
| 2 | SUPERVISOR | SU | NULL | 1 | 2015-08-01 20:54:33 | SUNOPSIS_INSTALL | 2015-08-01 20:54:33 | SUNOPSIS_INSTALL | I | NULL | NULL | NULL | NULL | NULL | c34e89cf-9195-3bf5-b0c9-e744c3cf4fa5 | 0 |
| 4 | SUPERVISOR_ROLE | NULL | NULL | 1 | 2015-08-01 20:54:34 | SUNOPSIS_INSTALL | 2015-08-01 20:54:34 | SUNOPSIS_INSTALL | I | NULL | NULL | NULL | NULL | NULL | 6e18bd13-f7e3-4474-a962-09ba86b8b7a4 | 1 |
+---------+-----------------+------------+------+----------------+---------------------+------------------+---------------------+------------------+------------+-------------+---------------+--------------+--------------------+---------------+--------------------------------------+----------+
2 rows in set (0.00 sec)
mysql>
Please Help.
Thanks