· 4 years ago · May 17, 2021, 01:56 PM
1tmarc@L9N0CX09E38439H:/usr/local/ranger-admin$ sudo ./setup.sh
22021-05-17 16:36:48,192 --------- Running Ranger PolicyManager Web Application Install Script ---------
32021-05-17 16:36:48,194 [I] uname=Linux
42021-05-17 16:36:48,196 [I] hostname=L9N0CX09E38439H
52021-05-17 16:36:48,200 [I] DB_FLAVOR=MYSQL
62021-05-17 16:36:48,202 [I] Audit source=solr
72021-05-17 16:36:48,204 [I] Checking distribution name..
82021-05-17 16:36:48,247 [I] Found distribution : Ubuntu
92021-05-17 16:36:48,248 [I] check if command /usr/lib/jvm/java-8-openjdk-amd64/bin/java exists
102021-05-17 16:36:48,249 [I] '/usr/lib/jvm/java-8-openjdk-amd64/bin/java' command found
11(standard_in) 1: syntax error
12(standard_in) 1: syntax error
13./setup.sh: line 348: [: -eq: unary operator expected
142021-05-17 16:36:48,291 [I] Checking MYSQL CONNECTOR FILE : /usr/share/java/mysql-connector-java-8.0.25.jar
152021-05-17 16:36:48,292 [I] MYSQL CONNECTOR FILE : /usr/share/java/mysql-connector-java-8.0.25.jar file found
162021-05-17 16:36:48,293 [I] Setting up UNIX user : ranger and group: ranger
172021-05-17 16:36:48,298 [I] the ranger user already exists and belongs to group ranger
182021-05-17 16:36:48,299 [I] Setting up UNIX user : ranger and group: ranger DONE
192021-05-17 16:36:48,300 [I] Setting up installation files and directory
202021-05-17 16:36:48,303 [WARN] core-site.xml file not found in provided hadoop_conf path. Creating blank core-site.xml
212021-05-17 16:36:48,305 [I] Setting up init.d
222021-05-17 16:36:48,308 [I] Creating script S88ranger-admin/K90ranger-admin in /etc/rc2.d directory ....
232021-05-17 16:36:48,311 [I] Creating script S88ranger-admin/K90ranger-admin in /etc/rc3.d directory ....
242021-05-17 16:36:48,319 [I] Setting up installation files and directory DONE
252021-05-17 16:36:48,335 [I] /usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/ews/webapp folder found
262021-05-17 16:36:48,336 [I] db/mysql/optimized/current/ranger_core_db_mysql.sql file found
272021-05-17 16:36:48,338 [I] Copying MYSQL Connector to /usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/ews/webapp/WEB-INF/lib
282021-05-17 16:36:48,342 [I] Copying MYSQL Connector to /usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/ews/webapp/WEB-INF/lib DONE
292021-05-17 16:36:48,343 [I] check if command python2 exists
302021-05-17 16:36:48,344 [I] 'python2' command found
312021-05-17 16:36:48,519 [I] DB FLAVOR :MYSQL
322021-05-17 16:36:48,519 [I] --------- Verifying Ranger DB connection ---------
332021-05-17 16:36:48,519 [I] Checking connection..
342021-05-17 16:36:48,519 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select 1;"
35Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
36SQLException : SQL state: 42000 java.sql.SQLSyntaxErrorException: Unknown database 'ranger' ErrorCode: 1049
372021-05-17 16:36:48,926 [E] Can't establish connection!! Exiting..
382021-05-17 16:36:48,926 [I] Please run DB setup first or contact Administrator..
392021-05-17 16:36:48,940 [E] 'setup_mode' not found in /usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/install.properties file while getting....!!
402021-05-17 16:36:48,942 [I] Setup mode is not set. Running DBA steps..
412021-05-17 16:36:48,986 [I] Running DBA setup script. QuiteMode:True
422021-05-17 16:36:48,986 [I] Using Java:/usr/lib/jvm/java-8-openjdk-amd64/bin/java
432021-05-17 16:36:48,986 [I] DB FLAVOR:MYSQL
442021-05-17 16:36:48,986 [I] DB Host:localhost
452021-05-17 16:36:48,986 [I] ---------- Verifying DB root password ----------
462021-05-17 16:36:48,986 [I] DBA root user password validated
472021-05-17 16:36:48,987 [I] ---------- Verifying Ranger Admin db user password ----------
482021-05-17 16:36:48,987 [I] admin user password validated
492021-05-17 16:36:48,987 [I] ---------- Creating Ranger Admin db user ----------
502021-05-17 16:36:48,987 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "SELECT version();"
51Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
522021-05-17 16:36:49,389 [I] Verifying user rangeradmin for Host %
532021-05-17 16:36:49,389 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "select user from mysql.user where user='rangeradmin' and host='%';"
54Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
552021-05-17 16:36:49,812 [I] MySQL user rangeradmin already exists for host %
562021-05-17 16:36:49,812 [I] Verifying user rangeradmin for Host localhost
572021-05-17 16:36:49,813 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "select user from mysql.user where user='rangeradmin' and host='localhost';"
58Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
592021-05-17 16:36:50,273 [I] MySQL user rangeradmin already exists for host localhost
602021-05-17 16:36:50,273 [I] ---------- Creating Ranger Admin database ----------
612021-05-17 16:36:50,273 [I] Verifying database ranger
622021-05-17 16:36:50,273 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "show databases like 'ranger';"
63Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
642021-05-17 16:36:50,696 [I] Database does not exist, Creating database ranger
652021-05-17 16:36:50,697 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "create database ranger;"
66Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
672021-05-17 16:36:51,112 [I] Verifying database ranger
682021-05-17 16:36:51,113 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "show databases like 'ranger';"
69Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
702021-05-17 16:36:51,527 [I] Creating database ranger succeeded
712021-05-17 16:36:51,527 [I] ---------- Granting permission to Ranger Admin db user ----------
722021-05-17 16:36:51,527 [I] ---------- Granting privileges TO user 'rangeradmin'@'%' on db 'ranger'----------
732021-05-17 16:36:51,527 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "grant all privileges on ranger.* to 'rangeradmin'@'%' with grant option;"
74Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
752021-05-17 16:36:51,945 [I] ---------- FLUSH PRIVILEGES ----------
762021-05-17 16:36:51,945 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "FLUSH PRIVILEGES;"
77Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
782021-05-17 16:36:52,356 [I] Privileges granted to 'rangeradmin' on 'ranger'
792021-05-17 16:36:52,357 [I] ---------- Granting privileges TO user 'rangeradmin'@'localhost' on db 'ranger'----------
802021-05-17 16:36:52,357 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "grant all privileges on ranger.* to 'rangeradmin'@'localhost' with grant option;"
81Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
822021-05-17 16:36:52,784 [I] ---------- FLUSH PRIVILEGES ----------
832021-05-17 16:36:52,784 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "FLUSH PRIVILEGES;"
84Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
852021-05-17 16:36:53,222 [I] Privileges granted to 'rangeradmin' on 'ranger'
862021-05-17 16:36:53,222 [I] ---------- Ranger Policy Manager DB and User Creation Process Completed.. ----------
872021-05-17 16:36:53,232 [I] /usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/ews/webapp/WEB-INF/classes/conf/ranger-admin-site.xml file found
882021-05-17 16:36:53,235 [I] /usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/ews/webapp/WEB-INF/classes/conf/ranger-admin-default-site.xml file found
89Starting configuration for Ranger DB credentials:
90Using Java:/usr/lib/jvm/java-8-openjdk-amd64/bin/java
91Alias ranger.db.password created successfully!
92Starting configuration for solr credentials:
93Using Java:/usr/lib/jvm/java-8-openjdk-amd64/bin/java
94Alias ranger.solr.password created successfully!
95Using Java:/usr/lib/jvm/java-8-openjdk-amd64/bin/java
96Alias unixAuthKeyStoreAlias created successfully!
97Using Java:/usr/lib/jvm/java-8-openjdk-amd64/bin/java
98Alias unixAuthTrustStoreAlias created successfully!
992021-05-17 16:36:55,999 [I] Starting setup based on user authentication method=NONE
100/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/ews/webapp
1012021-05-17 16:36:56,011 [I] Finished setup based on user authentication method=NONE
102ln -sf /usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/ews/webapp/WEB-INF/classes/conf /usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/conf
1032021-05-17 16:36:56,204 [I] DB FLAVOR :MYSQL
1042021-05-17 16:36:56,204 [I] --------- Verifying Ranger DB connection ---------
1052021-05-17 16:36:56,204 [I] Checking connection..
1062021-05-17 16:36:56,204 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select 1;"
107Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1082021-05-17 16:36:56,624 [I] Checking connection passed.
1092021-05-17 16:36:56,625 [I] --------- Verifying version history table ---------
1102021-05-17 16:36:56,625 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "show tables like 'x_db_version_h';"
111Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1122021-05-17 16:36:57,054 [I] Table x_db_version_h does not exist in database ranger
1132021-05-17 16:36:57,055 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "show tables like 'x_db_version_h';"
114Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1152021-05-17 16:36:57,480 [I] Table x_db_version_h does not exist in database ranger
1162021-05-17 16:36:57,480 [I] Importing x_db_version_h table schema to database ranger from file: create_dbversion_catalog.sql
1172021-05-17 16:36:57,480 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -input /usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/db/mysql/create_dbversion_catalog.sql
118Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1192021-05-17 16:36:57,996 [I] create_dbversion_catalog.sql file imported successfully
1202021-05-17 16:36:57,997 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "show tables like 'x_db_version_h';"
121Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1222021-05-17 16:36:58,458 [I] Table x_db_version_h already exists in database 'ranger'
1232021-05-17 16:36:58,458 [I] --------- Importing Ranger Core DB Schema ---------
1242021-05-17 16:36:58,458 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'CORE_DB_SCHEMA' and active = 'Y';"
125Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1262021-05-17 16:36:58,882 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'CORE_DB_SCHEMA' and active = 'N';"
127Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1282021-05-17 16:36:59,325 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "insert into x_db_version_h (version, inst_at, inst_by, updated_at, updated_by,active) values ('CORE_DB_SCHEMA', current_timestamp, 'Ranger 2.1.0.7.1.6.0-SNAPSHOT', current_timestamp, 'L9N0CX09E38439H','N') ;"
129Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1302021-05-17 16:36:59,758 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "show tables like 'x_portal_user';"
131Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1322021-05-17 16:37:00,193 [I] Table x_portal_user does not exist in database ranger
1332021-05-17 16:37:00,194 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "show tables like 'x_policy_ref_group';"
134Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1352021-05-17 16:37:00,624 [I] Table x_policy_ref_group does not exist in database ranger
1362021-05-17 16:37:00,625 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'DB_PATCHES' and active = 'Y';"
137Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1382021-05-17 16:37:01,069 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'JAVA_PATCHES' and active = 'Y';"
139Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1402021-05-17 16:37:01,501 [I] Importing DB schema to database ranger from file: ranger_core_db_mysql.sql
1412021-05-17 16:37:01,502 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -input /usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql
142Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1432021-05-17 16:37:09,304 [I] ranger_core_db_mysql.sql file imported successfully
1442021-05-17 16:37:09,304 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "update x_db_version_h set inst_by='Ranger 2.1.0.7.1.6.0-SNAPSHOT' where active='Y' and updated_by='localhost';"
145Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1462021-05-17 16:37:09,748 [I] Patches status entries updated from base ranger version to current installed ranger version:Ranger 2.1.0.7.1.6.0-SNAPSHOT
1472021-05-17 16:37:09,748 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "show tables like 'x_portal_user';"
148Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1492021-05-17 16:37:10,186 [I] Table x_portal_user already exists in database 'ranger'
1502021-05-17 16:37:10,187 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "show tables like 'x_policy_ref_group';"
151Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1522021-05-17 16:37:10,641 [I] Table x_policy_ref_group already exists in database 'ranger'
1532021-05-17 16:37:10,641 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'DB_PATCHES' and active = 'Y';"
154Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1552021-05-17 16:37:11,066 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'JAVA_PATCHES' and active = 'Y';"
156Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1572021-05-17 16:37:11,482 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "update x_db_version_h set active='Y' where version='CORE_DB_SCHEMA' and active='N' and updated_by='L9N0CX09E38439H';"
158Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1592021-05-17 16:37:11,897 [I] CORE_DB_SCHEMA import status has been updated
1602021-05-17 16:37:11,897 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'DB_PATCHES' and inst_by = 'Ranger 2.1.0.7.1.6.0-SNAPSHOT' and active = 'Y';"
161Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1622021-05-17 16:37:12,331 [I] DB_PATCHES have already been applied
1632021-05-17 16:37:12,581 [I] DB FLAVOR :MYSQL
1642021-05-17 16:37:12,582 [I] --------- Verifying Ranger DB connection ---------
1652021-05-17 16:37:12,582 [I] Checking connection..
1662021-05-17 16:37:12,582 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select 1;"
167Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1682021-05-17 16:37:13,005 [I] Checking connection passed.
1692021-05-17 16:37:13,005 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'JAVA_PATCHES' and inst_by = 'Ranger 2.1.0.7.1.6.0-SNAPSHOT' and active = 'Y';"
170Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1712021-05-17 16:37:13,440 [I] JAVA_PATCHES have already been applied
1722021-05-17 16:37:13,675 [I] DB FLAVOR :MYSQL
1732021-05-17 16:37:13,675 [I] --------- Verifying Ranger DB connection ---------
1742021-05-17 16:37:13,675 [I] Checking connection..
1752021-05-17 16:37:13,675 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select 1;"
176Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1772021-05-17 16:37:14,095 [I] Checking connection passed.
1782021-05-17 16:37:14,095 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'DEFAULT_ALL_ADMIN_UPDATE' and active = 'Y';"
179Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1802021-05-17 16:37:14,552 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'DEFAULT_ALL_ADMIN_UPDATE' and active = 'N';"
181Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1822021-05-17 16:37:14,982 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "insert into x_db_version_h (version, inst_at, inst_by, updated_at, updated_by,active) values ('DEFAULT_ALL_ADMIN_UPDATE', current_timestamp, 'Ranger 2.1.0.7.1.6.0-SNAPSHOT', current_timestamp, 'L9N0CX09E38439H','N') ;"
183Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1842021-05-17 16:37:15,422 [I] Ranger all admins default password change request is in process..
185Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1862021-05-17 16:37:26,784 [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java -cp /usr/share/java/mysql-connector-java-8.0.25.jar:/usr/local/ranger-2.1.0.7.1.6.0-SNAPSHOT-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "update x_db_version_h set active='Y' where version='DEFAULT_ALL_ADMIN_UPDATE' and active='N' and updated_by='L9N0CX09E38439H';"
187Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
1882021-05-17 16:37:27,232 [I] Ranger all admins default password change request processed successfully..
189Installation of Ranger PolicyManager Web Application is completed.
190tmarc@L9N0CX09E38439H:/usr/local/ranger-admin$ sudo ./set_globals.sh
191usermod: no changes
192[2021/05/17 16:37:42]: [I] Soft linking /etc/ranger/admin/conf to ews/webapp/WEB-INF/classes/conf
193tmarc@L9N0CX09E38439H:/usr/local/ranger-admin$ cd /usr/bin
194tmarc@L9N0CX09E38439H:/usr/bin$ sudo ln -sf /usr/local/ranger-admin/ews/start-ranger-admin.sh ranger-admin-start
195tmarc@L9N0CX09E38439H:/usr/bin$ sudo ln -sf /usr/local/ranger-admin/ews/stop-ranger-admin.sh ranger-admin-stop
196tmarc@L9N0CX09E38439H:/usr/bin$ sudo service ranger-admin start
197Warning: The unit file, source configuration file or drop-ins of ranger-admin.service changed on disk. Run 'systemctl daemon-reload' to reload units.
198tmarc@L9N0CX09E38439H:/usr/bin$ systemctl daemon-reload
199tmarc@L9N0CX09E38439H:/usr/bin$ sudo service ranger-admin start
200tmarc@L9N0CX09E38439H:/usr/bin$
201